SUMMARY

• A talent and resourceful professional seeking to build a long term career as an Oracle Exadata DBA and Oracle GlodenGate administrator to utilize my skills in Oracle database, RAC/ASM, Grid Control, Unix/Linux, Perl and shell scripts.
• Oracle 10g Certified DBA Professional with more than 10 years of experience in (12c/11g/10g/9i) Oracle Database upgrade, database cloning, patching, installations & building new data servers, DB migration, administration, performance tuning, backup - recovery, data guard.
• More than 8 years experiences in Unix-like system administration (including IBM AIX / HP-UX / Linux). Proficient in developing management / monitoring scripts by using Korn/Bash Shell and Perl.
• 4+ years’ in-depth knowledge and solid hands-on experiences of installation, configuration, trouble-shooting and performance tuning in Oracle 10g/11g R2 RAC (Real Application Cluster), ASM (Automatic Storage Management), Data Guard (physical standby database), Oracle Gloden Gate replicate software, Oracle Enterprise Manager.
• Two years first-hand administrative experiences in Oracle Exadata database full rack machine 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 five years experiences and solid hands-on experiences in Installation / Configuration / Performance Tuning / Troubleshooting Oracle GlodenGate 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 RMAN backup with/without catalog, cold and hot backup, full/incremental backup. Hands on experience in disaster recovery.
• Solid hands-on experiences in developing complex database objects like Stored Procedures, Functions, Package and Triggers using SQL and PL/SQL.
• Performance tuning, capacity planning, hot standby databases, database cloning, refresh, and patch.
• Take 24x7 on call technical support in monitoring, managing and solving production database issues.
• 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.

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Sr. Exadata DBA Consultant

Responsibilities:

• 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.
• 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 GlodenGate (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, Cincinnati, OH

Sr. Oracle DBA, Consultant

Responsibilities:

• Creating logical and physical design; installing and upgrading databases.
• Performed monthly maintenance and performance tuning on database.
• Setting off initialization parameters, and configuring online redo logs.
• Created primary database objects such as tables, views, and indexes.
• Knowledge of the database security by granting of roles and privileges to the users.
• Setting up logical / physical backups for these databases. Depending upon the nature of the database, setup of either full export, partial export or export of just structure of schema objects and cold or hot backups.
• Managed the disk space, data blocks, extents, data segments, index segments, temporary segments.
• Monitored the alert logs and trace files and mirrored the control files and multiplexing the redo log files.
• Reorganization of existing database to standardize the placement of various database related files, addition of table space to those databases and creation of schema owners and other database users.
• Killed long running queries dat may has caused database to slowdown.
• Research options of better performance tuning, backup, validation, and restores.
• Assisted windows admin to create and run scheduled tasks do daily maintenance, and backups.
• Research RMAN to do backups on multiple databases.
• Installed and created Oracle 9i, 10g Databases on Windows / Linux servers.
• Performed regular maintenance and performance tuning on Oracle 9i, 10g database.
• Providing maintenance of user accounts, privileges, profiles and roles.
• Managing undo segments, processes, memory, online redo log files, data files.

Confidential, Columbus, OH

Oracle Application Developer and DBA

Responsibilities:

• 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 dat occurred.
• Created an automated, enterprise wide monitoring infrastructure using several key technologies including Korn shell scripts, Perl. dis 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.
• 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.