SUMMARY

• 12+ years of experience as Oracle Database Administrator & Applications, providing 24x7 support of production and development of R12 & 11i EBS on 19c/18c/11gR2/10g/9i databases on different platforms.
• Oracle Database, Oracle Transport management, Oracle Golden Gate, Data Modelling, Data Masking, Mongo Database
• Hands on experience in Installation, Configuration, Maintenance and troubleshooting of Oracle Database and Applications.
• Extensive knowledge on database backup/recovery strategy (RMAN), Import/Export & Data pump, standby databases, Oracle configuration management, and database cloning, refresh, and patch management.
• Specialized skills in installation, configuration, upgrades, cross platform migrations, plan storage requirements, managing system security, integration with custom applications, design high availability, disaster recovery, backup, capacity planning, tuningand design workflow.
• Delivering Oracle Database performance - tuning services for customers with AWR REPORTS, EXPLAIN PLAN, TKPROF, SQL TRACE, ORADEBUG, OEM, Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Hands on experience in Grid control, CDC, replication, monitoring batch performance.
• Extensive knowledge on Creating a logical and physical data model using Forward engineer and reverse engineer using ERWIN.
• Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring.
• Experience in using Oracle development tools such as Tool for Oracle Application Development (TOAD), Oracle Forms builder, Forms 6i, SQL developer, SQL* Plus, Oracle Enterprise Manager (OEM), SQL Developer and SQL Tool.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Experience in Administration of Fusion Middleware Applications like WebLogic, SOA, ADF, AIA, OBIEE, ODI, WebCenter Content (WCC), Imaging (IPM), Hyperion, Oracle EBS & MuleSoft Applications
• Skilled in providing Offshore Onshore support solutions for multiple customers and diverse environments with strong adaptation of end user requirements, solution designing and troubleshooting issues.
• Experience with UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic. worked efficiently as an individual as well as in a team environment, well in analytical and logical problem solving with good communication skills.

TECHNICAL SKILLS

Technical Expertise: Oracle Database Administration Versions 19c/18c/12c/11g/10g/9i Oracle APPS Versions R12.1.1/2/3, R12.2 /11i, Oracle RAC 12c/11g/10g,ASM, SSO/OID,DMZ, OTM DBA v6.3/v6.4, MuleSoft, Golden Gate, SOA/FMW/WebLogic (10g,11g,12c), OBIEE (11g,12c), ODI (11g,12c), IPM(10g,11g), WCC(11g,12c), Oracle Application Server(10g), Tomcat Apache, Hyperion, Primavera, JBoss, SQL, PL/SQL, C and UNIX Shell Scripting.

Tools: /OS expertise Mule CloudHub (AWS), Github, AnyPointStudio, Splunk, Bitbucket, TeamCity, SourceTree, EMC Legato Networker, Big Brother, APPWORX, PVCs, JBOSS, Compuware, File-Zilla, TOAD, SQL Developer, SQL Tool, Form Builder, ERWIN, Tortoise SVN, PVCS, Red Hat Enterprise Linux AS 3/4/5/6/7, Windows server 2003/2008/2012/2016/2019 , Oracle Enterprise Linux, Sun Solaris (SPARC) 5.8/9/10/11, HP-UX, AIXV, VM ware

Industry Expertise: Education and Public Sector, Financial Services, Transportation, Gaming and High Technology industries

PROFESSIONAL EXPERIENCE

Confidential, NY

Lead Database Administrator

Environment: Oracle 12c/18c/19c,GoldenGate,Weblogic12c, Bitbucket, TeamCity, GitHub, ODI, Cloud Control 13c, Linux 7

Responsibilities:

• Installation, upgradation, migration, cloning of databases using RMAN/DataPump/Exp-Imp, patch implementation, planning & managing Backups and Recovery, database tuning and monitoring of oracle servers.
• Performed the capacity planning required to create and maintain the databases.
• Cloning of Oracle development applications using production data as per business requirements.
• Configure and integrate database and Application monitors with Ticketing, SLA.
• AWS CloudHub administration, deploying and promoting applications on MuleSoft.
• Worked on the storage planning, configuring, and migrating 11g prod databases to 19c ASM physical server databases.
• Strong experience of implementing and managing oracle real application cluster (RAC), Data guard, Backup and Recovery Process & Performance Tuning.
• Managed and provided support for database servers on various operating systems (Sun Solaris, AIX, Linux, and Windows) to multinational clients.
• Ensures stakeholders are regularly apprised of status and progress. Communicate effectively with offshore teams and clients.
• Coordinate tasks with Mangers and prepare weekly status report on the progress of key deliverables.
• CreatedPL/SQLprograms for BATCH processing.
• OEM & Alert scripts implementation for monitoring the instances.

Confidential, Chicago, IL

Lead DBA

Environment: Oracle 10g/11g/12c, Oracle Apps R12.1, WCC 12c, IPM11g, Primavera, Hyperion, OBI, SOA 12c, Cloud Control 12c, Oracle Supercluster, Solaris, Python & Shell Scripting, PLSQL, TOAD

Responsibilities:

• Migrate the Oracle Applications & Database to Oracle Super Cluster.
• Automation of code deployments and applying platform and application patches.
• Setup and performed data replication using Golden Gate Technology.
• Analyze, design, implement, tune, maintain and upgrade of various Database & Applications.
• Support of IPM, Hyperion, Business Intelligence, Primavera, Discoverer, Appworx applications.
• Creating security roles, group policy, user authentication, auditing and authorization.
• Well versed with deployment, migration, patching and maintenance of Database & Middleware applications.
• Configure Disaster Recovery solutions as per Client requirements.
• Effectively collaborate with the project teams about project health, risks & future opportunities.
• Design of overall technical solutions, including all desired customizations.
• Create standard templates for Functional and Technical Design, Unit testing for various database & applications.
• Setup, configure and performed data replication using Golden Gate.
• Configure Disaster Recovery solutions as per Client requirements.

Confidential

Database Administration

Environment: Oracle Database 9i/10g/11gR2, RAC, ASM, Oracle Apps 11i/R12.1, R12.2, Jenkins, Data guard, Golden Gate, Mongo Database, SOLARIS, AIX, RHEL 4/5/6 & Shell Scripting

Responsibilities:

• Golden Gate Heterogeneous replication and solutions design.
• Developed RMAN scripts for database backup and recovery including- hot and cold backup.
• Performed Database re-orgs to regain disk space, performance improvement on large EBS systems.
• Troubleshooting Performance Issues, Tuning Instance and Recommendations on SQL code Tuning. worked on Oracle SOA suite administration, installation, configuration, tuning and customization.
• Extensively worked on Import/export, Data pump, SQL*Loader, Partitioning, Materialized views
• Leads the business team in identifying, prioritizing and delivering automation of business processes.
• Ensures stakeholders are regularly apprised of status and progress. Communicate effectively with teams and clients

Confidential

Senior DBA

Environment: Oracle 9i, 10g, 11g R2, Oracle Apps 11i, R12, Informatica, Jboss, EMC Legato Networker, SOLARIS, AIX & Shell Scripting

Responsibilities:

• Worked as Onsite DBA at Confidential Europe (Germany) during 11g R2/ R12 upgrade
• Patched RAC and Non-RAC databases with latest CPU/PSU and one-off patches.
• Upgradation of production Database from 10g to 11g and applying patches.
• Oracle Database backups using Hot/Cold, Import/Export & RMAN.
• Taking backups and recover from tapes using EMC Legato Networker
• Installation, Up-gradation, monitoring of various oracle databases on Solaris platform.
• Set up and Supporting Active Data Guard, Snapshot Data Guard.
• Installation and configuration 10g RAC and troubleshooting the problems.
• Experience and proficient in Application Patching using AD Utilities and strong analytical and problem-solving skills in Patch Application.
• Being a senior and key member of the team responsible for delivering tasks on time at offshore.
• Managing the team and distributing the responsibilities among the team members

Confidential

Database Specialist

Environment: Oracle 9i, 10g, Compuware, AIX, RHEL 4, 5 & Shell Scripting

Responsibilities:

• Analyzing the Survey Sheets of the SPRINT Network.
• Designing the Masking Plan as per the Analysis.
• Loading the Flat file data into Databases using a tool named COMPUWARE.
• Masking the Desired Data by applying the Masking Plan using COMPUWARE tool.
• Troubleshooting the Network connection for the Database’s by reconfiguring the network related files.
• Monitoring & Maintaining the growth of the Tablespaces.
• Monitoring the Alert log file for the better performance of the DB.
• Performing data refreshment by EXPORT & IMPORT Utilities.
• Regularly backing up the database, Schema Level/DB Level using Export & RMAN Utilities.

Confidential

Database Administration

Environment: Oracle 9i, 10g Oracle Application server, ERWIN, Form Builder, SQL Tool, SQL Developer, Grid Control 10, RHEL 4, 5 & Shell Scripting

Responsibilities:

• Translating logical data models into physical database Designs using ERWIN.
• Performing code migrations on Production Databases.
• Generating performance reports like AWR, ADDM and analyze the bottlenecks.
• Implements and enforces security for all of the Oracle Databases.
• Plans and implements backup and recovery of the Oracle database.
• Applied patches using OPATCH and Patch sets using OUI.
• Monitoring the troubleshooting load and long running jobs.
• Creating oracle database scripts and setting the crontab.
• Monitoring the database growth, Re-Organization of Tables.