SUMMARY

• More than 10+ years of experience of handling multiple RDBMS including Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008/2012 & MySQL 5.1/5.5 in some of the most progressive organizations in Apparel, IT & Telecommunication sector.
• Track record of technical knowledge and expertise to effectively carry out all the database related activities such as Business Intelligence & Database Administration.
• Successfully Migrated Oracle 10gR2 database from HP - Unix to REL5.7.
• Upgraded & Patched Oracle databases from 10g to 11g.
• Cloned Oracle Applications 11.5 single tier to multitier.
• In depth experience in Oracle DBA technology with RMAN, Dataguard, RAC and OEM 10g /11g /12c.
• Provided 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/Veritas/Data-Protector, trace analysis, service creation, and cluster and system management.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Implemented Always-ON (AAG) on SQL Server .
• Excellent T-SQL / PLSQL Programming skills, Execution Plan, query optimization & performance tuning. Used SQL Profiler, Performance Monitor and DBCC Commands.
• Developed Transact-SQL / PowerShell scripts for system monitoring and maintenance.
• Benchmark level expertise in gather, finalizing the user requirement, logical and physical modeling of the desired system, implementation, managing system and performance tuning of the production system.
• Successfully Replicated Non-Oracle databases with Oracle using Oracle GoldenGate 11.
• Configuring and installing SQL Server 2014 on Microsoft Azure.
• Deployment and Maintenance of Dynamics AX databases hosting in Azure cloud using SQL Server
• Development of monitoring scripts using Nagios

TECHNICAL SKILLS

Database: Oracle 9i/ 10g/ 11g/ 12c, MySQL 5.1/5.5, Microsoft SQLServer

Operating System: UNIX, LINUX, Windows Server 2003/2008/2012

Languages: PL/SQL, T-SQL, LINUX Shell Scripting, Windows PowerShell, Microsoft Visual Studio 6.

Tools: / other Software: Quest Toad 11, Quest Data Modeler, Oracle Golden-Gate 11g, SQL Developer, NaviCat, Toad, ER/Win, Visio, SQLServer Migration Assistant Oracle Enterprise Manager 11g Grid Control

Hardware: IBM, INTEL, HP

PROFESSIONAL EXPERIENCE

Confidential - Vernon, CA

Sr. Database Administrator

RESPONSIBILITIES:

• Fully participated in Azure IAAS implementation for Confidential LLC.
• Implemented SQL Server 2014 Failover clustering for ACTIVE-ACTIVE using Always-On feature
• Created database Maintenance Plans, SQL Server Jobs and deployed custom maintenance scripts to schedule regular DBA tasks for enhancing the performance of SQL Server. Some of these tasks included Database Integrity checks and Re-Indexing, Updating Statistics, Full and Transactional Log Backups and DBCC Cleanup.
• Single handedly migrated & implemented SQL databases to Azure.
• Scheduled database backups on Azure Online Blob Container for offsite backup.
• Worked with BI team to deploy Integration packages, cubes and SSRS reports.
• Responsible to monitor & administrate the whole SQL databases infrastructure.
• Established fully functional monitoring setup using T-SQL / SQL Mail services / PowerShell scripts.
• Migrated all databases SQL Server to Azure Cloud services.

Confidential - Chesterfield, MO

Sr. Database Administrator

Responsibilities:

• Installation & Configuration of SQL Server 2012
• Created, Configure & Monitored Always-On using Asynchronous-commit mode for SQL Server 2012
• Created off-site DR instance using Always-On Asynchronous-commit mode.
• Performance Tune of long running sessions
• Used SSIS packages to transfer data from Oracle to SQL Server 2012.
• Created fully automated plan to migrate data from legacy Oracle database to SQL Server 2012.
• Follow the best practices for SQL Server to configure database instances
• Backup & Restore SQL Server databases
• Automated monitoring scripts to check different performance & instance availability stats
• Created & tested DR site for SQL Server 2012 with the help of Always On feature

Confidential

Oracle Database Administrator & Consultant

Responsibilities:

• Provide technical support on 24x7
• Analyze system requirements
• Document SOPs need to follow while migration
• Migrated databases using Transportable feature of Oracle databases
• Tested all interfaces and connectivity issues for newly deployed databases

Confidential

Oracle Database Administrator & Consultant

Responsibilities:

• Provide technical support on 24x7
• Analyze system requirements
• Document SOPs need to follow while migration
• Created reports as per user requirements
• Created interactive executive dashboards
• Performance Tuned long running reports
• Restructured old reports with new and improved performance and layout.
• Tested all interfaces and connectivity issues for newly deployed databases

Confidential

Oracle Database Administrator & Consultant

Responsibilities:

• Provide technical support on 24x7
• Analyze system requirements
• Document SOPs need to follow while migration
• Up-graded databases using Oracle Upgrade Assistant.
• Tested all interfaces and connectivity issues for newly deployed databases

Confidential

Team Lead, SQL Server DBA

Responsibilities:

• Provide any kind of technical support 24/7.
• Administrated multiple type MS SQL Server Relational and Warehouse Databases ranging above large Gigabytes.
• Automated the backup / maintenance tasks using SQL Server agent services.
• Analyze client requirements, estimate that, design that, assign appropriate resource(s) for further development.
• MS SQL Server Installations, MS SQL Service Administration Windows Platforms.
• Data Warehousing and Data Mart Databases Support, SSIS / SSRS deployments, Processing of Cubes.
• Reporting, Querying, Exporting, Importing and monitoring data integrity of several large Multi-User (100+) databases.

Confidential

Sr. Database Administrator

Responsibilities:

• Planning of DRP (Disaster Recovery Plan) for all databases.
• Design & implement Database structure & flow.
• Forecast storage of existing & newly deployed Databases
• Managing Cloning, Backups for Prod, Dev, Test Environments.
• Patching Apps 11i/DB with Adadmin, Adpatch, Opatch and Autoconfig.
• Troubleshooting Concurrent programs and Oracle application issues.
• Designed, implemented and supported highly available RAC clusters for companywide single sign on application, as well as other database solutions using advanced replication and standby (data guard) options.
• Provided Oracle RAC consulting and engineering to internal organizations for planned implementations and migrations. Consulting included designing backup solutions (using RMAN), disaster recovery plans, and performance tuning advice for RAC implementations.
• Engineering, implemented, documented and support builds of new clusters to use Oracle 10g RAC on HP-UX and Linux. Including installing clusterware, ASM (and shared disks) and creating new databases.
• Fine tune database performance for web & desktop applications.
• Refresh the database from production to test environment. Database backups and recovery
• In-house development for billing operations management
• Data extraction and load operations using SQL*Loader and PL-SQL Packages.
• DBA member of Change Decision Team, responsible for providing input for all change requests and approve or disapprove them based on the input and suggest alternate design.
• Database backups through RMAN, responsible for restoring data from backups in case of corruption.
• Established mediation layers and developed parsers, loaders, process monitors to send alarms through SMS and emails to concerns, rules etc.
• Took part in failover testing for clustered systems.
• Successfully migrated oracle database from 9i to 10g.
• Successfully patched many databases 9i/10g & SQL Server 2000/2005.