We provide IT Staff Augmentation Services!

Sql Server Dba Resume

0/5 (Submit Your Rating)

Santa Fe, NM


  • Microsoft Certified Professional in Administering SQL Server 2012 with 5+ years of experience as a SQL Server DBA in managing production and non - production environment.
  • Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database issues.
  • Extensive experience in managing MS SQL Server on Windows 2000/2003/2008/2012 Servers.
  • Used DMVs and DMFs for monitoring and troubleshooting performance issues.
  • Expert level knowledge in Server Consolidation and Data Center migrations.
  • Implemented Database Mirroring and Log Shipping configuration to provide HA/DR solution.
  • Managed SQL Servers running on VMWare ESX hosts.
  • Define and implementETLdevelopment standards and procedures for data warehouse environment.
  • Adept in designing and implementing Backup and Recovery Strategies.
  • Developing reports onSSRSon SQL Server.
  • Implemented different types of Replication models like Transactional and Snapshot.
  • Proficient in upgrading (In-place Upgrades) and migrating databases from MS SQL Server and SQL Server /2012/2014.
  • Create Database(s) on SQL AZURE.
  • Designed, tested and debugged external and DB2 native stored procedures
  • Deep KnowledgeSQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS).
  • Designed DR plans while satisfying SLA requirements and conducted DR tests.
  • Knowledge in Third party tools like TOAD, Remedy and Foglight.
  • Worked in production support role to provide 24/7 on-call support.
  • Proficient in migrating databases from SQL Server to Oracle.
  • Hands on Experience in installing and configuring Active/Passive Cluster.
  • Worked with tools like SQL Profiler, Windows Perfmon and Performance counters for Monitoring and Tuning MS SQL Server Performance.
  • Expertise in SQL server technologies for Clustering, non-clustering, High Availability and Disaster Recovery.
  • Sound understanding of change control and helpdesk ticketing processes.
  • Applied Service packs and hotfixes during off hours.
  • Skilled in using LiteSpeed and Redgate to backup and restore the SQL databases.
  • Conversant with all phases of Software Development Life Cycle (SDLC).
  • Flexible and enthusiastic team player with excellent communication and leadership skills.


Languages: T-SQL, Visual Basic, Java, C#.NET, VB Script, Java script

RDBMS: MS SQL Server 2014/2012/2008/2005/2000 and Oracle 11g

Web Servers: IIS, Weblogic

Operating Systems: Windows 2012/20, Windows NT

Backup and Restore Tools: Idera SQLSafe, Redgate, Litespeed

Monitoring Tools: Spotlight for SQL Server

Others: Microsoft Office Suite, Microsoft Visio, Trello, Tableau,Microsoft Project


SQL Server DBA

Confidential, Santa Fe, NM


  • Responsible for Installing SQL Server on new servers (2008/2012/2014 ).
  • Upgrading existing 2005/2008 Production Server to SQL Server 2012/2014 Version.
  • Moving several of the existing SQL 2005/2008 Production databases, jobs, packages, linked server and logins to new versions of SQL server.
  • Installed and maintained MS SQL Server 2000 on Windows 2003 Server. Worked on SQL Server 2000 failover clustering which is built on top of a Windows 2003 server cluster.
  • Upgrading SSIS Packages to SQL Server 2012 version.
  • Designed Schemas using Microsoft Visio.
  • Handling day to day support tickets and development issues.
  • Set up linked servers between SQL servers and oracle data sources.
  • Supported application programmers and users in their daily interactions with DB2.
  • Responsible for On-call support and support escalation from offshore.
  • Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
  • Working with Offshore team on pending issues and coordinating migration project activities to meet the project deadlines.
  • Monitor database systems performance, capacity and availability.
  • Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
  • Solid experience onhigh availabilitySQL Server solutions, includingReplication Models(Snapshot/Transactional) andSQL Server clustering(Active-Active, Active-Passive).
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
  • Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
  • Configuring, maintaining and troubleshooting Windows Server 2008 R2, SCCM 2007/2012 .
  • Performing regular SCCM Health Checks of Site Server.
  • For data mining applications, worked with SQL Server Analysis Services.
  • Responsible for database refresh and coordinating with QA Team.
  • Developed Documentation using Microsoft Office.
  • Used the tool BMC Remedy user by the BMC software in resolving the incidents in the development servers and the production servers
  • Developed and deployed SSIS packages and SSRS Reports.
  • Extracted data from internal data warehouse system to SSRS.
  • Proactive monitoring of SQL server known issues related to performance.
  • Writing Custom scripts to refresh tables and monitoring jobs.
  • Troubleshooting performance issues in production and non-production servers.
  • Providing support for database mirroring, always on and log shipping implementation.

Environment: MS SQL Server 2014/2012/2008 R2/2005, RedGate, T-SQL, Windows Server 2012/2008/2003 , SSIS, SSRS, Microsoft Office.

SQL Server DBA

Confidential, Wilmington, DE


  • Installed and configured SQL Server R2 in production and development.
  • Upgraded SQL Server 2000 to SQL server 2005/2008 in 32 and 64-bit environment.
  • Actively involved in installing and managing multiple 2 node failover cluster set up in active/passive environments as a High Availability mechanism.
  • Successfully implemented database mirroring with high availability mode for critical systems.
  • Implemented log shipping from primary server to standby server to support DR solution.
  • Troubleshoot database performance issues and tune database objects. Set up traces and profiler to troubleshoot performance issues.
  • Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
  • Recovered databases in the event of a disaster by developing and maintaining relational structures including backup/recovery and log shipping procedures.
  • Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest FogLight.
  • Reviewed andoptimized SQL queries, CDC,stored procedures, functions, Indexes, views and triggers.
  • Experience with third party tools like FogLight and Veritas Netbackup.
  • Configured 43 Production servers using FogLight monitoring tool.
  • Created ad-hoc reports.
  • Created and managed clustering environment such as active/passive clustering.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
  • Configured transactional Replication from multiple subscribers for reporting purposes.
  • Involved in performance tuning, optimization of stored procedures and queries.
  • Proficient in working with change management and change control procedure.
  • Created and maintained various databases for Production, Development and Testing using SQL Server 2005.
  • Planning the location of data, index, and Transaction log files on the disk.
  • Solved issues related to server performance and disk space.
  • Involved in the design and development of the SSAS cubes.
  • Supported Development team in deploying and testing the application.
  • Experienced in contacting Microsoft and other vendors for product and technical support.
  • Provided 24*7 support to SQL application developers in implementing the applications on production server.
  • Conducted root cause analysis of application availability and narrowed down to issues related to coding practices, database bottlenecks, or network latency.

Environment: Microsoft Windows Server bit, Microsoft SQL Server 2000/2005/2008 and Microsoft Visual Studio, Performance Monitor, Profiler and DTA.

SQL Server DBA



  • Installed and configured SQL Server 2005/2008.
  • Upgraded SQL 2000 and 2005 Server to SQL 2008 (In place and Side-by-Side) server for high volume processing databases.
  • Worked closely with application owners, development teams and other teams for planning and implementation of the migration.
  • Designed and Implemented Disaster Recovery Procedures.
  • Implemented High Performance Database mirroring on SQL 2005 database servers.
  • Automated database refresh from production to test using custom scripts.
  • Created custom jobs to back up the databases, maintenance tasks using custom scripts.
  • Estimated disk storage requirements for database software, database files.
  • Created databases, Logins, Roles and granted appropriate permissions.
  • Configured Database Mail and created profiles for business applications to send out notifications.
  • Developed and deployed SSIS packages and SSRS Reports.
  • Installed and Configured 2- node High availability SQL Active/Passive clusters.
  • Worked with 3rd party vendors to resolve database issues.
  • Configured Log Shipping for high availability on SQL Server 2008
  • Responsible for applying service packs and hotfixes
  • Refreshed databases from production to test, stage and development environments.
  • Provided on-call support.

Environment: MS SQL Server 2008 R2/2005/2000, Idera SQLSafe, T-SQL, Windows Server 2008/2003, TSM

We'd love your feedback!