We provide IT Staff Augmentation Services!

Sql Dba Lead Resume

0/5 (Submit Your Rating)

Seattle, WA


  • 10+ years of experience as SQL Server DBA in Production, Development, Test, Staging & Data Warehouse Environments (OLTP and OLAP).
  • Expertise in working on SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 versions.
  • Designed, Implemented and monitored SQL server Always ON as HA & DR solutions for various environments.
  • Expertise in configuring and Maintaining the SQL Always ON as Hybrid AO & other AO types includes Option 1, Option2, Option3 & Option4.
  • Migrated the SQL Servers from On premise to Confidential cloud (IaaS) environment for various business critical application.
  • Expertise in configuring the WSFC clusters, Quorum &FSW on multi subnet environments.
  • Deep hands on in Listener recreation, Connectivity issues, sorting the SPN creation &mapping issues.
  • Extensively worked on AG group properties settings, AG replica synchronization issues, AG failover issues & adhoc issues.
  • Designed, implemented and monitored the log shipping, Mirroring & replication on various environments.
  • Expertise in configuring the Transaction& Merge replication, Sorting the issue very quickly includes latency, PK violation, Job failures & Adhoc issues.
  • Analyzed and Quickly fixed the SQL Mirroring end point failures, Synchronization &failover issues.
  • Strong T - SQL Developer skills including stored procedures, Indexed views, Adhoc queries, User Defined Functions, Triggers, and Distributed Queries for various versions.
  • Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon, DB Engine Tuning Advisor, Extended events, Auditing.
  • Performed the in Place up gradation & side by side upgradation (Migration) for various versions includes SQL Server 2012/2008R 2/2008/2005/2000 .
  • Working on applying the
  • Good hands on in writing the Power Confidential scripts.
  • Expert in working on Contained Databases, Change data capture (CDC), online index & Transparent Data Encryption (TDE)
  • Planning the backup strategies, Maintenance plans using Native & Third-party tools (Lite Speed, Red Gate SQL Backup and Splunk).
  • Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
  • Experience in configuring and administering Integration, Reporting & Analysis services.
  • Experience in migrating SSIS packages to higher versions and fixing the issues.
  • Experience in BI Development and Deployment of SSIS packages from Flat files, Excel, Oracle, and DB2.
  • Experience in providing Logging, Error handling by using Event Handler & Custom Logging for SSIS Packages.
  • Expertise in SSIS package performance tuning by using the Row Transformations, Block and partial blocking Transformations.
  • Extensive experience in controlling the User Privileges, Monitoring the security &audit issues.
  • Experience in tasks automation includes monitoring Disk Space, Server Ping Status, and Database health checks using customized SQL scripts, batch file and Power Confidential .
  • Experience in solving Database issues with Index fragmentation, Integrity checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
  • Experience in analyzing SQL wait types, execution plans for troubleshooting performance issues.
  • Provided extended support for business critical applications like SharePoint, Project Financial, Data hub and SCOM.
  • Strong Communication &Management skills including best team lead role.
  • 24/7 on Call Support to cover the production/other critical issues, weekend deployments.


Databases: SQL SERVER 2014/2012/2008 R 2/2008/2005/2000 , MS-Access, DB2, Oracle Database 10g and 11g.

Operating System: Windows Server 2003 / Server 2008 / Server 2008R2/ Server 2012, Server 2014, Unix, Linux.

Programming Languages: TSQL, PL/SQL, Power Confidential, C, C#, VBScript, HTML, XML.

SQL Tools: SQL Server Management Studio, SQL Navigator, Confidential Visual Studio 2008/2010/2012 , SQL Server Enterprise Manager, BIDS, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerfMon, SQL Configuration Manager.


Confidential, Seattle, WA



  • Designed, implemented and maintained the SQL Always ON for the SQL 2014/2012 versions.
  • Implemented the Hybrid AO & other AO types includes option1, option2, option3 & option4.
  • Performed on premise to Confidential azure (IaaS) migration for the business critical applications.
  • Implemented the Hybrid AO and helped the business teams with appropriate migration planning.
  • Configured the multi subnet WSFC Cluster, Quorum & FSW as part of all AO configurations.
  • Applied the monthly patches and service packs to achieve the security & performance metrics.
  • Implemented the SQL Server Mirroring, Snapshot/Transactional replication on versions 2012/2008R2/200/2005 for various application based on the business requirements.
  • Quick analysis and fixed the AO listener connectivity issues, listener recreation/swapping& IP mappings/changes.
  • Performed the in Place upgrade and side by side upgrade (migration) for the various servers includes the versions 2014/2012/2008 R2/2008 by resolving any intermittent issues.
  • Configured the alert systems for all HA & DR implementations which helps in monitor the status, changes and performance.
  • Installed and configured SQL Server 2012/2008R2/2008Clusters by preparing the shared drives in WSFC cluster.
  • Designed and Implemented the Hybrid SQL Always On for various servers and performed the post checks, fail over & fail back testing.
  • Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.
  • Actively worked on performance tuning by analyzing the Windows, SQL, Memory &Query optimization by using the T-SQL debugging.
  • Actively worked on capacity planning, submitted the best plans to customer for successful implementation.
  • Resolved the Memory/IO/CPU/Temp DB bottlenecks to achieve performance by making use of Windows
  • Extensively worked on Profiler, perfmon, SQL traces, DMV’s, extended events and Auditing.
  • Design and deploy the SSIS packages intended for various functionalities includes importing data from Excel, Oracle, DB2 & MS Access.
  • Managed the SQL Server and database securable by providing the appropriate access to objects.
  • Developed Power Confidential scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
  • Created maintenance plans for database consistency and integrity checks, resolved issues related to database consistency and integrity.
  • Designed and Deployed SSRS reports, Scheduled reports to run on daily basis to send e-mails.
  • Migrated 2008 SSIS packages to SQL 2012 project deployment model and configured SSIS Catalog, environments.
  • Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used SQL Profiler for optimizing stored procedures.
  • Active focus on all critical tickets which are created in Service Now (SNOW)/ITSM to resolve them with in time and providing the RCA for the critical issues.
  • Responsible for the implementation, documentation, and day-to-day support and reports to management.
  • Managing the team in 24/7 support with rotational shifts and delivering the targets with in timeline by mentoring, task assignment and helping the team.

Confidential, TX



  • Installed Sql Server 2012 and configured Always On with Primary and secondary Replicas, Read only databases, listener and with Application Intent.
  • Installed SQL Server 2012/2008R2 on windows server 2012and migrated SSIS packages.
  • Migrated databases from SQL Server 2005/2008/2008 R2 to Sql Server 2012.
  • Implemented SQL mirroring, Clustering, Transactional replication and regular checks that include alerts, jobs failures, latency, and performance and fixing the adhoc issues.
  • Monitored and modified Performance using execution plans with query hints and Index tuning.
  • Experience with analyzing query plans, writing stored procedures, try-catch blocks, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking, Checking the threshold values and baselines.
  • Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Create triggers to keep track of changes to the fields of tables when changes are made.
  • Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
  • Involved in Table designing whenever required.
  • Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
  • Used SSRS to create reports that draw content from a variety of data sources
  • Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
  • Incremental loading of dimensions, facts, error handling in SSIS.
  • Created SSIS/DTS packages for Finance application that would transfer data among servers to perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Technical Analysis, Code Review, Implementation, 24 x 7 production support.




  • Design, develop and maintain database administration tasks for administering SQL Server 2005/2008/2008 R2
  • Installation and configuration of SQL Server 2000/2005/2008/2208 R2.
  • Designed and developed DTS packages.
  • Migrated DTS packages from SQL 2000 to SQL 2005.
  • Worked on SQL server up gradation from SQL Server 2000 to SQL Server 2005/2008.
  • Worked on ETL migration with required transformations like Derived Column, Data Conversions, Sort and Union.
  • Designed, Configured and automated SSIS packages as per Business (LOB) requirement.
  • Create and maintain various databases for development, testing, staging and production environments using SQL Server 2005/2008.
  • Monitoring and Troubleshooting SQL 2008 Cluster.
  • Hands on experience on SQL Server Log shipping, Replication and Mirroring.
  • Written Stored Procedures, Functions, and Views as per DBA requirement.
  • Troubleshooting query performance.
  • Manage users including creation/alteration, grant of system/db roles and permissions on various database objects and object level permission.
  • Creating & scheduling the maintenance plans.
  • Developing the successful Backup strategies based on Recovery models.
  • Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
  • Synchronizing Production and UAT environments.
  • Hands on experience in IIS 6.0/7.0/7.5
  • Installed and worked on F-Secure SSH Server, generating keys and exchanging with other teams to establish the connectivity for file transfer on daily basis.
  • Shrinking the Data files and log files if more free space is available.
  • Monitoring Database server, performing health check, SQL Jobs on day to day basis
  • Creating and Scheduled SQL jobs as per the business requirements.
  • Maintaining and Monitoring Production, Pre-Production and Development database server environment.
  • Perform Import/Export tasks using SSIS from different data sources like Flat file, Excel and DB2.


Sr Project Engineer


  • Planned and Installed SQL Server 2000, 2005,2008 on the Production, test and Development Servers.
  • Configured the Log shipping and mirroring on SQL Server 2005/2008.
  • Developing the successful Backup strategies based on Recovery models.
  • Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and
  • Restore the databases and transaction log on production/development servers as per requirement.
  • Involved in creating Logins, Tables, Clustered, Non-Clustered Indexes, Views, Functions and Stored Procedures.
  • Designed and created the DTS/SSIS Package, DTS Import/Export for transferring data.
  • Involved in implementation of replications like Transactional.
  • Implementing Database maintenance plan for Database consistence & Integrity.
  • Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
  • Monitoring SQL server performance using profiler to find the performance and deadlocks.
  • Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
  • Maintaining and Monitoring Production, Pre-Production and Development database server environment.
  • Having good knowledge on creation and scheduling of T-SQL jobs to run daily.


Technical Consultant


  • Installed and configured the SQL server 2000/2005 on various servers.
  • Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.
  • DBA activities like creating Logins, users &managing the permissions.
  • Created the tables, views and T-SQL queries.
  • Configured the SQL Server Log shipping, Mirroring for the databases.
  • Performing the database backups, restores, data refresh based on the schedules.
  • Calculate disk space and table space requirements, involved in capacity planning, estimating and sizing of tables.
  • Involved in designing the SSIS packages to export data of flat file sources.
  • Disaster Recovery Plans, Testing and analyzing and continuous update of documentation.
  • Developed the basic stored procedures, Database testing, maintaining the data sets.

We'd love your feedback!