Uploaded File
Tony
tony.zhang.5@gmail.com
404-565-3796
3902 Swallow Woods Point NE
Marietta, GA 30006
Oracle PL/SQL Developer/ DBA
13 years experience W2
3
Recommendations
Average rating
202
Profile views
Summary

  • Working knowledge of Oracle 10g/11g/12c Enterprise Server with solid Linux and Windows platform.
  • Experienced in SQL and PL/SQL programming, UNIX shell scripting.
  • Experienced in Oracle Database Creation, Maintenance, and Upgrade in RAC environment.
  • Experienced in Oracle DataGuard.
  • Experienced in Oracle GoldenGate.
  • Experienced in Oracle Database Performance tuning.
  • Experienced in Oracle Reporting and JasperReport.
  • In depth working knowledge of Oracle RAC 10g/11g.
  • In depth working knowledge of AWR, ADDM, OEM.
  • In depth working knowledge of Oracle Database Appliance (ODA).
  • In depth working knowledge of Pro*C.
  • In depth working knowledge of MySQL Cluster Server - Advanced Edition (Commercial) 5.6.15-ndb-7.3.4
  • In depth knowledge of data mining techniques.
  • Understanding of OEM Grid Control for 10g/11g/12cUnderstanding of OEM Grid Control for 10g/11g/12cUnderstanding of OEM Grid Control for 10g/11g/12cUnderstanding of OEM Grid Control for 11g
  • Strong foundation in Java technology and Object Oriented design, analysis and programming.
  • Having hands-on experience in Web applications development using J2EE technologies.

Experience
Oracle PL/SQL Developer/ DBA
Information Technology
Jul 2008 - present
  • Developed stored procedures, functions, packages, and triggers.
  • Developed the monitoring scripts and DBA tool scripts to perform the daily Maintenance tasks.
  • Generated the Web Report using Oracle10g Reports Builder.
  • Involved in the process design such as designing the procedure to do the database DDL refresh.
  • Tune SQL when there were performance problems.
  • Monitored Oracle database when the execution is slow and provide the solution.
  • Set up and maintain scheduled jobs at database level or CronJobs at OS level for dev, test, and production environment.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Installed and Configured Oracle Database Server 10g/11g in Linux Environment.
  • Applied patches of Oracle database.
  • Backup databases by using RMAN.
  • Created Auxiliary Oracle 10g/11g databases for testing purpose.
  • Managed Security of database Schemas.
  • Installed, Configured and Maintained Oracle Application Server 10g in the Linux Environment.
  • Developed ad-hoc report and dashboard by using Oracle Business Intelligence Discoverer.
  • Configured and secured the network for Oracle database servers and other application servers.
  • Installed, Configured and Tested Oracle Database 11g in RAC environment
  • Installed, Configured and Tested Oracle Dataguard
  • Installed and Maintained MySQL 5.6 database.
  • Developed MySQL database Schemas and DDL/DML scripts.
  • Migrated and Synchronized the data across multiple database platforms.
  • Virtualized and Consolidated Multiple Physical Servers to lower cost of Colo Cabinet. Utilized: Oracle11gR2/10g, Oracle RAC, DataGuard, Oracle Grid Control, Oracle Application Server, TOAD, SQL Developer, ASM Storage, RMAN, Data Pump, SQL*Loader, Linux shell scripting, MySQL Workbench, Heidi SQL, VMware
Triggers Stored Procedure SQL Loader SQL Shell Scripts Oracle RAC Oracle MySQL Business Intelligence PL/SQL DBA Data Security TOAD Oracle Application Server VMWare SQL Developer UNIX PL/SQL Developer Database Backups Database Design Linux
Remove Skill
References
Average Rating

3 recommendations
Oracle DBA/Developer
Information Technology
Mar 2015 - Apr 2016
  • Configured and Maintained Oracle Database 11g/10g in 3-nodes RAC environment.
  • Setting up and maintaining DataGuard on 10g/11gMaintain DataGuard on 10g/11g for Disaster Recovery Purpose.
  • Maintain GoldenGate 11g/12c in Oracle RAC.
  • Created PL/SQL stored procedures, functions, packages, and triggers.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Test and evaluate newly-created Oracle Databases in 12c ODAs.
  • Develop the monitoring scripts and DBA tool scripts to perform the daily Maintenance tasks.
  • Performed Oracle database server upgrades, security patches to maintain corporate data compliance and stability.
  • Tuned SQL when there were performance problems.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
  • Set up and maintain scheduled jobs at database level or CronJobs at OS level for Oracle Database environment.
  • Run ORAchk configuration audit tool regularly to proactively scan for the most impactful problems in RAC environment.
  • RMAN Backup and Recover Oracle databases through CommVault software.
  • Created Auxiliary Oracle 11g databases for testing purpose.
  • Managed Security of database Schemas and evaluate Transparent Data Encryption (TDE) to maintain PCI Compliance.
  • Configure and Maintain MySQL Cluster database5.6.15 ndb-7.3.4. Utilized: Oracle 12c/11gR2/10g, Oracle RAC, DataGuard, Goldengate, Oracle Grid Control and Cloud Control, Oracle Database Appliance (ODA), TOAD, ASM Storage, RMAN, Oracle utilities, Linux shell scripting, Transparent Data Encryption (TDE), MySQL WorkBench, VMware, Percona Server.
Shell Scripts Triggers TOAD Stored Procedure SQL Oracle Oracle 11i PL/SQL Scripting DISA Disaster Recovery Golden Gate Oracle RAC VMWare DBA MySQL Database Backups Database Upgrades Compliance Linux PCI Commvault Bacup Patch Management Auditing
Remove Skill
Jr. DBA
Information Technology
Apr 2008 - Jul 2008
  • Developed stored procedures, functions and triggers on Oracle database and SQL Server database.
  • Developed the monitoring scripts and DBA tool scripts to help DBA to perform the daily tasks.
  • Involved in the process design such as designing the procedure to do the database DDL refresh.
  • Helped the developers to tune SQL when there are performance problems.
  • Monitored 9i and 10g database when the execution is slow and provide the solution.
  • Set up and maintain autosys jobs.
  • Maintained the DDLs in ClearCase.
  • Generated the Web Report using Oracle10g Reports Builder. Utilized: Oracle10g/9i, Oracle Data Replication, TOAD, SQL Developer, DBArtisan, Import/Export, Data Pump, SQL*Loader, RMAN, UNIX/Linux shell scripting, ClearCase Project: iSite - Bundle Qualification Tracker (BQT)
SQL Server TOAD Shell Scripts Scripting SQL Triggers Stored Procedure AutoSys SQL Loader ClearCase Data Replication DBA Oracle Database Design
Remove Skill
Java Developer
Information Technology
Jan 2008 - Apr 2008
  • The project is to track the Bundle Qualification discount Ordering which might be fall out during the flow from the BQT system through Billing system (NSOP e.g.), and Ordering system (SEFS e.g.). If qualified discount ordering fall out, the iSite system must reflow the bundle discount order back to BQT system.
  • Involved in analysis and Design based on the requirement documents.
  • Implemented Struts framework based on the Model View Controller design paradigm.
  • Generated User interface Templates using JSP, HTML.
  • Developed the Java Code using Eclipse as IDE.
  • Develop SQL script in MySQL.
  • Maintain the DDLs in CVS.
  • Backup the MySQL Database. Utilized: Java, Servlet, JavaServer Pages (JSP), Tomcat, JBoss, Struts Framework, Apache Proxy Server, Eclipse, MySQL DBViewer, Linux shell scripting, CVS
Shell Scripts MySQL Apache Eclipse Java Java Servlet JBOSS JSP SQL Struts Apache Tomcat Linux
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Information System
George Mason University 2007
Record has not been verified.
Certifications
Oracle Database 11g Administrator Certified Professional (OCP)
Oracle Database: SQL Certified Expert
Oracle9i: Program with PL/SQL
Sun Certified Programmer for the Java 2 SE 5.0
Skills
Database Backups
2021
12
Linux
2021
12
Database Design
2021
11
PL/SQL Developer
2021
11
SQL Developer
2021
10
UNIX
2021
10
DBA
2021
9
MySQL
2021
9
Business Intelligence
2021
8
Data Security
2021
8
Oracle
2021
8
Oracle Application Server
2021
8
Oracle RAC
2021
8
PL/SQL
2021
8
Shell Scripts
2021
8
SQL
2021
8
SQL Loader
2021
8
Stored Procedure
2021
8
TOAD
2021
8
Triggers
2021
8
VMWare
2021
8
Auditing
2016
1
Commvault Bacup
2016
1
Compliance
2016
1
Database Upgrades
2016
1
DISA
2016
1
Disaster Recovery
2016
1
Golden Gate
2016
1
Oracle 11i
2016
1
Patch Management
2016
1
PCI
2016
1
Scripting
2016
1
Apache
2008
1
Apache Tomcat
2008
1
Application Development
0
1
AutoSys
2008
1
ClearCase
2008
1
Data Mining
0
1
Data Replication
2008
1
Eclipse
2008
1
J2EE
0
1
Jasper Reports
0
1
Java
2008
1
Java Servlet
2008
1
JBOSS
2008
1
JSP
2008
1
Performance Tuning
0
1
SQL Server
2008
1
Struts
2008
1
Windows
0
1