SUMMARY:

• I have more than 18 - years experiences in Database/Middle-Ware/Unix/Linux/Windows Systems Engineering and Administration.
• I am a Leading Oracle DBA in Oracle Database and Oracle Fusion Middleware, Sr. Sun Solaris and Linux Administrator, proficient in Perl/Shell/PL-SQL/batch and HTML/JavaScript scripts.
• I am a motivated self-starter with strong problem-solving and analytical skills. Personally, I am sincere, diligent and responsible.
• I am especially interested in seeking a position in a government agency that could utilize all or most of my IT experiences: Oracle database, Middleware and Operating System Administrations.

PROFESSIONAL EXPERIENCE:

Sr. DBA and Data Warehouse Center specialist

Confidential

Responsibilities:

• Designed, Installed and configured Oracle Data Integrator 12c (ODIEE) with Java logic server, Fusion Middleware (FMW) domain and JEE Agent.in Solaris Zone system for upgrading current Data Warehouse center
• Designed, Installed and configured Oracle Warehouse Builder (OWB) 11gr2 in Solaris and migrated OWB 10g to the 11g OWB.
• Upgraded OWB 10g into OWB 11gr2
• Migrated and tested OWB 11gr2 metadata to ODIEE12c using Linux system as tool box.
• Administrator of OWB 10g, OWB 11g and ODIEE 12c, including repository/control center/workflow, scheduler, and ODI scenarios, scheduler, security management.
• Evolved in data architect process, create, testing
• Working with ETL team to cleanup and export/import Source and Target Schemas to Oracle 11gr2 database
• Building up automatic DWH management system including RMAN backup, database health check, ODI performance status monitoring.

Confidential

Sr. Oracle DBA

Responsibilities:

• Automated daily database health check process by designing, developing a set of batch and SQL/PL-SQL scripts, reduced daily database checking time from 2 hours to 2 minutes.
• Developed and automated database and windows system cleanup process by oracle RMAN, batch and SQL scripting. eliminated existing database hang issue caused by disk space and fast recovery area fullness.
• Resolved standby database synchronization issue, configured and initiated standby database using RMAN backup/recovery mechanism.
• Established and automated local RMAN backup process via RMAN, batch and SQL scripting, MML client configuration. Worked on GoldenGate replication design, installing, configuration.
• Upgrading current production database systems from 11gR2 to 12c, including 12c installation, CPU patching, database migration with data pumping tools.
• Implemented database security configuration in the new production, including database wallet, tablespace encryption, access control list (ACL) and user profiles/roles management.
• Responsible for Application release deployment, production support, application database-related issue troubleshooting in development, testing and production systems.

Confidential

Sr. Unix/Linux SA and Oracle DBA

Responsibilities:

• I have been taking full responsibility for WLIS production system including UNIX Solaris 10 system, Network, Oracle 10rg2 databases, and WLIS front-end and back-end applications
• Installed, configured and patched Sun Solaris 10 system on Sun E3500 and Sun ultra servers
• Configured Network interfaces, SSH, firewall, SFTP and other security settings (ipf.conf, pam.conf, ssh and tty admin)
• Performed hard disk partition, file systems creation, storage volume and RIAD configuration for various storage needs.
• Re-configured tape driver, re-wrote tape backup scripts using ufsdump, and ufs snapshot for different type of file system.
• Performed and tested operating system and database backup and recovery process including root, /usr, /var /etc, /device and so on using ufsrestore, RMAN and other methods.
• Designed, Installed, configured RHEL 5 and 6 in NEC Express 5800/r320a-m4 Intel server, including disk partition, network configuration.
• Designed, Installed and configured Oracle 11gR2 RAC database and standby database (data guard) on the Linux RHEL 6 server.
• Designed, installed and configured Oracle WebLogic, Fusion Middle-ware for Form 11gr2, and upgrade of 4.5 form/report to 11gr2.
• Maintained the current 10g Database and Form/Report 4.5 application, including application client installation for end users.
• Wrote an eight-pages document “Nessus Vulnerability Analysis and Action Plan Proposal for WLIS server”, classifying the vulnerability distribution; analyzing the true vulnerability level, assessing the risk of patch implementing; finally proposed Action plan of CSAM or POA&Ms for WLIS.
• Successfully established Oracle 11gR2 Data Guard system into two Linux servers, with primary and standby databases; Demoded its High Availability, High Performance features by performing switch over and failover of the system between the two servers successfully.
• Installed and integrated the existing Forms/Report 6.0 and 6i software to work with Oracle 11gr2 database; compiled and upgraded the current Forms4.5/Report2.5 to 6.0 successfully; developed a login page to integrate WLIS applications for testing.
• With this developed Oracle 11gR2 system, I have provided customer supports for many mission critical issues of Weather Logistics Information Services (WLIS), such as: Analyzed and resolved data discrepancy between different systems, data correction, network issues and so on
• This position convers various areas of Information Technology Industry, including Administrations of Operating System, Oracle Database, Web Middleware, Development of forms/reports and Customer services. For each area I have independently made accomplishment showing strong skills for comprehensive system management, software integration, problem analyzing and resolving and customer support. I have also been following the principles of standardization and best-practice in my work.

Confidential

Sr. DBA

Responsibilities:

• Provide 7x24 production supports for Large Telecommunication Company. Response for on-call, bridge conference call for emergency requirement, and troubleshooting.
• Install, configuration, upgrading current 10g-11g Oracle RAC databases with RAC Data Guards and Confidential storage Management, on Linux Red Hat 5, Solaris 10 operating systems;
• Responsible for Database migration using Data Guard switchover, failover features and RMAN backup tool for RAC database upgrade (Four-node RAC primary and four-node RAC standby architecture).
• Responsible for application migration using data pump tools.
• Responsible for database performance tuning using AWR and ADDM software
• Installed, comforted, tested and implemented Oracle GoldenGate between Oracle databases.
• Support dev/test daily application activities. And as well as application production implementation.

Confidential

Lead Oracle DBA/Oracle Engineer

Responsibilities:

• Played as a lead Database Engineer in Oracle 11g2 RAC database design, installation, configuration and management in a complex environment with Sun Solaris Zone structure, and Oracle Automatic Storage Management system ( Confidential )
• Optimized database applications’ performance by monitoring and analyzing process types of applications, moving applications from On-Line Transaction Processing (OLTP) database to Decision Support System type database (DSS).
• Planed and Conducted application migration from 9i/10g to 11gr2 databases, including making migration lifecycle strategies, production upgrading planning and solid procedures.
• Played as team lead in analyzing, troubleshooting and fixing various performance issues for 11g database applications, such as resource distribution issues in Solaris zone, Confidential configuration and monitoring. Supervised application performance tuning by providing analyses reporting, SQL trace outputs periodically to application team.
• Oversaw production DBA team’s daily duties for 11g databases by re-wrote various Shell/perl and PL/SQL scripts for automation of database and oracle application management, including RMAN/MML installation and configuration, data pump backup process, file system and database alert notification, standby database management.
• Worked on upgrading plan for oracle 11g exadata and exaLogic for database and application moving to box clouding computing in Linux system. Re-wrote perl scripts for DAP-AD synchronization, OID administration and so on.
• Planed and Managed various security tasks in databases and oracle applications such as password policies, network securities, LDAP users creation/modification/deleting meriting and reporting
• Take full Responsibility for OFLC application team’s requisition including on-call production supporting, application production implementation, application database plan and design.
• Provided technical advice, guidance, and recommendations to managers and other technical specialists on some IT issues, CM, Database areas; applied new methodologies CMMI to improve the software development life cycle, IT services delivery and the organization’s IT architecture.

Lead DBA/Database and Application Server Administrator

Confidential

Responsibilities:

• Plan, prepare and verify hardware and software required for Oracle RAC database installation. configured and verified Sun Cluster 3.2, QFS file system, CRS (cluster ready service), RAC software on a new system.
• Create 10g RAC databases in new Sun Solaris cluster servers.
• Migrate current database to the new RAC. Create and implement Cold backup and hot backup shell/sql script for RAC database.
• Designed, installed and configured e-Business Intelligence system for data warehouse team. Install and configure Oracle Warehouse Builder and Oracle Workflow software for Database Warehouse Center, responsible for Data Warehouse ETL lifecycle (extraction, transformation, and loading of data.) development and performance tuning.
• Design, code and implement Perl script for AD-OID users/groups automatic synchronization. Install Sun Solaris 10 and configures virtual machines or zones on a Sun UNIX system. installation/configuration.
• Restored and recovered Oracle Application server for EBSS project from our backup successfully, which was caused by Disk devise failure.
• Used MS Project 2003 to review and plan projects, track progress, analyze workloads and provide work breakdown structure (WBS) and resource allocation.
• Responsible for on-call production support. Conducted Data Warehouse architecture design and application migration meetings. Troubleshoot with Oracle support via conference call.
• Wrote documents on database daily tasks for DBAs work standards including “data warehouse application design notes” and “Single- sign - on and synchronization of Active directory with Oracle OID design”. Adhere to best practices.
• Wrote documentation on “Database RMAN backup/recovery”, “standby database recreation using RMAN backup”, “RAC database installation notes”,
• Automated Database Administration routine tasks such as backup/recovery, email notifications on file systems or tablespace 85%+ full alert, database or application down alerts, database error alert, etc.

Principal Oracle DBA/Database Engineer

Confidential

Responsibilities:

• Installed, configured and managed Sun Solaris 9 and 10 operating system including storage configuration, network layout and Sun Cluster 3.2 for Oracle Real Application Cluster (RAC 10g) designed, deployed and managed 10g RAC with Sun Solaris 10, Sun Cluster 3.2, QFS and oracle CRS. Created RAC databases and upgraded 9i RAC to 10g RAC.
• Maintained and managed Oracle 9i Cold failover cluster database with VERITAS Storage Foundation for Oracle RAC 4.x
• Designed, create and implemented database backup/recovery strategies and processes. Created a comprehensive script set for database backup including cold, hot, export backup with various methods: tablespace-based backup, RMAN etc. Practiced and expertise in different recovery scenarios including Flashback and data miner.
• Automated database, system, and Oracle Application Server by creating different scripts in shell, perl and PL/SQL for security auditing, health check, system monitoring, backup, log file clean, performance tuning and etc. All reports and alert messages are automatically sent to DBAs/SAs via email.
• Responsible for on-call duty for system and customer support. Expert in database performance tuning using Statspack, SQL Trace, Event Analysis, Automatic Database Diagnostic Monitor (ADDM) and Automatic Workload Repository (AWR).
• Installed and utilized Oracle Management technology Oracle Grid Control
• Created, configured, monitored, and re-intentiated oracle database Data Guard. Performed failover, role switch and read-only report on Data Guard.
• Installed, configured, implemented and maintained Ora9iAS and Ora10gAs for Business Intelligence, including OID (LDAP), SSO, Portal, Discovery, and Form/Report etc.
• Created and implemented a Web application for compiling and download/upload form/report. export/import portal groups between development/test and production. Migrated OracleAS from release 1 to release 2.
• Configured, tested and implemented Oracle Single-Sign-On server, LDAP (OID) synchronization with NT Active Directory (AD), and Window Native Authentication (WNA) for Oracle Portal Application.
• Installed and configured Oracle Warehouse Builder and Oracle Workflow software for Database Warehouse Center.
• Designed, coded, and implemented a perl program for AD-OID users/groups automatic synchronization.
• Designed, coded, implemented a set of scripts in perl and shells for OraAS management, including cold backup, configuration file backup, server monitoring, LDAP middle tier packages for centralized application user administration.

Principal Oracle Developer DBA

Confidential, York Town VA

Responsibilities:

• Took leadership in database application design and development using object-relation architecture and Erwin data modeling tool. Oversaw the delivering of full range of new database application to QA testing and production environments
• Took leadership in planning and implementing database application migration from Oracle 8i to 9i databases and from relational to object-relational databases. Took responsibility for both Application and database performance tuning.
• Installed, configured and maintained Unix Sun Solaris (5.8, 5.9) for database server in testing and development environments
• Installed, configured and maintained ORACLE 9i database and 9iAS application on Sun Salaries 9 system.
• Designed, developed user-friend menu driven scripts for database management and performance monitoring.
• Designed, coded and implemented hot, cold backup processes in Korne Shell, and RMAN full/Accumulative/Increment Backup process in Perl.
• Created and maintained a master-snapshot database replication system
• Design physical database objects, data architecture for relational database using Erwin data modeling tool.
• Played a main role in designing, analyzing and object-relational database application, including object types, inheritance hierarchy, object tables and object views.
• Installed, configured JVM, XML DB schema. Tuned, monitored and supported database objects with Confidential, XML type for the developing team, saving disk space for XDB tablespace by 95%.
• Researched and resolved the problem caused by behavior of Confidential, XML, LOB data types in temporary tablespace, reduced the disk space usage by more than 95%. Wrote the documentation on “Temporary tablespace abnormally grow caused by Confidential ”
• Designed and documented a Security layer using Oracle PVD utility for the application administration interface.
• The security layer has granular access control down to individual user level implementing security policies, application context.
• Administrated Single-Sign-On (SSO) users stored in Oracle Application LDAP tier, created a set of PL/SQL packages, procedures for centralized user administration for the worldwide used Web application.
• Helped to configure PVCS software configuration management (SCM) system with both request tracking and SCM features.
• Built application base line for application production delivery.

Confidential

Sr. Infrastructure Specialist

Responsibilities:

• Designed, documented and presented to client on infrastructure architecture for D.C. government database center.
• Installed and configured Window 2000 operating system for Oracle database serve.
• Configured and installed oracle 8i and SQL Server 2000 on Window 2000 and IBM AIX UNIX server.
• Designed, developed and implemented Perl scripts for backup/recovery and performance monitoring on both NT and UNIX systems
• Installed and configured Oracle Enterprise manager server (OEM) and GUI interfaces for remotely monitoring database status and performance
• Provided 24x 7 technical supports to application teams for troubleshooting, question answering.
• Cooperated and coordinated with vendors in ERP application installation, configuration, data loading, PL/SQL package validation, and data migration to production.

Confidential

Sr. Infrastructure Specialist - production DBA

Responsibilities:

• Installed, configured and upgraded Oracle7.x/8.x 15-terabyts databases for Confidential 24x7 production including replication feature, security/network structures and backup/recovery routines (SQL-BackTrack and ADMS used) in UNIX AIX, HP, Sun-Solaris environments.
• Perform database application support for different projects, including creating develop/test databases, PL/SQL and SQL performance tuning, volume testing and production release delivery.
• Installed and administrated Oracle Web Application Server (OAS 3.0/PL-SQL cartridge); upgraded OAS 3.0 to 9IAS 1.0; implemented SSL security layer
• Developed various Unix Shell/Perl scripts and PL/SQL procedures to automate different job tasks and environment setups.
• Responsible for production 24-hour on-call support, cooperating with System, Network Administrators, and Development team leaders to do troubleshooting, slowness diagnoses, and worked with Oracle Technical support for troubleshooting if necessary.
• Supported Confidential database application production delivery coordinating efficiently with development project managers, system and network administrators for release implementation

Confidential

Sr. IT Specialist Staff

Responsibilities:

• I was a Principal Oracle Application Developer and Analyst for a new billing application in Designing, developing, testing and implementing various application modules in C, ProC, PL/SQL, Perl and Korn Shell in HP-UX, Dec Unix environments.
• Familiar with Job control tool Confidential .
• Provided technical leadership in full-life cycle development for a new billing solution application: Documented application design, project plan Coordinated Developing team with QA and DBA teams in project integration and production delivering
• I had played a role as Oracle Application DBA in designing, documenting, developing and delivering full range of the billing application in database, including Storage capacity planning, Data analyzing, Relational data modeling, logical data structure to physical data structure mapping and Schema objects and PL/SQL package creation.
• Optimized database application performance by using Database analyzer, SQL-Trace, SQL tuning, optimizer Override, indexing, schema export/import and related hands-on skills; set up developing and testing database environment for DEV/TEST teams.
• Worked as Senior IT specialist (SYSADMIN) in Confidential UUNET division for administrating and maintaining Internet Access Billing system. The tasks included network configuration, Internet access recording acquisition, customer data analyzing and calculation, high volume demanding of storage management and resource availability monitoring. Extensively used UNIX system shell/perl scripts for billing system programming, integration and for operating system duties, such as UNIX user/group administration, disk capacity estimation and expansion, CPU and Memory performance issues monitoring and handling.

Confidential

IT Tech. Leader

Responsibilities:

• Object-Oriented design with Rational Rose software
• 3-Tier Client/Server architecture using Confidential middle ware, and TCP/IP socket programming skills
• C++ Object-Oriented programming using ROGUE WAVE Libraries
• Oracle SQL/Oracle7 ProC languages for Database application development.
• Provide design document for Web application function requirements, coded, tested and implemented Web server programs: CGIs and NSAPIs using C, Oracle ProC/C++, PL/SQL, HTML, JavaScript languages in Sun-Solaris.
• Contributed to conversion of current CGI based Web site to JAVA Servlet based Web site using Java Servlet, Java Servlets, and JDBC in IBM WebSphere Server environment.