Sr. Oracle DBA

Nihanth K

Email: adic1z@r.postjobfree.com

Phone: 732-***-****

PROFESSIONAL SUMMARY:

* ***** ** ********** ** Oracle Database administrator, having hands on experience in Exadata cloud at customer X7-2, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 19c/18c/12c/11g/10g on Sun Solaris, Red Hat Linux, HP-UX, and Windows Platform.

Experience in Installation, Configuration, physical and logical backups, upgrade/migration, Cloning, Data pump, Data guard, Performance Tuning, RAC, ASM, Golden Gate, on different HP-UX, Sun Solaris, Linux, UNIX AIX, and Windows servers.

Experience in installation, configuration and administering 2/3/4 node Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM) including active monitoring of ASM disk groups for their load balancing and redundancy.

Experience in upgrading the database from oracle 12c to oracle 18c/19c & oracle 11g to oracle 12c and migration of the databases using transportable database, tablespaces export/import, data pump utilities.

Experience with Building RAC, Data Guard, Golden gate, and RMAN.

Migrating databases to Exadata from AIX to LINUX.

Planned and implemented Oracle 18c RAC, 12c RAC and Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).

Experience in installing and patching ASM with Oracle (RAC) on AIX, Solaris and Linux platforms.

Experienced in configuring resource allocation, information sharing, and high availability with (RAC)

Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN).

Expertise on performing cold backups, hot backups, advanced recovery methods like flash back recovery using (RMAN) recovery manager.

Software and firmware maintenance (DOMU) of the Exadata storage servers in the Database machine including upgrades and patching.

Replicate schemas using Golden Gate schema replication which includes online change synchronization and ddl synchronization.

Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance.

Performance Tuning: Experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, (OEM) Grid Monitoring.

Implemented strategy for partitioning and management of historical data tables in RAC

Experience in proprietary change management processes to prevent production disruptions and outages.

24*7 production database support with support to developers & end-users.

Good communication and coordination with different departments (IT & Non-IT) for efficient problem escalation and deciding on optimal solution.

TECHNICAL SKILLS:

Operating Systems:

Sun Solaris 9/10, HP-UX 11i v1.5, AIX 6.1/7.1, RHEL 4/5/6, Windows all Versions.

Databases:

Oracle 19c, 18c, 12c, 11g, 10g, Sybase 15,16, Microsoft SQL Server 2008, 2012, 2014, 2016 Real Application Cluster (RAC), ASM, Goldengate.

DB Utilities:

SQL*LOADER, Data Pump, RMAN, Opatch, TKPROF, Statspack, AWR, ADDM, SRVCTL, CRSCTL, ASMCMD, ASMCA, DBCA, ADRCI and DBUA.

Tools:

Oracle Enterprise Manager 11g/12c/13c, TOAD 8.5, SQL Developer, Logminer.

Languages:

SQL, PL/SQL for Oracle, C, Java, Php, .NET

PROFESSIONAL EXPERIENCE:

Project: American International Group (AIG), Houston, TX Mar 2019 – Present

Role: Sr. Oracle DBA (Exadata cloud at customer)

Responsibilities:

24*7 on-call support with 50 production databases ranging in multi-Terabytes.

Supporting Oracle databases in multitenant architecture.

Supported databases on Microsoft SQL Servers.

Supported RAC databases comprising of up to 8 nodes.

Performed OKV related activities like OKV setup and container key sharing.

Created containers and pluggable containers on 18c and 19c.

Hot clone and cold clone of pluggable databases.

Unplug/Plug of the PDB’s from one container to another.

Migrated databases from 11g/12c to 18c and 19c (non CDB to CDB).

Cross-platform migration of databases from AIX to Linux using RMAN XTTS method.

Movements of containers across ExaCC machines.

Supported Dom 0 and Dom U patching with Oracle and System engineers.

Configured Data guard for disaster recovery setup along with broker configuration.

Administered ASM storage components.

Applied quarterly PSU security patches and one-off patches for both standalone and RAC environments.

Configured Oracle Enterprise manager 13c with multi oms.

Configured Enterprise manager agents and targets.

Implemented Incremental transportable tablespace update between two PDB’s on multitenant.

Upgraded Microsoft SQL servers from 2012 to 2014 and 2014 to 2016.

Performed POC on Snowflake databases.

Used Jenkins plugins to deploy codes for Continuous Integration - pull source code from a Git repository, resolve dependencies, build the code, and then deploy for testing and then move to production.

Worked on POC to Install and configure Uni-directional Golden Gate for data replication from on-premise to S3 in AWS environments.

Monitored storage and database usage, track performance and conduct maintenance operations.

Assisted application teams with database requirements and performance issues.

Environment: AIX 6.3,7.1, RHEL, Red Hat Linux 6.0, Oracle 19c/18c/10g/11g/12c, Oracle 18c GRID, Oracle RAC, Data guard, TOAD, SQL server 2016, 2014, 2012, SQL Navigator.

Project: UBS, Weehawken, NJ Sep 2016 – Feb 2019

Role: Sr. Oracle DBA

Responsibilities:

24*7 on call rotation supporting over 200 production database.

Worked on Oracle 11g and upgraded to 12c.

Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.

Installed and configured extended 11g RAC on Linux.

Created oracle database tables, materialized views, objects with storage parameters based on quarterly growth requirements of the system.

Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control.

Responsible for RMAN backups and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.

Install and configure Oracle Golden Gate.

Created Users, Roles and Profiles, Privilege management with role-based security.

Configuring and using Oracle Log miner and Oracle Flash Back for recovery of the objects.

Performed database tuning using Explain Plan, TKPROF, Statspack, AWR, ADDM, ASH, SQL Trace and other custom utilities.

Integration of Exadata monitoring and escalation.

Experienced in using 11g features like Database Replay, Partitioning, Logminer, and Schema Management.

Performed logical backups of schemas and database using Data Pump (expdp/impdp) as per requirement.

Installation of Oracle 11g Grid and respective agents on databases, application servers, predefine templates with group option to monitor Prod, UAT and Dev Databases.

Performed Cross platform migration using transportable, tablespaces and RMAN.

Monitored backups, space usage, and user activity on daily basis and Performed daily hot backups and weekly Cold backups using RMAN.

Altered, modified, Partitioned, dropped, created Database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM.

Trouble shooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.

Used Export/Import, DataPump Utilities to move the data between different databases and for backups.

Involved in deployment process from dev to production environments.

Implemented and supported Golden Gate replication in production databases.

Installed and configured Golden Gate on 11g RAC database running on ASM for replication.

Configured unidirectional Golden gate replications at table and schema level.

Troubleshooting Golden Gate issues such as process abending and lag on replication environments.

Environment: AIX 6.3,7.1, Sun Solaris 2.6/7/8, RHEL, Red Hat Linux 6.0, Oracle 10g/11g/12c, Oracle 12c GRID, Oracle RAC, Data guard, TOAD 8.6, SQL server.

Client: DTE ENERGY, Detroit, MI Aug 2014 – Aug 2016

Role: Sr. Oracle DBA

Responsibilities:

Implemented Oracle 11g active standby database and worked on building and rolling out new 11g databases for test, dev and production database environment.

Worked on upgrading of oracle databases from 10.2.0.4 to 11.2.0.4 and successfully Installed and Configured Oracle 11g Golden Gate on Oracle 11g Database.

Maintained load balancing and disaster recovery actions and resolved conflicts with triggers data looping lag through Golden Gate bi-directional replication.

Involved in 24x7 support for 4 Node production RAC database and maintained through CRSCTL and SRVCTL.

Documented the necessary procedures as per the industry requirements for data guard, RAC installation and DataPump setup processes.

Configured Active Data Guard (physical Standby) to ensure high availability, data protection and Disaster recovery (DR) for enterprise data.

Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

Involved in setting up Grid Control for Monitoring Exadata X3 and upgrading exadata database machine from half rack to full rack.

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.

Configured unidirectional Golden gate replications at table and schema level.

Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.

SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and STATSPACK.

Performed Cross platform migration using transportable tablespaces and RMAN.

Performed full and incremental backups using RMAN and created catalog database.

Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN incremental backups.

Extensively used Oracle Application Server 10g, in deploying and integrating enterprise’s applications.

Migrating and upgrading the Oracle 10.2.0.5 database to Oracle 11.2.0.4 also performed version upgrades and patch installs.

Loading bulk data from flat files using SQL*loader and external tables.

Environment: Oracle 11g/10g, SQL, TOAD (10.1), RMAN, OEM, SQL*Loader, TKPROF, Data Guard, Shell Scripts, Golden Gate, AWR, ADDM, Windows 2008, RHEL 4.0, AIX-5.3

Project: BSNL, Hyderabad, India Jul 2012 – Jul 2014

Role: Oracle DBA

Responsibilities:

24x7 production database support

Installed and maintained 10g/11gR2 databases for testing, development and production

Database Monitoring and administration of database using Enterprise Manager Grid control (OEM).

Upgraded Oracle Database from 10g to 11gR2.

Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods.

Installed and configured oracle grid control.

Performed logical backups of schemas and database using DataPump as per requirement.

Performed Cold backup, hot backup using conventional backups and RMAN, recovered various and critical Production databases.

Assisted in management and database administration of Oracle database applications on Exadata platforms.

Prepared backup schedule which include offline, online and logical backups.

Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.

Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.

Generated performance reports and Daily health checkup of the database using utilities like AWR, Statspack and ADDM to gather performance statistics.

Partition of tables to improve performance.

Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.

Worked on SQL* Loader to load data from flat files, checking for Row Migration and Chaining on Highly used transaction tables.

Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Created DB links across databases and Solved Database connectivity issues by continuously monitoring the status of the listeners and instances.

Checked alert logs and background trace files on daily basis and resolved problems.

Automated shell scripts and scheduled batch jobs.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Data Guard, Shell Scripts, AWR, ADDM, RHEL 4.0.

Certifications:

Oracle Autonomous Database Cloud 2019 Specialist.

Oracle Cloud Infrastructure Foundations 2020 Associate.

Contact this candidate