SUMMARY

• Over 25 years of extensive experience in the Information Technology industry emphasizing on database administration, Unix System administration, application design, development, implementation and support
• Unix System administration experiences includes Confidential &T Unix System V, BSD Unix, SCO Unix and AIX. Planning/Monitoring storage capacity, system performance diagnostics, identify bottleneck in memory, CPU, I/O and network. Relate system activities to database/application activities to identify the source.
• Good skill in Unix scripts for system/database administration tasks, such as backup/restore, database refresh, clone, RMAN, database statistics, purging, etc. Familiar with many Unix tasks such as memory, storage configuration, account management, network configuration(TCP/IP, NFS, rcp/rsh), SCCS version control, etc.
• Expertise in Oracle database administration activities such as installation, configuration, database creation, upgrade, backup and recovery, performance tuning, SQL*Net, distributed databases, advanced replication, ODBC, java client, standby database, optimizing the performance of database, capacity planning, change management, database monitoring, managing storage structures, log shipping, OEM, and RMAN. Some development skills includes SQL, PL/SQL, C, Pro*C, Oracle Forms, Reporter
• Oracle Exadata DMA, work as a sole administrator, including Operating System, Storage Cell, Network, Database. Did installation with Oracle consultant together, quarterly patch upgrade, resilient test('turn off' redundant components alternatively), set up data guard between data centers, schedule cron job to monitor DR lag, TDE tablespace encryption, performance tuning by utilizing smart scan, storage index, disable indexes, etc. set up global names for Exadata on load balancer(Netscaler), set up SCAN listener on different ports(1521/1526), consolidate databases on Exadata by instance caging, IORM, etc.
• Certified Epic Cache DBA(2012&2014NVT), installation, configuration, upgrade/update, monitor using Redalert/Systempulse, backup and recovery, shadow/mirror setup, environment copy, storage management.
• Technical support, tuning, troubleshooting, and administration on PeopleSoft applications, provide database support for application activities such as Peoplesoft patches, bundles, maintenance packs, tax updates, and migrating online and external objects
• Experience as On - Call 24x7 production DBA support, application/development DBA, system administrator; handle business service requests using Helpdesk Service Management/Call centre
• Competency in developing application using database procedure, database trigger, Application Designer, SQL scripts, PL/SQL scripts, Oracle Developer/2000, and Unix Shell Scripts
• MSSQL Server Administration, act as back up DBA to MS SQL Server (install/configure, monitor, tuning, backup/recovery and writing scripts)
• Excellent interpersonal, communication, and analytical skill. A team player, with excellent problem-solving skill

TECHNICAL SKILLS

HARDWARE: AIX Server, Sun Sparc, DEC VMS1000, Dell, Ipad, Exadata

OPERATING SYSTEMS: Unix, Sun Solaris, Digital Unix, Redhat Linux, IBM AIX, Windows 95/ NT/ 98/ 2000/ 2003/2008/ XP/7/8

ERP: PeopleSoft 7.x/ 8.x/9.0 (Finance,HRMS, EPM, CRM, Portal)

LANG/ TECH: C, Fortran, COBOL, SQL, PL/SQL, Unix Shell Script, SQL*Plus, Basic

DATABASES: Oracle 5.x/6.x/7.x/ 8.x/ 9.x/10g/11g, MS SQL Server, IBM Informix, Cache

SERVERS: Apache, WebLogic 5.x/ 6.x/ 8.x, WebSphere 3.x, MS IIS

TOOLS: Oracle Tools (OEM, RMAN, Export/ Import, STATSPACK), Developer/2000 (Forms, Reports), ODBC, SQL*Net, Oracle Tranparent Gateway, SQL*Plus, Toad

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Burlington, MA

Responsibilities:

• Supported PeopleSoft production and development databases (Unix, Oracle, PeopleSoft, Finance, HRMS, and EPM)
• Support production and developement databases for various Lahey appliciations such as Orion Laheyview, Claim Manager, etc.
• Working on all databases administration activities such as installation, backup and recovery, performance tuning, trouble shooting, SQL optimization
• Provided on-call support regarding production-related database problems. Worked with IT managers and application developers to ensure the database high availability, integrity and security
• Configure AIX server to meet the requirements for Oracle database and application, share memory setting, aio setting, monitoring system memory, I/O, paging, network confliction
• Performing database upgrade v7.x, 8.x, 9.x, 10g and 1g. Use Oracle Plan Stability to switch rule-based optimization(RBO) to cost-based optimization(CBO).
• Reorganize database on a yearly basis to enhance database storage and performance.
• Automate backup/restore/refresh/clone production database to development environments on weekly/daily basis by writing Unix Korn Shell script packages
• AIX system tuning, solve high CPU problem by identifying/tuning problem SQL in Orion Laheyview application
• Install/configure Oracle Enterprise Manager on Red hat Linux, including version 9i/10g/11g/12c database and OEM application installation, database creation, backup and recovery. O.S. upgrade and maintenance
• Application optimization, SQL tuning, optimizer settings, parallel, database dynamic statistics, etc., to solve long-running SQL performance issues.
• Setup, Maintain and support database gateway between Oracle and MS SQL server, write SQL Job for transferring data to SQL server for Lahey website
• Setup/Test Oracle Dataguard for disaster recovery
• Setup/Test Oracle RAC for Orion Laheyview to have high availability
• Developed in-house website for database support. Collect historical system and database information, provide support for database and system activities, growth and analytic information for capacity planning.
• Setup/maintain Exadata X3-2 as the database machine administrator for various applications running on Exadata. Involved from installation template, installation with Oracle ACS consultants, create O.S. accounts for application user, create file system using Exadata local drives, mount NFS for database backups, setup ssh account equivalent among database nodes, storage servers and infiniband switches, write backup scripts, convert database from file system to ASM, convert database characterset to UTF32, adjust ‘pam’ security setting, run ‘exachk’, apply quarterly patches, …all of the support tasks.
• Epic Cache database administration, setup Epic environment, configuration, environment copy, SU update, trouble shoot printer issue(comcli, queue, class mapping), setup captive login, sync LDAP accounts, performance tunning for global transfer, sI/O benchmark. Certified as Epic Cache DBA(2014).
• Create/configure Oracle database on Exadata for Epic Clarity database. Setup RAC, DR, auto-start JLC listener, failover test, backup/recovery stategy, etc. Utilize Exadata features such as smart scan, storage indexes to improve SQL performance.

Oracle Consultant

Confidential, Woburn, MA

Responsibilities:

• Worked for various projects including application desgin/development/implementation, database administration, database/application performance tunning
• Worked on all databases administration activities such as installation, backup and recovery, performance tuning
• Provided all kinds of DBA support to development teams as well as production support to various applications
• Performed database tuning by using various tools, such as Oracle Enterprise Manager and SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor
• Write TCL scripts for database tasks
• Analyze business requirement and design database ERD diagram
• Customized and Tuned application Queries
• Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Developed scripts to monitor the storage usage, object status for daily job
• Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers
• Completed export and import of different databases using Oracle Export / Import utilities
• Table fragmentation tuning, partitioning the large table by date.

Database Consultant

Confidential

Responsibilities:

• Worked as database consultant, provide solution for Oracle clients in various projects.
• Worked in Telecom Starcom Billing system project in Shenzhen, China, including database design, infrastructure desgin and application impletation.
• Worked in Confidential Telecom system, solved the Billing system performnace by identifying various bottelneck in memory, disk configuration and application tuning.

Unix System Administration

Confidential

Responsibilities:

• Unix system administration on Confidential Unix system V
• Daily technical support for internal systems in Confidential Beijing office. Customer on-site support/trouble shooting for O.S related issues in various projects
• Involved in Unix System V localization project, wrote unix drivers to support chinese device such as display driver, printer driver etc.
• Setup/configurate RFS(Remote File System) for customer to operate their network devices remotely.