SUMMARY

• Solution oriented Oracle Database Administrator with over 14 years of professional IT experience with different oracle version such as 11g, 10g, 9i, 8i, 8.x, 7.x and including extensive working experience on architect and infrastructure design, which include schema design, security design, database logical design and physical design, SAN Storage design and so on.
• Proven records on Handling mission critical task, such as recover the Production database using RMAN, troubleshooting Production issue, Performance tuning on DB level and SQL level
• Provide High Availability solution with RAC, standard by database and other grid/clustering technologies such as HACMP on various operating systems such as Linux, UNIX (IBM AIX, HP UNIX and Solaris), Windows NT, Windows 2000/2003
• Hands on experience in Oracle advanced technologies such as RAC, OEM, Grid Control, Data Guard (both logical and physical), Streams, partitioning, RMAN.
• Managing various databases sizes ranging from 25GB to 100 Terabyte and administration of large scales of oracle instances.
• Creating all stage database, such as DEV, TESTING, READINESS and Production. Based on the ENV Owner requirement, setup the backup and recovery procedure using RMAN, Netbackup, BCV technology, data pump. Optimize backup and recovery procedure.
• Hands - on experience leading all stages of system development efforts, including requirements definition, logical design and physical design, design schema, user, role, security and so on. Based on the size of database and type of application, optimize the physical layer by designing SAN storage, file system, tablespace and database parameters such as Memory Target, SGA, PGA
• Expertise includes Oracle Installation, Backup/Recovery (RMAN), Instance/Database performance tuning, Migrations/Upgrades, DR planning, Patching, Replication, Streams, SQL and PL/SQL tuning, using these technologies in professional and volunteer capacities and has worked with small and large organizations in many industries including finance, manufacturing, healthcare and insurance.
• Effective in managing multiple projects simultaneously, troubleshooting, finding solutions to the most challenging technical problems and meeting the deadlines.
• Programming experience in SQL, PL/SQL, shell script and automation projects.
• Experienced with planning, implementing and tuning both OLTP and DSS systems.
• Self starter, convincing communicator, leadership, mentoring and motivational skills; Lead team of 8 to 12 DBA’s to provide development and 24x7 mission critical production support.
• Proven ability to work in high pressure environment. Have excellent analytical abilities, strong work ethic and has consistently demonstrated strong teamwork and the ability to make a long-term commitment to projects.

TECHNICAL SKILLS

O/S: IBM AIX, HP-UX, Sun Solaris, Linux, Windows NT and Windows 2000/2003

Hardware: IBM p590/p595/p690, HP-UX 9000, Solaris E15K/E10K

Software: Oracle DB server Version 11g, 10g, 9i, 8i, 8.0, 7.3 and Oracle 10g and 11g OEM Grid

Programming: PL/SQL, UNIX shell scripting, C and C++, HTML, XML.

Utilities/Tools: SQL Plus, Server Manager, SQL Loader, Import/ Export, Oracle Data pump, Job Scheduler, SQL*Net, OEM, DBCA, DBUA, Oracle RMAN, Oracle Gateway for heterogeneous database connectivity, TOAD, SQL Navigator, Oracle High availability solutions, Disaster recovery.

Data-modeling Tools: ERwin, ERStudio

PROFESSIONAL EXPERIENCE

Confidential, NY

DBA Lead/Database Architect

Responsibilities:

• Work as a Hands on DBA Lead of FISA to manage 8 DBAs team to build Database infrastructure from scratch. Learn and understand the New York City Financial Business requirement, design and implementation strategy to build Oracle database Environment
• Technically work as a Primary DBA resource to supervise team member to process the user request and resolve all kinds of technical issues.
• Implemented and supported Oracle 11g RAC 2 nodes with ASM. Install, Configure, and Create RAC CRS and Database Instances.
• Implemented a standby database operation using Oracle Data Guard for data loss and also provides graceful switchover and switchback between sites for a planned OS and hardware maintenance.
• Designed and implemented oracle streams process between OLTP and DSS system for real time replication on 9i and 10g database. Resolved all kind of streams issue.
• Designed and successfully implemented backup and recovery strategy using RMAN, Netbackup and BCV. Created the backup policy based on the business requirement.
• Recover the production database to point-in-time using RMAN, BCV due to Application error and User error in the very time intensive situation.
• Designed, setup and implemented creation of clone database from Production instance everyday during nightly cycle for reporting purposes.
• Communicated with Development team to understand the data model, optimize the data model and designed and implemented database logical layer and physical layer based on data model.
• Build DEV, INTEGRITION TEST, USER ACCEPTED TEST, PRODUCTION READINESS and PRODUCTION ENV on oracle 11g, 10g and 9i on IBM AIX 5, 6 systems.
• Worked with Change management team to migrate the code from DEV to Production.
• Participated building ETL process by using Oracle transparent Gateway, PL/SQL.
• Tuning oracle database on Database level and SQL level. Hands on skills onthe oracle tuning and managing tools, such as oracle standalone OEM and Grid control, oracle statspak, ASH and AWR report, explain plan, tkprof and so on.
• Trouble shooting all kind of issues, especially resolve mission critical issues. such as oracle internal error, ETL issue, system issue, scripting issue and so on.
• Monitor Oracle DBMS server performance using Precise I3 and OEM Grid control.
• Worked with Unix team to setup oracle file system with Meta Disk and Hyper Disk on SAN/EMC symmetric disk frame.
• Implemented Shell script to automate the various process such as monitoring oracle database availability, monitor oracle streams availability and health check, monitoring tablespace usage, shutdown and startup all oracle instance.
• Setup DBA job scheduling using CA scheduler
• Work closely with FISA disaster recovery team and perform the disaster recovery in IBM standby site on quarterly bassis
• Lead the Oracle Upgrade project and upgraded oracle from 9i to 10g, from 10g to 11g.
• Paricipated the IBM Single Sign On(SSO) project from DBA perspective using DB2UDB database. Changed the DB2UDB database from circular logging to archive logging, create backup and recovery procedure using Netbackup and DB2UDB backup and recovery utility.
• Setup the monitoring process using BMC patrol to monitor the DB2UDB instance, tablespace usage and other activities.
• Managing 24*7 on-call production support rotation.

Confidential, PA

Senior Database administrator

Responsibilities:

• Confidential is Data Provider Company for pharmaceutical company such as Merck, Pfizer and Johnson&Johnson etc. The main business of it is to purchase the data from pharmacy, process the data inside their Data warehouse database, then sale the information to large pharmaceutical companies.
• Worked as a Senior Oracle DBA to support multiple very large Oracle Data warehouse database in Confidential . The Database size range from several Terabytes to 100 terabytes and the databases contain up to 20,000 database files.
• Used various oracle technology to handle very large database in this environment, which include partitioning and indexing(table partitioning, local index partitioning, global index partitioning etc), parallel processing, materialized view, star schema etc.
• Worked effectively with development team to understand their request, build new database environment or build new schema in the existent database environment to help them to development the application effectively. Write the shell script to build the environment automatically due to the specialty of this environment, for example, 100 tablespaces may be created in one shot, so automation is very important in this environment.
• Worked effectively with Data modeler team to understand the data model and amend the data model, perform logical design and physical design, and then build the environment based on the design.
• Lead the oracle upgrade project. Upgrade oracle 9i database to oracle 10g database by using both Scripts and DBUA.
• Setup oracle 10g OEM grid control to manage, monitor and tune all the databases located in different server.
• Setup the backup and recovery procedure using Rman and Veritas NetBackup. Implemented automated backup and recovery procedure by shell script.
• Perform the incomplete recovery in recovery server using Rman recovery catalog for programmatic error to get original data back, using export and import to transfer the data from recovery server to production server.

Confidential, Long Island, NY

Senior Database Administrator

Responsibilities:

• Setup oracle database environment on multiple platforms for clients such as IBM, HSBC, SunTrust, Sallie Mae, Allstate etc.
• Setup oracle environment which include High availability environment on multiple platforms for numerous CA internal project.
• Supported on both production environment and development environment. Support production environment by trouble shooting, monitoring and tuning. Support development environment by data modeling, schema design, implement application from Dev/UAT to production, tuning SQL, setup performance bench mark, logical and physical design database
• Install, configure and manage oracle10g RAC and 9i RAC system on both OCFS and ASM on Unix and Windows Platform. Configure RAC balancing, fail over on both client and server side. Configure RAC service. Setup backup and recovery strategy in RAC environment with Rman.
• Created Oracle physical and logical standby database by data guard in oracle 10g and 9i.
• Monitored and Tuned performance of database server and application by various oracle technique, such as 10g AWR report, 9i statspack, oracle 10g and 9i OEM, statistics and event,, utlbstat and utlestat, oracle trace, Explain table and tkprof, system views (v$sqlarea, v$sqlplan etc).
• Designed and Implemented the backup and recovery procedure, perform backup(Hot backup and cold backup) and Recovery(complete, incomplete) using Rman and BrightStor(ARCserve). Using Rman and BrightStor(ARCserve) to create standby database and auxiliary database
• Design and Implemented oracle OLTP database, improve performance by configure db block size, code sharing, bind variable and cursor sharing etc.
• Designed and implemented the Data warehouse database. Configure the data warehouse database using various Data warehouse technique such as partitioning(range, hash, list, range-list, range-hash), indexing(bitmap index, b-tree index), index-organized table, materialized view, parallel processing, star schema etc.
• Updated Oracle database with oracle patching(Opatch) and migrated oracle database from 8i to 9i, 8i and 9i to 10g, 11g
• Database replication by Oracle stream.
• Ensure Oracle security using user, role, privilege, profile and VPD.
• Ensure Oracle integrity using constraint and trigger.
• Configured both Dedicated and Shared Server
• Created PL/SQL(package, procedure, function and trigger) and SQL, Pro*C, shell script
• Installed, configured Oracle database on different platforms including Windows, UNIX (Solaris, Aix and HP), Linux etc. Create Oracle database by DBCA and Script.
• Used gateway product to perform the connection between different RDBMS system.
• Performed DBA job on SQL Server 2000, 7.0, and 6.5 database using Enterprise Manager and ODBC data source.
• Performed DBA job on DB2UDB 8.2, 8.1 and 7.2 database using Control Center
• Performed DBA job on Sybase 11.x and 12.5
• Set up apache web server on Unix, Linux and windows environment, setup IIS on windows2000, windowsXP and windows2003. Configure CGI program and Shared library with Internet commerce enable server to communicated with oracle database.
• Strong team worker, suitable to different group.