SUMMARY

• MBA in Systems/IT, Oracle & AWS certified professional with over 12 years of work experience in IT.
• Experience in Amazon Web Services (AWS) provisioning and good knowledge of AWS services like EC2, S3, RDS, Aurora, Snowflakes, DMS, Lambda, VPC, Direct Connect, Route53, Cloud Watch, IAM, SNS etc.
• Experience in migrating Databases to cloud using DMS, GoldenGate, ETL, MyDumpper/MyLoader.
• Experience in Installation, Managing and upgrading large Oracle databases and version 9i,10g,11g,12c,18c and 19c on various platforms.
• Administrative experience in Oracle Exadata database machine administration, migration, health check, resource management, patching/upgrade and SQL tuning.
• Installing, configuring, administration, backup, recovery, designing, and troubleshooting MySQL, Mariadb, PostgreSQL, Oracle databases on AWS RDS and EC2.
• Applying patch sets and routine security patches, Security administration and user management.
• Installation, configuration, and administration of Data guard, Golden Gate, RAC and OEM.
• Application DBA experience in PostgreSQL PL/pgSQL, Oracle SQL, PL/SQL and Sql Server, MySQL involving db programming with stored procedures, triggers, functions, indexes, and packages.
• Experience with deploying configuration management and CI/CD services such as Ansible, Powershell, Jenkins, Docker, JIRA and CloudFormation.
• Programming experience in UNIX Shell Script.
• Worked in Agile environments with Scrum and Kanban and used Agile testing practices.
• Worked with Project and Defect management tools such as Rally, JIRA and HP Quality Center

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, VB, Unix Shell and Korn Script, Windows batch script, Windows Powershell.

Database Utilities: GoldenGate, RAC, Dataguard, OEM, RMAN, Datapump, Streams, Embarcadero, ASM, MySQL Enterprise backup, Sqldump, MyDumper/MyLoader

Tools: & Utilities: Putty, WinSCP, VNC viewer, Toad, SQL Developer, PowerBuilder9, Autosys, HPQualityCenter, Jira, Rally, Informatica, Workbench, MonYog, Nagios, SqlYog, PHPAdmin, BMC Patrol, ServiceNow, Github, SVN, Atlantis, Ansible, Docket, Jenkins, Cloudformation

RDBMS: Oracle, SQL Server, MySQL, MariaDB & PostgreSQL

Operating Systems: RHEL, Linux, UNIX, AIX, Windows 2000/XP/2008/2010

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Framingham, MA

Responsibilities:

• Provisioning aws infrastructure for databases and related services using Cloudformation.
• Deploying configuration management and CI/CD services such as Ansible, Powershell, Jenkins, JIRA and CloudFormation.
• Migration of Oracle databases from on premise to RDS and EC2 using GoldenGate and aws DMS.
• Data design components review, provided database tuning, monitoring database security, system performance and overall utilization.
• L2/L3 level support to the application teams during high risk issues (escalations) and within normal activities like code migration, Database recovery via RMAN, troubleshoots performance issues, export and import of tables/schemas among environments.

Environment: RHEL, AWS, DMS, Oracle 11g, 12c, 19c, GoldenGate, RMAN, RAC, SQL Tuning, PLSQL, Ansible, shell, JIRA, Service Now and Cloud Formation.

Senior Oracle DBA

Confidential, Irving Tx

Responsibilities:

• PostgreSQL Installation, Configuration, Migration, Upgrades and Patches of versions ranged from PostgreSQL 9.6 through 11.6.
• Migrating Oracle databases to AWS Aurora PostgreSQL RDS using AWS DMS service, pgloader and Oracle Golden Gate.
• Clone/Refresh PostgreSQL instances using pgdump and snapshots.
• Stored procedures, packages, and functions conversion from Oracle to PostgreSQL PL/pgSQL.
• Support developers for efficient SQL query and Identifying long running queries and optimizing. Setup/Maintenance of Test/Development/UAT Servers setup.
• Physical replication, backup, recovery, WAL archive setup/monitoring of multiple PostgreSQL databases.
• POC on xDB replication from Oracle to EDB Postgresql.
• Configuring third client softwares like pgadmin, DBeaver aws SCT and phppgadmin to access the database
• Automating custom scripts for vacuum at table and DB level.
• Create and maintain database replication on AWS RDS using GUI and CLI.

Environment: Aws aurora rds, Aws DMS, PostgreSQL 9.6/11.6, PL/pgSQL, pg dump, pgloader, fdw, pgadmin, DBeaver, ora2pg, Oracle 11g, 12c, GoldenGate and Shell scripting.

Senior Oracle DBA

Confidential, Orlando, FL

Responsibilities:

• Migrating Oracle databases to AWS Oracle/MySQL/MariaDB/PostgreSQL RDS and Aurora using AWS DMS service, Oracle Golden Gate and other tools.
• Migrating Oracle/MySQL databases to AWS RDS using AWS DMS.
• Configured and installation of AWS services such as EC2, S3, RDS.
• Architecting new DBA solutions in AWS.
• Converting schema from one DB engine to AWS RDS using AWS Schema Conversion Tool (SCT).
• Upgrade Oracle 11g /12c to 18c/19c databases on cloud and on - prem.
• Data Migration/REPLICATION-Extensively used ORACLE GOLDEN GATE and ORACLE DATAGUARD for data replication and protection. Also used Data pump, conventional export/import utilities for loading data to & from other databases.
• Configured Oracle Wallet for Encryption functions and involved in setting up Transparent Data Encryption for protecting sensitive data in the database.
• DR and HA solution setup with Fast Start Fail Over (FSFO) using Data Guard Broker
• Oracle database vault, Created Oracle Wallet, Enabling Transparent Data Encryption, Automatic Login Enabled for Transparent Data Encryption, Setting and Resetting the Master Key, Adding and Removing Salt from an Encrypted Columns, created encrypted table spaces and backup wallet
• MySQL andMariaDBinstallation and replication setup using MariaDB Max Scale.
• Upgrade and migration of MySQL and MariaDB databases to new versions.

Environment: RHEL, AWS, DMS, MariaDB, MySQL, Oracle 11g, 12c,18c, 19c, PostgreSQL, GoldenGate, OEM 13c, RMAN, RAC, SQL Tuning, PLSQL, TOAD, Atlantis, GitHub, MariaDB MaxScale.

Senior Database Engineer.

Confidential, Orlando, FL

Responsibilities:

• Expertise in Installation / Configuration / Performance Tuning / Trouble shooting Oracle Goldengate OGG in both homogeneous and heterogeneous environments including Oracle/MySQL/MsSQL to Oracle/MySQL/MariaDB
• Provisioning infrastructure for databases, server and VPC using Teraforms.
• Upgrade 11g/12c and migration of Oracle databases to new versions.
• Migrating servers (Database and Application) from on premise using Server Migration Service(SMS), Amazon Machine Image (AMI) and EC2.
• Monitoring and performance tuning of Oracle database through SQL and PL/SQL Tuning, TKProf, Explain Plan, tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor
• Performed bulk load of JSON data from s3 bucket to snowflakes.
• Oracle Apex and Logger installation and upgrading.
• Configuring high availability for GoldenGate instances.
• Migration of on premises Oracle Databases to Oracle/MySQL/MariaDB RDS.

Environment: RHEL, AWS, DMS, MariaDB, MySQL, Oracle 11g, 12c, GoldenGate, OEM 13c, RMAN, RAC, SQL Tuning, PLSQL, ASM, Apex, Oracle logger.

Senior Application DBA

Confidential, Hunt Valley, MD

Responsibilities:

• Responsible for the application schema (Capacity Planning, Tables, Views, Stored Procedures, Packages, Performance Tuning etc. specific to the application schema)
• Responsible for coordinating all requests to Database Shared Services for the development environment
• Responsibility to interface with Enterprise Database group and implement DB standards, ensure compliance to Data security and other applicable data standards
• Conduct Performance Tuning, Query Optimization initiatives and assist the team in troubleshooting and resolving performing related issues.
• Responsible for database MOD changes.
• Create, Implement and maintain all the Data Modeling changes for release management
• Expertise and Hands-on experience developing PL/SQL code as per the solution specifications
• Responsible for database capacity planning/space management/entitlement management of the schemas.
• Tune databases, applications, monitor performance of database servers, related processes CPU, memory, storage, and network.
• Through knowledge of Oracletools like OEM, RMAN, SQL Loader, AWR, ASH, ADDM, Flashback, SQL trace to perform daily jobs.
• Standby DB creation using Data Guard as per requirement for high availability.
• Upgrade 11g databases to 12c. Databases refresh activities as per requirements.
• Database Performance Tuning SQL Tuning for required applications.
• Automating data movement activities with Exp/Imp, Datapump, ETL techniques and Autosys.
• Providing DBA support to development teams and production support to the application.
• Develop and maintain backup and recovery strategy to provide reliable database as per database downtime and transactions.
• Space management & optimization space usage with Compression and Defragmentation.
• Develop UNIX shell scripts, Batch scripts, SQLs, PL/SQL procedures, functions, packages and triggers to support and automate repetitive task.
• Administration, Security, Troubleshooting and Support of MSSQL Server 2012.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration for MS-SQL server 2012.
• Design POC Mappings and help the ETL team on data acquisition techniques and loading strategies during the development phase.
• Query optimization and Fine tune the Informatica Mappings.
• Process to load the type 2 data from source (Oracle) to Dataware house data store using Golden gate.

Environment: RHEL, Unix, AIX, Oracle 11g, 12c, OEM 13c, RMAN, RAC, Datapump, GoldenGate,Putty, ETL, SQL Tuning, PLSQL, ASM, Exadata, MSSQL 2012, VNC and Python.

Senior Oracle DBA

Confidential, Irving, TX

Responsibilities:

• Installation and managing of Oracle 11g Databases on Linux and Windows environment.
• Implementing Backup strategy using Logical backups, Cold & Hot backups, and RMAN database backup.
• Database refresh with Oracle utilities like SQL*Loader, Export/Import, RMAN and DataPump.
• Incident handling from different databases and Applications.
• Monitoring of standby db and Golden Gate for ensuring business continuity & fixing lag issues.
• Support for Oracle streams, Golden Gate, Dataguard.
• Performance tuning with help of ADDM and ADDR reports.
• Identifying and fixing various ORA errors and raising SR to the Oracle support team as required.

Environment: RHEL, Unix Oracle 11g, RMAN, Datapump, Goldengate, Putty, SQL Tuning, ASM, BMC patrol

Oracle and MySQL Database administrator

Confidential

Responsibilities:

• Installation and configuration of Oracle ASM and non-ASM Databases (9i, 10g, 11g) on Linux.
• Managing Oracle EC2 and RDS cloud Instances.
• Up gradation of databases applying patches, patch sets
• Up-gradation of Oracle 9.2.0.6 later to 11R2 for production and non-production environments.
• Identifying Database performance issues and fixing them with help of AWR and ADDM reports.
• Ad-hoc Tasks (Collecting job listing / Assist AD team / Adhoc monitoring).
• Configuring of Oracle Streams and monitoring replication.
• PL-SQL coding and ETL with Oracle utilities like SQL*Loader, External tables.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations while coding a mapping.
• Worked with Informatica Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions.
• MySQL Installation, databases design, configuration, backup, recovery, security and tuning.
• MySQL backups using mysqldump and MySQL Enterprise Backup.
• Troubleshooting and fine-tuning of MySQL databases for its performance and concurrency
• MySQL processes, security management and queries optimization.
• User, privileges, security and database objects management with Workbench.
• Performed MySQL Replication, administration and monitoring with Monyog and Nagios.
• Assisted in designing, capacity planning, and security and accessibility functions of databases

Environment: RHEL, Unix, Windows, AWS RDS, Oracle 9i, 10g, 11g, RMAN, RAC, Datapump, Streams, MySQL5.5/5.6, MySQL Enterprise backup, MonYog, sqldump, Workbench, PHPAdmin, Putty, ETL, Informatica, SQL Tuning, PLSQL, Vncserver, WinSCP.

Database Administrator

Confidential, Irvine CA

Responsibilities:

• Automating backup jobs using shell scripting
• Progress Database Support on MFG/PRO ERP environment
• Dump/Load of Production databases

Environment: RHEL, Unix, Shell scripting, Progress database.

MIS Officer

Confidential

Responsibilities:

• Installation, configuration, administration Oracle DB and client on Windows, UNIX and Linux.
• DB administration, Backup, Space management, User Management and DB code deployment.
• ERP Functional support and troubleshooting technical issues related to application and data.

Environment: Linux, Windows, SQL, Oracle9i, ERP, Reporting.