PROFESSIONAL SUMMARY:

• More than 10 years of experience of programming field with extensive knowledge of programming languages (C/C++, Java, PHP, Perl) and database management (Oracle, MS SQL Server, MySQL), strong knowledge of database administration, self - motivated and enjoy working in a team environment.
• More than ten years solid Oracle database administration skills and experience in high-end enterprise environments across multiple industries.
• More than ten years’ experience in Unix-like system administration (including Solaris / IBM AIX / HP-UX / Linux / BSD). Proficient in developing management scripts using Korn/Bash Shell and Perl.
• Eight years solid hands-on experience and outstanding troubleshooting skills to Setup / Configure / Monitor / Maintain Oracle 10g/11g/12c RAC / ASM / Data Guard environments.
• Three years first-hand administrative experience in Oracle Exadata database machine (include X2/X3/X4-2 full rack) administration, migration, health check, resource management, patching/upgrade and SQL tuning.
• First hands-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.
• More than six years’ experience and solid hands-on experience in Installation / Configuration / Performance Tuning / Troubleshooting Oracle Golden Gate in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and MS SQL Server to Oracle).
• Seven years’ experience in huge size Oracle data warehouse (more than 30TB) solutions and ETL architecture, development, maintenance, production support, data modeling, reporting fields. Extensive knowledge and experience on various ETL, reporting, and database development tools such as Informatica, Erwin and Power Design.
• 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.
• More than six years’ experience in PL/SQL, Procedure, Functions, Triggers, Packages development in applications such as Financial, Telecom fields.
• Highly skilled in SQL and PL/SQL Tuning, TKProf, Explain Plan. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.
• Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

TECHNICAL SKILLS:

DATABASE: Oracle 10g/11g/12c, MySQL 5.x

LANGUAGE: SQL, PL/SQL Perl, Korn/Bash Shell, Java, C/C++

PLATFORM: Oracle Exadata, RedHat Linux, IBM AIX, HP-UX, Oracle Solaris, FreeBSD and Windows

DATA REPLICATION: Oracle Golden Gate

MONITORING: Oracle OEM 12c.

TOOLS: SQL/Plus, Toad, SQL Developer, DB Artisan

PROFESSIONAL HISTORY:

Confidential, Charlotte, NC

Senior Oracle Exadata DBA and Golden Gate Administrator

Responsibilities:

• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Setting up High Availability Oracle Golden Gate (OGG) systems on Oracle 11gR2 RAC environments (Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack).
• Upgrade Oracle Golden Gate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Log dump / discard file analysis etc.
• Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from MS SQL Server to Oracle Exadata).
• 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.
• Participating in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Application DBA leader for a large number of tuning projects. Working with third party developers on SQL code review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, OEM Performance Manager and home-cooked scripts by using Korn shell/Perl.
• 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.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Worked on Sev1, Sev2 Issues and also providing 24x7 On-Call Support and provided on-call and day-to-day support.

Confidential, Denver, CO

Senior Oracle Golden Gate Administrator

Responsibilities:

• The primary Oracle Golden gate (OGG) resource to manage a very complex OGG enterprise infrastructure in collaboration with the DBA team.
• Lead all OGG related tasks such as OGG installation, configuration, tuning, maintenance, patching, and problem diagnosis and resolution.
• Manage all aspects of the OGG design, implement and support in development, UAT and production environments; Identify and resolve OGG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning)
• Review and approve Remedy tickets to ensure Sarbanes Oxley (SOX) compliance parameters. Provide timely SOX documentation for SOX audits.
• Review and participate in Translating business and functional requirements into incident specification design documents. Write unit test scripts. Perform unit tests and clearly document results.
• Setup both the OGG one-way and the active-active data replication system and design the conflict detection solutions; Effectively decrease Oracle Golden gate lag by using various technical methods such as database tuning, OGG parameter tuning, application large table re-design, Linux/Unix kernel performance tuning, etc.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Log dump / discard file analysis etc.
• Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from MS SQL Server to Oracle Linux X64 box).

Confidential, Deerfield, IL

Oracle Database Administrator

Responsibilities:

• Part of the Data Architecture team which supports development, test and production databases
• Installed Oracle database, and applied Patches and DB migrating. Monitoring, Tuning and optimizing the performance of the database.
• Implementation and support of 9i and 10g migrations and upgraded from Oracle 9i to Oracle 10g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux.
• Planned and implemented a comprehensive Oracle backup & recovery strategy. Set up and maintained oracle disaster recovery site using Data Guard.
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Provided application 7x24 technical support for high availability system via on-call and troubleshooting. Responsible for production application maintenance involving enhancements and performance improvements.

Confidential, Pontiac, MI

Oracle PL/SQL Developer and DBA

Responsibilities:

• Involved in Business Requirements, System analysis and Design of the Data warehouse application. Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.
• Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, backups, replication, and other distributed data issues over a highly volume Terabyte Database.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats. Designed Physical and Logical Data model and Data flow diagrams and Designed database Relational and Dimensional models using Erwin.
• Designed, and developed Oracle PL/SQL ETL processes for loading data from internal systems using SQL Loader and External tables.
• Worked on various tables to create indexes to improve query performance. Also worked on partitioning large Tables using Range/List/Hash Partitioning, creating Index Organized Table (IOT), Cluster 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.
• 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.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• 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.