We provide IT Staff Augmentation Services!

Sql Server Dba Resume

2.00/5 (Submit Your Rating)

Cleveland, OH


  • 8+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012/2008/2008 R2 and SQL Server 2005/ 2000.
  • Experience in installing MS SQL SERVER 2000/2005/2008/2008 R2/2012updating with the hot fix and service packs.
  • Documented and good knowledge on SQL SERVER 2014 New Enhanced Features for migration to SQL server 2014.
  • Implemented Side by Side Migration of MS SQL SERVER 2000/ /2008R2/2012.
  • Experience in implementing DIASTER RECOVERY AND HIGH AVAILABLITY concepts like Native Log Shipping, Custom Log Shipping, Mirroring and Replication (Snap Shot and Transactional).
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
  • Experience in working and configuring with Windows server 2003/2008/R2/2012.
  • Experience in analyzing and resolving Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
  • Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Mirroring, Database Snapshot, DDL triggers, try - cache blocks, Online indexing, DMV’s, DMF’s, SQLCMD and dedicated admin connection.
  • Experience on Always On and T- SQL Enhancements of 2012 features.
  • Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, perfmon, activity monitor, Event viewer for performance analysis.
  • Experience in administrative activates comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
  • Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
  • Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
  • Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating TEMPPrincipals (logins) and Mapping users to roles. (Securables and Permissions)
  • Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic SQL queries.
  • Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
  • Experience in logical and physical data modeling of the database in MSVISIO
  • Hands on experience in configuring IIS.
  • Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases
  • Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
  • Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values
  • Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
  • Validated Data Integrity at various levels of Data Warehouse starting from the source data copies through the end user reports.
  • Well versed with Data warehousing life cycle.
  • Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
  • Developed SSIS Packages with Custom error handling, Logging using event handlers, Send E-mail Task and Used Checkpoints to rerun Packages from Point of Failure.
  • Designed and Deployed several SSRS reports such as Drill down reports, Drill through reports, Parameterized reports, Cascaded reports, Cached reports, Snapshot Reports, linked reports, Sub reports.
  • Explicitly used third party tools like LiteSpeed, Fog light, and Spotlight and Red gate.
  • Worked with a team of business analysts, data architects, application developers, ETL developers and testers, My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines
  • Strong experience in mentoring with team members, documentation and 24/7 on call production support


Databases: MS SQL Server 2012/2008R2/2005/2000, MS Office Access 2000/2003/2010/2013.

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, PowerShell.

Web Servers: IIS 6.0/7.0

Business Intelligence Tools: SQL Server Integration Services (SSIS), Data transformation services (DTS), and SQL Server Reporting Services (SSRS).

Operating Systems: Windows 2000 Advanced Server, Windows 2003/2008/2008 R2 Server, Windows 95/98/XP /Vista/7/Windows 8/8.1

Data Modeling Tools: Lite Speed, Red Gate, Fog Light, Commvault, Idera, Erwin

Reporting Tools: SQL Server Reporting Services, Crystal Reports.


Confidential, Cleveland OH

SQL Server DBA



  • SQL Server 2008/2012 Database Administration.
  • Implemented and documented TDE (Transparent Data Encryption) for databases more than4TB.
  • SQL 2008,2012 - Performed installation of SQL Enterprise bit version on windows 2008 servers on Enterprise systems of clustered and standalone Dell servers in Enterprise Data Centers. Patch applications.
  • Installed and administered two node and three node cluster Active/passive on Microsoft Windows Server 2008 R2 Enterprise Edition SP2 on SAN environment.
  • Worked in Active\passive and active\active\passive cluster environments.
  • Worked in Huge Replication Environment.
  • Good experience with installing Database Mirroring.
  • Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
  • Maintained the database consistency with DBCC at regular intervals
  • Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and database Engine Tuning Advisor.
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • Implemented the Data Partitioning for large tables in SQL Server 2008.
  • Extensively worked on SQL Server Integration Services (SSIS).
  • Implement Snapshot Isolation in SQL Server 2008.
  • Used Online Indexing and online Restoring in SQL 2008.
  • Implemented new topics like CLR integration on Development server.
  • Expert in implementing the DDL triggers.
  • Solving the Bugs Reflected by the Testing team.
  • Analyzed long running /slow queries and tune the same to optimize application and system performance.
  • Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
  • Evaluated data storage considerations to store databases and transaction logs.
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
  • Creating Packages to transform the data Using MS-SSIS and MS-DTS.
  • Developing and Maintaining Cubes, Dimensions in MS-Analysis Services.
  • Installed, authored, and managed reports using SQL Server Reporting Services.
  • Worked on different third party tools like OEM (Oracle enterprise Manager)Environment: MS SQL server 2008/2012, Windows 2008/2012, VB.Net, Enterprise manager, Query Analyzer, DTS, SQL profiler.

Confidential, Dallas, TX

SQL Server Production DBA/ Developer

Environment: Windows 2003/2008, MS SQL Server 2005/2008, Oracle, .net, VB and ASP, LiteSpeed, MS Visio.


  • Migrated 170 application and 49 servers from SQL SERVER both in place and side by side.
  • Used DTSXchange tool for migrating DTS packages to SSIS.
  • Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.
  • Installed couple of SQL Server 2005/2008 on cluster environment.
  • Solving the Bugs and issues reflected by the Testing team. SQL Server 2005/2008 Database Administration.
  • Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
  • Involved in data migration and cleaning using ETL tools like Informatica.
  • Implemented the new SQL Server 2008/2012 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
  • Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • Experience in Database security and integrity planning.
  • Successfully implemented the Capacity planning for different servers.
  • Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
  • Used VB.NET code in script Task for developing SSIS packages.
  • Designed and developed SSIS packages for data migration and cleansing.
  • Checked Database Health and consistency by using DBCC Commands and DMVS
  • Monitored and modified Performance using execution plans and Index tuning.
  • Recovered the System and User databases from suspect mode.
  • Expert in sizing Temp database.
  • Used log shipping for synchronization of databases.
  • Prepared Documentation step by step for the migration and Disaster Recovery plan.
  • Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
  • Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
  • Extensively worked on trouble shooting dead locks and fine-tuning of databases for its performance using native SQL Server tools like profiler and performance monitor.
  • Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.
  • Managing the VERITAS net backups and Litespeed backup.
  • Hands on experience in trouble shooting database issues.
  • Performed code reviews to ensure high Software quality and participated in weekly team meetings.
  • Performed all basic Database activities like moving databases between servers, copy databases etc.
  • Used SQL server Reporting Services (SSRS) to create reports.
  • Worked on call 24/7 Support on weekly basis.

Confidential, St Louis, MO

Technical Database Administrator

Environment: SQL Server 2008R2/2008/2005, Cluster, Reporting Services (SSRS), SharePoint 2010, INFOPATH 2010, Windows 2003, 2008.


  • SQL Server bit Failover Cluster Installation on Windows Server bit.
  • SQL Server 2008 Installation.
  • Writing batch scripts to do automation of database tasks.
  • Writing scripts to manage different servers for auditing purpose.
  • Running packages as for system promotion requirements.
  • Solving Memory Problem related with SSIS Packages.
  • SQL Server Analysis Services 2000 installation and Reporting Services 2005
  • Performance tuning on different Production Servers.
  • Extensively worked on Dynamic Management Views (DMV’s).
  • Running profiler to troubleshoot Blocking issues, Deadlocks issues and slow running.
  • Implementation of SQL Principle, Securable, Permission, Roles and Authentication.
  • Solving memory related problems by changing server configuration settings.
  • Rebuilding indexes with different fill factors and update statistics manually.
  • Building Maintenance plans for database maintenance.
  • Writing stored procedures as for business requirements.
  • Backup and Restore databases.
  • Moving Tempdb to different file location.
  • Shrinking the data files as the space requirements.
  • Effectively used PL/SQL advance features like collections, ref cursors, dynamic sql and Managing users and security.
  • Managing schema objects, such as tables, indexes, and views.
  • Making database backups and performing recovery when necessary.
  • Involved in database development by creating Oracle PL/SQL Functions, Procedures, used Team Foundation Server 2010 for maintaining source control, data collection.
  • Involved in Configuration and Administration of Share Point 2007 environment.
  • 24 X 7 Production Database on Call Support.


SQL Server DBA

Environment: SQL Server 2008R2/2008/2005, Cluster, Reporting Services (SSRS), SharePoint 2010, INFOPATH 2010, Windows 2003, 2008.


  • Installation and Maintenance of SQL Server 2008R2 on Development, Test and Production Environments.
  • Responsible for MS SQL Server 2008R2 configuration, tuning and provide 24X7 dedicated support to all Production, development and cluster servers.
  • Applied Patches and Service packs to update different versions of MS SQL SERVER.
  • Creating Backup strategies and scheduling them as a part of database maintenance plans.
  • Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
  • Documented and performed the data base health checks regularly.
  • Used native tools like Database Tuning Advisor, Profiler and Activity Monitor for performance analysis.
  • Used Perfmon, DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
  • Created baseline and sampling intervals in the Perfmon considering threshold values of the counters.
  • Monitor connections, locks and performance of SQL server.
  • Responsible for monitoring and making recommendations for performance improvement inhosted databases.
  • Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
  • Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
  • Evaluated data storage considerations to store databases and transaction logs.
  • Fixed the failed TEMPPrincipals (logins), User permissions and Security in Active Directory and SQL Server Level.
  • Scheduled regular Backup Jobs and kept track of database by receiving the emails on Alerts.
  • Expert in Performance Tuning, Analyzed long running queries and tuned them to optimize the system performance.
  • Maintaining the database consistency with DBCC utility at regular intervals.
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases.
  • Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
  • Implemented Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA, SQLCMD and dedicated admin connection, Common table Expression(CTE).
  • Deployed SSIS package for bulk insert and maintained archival data.
  • Created SQL Server Database users and Roles. Worked on DTS, Import and Export utility, installed, authored, and managed reports using SQL Server 2005 Reporting Services.
  • Developed and optimized database structures, stored procedures, Dynamic Management.
  • Moved files between the File Groups and partitioned the tables to improve the performance for transferring data, views, DDL triggers and user-defined functions.
  • Extensively used litespeed backups. Utilized the new features of 2008 like TCE, EKM, MERGE STATEMENT and Compressed Backups.
  • Handled numerous Change Management Requests on production servers.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments.
  • Extensively used Red Gate SQL Compare and Data Compare tools to compare and Build, synchronize SQL Database Schemas.


SQL Server DBA

Environment: SQL Server 2000, Windows NT server, SQL Profiler.


  • Actively participated in gathering of Requirement and System Specification.
  • Worked on complex T-SQL statements, and implemented various codes and functions.
  • Involved in creating Stored Procedures, views, tables, constrains.
  • Created stored procedures and triggers for Data consistency.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
  • Wrote complex stored procedures to process employee’s requirement and generating.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
  • Debugged the T-SQL queries for performance tuning.
  • Checked & updated Database Statistics and Re-indexing.
  • Created Users and Roles, and managed security and permission of database.

We'd love your feedback!