Senior Database Engineer Sample Resume Format in Word Free Download

640Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Summary

She has more than 10 years of experience in IT, specializing in Oracle database administration, production support and database design. She has excellent skills in database support (oracle 8i, 9i, 10g and sql server 2005), complex SQL queries and PL/SQL development, performance tuning, database installations and upgrades. Strong communication, interpersonal skills and solid system analysis support experience would make her a welcome addition to your team. She is also a ‘quick learner’ and able to perform well under pressure.

She is authorized to work in USA for any employer.

Education & Training Courses

·         2009: Oracle Application Server 10g R2: Administration I

·         2005: Oracle 10g New Features for administrator – from Oracle

·         2005: ITIL (the IT Infrastructure Library) training - from British government

·         2002: Oracle8i Certified DBA – from Oracle

·         2000: Master of Information Technology from Swinburne University of Technology, Australia

·         1997: Oracle 7 - from ORACLE University

·         1996: Bachelor of Computer Communication from Nanjing University of Telecom, China

 

Technical Skill Summary

Operating System:       Sun Solaris, MS-WINDOWS & NT and Red Hat Linux

Language:                   PL/SQL, SQL, JAVA, Oracle Developer 2000 & 6i, Unix Shell Script, HTML, DHTML, JAVA Script, ASP, XML, PROC

Databases:                   RDBMS, specializing in Oracle 7 & 8i, 9i, 10g, Sql server 2005

Software:                     Toad, ORACLE Enterprise Manager, Sql server Enterprise Manager, Microsoft Office suite and Oracle Browser, PVCS

 

 

Employment History

Commonwealth of Massachusetts, Boston MA                         August 2008 – June 2010

DBA - ORACLE 10g

Roles & Responsibilities:

·         Install and configure new databases based on best practices

·         Design, test, and implement database backups; restore database from RMAN backups

·         Monitor production database performance, trouble shooting performance bottleneck and ensure their availability, security, and operational efficiency

·         Perform day to day database administration on existing databases including applying patches and upgrades when needed

·         Refresh TEST, DEVELOPMENT environment for developers

·         Design, configure and maintain Oracle Dataguard (physical standby database) for DR

·         Support Oracle Fusion Middleware components, including oracle application server (reports, forms) and infrastrature server

·         Documentation of standard operating policies and procedures for system maintenance

·         SQL tune up for developers

·         Manage and audit user access to databases and ensure database security

·         Participate as a member of the engineering teams for database related tasks

Achievements: Successfully design, test and implement RMAN backup and effectively recover full database from media disaster. Design, configure and support database dataguard for system DR solutions. Efficiently provide live support of production database performance diagnoses and tuning suggestions.

Technical snapshot: Sun Solaris, ORACLE 10g, RMAN, AWR REPORT, DATAGUARD, PL/SQL, TOAD, SQL LOADER, Unix Shell Script, Oracle Fusion Middleware components, including oracle application server (reports, forms) and infrastrature server, MS-WINDOWS & NT

Nielsen, Milpitas CA                                         December 2006 – May 2008

Senior Database Engineer - Production support ORACLE 10g, SQL SERVER 2005

Nielsen Online, a service of the Nielsen Company, delivers comprehensive, independent measurement and analysis of online audiences, advertising, video, consumer-generated media.

Roles & Responsibilities:

·         Communicated with both business users and technology staff in order to implement business solutions across a range of database/application areas

·         Monitored and optimized performance using index tuning, Set user privileges within the database environment

·         Troubleshooted database upgrade(8i to 10g) issues, performance issues and any data queries

·         Implemented application solutions, including PL/SQL coding(stored procedures and triggers), UNIX shell scripting and detailed descriptions for programmers, system and user documentation and training

·         Set up ORACLE testing environment for other developers

·         Monitored and scheduled jobs on ORACLE database(10G), MS SQL Server (2005)

·         Proactively automated checks and balances in database maintenance routine

·         Application DBA for a new online advertising intelligence system.

·         Designed and created new databases.

·         Drove database capacity planning and provisioning exercises for Oracle/SQL Server databases

Achievements: Successfully troubleshoots and supports database upgrade from oracle 8i to 10g. Capable of being comfortable workings in a fast paced organization with demanding international customer service and operations requirements and excellently contribute her strong database experience and knowledge to diverse database technology needs (ORACLE & SQL SERVER).

Technical snapshot: Sun Solaris, ORACLE 8I and 10g, PL/SQL, SQL NAVIGATOR, SQL LOADER,  SQL Server Enterprise Manager, MS-WINDOWS & NT, Unix Shell Script

 

Origin Energy, Melbourne Australia                                        February 2004 – July 2006

Oracle DBA

Origin Energy is Australia second largest electricity and gas retailer

24*7 Production DBA support, part of a team for Orgin Metering Production and Development Database Support

Roles & Responsibilities:

·         Monitored database system capacities to maintain service levels.

·         Performed export and import for logical backup and loading.

·         Built up testing environment for project development team

·         Performance tuning of SQL and PL/SQL for various projects

·         Programming in PL SQL, SQL script and Unix Shell Script.

·         Database upgrade, installation

·         Worked with application developers to provide advice on database design and performance issues.

·         Implementation of database changes through a formal change control process (ITIL).

·         Processed and responded to third-level help desk calls and IT Work Requests directed to the team member.

·         Maintained up-to-date documentation for all technical changes.

Achievements: Successfully upgrade and supported metering database of oracle 8i, 9i and 10g. Strong DBA and PL/SQL skills combination solidly improved work efficiency and accuracy.

Technical snapshot: Sun Solaris, MS-WINDOWS & NT, ORACLE 8I, 9I and 10g, PL/SQL, SQL LOADER, ORACLE Enterprise Manager, SQL Server, interface between Oracle and SQL Server, Unix Shell Script, PRO*C

Microlistics, Melbourne Australia                                             May 2003 – February 2004       

Oracle DBA / Application Developer

Worked as a technical consultant for a few warehouse projects, including Nestle

Roles & Responsibilities:

·         Production oracle 8i Database Administration on Solaris

·         Database Design and Creation   

·         Developed scripts for analysing tables and indexes

·         Backup and recovery database using RMAN

·         Scheduling batch jobs on daily, weekly and monthly basis

·         Production support and customer support by shift work

·         Database performance tuning based on statistics gathered by scripts

·         System analysis and testing, assisted and corporate other developers on project implementation

Achievements: Successful application design and DBA support of multiple national warehouse systems in a mission critical, 24x7 environment. Successful customer support and production database support

Technical snapshot: Solaris 8, oracle 8i, PL/SQL, SQL LOADER, MS-WINDOWS & NT, Management reporting, Technical Support,

Deloitte Consulting                                                                  December 2001 – April 2003    

Application DBA / Developer

Project (Broadband Billing System): Telstra (The biggest telecom company in Australia), Melbourne

Roles & Responsibilities:

·         Database and Application performance tuning

·         Database Design and Creation, tables, indexes, and synonyms. 

·         ETL- Extracting, transferring, and loading data by development of PL/SQL, SQL script and Unix Shell Script

·         Test strategy – unit testing, integration and system testing.

·         Analysed database objects and statistics gathering

·         Business requirement documentation, capacity planning

·         Data warehouse system analysis

·         Upgrade database from oracle7 to 8i

Achievements: Successful Design, development and support of internal and production database systems – Telstra Broadband Billing System

Successful design, development and implementation of Oracle stored procedures, triggers and Views, shell scripts.

Tuning application performance using oracle 9i objects and efficiently reduced monthly processing time from 5 days to 4 minutes.

Technical snapshot: oracle 8i & 9i, SQL LOADER, PL/SQL, Solaris, ORACLE Enterprise Manager , MS-WINDOWS & NT, Management reporting, ETL, technical support

BHL Systems P/L, Melbourne Australia                       Feruary 2000 – October 2001   

Oracle DBA / Developer

She worked in Keystone team that responsible for providing technical Services to 8 large Legal firms, including Minter Ellison, Blake Dawson Waldron, Arnold Bloch Liebler, Wisewoulds lawyers. Keystone is a large Legal Practice Management System running on Oracle. Her responsibility includes analysis of system, coding of back end PL/SQL and front end program in Developer 2000 & 6i, database setup, administration and performance tuning. She have also developed a web site for the company using 

L, Java servlet, JDBC and Oracle.

DBA 

·         Installed, upgraded, backed up, recovered database on Red Hat Linux

·         Tuned database performance

·         Scheduled database jobs

·         Planed Capacity

·         Configured SQL Net and NET 8i

·         Administered database using Enterprise Manager, SQL*Plus and Toad

·         Database Planning and Documentation

·         Unix shell Scripting

 

Oracle Developer, support

·         Database Design and Creation

·         Application Design and Technical specification

·         Wrote PL/SQL, SQL scripts and Unix shell script

·         Front-end development using Oracle Form, Report

·         Tuned Application Performance

Web Developer

·         Intranet and Internet Development using HTML, DHTML, Java, JDBC, ODBC and Oracle, Java script

Achievements: Successful Design, maintenance oracle database (7 & 8i).

Successfully migrated databases from oracle 7 to oracle 8i.

Successfully designed, developed and supported legal practice financial management system (keystone) using oracle developer 2000(report, form and discover) and Toad.

Successful designed, developed and implemented of a number of oracle stored procedures, triggers and Views.

Successful design, development and implementation of website using java servlet, JDBC and oracle.

Technical snapshot: Oracle (Ver7 & 8i) on Windows NT, Red Hat Linux and Sun Solaris Platform, ORACLE Enterprise Manager, Ms Access, ODBC, Toad, PL-SQL, Access, Excel, Technical Support, User Support and Data Processing, JDBC, HTML, ER modelling, Java script, Java, developer 2000 & 6I

 

 

 

Swinburne University of Technology, Australia                       February 1999 – June 2000

Full time student

Hansen Corporation, Melbourne Australia                               May 1998 - December 1998     

Oracle Developer/Junior DBA

From beginning she was working as a team member responsible for the maintenance and enhancement of ELSIS system. This system is an electricity billing system that is used in Boral Energy, City Power, AGL, and Powercor and is being extended to gas billing. It is a large complex RDBMS database system running on Oracle, which involves in PL/SQL, Developer 2000(Form 4.5 and Report 2.5), and Oracle 7. The team comprises five people. Her responsibilities are to assist senior DBA to administer database and oracle reports development using pl/sql, sqlplus, developer 2000, and crystal report:

DBA Assistant of Oracle Database (Ver7) on Unix

·         Created, built database schema objects (indexes and tables, etc.)

·         Tuned up performance

·         Installed, and upgraded oracle products

·         Created database store procedure and database trigger

·         Maintained database backup scripts

           

Application Developer

·         Wrote PL/SQL, SQL script and Unix Shell Script

Development using Oracle Form, Oracle Report, Visual Basic and Crystal Report,          MS Access development

Achievements: Successful development for management reporting using oracle developer 2000 report and crystal reports.

Successful integration of PL/SQL skills and oracle DBA skills I got from the experience.

Deeply understanding software development life cycle methodology.

Successfully anticipated database design and implementation, including system structure implementation.

Technical snapshot: Oracle (Ver7) on Windows NT, Red Hat Linux and Sun Solaris Platform, ODBC, Toad, PL/SQL, Oracle data access objects, Access, Excel, Technical Support, Computer Programming, User Support and Data Processing, developer 2000, crystal report, VB 6

 

Sony Corporation, Beijing China                                                         July 1996- May 1998    

Junior Analyst Programmer

In this position she was able to gain an understanding of database operations and was responsible for ongoing maintenance, reporting and support.

Achievements: Successful integration of skills obtained from university into a business environment.

Technical snapshot: Oracle (Ver7) on Windows NT, Sun Solaris Platform, PL/SQL, Excel, Technical Support, Computer Programming, User Support and Data Processing, developer 2000

 

Other Languages

Mandarin: Fully Fluent

References available on request

Download Resume Format