SUMMARY:

• Extensive qualifications in all facets of Oracle database administration and support, as well as full database development lifecycle.
• Solid skills in database cloning, refreshing, migration, backups, restoration and recovery using RMAN; performance tuning, SQL tuning, partitioning, data guard and failover.
• Strong expertise in planning, installing/upgrading/patching, configuring and monitoring Oracle database in UNIX environment.
• Strong background in database system analysis, back - end programming including stored procedure/packages, Shell scripts.
• Good experience in database architecture, logical and physical database design, data modeling.
• Great team player with excellent verbal and writing communication skills.

TECHNICAL SKILLS

Database: Oracle 8i/9i/10g/11g/12c, ASM, MS SQL server, MS Access

Operating System: UNIX (Solaris 9/10/11), UNIX-HP, Red Hat Linux, Windows 2003/2008/2012/ NT/XP

Software/Tools: OEM13c,12c/Grid Control, PL/SQL, Toad, RMAN, Data Guard Broker, Oracle Application Server, Oracle Reports, Erwin, Data pump, SQL loader, Shell scripts, Java, Javaservlet, Java Server Page, JavaScript, Perl, C/C++, Apache, IIS server

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA (contractor)

• Responsible for database software installation, configuration, database upgrade, migration and patching on various platforms.
• Perform database cloning, refreshing, performance tuning, troubleshooting and database administration actives.
• Provide support of the production and development 12c/11g/10g/9i databases.
• Implement ASM and database 12c upgrade and database migration from windows to Solaris.
• Proficient in creating Unix shell scripts and windows batch jobs to automate upgrade, patching processes and database refreshing.
• Configure and setup production BCP (Data guard); perform BCP database failover.
• Create and manage patch plans in OEM to implement patching to multiple targets. Monitoring and proactively instance and SQL tuning to prevent performance issue.
• Conducted capacity planning and RMAN backup/recover solution. Work in close vicinity with the application team for day to day problem solving and process improvement.

Confidential

Senior Oracle DBA

• Dedicated in all aspects of Oracle 10g and 11g database administrations in UNIX environment to support internal and external OLTP systems.
• Planned and Performed Oracle database 10g, 11g and Grid infrastructure installation, patching, ASM and database upgrade, database creations and migrations.
• Performed data guard configuration, setups, monitoring, physical standby database switchover and Disaster Recovery.
• Managed and monitored database backups, implemented database restoration, recovery, refreshing and cloning using RMAN.
• Contributed to database optimization and performance tuning, database maintenance and application supports.
• M anaged production and development database instances; conducted trouble shooting to resolve application and data issues.
• Configured, scripted and set up automated jobs for different databases jobs and application vendors; supported data administers and application teams; performed installation, configuration and upgrade of the Oracle Application severs 10.1.2 and 10.1.3 as well as application server patching and user management activities.

Confidential, Houston, TX

Senior Oracle DBA

• Responsible for installation, configuration and administration of Oracle database 8i/9i/10g in UNIX and Windows environments.
• Planned and executed database backup and recovery strategy and migration. Performed Oracle database upgrades and patching.
• Experienced in database monitoring, troubleshooting and performance tuning.
• Conducted business analysis, database design, modeling, creation, maintenance and support. Designed and implemented partition and management of historic data for reporting purposes. Developed UNIX and Windows batch jobs to perform scheduled data processing and monitoring.
• Created and managed backend process to meet diverse business needs. Performed data loading, data import/export, data transmission.
• Successfully designed, developed and maintained Oracle databases to support TSC system on UNIX. Accountable for design, creating and implementing an OLAP database infrastructure for TSC Cost Management System. Responsible for data transformation to OLAP database, creation of summarized, cube, rollup tables and variety of analysis reports. Proficient in performance tuning, maintenance and support. Designed and implemented database solutions for variety business needs.
• Enhance, maintain and support TSC Reporting System. Integrated data from different database sources(AS/400, MS SQL Server, MS Access) and generated various reports in CSV, PDF and HTML format with Oracle Reports.
• Providing production DBA support for Oracle and Oracle Application Server. Going through the day-to-day user requests and troubleshooting the database related problems. Managed internally requested enhancements and changes to meet internal and external customer needs.

Confidential

System Analyst/Database Specialist

• Devoted to user requirements analysis, system and database design, implementation, database modeling, database programming (PL/SQL), stored packages and procedures, triggers and packages.
• EBS Contract/Event Tracking/Extranet System - As a key member of the development team, worked closely with the end user and constantly exceeded the user’s expectations. Involved in whole life cycle development of the projects. Responsibilities included user requirement analysis, object-oriented modeling and design (UML), triggers/stored procedures programming to implement server side business rules, user interface coding, troubleshooting and application enhancement.
• AEP(American Electronic Power) Customer Communication System Project - Participated in system analysis, database and application functionality design, ORACLE database modeling and programming.

Confidential, TX

Programmer/Analyst

• Working on the Down Stream of Transportation Billing System Project. Responsibilities included design, developing, modifying and maintaining stored procedure wrappers by using Visual C++, developing database stored procedures to access SQL Server data source and creating batch file for running the stored procedure wrappers. Experienced in job scheduling using AppWorx, and source control using PVCS version manager.

Confidential Houston, TX

Project Contractor

• Application support of Employee Training System through modification and quality assurance by using Oracle forms and Visual Basic5.0 as the front end, coupling with the Oracle back end allows multiple users to query and view the geo-science data.