We provide IT Staff Augmentation Services!

Senior Sql Server Dba Resume

3.00/5 (Submit Your Rating)

Detroit, MI

SUMMARY

  • SQL Server Database Administrator (DBA) and Engineer (DBE), Logical and Physical Data Modeling
  • Mentor and lead other DBAs and developers, DB2 App DBA, DB2 Database Design and Database Developer
  • Experience in Windows Scripting Language, Power shell involving SMO, WMI etc.
  • Performance Enhancements, Query Tuning, Developing and Reviewing Stored Procedures, Triggers, Functions, Views, T - SQL Queries, Data Archive and Purge Processes etc
  • Experience in leading teams at different geo-locations, mentoring team members, project coordination

PROFESSIONAL EXPERIENCE

Confidential, Detroit MI

Senior SQL Server DBA

Responsibilities:

  • Logical and Physical database design for OLTP mission critical applications
  • Guide developers and tune stored proc and queries for performance
  • Address business issues with analysts, developers and leaders
  • Data Analysis and product review for vendor contract
  • Support mission critical databases in all environments
  • Research topics on SQL internals and present white papers to DBA team
  • Installation, Configuration, Maintenance and Troubleshooting of SQL Instance and Database issues
  • Setup Database Auditing for PII / PIFI data for info security team
  • Designed a robust security model for developers and coordinated for implementation. Produced a data recovery Tool that recovers lost data from SQL table. Created Powershell scripts to automate admin tasks

Confidential, Cleveland OH

Senior SQL Server DBA

Responsibilities:

  • Design, architect and maintain data models using data modeling tool Erwin
  • Mentor and lead DBAs and developers and lead large enterprise projects
  • Upgrade SQL, migrate databases using backup-restore, attach-detach, mirroring-session etc.
  • Partition switching for sliding windows and developed an automated process
  • Resolve locking-blocking, deadlock, tempdb contention and various other issues using DMVs and other tools
  • Coached application developers on best practices and high performance database design
  • Added new functionality into an in-house DBA-tool using C# in .net platform, SSIS, SSRS
  • Presented shell scripting (Powershell scripting) involving SMO and WMI; Locking-blocking, Concurrency and Isolation; Proportionate Fill Strategy and several other topics to our SQL DBA team
  • Designed and developed a DB2 tool to replace CA’s RC Query and presented to the DB2 DBA team
  • Produced several automation tools using Powershell to automate numerous admin tasks
  • Created inventory for sql instances and machines using Windows Powershell, SMO and WMI Service
Confidential

Data Engineer

Responsibilities:

  • Create and Maintain Database Models using data modeling tool Erwin, writing Stored Procedures, Functions, and SQL query performance tuning, database code review for both databases, SQL Server and DB2, DB2 performance tuning using Visual Explain, Stored Procs using PL/SQL, delivered presentations to developers on (1) Locking and Concurrency and (2) Data Partitioning in DB2.
  • Analyzed, simulated and provided alternative resolutions to a massive “conversion” deadlock occurring in production environment in a SQL Server database.

Confidential, Louisville KY

DB2 Developer

Responsibilities:

  • Root Cause Analysis for database exception conditions, presented monthly production metrics to top leadership, data modeling and design using Erwin, creating indexes, MQTs and Stored Procedures, DB2 SQL Tuning, Explain Access path.
  • Accomplishments: Fixed job failures after a SOX compliance change using scripting language Rexx. Designed a tool to address this issues related to inconsistent API. Produced a system programmed tool for business analysts for easy data retrieval. Created an auditing tool to avoid production issues proactively. Leader for offshore team.

Confidential

Project Lead

Responsibilities:

  • Team Leader. Team and Project Management. Mentoring a team of 20-plus members. Coordinating on overall. SDLC process. Generating Project Health Metrics. Software Compliance Audits. Batch System Automation. Tutor/Trainer on DB2.
  • SDLC External Audit compliance. Automation of test batch system using Rexx

We'd love your feedback!