EXPERIENCE SUMMARY:

Have over 16 years of focused experience in IT industry in various fields like financial, telecom, and manufacturing. Extensive experience in Oracle database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as Oracle DBA, especially in Exadata and Oracle Goldengate proficient in Oracle 9i/10g/11g/12c software installations, migrations, database capacity planning, automated backup implementation, performance tuning on Linux/Unix and Windows platform. Involved with the architect group in designing the logical and physical model of the enterprise level databases. Have solid experiences in Linux/Unix administration, Korn shell / Perl scripting. Have impeccable communication and interpersonal skills and an exceptional team player.

SKILLS PROFILE:

Confidential

• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression , Flash Cache, etc.
• 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.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Solid skills to configure Exadata to meet company internal security requirement.
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.

Confidential

• More than five years experiences and solid hands-on experiences in Installation / Configuration / Performance Tuning / Trouble shooting Oracle Goldengate OGG in both homogeneous and heterogeneous environments including Oracle to Oracle and MS SQL Server to Oracle .
• Extensive skills to configure and build one-way, tow-way, active-to-active Oracle Goldengate Extract/Replicat for multiple databases.
• Strong experiences in configuration and building heartbeat monitoring in Oracle Goldengate. Develop flexible home-cooked Korn scripts to monitor the Goldengate lags.
• Configure error handling for Oracle Goldengate restart, logging, production support and status reporting.
• Hands-on experiences in trouble shooting and performance tuning Oracle Goldengate replications. Working with Oracle on SRs for critical issues.
• Primary technical resources to upgrade Oracle Goldengate from 11g to 12c in Exadata machine environment design Goldengate HA solutions by using Oracle 11.2.0.4 Clusterware functionality.

Confidential

• More than 8 years experiences in support large-scale up to 8 nodes , mission critical production RAC environment from 9i version to 11gR2 version RAC on deferent platform including IBM AIX, Redhat Linux, Sun SPARC Solaris, HP-UX
• Deep knowledge of Oracle 11g Grid Infrastructure, Clusterware, ASM, RAC internal, Active Data Guard in RAC environment.
• Architecting, planning, designing, developing, deploying and supporting Oracle 11gR2 RAC/ASM environment.
• Extensive hands-on experiences in installation configuration Oracle Grid Infrastructure Database Software Troubleshooting using cluvfy handling common issues that arise during integration of the whole bugs, network issues, configuration files issues, OCR issue, deinstallation cleanup of clusterware
• Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
• Worked with customer for different RAC related issue such as hang check, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss, etc.
• Backup and Recovery issues related loss of OCR, Voting Disk and Oracle clusterware also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking also flash recovery area.
• Solid skills in upgrading 10g R2 RAC to 11g R2 RAC and 11g R2 RAC to 12c R1 RAC.

PROFESSIONAL EXPERIENCE

Confidential

Role Responsibility: Sr. Exadata DBA / Oracle Goldengate Specialist II / Consultant

• l 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.
• l Setting up High Availability Oracle GoldenGate OGG systems on Oracle 11gR2 RAC environments Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack .
• l Upgrade Oracle GoldenGate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
• l Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.
• l Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments from MS SQL Server to Oracle Exadata .
• l Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 12c
• l Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• l Installed, configured and maintained Oracle 11g Real Application Cluster RAC / ASM on Redhat Enterprise Linux 6.x boxes.
• l 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.
• l 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.
• l Primary technical resources in SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• l 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.
• l Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• l Develop and record certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.

Confidential

Role Responsibility: Sr. Oracle DBA / Consultant

• l Supporting more than 20 Oracle 10g/11g development/testing environments on Solaris/SPARC and Linux/X64 boxes. Help the developers and QAs to do trouble shooting about database issues.
• l Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM, statspack/tkprof tools
• l Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• l Installed, configured and maintained Oracle 11g Real Application Cluster RAC / ASM on Redhat Enterprise Linux 5.x boxes.
• l Implemented 11g DataGuard Physical using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
• l Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• l Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• l Analyze data model in the existing databases and validate compatibility with Oracle GoldenGate OGG replicated environment, use OGG to setup the replicated implementation from MS SQL Server to Oracle 11g.
• l Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• l Oracle database performance testing, monitoring and analysis by using LoadRunner.
• l Developing the main application control utility: spksctl, by using perl, integrate apache web server into the application, get rid of the old iPlanet web server.
• l General DBA daily jobs such as disk usage monitoring, table/index rebuild and reorganization as needed.

Confidential

Role Responsibility: Oracle DBA

• l Part of the Data Architecture team which supports development, test and production databases.
• l Worked on RMAN duplication, Cross-platform Transportable Tablespace.
• l 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.
• l Performed oracle Software's Installations, Creation of new standalone and clustered databases.
• l Administering and setting up of 10g RAC and clusterware and instances.
• l Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• l Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
• l Redefinition of tables using DBMS REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespaces
• l Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• l Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• l Scheduled RMAN backups purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER and crontab.
• l Handled Chained Rows and Row migration, and solved the database performance issues.
• l Experienced with ASM, adding, deleting disks to the disk group.
• l 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.
• l Generated Statspack/AWR reports using OEM from Oracle 10g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace and database growth.
• l 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
• l Supported development teams for moving changes to different development, test levels and prepared documentations to move changes to the live production environment.
• l 24/7 on-call support for the production environment.

Confidential

Role Responsibility: Senior Technical Consultant

• l Provide POC proof of concept and finial technical solutions based on Oracle's flagship database servers according to customer's requirements.
• l Analyze technical fit of Oracle's products and professional services against prospects requirements.
• l 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.
• l Training customers about Oracle's products and in charge of POC Proof of Concepts based on customer's requirements.
• l Onsite hands-on performance tuning and trouble-shooting with Oracle database team and application vendors for Oracle's important customers.
• l Provide technical presentation about application server technology during Oracle's marketing road show campaign.

Confidential

Position: Oracle DBA

• Working as a BOSS System Oracle DBA and handling all the duties and work assigned to this position efficiently, these duties are as follows: The OS platform are most IBM AIX
• l Working with the developing engineers from third-party vendors to setup, performance tuning and deliver application.
• l Set up and maintained oracle disaster recovery site using Data Guard.
• l Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export / Import utilities and SQL Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• l Trouble shooting and resolving any database and/or application issues or errors that occurred.
• l Created an automated, enterprise wide monitoring infrastructure using several key technologies including Korn shell scripts, Perl. This allowed our operational DBA team to efficiently gather database metadata, exceptions, and performance statistics for remote clients running Oracle using a consolidated Intranet approach.
• l Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• l Provided on-call support regarding production-related database problems. Worked with IT managers and application developers to ensure the database integrity, high availability and security. Provided all kinds of DBA support to development teams as well as production support to various applications.

Confidential

Position: Oracle PL/SQL and C Developer of the BOSS Billing System

• Working as a PL/SQL and C/C programmer and handling all the duties and work assigned to this position efficiently, these duties are as follows:
• l Studied and analyzed the business requirements, designed entity relationship diagram using Erwin.
• l Review the data model and designed database tables as per technical specifications
• l In writing PL/SQL code and debugging for triggers, functions, and procedures and packages in the Oracle 8i/9i Database on HP-UX platform.
• l Developing the C/C module on the Tuxedo server side. Involved in review the code, preparation of Unit Test Plans required test scenarios .
• l Trouble shooting for the end users requirement and Optimizing the Oracle database.
• l Tuning application using tools like Explain plan, SQL Trace and TKPROF for high efficiency.
• l Loading data using SQL Loader both conventional and direct path loading and stored procedures.
• l Coordinating and scheduling changes to database based on requirements.
• l Responsible for all version control of code and technical documentation.
• l Providing support to team member on daily basis.