Oracle DBA, SQL server, Application support

David Jiang

***** ******** ****** **. **** Texas

(Cell): 832-***-****

E-mail: **********@*****.***

https://www.linkedin.com/in/david-jiang-b242b128

SUMMARY

Oracle Certified Professional with extensive experience in the databases, oil/gas industry applications, financial and government agency applications.

A professional DBA with strong experience and knowledge in database design, development, management and application support with Oracle 8/8i/9i/10g/11g/12c, MS SQL Server 2012/2008/2005 on UNIX, Linux, and Windows platforms. Extensive experience in performing a variety of administration duties, such as database setup, configuration, tuning, backup/recovery security management and database migration/upgrade.

An experienced and proficient Software Engineer in the field of software development with SQL, PL/SQL, UNIX SHELL scripting.

A great team player with good communication skills, ability to start new development projects, maintain existing implementations, research new technologies and prototype, oversee technical documentations. An enthusiastic volunteer who loves to give back to the community.

AREAS OF EXPERTISE

Oracle 8i/9i/10g/11g/12c Administration in Window and UNIX (Linux, AIX and Solaris): Oracle software installation and setup with ASM; Database space management; Cold and hot backup/recovery; High availability management with RMAN, Data Guard, Active Data Guard and RAC; Grid Control/OEM setup and configuration, jobs and events management and schedule. Optimization/Performance tuning concepts, procedures and use of STATSPACK; Listener and network configuration and trouble-shooting; Good at Oracle tools such as SQL*PLUS, SQL*Loader and Quest’s Toad, Import/Export, Data Pump and RMAN, and data migration and upgrade, and database performance tuning with index and AWR analysis, partitioning. Patching and upgrading databases. Oracle database refresh with Snapshot, scheduled jobs with exp/imp or RMAN scripts. Submitting TAR with Oracle Metalink.

Oracle database migration and consolidation with exp/imp, expdp/impdp and by using GoldenGate: Migrated 8i/9i/10g database to 11gR2 with Aix/Sun to Linux platform. And from Oracle 10g to 11gR2 version upgrade and zero down time by using GoldenGate.

Application support for various ERP application across oil/petroleum, financial industry and government agency: Sap Basis, PeopleSoft, Tobin from P2, IBM’s FileNet

Oracle Database Development: Good at SQL and PL/SQL and ODBC. SQL and PL-SQL query tuning with Oracle Grid Control, Quest Toad.

Good at Unix/Window Operation System management related to Oracle/SQL Server database setup

MS SQL Server 2012/2008/2005/2000/ Administration: Database and user setup, configuration and management; data management and backup/recovery with SSIS/DTS; stored procedure, query generation and performance monitoring and tuning; and database replication. SQL Server database monitoring, performance tuning and job scheduling with Idera SQL Server Software application

MS Access 2000/97: database setup and design; query generation. Link and import tables from two different databases for data migration by using ODBC

Database Design and Management: Excellent knowledge and experience with Designer6i/2000. Repository management, database design, modeling and management. Database scripts generation and migration. System design documentation and reporting by using reverse engineering with Designer.

Symantec Backup Exe(VERITAS): for backup/restore Oracle, MS SQL Server and data files backup and restore

Working experience with Windows Server OS, LINUX, Solaris and other UNIX OS: Windows OS and Linux OS installation and setup

PROFESSIONAL EXPERIENCE

2013 – 2016 Senior Database Administrator, Apache Corporation, Houston, Texas

-Oracle Database administrator supports environment consisting of over 250 9i/10g/11g production databases. Install, configure, upgrade, backup, performance tune for Oracle databases.

-Support Database upgrade and setup related to Tobin, RigView, FileNet, GIS with arcSDE and other applications for Apache core business in all regions.

-Performance tuning of critical Oracle databases by utilizing tools such as Grid Control, AWR, SQL trace/tkprof, ASH reports, and custom scripts to assist with SQL tuning, index tuning, and implementation of SQL Profiles and SQL Plan Baselines to stabilize performance

-Using RMAN to setup Data Guard for high availability and to set up Active Data Guard database for fetching reports against read-only standby database and thereby decreasing the load on the primary database.

- Database refresh with RMAN, Data Pump or snapshot copy for SAP-Basis or Petroleum related applications using Unix shell scripts.

-SAP-Basis support such as SAP Business Object 4.2, NRX(Asset Hub) database installation, management, refresh and performance support.

-Using 11G Oracle Grid Control to effectively monitor database environment, to run scripts and jobs and to tune SQL query.

-Database installation or migration from 8i/9i/10g to 11gR2 single instance Grid Infrastructure and RAC database with ASM running on Oracle in Linux VMWare.

-Participate in the Disaster Recovery(DR) test for all mission critical application related Databases

-Support MS SQL Server 2008/2012 Databases related issues like patch implementation, database refresh and backup/recovery. SQL Server database monitoring, performance tuning and job scheduling with Idera SQL Server Software application

2011 – 2013 Oracle Database Administrator, Waste Management, Houston, Texas

-Oracle database administrator supporting environment consisting of over 350 9i, 10gR2, 11gR1, and 11gR2 production databases with primary DBA responsibilities for over 75 databases including PeopleSoft Supply Chain Management (Reti) databases, HR and Financial databases

-Install, configure, backup, tune, and support 10gR2, 11gR1, and 11gR2 RAC on Linux RHEL, utilizing ASM storage and 11gR2 Grid Infrastructure and Data Guard.

-Utilized GoldenGate to migrate database environment from AIX to Linux with minimal downtime including upgrading from 10gR2 to 11gR2 where applicable. Utilized GoldenGate for switchover and switchback between AIX and Linux.

-Perform troubleshooting and performance/SQL tuning of critical databases, such as PeopleSoft by using Toad DBA module, Grid Control. Work closely with application developer and user to monitor and analyze the database environment for a fine-tuned performance and database backend.

-Setup and configure RAC and non-RAC databases in Linux and AIX environment and Grid Control monitoring and management.

-Migrated about 150 Oracle databases from AIX to AIX and about 100 Oracle database from AIX to Linux in cost-saving consolidation projects in a very short period of time.

-Extensive use of Flashback technologies for recovery as well as Guaranteed Restore Points as back out plans for script testing and migrations.

-Utilized RMAN, Data Pump (expdp/impdp) for effective database backup, database cloning and point-in-time recovery management.

-Installed, upgraded, migrated, and patched Oracle databases for database upgrade and bug fixing.

-Developed and implemented processes and procedures for database security, auditing, and disaster recovery for SOX controls. Work with auditor from inside and outside of company to make sure the compliance of the user security and standard.

-End to end monitoring of database environments and cron jobs setting up by utilizing Oracle Grid Control.

-Participate in the on-call rotation to support all databases and applications related issues

2008 – 2011 Database Administrator (Oracle/SQL Server), City of Houston, Houston, Texas

-Provide production database support for RODS (Real-time Outbreak Disease Surveillance) and in-house IntraNet applications on daily DBA function in multiple Oracle instances environment for Oracle 9i/10g/11g. Oracle10g Grid Control setup and management.

-SQL Server 2005/2008 databases installation, setup for multiple applications in SQL Server cluster environment. Database backup/restore with SQL Management and TSQL

-Oversee the activities in the evaluation and design of database structure planning and the development of policies and procedures pertaining to the management, security, maintenance and utilization of existing and proposed database systems.

-Oversee and monitor database performance and makes recommendations to improve efficiency and cost-effectiveness along with Oracle and SQL Server licenses maintenance, and hardware and software upgrade

-Design database structures and perform logical and physical data modeling, design relational database models, and creates physical data models from logical data models

-Develop and Support Database development activities. Advise management team on database concepts and functional capabilities, policies and procedures designed to ensure the integrity of the database environment

-Plan, coordinate and implement database migration from Oracle 9i to Oracle 10g for production databases with increased high availability feature and better performance and data solution with partitioned table

-Backup/recovery strategy and procedures automation for both physical and logical backups in testing/production database systems by using Oracle Imp/Exp, cold/hot backup, RMAN including command-line scripts writing, scheduling and management

-Perform data management and loading with MS Access, SQL Loader and SQL Plus as requested by clients and query generation and tuning for multiple Epidemiology applications

-Work closely with developer for database support on development and upgrade of the multiple in-house applications. Support many vendor-supplied applications for department users

-Transfer and loading between MS Access, SQL Server and Oracle

-Work with Oracle support to open TAR, to test/apply Oracle patches for version upgrade or bug fixing

-Write project and grant proposals. Successfully awarded more than $53,000 Discretionary Funding from Department of Homeland Security for RODS database server upgrade in 2009

-Manage and use Symantec Backup Exe. Application to backup Oracle, SQL Server and data files for backup/restore

-Know the Oracle Data Warehouse fundamental and involved in City Data Warehouse project

-Have a deep knowledge and understanding the relationships between hardware, database, license and applications to advise clients for designing and architecting needs

-Server setup and installation, Storage management with RAID (Redundant Array of Independent Disks). Domain user and security management support

-Applications supported: Real-time Outbreak and Disease Surveillance (RODS), Event Management System (EMS), Enhanced Perinatal Surveillance System (EPSS), Enhanced HIV/AIDS Reporting System (eHARS), Electronic Client Level Integrated Prevention System (ECLIPS), WebFocus, Mirth Connect

2007 – 2008 Database Administrator/Application Support, BHP Billiton Petroleum/CSC, Houston, Texas

-Provide production database support for the petroleum applications on daily DBA function in multiple Oracle instances environment for Oracle 8i/9i/10g. Oracle10g Grid Control setup and management

-Backup/recovery strategy and procedures automation for both physical and logical backups in testing/production database systems by using Imp/Exp, cold/hot backup, RMAN and DataGuard including scripts writing, scheduling and management

-Troubleshooting production problems for Oracle database tuning, SQL queries, memory, performance related issue

-Perform data management tasks as requested by clients to load, to refresh the database.

-Work with Oracle support to open TAR, to test/apply Oracle patches for version upgrade or bug fixing

-Work closely with developer for database support on development and upgrade of the petroleum applications

-Oracle Network setup and trouble shooting, ODBC setup and Citrix setup for applications

-Database ERD design and application database development by using Oracle Designer 2000 and Oracle Application Express 3.01 to develop Web Interface for generating forms and reports

-Business Intelligence Tools 10g Installation, configuration and trouble shooting for clients

-Familiar with Oracle E-Business Suite data architecture and basic Oracle ERP applications support

-SQL Server 2005 installation and backup/restore management for BlackBerry application database

-SQL Server database, transaction and performance monitoring with SQL Profile and T-SQL

-Petroleum Applications supported: Tobin, Enterprise Upstream suite( Oracle ERP solutions), EDV from P2ES; Merak-Peep, Merak-Volts, Decision Point from Schlumberger; GTMS from Salem Automation; Bivius from ETech International; iWellFile from LandMark; MasterTax from Master Tax Enterprise; Documentum from EMC; LDRPS from Strohl System.

2006 – 2007 Database/Application Support, JP Morgan Chase, Houston, Texas

-Provide application support to the investment/trading applications, which includes application, database alerts monitoring, trouble-shooting, Oracle scripts and Unix scripts running correctly for data and report retrieving, maintaining and sizing database objects, daily feed and job monitoring in Oracle/Sybase database environment.

-Participate and provide support in designing, configuration and support of application development and testing in Oracle database environments for database related releases, temporary/permanent tablespace issues, database/error-log monitoring and performance tuning.

-SQL, SQL*PLUS scripts development for running jobs and trouble-shooting errors during application support by using Embarcadero DBArtisan 8.1.2 and user audit for Sarbanes-Oxley (SOX) compliance.

-Manage and coordinate application related projects for new releases, DR testing among multiple teams.

-Provide on-call support 24x7 and timely follow-up on problem reports.

-Application support, monitoring, and batch job automation in UNIX by using shell scripts

-Class training on Information Technology Infrastructure Library (ITIL) from BMC

-Financial applications supported: iSynd, LoanIQ, Orbit, PaRIS, CCRM, M3, Tivoli, and Remedy

2003 – 2005 Database Administrator, Auto-Trol Technology Corporation, Houston, Texas

-Responsible for database design, development and administration for production test, and development of Oracle relational databases, providing DBA support for the development of the CM II certified Data Management software at all phases of the system lifecycle.

-SQL and PL-SQL (such as stored procedure, function and trigger) query development and tuning with Oracle Tuning package and with LECCO SQL Expert

-Application Trouble shooting, monitoring and tuning for developers and clients with their Database for performance, space and network issues

-Backup/recovery stratagem with exp/imp, Datapump, DataGuard and RMAN.

-Database upgrade and patch installation

-Oracle server and client databases installation, monitoring and maintenance of development/production database servers

-Performance analysis and tuning with STATSPACK and bStat/eStat

-Testing, documentation for our application related to Database server quality

-Perform database programming (e.g., stored procedures, triggers, views)

-Creates policies and procedures for ensuring the security and integrity of the application

and database. Research and documents weaknesses in design and process, recommend database upgrades, patches from Oracle

-Participated in designing and implementing DBWizard using SQL, PL-SQL and Java. This is a GUI based DBA tool that provides solutions to enterprise database administration problems. Current available modules include instance configuration, application database creation and migration, schema integrity checking.

-Performing database integration analysis and data integrity analysis on problems reported or enhancements suggested and documenting them, writing a detailed impact analysis on each change/enhancement made in the product, writing automated test cases to test the feature being implemented, writing instructions to aid SQA team in testing the change/enhancement made.

-MS SQL Sever 2000 setup, testing for the current software.

2001 – 2002 Database Administrator, PTI System, League City, Texas

Oracle DBA (Production and Development in Window 2000/NT and Sun Solaris)

-Database design, data modeling and development, and repository maintenance by using Designer6i/2000. Reports generation by using Oracle Forms and Reports 6i.

-Oracle 8i/8/9i database install, configuration and maintain for programmers inside the company and for our energy clients in Nuclear Power Plants

-Oracle OMS/OEM configuration in Oracle 8i. Management of eight Oracle database servers for database storage, security, and schema maintenance and scheduled physical/logical backup

-Databases distribution and replication setup and maintenance

-Database partitioning, and performance monitoring and tuning with STATSPACK

-Database, table maintenance and auditing by using SQL and PL-SQL

-Data migration from two different production databases in Oracle by using SQL Loader and Oracle Data Migration Assistant

-Experience with writing complex SQL scripts, procedures and triggers

-Network and Intelligent Agent in client/server set up with Net8 and SQL Net

-Security management in Oracle

MS SQL Server DBA (Production and Development)

-SQL Server2000 database installation, configuration and maintenance for programmers inside the company and for our energy clients

-Databases replication, analysis services, differential backups, log shipping and referential integrity setup and maintenance

-Security management in SQL Server and user monitoring by using SQL Profiler

-Database Import/Export by using DTS, and database backup and restore

-Data Files and Transition Log setup and management with stored procedures

-Monitor and trace databases daily, and resolved problems.

IBM DB2 DBA

-IBM DB2 database installation, configuration and maintenance

-Data migration from DB2 to SQL Server and Oracle

1999 – 2001 Software Engineer, Advance Digital Imaging Research, League City, Texas

-Computational algorithm and image analysis software development for automating chromosome classification software (MacKtype) by using C and C++ for medical genetic clients

-User interface design and development by using C and C++

-New software testing, documentation and quality control in medical genetic labs

CERTIFICATIONS AND PROFESSIONAL TRAINING

Oracle-certified Professional (Oracle8 DBA, Oracle8 DBA, Oracle9i DBA), November 2005

Oracle Database 12c New Features for Administrator from Oracle, Houston, Texas.02/05/2015

Exadata Database Machine Administration Workshop from Oracle, Houston, Texas.11/17–11/21/2014

Oracle Database 11g: RAC Administration from Oracle, Houston, Texas. 11/12 –11/15/2013

Administering MS SQL Server 2012 Databases from CLC, Houston, Texas. 12/9 –12/13/2013

Optimizing Oracle SQL with Hotsos, Houston, Texas. April 30 to May 04, 2012

Oracle Exadata Workshop with Enkitec, Oracle Education, Houston, Texas, February 22, 2011

Oracle Database Upgrade Best Practices Seminar, Oracle Education, Houston, Texas, July 1, 2010

Oracle 11g database Security Workshop, Oracle Education, Houston, Texas, December 1, 2009

Lower IT Costs with Oracle Database 11g Release 2, Oracle Education, Houston, Texas, 10/ 22/2009

Data Modeling for Business Intelligence Government Technology Conference, 01/26/2009, Austin, TX

11i Install, Patch, and Maintain Oracle Applications, Oracle Education, Houston, Texas, 2009

Business Intelligence & Interoperability, Oracle Education, Houston, Texas, September 10, 2008

Data Warehousing with Oracle Database 11g, Oracle Education, Houston, Texas, July 18, 2008

Oracle10g Grid Control Administration, Oracle Education, Houston, Texas, 2008

BusinessObjects Enterprise XI R2 Administration, JP Morgan Chase, Houston, Texas, May, 2006

MS Access 97/2000, Microsoft Education, Galveston, Texas, 1999

MEMBERSHIP

Member of South Central Oracle User Group (SCOUG)/ Houston Oracle User Group (HOUG) since 2008

GENERAL EDUCATION

Master of Science Program, Computer Science,

University of Houston-Clear Lake, Houston, Texas

Master of Science, Biological Sciences,

University of Houston-Clear Lake, Houston, Texas

Bachelor of Medicine, Medical Education,

Shandong Medical University, School of Medicine, Jinan, China

VOLUNTEER WORK

Project C.U.R.E.: Project C.U.R.E. is the largest provider of donated medical supplies and equipment to developing countries around the world. I have been a member of Apache team to volunteer there to sort the medical equipment.

The 2015 YMCA Dragon Boat Team Challenge: Proceeds benefit the South Montgomery County Family YMCA Annual Campaign, which ensures that everyone, regardless of age, income or background has the opportunity to learn, grow and thrive at the Y.

i9 Sports: I coached a team of young soccer players to practice and to match in the games and to encourage them to archive the best of their potential.

Citizen of United States of America

Contact this candidate