Database Engineer
Resume:
Jay Huang
*** ******* **. ************, ** ****4
*******@*****.***
Summary of Qualification
Highly experienced database engineer, administrator and software engineer with excellent problem solving and analytics skills.
Highly skilled Oracle database tuning expert with extensive experience tuning Oracle at both system and SQL levels.
Excellent skills in developing creative solutions and system automation with extensive programming skills with C++, Java, Shell, Perl.
Professional Experience
Sungard Availability Services 02/2016 to Present (Senior Solution Architect)
Provide daily support for multiple SAP Oracle databases with height volume transactions and large data volumes
Maintain multiple RAC nodes databases and provide proactive solution for monitoring the RAC environments.
Implement and support high availability solutions using Oracle RAC and Oracle Data Guard.
Implement and improve backup strategies using Oracle RMAN backups, NetBackup, Co-Pilot.
Develop and deploy scripts and program for proactive monitoring system events which cannot normally monitored by the existing tools available.
Perform monthly table reorganization and index rebuild to maintain optimal database performance.
Engage with Oracle Technical Support and other third party support for problem diagnostics and problem resolution.
Develop and implement strategies for data center and storage migrations.
Hewlett-Packard
Enterprise Consultant Architect 2005 to 10/2015
Senior Oracle Database Administrator/Engineer 1999 to 10/2005
Design and implement multiple very large Oracle databases cross various of environments and industries.
Install, configure and support Grid Infrastructure, ASM instances and RAC databases.
Install, configure, upgrade, Oracle instances and apply the latest Oracle patches.
Maintain and perform database consistency, database corruption detection.
Analyze data attributes and usage pattern to design partition methods for tables and indexes.
Perform analysis of physical attributes of database objects for table and index compression.
Proactively research and develop creative solutions for maintain maximum uptime and optimal performance for large scale databases.
Perform extensive database performance tuning tasks by fine tuning database memory of SGA, PGA and query optimizer operations.
Monitor and tune RAC global cache by partitioning applications to reduce network traffic.
Perform in depth tuning for SQL performance using Oracle DBMS packages for adjusting objects statistics, selecting optimal baselines, SQL profiles.
Use SQL patch to inject query hints for packaged applications SQL tuning.
Automate the generation of Oracle AWR, ADDM, ASH reports and review the reports for abnormal database performance issues.
Install, configure, upgrade, Oracle instances and apply the latest Oracle patches.
Implement Database backup strategy using RMAN and other third party software products for very large databases.
Implement Active Data Guard for data reporting, Snapshot Standby for testing and Physical Standby for disaster recovery.
Design, implement and maintain disaster recovery strategy using Oracle Data Guard, Veritas Cluster, BCV, HP service guard.
Perform logical and physical database design, maintain database schemas and database objects integrity at both logical and physical levels.
Develop advanced scripts for database monitoring, usage reports, security management and event notifications.
Develop Unix Shell and Perl scripts to automate the process for detecting index corruption and automatic index rebuild.
Perform table reorganization to improve performance and improve space usage efficiency.
Develop security procedures and scripts for maintain database security.
Work closely with developers to address development and performance issues SQL and PL/SQL programs.
Provide guideline for developers for coding practice with SQL and PL/SQL.
Act as primary resource for junior DBAs and resource for application developers.
Lead offshore DBA group to provide 24x7 support and maintain 100% database uptime.
Setup and monitor Golden Gate for data replications among different databases.
Philips Lighting 11/1994 to 04/1999
Senior DBA (Oracle, Sybase, MSSQL)
Oracle
Implement system architecture for system high availability and large database backup strategies.
Install and upgrade Oracle database servers, apply security patches, Perform logical and physical database designs for optimal database application implementation.
Define and setup database authorization, role and user security.
Develop DBA utility programs for the automation of daily DBA routine tasks.
Define database backup and recovery procedures through integration with ADSM.
Define and setup database alert threshold and performance thresholds.
Develop database monitor scripts for the integration with Tivoli enterprise monitor console.
Sybase/SQL Server
Install Sybase database servers, setup application databases and database servers' configuration.
Define backup and recovery procedures, implement SQL-BACKTRACK backup tools for logical and physical database backups.
Develop DBA utility programs for generation of database schema, version control, statistics update, data distribution mappings.
Perform database workload analysis, performance tuning, problem prognosis and corrections.
Participate logical and physical database design, setup database defaults, rules and referential integrity.
Setup database security, Sybase open client connection, ODBC configuration.
Develop database warehouse projects for decision support, product catalog, customer information systems.
Define performance throughput and system response time, conduct performance testing.
Develop stored procedures and SQL scripts for enhancement of database performance and identifying performance bottleneck.
Perform database problem diagnosis, trouble shootings, major database schema upgrades.
Perform daily DBA tasks for diagnosis of database performance problem, database space allocation.
Define and implement backup and recovery procedures for optimal database backup and recovery.
American International Group Livingston, NJ 05/1994-11/1994
Senior DBA
Administrate distributed Sybase database servers, setup and configure application databases.
Define database authorization security, backup and recovery procedures.
Perform the tasks of database modeling, logical and physical design.
Provide technical supports for problem diagnostics, trouble shootings.
Perform database performance analysis, tuning, and capacity planning
Install, upgrade and configure database servers, perform major database schema changes.
Develop SQL script, stored procedures,triggers for automation of daily database administration tasks
Define database rules, defaults and setup database constraints and referential integrity
Perform database performance analysis and tuning, database capacity planning
Define and schedule database batch job process and control remote job executions
Education
MS in Computer Science
East Stroudsburg UniversityEast Stroudsburg, PA
BS in Mechanical Engineering
SouthWest Engineering College, Szechuan, PRC
Contact this candidate