Sr. Oracle dba

James Zhang

** ********** ******

Livingston, New Jersey 07039

Email: ***********@*****.***

Phone: 862-***-****

Objective

A position as an Oracle DBA and Unix SA

Skills

Database: Oracle12c, 11gR2, 10G RAC, EXADATA, ASM, RMAN, DataGuard, Grid Control/OEM, PL/SQL, SharePlex, Stream, Oracle Media, Foglight, Warehouse Builder, Workflow, Oracle Internals, Oracle Character set, Greenplum, Mysql, Mongo db, Sybase IQ, SQL server, etc.

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

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

Others: WebLogic, Storage, Data Domain, Multipath, HugePage, Jumbo Frame, Erwin, iSoft, 3Par, SAS70, Active directory; Ldap

Work Experience

11/2013 – present, Sr. Oracle DBA, Mediaocean, New York/NY

Setup the kernel parameters, hugepage, jumbo frame for Oracle; created multipath block devices for ASM disk; configured sudoer for active directory logins; installed, patched, administered, backup and recovered Oracle11gR2, 10G RAC databases; improved overall performance and stabibility of a 4T production BI/OLTP database; migrated the database from old production to new; maintained DataGuard replication for EE and standby replication for SE. Worked with Storage engineer and SA to setup the isolated environment for failover/switch over test; developed the process to clone/refresh staging/UAT/development from production daily; educated other dbas and developers to use resources economically; identified the root causes of the performance issues; tuned numerous statements in applications; took care of all kind of complicated issues; researched in AWS RDS, KMS, and IAM; worked with network admin to setup the VPC to access AWS from NY office and pune office; migrated and supported Oracle database in AWS in Singapore; converted the database character set from ASCII to UTF8(unicode)

12/2008 – 11/2013, Lead Oracle DBA, Fulcrum, New York/NY

Installed, patched, administered, backup and recovered Oracle12c, 11gR2, 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; migrated database tables from SQL server to Oracle; masked sensitive data using scrambling.

7/2003 - 12/2008, Oracle DBA, Time Warner, New York/NY

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.

2/2001 - 6/2003, Sr. Oracle DBA & Unix SA, Tceg Equity, NJ

Maintained production databases and 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, etc; provided guidance for developers to write web based application; helped to develop a real time trading system.

Installed Solaris 2.6/8/9 to E450, ultras, and sparks; setup 2 Tbyte storage area network with LSI SMClient, 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.

2/1995 - 2/2001, Lead Oracle DBA, Reed Elsevier, Inc.,Hoboken/NJ

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 E5000 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.

1/1994 - 2/1995, System Analyst, Article Express, Westbury/NY

Created Oracle databases, developed Oracle applications;

Converted Paradox to Oracle.

7/1993 - 1/1994, Programmer, icket Master Co., New York/NY

VAX, Non-relational database, C, Basic.

Education

Dates Graduated School Degree Location

5/1993 CCNY Masters Degree New York, NY

7/1985 SJTU Bachelors Degree Shanghai, China

Contact this candidate