SUMMARY

• 9 years of experience as Database Administrator with Implementation and Production\Application Support for critical application in a 24x7 OLTP environment.
• Experienced in Installation, Configuration, Maintenance and Administration of SQL Server 2012, 2008R2, 2008, 2005 and 2000 in standalone and clustered environments.
• Migrate and upgrade from SQL Server 2000\2005 to SQL Server 2008\ 2008R2\2012
• Expertise in implementing efficient Disaster Recovery Strategies and High availability include Always On, Replication Clustering, Log shipping and Database Mirroring.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, Trace flags, Extended Events and other related monitoring and troubleshooting tools.
• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, network, disk space issues and other resource contention
• Intensive experience in monitoring and tuning SQL Server database performance using DBCC, DMV’s and Index Tuning Wizard.
• Experience in configure backup strategy and in case of database failure, to recovery the database point in time.
• Closely worked with development teams to assist them in various performance issue, problems solving and troubleshooting
• Web - based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Experience in Database Security and Management.
• Experience in Service Packs, Security Patches & Hot fixes install and management i.e schedule-install
• Having good experience in SQL Azure admin and configuration.
• Expertise in Transaction isolation level and solving database contention problems (dead locks and blocking etc)
• SQL Server 2008R2/2012 profiling with Dynamic Management Views in both Server-scoped DMV and Database-scoped DMV.
• Good experience on resolving performance tuning include query and server optimization, monitoring the growth of the database to ensure the smooth running of daily activities
• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Worked with Tivoli Data Protection and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008R2.
• Experience in trouble shooting SQL server jobs, and job monitoring tool, Experience in creating Jobs, Alerts, Database Mail configuration and scheduling DTS and SSIS, SSRS Packages
• Created maintenance plans to perform Index De-Fragmentation, Re-Indexing and update the Index Statistics
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• 24 X 7 Production Database On Call Support.

TECHNICAL SKILLS

RDBMS Software and Tools: MS SQL Server 2000, 2005, 2008, 2008 R2 and 2012, T-Sql, SSIS, SSRS, Profiler, Query Analyzer, Sybase 11, Sybase 12.5, Oracle 9i, 10g, 11i, Ms-Access.

Hardware/Operating Systems: Windows NT, Windows 2000, 2003, 2008, 2008 R2 and 2012 server, UNIX, AIX 4.3.x, Solaris, HP-UX 11.0 and 11i, SAN.

Development Languages: Active Server Pages (ASP), ASP.NET, VB.NET, C#.Net, Visual Studio, Internet Information Server (IIS 6.0), VBScript, Visual Source Safe, Crystal Reports, Red Gate, Erwin, Visio

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Lead SQL DBA

Responsibilities:

• Worked as Sr. DBA in Production and Implementation of Confidential, Maintaining 500+ Production, UAT and Development Servers, databases size including VLDB’s.
• Involved in the application build ability meetings and Understanding the business requirements Building PROD, UAT and Development servers accordingly.
• Installation of SQL Server 2012\2008 R2 and DB migration from SQL 2005\2008 to SQL server 2008 R2\2012
• Maintain MS SQL Server 2005\2008 R2\2012, including security, server configuration and install service packs upgrades
• Configured, maintained and administrated SQL Azure.
• Configure, monitor and troubleshoot efficient Disaster Recovery Strategies and High availability solutions include Clustering, Log shipping and Database Mirroring.
• Configure and monitor Transaction and merge Replication, resolved critical issues.
• Configuration and Maintaining as part of a team SLA’s, analyzed the different high availability solutions and implemented database log shipping, mirroring and replication.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification, replication verification, and indexing updates.
• Implement and maintain database security include create and maintain logins, users, roles, assign privileges
• Excellent experience in writing Power Shell scripts and executing on remote servers.
• Having good experience in configure backups, restore and DB refresh by using Power Shell
• Performance Monitoring using SQL Profiler, Performance Monitor, planning for CPU and Disk space requirements and db maintenance and optimization using DBCC commands.
• Experience on Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• SQL Server 2008R2/2012 profiling with Dynamic Management Views in both Server-scoped DMV and Database-scoped DMV.
• Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts.
• Worked as a 3rd line Production DBA Support and Provide 24X7 On Call Support analyzing database metrics and assisting with capacity planning
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions
• As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks
• MS SQL Server database administration, configure Scheduled Tasks for regular Database Backup and Maintenance Activities.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Troubleshooting of site issues, DB Performance issues and long running queries.
• Planning, implementation and support of database backup, database recovery and disaster recovery policies of databases in a highly availability environment.

Environment: SQL Server 2012/2008 R2/2005, Windows 2K/2003/2008 R2/2012, SQL Profiler, Spotlight,, SSIS 2012/2008R2, SSRS 2012/2008 R2, IIS 6.0, Erwin, Sybase 12.5 ASE, Oracle 10g, 11i.

Confidential, Jacksonville, FL

Sr. SQL Database Administrator

Responsibilities:

• Worked as Sr. DBA in Production and Implementation of SDMS, Maintaining 200+ Production, UAT and Development Servers, databases size including 5TB VLDB’s.
• Gathering and Understanding the business requirements (Hardware and Software), Building PROD, UAT and Development servers accordingly.
• Expert Experience in Database Architecture.
• Installation of SQL Server 2012\2008 R2\2008\2005 and its configuration and DB migration from SQL 2000\2005 to SQL server 2008 R2\2012
• Maintain MS SQL Server 2005\2008 R2\2012, including security, configuration and install service packs upgrades.
• Configure, monitor and troubleshoot SQL 2012 Always on High Availability in between the data centres.
• Implement and maintain database security(create and maintain logins, users, roles, assign privileges)
• Involved in Disaster Recovery test.
• Eexpertise in production change management process and resolving production issues as per ticketing priority
• Configure and monitor Transaction with multiple subscribers and merge Replication, resolved critical issues.
• Proactively configure and monitoring of live site production databases in Microsoft clustered environment.
• Configured, monitor and troubleshoot efficient Disaster Recovery Strategies and High availability solutions include Clustering, Log shipping and Database Mirroring
• Configuration and Maintaining as part of a team SLA’s, analyzed the different high availability solutions and implemented database log shipping, mirroring and replication.
• Experience on Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions
• As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks
• MS SQL Server database administration, configure Scheduled Tasks for regular Database Backup and Maintenance Activities.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Troubleshooting of site issues, DB Performance issues and long running queries.
• Planning, implementation and support of database backup, database recovery and disaster recovery policies of databases in a highly availability environment.
• Performance Monitoring using SQL Profiler, Performance Monitor, planning for CPU and Disk space requirements and db maintenance and optimization using DBCC commands.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• On Call support for 24X7.

Environment: SQL Server 2012/2008 R2/2005/2000, Windows 2K/2003/2008 R2, SQL Profiler, Tivoli, BMC Patrol, SQL Nexus, SSIS 2005/2008 R2/2012, SSRS 2005/2008 R2/2012.

Confidential, Jacksonville, FL.

Sr. SQL DBA

Responsibilities:

• Sr. Production Database Administrator.
• Taking care of 300 servers for SQL Server 2000, 2005 and 2008.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures.
• As part of a team, analyzed the different high availability solutions and implemented database mirroring and replication.
• Migrating the database from SQL Server 2000 and R2
• As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks
• Established and wrote Performance Tuning guidelines to enhance quality of our product for all current and future code development.
• Configure and monitor Transaction with multiple subscribers and merge Replication, resolved critical issues.
• Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts.
• Redesigned a thorough backup and recovery strategy for all major production systems.
• Upgraded all SQL Server 2000 to SQL Server 2005 and 2008 without service interruption
• Responsible for logical and physical design with a significant effort towards application and database tuning.
• Major activities include advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards.
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plan and Index tuning.
• To set up SQL Server configuration settings.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs.
• Using log shipping for synchronization of database.
• Created and developed the stored procedures, triggers to handle complex business rules and audit analysis.
• Monitoring the servers using spot light third party Quest software.
• Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Environment: SQL Server 2000, 2005 and 2008. Windows 2K\2003\2008 Data Center, SQL Profiler, LiteSpeed Backup software, Reporting Services

Confidential

DB Admin

Responsibilities:

• Monitored all production SQL Server Databases.
• Responsible for database creation, database tuning, performance planning and database administration
• Monitored and managed transactional and snapshot Replication.
• Created stored procedures, scripts, and cursors for the Bulk application, testing on the test servers and moving them to production.
• Managed Disk space, memory and User connections.
• Experience in Database Backup and recovery -- worked on different DR strategies with Log shipping, Replication and Clustering.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Gathered and analyzed specifications, created custom Business Intelligence reports written in SQL Server Reporting Services against a SQL Server data warehouse.
• Created Tables, Views and Functions using T-SQL.
• Monitored and modified Performance using execution plans and Index tuning.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Created and managed user accounts and tracked user activities as and when required.
• Created and optimized Clustered and Non Clustered Indexes.

Environment: Windows Server 2000,SQL Server 2000, ASP.Net, ADO.Net, VB.Net, VB 6.0, Visual Studio 2005, Internet Information Server, Oracle.