Dba Resume
4.00/5 (Submit Your Rating)
Sunnyvale, CA
TECHNICAL SKILLS
DATABASES: Oracle 9i/10g/11g, Oracle Streams, ASM, GoldenGate, RMAN, Microsoft SQL SERVER 2005/2008, hivesql, MySQL
LANGUAGES: SQL, PL/SQL, Korn shell, HTML, JAVA, C, DCL
PLATFORMS: Sun/Solaris, HP9000/UX, IBM PC, R6000/AIX
OPERATING SYSTEMS: UNIX, Linux, Linux HA, OCFS2, Microsof Windows.
SOFTWARE TOOLS: TOAD, Embarcadero DBArtisian, E/R Studio,AWR, ASM
PROFESSIONAL EXPERIENCE
Confidential, Sunnyvale, CA
DBA
Responsibilities:
- Automated the ORACLE database administration to maintain the stable and reliable of the servers and to maximize the use of the server (keeping the database online 99% of the working time).
- Wrote Korn shell and SQL scripts to automate the monitor for 40 databases Oracle server on Linux, LinuxHA, ASM, such as: database monitor, backup, restore, analyze, disk space information, table space monitor and information, generate duplicate database, grant, revoke, email alert, CPU monitor, rebuild index, RMAN tracking, Maintenace and support nearly realtime production VoiceToText mobile device database .
Confidential, San Leandro, CA
Database Developer Engineer
Responsibilities:
- Perform Oracle 9i,10G,11G Data Base Administrator on HP/UX, Sun/Solaris, Linux, and Windows, automate weekly full backup, daily increment backup using RMAN and Korn shell on more than 150 databases.
- Automated the Oracle database administrator to maintain the stable and reliable of the server maximize the use of the server (keeping 25 production databases online 24x7x365).
- Automated the monitor, backup, restore, analyze, disk space information, table space monitor and information, generate duplicate database, grant, revoke, email alert, CPU monitor, rebuild index, RMAN tracking on more than 150 databases.
- Perform RAC configuration, installation, convert single database to RAC, load balancing, CRS, monitor. Monthly migrate very large database from Oracle 9i to Oracle 10G (1200 GB) Perform quarterly build of 20 very large - scale Oracle Databases on HP-UX and Sun Solaris servers (1200 GB) to support manufacturing production, QA and test.
Confidential
Senior ORACLE Database Administrator / ETL Architect
Responsibilities:
- The main and only Database Administrator, the key programmer to develop shell scripts and PL/SQL, SQL scripts for DrugMatrix installation - an user friendly commercial Data Warehousing application, perform ORACLE Data Base and Unix system administration, the key technical consultant to team members and customers in solving system environments, databases and SQL problems, perform system integration and quality assurance, certified the DrugMatrix products on Oracle 8i, 9i, 10g, 11g on various UNIX platforms for releases, perform Oracle and Unix system configuration and DrugMatrix installation customer support, which at release time meant “24 hr On site / On Line / On phone” support.
Confidential, Palo Alto, CA
Database Administrator/ ETL Developer
Responsibilities:
- Perform ORACLE7 and ORACLE8 Data Base Administrator on various UNIX and Windows NT and technical consultant to team members and customers in solving databases and SQL problems.
- Develop quality test plans, test outlines, as well as creating, executing and automating test scripts, including regression testing - using html for online documentation.
- Perform system integrate, quality assurance for the SmartDB Workbench products on various UNIX and NT platforms.
- Perform SmartDB Workbench certification on ORACLE8 on the Window NT and Sun/Solaris.