We provide IT Staff Augmentation Services!

Sql Dba Resume

Washington, DC

SUMMARY:

  • Pursuing a position as a MS SQL Database Administrator, utilizing over seven (7) years of professional experience in the Relational Database Management System, skills in MS SQL Server in the areas of Installation, Configuration, Migration, Security, SSIS/SSRS/SSAS, ETL Data Modeling, Maintenance, HA/DR, Performance Tuning as well as development of database objects like tables, views, stored procedures, triggers, functions, and constraints.
  • Over seven years of experience administering SQL server Databases including versions 2016, 2014, 2012, 2008 R2, 2008, 2005.
  • Proficient with T - SQL to create and update database objects like tables, stored procedures, functions, views, and triggers.
  • Expert in reading and writing complex SQL queries utilizing sub-queries and Joins.
  • Expertise in SQL server installation, configuration, upgrade, and migration of databases.
  • Implemented and maintained policies and procedures for ensuring the security and integrity of the databases.
  • Experienced in disaster recovery by restoring the databases from backup and Implementing Point-in-Time recovery.
  • Designed and implemented DR and HA strategies utilizing Maintenance Plan, SQL Server Log Shipping, Database Mirroring, Failover Clusters, and Always On Availability Group.
  • Implemented different types of Replication Models including Snapshot, Merge, Peer-to-Peer, and Transactional Replication.
  • Strong background in database Performance Tuning, Index Management, and Update Statistics.
  • Created maintenance plans to perform index defragmentation, reorganize/rebuild index, and update statistics.
  • Background in Visual Studio to create and execute SSIS and SSRS packages.
  • Expertise in troubleshooting SQL issues by using SQL Tools, Execution Plans, SQL Profiler, Performance Monitor, Traces, Statistics, and Index Tuning wizard.
  • Identified SQL Server Locks, Blocks, and Deadlock situations utilizing System Stored Procedures, DMVs, and Activity Monitor.
  • Experienced in creating Linked Servers
  • Expertise in planning and testing databases and database objects.
  • Good communication skills both in writing and speaking.
  • Team player, ability to lead a team, and perform well under pressure situations.

TECHNICAL SKILLS:

Database Expertise: SQL Server 2016, 2014, 2012, 2008 R2, 2005, MS Access

Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and Excel to SQL Server.

Operating System: Windows Server 2012, 2008 R2, 2003 R2, 2000, UNIX/Linux, VMware

Languages: SQL, T-SQL, HTML, XML, JavaScript, ASP, ASP.net

ETL/Data Warehouse Tools: SSIS/DTS, BCP

Reporting: SSRS - Enterprise Reporting

Data Modeling Tools: Erwin, Visio, SSDD (SQL Server Database Diagram).

Third Party Tools: Solar Winds, Red Gate, Idera, SpotLite, Erwin, and Visio.

Networking: Active Directory, DNS, TCP/IP.

Hardware/Storage: SAN, RAID, iSCSI.

PROFESSIONAL SUMMARY:

Confidential

SQL DBA, Washington, DC

Responsibilities:

  • Installed and configured SQL Server 2016, 2014 and 2012 in production, Dev, and test environments.
  • Upgraded SQL Server 20 /2016 and then, migrated databases and logins.
  • Developed Transact-SQL codes to create/update Tables, Stored Procedures, Functions, Views and Triggers
  • Configured and maintained SQL Server High Availability solution including Always On, Clustering, Replication, Log Shipping and Mirroring.
  • Used new compression Techniques in SQL Server 2016/2014/2012/2008 for backup and restore jobs.
  • Scheduled maintenance tasks, planned production upgrades and capacity planning.
  • Checked Database Health by using DBCC Commands and DMVS.
  • Applied SQL Server service packs and hotfixes as they became available for updates.
  • Scheduled DBCC and update statistics on databases to ensure data consistency and better performance.
  • Implemented Database Backup, Restoration, and Disaster Recovery-procedures and performed Contingency plans testing.
  • Rebuilt the indexes at regular intervals for better performance.
  • Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Assisted developers with code enhancements, tuning of queries and indexing the tables.
  • Built and maintained SQL Server Hot/Warm Standby and Ad-hoc replication.
  • Designed and implemented Disaster Recovery strategy using SQL Server Log Shipping, Database Mirroring and Failover Clusters.
  • Performed Query Optimization, Debugging, Tuning, and Improvising to improve performance of the databases.
  • Used SSIS package, Import/Export utility, and BCP command to move data between different platforms.
  • Assisted in creating and executing SSRS packages for the purpose of reporting and analysis.
  • Monitored memory, CPU utilization, disk utilization, locks, deadlocks and run-time of queries.
  • Implemented Replication Models including Transactional, Peer-to-Peer, Merge, and Snapshot.

Confidential

Database Administrator, Ashburn, VA

Responsibilities:

  • Supported day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long-running queries, locks, deadlocks
  • Installed, Configured, and Maintained SQL Server 2008 R2, 2012, in development, test, and production environments.
  • Configured Backups, involved in restoring the database to point- in- time in case of issues, and optimization jobs for various purposes and DBA notifications like job failures, disk issues, critical events.
  • Applied SP (Service Pack) and Hot Fixes on SQL Server 2008 R2, and 2012.
  • Installed, Configured, and Administered SQL Server Reporting Services (SSRS), and Developed, Deployed and Managed Reports for associates and upper management using SSRS, Crystal Reports and Report Builder.
  • Expert in AMANDA Enterprise software with good knowledge of Case Management, Licensing, Permitting and Compliance, FOIA and Privacy Compliance
  • Involved in completing database design including conceptual, logical and physical data models
  • Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers and maintained referential integrity.
  • Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access and ODBC/OLEDB data sources.
  • Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access and ODBC/OLEDB data sources to SQL Server.
  • Scheduled to Rebuild and reorganize the index.
  • Performed Database administration including monitoring and tuning, job automation, maintenance task, backup recovery, analyze database performance.
  • Created and Managed Jobs, Setup Alerts, SQL Mail Agent and Scheduling SSIS Packages.
  • Implemented SQL Server security and Object permissions.

Confidential

SQL Server DBA, White Plains, NY

Responsibilities:

  • Performed Database Design, Installation, Development and Support of Microsoft SQL Server.
  • Scheduled maintenance tasks, planned production upgrades and capacity planning.
  • Scheduled DBCC and update statistics on database and ensure data consistency and better performance.
  • Implemented Database Backup Procedures, Restoration Procedures and Disaster Recovery procedures
  • Assisted developers with code enhancements, tuning of queries and indexing the tables properly.
  • Developed centralized Monitoring and onboard all the databases. Built and maintained SQL Server Warm Standby and Ad-hoc replication.
  • Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping, Database Mirroring and failover clusters.
  • Performed Query Optimization, Debugging and Tuning and Improvising performance of the databases.
  • Extract, Transform and Load (ETL) data using DTS, SSIS, Import/Export utility, BCP and DTS Packages.
  • Monitored memory, CPU utilization, disk utilization, locks, deadlocks and runtime of queries.
  • Implemented different types of Replication Models like Merge, Snapshot, Peer-to- Peer, and Transactional Replication.

Hire Now