Senior Oracle Database Administrator Sample Resume Format in Word Free Download

Sample 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

 

Stella  Sreedharan

(Email :stella@yahoo.com)  cell ph :732-692-9876 ,Home: (732)-305-1230

 

Senior Oracle Database Administrator

Summary :

Ø  Over 17 years experience in Oracle Database Administration, Oracle Manufacturing and Oracle development. He also has experience in helping corporations establish appropriate and innovative technical architectures and extend existing environment, operations and infrastructures.

Ø  Extensive experience working as a  Production Database Administrator in Oracle 11g,10.X,9.x,8.x,7.x .

Ø  Installed 11g  binaries.Grid infrastructure  and created RAC databases on multiple nodes.

Ø  Configured EM for  monitoring oracle 11g  RAC databases.

Ø  As a  senior Implementation/administration architect in the Oracle Application framework and data servers.

Ø  Supported  remedy software implementation  and following ITIL .

Ø  Followed ITIL standards in installing and resolving issues using incident management of  BMC remedy software.

Ø  Has deep insight and knowledge of contemporary business models across diverse industries and processes. His strongest attribute is his ability to envision and establish creative yet practical solutions, which support, extend and complement the operations and core competencies of existing organizations.

Ø  Diverse work experience on Oracle (7.x through 11g), in the areas of Analysis, Design, Database Modeling, Development, Testing, Performance Tuning and Production support.

Ø  Extremely strong UNIX skills. Very strong in shell scripting, sed, awk/nawk and Perl. Administrative expertise on most of the high-end Unix platforms like Solaris, HP-UX, AIX, UNIX and Linux. Strong experience as DBA and System Administrator on all of the above platforms.  Also possess extensive and varied experience on Windows NT/2000 server platforms.

Ø  Extensive experience working as Oracle developer developing applications , stored procedures, triggers, shell scripting, C++ programming.

Ø  Excellent experience in the Software Development Life Cycle.

Ø  Extensive experience working in Oracle  RAC 11g under linux environment and installing Oracle 11g  client.

Ø  Implemented and worked on data guard  on 10g,9.x,8i databases.

Ø  Has over 15 years experience in assisting organizations with the development, implementation and management of various business and IT strategies.

Ø  Excellent communication and interpersonal skills.

SKILLS:

LANGUAGES:               PL/SQL

GUI:                             Oracle Forms, Oracle Reports

RDBMS:                       Oracle 6.0/7.x/8.x, 9.X,10.X,11g

Storage & Backup: Netapps 6400 filer, EMC Clariion, IBM TSM 5 and Veritas Netbackup 6.0                                                          

OPERATING SYSTEMS: Sun Solaris 2.5/2.6, HP 9000, DEC Unix,  IBM Unix,Linux, Windows NT 4.0, Win 2000, Win 98/95,2000,2003 ,

WEB SERVER:             Apache server

APPLICATION SERVERS & Tools:Oracle Application Server 11I, 10.7(NCA), 11.03,Forms, server, Appworks, Tick Mark, EDM (EMC), OEM, Quest, BMC,VERITAS CLUSTER SERVER,EM 4.0,Qapache,Qcm,EMS 2.01  

 

Professional Experience

Forest Laboratories ,20th Floor

Harborside Financial Center

Plaza V

Jersey City , New Jersey 07311

                                                                      Nov ’03 – Till –date

Oracle Database Administrator

PROJECT DESCRIPTION

• Complete operations support for Forest Lab which involved fixing the issues of database related issues, application issues and monitoring all types of database and new oracle tools
• Installation of  oracle 11g  RAC binaries on multi nodes  with Grid infrastructure
• Creation of RAC databases with failover  infrastructure.
• Creation  and maintenance of dataguard databases (10g,9i,8i)
• Supported SAP,Siperian databases for Sales and Marketing and Financial  department.
• Database Administration of clintrial and clintrace databases.
• Supported EMC SAN migration for all production databases.
• Involved in disaster recovery testing for Clinical databases, EDC production databases.
• Setup Network management for rman backup and schedule Legato backup for newly build databases.
• Created rman script and schedule backup and test the recovery test using Legato client.
• Supporting all Oracle Inform databases for electronic data captures(EDC).
• Administration of users using phase forward software for clintrace database.
• Involved in testing the data guard failover testing for clintrial/clintrace system.
• Support of Inform central coding,crf submit applications.
• Monitor the backup of databases and scripting for improvements in the backup procedure
• Support developers for web related and Oracle database issues.
• Design for the support of frx.com project enhancement.
• Support for the upgrade testing of oracle 10g,11g databases.
• Implemented Mercury software for FRI and all users to perform stress test on NT servers.
• Support and monitoring  databases using  BMC –Patrol Monitoring tool.
• Support and monitoring RAC databases using  Oracle EM web.

Oracle Corporation, New York                                                               Sep 2002- Oct 2003

Oracle Database Administrator

PROJECT DESCRIPTION         

• Database administration and Implementation of Oracle Database 9i(9.2.0.1), 10g and oracle Application(11i) .
• Complete operations support for internal oracle which involved fixing bugs and monitoring all types of database and new oracle tools.
• Support and upgrade new tools like Qapache,Qcm for Oracle applications 11i.
• Support as a DBA for internal oracle developers to investigate issues from clients.
• Involved in development of EMS(Environment management services 2.01) for managing oracle database.
• Projected as first line contact for any bugs for coming new version of EM 4.0  to internal product family users
• Solving bugs for Oracle Applications issues for 11i,forms server,Report server, app top converter and  other oracle tools
• Implemented RAC setup and used RMAN to take backup of 9I databases.
• Performed Learning sessions for EM and other tools to internal team of Oracle Corporation.
• Involved and tested the new up coming 10g version of oracle
• Database Administration of all central databases and monitor the backup & Recovery using RMAN,EMS
• On-call weekend support in every 11 weeks to support oracle internal customer.

ENIRONMENT: SUN SOLARIS 2.6, NT Oracle 8.0.5, 8i (8.1.6),9I,  PL/SQL,  OEM, Quest Tools, Veritas Cluster server, EMC,ERWIN,DB ARTISAN, shell scripts, RMAN,  pl/sql,  OEM, RMAN backup,Dataguard .

      

J.P. MORGAN CHASE BROWN & CO

Boston ,MA                                                                                                    Dec 2001 – Sep 2002

Oracle Database Administrator

PROJECT DESCRIPTION         

• Implementation of Oracle Database 8i(8.1.6)
• Implementation OPEN FINANCIAL EXCHANGE Database.
• Database administration of Production databases.
• Building development, user acceptance test ,Production databases.
• Scripting for Data load from Tandem to UNIX server .
• Conversion from 8.0.5 to 8I.
• Creating Unix and shell scripts for monitoring the Databases.
• Setting up the cron job to monitor the Databases.
• Strong Experience in writing PL/SQL.,SQL, procedures, functions.
• Veritas high availability clustering for oracle databases 8i.
• Scripting the veritas cluster server for open financial exchange.
• Tuning the Oracle Database for better performance.

·        Managing Rollback segments. Controlling and monitoring user access to the data.

• Installation, Upgrade, Backup & Recovery of Oracle Databases.
• Calculating Semaphores, memory for the databases
• Adding and modifying the parameters for Better performance.
• Managing the online Redo log. Managing control files, schema objects, view sequences and synonyms.

ENIRONMENT: SUN SOLARIS 2.6, NT Oracle 8.0.5, 8i (8.1.6),9I,  PL/SQL,  OEM, Quest Tools, Veritas Cluster server, EMC,ERWIN,DB ARTISAN, shell scripts, RMAN,  pl/sql,  OEM

Inteliant Corporation                                                                                                    

Cablevision, Long Island, NY                                                                                   May  1999 – Nov 2001

Senior Oracle Database  Administrator

• Implementation of Oracle Applications 11I (11.5.3.13), 8i(8.1.6)
• Implementation of Forms server, Apache server.
• Implementation Self Service Web Expense.
• Refreshing from Production databases and Application top to development databases and setting up the environment for Oracle Applications.
• Migration from 10.7nca to 11i.
• Database Administration of oracle production  databases.
• Applying patches to the Oracle Applications 11.i.
• Conversion from 8.0.5 to 8I
• System Administration of Oracle Applications 11 i.
• Creating Unix and shell scripts for monitoring the Databases.

• Database Administration of Oracle Applications, Form server, web server.
• System Administration of Oracle Applications. This includes creating users, Registering printers, Monitoring concurrent Managers..
• Published Technical Documentation and User Procedures for access to all instances
• Setup reports and functions/forms in a heavily customized implementation
• Worked with Veritas high availibility clustering for Oracle Databases.
• Backup and Recovery, Reorganization to support development and production environments and developed scripts to automate the backup, maintain the databases.
• Performed the Disaster recovery activities for the critical databases
• Database support activities which includes Customer requirements, Project planning, Time-requirement, Database migration for the complete project and work as a team.
• On-call support 24X7 for critical databases.
• Worked with EMC BCV & SRDF and EDM Backup.
• Involved and done complete setup of Oracle Financials including GL, AP, AR, FA.,PO
• Developed, published and implemented development procedures and coding standards using PVCS.
• Implemented Supplier.cablevision.com for the suppliers with SSL.
• Implemented Reporting Server. Implemented the Oracle Applications and involved in setting up the environment.
• Primary DBA for 15 databases. Refreshing from Production databases and Application top to development databases and setting up the environment for Oracle Applications.
• Sql server database administration, Query  Analyzer .
• Shell scripting in unix and programming in c++ for database administration.
• Database backup using RMAN.
• Applying patches to the Oracle Applications using the tool adpatch.
• Creating scripts for monitoring the Databases. Setting up the cron job to monitor the Databases.
• Tuning the Oracle Database for better performance. Involvement with users and able to meet the deadlines.
• Database Administration of oracle Application 10.7(CUI) for Madison Square Garden & WIZ
• Database Administration of MDSI (Field Service Automation).

ENVIRONMENT: HP 9000 ver 10.20 & 11.00,SUN SOLARIS 2.5,IBM RS6000, Oracle ver 7.x to 8.0.5, 8.1.6, unix shell scripts,c++,Oracle Applications 11i(11.5.2), 10.7(NCA), 10.7(CB), EMC.

Applied Materials,

San Jose , CA                                                                                                May 1998 – Apr 1999

Oracle Database and Application Administrator

• Database Administration of Oracle Applications 10.7 SC and R11.02 (NCA), Oracle 8.0.5/7.3/8.05
• Primary Database Administrator for 30 production databases of 40GB to 160GB sizes.

§  Monitoring and Maintaining the production databases and responsible for databases up and running for 24hrs and 7 days a week.

§  Executed Disaster recovery for production database to remote locations.

§  On-call support 24hrs for a week in a month. Supporting 60  production databases on On-call.

• Primary Database Administrator for 30 production databases of 40GB to 160GB sizes.
• Monitoring and Maintaining the production databases and responsible for databases up and running for 24hrs and 7 days a week.
• On-call support 24hrs for a week in a month. Supporting 60 production databases on On-call.
• Database Administration of Oracle Applications version R11.03.
• System Administration of Oracle Applications. This includes creating users, Registering printers, Monitoring concurrent Managers.
• Applying patches for Oracle Applications through AD patch or Chain link utility
• Refreshing Databases from Production database to development databases.
• Backup and Recovery of production databases and tuning production databases for better performance.
• Migration of databases from 7.x to 8.0.5
• Setting up Online Backup through Omni-backup of HP Server.
• Creating new Databases according to the project plan.
• Monitoring oracle Application listeners through Oracle Web server.
• Setting up Cronjobs for Monitoring Tablespace and setting up daily logical backup of databases.

ENVIRONMENT: HP 9000 ver 10.20 & 11.00, SUN SOLARIS 2.5,Oracle ver 7.x to 8.0.5,OPS Oracle Applications R11.02

BPL-US-West Cellular                                                                                      Aug ’96 to Apr ’98

Database Administrator

·        Database Administration of the production database of 80 GB size. Installing and upgrading the Oracle 7.x server and application tools.

·        Allocating system storage and planning future storage requirements for the production database system.

·        Enrolling users and maintaining system security. Auditing the database objects and system privileges. Managing user privileges and roles.

·        Database Backup and Recovery using HotBackup (tablespace) and logical backup (export).

·        Creating primary database storage structures (tablespace) after application developers have designed an application. Modifying the database structure as required.

·        Tuning the Oracle database for better performance. Altering the database parameters.

·        Monitoring and optimizing the performance of the database. Monitoring sessions, users for the database using Server Manager, SQL DBA and Explain Plan.

·        Managing Rollback segments. Controlling and monitoring user access to the data.

·        Managing System Global Area.  Shell Scripting for Startup, Shutdown and Backup.

·        Managing the online Redo log. Managing control files, schema objects, view sequences and synonyms.

 ENVIRONMENT: DEC Alpha Server 2100, DEC UNIX, Oracle 7.3/7.2, Gupta SQL

Kothari & Sons                                                                                                          May ’93 to Aug ‘96

Oracle Database Administrator

• Database Administration of Oracle databases size from 30GB to 60 GB with 100+ concurrent users.
• Installing and upgrading the Oracle 7.x server.
• Allocating system storage and planning future storage requirements for the production databases.
• Tuning the Oracle database for better performance. Altering the database parameters.
• Managing System Global Area. Managing multiple rollback segments for the parallel servers.
• Enrolling users and maintaining system security.
• Modifying the database structure, as necessary, from information given by application developers.
• Creating primary database storage structures (tablespace) after application developers have designed an application.
• Managing the online Redo log. Managing control files, schema objects, view sequences and synonyms.
• Database Backup and Recovery using Hot Backup (tablespace) and logical backup (export).
• Archiving files from the file system to the DAT using tar utility.
• Monitoring and optimizing the performance of the database. Monitoring session’s users for the database using Server Manager, SQL DBA and EXPLAIN PLAN.

ENVIRONMENT: SCO UNIX, Oracle 7.2/7.1

Kothari & Sons                                                                                                          Nov ’91 to Apr ’93

Devolopment Experience

i)Financial Accounting Package

This package helps the Accounts dept. to perform the various operation like Bills Payable, Bills Receivable, Trial Balance, General Ledger, Reports on Profit & Loss A/c, Trial Balance, General Ledger, Outstanding Reports for their Auditing purpose and day-to-day operations.

ii) Quality Analysis Package

This package gives information about various types of cotton and its details and the demand in market, selling price and buying price in market and some suggestions of existing varieties and new varieties of cotton and different ways of testing cottons.

.

ENVIRONMENT: Windows 3.1, Oracle 6.0, Forms 3.0, Reports 1.0.

EDUCATION

BACHELOR’S DEGREE IN   SCIENCE

DIPLOMA IN RDBMS

POST GRADUATE DIPLOMA IN SYSTEMS MANAGEMENT

ITIL v3 certified

Download Resume Format