Oracle production DBA

BIANSHENG SUN

******@*****.*** 813-***-**** www.linkedin.com/in/drbsun

PROFESSIONAL SUMMARY

As DBA in development and production environments, ensure Oracle database systems operate efficiently and securely. Skilled in designing, installing, upgrading, and maintaining Oracle databases in large-scale UNIX/LINUX environments. In depth understanding of security and backup procedures to ensure database integrity. Proven skills on performance tuning, security, and user management. Superior communication, presentation, analytical and problem-solving capabilities. Well-developed interpersonal and personal management skills.

TECHNICAL SKILLS & CERTIFICATIONS

Databases: Oracle 7.3 up to 19c and MS SQL server (versions 2000 through 2017)

Operating Systems: MS Windows, Solaris, AIX, and Linux

Programming Languages Unix/Linux shell scripting with Bash/Korn, Perl, J2EE, C/C++, SQL, PL/SQL, and

& Scripting Tools: Veritas NetBackup

GUI Tools: Toad, sql developer, and Nimsoft

ODA (Oracle Database Versions X4-2 and X5-2

Appliances):

Oracle Technologies: RAC (9i, 10g, 11g, 12c,18c, and 19c), ASM, Data Guard, DB security, Oracle Application Server, OEM (Oracle Enterprise Manager, including Grid Control 10 and Cloud Control 12, 13c), SQL Loader, Data Pump, and Golden Gate replication.

Certificates: Oracle Certified Professional DBA Certificates 7.3, 8, 8i, 9i, 10g, 11g, and 12c

Brain bench C++ Certificates and Java 2 Certificates

PROFESSIONAL EXPERIENCE

FLORIDA TURNPIKE ENTERPRISE, Orlando, FL 2019 – 2020

Sr. Oracle DBA

Provide 24x7 on call support for all production databases, and daily maintenance for all environment (dev/intg/qa/prod) databases; participate in incident report, handling, performance tuning (both query and instance tuning), Golden Gate replication, table partition operation, and Oracle 19c upgrade project; handling very large (around 70 Terabytes) EDW database’s maintenance, migration, and reporting.

AIRLINES REPORTING CORPORATION, Tampa, FL 2006 – 2019

Sr. Oracle DBA

Provided 24x7 on call support for all production databases, and daily maintenance for development, integration databases; designed and implemented corporate database backup/recovery scheme and setup security and storage management strategies; worked with developers in designing database tables, partitioning/indexing, developed PL/SQL stored procedures, triggers and performed queries optimization. Created and maintained Oracle databases, database objects, including tablespaces, tables, indexes, views, synonyms, triggers, procedures, etc in development, test, and production environments. Participated incident report and handlings, planned and installed quarterly critical patch updates, and yearly disaster recovery practices. Installed Oracle database and client software on NT and various Solaris, Linux servers. Worked on routine user management and database security practices. Main achievements included the following:

BIANSHENG SUN ******@*****.*** Page 2

The production database was tremendously enhanced by applying due tuning techniques, proactively monitoring databases to keep the down time to bare minimum.

Assisted corporate large-scaled data migration to production database to meet with corporate business requirements.

Converted single instance database to RAC database using Data Guard to eliminate single-point failure of the production database.

Implemented centralized database backup/recovery solution using RMAN, catalog database repository which avoided maintain separate scripts on various servers.

Served as tech lead for completing 9 corporate databases and 4 clusters (including 32 databases) upgrades to meet company technology needs.

Completed all quarterly critical patch update to all corporate databases and ODA platforms to be compliant with PCI standard.

AVIS BUDGET GROUP (formerly Rezlink International, Inc.), St. Petersburg, FL 2001 – 2006

Sr. Oracle DBA/Director

Managed database design (including logical and physical), application design, development, and maintenance; administering company mission-critical main 24x7 database server, development and QA servers (including daily routines, patch updates, backup using RMAN); was on call support for 24x7 production database; mentored junior DBA’s; worked closely with top management group.

Accomplished major database application enhancement project (tech-lead) which reduced application response tremendously.

Completed company’s database server migrations from 8.0.5 to 8.1.7, from 8.1.7 to 9.2.0.1, and from 9.2.0.1 to 10.1.0.4.

Refined production database backup procedures by cutting the time spent from 3 1/2 hours to 1/2 hour.

ADDITIONAL RELATED EXPERIENCE

GEAC PUBLISHING SYSTEMS, INC., Tampa, FL

Oracle DBA

Provided Oracle database expertise including SQL & PL/SQL programming, writing stored procedures and triggers, doing physical and logical design, and implementations, database configuration, backup and recovery and performance tuning (Oracle server tuning and application tuning). Created database, database objects, including tablespace, tables, indexes, and views on NT servers per customer requirements.

EDUCATION

Doctor of Philosophy (Ph.D.), Mathematics, Florida State University, Tallahassee, FL

Master of Science (MS), Computer Science, Florida State University, Tallahassee, FL

HONORS & AWARDS

Walk-the-Talk Award, Airlines Reporting Corporation

Project Completion Appreciation Award, Intermedia

Member of Gamma Chapter of Upsilon Pi Epsilon, FSU

Sino-British Friendship Scholarship, University of Warwick, England

Contact this candidate