Oracle Database with NoSQL experience

SUMMARY (Total Working Experience: ** years) **OCI certified (Oracle Cloud Certified)

Working as Oracle DBA Lead with hands on experience on Exadata, Performance Tuning, OEM, RAC, RMAN Backup etc.

Experienced in working with AWS Cloud.

Having 9+ years of working experience as an Oracle DBA.

Having 8 years of working experience on Oracle RAC, Exadata.

Having 5+ years of working experience on oracle database Performance tuning.

Having 3+ years of working experience on Goldengate.

Having 4+ years of working experience on MySQL Database admin.

Having 4+ years of working experience on MongoDB Administration.

Knowledge on installing and configuring PostgreSQL database and Administration.

Performing Database Reviews by analyzing the whole database and implementing the changes for better performance.

Experience working on AWS Cloud EC2, S3, RDS.

Experience in migrating the on premise databases to Cloud environments.

Hands on experience with Cluster upgrade from 11gR2 to 12.1.0.2 on AIX, Exadata and Super cluster.

Hands on experience with installation and administration of Oracle RAC (11gR2) with ASM.

Experienced database upgrades from 10gR2 to 11gR2, 11gR2 to 12cR1.

Performed database upgraded 11gR2 to 12CR2, 12C to 19C.

Experience in grid software upgrade from 11g to 12C, 12c to 19C grid.

Installed 12C grid software and configured the RAC databases.

Efficiently worked on node addition to the RAC cluster.

Experience working with multitenancy databases CDB, PDBs.

Installation and configuration of Oracle database on UNIX (Solaris,IBM AIX,RHEL and Hp-UX),Windows.

Hands on experience with Data Guard configuration (Physical and Cascaded Standby) and DR drills.

Backup and Recovery Procedures using export/import, datapump, RMAN, physical backups.

With good knowledge of post installation troubleshooting, installation and configuration, upgradation, migration, backup & recovery, security, applying patches.

Zero Downtime Migration to Oracle Exadata with Oracle Golden Gate.

Migrated the databases to Exadata using Oracle Dataguard.

Migration of databases from Oracle 8i to 10g R2. The role involved in installation, configuration & upgradation of oracle server software on Solaris and Linux boxes Using TTS method.

Database Performance Tuning – Understanding AWR, ADDM, ASH reports and using the same for performance improvement measures.

Expertise in performing Table Reorg, Re Indexing and Analyze Activities during off peak hours

Database Performance Tuning-Understanding 10046, 10053, SQLT trace files and using the same for better execution plans.

Creation of tablespaces, user maintenance, database security imposition by creation and granting of roles and privileges.

Continuous and consistent track record of working on production/development and DR Site environment involving Oracle RDBMS 10g, 11g and 12c.

Hands on experience on Shell Scripting.

Documentation Report/Review – Site Documents, System Study, Backup Policy, Security Policy, Activity Report, Incident Report, etc.

Demonstrated ability to handle Oracle DBA activities independently.

A team player with strong communication, analytical, logical and problem-solving skills, ability to work under pressure situations.

Willingness to participate in a highly productive, team-oriented environment.

Proven ability to work under pressure of time constraints and to prioritize assignments necessary

Proven ability to work effectively and provide support within a technical team

Education

Bachelor of Science in Computer Science, 2007

ACHIEVEMENTS /TRAININGS

Oracle Cloud Infrastructure Architect Professional 2019 Certified.

Oracle Certified Associate 12C Database Administration.

Oracle Database 11g: RAC Administration training received from Oracle.

Goldengate Administration training received from Oracle.

Implemented Table Partitioning in critical applications by coordinating with application teams for better performance and simplifying the maintenance.

Performed Database Reviews and implemented the changes for better performance.

SKILL SET

OS : RHEL, IBM AIX, Sun Solaris, Windows, HP-UX.

Languages : SQL, PL/SQL

Database systems : Oracle 10g, 11g, 12c, 19C, RAC, MongoDB, MySQL.

Oracle Tools/Utilities: Oracle Enterprise Manager, TOAD, DBCA, NETCA, Export/ Import,

Data pump, RMAN, Explain Plan, AWR,

ADDM, TKPROF, OPatch, srvctl, crsctl

PROFESSIONAL EXPERIENCE

1.COMCAST Dec 2017 to till date

Lead ORACLE DBA

Environment: - Oracle 11g, 12c, 19c RAC, EXADATA, Goldengate, MySQL, MongoDB

Responsibilities:-

EXADATA activities.

Migrating databases to EXADATA.

Performance Tuning.

SQL Statement Tuning.

Database upgrades to 19C.

Grid upgrades to 19C, RU, PSU Patches.

Goldengate.

Database/OS monitoring automation Using Scripting.

On-call support for escalated issues.

Supporting administering MySQL and MongoDB databases.

2.General Electricals Nov 2016 to Nov 2017

Senior Database Administrator

Environment: - Oracle 10g, 11g, 12c, RAC, Oracle Exadata environment, MySQL

Platform: - IBM AIX, Linux, Solaris.

Responsibilities:-

Performing Daily Health Checkup of several databases and submitting report for the same.

Monitoring & Management of Tablespace and Data File growth in ASM and Non-ASM.

Database installation and configuration for new applications.

Monitoring CPU resource utilization and server disk space utilization.

Server/Storage Migration Planning.

Performance Tuning.

Grid Upgrade, Grid Patch, Oracle Patch Apply.

SQL Statement Tuning.

Database/OS monitoring automation Using Scripting.

RMAN Restoration to ASM to ASM, Non-ASM to ASM.

Datafiles movement between the diskgroup.

Migrated the databases from standalone DB servers to Exadata Db servers.

Raising Service Request with Oracle Support.

3. ICICI BANK. Nov 2014 to Nov 2016

Senior Database Administrator

ICICI Bank is India's second-largest bank .Bank has a network of 4,050 branches and about 12,964 ATMs in India and presence in 17 countries.

Environment: - Oracle 10g, 11g,12c, RAC, Oracle exadata and Supercluster environment.

Platform: - IBM AIX, HP-UX, Linux, Solaris and windows

Responsibilities:-

Performing Daily Health Checkup of several databases and submitting report for the same.

Oracle Installation, Database Induction.

Monitoring & Management of Tablespace and Data File growth in ASM and Non-ASM.

Monitoring CPU resource utilization and server disk space utilization.

Renaming/relocating of data files and multiplexing redo logs and control files.

Activity Planning and execution.

Server/Storage Migration Planning.

Performance Tuning.

Oracle Patch Apply.

SQL Statement Tuning.

Installation and migration of database from Oracle 10gR2 to 11gR2,11gR2 to 12cR1 and applying PSU on Oracle databases.

Database/Os monitoring automation Using Scripting.

Raising Service Request with Oracle Support for errors.

Performing Restoration drills.

Performing activities like Index Rebuild for removing fragmentation, improving database performance and effective space management.

Gathering statistics of important schemas to improve performance.

Configuring and managing Physical Standby for single instance and RAC databases.

Performing Switchover and Switchback of Production databases.

DR Activation.

Testing and Implemented Graceful Switchover and Switchback.

Testing of Active-Passive node failover on IBM SVC Cluster.

Implemented 11gR2 RAC on AIX,Solaris.

Adding disks in ASM diskgroups, managing RAC databases

Undertaken Table Partitioning activity, Database Reorg,SPA.

Exadata & Supercluster Activity:

Cluster upgrade from 11.2.0.3 to 12.1.0.2.

Grid disks Resize on Super cluster.

Health check of Exadata & Supercluster using Exacheck utility.

Coordinating with Oracle support for patching on Exadata and supercluster machines.

Database migration from Sun Solaris to Oracle Exadata and supercluster machines.

Troubleshooting problem on Exadata server.

4.YOU Broadband April 2013 to Nov 2014

Database Administrator

Environment: - Oracle 8i,9i, 10g

Platform: - Redhat Linux, Solaris and windows

Responsibilities:-

Responsible for both managing and supporting all Production, Development and Staging instances of Oracle Version 8i, 9i and10g.

Installation of Oracle 10g.

Migration of databases from Oracle 8i to 10g R2. The role involved in installation, configuration & upgradation of oracle server software on Solaris and Linux boxes Using TTS method.

Creating a New database and Cloning Existing Database.

Creation of database Users and setting the default tablespaces, Assigning quotas, roles, privileges and profiles to users.

Configured the physical standby database with delayed sync from production within the DC.

Configured the Physical Standby for high availability and Disaster Recovery Plans.

Creating the necessary tablespaces, data files.

Proactively Monitoring file system growth, Alert Log and Archive Destination.

Performing schema refreshes using Datapump.

Configured Dataguard and its management.

Physical Database Backup and Recovery (hot and cold backups, RMAN), Logical Backup using Oracle Utilities (Export and Import, Datapump).

Applied database patches using Opatch utility.

Index creation & rebuilding to improve the query performance.

Performing the regular proactive and preventive maintenance activities

of databases like Re-org, regular analyze of tables.

5. Netcomm IT Solutions June 2011 to Mar 2013

Database Admnistrator

Environment: - Oracle 9i,10G

Platform: - Redhat Linux, Solaris and windows

Responsibilities:-

Creation of users and roles for different projects and working closely with the developers during its release cycles.

Created and maintained Databases manually as well as using DBCA.

Monitored Oracle Instances, Users, Tables, Tablespaces, Memory Structures, Redo Logs, Archive Logs and Alerts.

Monitoring database health blocking sessions, long running sessions etc.

Responsible for granting required privileges and roles to users.

Monitoring all Oracle and Operating System service/processes up and running.

Experience with Working with Oracle Data Guard which is used for Disaster Recovery.

Used Data pump for exporting and importing tables, schemas and table spaces

Experience with Backup, Cloning, and Recovery using RMAN utility

Srinivas Reddy A

Contact this candidate