SUMMARY

I have over * years of hands-on experience as an Oracle, and 1 year as a PostgreSQL Database Administrator. Extensive experience Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Performance Monitoring and Tuning, RAC, Data Guard and Goldengate. I have worked on Oracle 12c, 11g, 10g versions on different OS platforms. I am good in communication, excellent team player and pay great attention to details.

SKILLS SUMMARY

Excellent experience in managing OLTP and OLAP databases of different sizes.

Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.

Executed and implemented user helpdesk tickets of various issues via REMEDY database from creating user accounts, read-only accounts on a database & table down to assisting them with logging into the database.

Experienced in using 11g features like 11g RMAN, Data pump Flash-Back Recovery.

Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

Expertise in maintaining Database Security using auditing.

Applying patches under UNIX platform.

Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data Pump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

Managed Oracle 10g & 11g databases in Data warehousing environment.

Starting/Shutting down the RAC databases, Creating and Relocating RAC database services to instances.

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

Proficient in Installation and configuration of oracle Golden Gate to support data replication in the Oracle database environment.

Apply PSU patch on standalone as well as rolling patch on RAC databases with no down time.

POC performed for migration of on premise PostgreSQL Databases (version 9.5.18) to azure Database for PostgreSQL using export/import, dump/restore and database migration service.

POC is in progress on Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL.

Monitoring of cluster ware files i.e., OCR files & Voting Disk files.

Monitoring the Database health check and growth with script.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.

Tablespace & Data file creation and Maintenance by Adding and Resizing data file if needed

UNIX Systems Administration - Database and application integration efforts. UNIX shell scripting, CRON jobs.

SKILLS SUMMARY

Department Of Energy – Washington DC

April 2020-Present

Monitor, troubleshoot and configure the Oracle database and infrastructure.

Work with Oracle 12c RAC environment, Oracle 12c features.

PL/SQL, SQL tuning, triggers, stored procedures, third-party tools, and transaction monitoring.

Building, maintaining, and communicating data dictionary for all data elements.

Physical and logical database design.

Perform both oracle and operating system performance monitoring and the necessary adjustments.

Knowledge of oracle real-time replication, backup and recovery scenarios.

Migrating code, database changes, reference data changes and menu changes through the development life cycle.

Perform reviews to ensure standards are being adhered to evaluate releases of Oracle and its tools and third-party products.

Patches, upgrades, and troubleshoots production and non-production databases.

Conducts performance tuning of indexes and optimization of storage functionality.

Reviews database design and integration of systems.

Kindred Healthcare - Hooksett, NH

Jun 2017 – March 2020

Oracle Database Administrator

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

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

Developed, DML, DDL, Oracle tables, triggers and UNIX shell scripts.

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

RMAN point in time recovery and Instance recovery done on 11g.

Developed compliance reports and performed auditing at higher levels.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture

Provided instance level performance monitoring and tuning for Wait events, Sessions, Physical and Logical IO and Memory Usage.

Experience in setting up Oracle ASM storage for Oracle RAC databases.

Performed database replication through Golden Gate.

Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.

Active participant in discussions related to Backup Strategy, DC/DR architecture. Maintained, patched, and upgraded servers as required.

Proactively update the latest security patches to database, which are provided by PostgreSQL open source community

Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON-CDB) Databases.

Applied the Cluster ware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for Bug resolution) using Opatch.

Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.

Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c. as part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1).

Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.

Planning and implementing DR & high availability solutions using Oracle 11g /12c Standby Database using Data guard.

Configured Bidirectional Oracle Golden Gate replication Active/Active across various sites with Conflict Detection and Resolution (CDR).

Configured Extract, Replicat for Golden Gate replication 11g/12c and Troubleshooting issues in Golden Gate Environment.

Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Data pump and Normal ) for restoring the specific objects at the database level.

Building Oracle Stand by databases, both Active Data guard for real-time replication and normal Data guard for disaster recovery also referred as BCP clone purposes.

Applied the Cluster ware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using Opatch.

Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c. as part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1).

Expertise in Analyzing data Quality checks using shell scripts. Upgrading, installing, and configuring PostgreSQL servers.

Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.

Ensure night corn jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF. Performing monthly and annual performance reports for trend analysis and capacity planning.

Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Worked on both VMS and UNIX environments.

Troubleshooting of various database performances by proper diagnosis at all levels like SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Cardinal Health - Sharon Hill, PA

Mar 2014 – May 2017

Oracle Database Administrator

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Tuned SQL with Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM)

Performed Database health checks, and used the notification tool to send the alerts in OEM Grid Control.

Supported and managed Oracle Real Application Clusters (RAC) environment on Red Hat Linux.

Built Physical standby databases using Data guard as part of the BCP disaster recovery strategy.

Identified database bottlenecks using OEM Grid Control, AWR, ADDM, STATSPACK, UTLBSTAT, UTLESTAT, ESTIMATE, ANALYSE, INDEXES, EXPLAINPLAN, SQLTRACE and TKPROF.

Automated the Data Replication process using Materialized Views for reporting databases.

Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

Implement policies to maintain database to make sure that the databases integrity and maximum availability.

Performance issue tracking and solution making using Stats pack analyze the report and find the root cause of the issue and provide best solution. Explain plan used to diagnose the long running queries, tuning applied if it required.

Virtual database setup to limit the user to access table columns only the admin not the application users. Oracle Advanced Security features like TDE (Transparent Data Encryption), Data Vault and Audit Vault.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.

Experience in working high transacted OLTP systems.

Creation of monthly IOT, creation and management of partitioned indexes and tables. Performance Monitoring and Tuning Databases and Application.

Partitioning for improving big tables to improve the Performance of the database.

Identifying bottleneck and rectifying it fine-tune store procedures to improve performance, database loads, performance improvements, proper setup of database files.

Performance tuning at database level for the parameters like SGA, PGA, PGA_AGGREGATE_TARGET.

Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance

Maintaining data integrity and tune database for optimum performance and availability.

Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

24 X 7 and on-call Production & Development database support and administration.

.

TECHNICAL SUMMARY

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 8, 9, 10. AIX 5.3, 6.1 RHEL 5.x., Linux Enterprise Server 9, 10. Windows 2012

RDBMS

Oracle 10g, 11g, 12c, PostgreSQL 11.x

Languages

SQL, PL/SQL, UNIX Shell Scripting

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

EDUCATION

Eleanor Roosevelt High School

Oracle 12c Certified

Oracle Database 12c SQL Fundamentals Certified

Oracle Cloud Infrastructure 2019

Oracle Cloud Infrastructure 2019 certified Architect Professional

Contact this candidate