We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

New York, NY


  • Sr. SQL Server DBA with over 8+ years of experience in SQL Server administration, implementation and support
  • Hands - on experience in supporting SQL Servers 2008/2008R 2/2012/2014/2016/2017 and SQL server 2019.
  • Offers solid track record based on professionalism, thoroughness, and dedication. Able to work both independently and as a team player.
  • Excellent communication, presentation and interpersonal skills.
  • Strong experience in Upgrade/Migration of MSSQL Server 2000/ /2008R2 and from MSSQL Server 2008\2008r2 to MSSQL Server 2012\2014\2016\SQL 2017\SQL 2019.
  • Experience in Performance Tuning, Backup and Recovery, Query Optimization and Security.
  • Experience in Using Performance Monitor/Profiler to resolve Dead Locks and Long /Slow running Queries.
  • Strong hands on T-SQL, stored procedures, tables, views, functions, triggers and indexes.
  • Experience in creating and maintaining ETL routines as well as assisting with reporting needs.
  • Strong hands on DTS packages and converting them to SSIS packages
  • Experience with developing and maintaining complex SSIS, SSRS and SSAS Packages
  • Experience in FDA Validation procedures required for Pharmaceutical Industry.
  • Work with Financial, pharmaceutical and communication Industries.
  • Acted as a production and development DBA.
  • Experience in AlwaysOn, Big Data support and SSDT
  • Responsible for securing SQL Server, user management, assigning permissions and roles.
  • Acted as a system administrator of various Windows operating systems.
  • Hands on experience and noledge on high availability SQL Server solutions, Replication
  • Experience in creating standard documentation for technical documentations.
  • Excellent experience in working independently as well as in team-oriented environments.
  • Involved in problem solving and conflict resolutions.
  • Experience in supporting and maintaining huge databases and troubleshooting their problems.
  • Excellent analytical, communication and interpersonal skills.
  • Experience in Database Mirroring, Hardware/Software Clustering and SAN technology.


Languages: SQL CLR,T-SQL, PL/SQL, HTML, VB, .NET Framework, C#, C++, and Java

ETL Tools: Microsoft SSIS,DSS, Remedy MDM.

Data Model: Darwin, Erwin, and SSAS.

Reporting Tools: Tableau, SSRS, QlikView, Cognos BI, and Business Objects XIBackup Software SQLBackup, Redgate,, FTP, EMC, and TSM, SQLSafe, Litespeed.

RDBMS & Tools: SQL Server 2000/2005/2008/2008 r2/2012/2014/ and 2016, MS Access 2003/2007/2010/2013/2016 , SQL Loader,and Export/ImportOperating System Windows NT/ 2000/2003/2008/2008 r2/Windows server 2012 & Windows Server 2012R2, and UNIX,Linux.

Third Party Tools: DB Artisan, RedGate, Spotlight, Quest's Toad, Idera, litespeed

Database Query Tools: MS SQL Server QA, SQL Profiler, ETL, SSMS and Enterprise Manager.


Confidential, New York, NY

Sr. SQL Server DBA


  • Experienced as a Production DBA support provided 24 X 7 for SQL Server
  • Installed and configured SQL 2014, 2016 and 2017 in Production and non-production Environment.
  • Experienced with creating SSIS packages for data import and export in SQL Server.
  • Experienced with creating ETL package that extracts data from multiple data sources.
  • Experienced in configured and maintained Always-On, Replications and Log-shipping.
  • Experienced in launching DB instances wizard by selecting DB size and flavors.
  • Migrated SQL Server to SQL Azure by scripting schemas and moved data to SSIS.
  • Implemented SQL Server 2014 Database Mirroring and Database Encryption.
  • Involved in upgrading from SQL Server 2012 to SQL Server 2014 servers and SQL 2016.
  • Installed and configured the MS SQL Fail over clustering for production servers.
  • Experienced with setting up the backup strategy for production, test and development.
  • Installed and Configured Foglight and Precise Software to monitor all servers.
  • Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
  • Experienced in AWS Cloud creating EC2 instance and migrated SQL Databases.
  • Experienced in backup and restore production databases to test and development servers.
  • Installed Quest Software and experienced with LiteSpeed backup and Restore.
  • Configured the log shipping in production environment to create the backup server.
  • Experienced with SQL Disaster recovery processes and documented the processes.
  • Created the maintenance plan for database optimization and integrity checks.
  • Experienced in migrating RDS Instance database to SQL Server by using SQLAzureMW.
  • Experienced with improving SQL Server performance using windows performance monitor.
  • Experienced with improving the database performance using execution plan, index tuning wizards and profilers.
  • Configuring High Availability of database servers using Replication, Database Mirroring and Always-On.
  • Worked with the SQL Developers to change the stored procedures codes to improve the performance. Develop, debug, analyze execution and performance of SSAS, SSIS packages
  • Experienced with monitoring all SQL Servers by Foglight and Precise.
  • Experienced in securing the SQL Servers and assign the permissions to SQL Server users.
  • Experienced in change management processes to implement the changes to production environments.
  • Created the check lists to install SQL Server, apply service packs, securityhot fix and upgrade processes.

Confidential, Houston, TX

SQL server DBA


  • Installed and configured MS SQL Server 2012, SQL 2014 and SQL server 2016
  • Worked on complex SQL environments that includes 400+ databases.
  • Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.
  • Responsible for a large scale of database migration from SQL server to SQL Azure
  • Maintain both Azure SQL Database and SQL server on Azure Virtual Machines(VMs)
  • Responsible for a large scale of database migration from SQL server 2008\2008R2 to SQL server 2012, SQL server 2014 and SQL server 2016.
  • Responsible for Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
  • Performed DBA operations and support work, backup, restores, security, Always On, DBA activities, HADR for databases, latest versions of SQL server, troubleshooting and fixing issues, SQL Failover cluster, Windows Clusters, database growth, daily server health checks .
  • Used PowerShell script for SQL Server Maintenance activities
  • Involved in database and log backups and restoration, planning backup strategies, and scheduling.
  • Involved in developing & Deploying SSAS,SSIS packages & SSRS Reports.
  • Implemented Database mirroring for High Availability.
  • Always-On Availability Groups (AAG) and High Availability /DR Setup and Configuration.
  • Backing up master & system databases and restoring them when necessary.
  • Rebuilding the Indexes at regular intervals for better performance.
  • Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
  • Responsible for Installing, configuring and maintaining SQL Fail over clustering
  • Involved in creating Logical & Physical Database Design using data model tool Erwin.
  • Responsible for configuring and maintaining Transactional, Snapshot and Merge replication in production environments.
  • Involve in Change Management/Incident Management Process and using Remedy tool notify requests and open new requests and update all records in work history.
  • Using third party tool Red Gate, ensuring all the databases are backing up on the regular basis and tan restoring dis database on requests.
  • Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
  • Monitoring and Tuning SQL Server - Managing Messages, System Monitor, Setting Trace Flags, Setting up Job Notifications and Capacity Planning and Sizing.
  • Using third party tool Idera, monitor all the servers and their jobs in a single Management Console.

Confidential, Eden Prairie, MN

SQL Server DBA


  • Supporting database servers of production, development, test & training environments
  • Administering, Installing, configuring SQL 2005\2008R2\2012\2014 database servers on Clusters
  • Worked with Windows and SQL server PowerShell using SMO, sqlcmd and sqlps.
  • Created standard operation procedures (SOP) for initial database shell creations for specific customer package builds.
  • Experience with SSIS and SSRS troubleshooting, performance tuning.
  • Migrating production, development servers between windows servers
  • Worked on Data Compression for halping Capacity planning projects
  • Securing SQL Server via Managing Logins, users and object level permissions. Configuring and Optimizing SQL Server Agent, Managing all maintenance Jobs and Deploying.
  • Monitoring and administering Replication, database Mirroring & Log Shipping
  • Applying Service packs and Hotfixes on all production/dev/test/training Sql instances
  • Administering and managing Terabyte databases on production and test environments
  • Implemented SQL Server 2012\2014 Always-On with four replicas
  • Performing and tracking regular production databases & transaction log backups
  • Migrating/upgrading production Sql instances to different windows 2003\2008\2012 servers
  • Performing maintenance activities & monitoring database space usages
  • Automating and scheduling SQL jobs on all production servers
  • Monitoring all servers, agents, Critical Jobs completion & tracking results
  • Working with windows admins, Storage group, data centre engineers & network administrators
  • Working, planning and performing DR (Disaster Recovery) tests with SunGard
  • Performing database restores for multiple development groups and business teams.
  • Working with installation, configuration and creation of SSRS.

Confidential, Zeeland, MI

SQL Server DBA


  • Responsible for Installing and configuring SQL Server 2005 and 2008, 2008R2 and SQL server 2012
  • Worked with SQL DBA team and SQL Developers to optimize the SQL queries and stored procedures.
  • Installed and configured SQL server 2005 Reporting Services (SSRS), created user roles, managed security built reports and deployed them to production. Worked with configured SSRS to monitor all jobs on daily basis, fixed the failed jobs and re-ran them.
  • Provided 24 X 7 dedicated supports to hundred and eight Production, development and clustered servers.
  • Implementing Database Mirroring using high safety with automatic failover for Disaster Recovery.
  • Developed the metrics and trending processes for SQL database sizing and growth.
  • Daily monitoring of two-node active-passive SQL cluster in a host environment.
  • Applied service packs and security fixes for all SQL Servers, and provided database administration support.
  • Involved in upgrading from SQL Server 2005 to SQL Server 2008\2012
  • Performed the database backups for production, test and development environments.
  • Created the backup and restore strategy for the all three environments.
  • Worked with the database optimization, Performance tuning and index tuning for optimization of queries.

Hire Now