We provide IT Staff Augmentation Services!

Senior Dba Resume

St Louis, MO

SUMMARY:

  • Possess excellent hands - on experience in both Database Administration and SQL programming.
  • Extensive skills in managing enterprise database implementations.
  • Senior production DBA with strong problem solving ability, excellent verbal and written communication skills.
  • Good performer both in team and independent job environments.
  • Excellent hands on experience in building and administrating SQL HA/DR system:
  • Creating and managing SQL failover clusters with multi SQL instances, DR with SQL log shipping.
  • Building HA using multi Always-On Groups.
  • Expertise in admin Enterprise Production (OLTP) servers (2005/2008/2012/2016 ) in AWS Cloud and other virtualized environment.
  • Outstanding Performance Tuning and Index Optimization (PTO) skills.
  • Strong trouble shooting and resolving SQL problems, hands on experience on production server migrations.
  • Strong Query Tuning with SQL Execution Plans (key lookups, ascending key problem, table spools etc.).
  • Excellent hands on experience in applying SQL indices: clustered, non-clustered Index, covering index, filtered index and SQL statistics.
  • SQL server Internals and Architecture: SQL engine memory optimization, SQL transaction logs, TEMPDB optimization.
  • Expertise in using DMV (Dynamic Management Views) in queries and server monitoring.
  • Proactively monitoring SQL servers using native (PerfMon counters, Extended Events) and 3rd party troubleshooting tools such as Sentry Plan explorer, Brent Ozar’s tools etc.
  • Database Encryption: built TDE database level encryption on production databases.
  • Hands on experience to apply column level encryption/decryption on sensitive data.
  • Highly proficiency in writing complex SQL Stored Procedures and generating various SQL queries.
  • Server side configuration, creating SQL jobs, alerts, maintenance plans. Working experience on SQL data compression, partitions, file stream etc.
  • Extensive working experience on windows, Oracle, Shell script programming, Java, Unix/Linux.
  • Experience with an Agile Scrum development team. Handle server incidents using Ticketing software.
  • Experience in using Microsoft Visio and Project.
  • Comprehensive experience developing Java Internet reusable class libraries and application frameworks.

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Senior DBA

Responsibilities:

  • Play a significant role at infrastructure team in support of Confidential Secured Cloud contract.
  • Administrate OLTP production SQL servers/databases.
  • Manage multiple Production and dev/staging servers in AWS environment.
  • Architected and built SQL Multi node HA/DR Design using SQL AlwaysOn (AG).
  • The infrastructure contains multiple AG groups to host SharePoint databases in order to balance online traffic.
  • Tuned poorly performed SQL queries to achieve 99% performance improvement.
  • Provided HA with log shipping for standalone SQL servers.
  • Supports over 10 mission critical projects, working with clients/developers to write ad hoc SQL queries and Stored Procedures.
  • Work closely with solution architect to implement required SQL solutions.
  • Applied database level encryption using TDE for user databases.
  • Programmed in SQL for column level encryption/decryption to secure client data.
  • Script automatic alerts/jobs to monitor SQL severe level errors, deadlocks, disk space, high transaction log size, AlwaysOn states, update Statistics and database integrity etc.
  • Using SQL perfmon counters, DMV and 3rd party tools to monitor SQL performance.
  • Automatic maintenance plans for backups and SharePoint database transaction logs management.
  • Handled all critical projects and setup end to end SQL servers .
  • Apply SQL service packs and patches.
  • SQL backups, restore and recovery models.
  • Capacity planning and assessment of SQL servers for current and future growth projections.
  • Trouble shooting for all projects.
  • Provided 24/7 on-call rotation support for production servers.

Environment: Microsoft Windows Server 2012 R2, Microsoft SQL Server 2016, 2014, 2012, 2008R2. Amazon Web Service (AWS)

Confidential

DBA

Responsibilities:

  • Install and administrate production SQL servers/DB’s in clustered environment with responsibility
  • Conduct database performance tuning assessments and engagements.
  • Design, develop high availability database solutions utilizing Microsoft’s SQL Server.
  • Implement routine database maintenance plans, perform upgrades, applying patches.
  • Performance optimization, wait statistics, index defragmentation and DMV (Dynamic Management Views).
  • Evaluate and recommend new technologies such as Big Data technology.
  • Familiar with server virtualization technology (e.g. Hyper-V, VMWare, etc.)

Confidential

MS SQL server DBA

Responsibilities:

  • Administered development, QA and production SQL Servers/databases and related systems in a clustered environment.
  • Refreshing and monitoring production, development databases for PeopleSoft.
  • Responsible for creation and scheduling of maintenance plans.
  • DB migrations between servers.
  • Database upgrade from .
  • Configured Database mail, linked servers.
  • Performed Failover cluster testing and maintenance,
  • Configured database Mirroring and Transactional Replication for development servers.

Confidential, Rochester, NY

Senior Consultant

Responsibilities:

  • Project Lead on counterparty filter project. Was responsible for fully designing and implementing a distributed system allowing counterparties in real-time commodity energy trading to access, update and save all related information from and to the backend database using J2EE(Java, RMI, Java thread programming).
  • Project Lead on a parametric search project. Was responsible for designing and fully implementing a parametric search engine for Business-to-Business Ecommerce product using Java.

Hire Now