Senior Oracle DBA
Resume:
Min Ding
Chantilly, VA *****
Email: *********@*****.*** Cell: 703-***-****
Summary of Qualification
** *****’ experience in Oracle DBA
* *****’ experience in Oracle developer
Master’s degree in Computer Science
Oracle Certified Professional DBA (Oracle12c, Oracle11g, Oracle10g, Oracle9i, Oracle8i & Oracle8)
Oracle Certified Expert, Oracle RAC 11g and Grid Infrastructure Administrator
Oracle Exadata 11g Certified Implementation Specialist
Oracle GoldenGate 10 Certified Implementation Specialist
Productive, motivated, independent and cooperated
Key Skills
Database: Oracle 12c/11g /10g / 9i / 8i / 8 / 7.x, PostgreSql Enterprise DB v9.5.3, MS SQL 2012, MySQL
Operating Systems: Oracle Exadata, HP-Unix 11.x, Sun Solaris 5.x, RedHat Linux 7.x, Windows
Software/Tools: SQL*Plus, PL/SQL, SQL*Loader, Oracle Databump, OEM, RMAN, SQL*Net,
SQL Developer, Toad, Data Guard, RAC, Oracle GoldenGate, Oracle EBS 12.2
Education and Certification
M.S. Computer Science, Southeastern University, Washington, D.C. 1994
B.B.A. Business Administration, Xingjiang University, China 1982
Oracle GoldenGate 10 Certified Implementation Specialist 06/26/2013
Oracle Certified Expert, Oracle RAC 11g and Grid Infrastructure Administrator 06/06/2013
Oracle Exadata 11g Certified Implementation Specialist 12/16/2011
Oracle Certified Professional DBA ( Oracle12c ) 10/30/2014
Oracle Certified Professional DBA ( Oracle11g ) 10/26/2011
Oracle Certified Professional DBA ( Oracle10g ) 04/28/2006
Oracle Certified Professional DBA ( Oracle9i ) 05/24/2002
Oracle Certified Professional DBA ( Oracle8i ) 03/22/2001
Oracle Certified Professional DBA ( Oracle8 ) 07/19/2000
Experience
Unissant 11800 Sunrise Valleys Dr. Reston, VA 20191 Database Management Specialist III 9/2017 – 3/2018
Client: ACF of HHS
Working as DBA lead to responsible for managing, implementing, upgrading and maintaining the OCIO (Office of Chief Information Officer) databases that reside on Red Hat Linux (5.x) servers and MS SQL (2012) servers.
Upgraded the Oracle databases from 11.2.0.3 to 12.1.0.1 to utilize Oracle latest available new features.
Coordinated with system administrators to resolve the lack of database memory and disk space issues to upgrade Oracle databases.
Implemented database performance auditing and tuning in production and non-production environments on Linux and MS SQL servers.
Resolved the database related issues reported by phone calls, personal walk-in and tickets assigned by Service Desk.
Implemented database daily incremental backup and weekly full backup for production databases. Documentation and test the database disaster recovery plans.
Designed and created new database per regional offices and program offices’ request to support and assist their existing and new projects.
Established database document section in the SharePoint and created documents such as DBA Best Practice and Database System Architecture Improvement Plan, etc.
Accenture Federal Services 800 N. Glebe Rd. Arlington, VA 22203 Database Specialist 6/2016 – 7/2017
Client: CMS of HHS
Working on the Marketplace Consumer Records project as a database management specialist to involve the technical designs and implementation of the MCR databases and application portal. The application portal will consolidate and presents information from multiple databases and vendors in one central location to allow visibility across all marketplace data tied to a consumer.
Defined PostgreSQL Enterprise Database development infrastructure and setup EDB configuration file parameters.
Monitored the database performance, base tables’ record growing ratio and tablespace usage.
Added/updated the table indexes for improving the database read and write, I/O and data load performance.
Designed and implemented database table partitioning to fix the table with multiple hundred millions of records.
Reviewed and approved the SQL queries and scripts for developing the MCR database or applications.
Provided weekly database statistics report to management for MCR base tables’ row count and space usage.
Assisted and supported software development team and test team to analyze data and identify/diagnose bottleneck to resolve variety of issues and requests.
Agilex Technologies 5155 Parkstone Dr. Chantilly, VA 20151 Senior Principal Oracle DBA 10/2011 – 5/2016
Client: CBP of DHS
As a senior principal Oracle DBA, working on different projects on the C3E program which provides a shared Common Delivery Platform (CDP) as the foundation for applications and technology implementations across all tiers of the application stack in the agency of Customs and Border Protection (CBP) of U.S. Department of Homeland Security.
Designed solutions to migrate oracle databases on legacy systems to EXADATA platfrorm:
1.Used Databump and transportable tablespace to change the database character set between databases with a different NLS_CHARACTERSET and convert characterset from US7ASCII to UTF8 while the databases were migrated from UNIX to Exadata.
2.Migrated databases from source to Exadata using Oracle DataGuard which is the fastest method with least downtime when the database version and platform are same on both source and target.
3.Migrated databases or schemas from source to Exadata using Oracle GoldenGate which provides flexible availability features such as active-active database for data distribution and continuous availability, and zero or minimal downtime. Used GoldenGate to migrate the near real-time data warehouse and consolidated various and heterogeneous source databases include various Oracle version, source platform and characterset to Exadata.
Created and configured the Oracle 11g databases on EXADATA as part of the consolidation efforts for the agency.
Extensively used GoldenGate in migration efforts for systems hosted on ZLinux and Non Oracle databases (SQL Server).
Setup and maintained Oracle11g Grid Infrastructure (RAC).
Setup DataGuard for multiple standby using one primary database.
Designed and planed the Disaster Recovery (DR) setup and implemented backup/recovery strategies with RMAN.
Implemented Oracle Grid Control for database administration, monitoring and performance tuning.
Upgraded the 11g databases to 12c to utilize latest available Oracle features.
Worked as database administrator with Identity, Credential & Access Management (ICAM) project to provide database support. The responsibility include create, implement and maintain the ICAM databases that reside on Exadata machine.
Serco 1818 Library St. Reston, VA 20191 Senior Oracle DBA 01/2007 – 08/2011
Client: Census of DOC
Provided 24/7 support as a production database administrator for mission-critical system within the Database Administrative Support Branch of AMSD in the U.S. Census Bureau by functioning as a technical authority in all assignments and applies available technologies and basic management principles to adapt computer methods to a variety of subject matter situations and providing accurate and timely financial data.
Supported migrations in the approximately 60 applications and 40 databases across development, test, training and production environments.
Provided 24x7 on-call production support for several OLTP and data warehouse applications running on UNIX and Windows.
Supported fail over procedures in the Tru64 Unix, SUN Solaris and 3 nodes Linux RAC and ASM Grid environments by developing shell scripts to support application processes linked to the database.
Monitored backups/resource utilization, granted and revoked user access, audited database usage and provided daily security audit reports to management on production databases.
Identified, diagnosed, resolved and/or made recommendations as to the various performance issues, ranging from I/O, slow responses, and hardware or software issues.
Planned and implemented the quarterly Oracle Critical Patch Update to Oracle systems.
Reorganized databases to reclaim storage and reduce disk I/O through import/export, index rebuilds, and database rebuilding.
Developed UNIX shell scripts to automate routine database operations through the Oracle crontab.
Applied security / business rules and best practices to support data extractions, transports, loads, performance improvements, and application deployments.
Assisted and supported software development team by performing the data analysis, performance bottlenecks identification and database tuning to resolve the variety of issues or requests.
Creative Information Technology 7799 Leesburg Pike, #500, Falls Church, VA 22043 Oracle DBA 11/1999 – 01/2007
Client: EPA
Maintained, developed and implemented the U.S. Environmental Protection Agency's Toxic Release Inventory database using
PowerBuilder & Crystal Report as the front end and Oracle as the database engine on Windows XP environment.
Analyzed data and processed requirements of validation and verification.
Interacted with operations support regarding production problems and database management.
Evaluated efficiency of program and system designs by using database resources.
Implemented trouble shooting and provided database performance monitoring, optimization and disaster recovery assurance.
Provided assistance and support to the software development team by developing/updating SQL statements or scripts and database documentation.
Provided the daily, weekly and monthly data statistics reports to TRI Project management and EPA.
Computing Technologies 3025 Hamaker Ct. Fairfax, VA 22031 Oracle DBA / Systems Analyst 07/1995 - 11/1999
Client: DOD
09/1997 – 11/1999: Oracle DBA
Developed and maintained the database in Windows/NT and VAX / VMS environment for the DOD project -Defense Telecommunications Service-Washington (DTS-W), the Automated Finance and Accounting System for telecommunication equipment and services for approximately 700 commercial telecommunication vendors and government’s agencies in D.C., MD and VA regions:
Managed database primary objects such as tables, views, sequences, synonyms, indexes, and stored procedures/functions and their storage structures.
Enrolled and monitored users by creating new user account, allocating the storage space for the user, controlling and monitoring user access to the database.
Defined different roles for the application and granted system privileges and object privileges to role and maintained system security.
Performed the database backup and recovery to ensure that the data stored in the database was able to access by the users, and that the contents of the database were up-to-date, consistent, and correct.
Performed database tuning that includes data access, memory management, disk I/O, CPU usage and resource contention, and configured the database by using Oracle OFA Rules.
07/1995 - 09/1997: Systems Analyst
Designed, developed and enhanced form-based applications using SQL*Forms and SQL*Menu to simplify customer interface with the database tables that are used to track customer inventories and vendor billing.
Generated SQL*ReportWriters and wrote SQL scripts to create ad-hoc reports. Analyzed information in the database via use of SQL*Loader and Import / Export utility programs to ensure approximately $12 million of monthly service orders were processed correctly and efficiently.
Converted the Oracle applications from Form3.0 to Form4.5 and from ReportWriter1.1 to Report2.5 and then took the advantage of the GUI capabilities to do the enhancement.
Contact this candidate