David Duan

Phone: 201-***-**** acxrit@r.postjobfree.com

SUMMARY

Computer professional with many years of experience in large-scale enterprise application deployments in the financial and telecommunications sectors with specialties in the entire Oracle technology stack including engineering, hosting and securing such implementations.

Extensive technical architecture background including architecting, engineering, implementing, hosting, monitoring, tuning and troubleshooting complex, scalable, highly secure and highly available business solutions.

I am a self-motivated, organized and committed individual with the ability to pay attention to details and increase efficiency and productivity. Quickly understand new ideas and concepts, and be able to work on my own initiative to meet deadlines.

Certified Oracle DBA and UNIX System Administrator.

Tech Skills

Knowledge and expertise in the following areas:

RDBMS : Oracle 12C/11g/10g with RAC, Data Guard, OLAP, OLTP, DW, Sybase, MS SQL 2008~2016 (SSAS/SSIS/SSRS), NoSQL, PostgreSQL, AWS

Performance : ADDM, AWR, Explain plan, Trace, Stats pack, OEM, DBMS_STATS, CBO, Mercury, SQL Tuning Advisor, SQL profiler.

OS: AIX, HP-UX, Sun Solaris, Windows, Linux, VMWare, VMS, OS/2

Technology: RDBMS, EJB, J2EE, JSP, Servlet, Data model, Data architect & data security, Shell, C/C++, Python

WORK HISTORY

BNP Paribas, Jersey City, NJ 2005 – Present

Sr. Database Engineer

BNP Paribas is one of the largest banks in the world. It is a multinational bank and financial services company with global headquarters in Paris. Based on 2012 information, BNP Paribas was ranked as the third-largest bank in the world, as measured by total assets, by Bloomberg and Forbes.

Over 10 years of IT experience as an Oracle/MSSQL DBA on a variety of UNIX (Solaris, Linux, AIX, HP-UX), Windows platforms having in-depth expertise with all facets of Database design, Administration, Programming, application Support.

Responsibilities:

Hands on database administrator, database programming in SQL, procedure, shell scripting, Python programing.

Perform the data modeling and revise engineering. Physical and Logical design / model with Erwin Data Modeler & ER/Studio. Maintain the meta data.

Managed Oracle10g and 11g server with Real Application Cluster environment on Solaris and Linux.

The environment is over 500 servers and around 1100 database instances on UNIX and Windows platforms.

Installed and Configured of Oracle servers on UNIX (AIX, Solaris) & Linux.

Installed and Configured of MS SQL servers on Windows.

Moved internet facing application to AWS and ported databases into AWS.

Handled day-to-day DBA activities on all Prod/UAT/Dev DB servers.

Database patches planning and configuration of all environments. Migrating databases to Oracle12c.

Proactive monitoring applications performance including SQL and PL/SQL using various diagnostic tools like OEM/GRID control, STATSPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports. Performed SQL tuning, System tuning, Database and Instance tuning by root cause analysis.

Writing of UNIX shell scripts to manage the health of database proactively.

Data partitioning & tuning queries on large Oracle RAC databases.

Setup OEM grid control by using Oracle12c for the enterprise.

Backup procedures using RMAN. Recovery of Database using RMAN (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files).

Provided on-call supports

Accomplishments:

Have an excellent customer relationship.

Successfully completed company the first time audit and provided documents for the DB security baseline.

Created performance project for the SWIFT payment system. Created partitions for the prod DB and moving data into archive database.

Trouble shooting BAD SQL and re-written the vendor procedure to speed up the security trading batch job from 5 hours to 3 hours.

Supported Oracle Financial/HR PeopleSoft in Oracle environment & completed the Oracle/MSSQL transition. Implemented data security for the sensitive data access control in both Oracle (Fine Grained auditing) and MSSQL Transparent Data Encryption for audit purpose. Using Oracle vault, masking technology for data protection.

Supported BNPP GL system and DWH (10TB). Tuning the application performance and fine tuned the nightly batch to fit the time required.

Resolve SQL performance issues such as high frequency transaction trading platform, static/dynamic execution plan and any other SQL tuning issues.

AT&T Research Labs, Florham Park, NJ 1994– 2005

Sr. Software Engineer

Projects: Voice system, CFO application and anywho.com

Experienced in project lifecycle management, planning, scheduling.

Managed, planned and executed the critical technology initiatives.

Driving innovation and creative solutions to business challenges.

Endured the delivery of technology solutions on schedule and within quality goals.

Designed and implemented data architectures.

Built many applications and system used state of art technologies such as Oracle RAC/OPS, Load balancing and high availability.

Ensured all operational processes are standardized, documented and enforced.

Envisioned, planed, designed, and overseen the implementation and ongoing support of all databases and middleware software technologies including high volume OLTP environment.

Developed, measured and reported on department goals and objectives.

Oracle Server installation, Data Modeling, SQL*Net, SQL*Plus and PL/SQL, Backup/Recovery, Performance Tuning, Oracle Enterprise Manager, 9iAS installation and configuration.

Unix environment and Shell programming, Solaris Installation and Jump Start, System Security and VERITAS Volume Manager, Netbackup, NFS and NIS.

EDUCATION

MS in Computer Science -- University of Southern Mississippi at Hattiesburg, MS

Contact this candidate