We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Miami, FL

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.

Hire Now