SUMMARY

• Over 11 years of Database Administration Experience.
• Provided day to day Database operations support.
• Provided support on - call rotation.
• Worked with Developers, Application, storage, OS and network teams on projects.
• Managed 10g, 11g, 12c and 19c Databases.
• Provided support for databases on EXADATA servers.
• Lead many Disaster Recovery Exercises.
• Sumo Logic certified.
• Managed 12c and 13c cloud control.
• Expertise on DMU tool for character set migration.
• Worked on DATAPUMP to clone tables, schemas and databases.
• Proficient in oracle RDBMS including SQL, PL/SQL and all areas of database administration.
• Create and maintain users, roles and privileges.
• Supporting and Documenting implementation of approved changes to system configurations and infrastructures within approved testing schedule.
• Setting up privileges to create local and remote objects.
• Performed Relink of binaries on standalone as well as RAC
• Build ASM disk groups and managed ASM databases
• Build and Administered 4 node RAC Cluster.
• Proficient in managing database on RHEL and Windows Environment.
• Upgradation of database to 18c and 19c.
• Performed Security administration tasks, setup users accounts, passwords, roles, profiles and quota.
• Good exposure of advance security using Database trigger, Auditing.
• Migrated from non-ASM to ASM databases.
• Proficient with Oracle Performance Tuning using ASH, AWR, ADDM and dynamic views.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Installed CPU, PSU and one-off patches.
• Very proficient with RMAN restore and recoveries of databases.
• Set up jobs from 13c cloud control.
• Setup monitoring of databases from OEM.
• Worked on various exports imports from exp/imp and Data Pump.
• Proficient in RHEL and other Linux platforms.
• Monitored data files, logical data storage and data growth activities.
• Worked with storage admins on ASM needs.
• Migrated Databases to AWS.
• Worked on project to migrate databases to AWS instance
• Set up oracle instances on AWS cloud.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Proficient in Scheduling backups using ZDLRA appliance.
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented
• Restore procedures for complete and incomplete recovery using RMAN.
• Performed capacity planning required to create and maintain database environments.
• Clone Database using RMAN duplicate / Export Import / Data Pump
• Create thorough documentation of installation procedures and administrative tasks in the clustered environment.
• Worked with Oracle on open issues.
• Worked with offshore/onshore teams.
• Strong leadership and management experience.
• Provided 24 x 7 support and flexible to work beyond regular hours.

TECHNICAL SKILLS

OS: RHEL, AIX, Windows

Languages: SQL, PL/SQL, Unix Shell Scripting

Databases: Oracle 19c,18c,12c,11g, 10g, RAC, Exadata

Data Appliance: Exadata, ZDLRA

Cloud: AWS, ORACLE

Documentation: Microsoft SharePoint, Word, Project, JIRA, EXCEL

Tools: /Utilities: SQL Loader, TKPROF, Export/Import, RMAN, Oracle OEM, SQL Developer, SQL Plus, Data PumpExplain plan, TOAD, Exadata, GoldenGate, AWS, MS Teams

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Worked as an Operations DBA performing day-to-day production database monitoring.
• Worked with Developers, Application, storage, OS and network teams on projects.
• Proficient to work in Cross trained environment.
• Performed Relink of binaries on standalone as well as RAC.
• Worked on Database migration projects.
• Lead many DR Exercises with a success rate of 99.9%.
• Build Physical Standby Data Guard for Disaster Recovery project.
• Build Active Data Guard for Business Reporting applications.
• Performed health checks in RAC
• Managing Database Structure, Storage Allocation, Table/Index segments, Undo segments, Constraints, Database Access.
• Managed databases from command line, TOAD, SQL Developer and OEM.
• Proficient in using 13c Cloud Control, OEM to monitor and setup alerts.
• Expertise in Tablespace Management.
• Performed Security administration tasks, setup users accounts, passwords, roles, profiles and quota
• Expertise in User Management.
• Resolved various performance Tuning scenarios
• Involved in SQL Query tuning.
• Used Export/Import to do table level and full database defragmentation.
• Performed Tablespace Reorg on monthly basis.
• Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.
• Refresh databases using export import and Data Pump
• Cloned database using RMAN
• Refresh databases using export import and Data Pump
• Worked on DMU tool for characterset migration.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Migrated Databases to AWS.
• Set up oracle instances on AWS cloud
• Familiar with EC2 and VPC environment.
• Ability to perform database code migration, change management and data management through the various stages of the development life cycle.
• Ability to independently investigate, analyze and troubleshoot problems, to determine and provide accurate resolution and root cause.
• Provided support for databases hosted on Exadata.
• Trained new team members to help them deliver required output by company.
• Involved in all phases of Project life cycle.
• Provided 24/7 on-call support.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Build many 2 node RAC clusters.
• Migrated databases from standalone to cluster.
• Migrated databases from non-ASM to ASM
• Worked with Developers, Application, storage, OS and network teams on projects.
• Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, and Data Guard.
• Worked on DMU tool for characterset migration.
• Performed Relink of binaries on standalone as well as RAC
• Build Physical Standby Data Guard for Disaster Recovery project.
• Build Active Data Guard for Business Reporting applications.
• Performed health checks in RAC instances using crsctl and srvctl utility.
• Worked with offshore developers and DBAs.
• Managed databases from command line, TOAD, SQL Developer and OEM.
• Troubleshoot OEM Agents.
• Restore and recovered databases using RMAN
• Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY
• (PITR)of databases.
• Expertise in Scheduling and maintaining database backups using ZDLRA
• Expertise in Tablespace Management
• Expertise in User Management.
• Resolved various performance Tuning scenarios
• Applied patches to Grid Infrastructure and RDBMS homes
• Applied CPU and PSU patches.
• Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment.
• Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Create thorough documentation of installation
• Involved in SQL Query tuning
• Used Explain Plan, Oracle hints and creation of new indexes, to improve the performance of SQL statements.
• Provided 24/7 on-call support.
• Refresh databases using export import and Data Pump
• Cloned database using RMAN Duplicated database.
• Provided support for databases hosted on Exadata.
• Setup jobs vai crontab and 13c cloud control.
• Troubleshoot performance and network connectivity issues.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Monitoring database events as part of a Production support and level 1 staff.
• Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY
• (PITR)of databases.
• Proficient in migrating data base from 9i/10g to 11g by applying latest patch sets.
• Configured RAC on oracle 11g RAC.
• Involved in administration of over 150 Oracle 11g/10g R2 instances.
• Implemented Oracle advanced security across various database levels.
• Developed Oracle Forms and Reports for the user interface; a data load using PL/SQL and SQL Loader; and Unix scripts to download and manipulate files
• Development of PL/SQL and Web PL/SQL stored procedures.
• Proficient in Oracle Materialized view replications.
• Installation and maintenance of Oracle 11g database.
• Involved in the process of tuning and refining queries of various applications.
• Implementing 10g Data guard with one physical database
• Converted a single instance database to Oracle RAC 10g.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Extensive usage of ADDM, AWR, ASSM, features of 10g.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Cloning of application from production environment to test environment and application of patches.
• Moving data from development to production through transportable tablespace exports.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Implementing standby database and database replication to provide high availability f database.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Involved in team management, team building exercises for the DBA team.