Banner Image

All Services

Programming & Development

SQL DBA with 15 years experience

$20/hr Starting at $25

Over the past 20 years in IT, I have worked as a Application Developer, Production Support Analyst, Database Administrator and Infrastructure Database Engineer Skills Microsoft SQL Server 2000 thru 2017 • Installation and Configuration of MS SQL Server from versions 2000 thru 2017 • Hands on experience on installation of SQL Server on Veritas & Windows clusters • Supporting 1600+ SQL Server instances with 37000+ databases • Experience in handling and preparing for DR activities and Moving of servers to different data centers • Experience in migration of databases • Configuring database mirroring \ HADR in various environments • Setting up of Transaction Log Shipping between servers. • Configuring Transactional Replication & Merge replication on large systems with upto 1000+ Subscriptions • Experience in Implementation of TDE and column level data encryption \ decryption • Experience in Implementation and configuration of CT and CDC • Experience in Implementation of data masking in SQL 2016 • Deployment of SSIS Packages, SSRS reports and Olap cubes • Generation of Databases, Server configuration and disk space reports on periodic basis • Automation of various alerts in powershell to enable early detection of critical Issues • Managing SQL Server Security and Database Permissions. • Backup & Restoration of system and user databases to disk \ tape. • Experience in performance analysis tools like PSSDiag, SQLDiag, PAL, SQL Nexus and SQL Internals viewer for identifying performance bottlenecks on query and server level. • Applying \ fixing \ Planning of Service Packs and Security Patches as and when released

About

$20/hr Ongoing

Download Resume

Over the past 20 years in IT, I have worked as a Application Developer, Production Support Analyst, Database Administrator and Infrastructure Database Engineer Skills Microsoft SQL Server 2000 thru 2017 • Installation and Configuration of MS SQL Server from versions 2000 thru 2017 • Hands on experience on installation of SQL Server on Veritas & Windows clusters • Supporting 1600+ SQL Server instances with 37000+ databases • Experience in handling and preparing for DR activities and Moving of servers to different data centers • Experience in migration of databases • Configuring database mirroring \ HADR in various environments • Setting up of Transaction Log Shipping between servers. • Configuring Transactional Replication & Merge replication on large systems with upto 1000+ Subscriptions • Experience in Implementation of TDE and column level data encryption \ decryption • Experience in Implementation and configuration of CT and CDC • Experience in Implementation of data masking in SQL 2016 • Deployment of SSIS Packages, SSRS reports and Olap cubes • Generation of Databases, Server configuration and disk space reports on periodic basis • Automation of various alerts in powershell to enable early detection of critical Issues • Managing SQL Server Security and Database Permissions. • Backup & Restoration of system and user databases to disk \ tape. • Experience in performance analysis tools like PSSDiag, SQLDiag, PAL, SQL Nexus and SQL Internals viewer for identifying performance bottlenecks on query and server level. • Applying \ fixing \ Planning of Service Packs and Security Patches as and when released

Skills & Expertise

AnalyticsMaskingMicrosoftMicrosoft WindowsPlanningPowerShellReportsSecurity ConsultingSQLSQL Server Reporting Services (SSRS)

0 Reviews

This Freelancer has not received any feedback.