SUMMARY:

• Senior Oracle DBA with over 18+ years of IT experience in Oracle Database administration of 19c/18c/12c/11g/10g/9i/8i/RAC,OEM12c,OEM13c,Dataguard,Standalone,Support DBA/Migration, Oracle Apps 11i, R12.
• Expert in Implementation Oracle 10g/11gr2/12c/18c/19c/13c OEM, Grid (RAC, CRS, ASM, Database) and Configuration for High Performance and High Availability with latest Cluster Technology.
• Expertise on Managing Oracle 18c/12c/11g/10g/9i/8i,RAC 24*7 on call production DBA Support on Linux, Solaris, HP - UX, Dynix, Windows Server Environment including E-Business Suite Implementations with full project life cycle experience skills.
• Expertise in Design, Migration, Upgrades, Datacenter Consolidations,HA,Implementation of Database Systems to provide database support for systems/projects, rehosts, migrations, upgrades and conversions.
• Implementation of all Oracle's latest Tools/Products to the Advanced Global next generation Information Systems Client/Server Architecture Technology for large/medium/high Oracle Databases in Global Market Production/Development Projects in a good Advanced progressive environment.
• Experience in Multitenant, Configuring, Exadata administration, Administration and Management of Oracle Dataguard in 11g,12c,18c,19c version.
• Conduct design reviews with ITD Database Analysts, Computer Operations personnel, Systems Development personnel, and external vendors, as applicable, to validate the selected designs.
• Estimate space requirements for databases, tables, indices, and, as applicable, database backup and logging facilities. Capacity planning and space management at Database level and adding Disk Space at ASM with rebalance.
• Migrate, rehost schemas, databases refresh from Sybase to Oracle. Cloning, refresh and restore of the multitenant database from production to lower levels and between lower levels using different methods (RMAN, Netapp, Avamar,performing flexclone of database using nfs snapshot filers and database utilities).
• Perform Migration using Oracle Golden gate and troubleshooting issues arising during Migration and rehosts using Oracle Golden gate.
• Upgraded Oracle Database Appliance from version 2.8.0. to 2.10.10.
• Troubleshooting, administration,Plugging,Unplugging,Multitenant, Performance tuning, Dataguard operations, Oracle Enterprise Manager Issues, Oracle Golden Gate Services, Exadata, Oracle Database Appliance and support of Oracle Database issues in RAC and Non RAC environment running in different platforms.
• Oracle Data Centre Migrations, Consolidation and Upgrade, Migrations of Oracle Databases for different Oracle Versions and platforms. Patching and Cloning of Oracle and Oracle Apps Instances.
• Experience in Implementing and administration of Oracle Ebusiness Suite projects and upgrades of Oracle Ebusiness Suite instance from 11.5.8 to 11.510.2 and 11.5.10.2 to R12.
• System administration and troubleshooting of Concurrent Managers, Forms, Reports, Web server Printer issues on the Ebusiness Suite 11i instance, R12 instance, OID and SSL configuration.
• System Administration of Oracle Apps 11.0.3, 11.5.8, 11.5.10.2. Patching and Cloning of Oracle Instances and Oracle Apps Instances.
• Involved in Manual discovering of the Database for Data Centre consolidation Project by collecting relevant details in Data Centre for various variants Oracle, MSSQL, Informix, Ingres, DB2, MYSQL, Postgres, and Sybase and Updating the Validated and Verified data into CMDB (Atrium) Database. Done Physical Audit of all the Windows/Unix Servers in Banking Data Centre.
• Identification of the Service and Server Mapping for the discovered Servers and databases in data Centre. Mapping of dependency between servers, databases and applications. Capturing details of the live, decommissioned Databases, Obsolete version of Databases, DR details for the databases and Risks associated with the Database Servers.
• Monitoring and troubleshooting of M360 Alerts, OEM Alerts, Ctrl M job alerts and other Critical alerts generated from various applications through various monitoring mechanism.
• Involved in supporting day to day activities in 24*7 Prod DBA Environment consisting of 9i, 10g, 11g,12c,18c,19c RAC and Non RAC systems, Dataguard, stream, Golden Gate support, Exadata support.
• Performance tuning of Queries, Database Performance improvements on Critical production Environment. Performance tuning of SQL, PL/SQL Queries, tuning using dbms profiler, sqlt, Trace analyzer, RDA, ash reports, AWR report, AWR SQL Reports, In-Memory,AHM, Performance Hub Reports. Analysis of Wait events and analysis of trace files using debug commands.
• Modifying, Automation,creating of various shell Scripts for Services management, Process monitoring, Clearing logs, setting environmental variables etc. proactively and doing RCA and Post-mortems for them.
• Setting up of Oracle Best Practice’s Tools like SQLT, Oswatcher, RDA,TFA,AHM for monitoring and analysis of the database servers.
• Raising TAR and solving issues as part of bugs arising during Development and Production issues. Preparing Key -Reports, Metrics, RCA’s etc. for the management.
• Have worked on and implemented various Change Management process as per the ITIL Framework Environment, adhering to operational/business SLA required for the organization. Using Change Implementation Procedures Implementation of the database in Test, Dev, Qa and Production as per the Compliance (Build,IQOQ, SCS, GXP, NonGXP, SOX) and FDA requirements.
• Handled large databases size in production ranging from 1GB to 30 TB.
• Worked on Oracle features in Oracle 10g/11g/12c/18c/19c (Partition, Parallelism, Compression, In-Memory, Dataguard),Oracle 9iAS, SQL*PLUS, Pro*C, IMP/EXP, IMPDP/EXPDP, RMAN, ASMCA, DBCA, DMU,AutoUpgrade,SQL*Loader, Oracle Golden Gate Support.
• Exposure on Managing other Database Variants and tools like MSSQL Server 2000/2014/2016, MYSQL, Postgres Adaptive SQL, Sybase, DB2,AWS-RDS,OCI,Ansible
• Microsoft SQLServer Management and administration including Backup and Restore, Security Management,Reports,Performance tuning.
• Expertise on the data modeling techniques, tools as part of database design, conceptual, logical and physical data models generation, DDL engineering.
• Exposure in moving Oracle database to Cloud (AWS-RDS), Autonomous Database on OCI.
• Motivated to take independent responsibility as well as to contribute to be a productive team member. Strong Team building and mentoring skills and excellent Team leadership capability.
• Strong Logical and Analytical Reasoning Skills, Excellent Management skills, Excellent Communication with good Listening, Presentation and Intrapersonal Skills.
• Domain knowledge on the various enterprise practices (Telecom, Healthcare application systems and practices).
• Exposure working in different domains such as Wireless, Manufacturing, Telecom, Banking, Logistics, Mass Media, Communications, Financial and HealthCare.

TECHNICAL SKILLS:

Operating Systems: UNIX, SUN SOLARIS, RHEL, Dynix,VM,Windows,IBM,Dell Power Systems,AIX

RDBMS/Database: Oracle 19c/18c/12c/11g/10g/9i/8i/7.x, MSSQL Server 2000,2014,2016, MySQL, Postgres Advanced Server, MS Access

Other Tools/Tech/Reporting: Interconnect,Clusterware,ASM,SQL Loader,AWR,ADDM,ASMCATKPROF,TOAD,DBArtisan,PowerDesigner,Erwin,vi editor,RMAN, adadmin,adpatch,SQLT,Trace Anayzer,PLSQL Profiler,RDA,AHMOSwatcher,Oracle Golden Gate, Oracle Dataguard, Oracle streams, Oracle 10g/11g/12c/18c,19c/In-memory,Oracle Database Appliance, OEM12c,OEM13c,Exadata,Oracle Reports.

Other Applications: Oracle Apps 11i,R12,Oracle Interconnect 10g,Weblogic 6.x/8.x, BI,Forms/Reports 10g

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines

Senior Oracle Database Administrator

Responsibilities:

• The project involves setup, migration, rehosts, upgrades, maintenance, administration, monitoring, performance tuning, Cloud Migration and Implementation of Database support over international operations for the IT. Building on this momentum, Ortho’s core manufacturing, supply chain, customer service and finance enterprise IT platforms.
• The team to setup and support 24*7 critical on call production-oriented support and Development for systems associated with OCD.

Environment: Windows, Linux, VM, Active-Passive, Oracle 11g/12c/18c/19c databases, OEM 13c, Multitenant, MSSQL 2014,MSSQL 2016,Oracle backups using snapshot,RMAN,Clusterware,AvamarASM,AWS-RDS,OCI.

Confidential, Des Moines

Senior Oracle Database Administrator

• The project involves maintenance, administration, monitoring and Implementation of Database support over international operations consisting of hundreds of servers including SOX critical database servers.
• The team to support 24*7 critical on call production - oriented support for systems associated with Customers and Employees with strict adherence to Change Management Policy.

Environment: Linux,Solaris,HP-UX,AIX,Oracle 9i/10g/11g databases,RAC,CRS,Oracle Golden gate, Dataguard, Exadata,OEM 12c,Oracle Streams, Oracle backups using snapshot.

Confidential

Lead Oracle Database Administrator

Responsibilities:

• The project involves maintenance, administration, monitoring and Implementation of Database support over international operations consisting of 500+ servers including SOX critical database servers. The team to support 24*7 critical on call production - oriented support for systems associated with NBC universal and its customers.

Environment: Linux, Solaris,HP-UX,AIX,Oracle 10g/11g databases,RAC,CRS,ASM,Oracle Golden gate, Dataguard, OEM 12c,Oracle Database Appliance, Oracle RMAN using NetBackup.

Tesco,UK

Sr Oracle Database Administrator

• The Project involves provide DBA services for the Client/Server platforms for several systems development areas within ITD.Involved in Implementing database design requirements in continued support of HDS rehosting and Sybase conversions to Oracle. Provide database support for systems/projects prioritized for Prod, UAT, Test requests for DBA Air Ground (Line Haul users).

Environment: Linux,Solaris,HP-UX,Oracle 10g/11gc databases,RAC,CRS,ASM, Golden gate, Dataguard, Oracle Enterprise manager 12c,Grid,Oracle RMAN using SQL-Backtrack,Erwin,PowerDesigner.

Confidential

Senior Oracle Database Administrator/Tower Lead

Responsibilities:

• The Project involved discovering the IT infrastructure services (Servers, Databases, Applications, services) and creating a mapping based on the associated services and dependencies between them and identifying risks associated with all services and presenting to management for preparing road map for upgrade to latest versions.

Environment: Windows/Unix Servers (Different platforms), atrium, Oracle 8i/9i/10g, MSSQL Server7/2000, 2003, Ingres, DB2, Informix, Sybase, Postgres and MySQL

Confidential

Oracle Lead Database Administrator

Responsibilities:

• The Project involved maintenance, administration, monitoring, and Implementation of Database support over international operations consisting of 100+ servers includes SOX critical database servers.
• Using Database as means for managing entire network services including underwater communications globally. The team to support 24*7 critical on call production - oriented support with ITIL framework and process oriented Enviornment adhering to business SLAs.

Environment: HP-UNIX, Dynix, Solaris, Linux,Windows NT,Oracle Application 11.0.3, Oracle Application 11.5.8,Oracle Application 11.5.10.2,Oracle 8i/9i/10g/11g databases, RAC,CRS,ASM, Oracle Golden gate, Data guard, Oracle Enterprise manager,Grid,MYSQL,Postgres advanced server, Oracle RMAN using NetBackup.

Confidential

Senior Oracle Apps Project DBA

Responsibilities:

• The Project involved setting up of Oracle Database and Oracle Ebusiness Suite Implementation for managing their critical industry with implementation of Oracle latest trends of technology in their industry for better manageability and productivity.

Environment: HP-UNIX 11.11, Red Hat Enterprise Linux AS Release 4,Oracle Application 11.5.10.2,11.5.8,Oracle 9i database, Oracle 10.1,HP-UNIX 11.11,Oracle Application Interconnect