SUMMARY

• More than 8+ years of experienced Oracle DBA with extensive knowledge on Oracle Database technologies looking to transform and take my capabilities to the next level along with the ever - changing industry.
• Monitoring of the databases to ensure 100% availability.
• Extensive experience of working on Oracle 10g, 11g and 12c on Red Hat Linux, Sun Solaris, IBM AIX virtual machine (VMWare).
• Building RAC single/ multi-node cluster and installing databases.
• Working on Database Migrations, applying quarterly patches PSU / on-off patches.
• Database Upgrades from lower versions to 12c.
• Working on refreshes using RMAN manual restore / Duplicate / Data pump methods.
• Installing and Configured Golden Gate Bi-directional and Multi-directional replication.
• Added Alias process for pumps for auto stop and start during Golden Gate failover.
• Performing restore and recovery of the databases during disaster.
• Building Data Guard environment for maximum availability and in case of any disaster to primary.
• Migrating the databases from old data center to EXADATA machine X3-2 half rack using data pump.
• Supporting legacy servers and managing the services until its conversion to EXADATA machine.
• Applying quarterly patches to EXADATA machine on storage cells and database servers.
• Having knowledge on implementing the cloud services with AWS and using RDS migrating on-premises relational databases like Oracle, SQL Server.
• Have good knowledge on support Oracle on AWS and supporting other AWS services like VPC, EC2, S3, etc.
• Performance Tuning of databases using AWR, ADDM, explain plan, Gather Statistics, monitor memory, index usage.
• PL/SQL objects creation Create trigger/function/stored procedure/packages.
• Manage cursor. Tune and troubleshoot PL/SQL codes. Handle run time errors. Write database monitoring PL/SQL objects. Create materialize view.
• Have good knowledge in using ITIL tools like Service now, Remedy 7, Agile craft, JIRA and its SLA priorities.
• Supported production databases servers and applications that provided secure mission and critical services.
• Meeting timelines of the customer whenever any critical activities were performed.
• Implementing best practices on all the customers throughout the support.
• Implementing database backup design to meet customer’s SLA for the duration of backups.
• Have good presentation and communication skills to provide support to customer.

TECHNICAL SKILLS

Languages: PLSQL, SQL, Python, JScript

Operating system: Solaris- 9&10, Linux 2.1/3.0,4, Windows 2k

Oracle Tools and Utilities: 11g OEM, 12c OEM, RMAN, Golden Gate, TOAD, SQL*Developer, SQL*Net, Net Configuration Assistant, Oracle universal Installer, Oracle database configuration assistant, MYSQL, SQL Loader

Cloud Computing: Amazon Web Services (EC2, ELB, S3, VPC)

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis, MO

Oracle DBA

Responsibilities:

• Successfully configured complex bi-directional replication with Oracle Golden Gate across 62 servers.
• Added Alias process for pumps for auto stop and start during Golden Gate failover.
• Upgraded Golden Gate from classic capture to integrated capture.
• Configured Golden Gate monitoring scripts for Lags, Abended and stopped status.
• Engineering, implementation, tuning support for Oracle RAC databases.
• Experience in Installation, Configuration of Oracle Real Application Clusters (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Supporting for weekend maintenance activities like PSU/OS patching, any outage change request. Properly following the documented SOP.
• Working on daily database administrator activities like user/space/memory management.
• Troubleshooting database related errors and we process if any changes required such as INIT parameter changes /applying patches and such maintenance activities.
• Working on refreshes using RMAN manual restore / Duplicate / Data pump methods.
• Have good knowledge on using OEM (Oracle Enterprise Manger) 12c and 13c grid control.
• Working on database upgrades, applying quarterly patches PSU / on-off patches.
• Troubleshooting on bad query performance by generating, analyzing AWR report.
• Recommending application for any SQL ID changes for any query
• Created and configured shell script to drop partitions and automated for nightly maintenance.
• Tuning SQL Query, suggesting application to change code for better performance.
• Have good knowledge on using Oracle Key Vault and Audit Vault.
• I am Primary SPOCs on newly supported project. Involved in from pipeline to converting the project to our standard and supporting it.
• Involving in daily internal calls with client/team wherein we discuss about the project and for better performance.
• Configure and Involved in failover testing with Global Dispatched and Tomcat Apache teams for Oracle cloud production servers.
• Performance Planning and tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Database Monitoring and Performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM.
• Have good knowledge on Oracle Exadata.
• Involving and organizing the meetings with respect to any issues for our quality support.
• Conducting meetings with vendors and application team for any improvements and automation
• Supporting databases during critical maintenance window.
• SPOC for high priority SLA breaches and gathering responsible team to get the RCA, thus applying appropriate actions.
• Have good knowledge in using ITIL tools like Remedy 7, Agile Craft, JIRA and its SLA priorities.

Environment: Red Hat Linux, Oracle 11g, 12c, Golden Gate, RAC, RMAN, OEM 12c, SQL, EXP/IMP, EXPDP/IMPDP, SQLLOADER, TOAD, AWR, ADDM, ASH reports, Explain Plan, Remedy, Agile Craft.

Confidential, Florida

Oracle DBA

Responsibilities:

• Performs database system management functions (e.g., software installs, version upgrades and configuration management).
• Responsible for database backups, design, development, testing and performance tuning.
• Create new database systems and make recommendations to improve the performance and efficiency of existing systems.
• Installed and configured Oracle 10g/11g RAC high availability.
• Applying rolling upgrade patch for RAC databases.
• Upgrading RAC database from 11.2.0.2 to 11.2.04.
• Deep understanding about Exadata specified features such as Smart Scan, HCC(Hybrid Columnar Compression), Flash Cache etc.
• Experience in software and firmware maintenance of both database and Storage servers in the Exadata machine including upgrades and patching.
• Solid skills to configure Exadata to meet company interval and security requirement.
• Add node from cluster using addNode.sh script.
• Continuously manage performance through trending analysis and work with development teams on identified tuning opportunities.
• Extensive use of Export and Import for full database backup, schema level backup, Table level backup and metadata using Data Pump.
• Worked with Network team to configure F5 Load Balancer.
• Tested disaster recovery by doing Switch over/Switch back before live.
• Configured RMAN backup for tape using Symantec NetBackup solution and schedule backup jobs in crontab.
• Monitoring database locks, blocking sessions and long running sessions and killing as per request.
• Managing Security, User groups and Users by using roles, grants, privileges and profiles.
• Extensive experience in daily batch and report monitoring, space management, index rebuilds statistics collection and other Oracle housekeeping tasks.
• DBA maintenance tasks including adding datafile to tablespaces, resizing the datafiles, File system usage, Creation of users assigning privileges and roles, change of init parameters, code deployments and creating PL/SQL objects.
• Researching and analyzing emerging Oracle database technologies, techniques and protocols and making recommendations.
• Good knowledge on all incident, change, problem management process & compliance process.

Environment: Oracle 11g, 12c, RHEL, RAC, RMAN, OEM 12c, Data Pump, SQL, PL/SQL, F5 Load Balancer, Switch over/Switch back, Symantec NetBackup, Security, SQLLOADER, TOAD.

Confidential

Oracle DBA

Responsibilities:

• Supporting 1500+ targets in Confidential Corporate which includes development, stage and Production targets.
• Manage Production and Non-Production non-ERP environments ranging from Oracle 10g, 11g instances across Linux, Solaris, and Windows platforms. Provided 24x7 support
• Proactive monitoring, Alert Monitoring, Backups, OEM and other critical activities
• Experience with Real Application cluster (RAC) and Automatic Storage Management (ASM).
• Engineering, Implementation and support for high availability solutions using Oracle Real Application clusters (RAC).
• Implementing and managing multi-terabyte Oracle 11g RAC databases to deliver leading multi OLTP application.
• Performed schema and object level refreshes using export or Data Pump.
• Performed Database Refreshes using RMAN cold or hot backups or using data pump.
• Extensive experience in performing Database Upgrades.
• Applying Quarterly PSU patches on Oracle binaries.
• Configured Golden Gate Bi-directional setup.
• Managed Data Guard Created physical standby databases for High Availability.
• Have hands-on on Oracle EXADATA and its features like smart scan, HCC.
• Migrated the databases to EXADATA machine using data pump.
• Have Hands-on knowledge on upgrades and patches on EXADATA machine in database servers and storage servers.
• Performed service-now change tasks like creating schema user, granting specific roles or privileges, code deployments, creating database links (both public and private), creating objects like tables, indexes etc.,
• Monitoring the daily scheduled backup jobs includes RMAN hot and cold backups and troubleshooting on them if any issues.
• Worked on databases related and alerts like file system alerts, table space alerts, ASM disk group related alerts proactively on daily basis using OEM 11g and 12c. Troubleshoots for its permanent fix.
• Worked on alerts related to performance and tuning like maximum CPU utilization or query is taking much time to run. Have basic knowledge in handling these issues.
• Worked on database performance issues like SQL running slow, database hung issues and analyzing to give a fix.
• Good understanding and use of tools such as Oracle Enterprise Manager, TOAD, SQL developer, AWR.
• Handling key alerts of databases around the clock.
• Creation, Scheduling and monitoring CRON Jobs for day-to-day activities.
• Involved in commission/decommission activities as per the project.
• Taking RMAN backups using Oracle advanced compression for faster backup and recovery and boosts performance.
• PL/SQL objects creation Create trigger/function/stored procedure/packages. Manage cursor. Tune and troubleshoot PL/SQL codes.
• Worked closely with Oracle support in identifying and incorporating Oracle recommendations and best practices in design phase resulting in minimal issues during implementation.
• Have hands on experience on Microsoft SQL Server for creating databases, granting SQL access, cleaning Sql Orphan users and scheduling jobs using Sql agent.
• Planning and scheduling backup, checking logs for errors, ensuring maximum uptime of 24x7 databases.
• Participate in daily meeting with DBA Team to review project progress and planning downtime and activities like Patching, Migration, new projects etc.
• Inter personal skills training and Awareness about Lean ITIL Documentation about the team activities.

Environment: Oracle 10g, 11g, Solaris 9&10, Linux 2.1/3.0.4, Data Guard, Data Pump, Golden Gate, EXADATA OEM, SQL Developer, SQL*Net, Microsoft SQL Server.