SUMMARY:

• 13 + years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012/16/27
• Expertise in Always - On Availability Groups (AAG) and HA/DR Troubleshooting
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• 24 X 7 Production Database on Call Support
• Experience on PowerShell scripting automating disk space alert, logshipping status, e.t.c
• Working Experience in design techniques, ETL processes, relational database theory, N-Tier development
• Excellent communication, presentation and interpersonal skills

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, Tx

Senior DBA/Azure Engineer

Responsibilities:

• Managed over 80+ database servers monitoring, working on incidents and providing support
• Performed as a Tech Lead (Managing several application teams) in Agile to Administer, guide teams in Code development, Migration and Performance Tuning
• Worked with Scrum master to estimate project, discuss with business team understanding the scope and driving project completion
• Experience in Windows Azure, migrating database to Azure
• Use of Dacpac & SSDT for automated/Manual database deployments
• Implemented Columnar Data Store Index for faster response
• Good knowledge on Continuous Integration and Continuous Delivery Pipeline for 3-tier Application

Confidential, Dallas, Tx

Senior DBA

Responsibilities:

• Day 2 Day DBA activities that includes - space, job failure, error log, backup checks
• Idera Diagnostic Manager - Alerts resolving
• Centralized DBA metrics - includes configuration, performance related data
• Baseline SQL server using PAL Tool for every quarter
• Participating in change control meetings
• Setting up / Migrating / SQL Server using standard alone and cluster.
• Sharepoint performance support
• Microsoft Dynamics CRM Collation migration

Technology: SQL Server 2k,2k5,2k8,2k8R2, Windows 2k, 2k3, 2k8, Solarwinds Orion

Production Support DBA

Confidential, Little Rock, AR

Responsibilities:

• Daily Backup, Drive Space, Logshipping, Prod to QA Restore refresh, Cloning of Database Status check
• Applying patches to production and non production servers
• Setting up dataware house for the Insurance domain
• Implemented Attunity Tool for Change Data Capture from Oracle and SQL Server
• Backup & Restore using RedGate, LiteSpeed, Avamar
• Profiling 3rd part tools for understanding the data flow for Compass and Life Pro tools
• SCOM Monitoring and Setup
• Sharepoint Reporting Set up.
• Ad hoc SSIS/SSRS reporting need development and setup
• Performance monitoring of SSIS/SSRS/Data Feed jobs
• Quest Spotlight Setup and monitoring.

Technology: SQL Server 2k,2k5,2k8,2k8R2, Windows 2k, 2k3, 2k8, Attunity, Redgate, Litespeed, SCOM 2012, Pragmatic Works Factory, BIXpress.

Confidential

Database Specialist

Responsibilities:

• Executing the day-to-day database operations Installing, configuring, patching and administering the database servers.
• BCP, Power down Drill exercise every quarter.
• Support migration and upgrade of Databases.
• Day to Day database backup status check
• Upgrading non prod SQL Server patching
• Setting up Remedy replication
• SCOM Set up
• CAB Approval for database changes

Technology: Windows 2k,2k3,2k8, SQL Server 2005,2008, SSIS Packages, SQL 2005 Reporting Services

Confidential

Sr. SQL Server Developer/DBA

Responsibilities:

• Involved on Creating and Implementing Disaster Recovery Plan - best practices.
• Performance Monitoring - Log (Application,System,Security), Perfmon - Regular and Timely Fashion
• Advanced Statistics gathering of Memory, CPU, I/0, Hardware Failure, Application Bottleneck.
• Familiar with Log Parser 2.2 and Performance Analysis Log.
• Setting up and Maintaining Windows Cluster & SQL Clusters
• Setting up and maintaining Replication - Transactional & Snapshot across geographic locations.
• Creating and Running Maintenance Plans during Maintenance Window.
• Monitor and Resolve Job Failures (Debug stored Procedure if required).
• Replication monitoring.
• Running DTS/DTSX Packages for Failed Jobs
• Monitoring Backup/Restore (Refresh non production databases with production database)
• Resolving Drive Space issues
• Monitoring using wide range of Quest tools that includes Spotlight, Performance AnalysisSQL Watch,Benchmark Factory for Databases, Toad

Technology: Windows 2k,2k3,2k8, SQL Server 2005,2008, SSIS Packages, SQL 2005 Reporting Services, SQL Lite Speed

Confidential, SanFrancisco, CA

SQL Server Developer/ DBA

Responsibilities:

• Responsible for development of stored procedures, triggers and ETL scripts.
• Proactively monitor the Production Database and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.
• Ensure all database environments (Development, Staging, QA and Production) are in sync. Define db scripts versioning system to keep track of database versions for all environments.
• Ensure all database environments (Development, Staging, QA and Production) are in sync. Define db scripts versioning system to keep track of database versions for all environments.
• Provides application support for QA and Development groups.
• Participates in a rotating On-Call schedule.
• Ensuring the Physical and Logical Model are in synch with every release using Embarcadero ER Studio.

Technology: Windows 2000, SQL Server 2000, DTS Packages, Embarcadero ER Studio, SQL Data Compare, Toad for SQL Server 2000, Spot light for Monitoring.