We provide IT Staff Augmentation Services!

Sql Server Production Dba Resume

0/5 (Submit Your Rating)

Houston, TX


  • 8+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R 2/2008/2005/2000.
  • Expertise and Interest include Administration, Database Design, Performance Analysis of highly transactional servers and production support for Large (VLDB) Complex and Critical databases.
  • Extensive experitise with configuring High Availability and Disaster recovery scenarios like Always On, Clustered environments, Mirroring, Log shipping and Replication.
  • Documented Disaster Recovery plans and participated in disaster recovery drills.
  • Worked extensively on Multi - Subnet Clustering and Server consolidation. Troubleshooting Production issues, HA issues and AG alerts
  • Experience in implementing advanced features like Policy Based Management, Resource Governor, Data Collector sets, and Backup Compression Techniques.
  • Implemented the methodologies like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, Online Indexing,
  • Experience in creating cubes using MS SQL Analysis Services. Developed star and snowflake schemas.Working in both MOLAP and HOLAP environments.
  • Worked extensively on DMV’s, DMF’s, Mail Setup, Jobs and Alerts, DTA, SQLCMD.
  • Experience in working with Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.
  • Expertise in setting up High Availability and Disaster Recovery(HADR) solutions such as Active/Passive and Active/Active Clusters.
  • Performed Sharding and Vertical Partitioning in order to suffice the Application through put and good experience in resolving SQL Server blocking and Dead Lock Issues.
  • Expert in Performance Tuning by Index Defragmentation, Optimizing execution plans, Proper usage of indexes, Index Rebuild, Reorg.
  • Experience working with Profiler and Server side trace.
  • Expertise in reading and understanding Execution plan and fixing query to execute with low cost.
  • Expert in handling parameterized Reports, Drilldown Reports using SQL SERVER REPORTING SERVICES 2005
  • Designed effective Maintenance Plans for Backups (Full, Differential and Transactional Log) and RPO, RTO to recover point in time data in in case of disaster of server/center
  • Thorough Understanding of different RAID levels implementation and Performed methologies such as Disk Striping with/without Parity.
  • Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
  • Upgraded databases from MS SQL Server, 2012 and MS SQL Server, 2014.
  • Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.
  • Hands on Experience with using Data Modeling Tools such as Erwin and MS Visio.
  • Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
  • Experience in SQL Server Reporting Services(SSRS) and Crystal Reports.
  • Overall database design thatinvolvescreating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
  • Explicit expertise in installation and configuration of SCO(System Center Orchestrator 2012) and SCOM(System Center Operations Manager 2012).
  • Performed both single server and multiple server deployment of SCOM and its components.
  • Extensively worked on Data tier applications, deploying and managing dacpacs.
  • Hands on expertise on both Upgrading and Downgrading SQL Server to new versions and applying Service packs and Hot Fixes.
  • Expertise in implementing advanced methologies like Transparent Data Encryption (TDE), Page Level Compression, Column Stored Indexes.
  • Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
  • Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.
  • Explicitly used third party backup tools like Lite Speed, Fog light and Red gate.
  • Creation and maintenance of Databases, creating Roles and managing user permissions and Data Warehousing.
  • Experience in Troubleshooting and documenting root cause analysis.
  • Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.
  • Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
  • Experience working with Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Develop and manage reports on SharePoint Server.
  • Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
  • Monitoring and troubleshooting by checking Performance Monitor and Activity monitor.


Databases: MS SQL Server 2014/2012/2008 R2/2008/2005

ETL & REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

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

Third Part Tools: SCOM, Idera SQL Check, Companion, lite speed, Red gate, Veritas net backup, Erwin r7, Guardum, Azure Storage Explorer, Cloudberry Storage Explorer.

Languages: T-SQL, C/C++, Java, PERL, java script, Visual Studio2010/2012, XML, HTML, ASP.NET, VB.Net.


Confidential, Houston, TX

SQL Server Production DBA


  • Migration of databses from SQL Server, SQl Server 2012.
  • Installation, Setup and Management of Always On Availability Cluster
  • SQL Server Logins and Windows Access Administration. .
  • Repaired, Recovered, Database Synchronization for Disaster Recovery.
  • Provided Consulting for Database Performance Tuning and also used tools such as Data Tuning Advisor and Profiler.
  • Managed Databases using Maintenance Plan, DBCC, Backup (Full, Differential, Log), Automated Backup to Blob Storage.
  • Performed SQL server trouble shooting for immediately issue, such as deadlocks and Blocking
  • Implemented Horizontal partitioning and Page Compression for Very Large Tables.
  • Implementation of TDE (Transparent Data Encryption) for HPA-Data and maintenance of Encryption Keys, Certificates and migration of Encrypted Databases across different environments.
  • Downgrading SQL Enterprise Edition to DE (Developer Edition 2012/2014) in Development Environments. nstalled, authored, and managed reports using SQL Server 2005 Reporting Services (SSRS).
  • Involved in capacity planning, sizing and database growth projections.
  • Implemented disaster recovery strategy and configure relative job on DR.
  • Created and monitored SQL agent jobs.
  • Installed and Configured Microsoft monitoring tool System Center Operations Manager (SCOM)
  • Installed and integrating MOM Agents across different machines for SCOM monitoring
  • Powershell scripts for Server Health monitoring and automated jobs for Blob storage
  • Create alerts for AG (Availability Groups) health and Extended Events for Dead Lock monitoring.

Confidential, Cleveland, Ohio

SQL Server DBA


  • Involved in the Migration of Databases from SQL Server and SQL Server .
  • Involved in migrating DTS packages from SQL Server 2005/2008 to SSIS packages in SQL Server 2012 database.
  • Created and optimized SSIS packages for data flow between SQL Servers.
  • Extensively used SSIS and DTS packages for Data Warehousing and Archiving.
  • Extensively worked on Extracting, Transforming and Loading (ETL) of Data from Excel, Flat file, Oracle to MS SQL Server using DTS Import/Export utility, BCP, DTS and SSIS Packages, Automation using SSIS
  • Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Evaluate and apply SAP Kernal patches and support packs.
  • Monitor and Tune SAP application performance.
  • Installation and Postinstallation procedural documentation for SAP Optimizer.
  • Installed, configured and maintained transactional Replication Server.
  • Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
  • Created alerts and notifications for System errors, insufficient resources, and Fatal database errors.
  • Created Triggers to enforce data and referential integrity.
  • Involved in writing T-SQL Programming to implement Stored Procedures and Functions for different tasks.
  • Performance Tuning, Analysis and optimizing for SQL Server Application by using Performance monitor.

Environment: MS SQL Server 2005/2008/R2/2012, SAP,Windows 2003/2008, SSRS, SSIS, SSAS, PL/SQL, MS Access, perl script, Erwin, companion, Idera, TSM/TDP.

Confidential, Plymouth, MN

SQL Server DBA


  • Manage and administer SQL server 2005\2008\R2\2012 servers.
  • Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
  • Deployment of databases, jobs, cubes from pre-production to production.
  • Building SQL 2008\R2 cluster environments on VMware or Physical windows
  • Performed installations of SQL 2008\R2\2012 on clustered and standalone servers
  • Upgradtions of sql server versions and applying patches and hot fixes.
  • Adding nodes to already existing clustered servers as a part of data load\High availability
  • Configured Transactional Replication and Log Shipping with SQL Server Management
  • Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
  • Work on weekly Issues reports which are generated as a part of infrastructure setup.
  • Conitnuous monitoring server health with Idera
  • Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
  • Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
  • Performance tuning of databases by windows performance monitor and SQL Profiler
  • Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
  • Documenting the standard procedures on regular basis.
  • Working on tickets\incidents with in the SLA’s, as a part of operations support DBA
  • Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
  • Resource planning and coordination for application migrations with project managers, application and web app teams
  • Involved in capacity planning, sizing and database growth projections. Worked with Data warehousing team in VLDBs environment for archiving the old data
  • Worked in a environment with Change management process (Service-now tool) in place for all kind of production and non production changes
  • 24*7 oncall production support.

Environment: MS SQL Server 2000/2005/2008 / R2/2012, Windows 2003/2008, SSRS, SSIS, SSAS, PL/SQL, MS Access, perl script, Erwin, companion, Idera, TSM/TDP.

Confidential, Atlanta, GA

SQL Server DBA


  • Performed backup/restore, created database objects such as tables, procedures, constraints, indexes and views, user security management.
  • Designed database tables and relations between them through Normalization. Involved in project planning, scheduling for database module with project managers.
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
  • Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints 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.
  • Monitored the overall performance of the database to recommend and initiate actions to improve/optimizeperformance.
  • Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning and optimizing indexes using Performance Monitor, Profile and Index Tuning wizard.
  • Experience on Import / Export using DTS and BCP utility.
  • Worked as a developer in creating complex Stored Procedures, Functions, Triggers, and views.
  • Involved in Database designing, Logical and Physical Data modeling using Erwin.
  • Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.

Environment: MS SQL Server 2000/2005/2008 , MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer.

Confidential, Longwood, FL

SQL server DBA


  • Involvement in the Design and Development of Database.
  • Creating Automatic data loading Procedures from the host system to master systems
  • Used stored procedures, bcp and DTS Packages
  • Involved in automation of the job and was involved in daily monitoring of the tables and indexes for performance
  • Monitoring Log shipping/Replication and trouble shooting of errors
  • Security issues related to logins database users and application roles and linked Servers.
  • Performance Tuning of SQL 7.0
  • Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
  • Backup and Restoration of data/database.
  • Involvement in Development and Implementation
  • Designing the database
  • Creating Automatic data loading Procedures from the host system to master systems
  • Used stored procedures, bcp and DTS Packages
  • Security issues related to logins database users and application roles and linked Servers.
  • Timely completion of activities for database backup, restoration and health check of databases.
  • Involved in trouble shooting and fine-tuning of databases
  • Tuning front-end applications like Visual Basic and MS Access, which query the SQL Server databases.
  • Troubleshooting ODBC and OLEDB issues between the application and the server.
  • Scheduling Full and Differential Database backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.

Environment: SQL SERVER 2000, MS-Access, Visual Basic 6, and Windows NT Server and Windows 2000.

We'd love your feedback!