SUMMARY:

• A SQL Server Database Administrator with over 6 years of experience with large - scale production environments across multiple platforms such as Windows Enterprise, Standard, Client and Server and ERP Applications. Capacity to give master level specialized technical support in all parts of database administration including installation, configuration, upgrades, patching, mirroring, clustering, replication, log shipping, always on, performance tuning, backup and recovery. Able to work both as an individual contributor and as a team player.
• 4+ years of experience in Database Administration databases in SQL Server 2012/2012R2, 2008/2008 R2, 2014.
• 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.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log Shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server 2008.
• Experience on 64bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experience on Data center servers and handling 1.4 TB databases.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support

Environment: RDBMS: SQL Server 2005, SQL Server 2008, SQL Server 2012. Enterprise Environments, Tuning with SQL Profiler, Clustering, SQL Server Integration Services.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012 enterprise, Windows Server 2003 Standard, Linux.

Tools: Backup Utility, SQL LiteSpeed, Visio.

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP.

ORACLE: Oracle 10g, 11g, 12C, Unix shell script, Grid Control, DataGuard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR and Statspack Reports, EXPDP/IMPDP, EXP/IMP, PL/SQL, RMAN, Crontab, Tivoli Storage Management for DB tape backups, BMC Patrol for DB monitoring, RHEL 4.4, HP-UX, 10g, and 11g, Oracle 10g/11g RAC, ASM, Data Guard, Oracle Enterprise Manager etc.

PROFESSIONAL EXPERIENCE:

SQL DBA

Confidential, Bloomington, IL

Responsibilities:

• Managed the migration of SQL Server 2008 databases to SQL Server 2012.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2012.
• Prepared the project management and technical documentation.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in performance monitoring and tuning of the database.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS.
• Analyze long running slow queries and tune the same to optimize application and system performance. set up SQL Server configuration settings for better server management.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Involved in backup and recovery tasks.
• Involved in disaster recovery planning.
• Implemented database backups and disaster recovery strategies. Developed technical documentation for disaster recovery.
• Work beyond regular hours based on business demands. Provided 24x7 on-call production supports.
• Conferred with coworkers to determine impact of data base changes on other systems and staff cost for making changes to data base.
• Modified data base programs to increase processing performance, referred to as performance tuning.

Environment: SQL Server 2008/2005, Window server 2012, .Net Framework 2.0, Windows 2000, Windows 2003 Server, MS-Access.

SQL DBA

Confidential, Milwaukee, WI

Responsibilities:

• Expertise in Always-On Availability Groups (AAG)
• Installed and configured SQL SERVER 2012 on Windows server 2012 enterprise.
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Three-Node Cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition.
• Expert in Using DMVs, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Involved in performance monitoring and tuning of the databases.
• Implemented database backups and disaster recovery strategies. Developed technical documentation for disaster recovery.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
• Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Window server Failover cluster 2012.

Position Oracle Database Administrator

Confidential, Charleston, IL

Responsibilities:

• Analyzed and tuned the Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.
• Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment.
• Oracle performance tuning support pack and Statspack, AWR, ASH, ADDM, RMAN, Oracle Universal Installer, OPatch and Patchset.
• Supporting data-guard (11g Active dataguard) for customer data service.
• RMAN backup and recovery strategy using incrementally updated image copy backup.
• AWR report generation and wait analysis for performance.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Applied necessary Patches during installation and also in up-gradation of databases on Oracle database versions 10g and 11g.
• Configured Dataguard broker between the primary and standby databases, perform Switchover/Failover and monitor the Dataguard status via DGMGRL and GUI.
• Implemented Backup and Recovery using RMAN, which includes hot backups and Cold backups to tape, drives, and disks.
• Involved in query optimization and using rule-based optimizers and cost-based optimizers.
• Performed database performance tuning, STATSPACK reports automation, stress test on production copy for scalability, resolving production performance issues.

Environment: Oracle 10.1.0.4/10.2.0.4/11 gR2, RHEL 5 and 6, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Shell Scripting, TOAD.