OBJECTIVE:

Seeking a challenging workplace to utilize database skills to provide excellent services by being productive, innovative, co - operative, pro-active, diligent, reliable, and eager learning.

SUMMARY:

• Experience 19-year as a DBA with primary focus on Oracle, solid hands-on experience in MSSQL, MySQL, and PostgreSQL.
• Expertise Strong scripting skills to automate many database tasks and develop database tool kits for easy management Oracle RAC, Performance Tuning, RMAN, Streams, Data Guard, Grid Control

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior DBA

• Provision and manage 11g RAC and standalone databases in the Oracle Database Appliance as well as databases in Windows.
• Configure and manage Oracle RMAN backup and recovery with the Tivoli and NetBackup.
• Installed 12c Grid Control to monitor Oracle, MSSQL, MySQL, and PostgreSQL databases.
• Automation on Oracle Database Space Management
• Target database discovery: a developed process installed in the host will discover all databases by recording host configuration, database/instance/service names, tablespaces, users, and etc. in a central repository database.
• Automatic datafile addition: sufficient space will be maintained by automatically adding datafiles to those tablespaces reaching user-defined thresholds defined in the central repository database.
• High availability: having each database maintaining its own copy of tablespace information if the repository database becomes unavailable.
• High scalability: process is running inside each database concurrently rather than serially from the repository database.
• Capacity planing: tablespace usages are recorded in the central repository database.
• Automation on Oracle Schemas Refresh
• All schema refresh requests: can be easily managed by simply schedule a job per request by eliminating tedious manual works.
• Multiple schemas can be refreshed in a single job.
• Source and target schemas can be in different databases and hosts.
• Disaster Strategy
• Support daily operation for MSSQL databases and create linked servers to communicate to both MySQL and Oracle databases.
• Install MySQL engine and create MySQL databases, export/import databases, setup SSL connections and slave
• Install PostgreSQL engine and create databases, load data, configure SSL connections
• Work with Amazon Web Services in terms of RDS and EC2.

Confidential,New York, NY

Senior Oracle DBA

• Provided production support and engineering for 11g Oracle RAC/standalone databases
• Involved database design and planning by cooperating with business owners to scope out the database requirements and provide upmost solutions.
• Performed database auditing, capacity planning, performance tuning, security, upgrades and patches.
• Wrote Oracle PL/SQL packages.
• Designed and developed backup and recovery strategy with RMAN.
• Came up with a method to clone a multi-terabyte production Oracle database in hours by using both SAN and Oracle technologies.
• Documented the database standards, operational procedures and processes.
• Managed Oracle production database disaster by activating the standby database to primary and solved all application connections smoothly in a timely fashion to avoid catastrophe, then rebuilt this multi-terabyte standby database from the active primary database with RMAN.
• Created and supported multiple instances of the MSSQL 2005, 2008 and 2012 including creating databases, users, and objects, performing database mirroring, backup and restore, and jobs.
• Created MySQL databases and users.

Confidential, Stamford, CT

Associate

• Lead the US region to build out consistent Oracle environment globally.
• Provided global support for over 1000 Oracle database estate using Oracle streams, RAC, and ASM.
• Engaged in Oracle financial R12 project, designed and built 11gR2 RAC databases.
• Provisioned Oracle RAC and standalone databases in the VCS cluster with the usage of the EMC SRDF technology.
• Conducted disaster recovery test for Oracle databases with the EMC SRDF technology
• Lead the project to migrate Oracle databases from the ABN AMRO to the Royal Scotland domain.
• Installed, cloned, and provided system administration for Oracle financial 11i and R12.
• Setup 11g Grid Control and deployed agent to target Oracle databases.
• Wrote PL/SQL packages for password management, data archiving, and purging.
• Trained and served as US regional expert for the Stratavia (database deployment automation application).
• Designed and built consistent Oracle database backup and recovery strategy with the RMAN where scripts reside in global RMAN catalog.
• Trained newly hired database administrators and mentored less-experience team members.
• Performed minor works for Sybase and MSSQL databases.

Confidential, NY

Senior Oracle DBA

• Solely managed all Oracle databases used for middle and back office operations for hedge fund companies.
• Built and supported10g Oracle Data Guard databases with the Data Guard broker. The RMAN backup was performed on the standby databases rather than primary production databases to eliminate additional backup loads.
• Tuned Oracle database performance by adjusting instance memory, and re-writing SQL statements, partitioning large tables, re-organizing fragmented tables, and archiving data of the highly transactional tables.
• Wrote PL/SQL packages for business processes.
• Installed 10g Grid Control to monitor Oracle databases. Upgraded all 9i databases to 10g. Installed and created 10g RAC databases with ASM.
• Supported MSSQL 2000 and 2005.
• Managed database license and worked with outside vendors.

Confidential, New York, NY

Senior Oracle DBAlTeam Lead

• Supported all the Oracle databases for the Enterprise Confidential System. Managed onsite and offshore database administrators.
• Established Oracle database standard practices including database consistent build, user management, backup and recovery, physical structure, security, naming convention, and coding standard.
• Upgraded all the 9i Oracle databases to 10g.
• Partitioned large tables with the dbms redefinition package.
• Hardened database security by creating different profiles and roles, defined user management process, setup database auditing, revoked excessive user privileges as well as automating user recertification processes for the SOX audit.
• Protected business confidential data with the Oracle Virtual Private Database.
• Designed and developed Oracle database backup and recovery process with the RMAN
• Troubleshoot performance issues and significantly shortened production batch process time by collecting statistics, creating proper indexes, and re-writing stored procedures.
• Worked with SQL Server 2005.

Confidential, Weehawken, NJ

Lead Associate

• Learnt quickly to support Oracle databases hosting mission critical applications.
• Certified 10g Grid Control and documented its feature usages.
• Provided in-depth performance analysis with statspack to significantly improve database performance.
• Supported Oracle database farm environment and upgraded databases to version 9.2.0.8.
• Automated data archiving for large tables.
• Standardized documentation for the disaster recovery procedure and Oracle database tool usages.
• Supported a terabyte warehouse database.
• Participated 11g feature certification.

Confidential, Wilmington, DE

Senior Oracle Database Administrator

• In charged of all phases of the Oracle database operation including capacity planning, evaluation of vendor products, database architecture design, development, implementation, and administration. Established and documented database standard practices.
• Served as the lead resource for the Oracle database estate.
• Built and supported Oracle databases hosting CRM, Tidal, MQ, PeopleSoft, Aspect, SBO, Data Mart, and Epiphany applications.
• Lead database resource to build Oracle 10.2 databases for GL and BPM projects.
• Developed processes to monitor databases in terms of long-running SQLs, lock, tablespace usage, disk I/O bottleneck, alert log, and storage usage.
• Tuned database performance with Statspacks, TKPROF, and trace tools.
• Designed and implemented RMAN backup and recovery strategy.
• Developed table partitioning strategy for backend data mart databases, and partitioned large tables with dbms redefinition package.
• Patched and upgraded Oracle databases.
• Developed a script to fully automate Oracle software installation (silent installation with the response file) and database creation. Built and supported 9i RAC databases with the OCFS.
• Utilized the Oracle 9i Data Guard as the disaster recovery strategy.
• Wrote Unix Shell script to automate business processes including the bank marketing data load, warehouse data feed, and data scramble.
• In charged of the Quest Foglight administration, patch application and upgrade, monitoring, reporting, and creation of custom agents.
• Lead resource for Oracle database audit performed by the US Office of Thrift Supervision
• Mentored the junior DBAs
• Supported MSSQL databases.

Confidential, New Castle, DE

Senior Database Administrator

• Supported online transactional Oracle 9i standalone and RAC databases.
• Mentored junior database administrators and PL/SQL developers.
• Installed 9i Oracle software and created standalone and RAC databases on HP, Compaq Tru64, and Redhat Linux.
• Developed Oracle database backup and recovery with the RMAN.
• Reviewed and hardened Oracle database security.
• Implemented active-active database solution with 9i Oracle Advanced Replication.
• Migrated MSSQL databases to Oracle 8i with the Oracle Migration Bench, DTS, and the SQL*Loader, then upgraded and converted to 9i RAC.
• Extensively used PL/SQL to create packages for various application including online transaction, reporting, merchant setup.
• Developed a robust data loading process with the SQL*Loader and import utility.
• Wrote Unix shell scripts to monitor databases including tablespace usage report, lock, cursor, and alert log as well as for cold and hot backup.
• Tuned SQL statements with the explain plan, Autotrace, SQL Trace, and TKPROF.
• Developed data encryption methodologies and archiving strategies.
• Managed projects involving design, documentation, delivering, testing, and rollout.
• Created stored procedures and assist in administration for MSSQL

Confidential,Newark, DE

Oracle DBA

• Installed Oracle 8i software and created databases. Setup database security by creating roles and profiles.
• Wrote Unix shell scripts to monitor databases and automate production processes.
• Created objects including tablespaces, users, tables, constraints, views, indexes, sequences, triggers, and PL/SQL packages.
• Tuned databases for performance.
• Loaded data with import utility and SQL*Loader.
• Tuned SQL statements by rewriting the statements, using hints and indexes.