SUMMARY

• I have about 7 years of practical experience as an Oracle Database Administrator and transforming business strategies of various organizations into efficient and integrated global business solutions.
• I have worked on multiple database versions running on different platforms, including Linux, Windows and Solaris, delivering technical knowledge in both production and project support environments.
• Excel at managing all database related activities.
• Proven capacity to work collaboratively on conducting requirements gathering, project scoping and acceptance testing.
• Adept at planning, prioritizing and scheduling work activities to ensure project targets are consistently achieved.
• Proactive, able to work with various technical teams developing solutions to applications and database development projects and integration.

TECHNICAL SKILLS

Database (RDBMS): Oracle 10g, 11g, 12c, SQL Server, PostgreSQL

Operating Systems: Windows /2016/ NT, RHEL7.6 (RedHat UNIX/Linux Enterprise Server, AIX5.1, 5.2, 5.3, 6.1 Sun Solaris 2.5, 2.6Applications: HR, FIN, PEOPLESOFT, HASTUS, SPEAR, HCM

Database Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM, Toad, JIRA, Putty, NX client, WinSCP, SQL Developer, EMC,Bitbucket,Pagerduty,Salesforce,Octopus,Confluence,Github PL/SQL, UNIX Shell Scripting, PERL, ETL.

Database Utilities: SQL*Plus, Oracle Enterprise Manager (OEM), Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import, Database links utilities, MTK, Crontab,ACTIVA

Replications: GOLDENGATE, CDC - STREAMS, LOGJOURNAL, Load Job

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• Performed database replication through GoldenGate and CDC-STREAMS replications
• Successfully installed and configured Oracle 10g, Oracle 11g, oracle 12C databases on Linux platforms
• Loading data from flat files to database using SQL*Loader, External Tables.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage regular databases. Used TOAD for database management.
• Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases. Performed Database upgrade from Oracle 10g to 11g to 12C and to 19C
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g and 12C servers for the purpose of disaster recovery procedures.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve performance.
• Database refreshes using Datapump and RMAN for database Duplication and cloning.
• Worked with development and operations staff in resolving problems quickly and efficiently Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database.
• Performance tuning. 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, SQL*Trace, TKPROF, Explain plan, ASH,AWR and ADDM reports, Advisors as SQL Tuning advisor, SQL access advisor, Undo, Segment, MTTR, Memory.
• Documented the Standard Processes for peers to follow.
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental and cumulative backups.
• Configured and worked in Oracle GoldenGate installation, configuration, troubleshooting GoldenGate issues.
• Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments.
• Perform load balancing by distributing database files across multiple drives to improve performance.

Confidential -Miami FL

Oracle Database Administrator

Responsibilities:

• configuring and maintenance of Oracle Replication Tool using Oracle GoldenGate.
• Performed database replication through GoldenGate.
• Configured and worked in Oracle GoldenGate installation, configuration, troubleshooting GoldenGate issues.
• Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments.
• Expert knowledge in installing oracle database server on SOLARIS, AIX, WINDOWS, LINUX and migration of oracle databases from 10g to11g and from 11g to 12c.
• Expertise in migrating single instance databases to multi-nodes 10g, 11g R1, R2 RAC environments for high availability, scalability and load balancing.
• Extensive Knowledge of 10g and 11g ASM.
• Efficiently maintain 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.
• Create new Oracle databases using DBCA or database scripts. Creating new ASM disk group or raw devices for RAC Databases.
• Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms.
• Worked with development and operations staff in resolving problems quickly and efficiently Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database.
• Good experience in applying Patch set update (PSU) and Critical Patch Update (CPU Patches) on Databases.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems. Performed complete multi-master replication with updateable Materialized views.
• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Expertise in Performing Tuning. 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, SQL*Trace, TKPROF, Explain plan, ASH,AWR and ADDM reports, Advisors as SQL Tuning advisor, SQL access advisor, Undo, Segment, MTTR, Memory.
• Schedule backups using RMAN scripts and also oracle enterprise manager cloud control 13C
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g and 12C servers for the purpose of disaster recovery procedures.
• 24/7 support for Production databases and responsible for round-the-clock database operations. Offered
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using MTK Tool
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Proficiency using Flash-Back Recovery, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM)
• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using tools like TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental and cumulative backups.
• Participates in 24/7 on call rotation once every month.
• Support engineers and developers to deploy scripts and also take part in monthly releases.

Confidential - Miami FL

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 10g, Oracle 11g, oracle 12C databases on Linux platforms
• Loading data from flat files to database using SQL*Loader, External Tables.
• 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 Linux platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases using Rconfig. Installed ASM environment and migrated databases from NON-ASM to ASM.
• Collaborated, cross-functionally on the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage regular databases. Used TOAD for database management.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 20GB to 2TB and automated the process through Scripts and Crontab.
• Performed full and incremental backup (cumulative and differential) using RMAN and implemented recovery strategies. This help to speed up recovery process in this environment.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• 24 X 7 Production & Development database support and administration. Made optimal use of Oracle Support in resolving the SRs.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve performance.
• Database refreshes using Datapump and RMAN for database Duplication and cloning.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
• Refreshed/cloned databases using RMAN utility and data pump
• Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases. Performed Database upgrade from Oracle 10g to 11g and to 19C
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Experience in Oracle Goldengate in a unidirectional replication.