Oracle Manager

Location:

Silver Spring, MD

Salary:

110000

Posted:

May 26, 2020

Contact this candidate

Resume:

SUMMARY

Certified Oracle DBA with over * years of IT experience. Expertise in Database Security, Backup & Recovery, Performance Tuning, Data Guard & Golden Gate Configuration, & Administration. Proficiency in Database Migration, Grid Control, Upgrade/Patching, Risk Analysis/Mitigation, Oracle to AWS Migration & Database Restore/Refresh.

HIGHLIGHTS

Single-handedly administered & monitored over 100+ oracle databases 11g/12c of sizes ranging from 200GB to 20TB, replication process, & completed performance tuning using OEM (Oracle Enterprise Manager).

Administered over 50 servers including HVR Hub servers with 3 nodes instances on RedHat Linux operating system. Also, identified & resolved blocking sessions within oracle databases using v$ views and customized shell scripts.

Ensured load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.

Developed Shell scripts, SQL & PL/SQL scripts for monitoring Golden Gate processes & their stats running on 60+ servers from one single database repository providing table-level granularity with end-to-end replication map and thus maintain the history of all Golden Gate processes for later analysis.

Extensively used import/export utilities for cloning/migration of small-sized databases and Data pump import/export to move data between 9i & 10g/11g environments. Additionally, applied upgrade patch, maintenance, & interim (opatch) patches on all the databases.

Performed migration from oracle & SQL server databases to AWS using the Golden Gate & DMS services.

SCORECARD

Skills

Years of Experience

Overall Experience

Oracle DBA/ RMAN Backup/ Data Pump/ Golden Gate

RMAN Backups / Linux & Unix / RAC environment

Amazon Web Services (AWS) Migration

PROFESSIONAL EXPERIENCE

Oracle Database Administrator Sep 19 – Feb 20

General Electric (GE Aviation), Cincinnati, OH

Installed & configured HVR 5.5 with a Bidirectional replication topology on the Linux platform. Also, Provided support in monitoring jobs, issues, and problem tickets. Also, used scripts to schedule Listener and GPFDIST on Crontab.

Ensured a top replication performance between Oracle 12c databases server and Greenplum 4.2 database server. Also, created & initialized source/target HVR channels based on the demand for data to be replicated.

Disabled and enabled supplemental logging on table level as well as database-level accordingly for replication performance. Additionally, performed refreshes on HVR channels daily for an up to date clients’ data.

Worked extensively with offshore and other global teams to provide technical solutions to various client stakeholders. Also, prioritized issues & urgently provided short-term and long-term solutions.

Created & dropped indexes and used materialized views accordingly for optimal application/system’s performance. Also, resolved at a fast-paced assigned Service Now tickets daily.

Performed migration from oracle and SQL server databases to AWS using the golden gate and DMS services.

Provided 24x7 support and on-call rotation on all Production, QA, and Development channels.

Set up a New Relic environment and customized it for servers’ system checkup. Also, performed performance evaluations on oracle database system and worked closely with customers to implement the enhancements using Oracle Enterprise Manager13c, DBeaver, & script tools.

Administered over 50 servers including HVR Hub servers with 3 nodes instances on RedHat Linux operating system. Also, Identified & resolved blocking sessions within oracle databases using v$ views and customized shell scripts.

Used customized scripts on crontab and RMAN to schedule backups. Also, gained good working knowledge of Greenplum database system architecture. and applied PSU patches, 11.2.0.4., 12.1.0.2, and 12.2.0.1.

Optimized Oracle database backups by enabling Block Change Tracking, increasing channels, or parallelism, turning on Auto-backup on RMAN configuration.

Performed migration of Oracle database schemas to Greenplum databases using SQLINES and SQL Data tools. Also, extensively worked on the migration of databases/data from Oracle to AWS.

Effectively handled the project & communicated both verbally & written with on-site and off-shore teams and work effectively in a synergic environment to meet clients’ requirements. Also, established & sent daily & weekly status reports to management.

Attended & participated in HVR support monthly calls. Also, upgraded HVR 5.5 server to HVR 5.6 server.

Oracle and SQL Database Administrator May 16 – Sep 19

Iowa Foundation for Medical Care, West Des Moines, IA

Ensured load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.

Monitored and maintained 2/3 node RAC databases on Red Hat Linux. Providing support to the development team and handling release schedules.

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

Extensively used import/export utilities for cloning/migration of small-sized databases and Data pump import/export to move data between 9i and 10g/11g environments. Additionally, applied upgrade patch, maintenance, and interim (opatch) patches on all the databases.

Extensively maintained Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability, and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

Monitored and worked on Performance tuning of Golden Gate sessions at OS level, Database level, and GGSCI level & investigated replication failures using ggserr.log, report files, & Log Dump utility.

Performed Zero Downtime migrations from Non-Exadata machines to Exadata machines using Oracle Golden Gate & Data guard.

Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2. Also, cloned/migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.

Developed policy and procedures related to database maintenance, security and archiving.

Performed migration from oracle & SQL server databases to AWS using the golden gate and DMS services.

Maintaining sound backup and recovery policies and procedures using RMAN and monitored the scheduled backup procedures for a daily basis using crontab.

Performed Replication using materialized views with a complete refresh/Fast refresh, Database refreshes using export /import, and data pump. Also, used RDA, ADDM, & AWR report to monitor the database performance.

Refreshed Dev & Test instances with data from Production regularly. Also, created, granted, & monitored user access rights and privileges through roles and profiles.

Performed backups and recovery of SQL server databases.

Applied security patches on SQL Server Databases and gained sound working experience with Query Optimization and Execution plan Analysis.

Ensured database compliance for audits for the SQL server databases. Also, provided HA solutions such as log shipping, transactional replication.

Worked hands-on in the implementation and setting up of Disaster Recovery in SQL SERVER. Also, performed refreshes on MS SQL databases using exp/imp utility.

Gained extensive knowledge of DR options for MS SQL SERVER such as Database mirroring, ALWAYS-ON FAILOVER CLUSTER.

Installed, configured, and monitored on Prod and Non-production databases MS SQL 2016, 2017, SSIS, SSRS, and SSAS services.

Performed database management functions including resolving performance issues and installing new releases and patches on SQL Server databases.

Worked with tools such as DPA, SQL Profiler, Explain the plan to resolve performance issues in the SQL server.

Resolved performance issues such as deadlocks issues, slow running SQLs, and connectivity issues. Also, performed health checks of SQL server databases raging from 1TB to 2TB using the DBCC utility tool.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.

Enabled Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM).

Gained thorough knowledge in setting up infrastructure for databases in huge data centers. Also, worked on refreshing Dev and Test instances with data from Production regularly.

Successfully applied RDBMS patches, security patches for improving the security and functionality of the databases. Also, Installed Oracle 11g on Linux platform using ASM.

Efficiently performed installation, setup, and creation of four-node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Successfully worked on the installation/maintenance of the physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, Data Pump, & EXPLAIN PLAN.

Administered & monitored over 100+ oracle databases 11g/12c of sizes ranging from 200GB to 20TB, replication process, & completed performance tuning using OEM (Oracle Enterprise Manager).

Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD, and Oracle Enterprise Manager.

Applied upgrade patch, maintenance, and interim (opatch) patches on all the databases. Also, developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers, and UNIX shell scripts.

Implemented ASM on RAC and stand-alone databases and managed disks & disk groups with ASM. Additionally, participated in project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements.

Installed, patched, and upgraded Oracle 10/11g & 12c to support internal production and test environments. Also, installed 12c OEM and customize it as per need.

Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication.

Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams. Also, Automated the Data Replication process using Materialized Views for reporting databases.

Configured Oracle Streams on Oracle 11g, 10g databases for data replication, and monitored them using Grid Control.

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

Oracle Database Administrator Mar 14 – May 16

Wolter Kluwer Health Inc., Indianapolis, IN

Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database. Also, single-handedly completed Installation & configuration of Oracle 10.2.0.1 database on the HP-UX platform.

Configured Golden Gate Classic on RED HAT LINUX & Integrated components for Active-Passive and Active-Active.

Performed space management, capacity planning, disaster recovery, and overall maintenance of the databases. Also, Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Maintained data integrity and security using integrity constraints and database triggers. Also, provided 24X7 supports for all the production and development databases.

Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using M of Oracle 11g R2.

Performed RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot, and establish the connection to Oracle database through ODBC, JDBC.

Successfully performed performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ADDM reports, Database tuning, Application Tuning & performance monitoring. Fine-tuning Initialization parameters, I/O, Memory, and Operating System kernel parameters.

Monitored the production Oracle alert logs for database errors and data issues. Additionally, used EXPORT/IMPORT to do table level and full database defragmentation.

Performed patching of Oracle databases with the latest patches from Oracle. Also, managed RAC Linux servers running Oracle in cluster environments.

Installed and configured block change tracking to work with RMAN Merged incremental backups and applied patches 11.2.0.2 and 11.2.0.3, 11.2.0.4.

Constantly monitored the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Responsible for Creating Users, Groups, Roles, Profiles, & assigning the users to groups and grant necessary privileges to the relevant groups. Also, run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, & fragmentation, etc.

Technical Expertise

Certified Oracle Database Administrator

Oracle 10g / 11g / 12c

Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant)

Toad / OEM Grid / RMAN / DBeaver

SQLData / SQL*Loader Exp / Imp/ Data Pump

Log miner / Statspack / AWR / Top / DBCA / DBUA / ADDM

Service Now / SQLine / DPA

UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX, Microsoft

Cisco VPN / Checkpoint VPN / Remote Admin / VNC / Remote Desktop

VMware Virtualization

DB Console / Grid Control / RAC environment

Patching / Upgrading / Migration/Refresh

Performance Tuning / Troubleshooting

Shell Scripting / DB Visit / Oracle Audit Vault

Amazon Web Services (AWS)

OLTP & Data Warehousing / Hot / Cold Backup

TAF policy for RAC instances

Education & Certification

Bachelors in Information Technology, The University of Shady Grove, MD – (In-process)

Associates Degree in General Studies, Montgomery College, Takoma Park, MD – 2018

Oracle Certified Associate (OCA 12C)

Oracle Cloud Infrastructure (OCI)

Contact this candidate