We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

0/5 (Submit Your Rating)

Atlanta, GA


  • 8 years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2014 and SQL Server 2012/2008/ 2005/ 2000.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Worked on SQL Server 2012 migration from SQL Server 2008 and 2005
  • Extensively worked on Data and Backup compression in SQL Server 2012.
  • Worked with SQL Server 2012 new MERGE statement
  • Good Knowledge at SQL Server 2012 new features like Policy Based Management, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)
  • Knowledge on SQL Server Management studio 2012 new and enhanced features like object search, Object Explorer Details, activity monitor, Multi Server Query and T - SQL Debugger
  • Implemented the new SQL Server 2008 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, ETL, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
  • Worked on 32 bit and 64 bit SQL Server and MSCS Configurations.
  • Administering SQL Server High Availability.
  • Data modeling Experience like Physical data modeling and logical by using ERWIN.
  • SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages and SSAS with OLAP.
  • Worked on Replication and Log shipping for SQL Server High Availability
  • Worked on MongoDB,MongoDB is document database that povides high performance,high availability and high scalability
  • Extensively worked on Active-Active and Active-Passive Clustering
  • Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
  • Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
  • Experience with 2012 Always On High Availability groups.
  • Having hands-on experience in Database Mirroring.
  • Worked on configuring SQL Server with minimum privileged access.
  • Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
  • Hands on experience working with MongoDB (Installed and configured) on Linux servers.
  • Extensively implemented the change management processes by using Team foundation server (TFS), Visual source safe (VSS) and Clear case.
  • Expertise in T-SQL writing stored procedures, triggers and functions.
  • Used Filtered Indexes for improving query performance, lower storage and maintenance cost.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
  • Done Password Changes on cluster and Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
  • Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management.
  • Experience with business requirements analysis, entity relationship planning and reporting structures.
  • Troubleshoot performance problems, fine-tuning of databases and index Analysis.
  • Created Linked Servers between SQL Server 2005 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
  • Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.


Databases: MS SQL server 2014/2012/2008 R 2/2008/2005/2000 , MongoDB

ETL Tools: SQL Server Integration Services (SSIS), INFORMATICA, SQL Server DTS

Other Tools: Microsoft Visual Source Safe, IDERA, Red gate, Fog light, Sentry

Data Modeling Tools: Erwin, Microsoft Visio 2007

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, SSRS Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers


Confidential, Atlanta GA

Sr. SQL Server DBA


  • Managed Production, Development, QA and UAT environments
  • Worked extensively on Virtual and VMware Environments.
  • Worked on ACTIVE/ACTIVE and ACTIVE/PASSIVE clusters
  • Involved in Performance Tuning on Production, QA and Staging servers of the current project.
  • Managed Production environment for High Availability in Active/Active and Active/Passive mode
  • Worked on setting up and managing Snapshot and Transactional Replication
  • Involved in Monitoring Performance of different production servers.
  • Implemented Database mirroring and Log shipping for disaster recovery.
  • Maintained various databases for Production and Testing using SQL Server 2014/2012 R2.
  • Planning the location of data, index and Transaction log files on the disk.
  • Performance tuning and optimization of procedures and queries. extensive use of SQL Server DMV's for Performance Tuning
  • Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks
  • Implemented High Availability with AlwaysOn Availability Groups.
  • Created the backup and restore strategy for production and development environment.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.
  • Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.
  • Migrated MS SQL Server 2008 to MS SQL Server 2012
  • Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa
  • Installed and configured MongoDB on Linux servers.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2012.
  • Automated mongoDB backups using mongodump utility.
  • MongoDB supports search by field, range queries, regular expression searches.
  • Documented all the steps and procedures for future s.
  • Interacted with concern application team in fixing the problems when ever needed.
  • Created performance baseline reports using RML tool and documented for future use.
  • Involved in setting up database mirroring for production server
  • Configured replication methods like snapshot, transactional and merge replications.
  • Monitoring and scheduled jobs on production and staging environment.
  • Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
  • Used the Execution Plan to improve the optimization of the T-SQL code.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Resolving performance related issues to Blocking, Deadlocks and long running queries
  • Provided 24 x 7 Production support for the database and application issues.

Environment: SQL Server 2014/2012/2008 R2, VMware, Virtualization, SSAS, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, TFS, Crystal Reports, MongoDB, Windows 2008 R2/2003/2000, ERWIN, Lite Speed Backup

Confidential, PA

SQL Server DBA


  • Perform business analysis, technical analysis, systems design, application software programming.
  • Prepared DFD's & Entity Relationship(ER) diagrams.
  • Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
  • Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
  • Extensively worked on Dynamic Management Views in SQL Server 2005.
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
  • Managed the migration of SQL Server 2005 databases to SQL Server 2008.
  • Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Involved in implementation and maintenance of disaster recovery solutions such as replication and log shipping.
  • Using MongoDB high availability of database will be maintained.
  • Indexes are designed using MongoDB or Mysql or Oracle.
  • Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
  • Prepared the project management and technical documentation.
  • Implemented AlwaysOn functionality on a Clustered environment
  • Implemented AlwaysOn with Sync and Async configuration.
  • Unit Testing the SSIS packages with respect to its flow and performance issues.
  • Solving the Bugs Reflected by the Testing team.
  • Rebuilding the indexes at regular intervals for better performance.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Configured transactional and snapshot replication and managed publications, articles.
  • Rebuilding the indexes at regular intervals for better performance.
  • Extensively worked on DBCC commands and Dynamic Management Objects.
  • Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Complete documentation about the database. Recovering the databases from backup in disasters.
  • Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings for better server management.
  • Monitoring the servers using Idera third party software.
  • Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2012/2008, Oracle 11g/10g, .Net Framework 3.5/4.0, C#.Net, Asp.Net2.0, JavaScript, SSIS, SSRS, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access, SPSS, Erwin, Visio Professional, TFS

Confidential, Jersey City, NJ

SQL Server DBA with SSIS Data Warehouse


  • Responsible for Query optimization and Performance tuning.
  • Rebuilding of indexes to improve data retrieval performance
  • Managed Microsoft Clustered SQL Server 2005 and 2008 environments.
  • Involved in Migration from SQL 2005 to SQL 2008
  • Managing server logins, database users and permissions.
  • Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
  • Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
  • Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
  • Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
  • Used the SQL server integration services (SSIS) as a part top transfer logins from SQL server and to move data from one server to another server.
  • Configuration and Administration of IIS 6.0, Windows 2003 server.
  • Created the Database Objects like Tables, Views, Functions, Stored Procedures and Triggers.
  • Managing security tasks like granting and revoking permissions

Environment: Windows Server 2000/2003, VMware, SQL Server 2008/2005, DTS, T-SQL, SSRS, SSIS, SQL lite speed, Erwin, Visio Professional, TFS

Confidential, Baltimore, MD

SQL Server DBA


  • Database Administrator, Database Programming.
  • Responsible for Logical & Physical Database Design.
  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
  • Creation of New NT Logins and granting privileges to users/Groups and objects.
  • Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.
  • Backup and recovery of Master, MSDB and Application databases.
  • Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current.
  • Implemented log shipping and performed changing roles when production data base goes down.
  • Worked extensively on DTS Package designs for Import/Export from various Data Source Flat file, Excel, MS Access to MS SQL Server and schedule the jobs in SQL Server.
  • Provide 24x7 dedicated support to all Production, QA & Development MS SQL Server Environments.
  • Related issues /performance related issues with Minimal Downtime & Maximum Reliability.
  • Responsible for deployment from development to test, UAT and production environments.
  • Review / test / apply all database changes to all environments including QA, Development and Production Servers. Monitor SQL Error Logs /Schedule.

Environment: MSSQLServer 2008/2005,.NET Framework,DTS, SSIS,SSRS,SVN,C# .NET, SSL, IIS 6.0/7.0,Windows 2008/2003, Erwin, Excel




  • Database Administrator, Database Programming.
  • Converting DTS packages into SQL Server 2005 Integration Services.
  • Migrating SQL Server 2000 data bases into SQL Server 2005.
  • To set up SQL Server configuration settings.
  • Backups and Restoration of data/database using a Third Party Tool (SQL Lite Speed).
  • Recovering the databases from backup in disasters
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Rebuilding the indexes at regular intervals for better performance
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies
  • Involved in trouble shooting and fine-tuning of databases for its performance.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Rebuilding the indexes at regular intervals for better performance
  • Managing the San backups.
  • Deploying new code base release to UAT and Production Environments.
  • Perform SQL Server service pack and Windows Service pack upgrades.
  • Working with customers on Application rollouts and server migrations.
  • Extensively worked on Enterprise Manager for managing the database
  • Troubleshoot performance problems and fine-tuning of databases.
  • Involved in Index Analysis and Performance Tuning.
  • Worked with different upstream team for downloading ETL MART data.
  • To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, Windows 2003/2000 Server, SQL Lite Speed 4.5, Visio, Enterprise Manager, SQL Query Analyzer, SQL Profiler.


SQL Server DBA


  • Database Administration for Development, Test and Production servers with MS SQL Server 2000/2005 on Windows 2000/2003NT 4.0.
  • Created backups for databases.
  • Involved in Performance tuning.
  • Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system with ERWIN.
  • Gathered requirements from business users.
  • Wrote user requirement documents based on functional specification.
  • Designed physical data models.
  • Created functions, views and triggers.
  • Developed source to target specifications.
  • Created DTS package and schedule the jobs for batch processing.
  • Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.

Environment: Windows Server 2003, MS SQL Server 2000/2005, Erwin, DTS, Stored Procedure, Views, Triggers.

We'd love your feedback!