CAREER GOAL:

A talent and resourceful professional seeking to build a long term career as an Oracle Exadata DBA and Oracle GoldenGate administrator to utilize my skills in Oracle database Exadata focus , RAC/ASM, Grid Control, Unix/Linux, Perl and shell scripts.

PROFESSIONAL SUMMARY:

• More than 12 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 experiences in high-end telecom, financial and medical enterprise environments.
• More than 11 years experiences in Unix-like system administration including Solaris / IBM AIX / HP-UX / Linux / BSD . Proficient in developing management scripts by using Korn/Bash Shell and Perl.
• Eight years solid hands-on experiences and outstanding troubleshooting skills to Setup / Configure / Monitor / Maintain Oracle 10g/11g RAC / ASM / Data Guard environments.
• Three years first-hand administrative experiences in Oracle Exadata database machine X2-8 Full Rack administration, migration, health check, resource management, patching/upgrade and SQL tuning.
• Solid 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 5 years experiences and solid hands-on experiences in Installation / Configuration / Performance Tuning / Troubleshooting Oracle GoldenGate in Oracle to Oracle homogeneous environments and heterogeneous environments including Oracle to Oracle and 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.
• 6 years experiences in PL/SQL, Procedure, Functions, Triggers, Packages and Pro/C development in applications such as Financial, Telecom fields mainly used language: C/C
• 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.

WORK EXPERIENCES

Confidential

Position: Sr. Exadata DBA, Consultant

• Working as the primary DBA in the DB support team, get involved in the daily On-Call to support the mission critical OLTP and Data Warehouse production databases. Working as one key member of the technical resources pool to support the Front Line Support On-Call team according emergence requirements and issues.
• 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, Statspack, OEM Performance Manager and home-cooked scripts by using Korn shell/Perl.
• 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.
• 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 and configured High Availability Oracle GoldenGate OGG systems on Oracle 11gR2 RAC environments Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata . Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / 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 .
• 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.
• Daily Oracle DBA tasks such as Oracle network trouble shooting, tablespace usage monitoring, rebuild index / tables etc.

Confidential

Position: Oracle DBA, Consultant

• Supporting more than 20 Oracle 10g/11g development/testing environments on IBM AIX and Linux/X64 boxes. Help the developers and QAs to do trouble shooting about database issues.
• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/ASH, statspack/tkprof tools
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Data Pump utilities and SQL Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Installed, configured and maintained Oracle 11g Real Application Cluster RAC / ASM on Redhat Enterprise Linux 5.x boxes.
• Implemented 11g DataGuard Physical using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Install, configure and support Goldengate uni-drectional and bi-directional Oracle-to-Oracle replicated environments.
• Analyze data model in the existing databases and validate compatibility with Oracle Golden Gate OGG replicated environment, use OGG to setup the replicated implementation from MS SQL Server to Oracle 11g.
• Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• General DBA daily jobs such as disk usage monitoring, table/index rebuild and reorganization as needed.

Confidential

Position: Oracle Application DBA

• Working with the developing engineers from third-party vendors to setup, performance tuning and deliver application.
• Set up and maintained oracle disaster recovery site using Data Guard.
• 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.
• Trouble shooting and resolving any database and/or application issues or errors that occurred.
• 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.
• Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• 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.

Position: Oracle PL/SQL Developer

Confidential

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