SUMMARY:

• Database professional with over 10+ Years of diverse IT experience and good domain knowledge in Banking and Financial Services, retail and manufacturing.
• Oracle Certified Professional having extensive knowledge on database administration for Oracle 9i, 10G, 11G and 12C with experience in very large - scale database environment and mission critical large OLTP and OLAP systems running on UNIX, Linux, Solaris & SQL Server MS Windows platforms.
• Proficient in Oracle 12c/11g/10g/9i/8i and SQL Server 2005/2008/2008 (R2)/2012/2014 Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation.
• Extensive knowledge and experience on High Availability technologies such as RAC, Data Guard, ASM, Database replication and Clusterware.
• Extensive experience in Database Migration to AWS cloud using DMS and Airflow and implementing backup strategies, monitoring DB on AWS.
• Extensive experience on RAC Clusterware installation using ASM, Configuration, administration and Patching.
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Expert knowledge on Golden Gate and SharePlex replication for conflict resolution using Active/Active replication.
• Proficient Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Expert knowledge of enterprise backup solutions such as RMAN & various media management systems.
• Experienced in installing, configuring and managing Oracle Enterprise Manager (OEM) grid and cloud (10g, 11G, 12C & 12C) for database monitoring/performance/diagnostics/job system.
• Experienced in RAC Databases, OEM upgrade and migrations.
• Expertise in Database Patching and Upgradation.
• Good knowledge on TDE, sensitive data encryption / decryption.
• Expert knowledge on migrating Database from MS SQL Server to Oracle Database, Oracle to MySQL, MySQL to Oracle, On-premise Oracle to RDS, EC2 Instance in AWS.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers, Shell scripting, Python scripting.
• Actively participated in several Oracle development projects consisting of design, testing and deployment into production communicating across various teams.
• Experience as On-Call 24x7 production DBA support, application/development DBA.

TECHNICAL SKILLS:

Databases: Oracle Database 9i, 10G, 11G, 12C, SQL Server 2005/2008/2008 (R 2)/2012/2014.

Tools: & Utilities: AWS, OEM 11G 12C &13C cloud, ASM, Dataguard, AWR, ADDM, ASSM, RMAN, Datapump, SharePlex, Spotlight for Oracle, MySQL Enterprise Monitor, SQL Developer, VictorOps, SolarWinds, Imperva, AppDynamics, TOAD, Putty, SQL Optimizer, NoMachine, ODU, DUL, JIRA, GIT HUB, Atlassian.

Languages: PL/SQL, PHP, HTML, CSS.

Scripting: Shell Scripting, Perl Scripting, JavaScript.

Operating Systems: Linux, UNIX, SOLARIS and Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Oldsmar, FL

Sr. Database Consultant

Responsibilities:

• Performed database Cloning to setup test and development database.
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Conducting sizing & capacity planning for Oracle databases.
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace.
• Installed and configured Oracle OEM to monitor the DB.
• Monitored the Performance of the migrated databases using grid Control and features AWR, ADDM, ASH and generated the reports for metric collection and health check of the databases.
• Provide administrative database security role by protecting the database, creating and managing users, restricting unwanted privileges and granting required roles.
• Scheduled Full and incremental backups in AWS.

Confidential, Oldsmar, FL

Sr. Database Consultant

Responsibilities:

• As a database engineer responsible for design, development, and implementation of AWS Cloud solutions to the client Confidential .
• Participate in planning, implementation, and growth of our customer's Amazon Web Services (AWS) foundational footprint.
• Performed proof of concept (POC) with application and architecture teams and implement the design in production environment in AWS.
• Worked with current application teams to understand current applications and make migration recommendations and to-be architectures in AWS.
• Migrated existing Oracle databases, OMS from on-premise to AWS RDS, EC2 instances and Redshift, PostgreSQL using various tools including DMS, Airflow- DAG, but not limited to AWS Data Migration Services and AWS Schema Conversion Tool.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Performed routine activities such as Query Optimization, Database Consistency monitoring.

Confidential, Tampa, FL

Sr. Database Administrator

Responsibilities:

• Primary DBA resource providing production support for high volume OLTP replicated (Golden Gate) database systems with large multi-terabyte data on Oracle (ASM) clustered and high availability (RAC) instances, physical standby Servers.
• Monitoring and support SQL Server 2005 & 2008 instances on Windows 2008 Servers.
• Involved with installation and maintenance of ORACLE 11g RAC/ORACLE 12Cg RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Responsible for installing, upgrading, patching and configuring the Oracle DB environment.
• Implemented Oracle Golden Gate replication between Data centers with unidirectional, bi-directional and peer to peer replication and created conflict resolution for multiple applications.
• Subsequently responsible for patching and upgrading multiple RAC and single node ASM instances to the latest releases.
• Performed routine activities such as Query Optimization, Database Consistency monitoring, configured and managed replication Server.
• Creating application Database Data modelling using Erwin tool.
• Routinely provided DBA support for in house software development and implementations and promoting into SQA, UAT & production.
• Migrated MS-SQL Server to Oracle and MySQL to Oracle DB successfully.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.
• Responsibility include participation in a 24 x 7 on-call production support rotation.

Confidential

Database Administrator

Responsibilities:

• Primary DBA assigned to a large multi-terabyte data warehouse RAC environment project.
• Daily task include administration, support & development enhancements for production, QA and development Linux/Oracle 10g RAC database and Linux/MySQL.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Project work included installation, configuration & deployment of several additional RAC instances.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Designed databases for referential integrity and involved in logical design plan.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Developed stored procedures, triggers in MySQL for lowering traffic between Servers & clients.
• Managing database clustering on NDB technology.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and Windows and block/unblock remote access to MySQL Server.
• Successfully upgraded/patched multiple Oracle database instances from 9i to 10g & 10g to 11g.
• Development contributions: design, testing and implementation of database objects (tables, indexes, triggers, views, synonyms, views, etc.) and PL/SQL code.
• Routinely performed database cloning/refresh, Shareplex support, and code migration through development landscape into production environments.
• Conducted daily maintenance and support tasks such cluster administration, performance tuning, patch application and tablespace management.
• Automated nightly administration jobs such as RMAN Backups, data pump exports, alert log error reports; external data loads with SQL Loader scripts as well as monitoring of listeners and other critical process running on multiple database instances using UNIX shell scripts.
• Execution of SQL queries to monitor usage and performance.
• Extensive user support which includes creation of users, granting privileges, roles, helping in troubleshooting SQL queries.
• Implemented advanced Oracle technologies and strategies such as TDE tablespace level encryption, tablespace management with compression & big files as well as other latest 11g features available.
• Designed, tuned and optimized the RMAN backup strategy for multi-terabyte data warehouse utilizing FRA, incremental schedules, parallel & data compression.
• Other duties included participation in a 24 X 7 on-call product support rotation for over 100 databases with various configurations and releases of Oracle including RAC, ASM, Standby DR Servers, OMS Grid and RMAN repositories.