Pl/sql developer
Resume:
JIAZHONG WU (Jason)
Plano, Texas *****
***********@*****.***
Oracle Developer
Oracle Certified Professional(OCP 11g) with extensive experience in full life-cycle application development including data modeling, database design, implementation, and maintenance. Proficient in ETL process and database development and maintenance with PL/SQL and T-SQL. Proficient in database performance tuning and application/SQL tuning, Unix shell scripting, PL/SQL and SQL scripts development, application and database monitoring and maintenance.
TECHNICAL SKILL HIGHLIGHTS
Agile software development methodologies, Scrum project management
PL/SQL database development and maintenance of packages, procedures,functions, triggers
Oracle database/application performance tuning, SQL Tuning, SQL*Trace
Data modeling and database design using Erwin, Oracle Designer
Knowledge of OBIEE, Ab Initio, Microsoft SQL Server, T-SQL, SSRS
SQL*Loader, TOAD, PL/SQL Developer, UNIX shell scripting, HTML, C/C++, Java
EDUCATION
MS, Computer Science, University of Texas at Dallas, Richardson, TX
MS, Physics, Louisiana Tech University, Ruston, LA
BS, Electrical Engineering, Zhejiang University, HangZhou, P.R. China
PROFESSIONAL EXPERIENCE
ETCC (Electronic Transaction Consultants), Richardson, Texas August 2012- October 2017
Sr. Application Developer (PL/SQL)
Designed, implemented and maintained custom applications written in Java and PL/SQL in Linux and Windows
Created, modified and maintained logical/physical data models.
Developed and supported backend data processing with PL/SQL packages, stored procedures, and other ETL scripts.
Designed, implemented, and maintained database objects(tables, views, packages, procedures, indexes)
Developed complex and ad-hoc queries for various reports and analysis.
Performed application and SQL tuning, analyzing AWR reports and trace file outputs.
Developed and customized reports with Oracle Reports
NOKIA, INC., Irving, Texas August 1999 – August 2012
Sr. Application Developer / Data Architect,(2010-2012)
Performed ETL process, data modeling, development and maintenance, and tier 3 application support
Developed and maintained various ETL integration processes (PL/SQL, T-SQL, stored procedures, packages). Maintained and enhanced data models. Performed application and SQL tuning. Analyzing production database usage to identify poor performing SQL statements. Summarizing application and database performance and trends. Making suggestions for appropriate revisions in the production environment as application needs evolve.
Participated in various projects with analysis, design, development of reports executed against a large financial data warehouse and data marts.
Performed application configuration. Tested and deployed application enhancement/changes, Oracle packages/procedures, and various UNIX scripts including monitoring and email reports.
Data Architect/Sr.Oracle DBA, (2001-2010)
Performed database design, implementation, and administration
Performed data modeling and physical implementation for various type of databases(theFeature-OLTP type, CDB-data warehouse type, CCPE-hyperbrid, AWS-OLTP type, etc.,) on Sun Solaris, HP-UX and Windows environments using ERWin
Tier 3 support for N-SCOPE, NokiaUSA.com. Responsible for building and maintaining data models, assisting application teams with identifying and designing the data structures necessary to support the applications. Developed SQL scripts, PL/SQL stored procedures, packages, Unix shell scripts, Crystal reports, ad hoc queries. Performed database and SQL performance tuning. Installed Oracle on new servers, patched, performed upgrades, bulk loads with data pump, SQL*Loader, and external tables. Developed and maintained ETL integration processes using stored procedures and shell scripts.
Performed database and SQL tuning with Oracle STATSPACK, SQL*Trace and TKPROF.
Performed post-delivery support. Analyzed database usage to identify poor performing SQL. Summarized database performance and trends.
Configured and maintained Oracle Data Guard environments on Sun Solaris.
Defined and implemented monitoring strategies with shell scripting and SQL scripts.
Designed and implemented many data archiving processes.
Implemented RMAN backup and recovery strategies and scripts.
Installed and configured Oracle9iAS, OID Server and Single Sign-On on Sun Solaris. Setup multimaster replication environment (Oracle9i, materialized views) for CCPE project.
Oracle DBA, Operation Center (1999-2001)
24x7 on-calls supported more than 20 Microsoft SQL Server and Oracle production databases in HP-UX, Sun Solaris, IBM AIX, and Windows NT environment. Oracle versions include Oracle 7.3.4, Oracle 8.1.6/ 8.1.7. Oracle 8i OPS, Advanced Replication, and Standby DB were used.
Migrated many Oracle7.3 production databases to Oracle8i.
Designed and implemented RMAN backup/recovery strategies (scripts) with Legato Networker.
Performed performance tuning, capacity planning, backup and recovery of large databases.
Performed physical database design and implementation for many projects.
Enhanced existing production management applications using shell scripting and PL/SQL(stored procedures, triggers).
CERTIFICATIONS
Oracle Certified Professional (version 8 through 11g)
ITIL V3 Service Management Foundation
Contact this candidate