TECHNICAL SKILLS

Database: Oracle 9i/10g/11g RAC, SQL Server 2005/2008/2012 , MySQL 4x/5x, Postgres v8

Platforms: Solaris, HP - UX, Linux, Windows OS

Languages: SQL, PL/SQL, Visual Basic, C, Java, Perl, Bourne Shell

Tools: OEM Grid Control, Oracle AS, RMAN, Toad, ERWIN, ARIS, Veritas Netbackup

Applications: Oracle 11i ERP, Oracle SOA suite, WebLogic, PeopleSoft, MicroStrategy, Cognos

PROFESSIONAL EXPERIENCE

Confidential

Senior database engineer

Responsibilities:

• Maintained Oracle 11g RAC on ASM for Genesys HPE application.
• Maintained asm instance and disk group. Tasks included adding new disk to existing group, creating new disk group, and monitoring disk group space.
• Installed, configured, and maintained Oracle Enterprise manager 12c on VM on Hyper-V.
• Migrated Oracle 9i and 10g databases to Oracle 11g platform.
• Configured Golden Gate replication and performed refresh of schemas.
• Tuned problematic SQL reported by developer and end users by implementing partition, index, MVIEW, and application caching.
• Monitored and analyzed historic performance data and benchmark it against current data to discover/fix potential performance issues.
• Participated in cost and license planning for the operation group.
• Performed database and SQL tuning using Enterprise manager 12c. Analyzed the suggestions from AWR reports, profiler and tuning advisor.
• Automated daily tasks using shell scripts, database job scheduler and crontab.
• Implemented parallelism to process data load for the Oracle data warehouse.
• Performed database refresh using RMAN and data pump (expdp/impdp).
• Participated in architecture design/enhancement of new systems for IVM, data warehouse, HPE, ClientCare, and Hyperion.

Confidential

Senior Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 11g RAC on ASM and SQL Server 2008/2012 databases for Hyperion, Business Objects, JDE, IBM DataStage, eSM, FAS500, JIRA, Nexus, Proliance, Primavera, Sharepoint, and WebSense applications.
• Configured and maintained standby database per recovery requirement on Oracle 11g and SQL Server 2008 databases.
• Leaded in the disaster recovery exercise on system that is used by all US departments.
• Participated in cost and license planning for all Oracle and SQL Server databases.
• Worked with JDE developer/user to optimized performance of the application, decrease application wait time and decrease report runtime.
• Worked with Hyperion end user and developers to refresh development environment.
• Tuned problematic SQL to improved response time by at least 50% by using partition, index and caching technologies.
• Monitored and analyzed historic performance data and benchmark it against current data to discover/fix potential performance issues.
• Performed database and SQL tuning using Enterprise manager 12c. Analyzed the suggestions from AWR reports, profiler and tuning advisor.
• Performed database refresh using RMAN and data pump (expdp/impdp).
• Automated daily tasks using shell scripts, database job scheduler and crontab.
• Implemented parallelism to process data load for the Oracle data warehouse.

Confidential

Owner

Responsibilities:

• Provided consulting services for clients in the healthcare, entertainment, financial, online ads serving and gaming industry running Oracle 10/11g, SQL Server 2005/2008, MySQL v4/5 and Postgres v8 database on Unix/Linux/Window servers.
• Projects include data warehouse design and implementation, BI application review, data center design, capacity planning, cluster database architecture and setup, and ETL development.
• Architected cluster and/or standby databases to meet SLA of 99.999% uptime.
• Performed SQL tuning and improved the response time by adding index, issue hints or making table structure changes.
• Benchmarked performance of production servers and troubleshoot performance issues.
• Configured Oracle stream replication to multiple destination databases.
• Implemented Data Guard and RAC solution to various clients running Oracle 10g.
• Installed and configured standby and cluster databases running MySQL 5x.
• Architected and implemented Oracle 10/11g databases for CRM and CMS applications.
• Automated backup process by setting up cron job for the different level of RMAN backup.
• Installed SQL Server 2005/2008 databases. Projects involved in setting up standby databases, database on virtual servers (Polyserve), and OLTP databases.
• Configured SQL Server 2005/2008 databases. Tasks included setting up database mailer, scheduled jobs and backups, and develop SSIS packages for data import.
• Worked with Cognos BI application developer/report builder to optimized performance of the application and reports.

Confidential

Senior Oracle DBA

Responsibilities:

• Maintained multiple Oracle 10g databases which include OLTP and data warehouse.
• Setup Oracle stream replication to multiple destination databases.
• Performed SQL tuning by exam the explain plan and analyzed table level objects.
• Participated in the data center design and configuration.
• Duties include capacity planning, budgeting, recovery planning, and Oracle database installation and configuration.
• Configured Data Guard on Oracle 10g to meet the SLA.
• Automated daily tasks by using shell scripts and crontab.
• Performed patch installation and database upgrade to multiple Oracle 10g databases.
• Performed database refresh using RMAN and schema refresh using data pump.

Confidential

Senior Oracle DBA

Responsibilities:

• Configured and maintained Oracle 10g RAC for Fox local news stations.
• Planed and implemented RMAN backup for the Fox Local news databases.
• Performed database and SQL tuning. Improved the SQL response and execute time by 80% for the application.
• Eliminated excessive archive log generation by tune the MVIEW refresh, implement trigger base tables and partition tables for My Fox Local project.
• Reviewed database architectural design documents and provided suggestion on database for VP and director of My Fox Local project.
• Performed patch installation and database upgrades.
• Designed, installed and implemented the database schema. Acted as the database architect and the lead Oracle DBA.
• Upgraded Fox Sports and Fox Sports International CMS system and migrated data into the new system from the old legacy system.
• Coded PL/SQL packages and stored procedures for the CMS project.
• Used VARRAY, nested cursor, and ref cursor. Added exception handing to make the code more robust.
• Extracted BLOB from database to file system for the CMS project. LOB included images, video and documents.
• Trained Engineers on database technology and enforced the usage of new features in Oracle 10g.
• Installed, maintained and tuned MySQL v4.1 databases.
• Accomplishments included Master-Slave replication setup, backup of database, and monitored database performance.
• Participated in meetings and assisted on architecture and schema design.
• Utilized open source software and saved about $80,000 on license cost annually.
• Developed complex solutions for scalability issues.
• Application is used by myspace.com users to create individual advertisements.
• Planned the capacity and calculated the growth of the database.
• Calculation includes disk space, number of transactions, number of users, and table partitions.
• Tuned problematic SQL and implemented caching, index and partitioned tables to improve application response time.
• Configured Oracle Data Guard and Stream on Oracle 10g databases on Linux.
• Used partition on key tables to improve query response time.
• Worked with outside vendor for credit card payment processing.
• Architected and implemented backup and recovery strategy for the data warehouse
• Maintained databases, schema and users in Postgres v8 for the MicroStrategy BI app.
• Tuned SQL statement for the application developer and the BI application.

Confidential

Senior Consultant

Responsibilities:

• Supported Oracle 8i/9i/10g databases on Solaris, Linux, and Windows platforms for 17 clients.
• Databases size ranges from 200GB to 800GB.
• Installed and upgraded Oracle database to 10g from previous versions.
• Designed, tested and implemented backup plans for 7 clients.
• Backup types include RMAN, RMAN with Veritas and user backups.
• Maintained Oracle 11i applications for 7 clients.
• Duties included database refreshes, clone of production databases, apply patches and troubleshoot user reported problems.
• Implemented application code changes and worked with developers to tune the applications and Oracle databases.
• Performed tuning of database and SQL statements using the 10g enterprise manager.
• Scheduled and automated recurring job using OEM console.

Confidential

Oracle application DBA

Responsibilities:

• Installed and maintained Oracle 9i/10g servers and clients, Oracle 11i ERP, Mercury ITG, BEA Weblogic, Axeda DRM and APAK applications.
• Participated in the Axeda DRM data warehouse project.
• Designed, created, monitored, refreshed, and tuned Oracle 9i/10g databases.
• Supported over 80 SQL Server 2000 databases.
• Performed complete and incomplete recovery with RMAN.
• Supported Oracle 11i ERP application.
• Duties included apply patches, monitor concurrent managers, compile packages, relink executable and perform database refreshes.
• Cloned Oracle 9i databases and 11i applications using Autoconfig and Rapid Clone.
• Managed database and application security.
• Duties included apply patches, set up user accounts, create roles, views and synonyms, and perform database and user audits.
• Coded Bourne shell scripts to monitor database, disk utilization, and tablespace size.
• Decreased response time, minimized hard parse and consistent gets of SQL statements.
• Evaluated system statistics gather by STATSPACK on a regular basis and developed plans to improve system performance.

Confidential

Database Analyst III

Responsibilities:

• Supported business operations on a 24x7 basis. Achieved database uptime of 99.99%.
• Interacted with Oracle 8i/9i/9iAS databases on Sun’s Solaris 8/9.
• Performed hot backups, export dump of application owner schemas, and RMAN backups.
• Recovered database using RMAN and command line syntax.
• Implemented physical and logical standby databases.
• Tuned Oracle 8i/9i databases which included parameters, memory setting and I/O tuning by reviewing system statistics gathered by STATSPACK.
• Created indexes and table partitions to improve query response time.
• Coded and tuned SQL statements by analyze the explain plan and use the proper hints.
• Managed database and application security.
• Duties include apply patches, set up user accounts, create roles, views and synonyms, and perform database and user audits.
• Coded Bourne shell scripts to monitor database, disk utilization, and tablespace size.
• Coded store procedures, functions, triggers and packages using PL/SQL.
• Coordinated with Production Control team to develop effective version control and post maintenance checks for the applications.

Confidential

Developer

Responsibilities:

• Performed adhoc, functional, and regression testing for Grammy’s Awards websites.
• Participated in the testing phrase of the SDLC of Confidential ’s internal applications.
• Coded store procedures, functions, and packages using PL/SQL.

Confidential

Database Developer

Responsibilities:

• Maintained Oracle 8i databases running on Windows NT server.
• Tuned Oracle 8i databases which included parameters, memory setting and I/O tuning.
• Coded and tuned SQL statements by analyzing the explain plan and use hints.
• Performed backups and export dump of application owner schemas.
• Analyzed the business processes of online purchasing system and worked with business analysts to developed ERDs.
• Coded store procedures, functions, and packages in PL/SQL.