We provide IT Staff Augmentation Services!

Sql Server Dba Resume

0/5 (Submit Your Rating)



  • Around 6 years IT experience in SQL SERVER DATABASE ADMINISTARSTION and its related activities.
  • Hands on experience with High Availability & Disaster Recovery Solutions - log shipping, Mirroring Always on and Replication (Snapshot & Transactional).
  • Mastered in Online Transaction Processing (OLTP)&Online Analytical Processing (OLAP).
  • Developed many SQL queries depending on the requirements in the project.
  • Developed Dimensional Modeling, ER Modeling, Star Schema, Snowflake Schema.
  • Experience with Clustering (Active-Passive and Active-Active) and database migration.
  • Good understanding and experience in Object Oriented Methodologies.
  • Good experience with powershell scripting.
  • Developed and implemented complex business rules in tsql using functions, triggers and stored procedures.
  • Expertise in complete ETL cycle including data analysis, database design, data mapping conversion and data load.
  • Experience in production support of data loading and making the data available in data marts.
  • Experience in performance tuning, maintaining & schedulingSQL Server Jobs, Query Optimization and Indexing of database using SQL profiler and Query Analyzer.
  • Familiar with SQL Server third party tools(Litespeed, Idera, Spotlight, Redgate) used for backup, restore and performance tuning of databases.
  • Administered, maintained policies and procedures for ensuring the security and Integrity of the company database.
  • Experience in different phases of Software Development Life Cycle (SDLC) including Planning, Design, Development and Testing during the development of software applications and in Agile/ Scrum Methodology.
  • Expertise in generating reports usingSQL Server Reporting Services and Crystal Reports.
  • Worked closely with project management, applications development teams to resolve business hampering database problems.
  • Adaptable new technologies at greater pace for fulfilling the project goals and objectives.
  • Good team member with strong interpersonal and communication skills combined with self-motivation and the ability to think outside the box.
  • Quality of learn ad-infinitum provides the space to think outside the box.


Framework: .NET Framework, MVC

Languages: C, C++, C#, T-SQL, Oracle, LINQ

Scripting Languages: Java Script, J-Query

Web Technologies: Azure, HTML, HTML5, DHTML, CSS, Web Services (SOAP, RESTFUL)

Operating Systems: Windows 7,8,10, Windows Server 2003/2008, LINUX, UNIX

Databases: MS SQL Server 2008R2, 2012, 2014, 2016

Protocols: TCP/IP, HTTP, FTP

Tools: SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), Visual Studio, TOAD, SQL Developer.

Reporting Tools: Crystal Reports, SQL Server Reporting Services (SSRS)



Confidential, GA


  • Installation and Maintenance of SQL Server 2012, 2014, 2016 instances on production and test environments along with configuring the drives according to standards and policies.
  • Implementing Disaster Recovery solutions like Transactional Replication and log shipping for high availability.
  • Setting up proactive database performance monitoring and tuning.
  • Maintained system security, users and their roles, assigned privileges as well as concentrates on capacity planning of database.
  • Developed DTS packages to extract, transform and load into the Campaign database from OLTP database.
  • Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
  • Created and configured an OLTP replication database for disaster recovery purpose.
  • Worked with developers to tune the SQL queries using SQL Profiler.
  • Worked with Star Schema, Cubes and Analytical services.
  • Capacity planning of databases according to client requirements.
  • Provided on call support for the server maintenance and incident issues.
  • Worked on very large and complex database and in a highly transactional environment.
  • Back up and restored master, system databases depending on the requirements.
  • Maintained field office database backups through SQL mail scripts through SMTP.
  • Maintained documentation throughout whenever and wherever required.
  • Designed and implemented comprehensive Backup plan and disaster recovery with and without compression.

SQL Server DBA

Confidential, PA


  • Server maintenance of SQL Server 2012, 2008R2 updating with latest service packs and security patches.
  • Administrating MS SQL Server by creating user logins with appropriate roles,dropping and locking the logins, monitoring the user accounts, creating roles, granting privileges to users by adding them to roles.
  • Implementation of log shipping for production server as part of the disaster recovery.
  • Responsible for General Server maintenance and Performance tuning.
  • Experienced in resolving deadlock and blocking issues for concurrent users.
  • Worked with DTS packages to load the data into Data warehouse.
  • Data Migration from legacy systems using DTS-Import and Export wizard.
  • Developed Database Backup Scripts and automated this process.
  • Deploy and scheduled SSIS package and reports as per user requests. Migrated SSIS package fromSQL Server from Dev to higher environments.
  • Using PowerShell scripts on regular basis for getting instance specific details.
  • Partially participated in system study and analysis of software applications.
  • Experienced in production support and applications development.
  • Coordinating implementation of performance tuning actions with application development teams.
  • Analyzing and implementing requested modifications to existing database structures for change requests.
  • Maintained Transactional Replication on production servers.
  • Worked on SQL Server tools like database tuning advisor, profiler and activity monitor for performance analysis.
  • Managing scheduled tasks for the servers and also automating all the maintenance activities and data flow tasks.




  • Administrating MS SQL Server 2008 R2 by creating user logins with appropriate roles,dropping and locking the logins, monitoring the user accounts, creation of roles, granting privileges to users and roles.
  • Responsible for General Server maintenance and Performance tuning.
  • Analyzing and implementing requested modifications to existing database structures for change requests.
  • Backing up master & system databases for restoring them when necessary.
  • Implementation of SQL in writing stored procedures, Triggers, Views, Sql functions and locking issues.
  • Experienced in production support and applications development.
  • Troubleshooting the problems involved with the existing stored procedures by debugging.
  • Managing scheduled tasks for the servers and also automating all the maintenance activities and data flow tasks.
  • Tutor for undergraduate students with main focus on Engineering development Skills.
  • Responsible for a role in providing guidance for Coding, Implementing and test validation of both software and hardware of an Embedded System Controller.
  • Providing an overview of Basic C, C++ and object oriented programming which is the backbone of software industry.
  • Under the guidance of professor trained many students with the introduction to MATLAB commands and codes using different Simulink.
  • Provided technical support and managed Active Directory users, printers, rights and permissions for the 100 + computers available in the computer facility.
  • Part of the team responsible for maintenance and installation of Software in various operating systems and equipment available.

We'd love your feedback!