SUMMARY

• Oracle Database Administrator (DBA) with 8+ years of experience in administration, installation, configuration, and upgrades of Oracle 19c, 12C, 11g, and 10G databases.
• Experience in Upgrading databases (10g R2 to 11g, 11g R2 to 12cR1, 11g to 19c)
• Excellent experience in OLTP database systems, implementing and managing large Oracle databases (VLDB)
• Installed Oracle Cluster ware to provide infrastructure for RAC and configured 2,3,4 node Oracle 11g RAC, 12c RAC, 18c with EMC.
• Experienced in setting up and installation and configuration of release 19c,18c,12c,11g RAC/10g R1 RAC with ASM EMC Storage.
• Planned and implemented DR & high availability solutions using OEL 11g Standby Database using Oracle Data Guard, 11g, 12c and 18c, 19c RAC.
• Designed and implemented Oracle Real Application Clusters (RAC) on Solaris for an OLTP application with Transaction Application Failover and high transaction volume.
• Proficient in using OEM and RMAN Upgrade and Migration of Databases from Oracle 11g,12c,18c
• Experience in Installing and Administrating MySQL databases on Aws RDS
• Experience in migrating oracle and MySQL databases from on - perm servers on to Cloud environments such as EC2 and RDS servers.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Performance Tuning, capacity planning, script development, and documentation.
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering 40 Terabytes of Oracle Databases on Oracle 18c,12c,11g,10g,9i
• Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools
• Good working knowledge as a Primary support for database related issues with clients.
• Worked on Exadata x6-2, x5-2, x4-2, x3-2, x2-8 Half rack and migrated databases to Exadata and provided excellent support for databases running on Exadata, used ZFS to perform backups and used as common storage for migration of databases to Exadata
• Installation, configuration, upgrade and performance tuning of Oracle RAC
• Experience with OEM, TOAD, Oracle grid-control and Database Tuning, PL/SQL tuning using explain plan and used HINTS extensively to optimize the SQL statements, used cost-based approach extensively and also used rule-based methods to tune the SQL
• Expertise in maintaining Database Security using auditing
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, Logical and Physical database design.
• Experience on Script Programming using Korn shell, bash shell, Perl, AWK and knowledge on archiving tolls like tar, gunzip, backup, auditing both external auditing and internal auditing, experience on various UNIX platform like Redhat, AIX
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Excellent analytical and problem-solving skills and Result oriented, self-motivated, team player, ability to work independently.
• Handled daily production problems/change requests (DBCRS) with Oracle and 24x7 production DBA support, Application and development DBA

TECHNICAL SKILLS

Databases: Oracle 19C, 12C,11g, and 10g

Oracle Products: Oracle Real Application Cluster 10g/11g/12C, OEM 13C, 12C, Data guard, Import & Export, Automatic Storage Management, Oracle 10g/11g/12c (Grid Control), Golden Gate, RMAN.

Operating Systems: Windows, Linux.

Languages: SQL, PL/SQL, Unix shells scripting

Tools: & Utilities: Oracle Grid Control 11g/ 12c/ 13c, SQL*Loader, RMAN, SQL Developer, PL/ SQL Developer, DBCA, SRVCTL, CRSCTL, ASMCMD, DGMGRL

Ticketing Tools: JIIRA, ServiceNow

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle Databases and Responsible for installing and configuring Installed, Configured, Maintained Oracle 12c 4 Nodes RAC Databases hosted on OCI Exadata (IAAS) . Maintained 12c Dataguard with RMAN backup (IAAS)
• Upgraded Oracle 19.2.x from 12.2.x Oracle Database on RHEL 7.x Cent OS and Windows Server.
• Ensured performance, scalability of Oracle, PostgreSQL, MongoDB (NoSQL) databases.
• Extensively worked on performance tuning and resolved bad sql’s on databases
• Applying DDL changes and supporting new deployments and creating Implementation plans for maintenance for patching and upgrades of databases
• Used export expdp and import impdp extensively for refresh’s and migrating data between databases.
• Administered oracle databases that sit on AWS RDS.
• MySQL and PostgreSQL 10.x/11.x Installation, HA (three Node cluster) Configuration, Server Tuning, Implemented, refined and maintained Database replication and failover on Centos 7.x OS.
• PostgreSQL DB Query optimization on the Development, UAT and Production DB’s for Air Arabia and Other Airlines
• Maintained the multiple databases server on the Cloud IAAS and PAAS environments.
• Automated messaging services on server failures, for task completion and success Oracle Database Migration from on-premises to Oracle OCI Cloud and DevOps team for database design for new features/functionality.
• Managed Multiple Databases on AWS EC2, Developing, refining and monitoring recurring database jobs/scripts
• Coordinated with the DevOps team for the new deployment, monitoring, backup, recovery, security, and DB health best practices and measuring the performance of MongoDB databases for Scaling
• Analyzed and optimized the databases as per business logic and the requirements, Migrated the data one source to another destination.
• Worked hands on to migrated oracle databases to RDS using Data migration service.
• Done poc on AWS RDS migration to determine best migration strategy that works for the environment.
• Used RMAN new features to clone database and for migration data between databases
• Worked with offshore team and coordinating database monitoring, scheduled calls
• Responsible for database administration and worked in all phases of Software Development Life Cycle (SDLC), and systems analysis procedures
• Applied patches for all production databases, development and test and configured scripts for automatic patching on database
• Extensively Ticketing Systems BMC Remedy and Service now and 24x7 production Support Database Maintenance and on-call Support

Environment: ORACLE SQL*Plus, OEL /11g/12c/18c,19c Red Hat Linux 6.x,7.x, AIX 6.1, RAC 11Gr2, 12C, 18c, 19c IBM, AIX-6.1, Data Guard 11g, 12c, 18c, Oracle RAC, DATAGUARD, TDE, PostgreSQL. Exadata X6-2, X5-2, Oracle GDS, AWS.

Confidential, Indianapolis, IN

Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration including Oracle 10g/11g/12c RAC.
• Fine-tuned Oracle SQL Query, Optimized Database, Monitored and Maintained the database using OEM, ASH, ADDM, SQL Tuning Advisors Profile and SPM.
• Deployed and maintained PostgreSQL and MongoDB databases on AWC EC2 and RDS services
• Migrated Oracle Database from on-premises datacenter to OCI and AWS and Collaborated with DevOps team for database design for new features/functionality.
• Configured OEM (Agent installation) and worked on adding database, host targets on OEM 12c & 13c.Monitoring the log files, backups, database space usage and the use of system resources at OS level and in OEM.
• Managed ASM disk groups via ASMCMD and database control. Monitored and administered numerous databases in various platforms like Linux/Unix, Aix, Windows. Used RMAN for backup and recovery jobs. Performed capacity planning for efficient database growth. Involved in optimizing database uptime/availability and performing database audits.
• MySQL and PostgreSQL 10.x/11.x Installation, HA (three Node cluster) Configuration, Server Tuning, Implemented, refined and maintained Database replication and failover on Centos 7.x OS.
• Installation of Oracle RDBMS server software and version upgrades 11g and 12c
• Managing, troubleshooting, and resolving oracle database, RAC, and applications issues.
• Involved in Upgrade/Migration of the oracle databases from Oracle 11g to Oracle 12c and Sun Solaris to OEL (Oracle Enterprise Linux)
• Designed and implemented Oracle Real Application Clusters (RAC) on Solaris with EMC Storage for an OLTP application with Transaction Application Failover and high transaction volume
• Monitored/managed 2,3 node RAC environments, databases using OEM-Grid control, and RMAN database backup and recovery
• Planned and implemented high availability solutions using Oracle 12c RAC, Standby Database using Oracle Data Guard
• Configured Service Level Agreement (SLA) for applications accessing standby databases (ACTIVE Data Guard) and applied logs with delay to prevent Block corruption
• Developed 2 node RAC environments for a 2+ TB database in 12c and Implementing Data guard on this RAC environment with another RAC Standby Database
• Enabling and analyzing trace files, optimal Space utilization in table space by avoiding fragmentation and Usage of Partitions to improve the query performance and manageability.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup
• SQL and PL/SQL Programming and Developed back-end logic for business applications, e.g., views, procedures/functions, triggers.
• Developed scripts and reports using PostgreSQL, PL/SQL and Perl and Standby Database (Data Guard) setup and configuring DB links
• Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.
• Migrated applications to the AWS cloud and Deployed applications on AWS by using Elastic BeanStalk
• Performed and tuned using AWR, ASH, OEM Grid and Tkprof Oracle Databases.
• Performed partition maintenance and automated the process of creating new partitions as and when required
• Worked with offshore team and coordinating database monitoring, scheduled calls to discuss database issues and assisting in implementation of change control process in production and
• Handled daily production problems/change requests (DBCRS) with Oracle and 24x7 production DBA support, Application, and development DB

Environment: ORACLE, SQL Server, SQL*Plus, OEL 10g/11g/12c, Red Hat Linux 6.x, RAC 11Gr2, 12C, Solaris10, Data Guard 11g, 12c, Golden Gate / Shareplex, Web Logic 12c, Exadata x4-2, X3-2, ZFS, ASM, PL/SQL, PostfreSQL, RMAN, Toad, OEM GRID, EMC, NetApp, Maria DB, Net Backup, AMAZON AWS, EC2, RDS, S3

Confidential, Des Moines, IA

Oracle DBA

Responsibilities:

• Implementation of High Availability solutions with Oracle RAC, Physical Standby Databases and 24x7 Oracle Production Database Administration including Oracle 11g RAC Administration and management
• Installed and configured OEM Grid Control 12c and mass deployment of agents
• Managing, troubleshooting, and resolving oracle database, RAC, and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose and Performed Oracle Database upgrades from 10.2.0.4 to 11.2.0.3 in AIX RAC environment.
• Implementation and Configuration of 12C OEM & Oracle Management Server for maintenance and monitoring
• Using RMAN & User Managed backup methods for better control.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database and Review alert logs and dump files to check for any problems related to the database/user.
• Installation and Maintenance of Golden Gate Replication, Veri data
• Perform database cloning, Expdp, Impdp to setup identical databases in the production and development environments.
• Upgrade and migrated the production and development databases from 10g to 11g and Involved in Database sizing, Capacity Planning and Presenting user-friendly reports, and providing training to end users on reporting functions
• Involved in monitoring the lock and block processes, releasing locks in case of resource blockage, and gathering statistics.
• Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.
• Expertise in developing web applications using Java and related technologies and integration issue to figure out the SOA issues from SOA monitor with SOA users and Web Services like SOAP and REST
• Developed New Package to call the Fusion Middleware OSB Web Services from the Oracle E-Business Suite database and pass the parameters to them.
• Created users and set permissions and Managed database security using groups, roles and handled number of databases in different places
• Created database objects and managed the permission access on the objects with necessary security
• Troubleshoot the automation of Installing and configuring applications in the test
• Supporting different projects in build and Release SCM effort and Deployment of Release to various QA and UAT environments

Environment: ORACLE, SQL Server, SQL*Plus, OEL 10g/11g, Red Hat Linux 5.x, IBM, AIX-6.1, Data Guard 10g, 11g, Golden Gate/Shareplex, ASM, PL/SQL, RMAN, Toad, Exadata x2-8, BANNER 8., WebLogic Server, REST, SOAP, SOA Fusion Middleware, OEM GRID, SQL * Plus, OEM, Erwin Data Modeler

Confidential

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Databases migrated to RAC for improved resiliency and performance.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Experienced in cloning the databases using HOT and COLD backups.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.