SUMMARY

• 13 years of experience as Oracle Database Administrator having experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 10g, 11g, 12c, 18c and 19c with experience within large scale database environment and mission critical large systems on Linux Environment.
• Migration of on - prem databases from on-prem to AWS cloud EC2 Servers and RDS databases.
• Split up the server using AWS AMI and cloning the server using EBS volumes snapshots in AWS cloud.
• ASM volumes consolidation and EC2 instance type changes for Prod servers for better performance.
• Expertise in upgrading the databases from Oracle 11gR2 to 19c, Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c and oracle 19c for standalone databases and also RAC databases including production with standby configuration.
• Migration of old 10g databases from on-prem cluster (red hat 5) to Nutanix cluster with new Red hat version 7.9
• Testing, designing and implementation of Oracle Secure backup by setting up RMAN backups from OEM directly to AWS S3 bucket.
• Good working experience with 12c Container databases or Pluggable Databases (PDBs).
• 24*7 production database support with Support to developers & end-users.
• Expertise in maintaining Oracle security using Auditing.
• Installed and cloned Oracle GI and ASM 19c software with ASM File systems.
• Experienced in Installation of high availability RAC environment (2, 3 node clusters) and upgraded standalone databases to 11g RAC environment.
• Experienced in implementation of Qlik Attunity for replication purpose between databases.
• Migrated Non-ASM database to ASM database for Oracle databases.
• Experience with High Availability features (RAC/ DG/ ASM / RMAN).
• Excellent knowledge in logical backups,Hot/Cold Backup and Recoveryand Cloning of databases usingRMAN.
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Good exposure to oracle technologies like AWR, ASM, ADDM, SQLT, Flashback, Transportable tablespace and data pump import/export.
• Experience in implementing Golden Gate 12c (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
• Proficient in setting up Standby Database using RMAN utility, activating and Re-building physical Standby Databases using SCN based backup and recovery.
• Managed very large database (VLDB) of maximum size 65 TB with 2 standby databases in different AWS different region and different availability zone.
• Having hands on experience in installing, upgrading and configuration of Enterprise Manager Cloud Control 13c.
• Experience in Identifying performance bottlenecks on high volume transaction systems, Analyzing SQL statements, reorganize database objects and design indexes to improve response of queries, tuning heavy data loads, Monitoring and Performance tuning.
• Having good knowledge on stored procedures, functions, triggers and scheduled jobs. Worked closely with application teams for the production installs and also work on the regular maintenances for database upgrades/migrates, security patches and OS related patches.
• License consolidation for Oracle environment by decommissioning databases, consolidating the databases, analyzing the database CPU utilization.
• Experience in applying Quarterly security patches (Both CPU and PSU patches) to the databases for fixing the bugs.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Supporting DR testing using switchover/Switchback, also with Flashback technology.
• Good interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service-oriented attitude. A very good team player, self-motivated, dedicated in any work environment.
• Familiarity with SOX controls and audits.
• Good knowledge in shell scripting and tools like Ansible for automation.
• Working experience in CI/CD GitHub, Jenkins, AWS Cloud Formation templates (CFTs), AWS VPC, AWS security groups, EC2, Postgress SQL/MySQL/Oracle RDS, Aurora database, AWS AMI, parameter groups, etc.
• Experience in data modeling using ERWIN tool

TECHNICAL SKILLS

Databases: Oracle 19c, 12c, 11g, 10g, 9i

Oracle Products: Golden gate, Oracle (Grid Control), OEM (Oracle Enterprise Manager), RMAN, SQL*Loader, DATA PUMP, ASM, RAC, OSB

Programming Languages: SQL, PL/SQL, C, C++

Operating systems: OEL, RHEL, AIX, Solaris

Other Tools: TOAD, Putty, SQL developer, Ansible

PROFESSIONAL EXPERIENCE

Confidential, Texas

Lead Oracle DBA

Responsibilities:

• Working on Oracle databases 10g,11g, 12c and 19c (including RAC) and managing different size databases including terabytes size databases.
• Lead Migration project of Oracle databases to AWS. Performed migrations of databases from on-prem to AWS cloud using different strategies.
• Planning, coordinating and performing the Upgrades from 11g to 19c. for both standalone and RAC environment.
• Created Ansible scripts to automate upgrades for oracle databases from 11g to 19c.
• Performed Quarterly Security patching to be proactive for the bug fixes including security bug fixes.
• Oracle License consolidation for reducing the license cost by consolidating the servers and changing the EC2 server instance types from r4 to r5 for better performance.
• Implemented Oracle Secure backup to take the RMAN backups to send them to S3 bucket directly bypassing the storage gateways to reduce the cost and performance improvement.
• Upgraded central monitoring system, Oracle Enterprise Manager (OEM) to 13.4 from 13.2
• Performed moving the selective databases from one EC2 server to another EC2 server using AWS snapshots and AWS AMI to reduce the load on one EC2 server.
• Worked on migrating databases to AWS Oracle RDS instances using Export/Import data pump tool.
• Performed Data guard configuration for Mission Critical databases across region and across Availability zone.
• Performed Goldengate configuration for Oracle databases for continuous replication of data as per the App team requirements.
• Evaluating Qlik Attunity for replacing Goldengate for replication purpose in POC environment.
• Refreshed selective schemas in RDS database from Prod database in EC2 server using export Import Data pump.
• Used AWS CFT for creating new EC2 servers for migrations
• Performed migrations by setting up standby database to reduce the downtime based on the size and criticality of database.
• Performed Configuration of EC2 server, ASM, databases, Goldengate after cloning to a new EC2 from another EC2 server as part of OS upgrade project. Analyzing the EBS volumes utilization.
• Troubleshooting the database performance issues using OEM, ADDM, SQL profile, indexes, statistics, etc.
• Addressing oracle vulnerabilities from scan report like rpm updates, listener port, etc.
• Created and Upgraded Postgress SQL/Oracle RDS databases to latest versions. Supported the regular tasks like adding database objects, pgdump export import of the data for refreshes, etc.

Environment: Oracle Database Version 19C/12C/11g/10g, RMAN, Data guard, RAC, ASM, Oracle Enterprise Manager Grid Control 13c, Goldengate 12c.

Confidential, Texas

Production Support Engineer

Responsibilities:

• Worked on Oracle databases 11gR2.
• Performed User level Datapump exports as a backup of schemas and imported them as per the requirement.
• Worked on switchover database to the physical standby database as part of DR testing.
• Cloned database using duplicate from active database in 11g.
• Applied one-off patches to oracle databases 11g to fix bugs.
• Performed Golden gate replication for unidirectional on oracle database 11g.
• Configured Goldengate processes Extract/Datapump/Replicate for the golden gate replication.
• Performed standby database sync with Primary database in data guard using incremental backup using SCN.
• Monitoring and adding disk space to primary and standby database when required
• Used Oracle Enterprise Manager Cloud Control 12c to monitor the databases and performance.
• Performed point in time recovery using RMAN full/incremental backups for database.
• Worked on tickets for user maintenance and any error messages.
• Created users and assigned/modified the privileges for users as per the requirement.
• Worked on Incidents and service now tickets as part of Ops Support.
• Analyzed and performed recovery of corrupted blocks in the database.
• Configured oracle RMAN backups for level0/Level1/Archivelog backups for the productions databases.
• Provided required admin support to the App teams.

Environment: Oracle Database Version 11g, RMAN, Data guard, RAC, ASM, Oracle Enterprise Manager Grid Control 12c, Shell Scripting, Goldengate.

Confidential, Ohio

Oracle Database Administrator

Responsibilities:

• Worked on Oracle 10g/11g databases on HP-UX platform.
• Resolved the block corruptions in 11gR2UAT/TEST databases by skipping the corrupt blocks.
• Performed NLS migration (to AL32UTF8) to be consistent with NLS setting to sync with prod systems.
• Resolved the datapump import and export issues for the 11gR2 databases with data issues while importing to get the correct data as requested.
• Installed 11gR2 Grid Infrastructure before the database upgrades.
• Performed ASM upgrades from 11.1.0.7 to 11.2.0.4 for database upgrades.
• Performed Database upgrades from 11.1.0.7 to 11.2.0.4 on both RAC and single instance databases.
• Monitored the databases and space availability in the databases.
• Performed activities for the developer requests which need DBA tasks.
• Worked on clearing the stateless alerts in the Oracle Enterprise Manager Console summary by running command on emcli.
• Worked on datapump export and import as part of developers request to refresh schema.
• Applied the PSU patches to 11g R2 Grid Infrastructure and databases instances to fix the bugs. Also updated the OPatch versions as a pre-requirement for patch applications.
• Used Oracle Enterprise Manager Cloud Control 12c for monitoring the databases. Also checked for space issues specially for archivelog destination.
• Moved the SPfile from non ASM to ASM disks for facilitating RMAN auto backups.
• Worked on Oracle Enterprise Manager, working with ASH, AWR reports, ADDM, STATSPACK and gathering statistics.
• Removed the ASM old disks and added new disks to the ASM disk groups as part of maintenance work.
• Installed golden gate 10g/11g and configured unidirectional replication for testing.
• Configured Goldengate processes Extract, Datapump and Replicate for Goldengate replication.
• Worked on post upgrade issues of having invalid components to validate the components.
• Used Dataguard Broker to database switchovers in dataguard configurations to check the standby database.
• Worked with 11g new features such as ADRCI, Duplicate from Active database, ASMCMD, etc.
• Performed RMAN backups whenever required before starting upgrade of databases.
• Cloned the databases for testing the RMAN backups periodically. Created active dataguard configuration for utilizing the resources by read only access of physical database.
• Worked with the team to perform DBA tasks as per the ticket’s requests raised.
• Performed user related activities like assigning privileges and profiles to users upon approvals.
• Installed Oracle12c database and created pluggable databases for testing purpose. Users’ maintenance, upgrade, cloning, patching, and backups
• Worked with 12c Container databases or Pluggable Databases (PDBs).
• Upgraded 11g database to 12c using direct method DBUA.

Environment: HP-UX, Oracle Database Version 10g/11g, RMAN, Data guard, RAC, ASM, Oracle Enterprise Manager Grid Control 12c, Goldengate.

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle 10g and 11gR2.
• Upgradeddatabases fromOracle 10g to 11g.
• Involved with installation and maintenance ofORACLE 10g RAC/oracle 11gRAC and Standby databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Responsible forinstalling, upgrading, patching and configuringthe Oracle environment.
• ImplementedOracle database backup & recovery solutions using RMAN.
• Extensively used Oracle Data pumpExports/Imports utilityfor moving data among the servers.
• PerformedSQL tuning Advisor for tuning of SQL queriesand database systems.
• CreatedUser accounts, Rolesand granting requiredaccess permissions and privilegesto the users.
• Partitioning and re-organization of table and indexes.
• Responsible inconfiguring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Written documentation for backups and cloning of database for future reference.
• Migrated databases from HP-UX to IBM AIX platforms.
• Continuously monitored database performance during batch jobs running on the database using AWR report and OEM.
• UsedData pumpto take the logical backups of databases.
• Worked on ASM instances for 11g databases.
• Installed and configured 12c software and database.
• Worked on pluggable and container 12c database model.
• Performed other DBA activities including space management and performance monitoring.

Environment: HP-UX, Oracle Database Version 10g/11g, RMAN, Data guard, RAC, ASM, Oracle Enterprise Manager Grid Control 12c, Shell Scripting.

Confidential

Oracle DBA/Apps DBA

Responsibilities:

• Installed 11g software and created a database on Redhat Linux for R12 testing.
• Performed Oracle Database upgrades from10.2.0.2 to 10.2.0.3in AIXRACenvironment.
• Upgraded databases from 10.2.0.2 to 10.2.0.5 and 10.2.0.5 to 11.1.0.6
• Applied different patches - one-off patches, CPU and PSU patches: 11.2.0.1.1 , 11.2.0.1.2
• Performed pre-upgrade and post-upgrade tasks for upgrade process of databases.
• Performed RMAN/Offline /Online backups and restored the backups to refresh the environment.
• Setup and configured 2 node Oracle 10g RAC with ASM for high availability of database at instance level.
• Used 10g OEM (Oracle Enterprise Manager) to manage and monitor databases for maintenance tasks.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
• Worked on operating system command line utilities likeSAR, TOP, VMSTAT.
• Responsible for setting and managing user accounts, granting required privileges and roles to users.
• Worked on Managing Applications on oracle 11g / 10g RAC databases using ASM file system with server control utility (SRVCTL) and CRSCTL for high availability.
• ConfiguringDB Linksfor users located remotely to access data locally using database link.
• Management of schemas, objects, the tables & indexes.
• Created partitionsto improve the queryperformance and manageability.
• Applied CPU security patches and PSU in both RAC and standalone systems in ASM environment.
• SQL Query performance tuning for optimized results using tools like Explain Plan, SQL TRACE, TKPROF, SQL Profiler
• Used shell scripts for daily administration.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Installed and configured of Oracle 10g &11gRAC using Cluster ware and ASM.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Recovered the database restore and recovery from RAMN backup.
• Worked on Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Worked on documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Environment: Redhat Linux, HP-UX, Oracle Database Version 10g/11g, RMAN, Data guard, RAC, ASM, Oracle Enterprise Manager (10g), Opatch, Shell Scripting, TOAD, Datapump.

Confidential

Oracle DBA

Responsibilities:

• Monitored Smiths medical client production and development databases. Checked the Blocking sessions, if the blocking session is inactive then clearing those sessions, so that other sessions waiting can continue.
• Cloned and refreshed the databases as per requirements of the development team.
• Created, altered the tables, views and PLSQL objects as per the development team requirement.
• Used 10g OEM (Oracle Enterprise Manager) to manage and monitor databases.
• Collected the statistics of the database and tuning the resource consuming SQL statements.
• Applied patches on databases and 11i Oracle EBS applications.
• Created custom tops, custom responsibilities in Oracle applications.
• Used exp/imp to refresh schemas and also performed RMAN/cold/hot backups.
• Automated and implement day-to-day Oracle DBA functions using cron jobs and shell scripts.
• Used traditional export import to take backup of schemas whenever required as per the request.
• Gathered database statistics and rebuilt indexes if required for better SQL query execution.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups as per the requests.
• Performed daily DBA support activities for the Oracle production Systems.
• Performed and tested Oracle backup and recovery policies and procedures.
• Participated directly in testing and planning to prepare for database 10g upgrades.
• Worked on Oracle Apps 11i/R12 E-Business suite systems also.
• Installation, configuration and upgrade. > Cloning and Autoconfig. > Patching (ADPATCH). > Concurrent managers. > User management.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation of Oracle Database and Oracle products.
• Developed/customized UNIX shell scripts to automate routine DBA tasks.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Created and implemented Oracle database backup and recovery strategies.
• Installed Oracle 10g, applied patches in various environments and upgraded databases from 9i to 10g.
• Set up, configured and maintained Oracle data guard (physical/logical standby databases) to ensure disaster recovery, high availability and data protection.
• Created procedures, functions, packages, and triggers using PL/SQL.
• Utilized SQL*loader and data pump import to load data into tables.
• Audited database for statements, privileges, and schema objects.
• Database installation and instance creation.

Environment: Oracle 9i, HP-UX, Solaris, RHEL, AIX, Database Tools/Utilities, Shell Scripting, export/Import.

Confidential

Junior Oracle DBA

Responsibilities:

• Installation of Oracle Database and Oracle products.
• Creating users and maintaining database security.
• Developed/customized UNIX shell scripts to automate routine DBA tasks.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Created and implemented Oracle database backup and recovery strategies.
• Installed Oracle 10g, applied patches in various environments and upgraded databases from 9i to 10g.
• Set up, configured and maintained Oracle data guard (physical/logical standby databases) to ensure disaster recovery, high availability and data protection.
• Created procedures, functions, packages, and triggers using PL/SQL.
• Utilized SQL*loader and data pump import to load data into tables.
• Audited database for statements, privileges, and schema objects.

Environment: Oracle 10g /9i/8i, Red Hat Linux, AIX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* Loader, Windows 2000.