Overview

• Senior Oracle Core DBA certified /Application DBA E-Business R12 certified PL/SQL development /Oracle Architect/SAP
• DB2 DBA z/OS certified, LUW
• SQL Server 2012/2008 /Sybase/MySQL DBA
• Oracle 12c/11G new features Pluggable database online Partitions Migrations
• Oracle OEM cloud 12C, and 11G Grid.
• Applications: Oracle E-Business Suite 11i/R12 Application DBA certified /Oracle PeopleSoft DBA/SAP with Oracle DBA Demantra
• WebLogic Server SOA Oracle Fusion Middleware 11g install, configure, tune, monitor Oracle 10g Application Server
• Oracle Gateway
• HA expert: Data Guard, RAC DBA certified
• Exadata 5 years hands-on /ASM/Columnar Compression HCC
• GoldenGate expert /SharePlex/Stream
• OBIEE/Data warehouse

IBM Certified Database Administrator DB2 10 for z/OS

• Senior Member of China Computer Federation CCF
• Senior Membership of IEEE, Computer Society
• Brainbench Certified Oracle Professional Database Administrator 10G
• Kenexa Certified Oracle 10g DBA.
• Operating Systems MS-DOS, Windows XP/2008/2003/2000/NT, Unix, Solaris 10, HPUX, AIX 5.3, Linux 2.4/2.6 kernel
• Development Languages SQL, Pro C, PL/SQL, J2EE, JDBC 2.0, SQLJ, PERL 5.8 , Python, Unix Shell scripting, C , C, Regular Expressions
• Databases Oracle 7/8i/9i/10g/11g/12c, Oracle Application 11i, SQL Server 7.0/2000/2005/2008/2012, Informix, Sybase ASE12/12.5/15, DB2,
• Applications SAP R/3/ERP 2004/2005 Oracle E-business OBIEE Demantra PeopleSoft Sungard SQL Server BI Informatica IDM
• Front End Tools Visual Basic 6.0, TOAD 7.4, Developer 2000, Precision I3, DB Artisan
• Reporting Tools Crystal Reports 4.6 7.0, Oracle Reports, Oracle Discoverer 10G
• Database Tools OEM 12c cloud control 11g Grid control , SQL LOADER, SQL PLUS, Oracle Net/SQL Net/ Net8, RMAN, Erwin 4.1.4 , PowerDesigner BESR Synantec Backup Exec Server Recovery
• Management Tools Primavera, SAP xRPM

Experience

Confidential

Senior Oracle DBA, DB2 DBA, SQL Server DBA

• Architect work, design applications by using Erwin and DBArtisan
• Created Oracle RAC 11gR2 11.2.0.4 databases for 5 large departments, from planning and testing through production, creating standby physical databases for DR.
• Clone database hot duplicate to create new development database, create scripts to automate whole process.
• Using 12c database for development environment consolidations.
• Configure/monitor/patch Exadata server, migrate database to Exadata server.
• Implementing Database Design Tablespace Index and various objects
• Performance tuning, SQL tuning and database tuning, trouble-shooting.
• Authorization and privileges for DB2 Access
• Regular Backup and Recovery Activities RMAN, CommVault
• DB2 Utilities: Runstats, Reorgs, DSNCOPY, DSN1COMP etc.
• DB2 Query tuning, stored procedures, Triggers.
• Applying quarterly Oracle database patch
• Using OEM 12C cloud control to manage enterprise-wide databases, install agent
• Setup/administrate GoldenGate for database replication in development and production unidirectional and bidirectional
• Support Weblogic Server 11g Install/configure/monitor/trouble-shoot
• Support SOA, design restore/recovery detailed steps.
• Support 7x24 Production environment, rotaing on-call

Confidential

Senior Oracle Application DBA/DB2 mainframe DBA/SQL Server DBA

• Number of Oracle Instances: 150 Number of SQL Server: 50 Number of DB2: 30 biggest database size: 30 TB
• Database Architect work, database design, capacity planning, third party hardware/software recommendation,
• Install 12c databases, Using Pluggable database and 12c other features.
• Responsible for Oracle 11gR2 logical and physical database design, implementation, and maintenance on Unix HP server.
• Design HA/DR architecture for current databases, install RAC databases, create physical standby databases, repair broken /behind standby databases to catch up with primary databases if problem occurs.
• Involved in all phases of database development, design, tuning, and support.
• Create new databases and users set up backups, automate logical backup export , and other monitoring
• Clone database hot duplicate to create new development database.
• Sophisticated database performance tuning based application problem.
• Reorganize database structures: use tools to reorganize or defragment database table spaces, tables, and indexes provide efficient database environment to maximize productivity and improve performance.
• Setup/administrate GoldenGate for database replication in QA and production.
• Patch database regularly Install and upgrade database and related products: Keep databases at current release and maintenance levels install supporting products provide current, stable production and development environments
• Reorganize database structures: use tools to reorganize or defragment database table spaces, tables, and indexes provide efficient database environment to maximize productivity and improve performance.
• Capacity planning and reporting: Monitor file system space, database allocation, etc.
• ASM support install/mutilpathing monitor/disk adding/dropping .
• DB2 Database administration in mainframe z/OS in large environment.
• SQL Server 2008/2012 DBA work recovery as requested, duplicate new development environment, index tuning, sql tuning, database performance tuning when on-call support.

Confidential

Senior Oracle Application DBA/Core DBA/SQL Server DBA

• Number of Oracle Instances: 170 Number of SQL Server: 20 database size: 70 TB
• Database performance monitoring and tuning: closely monitor performance, identify problems and implement solutions, ensure the database is running at optimum speed and efficiency
• Provides application support: Resolve problems and answer questions related to the RDMS and platform environment contact vendor support when necessary facilitate application development and client problem resolution with optimum speed and efficiency.
• Setup/administrate GoldenGate for database replication.
• Reorganize database structures: use tools to reorganize or defragment database table spaces, tables, and indexes provide efficient database environment to maximize productivity and improve performance.
• Provide assistance in database design as needed: Research and recommend optimal design criteria publish standards and work with development staff standardize environment and improve efficiency.
• Capacity planning and reporting: Monitor file system space, database allocation, etc.
• Support OBIEE data warehouse, patching OBIEE, using Exadata half-rack to improve data-warehousing/SQL performance Combined with Exadata to do column level compression HCC,11G
• Design HA/DR architecture for current databases, install RAC databases, create physical standby databases total create 15 new standbys , repair broken /behind standby databases to catch up with primary databases if problem occurs.
• Import Export of various data formats using DTS,BCP, Bulk Insert and SQL 2008 Integration Service
• Install SQL Server instance in cluster, create new databases
• Create SQL server test environment by using backups from production DB.
• SQL Server performance tuning including re-indexing, updating statistics, recompiling stored procedures and active performance monitoring, setup maintenance jobs.
• SQL server backup setup, restore/recovery when needed.

Confidential

Senior Oracle Application DBA/Core DBA/SQL server DBA

• Work as primary application DBA, to assist upgrading path from 11i to R12 oracle E-business Suites in an 11g/RAC environment
• Database Performance Tuning AWR/ASH/TKprof on trace file 10046 , Real Application Testing index/hint/join/histogram tuning 60 tune applications from structures 40 .
• Undertaking installations, upgrades, migrations and patch management of oracle E-business Suites environments Database Application Server
• Perform application and database tuning, performance monitoring and investigative troubleshooting for various customers the main application supported are Human Resource, procure-to-pay, Manufacturing Supply Chain Management, General Ledger and Financials,
• Oracle DBA work for various one-way and bi-directional other applications, for example, SOA, OBIEE and some home-grown products in current environment.
• Use Oracle banner for business process integration
• Setting up of Oracle 12C Cloud Control, Use OEM Cloud control to administrate and monitor all databases
• Migrate Oracle database from Sun Solaris to Linux,
• Create auditing procedure to audit database human resource application .
• Data warehouse tuning, partition newly created tables to improve performance, design related purge strategy.
• Support Application Manhattan retail, Trouble-shooting all related problems.
• Working with system administrators to convert backup server from TSM to Commvault to resolve backup slowness RMAN backup and related backup design and trouble-shooting Collaborate with other leads to test, document, and maintain disaster recovery procedures
• SQL Server DBA support as requested C debug SSIS, sql tuning
• Ensure all appropriate system procedures and change control processes are documented. And make sure they are continuously updated.

Confidential

Senior Database Oracle/SQL server Administrator

• Number of Oracle instances: 36 Number of SQL server: 20 biggest database size: 58 TB
• As a senior DBA, focus on architecture design PowerDesigner for Fedex home-grown applications by applying 11G 11.2.0.3 new feature Performance tuning by creating new stored procedures/using bulk collections/compressions/redesign indexes/partitions program PL/SQL packages to purge obsolete partitions automatically
• Work as R12 E-business DBA in 4-nodes RAC/ASM databases Using AD tools/Autoconfig concurrent manager management patching administrating/monitoring by using Application Manager trouble shooting for Apache webserver and forms servers
• Maintaining Netezza Server, Netezza system administration Experience with Netezza' s nzsql, nzload, backing up data, managing users, schemas, and table structures.
• Setup and tuning and troubleshooting development/test/production GoldenGate replication in RAC/ASM environment stop/start/reconfigure GG settings for data loading. Active-Active design new tables to avoid replication conflicts create stored procedure to catch errors
• Using Exadata off loading/column compression for data warehouse 58TB to improve query speed.
• Work as SQL server DBA as requested, to help daily DBA work: using SSIS for data integration trouble-shooting errors tuning bad sqls.
• Automate database monitoring/administration work by using Perl and shell scripts, maintaining a high-level monitoring, availability and security of data
• Work as project manager for current project, attend various meetings to coordinate project progress/development technical issues direct schedules for development /production release.

Confidential

Senior DBA

• Performance tuning for OBIEE of data warehousing database Heavy SQL tunings for ad-hoc SQL queries
• Migrate Oracle database from Oracle 10g to 11gR1 RAC environment setting up RAC standby database setting up/tuning GoldenGate database replication from legacy production data warehouse database to production
• Install, Configure Oracle 11G Grid control, Mass deployment database intelligent agents.
• Fulfil full application DBA daily activities, including user management creating users, profiles for resource management, tablespace, privileges, roles, quotas, sequence, synonyms, table, index, etc. space management tablespace/segment , monitoring space usage, alert log, memory, disk I/O, CPU, database network connection
• Maintaining Netezza Server, Netezza system administration Experience in using External Tables, nzload and SQL analytical functions.
• Perl scripting for DBA universal automation work across multiple operating systems setting up repository database in dedicated server for mass database monitoring installing Sybase client 15
• 11gR2 Oracle RAC Real Application Cluster database administration.
• Implement/administrate ASM Automatic Storage Management
• Developing relational database models using a tool such as ERWIN or Rational Rose.
• Developing logical data models from existing business requirements.
• Data analysis - interviewing subject matter experts and documenting requirements.
• Data design - data modelling and logical database design create cubes
• Transition of logical database models to physical databases.
• Database backup/recovery design/monitoring Set up Flashback database feature for quick logical errors correction.

Confidential

Senior Oracle DBA/Developer

• Senior Oracle DBA/Consultant for Iway's product Iway Service Manager ISM travel to client companies to do demo, install/configure/patch/debug ISM.
• Install/set up 11G database RAC in RedHat Linux upgrade 10GR2 to 11GR1 Development data modelling design/programming/trouble-shooting support for all related project.
• Install, configure GoldenGate for heterogeneous replication in Oracle Database Oracle to Sybase, Oracle to Oracle
• Setting up Oracle Streams for Oracle-Oracle database replication.
• Design/Programme replication tool for Oracle to Oracle, Oracle to SQL Server, DB2 to Oracle by using different databases' Change Data Capture CDC features Q replication/SQL replication/LogMiner/CDC API Wrapped with JDBC, make a Java Plug-in into ISM
• Support PeopleSoft 9.0 Financials and Human Resources in Oracle RAC database 10G
• Oracle database Performance database tuning by adjusting index/init.ora/chained-rows/TKprof 30 application design tuning by de-normalizing tables/Minimizing database trips/Minimizing logical reads/Minimizing locks/bundled-query approach etc. 70 .
• Maintaining Netezza Server, Netezza system administration Experience in working on Netezza Administrator Tool and advanced security Experience in writing ELT NZ sql procedures and development.
• ETL work for Oracle data warehouse environment by using Informatica.
• Data loading optimisation for a British banking group 200 Million rows .
• Setting up physical standby database Data Guard .
• Using IBM COGNOS for BI reporting.
• Configure/scripting DB2 journaling
• PL/SQL programming, shell scripting for automation.
• Build test environments SQL server 2008/ Sybase 15 in multiple platforms like Linux, Unix, Windows LUW

Confidential

• Migrate/Patch production and all test environment databases from 9i to 10GR2
• Set up some test environments by using 11G, using database Replay feature to test. Upgrade production to 11G 11.1.0.6
• Migrate database from Oracle to Sybase
• Using quest's SharePlex for data replication to achieve better replication performance with low overhead.
• Intensive PL/SQL Development work for Sungard application improvement Procedure, triggers, Package
• Doing Development work based on PVCS version management.
• Acts as liaison with Oracle, users, management, and Sungard vendor .
• Support Oracle E-business suite R12 in RAC 3 nodes environment Upgrade from 11i 11.5.10 to R12 Patching using Quest STAT for life cycle change management.Responsible for initial and on-going architecture and environment design.
• Design quick large db clone strategy for use in daily testing, training and development.
• Oracle development /shell script to redesign bulk data loading.
• Setup/monitor CDC Change Data Capture Informatica ETL from ODS for production data warehousing database/data mining database warehousing tuning intensive SQLs tuning scripting Autosys Unix , and Intel box Exe and Batch files for application.
• Install/setup Oracle Identity Manager IDM
• Setup/configure DB2's data replication, experience with SQL replication/Q replication and Event Replication.
• Manage database features materialized views, snapshots, partitioned tables, etc. as needed
• Experience with using Oracle Exadata storage server for better data storing performance.
• Maintaining Netezza Server, Netezza system administration Experience in working on Netezza Administrator Tool and advanced security Experience in writing ELT NZ sql procedures and development.
• MS SQL server 2005 DBA support for BI applications Integration service IS, Analysis service AS, Reporting Service RS . Debug/tune T-SQL query, SQL server database maintenance backup, space etc. SQL Server query optimisation, performance tuning Using SSIS for data imp/exp/transformation /ETL
• Using Oracle Forms to build query and data-entry applications

Confidential

Senior Oracle DBA/Database Architect

• Evaluate test proposed changes to the environment in QA, pre-production, and validate in production.
• Direct troubleshooting activities during outages, coordinating and engaging internal vendor resources while ensuring timely communication to stakeholders, on-call 7x24.
• Evolve the company's database strategy and work to ensure that new deployments conform to business needs.
• Manage a geographically dispersed matrixed team of Oracle database administrators
• Manage the design, implementation and support of large, complex database environments.
• Effectively manage multiple projects while balancing production needs to ensure deliverables are met.
• Install/deploy the OEM Management Agent, establish OEM Grid Control for all instances to centralize the administration work, identify/setup all processing service for EMS monitoring.
• Install Oracle RACs on Sun Solaris OS sun 10 , 2 clusters are three/four nodes and one is two nodes 10.2.0.3 , all using ASM.
• Large data loading 1-4 TB from production to QA/test environment by using shell scripting for multi-thread parallel. Make them quick to deliver in narrow time window.
• Create RMAN repository, create recovery catalogs, register database. Design backup strategy for individual database centralize backup tape management using Oracle Secure Backup /Oracle Backup .
• Using BMC SQL track, Grid /DB control, TOAD as supplemental tuning tool.
• Support SAP R/3 application with HRMS application, design/implement its backup strategy stress testing for Business Warehouse database BW .
• Using Veritas Netback and Oracle Secure backup to set up back up library for tape backup.
• Using SNMP Trap with SA to send alerts for large Oracle environment monitoring.
• 11i 11.5.10.2 E-business application support RAC, CIFA-financial .

.

Confidential

Senior Oracle DBA

• Upgrade database from 8i 8.1.7.4 /9i to 10G, database patching.
• Created EM repository/troubleshooting for OEM/Grid Control.
• Provide different version Oracle production databases support 24 7 for 8i, 9i, 10G/RAC environment also provide SQL server database support.
• Working closely Oracle Developers to provide production support, many trouble shooting works based on different problem scenarios.
• PL/SQL programming for production database, Debugging PL/SQL scripts to correct developer's errors, shell scripting for cron work.
• Analyzes, develops, tests and implements database designs in development databases, also maintain/troubleshooting development databases.
• Oracle
• Install/configure OID.
• Install Oracle Portal in Linux server.
• Performance tuning for OS level and database/instance level Involved in application side SQL tuning by hint.
• Using different backup solutions RMAN, BMC SQL Backtrack, hot backup scripts .
• Supporting Oracle 11i's Financials Application General Ledger/ Payables/Receivables/Fixed Assets and Human Resources Applications HRMS/Payroll .

Confidential

Oracle DBA/Developer

• Using RAID Strategy for stripping and mirroring SAME , configure Unix kernel parameter.
• DBA work
• Setting up Automatic Storage Management ASM, 10G , allocated system storage and planned for future storage requirements for the databases. Modified and altered the database storage parameters as needed.
• Performance tuning backup/recovery using RMAN and third party tool.