SUMMARY

• An Oracle Database Administrator wif over 5years of experience. Advanced skills in Installation, Configuration, Migration, Database Backup & Recovery, Dataguard implementation, Tuning at Instance level and SQL level, Cloning, Space Management, Database Security, Auditing, Troubleshooting, Managing Oracle 11g /12c databases, PostgreSQL and documentation in heterogeneous environments. Worked on various PostgreSQL versions like 9/10 Databases across various platforms such as Solaris, UNIX, Linux.
• Over 5 years of experience in Oracle/Postgres SQL database administration in heterogeneous system environment including Solaris, UNIX, and Windows.
• Performance tuning of teh database - SQL Tuning, Used Tuning utilities like, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Expertise in Oracle's Data protection, high availability, and performance technologies such as Oracle Dataguard, ASM, and Oracle glodengate.
• Experience in PostgreSQL RDBMS wif noledge of installations and Configurations, Backups, Warm/Hot Standby/Streaming Replication, pgbouncer.
• Configuring PostgreSQL Streaming Replication and Pgpool for load balancing.
• Managing teh monitoring tools for better performance like PgBadger.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Responsible for all backup, recovery, and upgrading of all teh PostgreSQL databases.
• Experience in administration and tuning of Oracle databases running on Windows and all types of UNIX platforms.
• Experience in Dataguard for different types of Standby Databases such as Active for reporting, Physical, Logical, and Snapshot standby on implementation, administration, & performance tuning.
• Experience in implementation, configuration, troubleshooting, and performance tuning of Oracle Glodengate replication between Unidirectional Oracle Databases.
• Experience in Performance Tuning Oracle Databases wif respect to all aspects of IT Infrastructure such as Network, OS, Storage, and Application.
• Experience in using various performance tools or utilities like EXPLAIN PLAN, AWR, ASH, and ADDM, and analyzing reports for tuning recommendations.
• Experience in implementing desired database backup solutions based on environment, affordability, and other key IT Infrastructure aspects. Experience wif Oracle RMAN backup utility and in traditional hot (online/cold (offline) backups, Experience in logical backups and Database migration tools such as DATA PUMP, Export/Import, and Transportable Tablespaces.
• Experience in upgrading Oracle Databases from 11g &12c.
• Knowledge and experience on managing very large Data Warehouse databases.
• Experience in implementing Oracle Flash-Back Technology and utilizing it for various rollback purposes.
• Oracle GlodenGate experience wif Installation, configuration and troubleshooting of Oracle GlodenGate 12c replication setup across heterogeneous database servers and ensure data synchronization.
• Experience wif Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
• Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
• Experience in SQL Tuning using tools like Explain Plan and OEM.
• TEMPEffective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.
• Experience in Database capacity planning, monitoring object growth and Storage Management.
• Experience in performing Cloning and Refresh using RMAN and Datapump.
• Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modeling.
• Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.
• Experience in applying CPU/PSU patches to various versions of databases wif minimum downtime.
• Experience in upgrading Oracle Binaries and databases from 11g to 12.
• Experience in handling very large databases (VLDB) ranging up to 110TB.

TECHNICAL SKILLS

Operating Systems: Sun Solaris, AIX, Linux Enterprise Server

RDBMS: Oracle 11g, 12c

Languages: SQL, PL/SQL

Tools: EXPLAIN PLAN, ASH, AWR, and ADDM.

Database Utilities: SQL*Plus, Oracle Enterprise Manager, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import

PROFESSIONAL EXPERIENCE

Confidential - Mooresville, NC

Oracle / PostgreSQL Database Administrator

Responsibilities:

• 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 teh databases.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Installing, configuring and managing PostgreSQL clusters in both on-prem Linux environments as well as AWS RDS environments
• Creating and Maintaining PostgreSQL users, roles, database objects on both AWS and on-prem environment
• Expertise in trouble shooting teh database performance issues along teh wif query optimization.
• Perform maintenance on teh server wifout minimal downtime by using pg repack
• Refreshing Dev and Test instances wif data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Automate teh configuration management of database and Big Data systems.
• Performing schema management, database sizing, maintaining privileges.
• Installed Oracle 12c on Linux platform using ASM.
• Configured and worked in Oracle GlodenGate installation, configuration, troubleshooting GlodenGate issues.
• Planning, Implementing and Validating various versions of Oracle Databases to 19c Release & upgrades on all teh environments (in a procedural approach Dev, Test, Stage, QA and Production)
• RMAN point in time recovery and Instance recovery done on 12c.
• Developed compliance reports and performed auditing at higher levels.
• Installing, configuring and maintenance of Oracle Replication Tool Oracle Gloden Gate.
• Handled all daily DBA activities and excellent experience wif SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce teh referential integrity constraints and business rules.
• Installed and configured Oracle OEM 19C on test environments. Used OEM extensively to monitor teh general health and troubleshoot/diagnose problems in teh environment both on server, database level and also most importantly at teh Sql level to identify Sql queries.
• Redesigned table and index partitioning strategies, using HINTS to improve teh query Performance.
• Developed, modified and optimized very complex queries to data retrieval Explain Plan, SQL Trace and partitioning using techniques.
• Monitoring teh CPU, memory usage, I/O contention on servers using top, iostat, SAR, glance, vmstat etc.
• Analyzing AWR, ADDM and 11046 traces for diagnosing teh root cause of teh issue.
• Experience in writing UNIX/SHELL scripts for providing teh reports.
• Installed and configured Oracle 12c database on a test server using Oracle standard procedures and OFA, for performance testing and future 11g production implementation.
• Applied PSU Patches (12.2.0.3, 12.2.0.4) as a part of maintenance activity.
• 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 teh Optimal Flex Architecture
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and standalone database
• Performed database replication through Gloden Gate.
• Implemented Data Guard wif high availability and performance configurations and participated in Data Guard Fail over tests.
• Configuring PostgreSQL Streaming Replication and Pgpool for load balancing. Managing teh monitoring tools for better performance like PgBadger, Kibana, Grafana, and Nagios.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Responsible for all backup, recovery, and upgrading of all of teh PostgreSQL databases.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases wifin teh organization.
• Monitored data transfer between teh Database servers using Data Stage, Oracle Streams/CDC
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Worked on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• 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, PL/SQL, database design, database tables, indexes, Instance, memory and operating system.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Confidential - Bellevue, WA

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 11g and 12 g on Linux and also Upgraded from Oracle 11g to 12c.
• Involved in checking and managing tablespace growth, monitoring teh data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup teh tables.
• Monitored queries wif high response time and high disk read per execution (Top SQLs) and tuning teh same using Explain Plan and SQL tuning advisor.
• Responsible for all database activities such as User management, space management, database security management.
• Implemented teh resizing teh online redo logs in production and in standby database.
• Automated Database refresh from teh Host system to Oracle using, SQL and PL*SQL procedures.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling teh Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring teh scheduled jobs.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning teh users to groups and grant necessary privileges to teh relevant groups.
• Constantly monitor teh performance (V$ dynamic performance views at peak load) of teh Databases and viewing Alert log files & Trace files.
• Used to run teh scripts to check teh status of databases such as growing table sizes, extent allocation, free space, used space, etc.