OBJECTIVE

• Seek a challenging workplace to fully utilize my database skills to provide excellent services, and to continuously produce, improve, and innovate as well learn and grow with the company.

TECHNICAL SKILLS

Experience: 15 - year as an Oracle DBA and 8-year as MS SQL DBA mainly for the financial industries supporting critical trading, banking, and back office applications. Provide global Oracle database support for over 1000 databases including multi-TB databases.

Databases & Tech: Oracle 8i, 9i, 10g, and 11g

Oracle: financial 11i and R12 installation, clone, and system admin.10g & 11g RAC, ASM, RMAN, Data Guard, 10g, 11g, and 12c Grid Control, Oracle Streams, Oracle Advanced Replication, Partition, Object Reorganization, Audit, Virtual Private Database, Capacity Planning, Security, Performance Tuning, PL/SQL Profiler, Outline.

SQL Server: 7.0, 2000, 2005, 2008, and 2012.

Tools: Stratavia, DBArtisan, Quest Foglight, Central and TOAD, Autosys, Erwin, Case Studio, Microsoft Project and Visio.

Operating: Solaris, Redhat Linux, AIX, HP-UX 11.0, and MS Windows.

Languages: SQL, PL/SQL, K-shell, and Perl

PROFESSIONAL EXPERIENCE

Confidential,New York, NY

Sr. Oracle DBA

Responsibilities:

• Provide production support and engineering for Oracle and MS SQL Server databases including Oracle RAC and standalone databases with various sizes consist of multi-terabyte databases.
• Involve project design and planning pertaining to database, heavily interact with developers and business users to scope out the database requirements and provide adequate solutions.
• Install Oracle database software, perform database creation, auditing, capacity planning, performance tuning, partitioning, security configuration, monitoring, archiving, upgrades and patches. Install Oracle Enterprise Manager 11g and 12c.
• Proactively tune database performance by adjusting memory structure, partitioning and indexing, collecting stats, monitoring long running queries and locks, analyzing AWR reports, and looking at SQL explain plan.
• Lead the project to design uniform strategy for backup and recovery. Designed and developed a customized shell script to standardize Oracle database backup and recovery utilizing RMAN. The backup is taken on the standby databases to eliminate the potential load to the primary databases.
• Reduced the cloning time from several days to hours for a multi-terabyte production Oracle database for UAT testing by proposing a combination of SAN clone and database technology, and developed a shell script to fully automate this process. Wrote a robust shell script being used for any Oracle database schema refreshes, which not only satisfies repetitive requests from developers in a timely and consistent fashion but also saves enormous amount of manual DBA works.
• Developed a database inventory system to serve as a central repository to store information of all Oracle databases and hosts for an easy retrieval of database-related data. In conjunction with this repository, the database tablespace usage alerting and expansion (datafile addition) are fully automated and triggered with consideration of both user-defined thresholds of tablespace unused space and percent usage, and these thresholds can be configured as granular as per tablespace level, which eliminates DBA from simply just to log into databases to add datafiles upon space exhaustion. The system designed to reach its high scalability by running queries inside each target database engine rather than all from the single central repository database, and high availability is archived by storing configuration data in both the central repository and target databases ensuring this process alive so long as the target database is available in spite of the repository database failure. It stores historical tablespace usage data that can also be used for database capacity planning.
• Developed post deployment process for Oracle databases that solved many issues caused by production releases, which also captures all DDL statements executed thus helps troubleshooting the issues due to the releases.
• Solely resolved an 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.
• Built out and provide support for multiple instances of the MS SQL Server 2005, 2008 and 2012 including creating databases, users, and objects, performing database mirroring, backup and restore, and jobs. Monitor activity and performance for MS SQL databases.
• Wrote a shell script to clean up unwanted historical Oracle database trace and log files as well as any other files by simply entering entries in the configuration file. The script will compress, remove, or move files based on file age and name pattern specified in the configuration file.
• Installed Oracle database 12c, created database and reviewed its features.
• Create MySQL databases and users.

Confidential, Stamford, CT

Associate

Responsibilities:

• Served as lead role in the US region to build out consistent Oracle environment globally.
• Provided global support for Oracle database estate consisting of over 1000 databases using Oracle streams, RAC, ASM, and VCS clusters.
• Engaged in Oracle financial R12 project, esp. designed and built 11gR2 RAC database.
• Built 10g and 11g RAC databases as well as 11g standalone databases with VCS cluster in the shared farm servers with the EMC SRDF technology.
• Conducted DR test with the SRDF for the databases hosting various critical applications.
• Lead the project to migrate databases from ABN to RBS domain.
• Packaged sqlnet.ora, ldap.ora, and tnsnames.ora for the US regional applications to connect to global databases.
• Installed, provide system admin and cloning for Oracle financial 11i and R12.
• Installed 11g Grid Control and rolled out agent to the monitored target Oracle databases.
• Wrote packages with PL/SQL for password management, data archiving, and purging.
• Trained and served as US regional expert for the Stratavia (database automation application).
• Setup RMAN backup consistently with the scripts reside in global RMAN catalog.
• Installed GoldenGate and gained some knowledge.
• Trained new DBAs and mentored less-experience team members.
• Performed minor works for Sybase and MS SQL Server databases.

Confidential, NY

Senior Oracle DBA

Responsibilities:

• Solely designed and supported Oracle databases used for middle and back office operations for hedge fund companies.
• Built and supported 10g Oracle Data Guard databases with dg broker. Eliminated backup load on the primary production databases by backing up standby databases with the RMAN.
• Tuned and significantly improved database performance by tuning database instances and SQLs, partitioning large tables, re-organizing fragmented tables, and archiving data off.
• Wrote packages with PL/SQL for business processes as such data extraction and manipulation.
• Installed 10g Grid Control and achieved high availability by configuring standby Grid management services. Upgraded all 9i databases to 10g. Installed and created 10g RAC databases with ASM.
• Supported SQL Server 2000 and 2005.
• Managed database license and worked with outside vendors.

Confidential, New York, NY

Senior Oracle DBAlTeam Lead

Responsibilities:

• Supported all the Oracle databases for the ERMS. Managed all the database projects and mentored onsite and offshore DBAs.
• 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.
• Automated database schema refresh with data pump. Partitioned large tables with the DBMS redefinition method.
• Strengthened 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 SOX audit.
• Protected business confidential data with the Oracle Virtual Private Database.
• Designed and developed Oracle database backup and recovery process with the RMAN as well as enabled flashback database.
• Installed and upgraded the Oracle Grid Control.
• Troubleshoot performance issues and significantly shortened production batch process time by collecting statistics, creating proper indexes, and re-writing stored procedures.
• Designed and developed a process to report database inventory.

Confidential, Weehawken, NJ

Lead Associate

Responsibilities:

• Learnt new environment very quickly and supported Oracle databases for six different applications including mission critical ones.
• Worked with 10g Grid Control to certify and document feature usages.
• Provided in-depth performance analysis with statspack for the alerting and messaging database and made significant performance improvement.
• Supported Oracle database farm environment and upgraded databases to version 9.2.0.8.
• Developed generic script to automate management for date range partitioned tables.
• Automated archiving statspack data and freed up space usage.
• Standardized documentation for DR procedure and Oracle database tool usages.
• Supported terabyte warehouse database.

Confidential, Wilmington, DE

Senior Oracle Database Administrator

Responsibilities:

• 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 policies and procedures
• Served as the lead resource for the Oracle databases in terms of database problems, design, change management, production releases, database and business processes.
• 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.
• Set up database security, secured listener with password, and turned on database auditing
• 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. Chose proper storage RAID configuration and sizes for redo logs, log buffer, and memory.
• Designed and implemented RMAN infrastructure. Refreshed databases with RMAN.
• Developed partition strategy for backend data mart databases, and partitioned large tables with dbms redefinition.
• Performed patches and upgrades. Automated Oracle software silent installation and database creation. Built and supported 9i RAC databases with the OCFS. Installed 10g Grid Control.
• Encrypted password with the gpg utility to remove clear text passwords from scripts.
• Utilized the Oracle 9i Data Guard and 8i physical standby as DR strategy.
• Automated business processes including the bank marketing data load, warehouse data feed, and data scramble with the K-shell script and/or Perl.
• 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 SQL Server databases.

Confidential, New Castle, DE

Senior Database Administrator

Responsibilities:

• Supported OLTP Oracle 9i standalone and RAC databases.
• Mentored junior database administrators and PL/SQL developers.
• Installed 9i Oracle binaries and created standalone and RAC databases on HP, Compaq Tru64, and Redhat Linux. Chose proper storage RAID types and data file layout.
• Designed and implemented RMAN. Wrote generic Unix shell scripts for it.
• Created database schemas and different objects. Implemented database security with customized roles and profiles.
• Implemented active-active database solution with 9i Oracle Advanced Replication.
• Migrated SQL Server 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 OLTP, web reports, merchant setup, payment servers, and data insertion processes. Tuned the SQL statement with proper indexes and hints to decrease response time.
• 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 SQLs with explain plan, Autotrace, SQL Trace, and TKPROF. Enhanced database performance by collecting object statistics, partitioning large tables, creating indexes, using hints and bind variables, and pining packages and small tables into the memory.
• Developed data encryption methodologies and archiving strategies.
• Managed projects involving design, documentation, delivering, testing, and rollout.
• Created stored procedures and assist in administration for SQL Server.

Confidential, Newark, DE

Oracle DBA

Responsibilities:

• Installed Oracle 8i software and created databases. Set up database security by creating roles and profiles.
• Wrote Unix shell scripts to monitor databases and automated 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 SQLs by rewriting the statements, using hints and indexes.