SUMMARY

• Over 8+ years of experience as Oracle DBA in development and production environments Ensuring oracle database systems operate efficiently and securely, Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.
• Managing internal databases, from planning and testing stages through implementation and support and In - depth understanding of security and backup procedures to ensure database integrity, Background in developing backup and disaster recovery plans for nationwide offices and Superior communication, presentation, analytical and problem-solving skill. Work well with all levels of business.
• Experience in Installation, configuration of Oracle RAC 10g, 11g, 12c, 18c, 19c developed 2,3,4 node RAC environments for a 10TB+ database
• Implemented strategy for partitioning and management of historical data tables in RAC
• 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 Clusterware 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
• 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.
• Expertise in Oracle GoldenGate installation in 11g,12c,18c, configuration, and troubleshooting GoldenGate issues.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
• 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
• Good knowledge on Oracle streams, data guard physical standby databases, working knowledge on BCV’S, SRDF, and managing of partitions and clustering of tables.
• Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools
• 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 also used as common storage for migration of databases to Exadata
• Configuring DB Links for users located remotely and Expertise in supporting replication with snapshots, Materialized Views and Streams
• 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
• Management of schemas, objects & partitioning the tables & indexes.
• Worked on Advanced Replication including synchronous and asynchronous scenarios
• Experience with Oracle 11g, 12c, 18c, 19c features
• Solid experience with Oracle technology architecture, Oracle and Real Application Clusters.
• Knowledge of Data transfer between SQL Server and Oracle.
• 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
• Excellent written and verbal communication skills

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle Databases and Responsible for installing and configuring GoldenGate 12c, 18c, 19c on Oracle Servers
• Install and configure Oracle GoldenGate, Establishing standards, policies, and procedures for GoldenGate replication administration
• Configured Integrated extract using downstream capture, used different utilities logdump, defgen to manage golden gate environment
• Installed and configured GoldenGate 11g, 12c, 18c, 19c on AIX and RHEL platforms and Configured Integrated Extract and Replicat on Oracle multitenant database
• Used 18c new features in clusterware, configured orachk to schedule recurring health checks at regular interval on server level,
• Enabled memory guard In 18c cluster to overcome stressed connection on database
• Configured Extract and Replicate pumps for golden gate replication 11g, 12c, 18c and Troubleshooting issues in Goldengate Environment using report files & logdump
• Performed Cross platform migration and used Oracle Golden Gate 19c to migrate databases from Aix to Linux as part of Migration
• Performed Zero-Down Time migration from AIX to RHEL using Expdp and GoldenGate and process improvement for GoldenGate Environment by proactive monitoring using Shell scripts
• Installed Oracle GoldenGate Veridata and Agents and created jobs compare data between instances and Used Logdump Utility to Investigate data on the trail and defgen utility to create definition files used for replication
• Configured BI-DIRECTIONAL replication and replicated tables between instances and used CDR parameters to resolve conflicts
• Worked on troubleshooting out of sync issues in GoldenGate and RAC environment
• Creating services using “dbms service” on pluggable databases in both RAC and NON RAC environments
• Applied patches to 11g,12c,18c and also upgraded databases from 12.1 to 12.2 and 18c
• Installed OEM 13c on database 12.1.0.2 and Monitoring databases using Grid Control 10g/11g/12c and 13c for Configuration of error notifications and adding them to the grid control
• Created ASM diskgroups, created volume and ACFS, mounted on RAC servers
• Worked on Exadata x6-2, x5-2 and migrated databases to Exadata X6-2 and Worked on patching Exadata, and validated all Exadata components on patching
• Worked on building DR databases using 12c, 18c, 19c data guard, and trouble shooting out of sync issues
• Used new parameters in DataGuard in oracle 19c and configured DataGuard for production databases, Configured Dataguard broker and managed Dataguard environment using broker
• Implemented Oracle security on New database servers, implemented oracle wallet and encrypted tablespaces
• Configured oracle GDS read only services and read write services for automatic failover in DataGuard environment
• Used OEM 12c, 13c and generated AWR, ASH, ADDM reports for database performance issues
• Deployed new agents on servers and registered databases with OEM 12c, 13c
• Deployed jagents and registered oracle GoldenGate process to OEM 12c, 13c
• 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
• 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, Golden Gate 11g, 12c,18c, Oracle RAC, DATAGUARD, TDE. Exadata X6-2, X5-2, Oracle GDS

Confidential, Duluth, GA

Senior Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration including Oracle 10g/11g/12c RAC.
• 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
• Managing health check and potential fix using orachk, Crsctl and Srvctl in clusters
• Planned and implemented high availability solutions using Oracle 12c RAC, Standby Database using Oracle Data Guard
• Implementation of High Availability solutions with Oracle 12cg RAC, Physical and Active Standby Databases (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
• Installed and configured OEM Grid Control, deployed agents registering and monitoring databases
• 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
• Managing Databases running on Exadata X4-2, X3-2 half rack and migrated databases to Exadata x4-2
• Used CellCLI, dcli to monitor Exadata X4-2, X3-2 storage cells and managing health checks
• Configured IORM and monitoring Exadata I/O distribution on storage nodes on Exadata
• Configured parallelism for databases running on Exadata X4-2 and performance tuning query’s running on OLTP Compression tables
• Supported Exadata Storage replacement and Exadata patching, worked with platinum support in applying patches to Exadata
• SQL and PL/SQL Programming and Developed back-end logic for business applications, e.g. views, procedures/functions, triggers.
• Developed scripts and reports using SQL, PL/SQL and Perl and Standby Database (Data Guard) setup and configuring DB links
• Established best practices and best procedures for database administration. Responsible for Software life-cycle support to include migration of all custom application changes through four different instances to production
• Analyzed the user requirements and designed partitioned tables for improving performance of Data marts and Responsible for continuous database monitoring and reorganization for ensuring performance
• Worked with developers and Developed Packages and customized functions and Triggers based upon the business logics
• Configured multiple weblogic domains including machines, manager servers, node managers and cluster environments and Used WebLogic 12c console to create new Users for managing GoldenGate Veridata, and granting privileges
• 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
• Managing Oracle Enterprise Manager Grid control 11g/12c for monitoring databases to monitor all databases and performing monitoring and performance tuning and Defining and Setting backup and recovery procedures.
• Performed and tuned using AWR, ASH, OEM Grid and Tkprof Oracle Databases.
• Tuning the database using stats pack on standby database and custom scripts
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK
• Writing Shell Scripts for managing day-to-day activities and automation of backup
• 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 11g, 12c, Web Logic 12c,Exadata x4-2,X3-2, ZFS, ASM, PL/SQL, RMAN, Toad, OEM GRID, EMC, NetApp, Maria DB, Net Backup, AMAZON AWS, EC2, RDS, S3

Confidential

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
• Involved in Database Administration, Installation, Maintenance and development of Life ray for medi-care and Upgrade/Migrated the production and development of databases to Exadata Machine x2-8 and worked with Oracle platinum support to apply patches on cluster
• Used Exadata features smart scan and tested storage Index’s and calculated cell offload efficiency of sql’s deployed
• Performing daily Archive log file backup and checking Alert Log files and Monitoring the table space growth and resizing the table space on RAC environment.
• 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 GoldenGate Replication, Veridata
• 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.
• Performing Online and Offline database backups on schedule and Scripting (shell) of automated backup for Cold, Hot backups and also defining and Setting backup and recovery procedures
• Creating ODBC for users and Application Developers and Co-ordination has been extended to Application developers for coding to improve the performance of the database
• Exported data from all Units and Automated the procedures and interface programs using Oracle Advanced Queuing, Oracle Enterprise Manager
• Configured and administered WebLogic server with Oracle 10g and 11g databases and Configured WebLogic Node manager for administer the Managed servers
• Configured and administered Connection pools, multi connection pools and Data Source for JDBC connections
• Troubleshooted emerging application issues from WebLogic configuration side
• Applied the patches to the WebLogic servers and Troubleshooting multicast issues using WebLogic Java Utility Multicast Test
• 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 10g, 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