Database Administration Oracle

Prathap Putha

Oracle Certified Professional (OCP) in Oracle Database Administration.

AWS Certified Solutions Architect – Associate.

***********@*****.***

Cell: 609-***-****.

Professional Summary:

Senior Lead Oracle Database Administrator (DBA) with Fourteen (14) years of experience in Database Administration, Installations, Configurations, Upgrades, Patches, Performance Tuning, Backup’s and Recovery, Space management, Cloning, Migrations, Shell scripting, Production Support, and documentation.

Experience working with government clients, the States of New Jersey, State of Washington and State of Colorado.

An experienced professional in Oracle and PostgreSQL database administration with AWS.

Extensive experience in database administration for Oracle 9i, 10g, 11g, 12c, 18c, 19c and 21c with experience within very large scale database environment and mission critical large systems.

Excellent experience in installation, setup and configuration of Oracle 21c, 19c, 18c and 12c in RHEL, IBM-AIX and Windows Environments and Oracle Real Application Cluster and SAP.

Hands on experience in Exadata DMA, PostgreSQL and AWS, management and database administration of Oracle applications on Exadata Quarter RACK and Half RACK platforms.

Exadata Machine Administration - configure and administer racks, ASM, and grid infrastructure patching.

Oracle - Installs, upgrades and Patches Oracle Exadata databases and Oracle Applications.

Good experience in Oracle technologies like AWR, ASH, ADDM and Export and Import utilities.

Data Guard - configuration and administration for RAC (Real Application Cluster).

System health monitoring and proactive correction of issues.

Creating users, tablespaces, logs, Performance tuning, Upgrades, Capacity management, Disaster Recovery, Backup and Cloning and Technical Patch Management.

Experience in Performance tuning of very large Oracle databases in AWS (30+ TB).

Install and Build database structures. And Documentation of database processes in Linux / UNIX operating systems (Red Hat and AIX). Oracle Database monitored with Control-M, Jenkins and Foglight tools.

Experience in Overall maintenance, administration, monitoring, problem management, and production for Oracle databases and PostgreSQL databases and knowledge on ZDLRA.

Experience in Database management with Oracle RAC, Grid infrastructure (ASM & Cluster), Data Guard (logical and physical standby), Configure OEM, setting up of alerts and resolving issues.

Converted Physical standby database to Snapshot Standby and Snapshot Standby to Physical standby in Oracle Data Guard (ODG) and monitored in Oracle OEM Cloud control.

Configured OMS and OEM on RHEL and Windows Server. Hands-on experience with CI/CD methodology.

AWS Cloud expertise in administration, migration and enterprise configurations.

Developed technical presentations for clients using Microsoft Office Suite.

Worked on Multitenant Database Migrations from Non CDB to CDB and PDB. And applied quarterly patches.

Working knowledge of Oracle Data Guard and standby database and Golden Gate.

Working knowledge of Oracle Golden Gate and database replication. Created Read Replica Database for Production Database. Learning PostgreSQL. Involved in Capacity planning and build activity.

Experience with Database Migration from Non-Cloud Servers to Cloud Servers.

Working experience and supported for data warehousing and ETL Informatica databases.

Education

Bachelor of Information Technology from JNTU Hyderabad – 2006 – India.

Certification

Oracle Certified Professional (OCP) in Oracle Database Administration.

AWS Certified Solutions Architect – Associate.

Technical Skills:

Databases : RDBMS, Multitenant, Oracle 23ai, 21c, 19c, 18c, 12c, 11g, 10g, and 9i.

Oracle Products : Golden gate, ZDLRA, Oracle Exadata, Data Guard Broker, OEM, RMAN, ASM and RAC

Programming Languages : SQL, PL/SQL, JAVA, C, C++

Operating systems : OEL, RHEL, AIX, Solaris, Windows XP, 2003, 2008, 2010 and 2012.

Other Tools : SAP, RDBMS, Jenkins, APEX, BMC, Control-M, ETL, Python, Foglight, PostgreSQL, MobaEx, MS Office Suite (Word, Excel, PowerPoint, MS Visio, MS Project)

PROFESSIONAL EXPERIENCE:

Freddie Mac Oct 23 to till date

Lead / Sr. Consultant.

Responsibilities:

Responsibilities in Database Migration from On Primes to AWS – EC2 Instances on Cloud.

Expertise in Oracle database backup/recovery, high availability, data replication solutions, and applying quarterly security patches. Working with Oracle Databases 19c and Multitenant concepts (CDBs and PDBs).

Proficiency in managing Oracle DB and client requirements. Working Capability with RAC.

Performed in Migrating Oracle 12c - Oracle 19c and AWS RDS, EC2, S3, IAM and Cloudwatch.

Understanding in Oracle Real Application Clusters and Oracle DataGuard and Golden Gate environments

Interaction in Migration from on premises database to PostgresSQL Administration using SCT.

Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.

Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.

Installing and Configuring PostgreSQL from source or packages on Linux machines.

Setup and maintenance of postgres master-slave clusters utilizing streaming replication

Converted Physical standby database to Snapshot Standby and Snapshot Standby to Physical standby in Oracle Data Guard and working grasp in Golden Gate.

Working proficiency on ORACLE EXADATA for the extreme performance of the database.

State of New Jersey, NJ. May 21 to Oct 23

Sr. Consultant

Responsibilities:

Experience in Oracle database backup/recovery, high availability, data replication solutions, and applying quarterly security patches and Implemented Oracle GoldenGate unidirectional in Prod environments.

Working experience in Oracle Multitenant CDB/PDB administration along with migration from non-CDB to PDB.

Experience in performing optimization and tuning activities, including capacity planning, tracking historical usage, trending future resource needs, and modifying resource allocations as needed.

Experience in Monitoring, Backup/Recovery Management, DB Provisioning/de-provisioning, DB refresh/restore, HA/DR, Patching, migration, replication, and upgrades and ZDLRA.

Experience in Understanding of Incident Management, Problem Management, and Change Management and in tools such as Service Now, JIRA, and Confluence for Oracle Database and Golden Gate.

Migrated On Premises Oracle Database to AWS RDS Database and EC2 Instances as well.

Non-RAC to RAC conversions, Non ASM to ASM migrations. RAC node crash and instance failovers.

Excellent knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN

Charter Communications, CO. Aug 20 to May 21

Lead / Sr. Oracle DBA

Responsibilities:

24x7 Production Database administration and applications support

Supporting multiple databases for Production, Development, Test and Staging purposes

Applying upgrade patch, maintenance (opatch) Patches on all the Exadata databases.

Refreshing Dev and test instances with data from Production on a regular basis.

Provided performance tuning of Oracle Databases on Exadata.

Experience with RMAN point in time recovery and Instance recovery done.

Converted Physical standby database to Snapshot Standby and Snapshot Standby to Physical standby in Oracle Data Guard. And Implemented Golden Gate Unidirectional.

Applied Patches for every Quarter for Standalone and DataGuard Databases

Upgrade and Migration of Database from 10g to 11g and 11g to 12c applying patches whenever required.

Monitoring and optimizing the performance of the Databases and Golden Gate

Worked on Multitenant Database Clones from one CDB to CDB Databases.

Oversaw setting and managing USER MANAGEMENT, SPACE MANAGEMENT, Granting required privileges to users.

Troubleshoot and resolve RAC and Redhat clustering issues in database environments.

Experience in Installing Oracle release updates (RU) security patches on data guard, multitenant, stand alone and Real Application Cluster (RAC) databases

Experience in accountable for building, managing, operating, and continuously improving Database and Tools Infrastructure that support customer facing applications, back-office, and provisioning infrastructure in a 7*24 environment.

State of Washington, WA June 19 to Aug 20

Lead / Sr. Oracle DBA

Responsibilities:

Providing 24X7 production support for critical Payments, Financial, and connectivity applications’ Oracle 19c and 18c databases on RHEL and Windows.

Worked on Database Migrations from On Premises to AWS RDS Database

Worked on Quarter Rack and Half Rack Exadata on X6 and X7 machines.

Worked on Database Migrations from one datacenter to another datacenter and enabled monitoring.

Used OEM (Oracle Enterprise Manager) to setup matric alerts and Performance Tuning as well.

Applied Patches for every Quarter for Standalone and DataGuard Databases

Piloted the Planning and Migration of Oracle databases from In-premises Datacenters to AWS Cloud including homogeneous and working experience with Oracle Golden Gate.

Experience in Database Migration from on Primacies to AWS RDS Database using Export and Import

Working experience with Applying Patches for Database Release Update and OJVM Components

Worked on Multitenant Database Refreshed from one CDB to another CDB and PDB databases.

Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard

Working experience with Adding node and Deleting node in RAC databases.

Supported for 3-to-4-week sprints and therefore need to be quick and agile.

State of Colorado, CO Dec 16 to Jun 19

Lead / Sr. Oracle DBA

Responsibilities:

Worked on 2 Node RAC on Production Database for High Availability.

Applied Quarterly patches for Oracle Database

Worked on Half RACK Oracle Exadata Database Machine Administration

Database Monitored through OEM 12c Cloud control.

Worked on Multitenant Database Services for each Pluggable database and Container database well.

Converted Physical standby database to Snapshot Standby and Snapshot Standby to Physical standby in Oracle Data Guard.

Strong experience in allocating system storage and planning future storage requirements for the database system.

Experience in Utilizing Change Management controls to implement Code changes in Production and non-Production instances.

Proactive monitoring, provide and implement database and application performance tuning recommendations with the help of ADDM / AWR / ASH / SQL tuning advisors.

Experience in Database Design and Architecture, Database Installation and Configuration, Data Security and Integrity.

Experience in Performance Tuning and Optimization, Backup and Recovery, Database Maintenance, Troubleshooting and Issue Resolution, And Capacity Planning.

Proficiency in replicating and/or migrating Oracle databases to the Cloud (preference for on-premise to VMware’s Cloud Disaster Recovery (VCDR) environment.

Experience in Reviewing database design and integration of systems, and makes recommendations regarding enhancements and/or improvements and Golden gate.

Collaborated with other Application DBA staff, senior infrastructure DBA staff, developers, and other technical staff to ensure that best practices are followed for relational database design, database configurations, and installation options.

Worked on Multitenant Database Migrations from Non CDB to CDB and PDB. And applied quarterly patches.

Eli Lilly, NJ Apr 16 to Dec 16

Lead / Sr. Oracle DBA

Responsibilities:

Installed Oracle database and Oracle Grid Infrastructure software on IBM clusters.

Experience in focus on building, deploying and stabilizing code, services, systems, tools; driving standardization and service focused instrumentation, resolving break/fix scenarios, engaging broader teams as necessary.

Have Strong knowledge in Oracle Database administration including oracle cloudbased databases (11g above databases)

Experience in knowledge and understanding of supporting Oracle DB production instances in a 24x7 days environment including process management

Experience in knowledge using OEM, DBCA, Databases Creation, Database Configuration, Backup and Recovery and SQL tuning and Maintenance work like patching & upgradation, RAC, Data Guard, ASM disks, SQL and other shell scripting.

Experience in implementing and supporting Oracle on AWS including EC2, RDS and S3 buckets. And Oracle based ETL processes.

IBM, India Mar 11 to Nov 15

Oracle DBA

Responsibilities:

As a Oracle DBA, Installation, configuration, maintenance and tuning of Oracle 11g and 10g.

Worked as a part of team in Data Center Migration project for 6 months.

Daily database administration tasks including backup and recovery through RMAN.

Performed data transfer using Export and Import

Created Build Plan for Quarterly Patches and Database Upgrades

Created NEVER expiry profiles for all system USERS

Worked on Database Health Check for every Quarter.

Worked on query performance tuning for long running queries.

Applied patches for every quarter in Oracle database.

Worked on Exports and Imports for Schema Refresh task.

Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.

Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.

24x7 remote support and on call Database support for Database developers & end-users.

Experienced in implementing Oracle Database Patches.

Implemented Oracle Dataguard for PROD Environments.

Successfully configured and installed Oracle Golden Gate for replication.

Helped in developing applications based on Oracle Exadata platforms.

Maintained the Heart beat tables to check the lag between the sites.

Installation and configuration of 11g Database on AIX.

Worked with application team to resolve conflict handlers and the replication issues.

Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard

Environment: Oracle 9i,10g and 11gEXP, IMP, IBM-AIX, Windows XP/NT, PL/SQL, SQL, Supported Applications like SIEBEL, OBIEE, Hyperion, WindChill, PeopleSoft, JD Edwards and ServiceNow. RDBMS, Jenkins, PgAdmin, BMC, Control-M, Putty, PostgreSQL, MobaEx and Secure CRT.

Contact this candidate