We provide IT Staff Augmentation Services!

Sr. Sql Database Engineer Resume

Seattle, WA

SUMMARY:

A Microsoft Certified SQL DBA (Database Administrator), over 6 years of experience in Azure SQL server Database with thorough knowledge of SQL Server 2005/2008R 2/2012/2014/2016 databases seeking a position as MS SQL Server Database Administrator. Experience entails different aspects of SQL Server Databases in Installation, Configuration, Migration, Maintenance, Performance Tuning, Security, SSIS, SSRS, ETL, Data Modeling and design, as well as development of database objects including stored procedures, triggers, views, functions, constraints etc. Highly skilled in completing projects and achieving company goals within budget and deadline. Analytical problem - solver with in-depth knowledge and hands-on experience in technical troubleshooting, installation, and maintenance for optimal performance and client satisfaction.

CORE COMPETENCIES:

MSSQL Server (2005,2008,2012,2014, 2016,2017,2019)

Toad Data Modeler

Red gate

Microsoft Office Suite (PowerPoint, Access, Excel, and Publisher)

Active Directory

SSRS/SSIS

Windows SharePoint Services

Agile methodologies

Azure SQL server

SQL Server Powershell

End-User Communication

Strategy & Procedure Development

IT Reporting & Documentation

Client Relationship Management

Issue Identification & Resolution

Process Improvement

Technical Research & Analysis

Communicate effectively.

Subversion

Version One

PL/SQL, SQL Plus

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr. SQL Database Engineer

Responsibilities:

  • Providing support to Microsoft customers on Azure SQL server Connectivity and Performance issues
  • Working collaboratively with a team on Azure Cloud Environment.
  • Ensure high levels of performance, availability, sustainability, and security
  • Designs, installs, monitors, maintains, and conducts performance tuning procedures in a production MS SQL Server database environment while ensuring high levels of data availability.
  • Experience in a customer facing or customer support role.
  • Using ASC “Azure Support Center” Platform to help customers troubleshoot various issues.
  • Monitoring over Production, Dev and Test SQL Server Databases
  • Troubleshooting and resolving of database integrity issues, performance issues, blocking and deadlocking, connectivity, and security issues.

Confidential, Hammond, LA

SQL Database Administrator

Responsibilities:

  • Database Installation and configuration (Development, QA and Live environment):
  • SQL Server 2008, 2012, 2014,2016 (SSRS, SSIS) installation and configuration
  • Familiar with different types of error occurred during installation.
  • Instant file initializing, proper allocation unit for system drive and other drives.
  • Database Upgraded (Development, QA and Live environment):
  • SQL Server and 2014
  • SQL Server 2005 to SQL Server 2008, 2008R2
  • Server Migrated (Production environment)
  • Physical server to VM ware.
  • Standalone to Active/passive Cluster (By consuming Old DNS name and IP Address)
  • Exported data from SQL Server to multiple destinations for sales forecast and other purposes.
  • Configured and maintain database High Availability Features (Failover Clustering, Always on availability groups Database Mirroring, Log Shipping, Replication)
  • Implement and maintain database mail, Created a disaster recovery plan.
  • Test application connection in Always ON Environment using the listener in the connection string file.
  • Configured the Quorum Setting that works with Always ON following Microsoft best practices.
  • Create and managed MS SQL Cluster (Active/Passive), Multi node cluster on Cisco UCS blade chassis 5100 series, shared storage on EMC VNX 5200 Series.
  • Configured and troubleshooting Replications (Transactional).
  • Involved in data modeling for the application and created ER diagram.
  • Backward & Forward Engineering with data modeling tools mentioned above.
  • VISIO, SQL Server Data Diagram
  • Applied SP (Service Pack) on SQL Server and Windows Server
  • Cluster aware update for windows servers 2012 R2.
  • Applied HOT Fixes, Cumulative update on SQL Server.
  • Strong knowledge on database Monitoring and Performance tuning.
  • Monitor different logs, Space usage, Events, Agent Job history by PowerShell scripts.
  • Provide support to application developers in designing and implementing physical database structures.
  • Tune slow running, resource consuming queries by evaluating query execution plan.
  • Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolve deadlock, block, and locking conflicts and resource utilization.
  • Idera Backup solution - SQL SAFE.
  • Familiar with EMC Recovery Point techniques.
  • Strong working experience in SQL native database Backup and restore.
  • Disaster Recovery planning and implementation.
  • Experienced with Point-in-Time Recovery.
  • Take necessary prevention for data corruption.
  • Strictly maintain data integrity using DBCC CHECKDB.
  • Restoring single page from backup using dbcc write page, dbcc ind.
  • Documentation: Prepare different documentation (SQL Server Build Guide, Database Decommissioning steps, restore steps,) and update them in timely manner.
  • Encryption: PCI complacence by using SQL Compliance from Idera, SQL auditing.

Confidential, Sterling, VA

SQL Database Administrator

Responsibilities:

  • Working on SQL native database Backup and restore.
  • Disaster Recovery planning and implementation.
  • Idea Backup solution - SQL SAFE. Experienced with Point-in-Time Recovery.
  • Dealing with Database Corruption: Take necessary prevention for data corruption.
  • Strictly maintain data integrity using DBCC CHECKDB. Restoring single page from backup
  • Documentation: Prepare different documentation (SQL Server Build Guide, Database Decommissioning steps, restore steps,) and update them in timely manner.
  • Encryption: PCI complacence by using SQL Compliance from Idera, SQL auditing.
  • Managed MS SQL Cluster (Active/Passive), Multi node cluster.
  • Installed, Configured and Maintained Database Mirroring using automatic fail-over option.
  • Configured Log Shipping as Standby database from Production database for Reporting purposes.
  • Configured and Maintained Replications (Transactional)
  • Monitor SQL Server Error Log, space usage, Events, Jobs, customer complaints, Daily routine works.

Hire Now