TECHNICAL SKILLS:

Database: Oracle 11gR2, 10G RAC, EXADATA, ASM, RMAN, DataGuard, Grid Control/OEM, PL/SQL, Stream, Oracle Media, Foglight, SharePlex, Warehouse Builder, Workflow Oracle Internals, etc.

OS platform: Linux, Solaris, AIX, Windows, AWS, EC2.

Scripts: Shell, Perl, batch, JSON, Java, C, VB.

Others: Storage, Data Domain, Multipath, HugePage, Jumbo Frame, Greenplum, Mysql, Mongodb, Erwin, iSoft, Sybase IQ, 3Par, SAS70, etc.

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA

Confidential, New York, NY

Responsibilities:

• Installed, patched, administered, backup and recovered Oracle11gR2, 10G RAC databases; responsible for a 4T production BI/OLTP database; migrated the database from old production to new; maintained DataGuard replication.
• Worked with Storage engineer and SA to setup the isolated environment for failover/switch over test; developed the process to clone/refresh staging environment from production daily; educated the developers to use resources economically; identified the root causes of the performance issues; tuned numerous SQL statements in applications; taking care of all kind of complicated issues; supported Oracle database in AWS.

Lead Oracle DBA

Confidential, New York, NY

Responsibilities:

• Installed, patched, administered, backup and recovered Oracle11gR2, 10G RAC databases; responsible for a 10T production BI database; migrated the database from old production to new; developed the backup strategy to be able to restore the database to last 60 days; refresh development environment with production; educated the developers to use resources economically; tuned numerous SQL statements in applications; provide guidance to developers according to the company policy.

Oracle DBA

Confidential, New York, NY

Responsibilities:

• Installed, patched, administered and recovered Oracle10G(RAC)/9i databases; migrated a 2G database from 9i to 10G RAC database; responsible for a 10T production BI database, improved its performance by 10%, saved 30% storage space by modifying the ETL application and tuning the database parameters; modeled and supported the company’s flagship application development using Erwin; developed, maintained, modified a centralized magazine newsstand distribution system which will handle 200 magazine titles for 200 wholesalers with total of 200,000 stores.
• The application includes setting up inbox to exchange files, fetching the file from inbox, defining the loading strategy, calculating the draws for each magazine per each store, pushing the result to outbox for picking up; helped developers to tune SQL/PLSQL statements, partitioned large tables, worked with a C# developer to develop the front end interface; installed Oracle Warehouse Builder 10G/9i software, created design - time, run-time repository, developed application prototype for ETL, and installed OEM 10G Grid Control to schedule/execute the mappings; installed and managed iSoft Commerce Suites and Tumbleweed software for transferring data with AS2 protocol; researched, evaluated EDI software.

Senior Oracle DBA/Unix SA

Confidential, NJ

Responsibilities:

• Maintained 3 production databases and 2 development databases; upgraded the production databases from Oracle815 to Oracle9i release 2; upgraded Oracle Application Server 4.0.8 to Apache web server; installed SSL to the Apache web server using mod ssl and openSSL; created DAD for web applications; setup the authentication scheme for applications; wrote shell scripts automating the data download and upload procedures and ftp processes;
• Installed Oracle9IAS and Infrastructure with business intelligence; installed Oracle9IDS for the development team; stabilized and optimized the databases to double the performances by tuning the rollback segment, database buffer cache, SQL statement, and etc.; shortened the overnight batch job to less than half of the processing time by reorganizing and consolidating the scattered procedures;
• Redesigned the backup strategies by implement of Recovery Manager
• Installed Quest Central and Foglight monitoring software; fixed bugs; mentored developers for creating indices, writing efficient SQL, providing sample code, partitioning table, handling exceptions, etc.; solved problems like dead lock issues, JDBC connectivity,
• Provided guidance for developers to write web based application; helped to develop a real time trading system.

Confidential

Unix SA

Responsibilities:

• Installed Solaris 2.6/8/9 to E450, ultras, and sparks; setup 2 Tbyte storage area network, decided the Raid level and the stripe size, formatted/partitioned the disk, created the file systems, mounted and shared them on the server, mounted them onto the client;
• Monitored the healthiness of the file systems, cpu and memory usages; setup the quota for users; upgraded sendmail,
• Qpopper; proposed/built the Emulator 3270 on Solaris that solved a crisis to meet our vendor’s requirement in a pure Unix environment; administered DNS, PIX firewalls, Cisco routers, bridges, and VPN concentrator.

Lead Oracle DBA

Confidential, Hoboken, NJ

Responsibilities:

• Responsible for whole company's 8 production and development databases with about 500 GB of data; designed, defined, created, and maintained Oracle databases and applications;
• Built customer databases, authentication system, reporting system, and online free word searching applications;
• Analyzed data; designed and developed data loading procedures; finalized searching strategies; designed architecture of databases;
• Deployed applications; upgraded whole company's application from Oracle7 to Oracle8; designed and implemented the backup and recovery strategies for production databases;
• Created standby databases for fail over and disaster recovery purpose;
• Provided technical guidance to other dbas and developers.

Databases: Oracle8i, Oracle8, and Oracle7; interMedia TEXT.

Webserver: Oracle application server 4.0.7, 4.0.8; Internet Application Server 8i.

Operating system: Sun Solaris 2.6, 2.7. Machines 2 x E50 00 with 10 400MHZ cpu 10GB memory; E3000, Ultra2, and etc.

Skills: Solid Oracle DBA experience, PL/SQL, pro*C, C++, java, VB, HTML, and Unix administration; Life-cycle development experience; Oem.

System Analyst

Confidential, Westbur, NY

Responsibilities:

• Created Oracle databases, developed Oracle applications;
• Converted Paradox to Oracle.

Programmer

Confidential, New York, NY

Responsibilities:

• VAX, Non-relational database, C, Basic.