Summary

• me am an enthusiastic technology professional wif in - depth experience as an oracle database administrator.
• me has supported thousands of users on both development and production environments.
• me am very comfortable working on Oracle database versions 10g, 11g, 12c, 18c and 19c as well as open-source database such as MariaDB, MySQL etc.
• Some areas of my specialization include Installation and configuration, database upgrades and patches, backup and recovery
• Performance tuning, security, database cross-platform migrations, RAC, Dataguard and Golden Gate, PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential - Malvern, PA

Database Administrator

Responsibilities:

• Installation of oracle 11g and 12c 18c and 19c databases in production, development and test environments on Windows servers (2008, 2012, 2016)
• Created and Maintained Physical standby databases for production and UAT environments
• Migrated databases from prem to the newly AWS environment
• Applied maintenance and interim (Opatch) patches ((Windows Bundle & Java) on all the databases
• Successfully upgraded and migrated 11g databases to 12c release 2 using data pump
• Performed QA and UAT deployments in regular basics using tools like Jenkins, SourceTree.
• Monitored database growth such as tablespace size, free space, extend allocation using manual scripts
• Scheduled backups through windows job using task scheduler
• Provided DBA support for production deployment
• Installed and monitored MariaDB databases on Unix based server (Ubuntu)
• Performed backups of MariaDB databases using MySqldump
• Set up MariaDB Master-Slave replication
• Performed storage reengineering of entire databases from DEV to PROD by moving actual datafiles into big file tablespaces
• Performed various tuning procedures using all the Oracle tuning tools (SQL Tuning Advisor, Explain Plan etc.…)
• Migrated and upgraded 12c databases to 18c and 19c in newly allocated servers using data pump and GoldenGate when no downtime required
• Refreshed DEV, QA and UAT databases from Production data
• Experience wif Oracle applications like PeopleSoft, E-Business Suite (EBS) etc...
• Assisted dev team on testing, monitoring, tuning and deploying our in-house application Appworks

Confidential - Richmond, VA

Oracle Database Administrator

Responsibilities:

• Installation of oracle 11g, 12c, 18c and 19c databases in production, development and test environments depending on project requirements.
• Oracle HA Stack: Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications.
• Configured and Managing Oracle 11gR2 Data Guard (Active Physical Standby on 2 nodes RAC)
• Design and Maintaining Physical standby maintenance (Switch over - using Data Guard Broker).
• Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data guard (DG Broker), Stage and Dev systems
• Upgrade DBs from 11.2.0.4 to 12.1. From 12c to 18c and 19c. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Applying upgrade patches, maintenance and interim (Opatch) patches on all the databases.
• Refreshing Dev and Test instances wif data from Production on a regular basis.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Experience wif Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked wif conventional EXP/IMP for migrating data from 10G to 12c.
• Scheduled RMAN backups, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts) using OEM
• Monitored and troubleshooted database issues wif OEM grid control.
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site
• Very comfortable in using ASM for creating disk groups, adding additional storage (Disks) and troubleshooting ASM issues.
• Setup the unidirectional replication on oracle 11g databases using Goldengate.
• Monitoring and troubleshooting the gaps between source and target databases configured wif Goldengate.
• Successfully upgraded the databases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Configuration of Listener and Tnsnames.
• Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Windows, Linux Red hat)
• Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 2 nodes RAC architecture in development and UAT running oracle.
• Experience in designing and configuring high-availability systems using Data Guard wif physical standby effectively configured and used Data Guard Broker utility.
• Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Performed logical backups using Export/Import and Data Pump
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction
• Performance Tuning of SQL statements and Database Tuning using tools like Explain plan, SQL Analyze, ADDM, AWR reports etc.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage. Debugging SQL tuning
• Plan for contingency, disaster management that includes standby databases, data guard and cloning/refresh of the databases
• Administered databases of various sizes from 200GB to 6TB
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
• Designed Logical and physical database for business transaction functionality.
• Provide production support for the deployed project till it is stabilized.

Confidential - Lexington, MA

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 12.1.0.2, 12.2.0 databases on Linux platform.
• Successfully performed migrations from Oracle 11g/12c to 11gR2 RAC (Real Application) Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2, 12cR2.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 11gR2.
• Migrated and upgraded single instance database to multiple instance databases using export/import, data pump.
• Configure Data Guard on both standby and primary for 15 production databases.
• Fail over and switch over between standby and primary databases.
• Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Experience in working wif virtual machine and oracle virtual machine (OVM).
• Experience in migrating from multiple Oracle 11gR2 database to oracle 12cR1 on virtual machine.
• Hands-on experience in taking snapshots and rebooting the server's and performance monitoring for Oracle databases in virtual machines.
• Experience in adding and expanding the disk volumes to oracle serves on virtual machines.
• Experience in installing oracle software and creating standalone databases on virtual machines.
• Hands-on experience in working wif virtual machine under different operating system like Linux, sun Solaris and windows.
• Experience in configuration and administration of Data Guard (Physical/Logical standby Databases).
• Setup RMAN solutions for all Oracle Databases -- provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Implemented and maintained Oracle 11g, 12c Data Guard/standby databases for switch-over and fail-over purposes.
• Experience in Implementation of High Availability solutions wif Oracle 10g,11g and 12c RAC, Physical Standby Databases (Data Guard). Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Applied patches 11.2.0.1 and 11.2.0.3, 10.2.0.4.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.