Senior SQL Server DBA, Application Support Resume Irving, TX - Hire IT People

SUMMARY:

An enthusiastic technology professional with over 12.8 years of experience into SQL Server Database Administration, Application Support, Data analysis and Business Intelligence development.
Self - learner with excellent verbal and written communication skills
Good understanding of data management, logical and physical database design, ITIL Framework
Good analytical ability and can work either as an independent contributor or in a team oriented environment
Successfully performed data migration from SQL 2008 to SQL 2012 with minimal downtime
Played key role in procuring infrastructure for application upgrade
Carried out infrastructure upgrade from SQL 7.0/2000 to SQL 2005 environment
Automated various daily/weekly reports resulting in overall productivity improvements
Setup automated processing of data feeds; thus saving manual efforts
Designed key metrics for compliance tracking
Designed auto-reconciliation solution for the client resulting in tremendous cost savings
Created ITSM documents for Project Compliance
Enhanced SQL Procedures that helped in overall application performance
Team management - maintaining work load balance between team members, assigning tasks and responsibilities, addressing technical issues/concerns and providing technical training

WORK EXPERIENCE:

Confidential, Irving, TX

Senior SQL Server DBA, Application Support

Responsibilities:

Application DBA responsible for management of application databases
Creating Business Requirement documents for Application enhancements
Setting up high availability of databases using Database Mirroring
Interface with the customers to gather requirements and implement solutions to deliver the same.
Strategy and project planning for infrastructure upgrade/migration
Designing of stored procedures, functions, and other database objects to meet the business requirements
Setting up ETL processes to load/process data from different systems using SSIS.
Performance tuning using tools likes SQL Server Tuning Advisor, SQL Server Profiler, and Performance Monitor etc.
Project tracking using Microsoft Project (MPP)
Implementation of ITIL processes including Change Management, Incident Management and Problem management using ServiceNow.
Implement and maintain database backup and disaster recovery plan.

Confidential

Senior Database Developer

Responsibilities:

Confidential

Project Lead, Senior SQL Server DBA

Responsibilities:

Application DBA responsible for management of application databases
Setting up high availability of databases using Database Mirroring
Implement and maintain database backup and disaster recovery plan
Participate in annual COB tests to ensure Disaster Recovery readiness
Performance tuning using tools likes SQL Server Tuning Advisor, SQL Server Profiler, Query execution plans, etc.
Setting up various database jobs using SQL Server Agent and troubleshooting in case of any issues
Installation of SQL Server in Production, UAT and Development environments
Designing and deploying SSIS packages that are used for generating client reports, loading data feeds, etc.
Writing SQL Stored procedures to meet business requirements

Confidential

SQL Server DBA, Application Support

Responsibilities:

Involved extensively in creating and managing replication across different SQL servers
Involved in migration of databases from SQL Server 7 and 2000 to SQL Server 2005
Designing SQL Stored procedures using T-SQL as per the business requirements
Create, deploy, monitor and troubleshoot SQL Server Agent Jobs
Detailed analysis of the requirements and preparation of Analysis & Design documents
Version control using various software's like PVCS, Microsoft Visual Source Safe
Release Management - Deploying reports and various releases to the UAT and PROD environment