SUMMARY

• Passionate and proactive Oracle Certified Database Administrator/OGG Implementation Specialist certified with over 6 years of experience in Database installations, Golden gate installation and configuration and management of Oracle tools and databases. In pursuit of a new challenge to leverage my technical and soft skills in a fast - paced environment within the United States. Ready to relocate
• Excellent in routine database activities: database design, maintenance, optimization, backup/restore, disaster recovery, capacity planning, security, cost analysis, system integration, strategic projection and turnover procedures.
• Expert knowledge in installation, configuration and management of Oracle products running on LINUX, SOLARIS, HP-UX, AIX, WINDOWS NT.
• Expert knowledge in Golden gate micro services installations and configuration.
• Competent in migration of Oracle, PostgreSQL and SQL Server databases across platform on-premises
• Proactive and reactive in PERFORMANCE TUNING at all levels: Network, Operating System, Instance and Application/SQL tuning using TK PROF, EXPLAIN PLAN, SQL TRACE, UTLSTAT, STATSPACK, AWR and ADDM.
• Good knowledge of PL/SQL programming language.
• OCA and OCI certified
• Proficient with Security Administration, configuring quotas, auditing, and Advanced Data Encryptions.
• Excellent in applying PATCHES and performing database UPGRADE from oracle 9i to 10g to 11g and 12c.
• Good experience in ORACLE GOLDENGATE Configuration and maintenance on 10g, 11g (R1, R2) and 12c both classical and integrated using micro services
• Quality experience in configuring, maintaining single and multi-node Real Application Clusters (RAC) on 10g, 11g (R1, R2) and 12c; ensuring high availability, scalability, load balancing and easier management.
• Skilled in configuring and maintaining DATAGUARD with Physical, Logical, and Active standby databases on Oracle 11g, 12c RAC servers for disaster recovery and high availability.
• Experienced in maintaining large Production, UAT, IST and DEV environments.
• Experience in BACKUP, RECOVERY, CLONING, DEPLOYMENTS, DATABASE REFRESH, TICKET MANAGEMENT, and interactions on MY ORACLE SUPPORT.
• Skilled in developing database MONITORING/HEALTH CHECKS ALERT scripts for database uptime/downtime status, and sizing issues using grid control/Oracle Enterprise Manager (OEM)13c.

PROFESSIONAL EXPERIENCE

Confidential, Austin Texas

Oracle Database Administrator

Responsibilities:

• Supporting Production activities like resolving alerts of tablespace filling up, mount points full and also checking all backups and making sure they are completing and basically all Production support issues
• Managing databases on AWS RDS/EC2 and doing rehydration of new AMIs every 3 months
• Migrate data using DATAPUMP, transportable tablespaces, SQL*Loader, and Database Links
• Resolving issues with Blocking Sessions by using OEM 13C, TOAD and or command line
• Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
• Worked on projects like dataguard configuration and managing databases on dataguard making sure that the primary is always in sync with the standby
• Installation of Goldengate using the integrated capture (micro services) and also managing databases running on Goldengate making sure that replication is happening and there is no data loss
• Done a lot of performance tuning from database to SQL by using tools like OEM, TOAD, SQL tunning advisor, AWR Report, ADDM Report and ASH Reports to diagnose and come out with solutions.
• Managing databases on RAC environments running on ASM making sure there is always storage available and als that all the services are working fine
• Decommissioning old servers to new servers. That is moving old Databases to new servers adding some new features. Also known as Tech Refresh
• Have knowledge in Agile philosophy and how choosing the best methodology is good for a project
• Database Monitoring Scripts deployment.
• Goldengate table add for replication
• Mostly use Oracle TOAD to manage my databases like running an AWR, monitoring blocking sessions, Active and inactive sessions.

Confidential, Charlotte, NC

Oracle Database Administrator

Responsibilities:

• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan, SQL Trace, TKPROF, and OEM 13c.
• Ensuring load balancing in RAC by creating services for different purposes based on the application requirement and defined TAF policy for RAC instances.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Migrate data using DATAPUMP, transportable tablespaces, SQL*Loader, and Database Links.
• Performance tuning of ORACLE GOLDENGATE sessions at OS level, Database level and GGSCI level, and fixing errors tracked by the ggserr.log, report files and Log Dump utility.
• Also been exposed on working with EXADATA machines by doing migration from on prim to EXADATA
• Migrated databases from Oracle to Postgres and AWS (RDS and EC2)
• Edit Shell scripts, SQL & PL/SQL scripts for monitoring Golden Gate processes and their stats running on 50+ servers from one single database repository providing table level granularity with end-to-end replication map.
• Development of policy and procedures as they relate to database maintenance, security and archiving.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using CRONTAB and OEM.
• Monitoring database performance using tools like TOAD, SQL Developer, OEM 13C to reach the best output
• Creating, granting and monitoring user access rights and privileges through roles and profiles.
• Providing 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.
• Refreshing Dev and Test environments with data from Production on a regular basis using EXPDP /IMPDP.
• Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
• Installation of 13C OEM and customize it to company needs.

Confidential - LITTLE ROCK, AR

Oracle Database Administrator

Responsibilities:

• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN, TOAD and OEM (Oracle Enterprise Manager
• Provided interim Services on MongoDB in the absence of a colleague
• Documented the Standard Processes for peers to follow.
• Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies and refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Applied RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, partitioning tables, creating materialized views, using hints and SQL Profiles, configuring bind variables, configuring Huge Pages,
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.