OBJECTIVES:

Oracle Database Administrator

PROFILE:

I have more than 18 years of experiences in IT industry, especially in database administration, software design and implementation areas and have 15 years solid Oracle database (from version 7.3.1 to current 12c) administration skills and hands - on experiences in high-end telecom and financial enterprise environments in Unix-like system platform. I have excellent English writing, verbal and communication skills, and I also am strong team player, able to work alone, highly self-motivated and able to adapt and learn new technology quickly.

SKILLS AND TOOLS:

Operating System: IBM AIX, HP - UX, Solaris, Linux, Windows

Language: C/C++, Java, Perl, Korn/Bash Shell, C#, Visual Basic

Database: Oracle (7.3, 8i, 9i, 10g, 11g R2,12C), MS SQL, DB2, MySQL

Application Server: Oracle/BEA Weblogic, Tuxedo, GoldenGate, Tomcat, JBoss

Others: Oracle OEM grid control, Toad, ERWin, PowerDesign, Informatica

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Oracle Database Administrator (Consultant)

Responsibilities:

• Provide On Call support for production Database outage and Performance issue and acknowledge P1/P2 Incident team and Global Command Center calls.
• Provide support to Change Deployment support for Production databases
• Perform data warehouse migration from SunOS Servers to Exadata
• Perform database upgrade from 11g to 12C.
• Provide support for application team on testing and performance tuning
• Provide support on schema refresh and database flashback on non-production databases for application teams
• Provide Support on database backup and recovery and monitor the backup logs
• Provide support to monitor all databases via OEM 12 & 13

Confidential, Charlotte, NC

Oracle Database Administrator

Responsibilities:

• Provide support on Database monitoring and respond to any incidents generated by the system, or initiates escalation process as required
• Provide support on the database migration and transition process
• User account management using CyberArc, maintain user profiles/Policies
• Provide support on patching activities in production and non-production environments
• Support on High Availability Oracle GoldenGate (OGG). Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.
• Monitor and support RMAN for backup and recovery in the enterprise, provide support on export and import of different database environments using Oracle data pump utilities and SQL*Loader.
• Participating in quarterly Disaster Recovery exercises and provide support for App team with various issues during the test.
• Provide support on Oracle network troubleshooting, tablespace usage monitoring, rebuild index / tables etc.
• Support the development and QA teams, and execute SQL scripts in test and production environments, assist with application migration
• Provide assistance on load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, Statspack, OEM Performance Manager and custom scripts by using Korn shell/Perl.

Confidential, Richardson, TX

Senior Oracle Database Administrator

Responsibilities:

• Working as Application DBA in the DBA team to support the development and QA teams, and help build and delivery applications according to the physical DBA team's requirements. Working as one key member of the technical resources pool to support the Front Line Support On-Call team according emergence requirements and issues
• Oracle DBA lead for a large number of tuning projects. Working with Amdocs (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, Statspack, OEM Performance Manager and custom scripts by using Korn shell/Perl.
• Installed, configured, maintained/patched Oracle Database Server11gR2. Performed upgrades from previous version of RAC environments. Prepared and planned the database migration and transition process.
• Setting Up High Availability Oracle GoldenGate (OGG) systems on Oracle Clusterware 11g Release 2 and Oracle 11gR2 RAC environments. 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 Oracle to MS SQL Server / DB2).
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle datapump utilities and SQL*Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• 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 Application DBA tasks such as Oracle network troubleshooting, tablespace usage monitoring, rebuild index / tables etc.

Confidential, Denver, CO

Oracle Database Administrator (Consultant)

Responsibilities:

• Supporting more than 20 Oracle 9i/10g development/testing environments. Help the developers and QAs to do trouble shooting about database issue.
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• Installed, configured and maintained Oracle 10g Real Application Cluster (RAC) / ASM on Redhat Enterprise Linux 4.x boxes.
• Prepared and planned database migration and transition processes, and consolidated data from various sources including DB2, SQL Server and plan text files.
• Analyze data model in the existing databases and validate compatibility with a Golden Gate replicated environment, use GG to setup the data replicated implementation between Oracle 10g and MS SQL
• Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• General DBA daily jobs such as maintaining user roles and privileges, disk usage monitoring, table/index rebuild and reorganization as needed.

Confidential, Lansing, MI

Database Administrator / Senior Application Developer

Responsibilities:

• Led numerous projects in data modeling, database design, and application design for a number of Departments in the state of Michigan using Oracle, SQL Server.
• Conducted user interviews to gather and document system requirements. Undertook system analysis, system design, and system documentation. Designed and developed user interfaces to databases.
• Installed and configured Oracle/MS SQL database servers and application servers in development and QA environments. Consolidated data from various sources for the new systems using appropriate ETL tools, and planned database base migration and transition for the development and QA environments. Document the configuration and procedures for the production team.
• Performed daily DBA tasks to monitor test and QA database performance, troubleshoot issues, perform database tuning and backup. Restore production data into development and QA database servers. Analyzed database’s physical and logical layout, and proposed and implemented database structural changes. Developed and maintained user security.
• Collaborated with database team members, project managers, QA analysts, application users in the development and implementation of new software and applications.
• Developed, integrated, maintained and troubleshot applications using various tools such as Visual Studio, Crystal Reports, SQL, PL/SQL, Java, JavaScript, C++, ASP, XML.
• Set up standards for system development and maintenance. Analyzed, customized and implemented the solutions.
• Performed benchmark test, test result analysis and reporting. Debugged applications and documented the changes.
• Created and maintained user’s guide and technical manuals. Trained application users.
• Developed scripts to automate data exchange between the State departments.

Confidential, Troy, MI

Visual Basic and PL/SQL Developer

Responsibilities:

• Design and develop graphic user interfaces to the database.
• Create stored procedures to calculate and analyze historical sales data.
• Tune the procedures with production data for ultimate performance.
• Produce report in Crystal Report for the management.
• Gather user response on the new GUI and make improvement accordingly.
• Create and refine user manual.