DIANA DAI

Email: acxs3y@r.postjobfree.com Phone: 646-***-****

TECHNICAL SKILLS SUMMARY

Certified Oracle DBA (18 yrs of Oracle, 12 years of MS SQL server, 4 years MySQL, 2 years of MongoDB & Postgres)

Operating Systems: UNIX (solaris, HP, AIX), LINUX, Window

Database Systems: Oracle 8i/9i/10g/11g/12c, MS SQL Server 2000-2014, MySQL 5.*, MongoDB 2.6/3

Oracle Technologies: RAC, Active DataGuard, RMAN, Partition, Flashback, DataPump, ASM, Enterprise Manager Cloud Control 12c / Grid Control, GoldenGate 12, Oracle application server, web logic server

MS SQL server Technologies: Cluster, Mirroring, Replication

MySQL Technologies: Replication, partition, compression, transportatable tablespace

MongoDB Technologies: Sharded cluster of replica sets

Database Backup: Veritas BackupExec, Veritas NetBackup, IBM Tivoli, DataDomain, Avmar

Data modeling: E/R studio, Erwin, Relational Database Design

Programming: PL/SQL, Transact-SQL, SQL, Unix Shell Scripting, Perl

Application: Oracle Financial, E-business Suite, PeopleSoft, Hyperion

SUMMARY

Senior DBA with extensive experice in Oracle, MySQL, MS SQL server and MongoDB. Worked for some most premier companies, including Federal Reserve Bank of New York, Time Warner, Barnes & Noble and some mid-sized companies. Built extensive production and development experience on OLTP and Data Warehousing environment, proficiently knowledgeable on Database Clustering, replication, partition, compression, backup/recovery, optimization/tuning. Keep updated with the latest Database technology and have proven track records to deliver mission critical projects in tight time line.

EXPERIENCE

Nov.2014 – Current, Barnes and Noble --- Senior Oracle DBA New York, NY

Manage the company’s E-Commerce website Oracle production, standby and QA/Dev datababases.

Provide database management for Oracle Enterprise 11gR2 RAC environments, including setup, configuration, deployment, backup/restore, monitoring, alerting, auditing and security. Install 2-4 nodes Oracle 11gR2 RAC on ASM storage Linux platform. Set up DataGuard standby databases.

Work with development teams to design and develop the new databases, create tables/indexes/constraints and stored Procedures, triggers and ad-hoc queries. Deploy complex partition strategy including range, hash, interval partitions.

Install and set up GoldenGate 12 on ASM Cluster File Systems (ACFS), replicate selected tables from multiple OLTP databases to a target centralized reporting database.

Provide 24x7 support to production databases maintenance and critical application release and database deployment.

Install and configure Oracle Enterprise Manager Cloud Control 12c to monitor database performance and send alerts, analyze AWR/ADDM/ASH reports for performance tuning recommendation, review query execution plan to optimize long-running queries. Advise developers on PL/SQL coding, SQL, indexing, data integrity constraints.

Create and deploy materialized views to replicate data across multiple databases.

Upgrade Oracle 11g database to 12c, evaluate and implement Oracle12c new features.

Perform capacity planning, implement database security policy, perform backup/recovery and database cloning with RMAN.

Manage Oracle E-business suite R12, includes installation,patching, performance tuning and troubleshooting.

Sept.2012 – Oct.2014, MediaOcean, -- Senior Oracle DBA New York, NY

Worked as production and project DBA, participated in the overall database system design, development and implementation, provided 24/7 Oracle and MySQL DBA services to global databases and infrastructure across New York, Chicago, London, India.

Set up, cofigure and manage Oracle 11gR2 RAC, Data Guard, ASM, OEM Grid Control, ASM Cluster File Systems (ACFS).

Test, compare and implement Storage Flash Disks and ASM for all Oracle production and staging databases, greatly improve performance and data recovery/refresh speed.

Optimize database system by tuning database parameters, tuning SQL and PL/SQL codes for performance improvement.

Install/Configure MS SQL server cluster, set up linked server to retreive data from Oracle to SQL server; set up Oracle transparent gateway to retrieve data from SQL server to Oracle. Architect DR and failover strategies such as mirroring, log shipping for MS SQL server databases.

Participate full software development and release cycle from database design, capacity planning, creation of table, index & constraints, table partition, troubleshooting performance issues, disaster recovery, backup maintenance.

Provide additional support for MongoDB, Greenplum and Postgres databases.

Jun. 2009 – Sept.2012, Bluewolf Group, -- Senior Oracle and MS SQL server DBA New York, NY

Provided 24/7 DBA services to various companies, including NYSE, Vonage, Bluefly, Benjamin Moore, Crowley Maritime,

and many others, on high-availability OLTP and terabytes Data Warehouse environment.

Provide Oracle 9i/10g/11g Architecture expertise to offer solutions for high availability, backup and recovery, scalability and performance tuning. Hands on experience in deploying Oracle RAC, Active Data Guard, ASM, RMAN backups.

Manage high-performance, high-capacity databases in a critical production environment including database installation, database creation and configuration, general administration, troubleshooting production issues.

Install and configure Oracle Grid Control 10g/11g/12c, develop UNIX Shell and SQL scripts for proactive database monitoring.

Develop different backup, disaster recovery, high availabilities strategies, perform point-in-time database recovery, create Data Guard/standby database, install and support Oracle RAC node one and RAC (2-4 nodes) on ASM and cluster file systems.

Convert Oracle databases on SAN filesystem to ASM filesystem and vice versa.

Support MS SQL server 2000/2005/2008/2012, install SQL server cluster, set up warm standy, mirrored site, transactional replication, peer-to-peer replication.

Support vaious vendor applications, Such as Oracle E-business suite, PeopleSoft, Hypersion, Agile, BI applications.

Jan. 2005 – Dec. 31st, 2008, Federal Reserve Bank of New York. – Senior Oracle DBA New York, NY

Provided support to Database system of Feds Markets Group, support systems of Treasury securities trading and Feds open market operations, support cash payment and security lending, overnight repo, discount window between Central Bank and commerical banks, supports accounting and portfolio management activities for accounts held by domestic banks and foreign foreign central banks and international agencies.

Provided production supports for very high profile Feds Markets Oracle Databases ( Each system has multi-billion dollars transactions per day ). Implement various high availablility technologies including RAC, DataGuard, Veritas Cluster, RMAN, grid control on production and its contingency sites to ensure maximum availability of databases.

Upgrade Oracle Databases from 9i to 10g. Implemented 10g new features and advanced RMAN backup/recovery features, optimized RMAN backup scripts & process .

Designed database architecture, Data Modeling, performed physical/logical capacity planning, developed SQL scripts and PL/SQL packages / procedures, monitored and tuned application performance.

Projects Highlight:

Built two DataWarehouse databases for Federal Reserve Bank’s market risk and credit risk analysis. Created tables/indexes, partitions, materialized views, developed very complex canned report queries and PL/SQL packages, procedures, functions, and optimized them to best performance. (Informatica, ETL, PL/SQL, partition, materialized view)

Built Feds Treasury securities online trading system in Oracle 9i/10g RAC database. Work with application development teams to roll out new projects deployment from development, QA to production environment.

In financial crisis, rollout Primary Dealer Credit Facility program (PDCF) and Term Securities Lending Facility (TSLF) application, new loan program offered to primary dealers to promote liquidity in financial market.

Built VLDBs that contains historical economical data for business report and analysis purpose, created partition and data loading process, tuned application performance.

Jan.2004-Dec.2004, ING Bank – Senior Oracle DBA New York, NY

Provided 24*7 production support to 300+ Oracle OLTP and warehouse databases of ING Bank in a global VLDB environment, supported critical banking systems, including financial transactions, fixed income and equity trading, mutual funds, annuity.

Troubleshoot production problems, analyzed root cause and took resolution accordingly.

Participated in the creation of database standards and best practices; Created scripts to enchance database monitoring; Designed and implemented onsite and offsite high availability solutions to meet business requirements; Optimized database backup and recovery processes;

Mar. 2000-Dec. 2003, AOL Time Warner INC., - Senior Oracle and MS Server DBA New York, NY

Created and managed 30+ large-scale Oracle 8i/9i and 200+ MS SQL server 7.0/2000 production, staging, development databases, ranging across finanical, Treasury, legal, HR/benefits, help desk applications. Developed best practices and scripts for deploying databases. Developed Unix shell scripts, Perl scripts and SQL and PL/SQL procedures to automate operational task, such as space management, monitoring. Planned and implemented backup and disaster recovery strategies of databases.

Engineered Oracle hot stand-by and MS SQL cluster failover technology to enhance availability and scalability.

Built and implemented enterprise database systems through the whole project lifecycle.

Projects Highlight:

Installed and managed the Time Warner corporate accounting system which used Oracle Financials.

Created a mission critical financial warehouse database, extracted 10 years financial metadata from the company’s accounting database to the new database warehouse system, established a central financial information repository for financial reporting, budgeting, forecasting purpose.

Created an analytical supplier Optimizer database, that helped the company headquarter considate information about each division’s expenditure, manage its spending and increase negotiating leverage with its suppliers.

Transformed the company’s Benefits system from Mainframe flatfile to Relational Database design, created a web-based employee benefits system for the company’s 80,000 employees, enabling employees to retrieve their payroll, stock option, benefits information online.

Designed and developed a database and web based application to capture information on IT production infrastructure, enabled to view/edit information on the company’s applications, servers, databases, products and their interrelationships online.

Mar. 1999-Mar. 2000, DAILY RACING FORM, - Oracle DBA/Developer New York, NY

Led a multi-million dollar E-commerce project through its full system development cycle from conceptualization to final deliverable, enabled company’s publishing business to become a fully web accessible system, provided additional steady online subscription revenue for the company. ( Oracle 8i, Oracle application server, Unix Solaris )

Gathered business requirements, translated complex business models to data models. Installed, configured and maintained the company Oracle 8 database server and Oracle application (web) server. Setup replication between main database server

and online database, kept high-volume online databases systems up and running smoothly, troubleshooting problems ranged

from control file/ datafile corruption, process locking, resource contention to performance optimization. Set up monitoring

and backup/recovery scripts and routine job automation.

Co-ordinated with the developer team to develop PL/SQL packages and triggers and stored procedures, which included usage of Oracle text to faciliate text search function.

Developed ETL processes to extract, transform and load data from legacy Mainframe system to Oracle.

Managed Oracle Financial used for the company’s accounting.

1998- 1999, Bigfoot International INC, -Oracle and MS SQL Server DBA/Developer New York, NY

Participated in the design and development of large-scale Oracle and MS SQL server database systems and web-based applications for the company’s B2B business clients, helped them improve their online sales through creative email marketing and proactive customer relationship management. The functionality of the application included dynamic content generation, catalog browsing, user information gathering. Developed complex report queries and front end application for business clients to analyze customer feedback information.

EDUCATION

2002, Baruch College (Zicklin Graduate School of Business), MBA in Finance & Investment, New York, NY

1998, City College of City University of New York, MS in Computer Science, New York, NY

1992, Beijing University, Bachelor of Arts, Beijing, China

Contact this candidate