We provide IT Staff Augmentation Services!

Sr. Oracle Dba And Oracle Goldengate Architect Resume

Englewood, CO

SUMMARY

  • Over 11 years extensive experiences in Information Technology industry, especially in Oracle Database / Unix - like system administration, software design and implementation area.
  • More than 10 years in Oracle databases (9i/10g/11g/11gR2) as Sr. Oracle Database Administrator in Oracle Exadata machine, IBM AIX, Redhat/CentOS Linux, Confidential -UX, Solaris and Windows.
  • Solid hands-on experiences in installation, configuration, trouble-shooting, performance tuning in Oracle High Availability technologies, including 10g/11g RAC, ASM, Physical/Active DataGuard on AIX/Linux(X64) environments.
  • Proficient with Database Cloning, Migration, Standby Database, Data Guard and Patching of Oracle Databases and Oracle Applications.
  • Hand-on skills about Exadata hardware architecture including Storage, Grid and Infiniband. Deep understanding of key Exadata features including HCC (Hybrid Columnar Compression), Smart Scan, Smart Flash Cache, Storage Index and Storage Management.
  • First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
  • Provide and implement performance tuning recommendations of all components in Exadata database machine.
  • Experience with Oracle 10g/11g new features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo Management, Grid Monitoring and Recycle Bin.
  • 6+ years experiences and solid hands-on experiences in Installation / Configuration / Performance Tuning / Troubleshooting Oracle GoldenGate data replicate middleware in Oracle to Oracle homogeneous environments and heterogeneous environments (including MS SQL Server to Oracle).
  • Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full/incremental backup.
  • Highly skilled in SQL Tuning by using Oracle statistics management, Explain Plan, TKProf and necessary SQL code rewrite. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.
  • Strong work experience with tools like Toad, PL/SQL Developer, Oracle SQL Developer, OEM Grid Control 12c.
  • Proficient in developing management / monitoring scripts by using Korn/Bash Shell and Perl.
  • Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.

TECHNICAL SKILLS

Database: Oracle Database 9i/10g/11g/12c, MySQL, Microsoft SQL Server

Language: SQL and PL/SQL, C/C++/C#, Java, Perl, Korn/Bash Shell

Hardware: Oracle X2/X3/X4/X5 full rack Exadata, IBM PowerPC, X64 servers, Sparc, Confidential - UX

Data Replication: Oracle GoldenGate

Monitor Tools: Oracle OEM 12c, Zabbix

PROFESSIONAL EXPERIENCE

Confidential, Englewood CO

Sr. Oracle DBA and Oracle GoldenGate Architect

Responsibilities:

  • Oracle Core DBA work on ODS and EDW implementation using Oracle 11g and 12c. Implementation of Backup, Recover, Disaster Recovery (Using Physical DataGuard) and cloning of 50 TB+ database.
  • Provided 24x7 on-call supports for more than 30 mission critical OLTP (RAC) production databases on Linux and AIX platforms and several huge data warehouse systems with data sizes of 20~40 TB, including one full rack Exadata. Database versions are ranging from 9i,10g, 11gR2 and the most recent version 12c R1.
  • Setup and configuration of ASM on multiple RAC instances. Setup TDE for data encryption. Setup of OVD to support single sign-on. Migration of EDW database from 11g running on AIX to Exadata Full Rack X5.
  • Participated in the full life-cycle development process from definition and design to production delivery.
  • Participated in implementation of various projects for SEC. Wrote custom PL/SQL script to move data from old systems running on Oracle 9i on AIX to Exadata.
  • Supported multiple phases of the project for both backup and recovery and other core database responsibilities.
  • Setting up and administering of 11gR2 RAC and Clusterware and Instances. Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services. Applied patches on Oracle Clusterware and RAC databases.
  • Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
  • Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
  • Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
  • Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.
  • Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments.
  • Effectively decrease OGG lag by using various technical methods such as database tuning, OGG parameter tuning, application large table re-design, Linux/Unix kernel performance tuning.
  • Upgrade OGG from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
  • Trained other DBA's on the team in Oracle RAC, Back/Recovery, Oracle GoldenGate, Performance Tuning and general Database Administration tasks.
  • 24X7 level L3 DBA support for the production systems.

Confidential, Warren, NJ

Sr. Oracle Database Administrator (Exadata)

Responsibilities:

  • Working as a DBA in the Database Support Team to support (daily On-Call rotation) production and non-production environments.
  • Working with the Information / Data Architect and Database Designer / Modeler to help implement the physical data model to support the mission critical OLTP and OLAP production databases.
  • Duplicate all the non-production databases on Exadata server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using Oracle HCC (Hybrid Columnar Compression) techniques.
  • Primary technical resources in SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
  • Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
  • Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
  • Develop and record certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.
  • Installed, configured the Oracle 10gR2 RAC/ASM production and non-production databases on Redhat Linux X64 boxes to support different applications.
  • Implementation and support of 10g and 11g migrations and upgrades from Oracle 10g to Oracle 11g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux X64 box.
  • Implemented 11g Data Guard Physical and Logical standby using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
  • Setup and trouble-shoot the Oracle physical Data Guard for disaster recovery purpose.
  • Maintenance of production database and development database which includes table space management, user creation, and privileges, roles. support RMAN backup and recovery including physical backups and logical backups by using data pump(Exp/Imp) tool. Extensively developed and maintained Korn shell and Perl scripts..
  • Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
  • Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
  • Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER and Crontab.
  • Handled Chained Rows and Row migration, and solved the database performance issues.
  • Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
  • Performance Tuning and Troubleshooting of custom and vendor apps running on Oracle databases using AWR/ADDM, traces/tkprof, explain plans, profiles.
  • 24X7 On-call support rotation to the production database.

Confidential, Pontiac, MI

Oracle Database Administrator

Responsibilities:

  • Executed different phases of SDLC including gathered and analyzed business requirements, designed and modeled them into diagrams and documents, monitored function and structure implementations, designed test scenarios.
  • Analyzed and segregated Business Requirements into high level and low level Use Cases.
  • Developed Unix Shell Scripts, Perl Scripts, PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
  • Loaded source data files with SQL*Loader and imp/exp utilities.
  • Created Oracle database objects(tables, partition tables, b-tree and bitmap indexes, constraints, views and materialized views), PL/SQL Procedures/Functions/Packages, SQL and Korn shell/Perl Scripts and develop transaction processes based on created objects to support business needs and reports needs. Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
  • Designed Test Plan and Test Cases according to Functional Requirements and design specifications of the application and executed them with testers. Implemented Unit Testing Stored Procedures, Functions, Packages and Triggers.
  • Implemented Test Plans using both automated and manual testing methods, and resolve and document software issues based on test results.
  • Designed, and developed Oracle PL/SQL ETL processes for loading data from internal systems using SQL Loader and External tables.
  • Designed, developed and maintained oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
  • Created PL/SQL packages, stand alone procedures, and stand alone functions. Wrote complex SQL queries with sub-queries, analytical functions and inline views
  • Performance tuning and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.

Confidential

Customer Support Engineer in Database Team

Responsibilities:

  • Provide POC(proof of concept) and finial technical solutions based on Oracle's flagship database servers according to customer's requirements.
  • Analyze technical fit of Oracle's products and professional services against prospects requirements.
  • Installed, configured Oracle database production in different complex customer's environments. Provide initial technical assistance to customers and prospects, and coordinate customer technical staff and Oracle's resources.
  • Training customers about Oracle's products and in charge of POC(Proof of Concepts) based on customer's requirements.
  • Onsite hands-on performance tuning and trouble-shooting with Oracle database team and application vendors for Oracle's important customers.
  • Provide technical presentation about application server technology during Oracle's marketing road show campaign.

Hire Now