Sr. Oracle DBA 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

Danna

danna.anandan@gmail.com

Oracle DBA

Summary:

·         11+ years of experience as Oracle Core DBA

·         Experienced with Data Modeling (Logical & Physical) techniques.

·         Involved in analysis, design and development of business logic using SQL & PLSQL procedures and packages and Oracle Partitioning

·         Effective skills in Backup, Restore and Recovery  strategies using RMAN and also TSPITR

·         Oracle Dataguard Installation

·         Oracle Database Installation and Data Migration and applying Patches

·         Cloning Database

·         Exposure to GRID CONTROL and Database UPGRADE

·         Optimizing SQLs using explain plan to analyze the execution plan and tune the statements.

·         Performance Tuning  for SQL through HINTS/Oracle BASELINE/SPA/Database Replay  and reframe SQL Queries

·         Designs, tests, implements, maintains, and controls the companies physical, relational, and object-oriented databases like Oracle 11g,10g,9i,8i across multiple platforms like HP UNIX, Red hat LINUX,IBM AIX, Sun Solaris, Windows with the performance tuning of the databases

·         Installation of ASM (Automatic Storage Management).

·         Vast experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by working in development area more with STATSPACK, OEM Grid Control, AWR as the main tool to tune SQL queries and dynamic performance views to monitor system statistics and wait events.

·         Creation of database, tablespaces, rollback segments and tuning the physical structure of database.

·         Creating packages, procedures, functions, queries in DDL and DML through PL/SQL

·         Defining Backup Strategy for databases and testing them periodically.

·         Configuring user creation, their roles and privileges, profiles to control access over database objects.

·         Backup and Restore (complete/incremental Hot and Cold Backups).

·         Excellent Communication and Interpersonal skills

·         On call 24X7 Production Support.  Willingness to work beyond regular hours

·         Rapidly resolve issues in order to adhere to SLA

Technical   Skills:

Operating System	Sun Solaris 8/9/10,, HP UNIX, IBM AIX 5.2/ 5.3, Red Hat LINUX, Windows 95/98/NT/XP
Databases	Oracle 11g,10g/9i / 8i /8/ 7.3
Tools	Oracle Enterprise Manager, Toad, Export, Import, Data Pump,  SQL Loader, SQL*plus, SQL Optimizer, Oracle 9i/8i IAS, Business   Objects, Oracle Discoverer, Forms, Reports, Autosys
Languages	SQL, PL/SQL, UNIX Shell Script, HTML, C, C++,
Oracle Applications	Oracle 11i E-business suite (HRMS/Financials).
Middleware Technologies	Connect Direct, Siteminder, iplanet, Kintana, IBM Websphere and Business Objects

Education:

·         Bachelors  in Computer Science & Engineering

Professional Certifications:

·         Microsoft Certified Solution Developer (MCSD)

Professional Experience:

JPMorgan Chase & Co., Wilmington, DE                                             Apr 2010 to Till date

Sr. Oracle DBA

Responsibilities

·         Responsible for administration and supporting Oracle 9i, 10g and 11g databases.

·         Provided 24x7 on call production support.

·         Involved in JPMorgan Chase commercial card application project migration from SQL Server database to Oracle 4 node RAC cluster configuration.

·         Knowledge on IBM Datastage ETL tool, hands on experience in troubleshooting and tuning the configuration for optimal database performance.

·         Involved in several database proof of concept tests which are done before the database migrations to test the scalability and performance of the databases in the new environment.

·         Extensive tuning and scalability benchmarking of various environments at the Database level for AIX, Linux and Solaris.

·         Performed failover tests for many databases before it is deployed to production to test the failover capabilities.

·         Setup Oracle 10g RAC Data warehouse. Implemented Data Guard, best practices. Tuning and scaling. Installed on Windows, Solaris , Linux and HP-UX. Database migration from AIX to RHEL using expdp/impd and Oracle streams.

·         Upgrade Databases to 11g RAC with ASM. Install and configure Clusterware on Windows, Linux, AIX, HP-UX and Solaris. Have performed fresh installs and configurations of 11g with ASM and scan listener technology.

·         Configured Goldengate for replication between Oracle Databases. Used for Reporting. Setup Architecture, installed servers, setup replication tasks.

·         Setup Goldengate in RAC environment for near zero down time strategy and for replication purpose.

·         Hands on experience on Oracle GoldenGate tool including creating multiple extracts and replicats, troubleshooting performance for high availability of replicated data.

·         Migrated databases from AIX to SOLARIS using cross platform transportable tablespaces, moved the databases from raw file system to ASM.

·         Applied patches to bring Oracle Products to latest Patchset level. Experience in RAC rolling patch upgrades.

·         Installed Redhat Linux and setup EMC SAN with powerpath. Implemented ASM using 11gr2 new features.

·         Setup Oracle Grid for over 150 databases, application servers, web-logic. Provided all monitoring and tuning.

·         Experience working with Resiliency Team. Involved in all Disaster Recover strategies for Databases including the switch over of the databases from one datacenter to other.

·         Setup RMAN solutions for all Oracle Databases -- created rman repository, wrote scripts for backup, integrated rman with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.

·         Configured High Availability with Dataguard and setup RMAN for backups.

·         Involved in most of the call center application release testing from the backend perspective tuning.

·         Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 9i over to HP Itanium boxes running Oracle 10g.

·         Installed and created 10g databases and 10g OEM

·         Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins

·         Installing and configuring Recovery Manager (RMAN) and Flash Recovery

·         Cloning databases using scripts as well as RMAN.

·         Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases. Assisted a team of DBAs in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.

·         Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.

·         Data Modeling, Database Design and Creation.

·         Data Modeling using ER-Win.

·         Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.

·         Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.

·         UNIX shell scripting in csh, ksh to be controlled from Crontab.

·         Extensive Performance Tuning, Memory (SGA) Tuning, etc.

·         Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team.  Extensive familiarity with Tuning Tools like Oracle Enterprise Manager’s (OEM’s), Oracle cost optimizer, SQL analyzer, top session, top SQL, Performance Manager, etc., Statspack, TOAD.  For SQL tuning using “Explain plan”, “TKPROF”, “SQL_TRACE”, Optimizer modes, using Optimizer hints, Gathering statistics, Statspack etc.

·         Create database maintenance plans, including updating statistics, re indexing, structure modifications, Capacity plans, and index analysis.

·         Data Modeling, Database Design and Creation.

·         Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.

Environment: Solaris 8.0/9.0/10.0, Linux Red Hat, Windows 2000/2003 Oracle 9i/10gR2,11g Oracle Enterprise Manager, Oracle Partitioning, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, Toad and SQL Navigator.

Client: United Parcel Service, Atlanta, GA                                          June 2008 – Apr 2010    

Sr. Oracle DBA

Description: United Parcel Service, Inc., commonly referred to as UPS, is the world's largest package delivery company. It’s main businesses include Shipping, Freight, Logistics and Supply Chain Management. UPS provide business solutions to many small businesses and enterprises to manage their shipments with ease.

Responsibilities:

·         Primarily responsible for production support. To keep all databases up and running in production.

·         Upgradation from Oracle10g to 11gR2.

·         Configuration of RAC Environment.

·         Configured Flash Recovery Area in Dev databases.

·         Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.

·         Extensive experience in working on Distributed Oracle Database server's 11g/10g, SQL Server and developing stored packages, procedures, functions, triggers and views

·         Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.

·         Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.

·         Taking table level backups using exp and imp. Responsible for capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lock activity.

·         Tuned the system in terms of SQL optimization, Memory tuning and application tuning.

·         Extensive experience in database design, data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.

·         Oracle Grid implementation with Oracle Application Server.

·         Tuning Query performance by creating indexes.

·         Monitoring, sizing and tuning undo segments by creating multiple undo tablespaces.

·         Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.

·         Replication of tables to cross platform and Creating Materialized Views.

·         Designing and developing packages in the database layer, stored procedures, functions and triggers.

·         Replicated Datacenter and Local database for automatic update of Objects.

·         Configured Staging area to capture the changes made to the database

·         Implemented Data guard (standby) for maximum protection.

·         Strong programming and debugging skills in PL/SQL, SQL, Dynamic SQL and UNIX shell scripting, SED editor.

·         Worked with programmers developing PHP applications for Oracle Database.

·         Communicating with UNIX Production Support group for UNIX production issues like database installations, file space issues, patch applications, database startup/shutdown automation, and other database services and file system backups.

Environment: Oracle 11g/10g, Oracle EM Grid Control, IBM Rational Clear Case and Clear quest, AWR and ADDM Analysis, SQL*Plus, ASM, PHP, SQL*Loader, PL/SQL, RMAN, Oracle Enterprise Manager, Red Hat Linux AS-4, Sun Solaris, Quest Tools (Shareplex).

Subaru of America, Cherry Hill, NJ                                                                  Jan 2007 to Jun 2008

Lead Database Administrator

As Principal Lead Database Administrator responsible for database administration and techno functional support of 11.5.9 e-business Suite. Successfully upgraded the ERP 11.5.9 to 11.5.10.2 along with Multinode split with Shared APPL_TOPs and also upgraded ERP database 9.2.0.6 to 10.2.0.2. Major challenging tasks like setup dedicated Configurator, ipayments servers for OTC (Order-to-cash) project, implementing OTM, implementing BPEL.

·         Working on OTM implementation and BPEL implementation.

·         Lead DBA for Data center migration for Oracle ERP, DB and 10g AS Servers.

·         Performed four rounds of testing with TEST and DEV for Upgrading Project from 11.5.9 to 11.5.10.2 which includes Database upgrade from 9.2.0.6 to 10.2.0.2 and Technology stacks

·         Installed Developer 6i Patch sets 18 for Upgrading forms and admin server

·         Performed a complete upgrade from 11.5.9 to 11.5.10.2 on Production without any issues.

·         Upgraded the Java Development Kit (JDK) from 1.3.1 to 1.5

·         Upgraded the Discoverer 4 EUL to 10g EUL (Application EUL)

·         configured the load balancer  BIG IP(F5) with Multiple Web servers

·         Automated the startup and shutdown scripts for the production Applications

·         Configured the Workflow Mailer and troubleshoot/fix issues

·         Configured the Multi Node architecture. And Shared APPL_TOPs

·         Configured the Configurator/ipayment servers on standalone server.

·         Performed post production support after upgrade till client system was stabilized

·         Performed cloning from single node to Multi node and from multi node to multi node several times as part of the upgrade iterations.

·         worked with oracle support (TAR’s) in post production support issues

·         Applied series of patches given by Oracle Support to resolve user specific issues, applied various patching techniques to minimize the down time.

·         Handled space related issues and applied series of patches for software related issues like ORA – 0600 and ORA-7445 and resolved many issues like Rep-0177, Rep-1416,Rep-3000  using opatch.

·         Involved in code migrations And Production Maintenance.

Environment:  Sun Solaris 5.8/5.9/5.10,RHEL4.5 Oracle RDBMS 9i (9.0.2)/10G(10.2.0.2), 9iAS & 10gAS, Oracle ERP: E-business Suite 11i (11.5.10.2), CZ,AR,AP, JDeveloper 9i, Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM),Oracle Transportation Management (OTM), Business Process Execution Language(BPEL).

Applied Materials, Santa Clara, CA.                                                                Feb 2005 to Nov 2006

Application Database Administrator

·         Worked in the Upgrading Project from 11.5.2 to 11.5.10.2.

·         upgraded their database from 8.1.7.4 to 9.2.0.7

·         upgraded their HTTP server to 8.1.74 and jinitiator VER 1.1.8.16 to 1.3.1.26

·         configured the forms and load balancing server

·         configured the Web server.

·         Integrated the 10g Application Server with 11i EBS 

·         Applied series of patches given by Oracle Support to resolve user specific issues

·         done security patches for April 06 CPU.

·         Design and developed shell scripts to Monitor the Database

·         Performance tuning of database

·         worked with oracle TAR’s in post production support issues

·         worked closely with the business users to monitor the performance of the system

·         Installed discoverer software on various client spaces

·         Configured TNSNAMES, SQLNET and resolved the connectivity issues with developers.

·         handled space related issues and applied series of patches for software related issues like ORA – 0600 and ORA-7445

·         Involved in code migrations And Production Maintenance.

Environment: IBM Version 4.3/5L, Oracle RDBMS 9i (9.0.2) & 9iAS, Oracle ERP: E-business Suite 11i (11.5.9), Financial Modules, HRMS/Payroll, JDeveloper 9i, Oracle Enterprise Manager (OEM),

RMAN (Recovery Manager), PVCS, TOAD

Met Life Inc, Jersey city, NJ                                                                             July 2003 – Feb 2005

Oracle DBA

Worked on a large environment as a member among team of 18 DBA’s which was responsible for the support of about 120 Oracle instances. I managed and supported databases related to multiple applications used by HR and financial departments.These applications include Peoplesoft Financials and Peoplesoft HR & Payroll, authoria and a few home grown applications.

Responsibilities:

·         Maintained more than 120 instances for different projects in a team.

·         Installed, configured and upgraded multiple Oracle environments.

·         Performed migration of database from Oracle 8.1.7.4.0 to 9.2.0.5.0

·         Created several Oracle Databases, tablespaces and database objects.

·         Cloned production database to refresh development and test environments.

·         Installed, configured and administrated Dataguard.

·         Implemented Data partitioning for very large application tables.

·         Used Unix shell scripts for data validation and Oracle SQL*Loader utility for data migration.

·         Installed Oracle client and trouble shooted with Oracle-Net for connectivity.

·         Query performance checking and optimization using EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK, joins, indexes, fragmentation, partitioning, optimizer hints.

·         Performance monitoring using TOP, VMSTAT, NETSTAT & shell scripts.

·         Used STATSPACK extensively while resolving performance problems.

·         Depending on the nature of database, set up of either full export, partial export or cold or hot backups.

·         Worked extensively on RMAN for database backup and recovery.

·         Scheduled shell scripts through cron jobs to automate different types of backups including RMAN.

·         Implemented and maintained Database security.

·         Complex security authorizations were enforced using database triggers.

·         Started Oracle auditing for the critical tables.

·         Planned  growth and changes of the database.

·         Handled Oracle service requests as per the requirements from different teams.

Environment: Oracle 9.2.0.5.0/8.1.7.4.0, Sun Solaris 8

Verizon, Dallas, TX                                                                                          Dec 2001 to Jun 2003

Oracle DBA

Material Recovery and Reuse System (MRRS)

The MRRS facilitated the consolidation of Verizon operations related to the procurement, distribution, and repair and scrapping of the telephone systems. Verizon’s national inventory of telephone systems was housed in 17 Verizon Supply warehouses throughout US, which served nearly 4000 Central offices of Verizon Telephone Operations/Network services. This system consolidated and improved the inventory management and reduced the expenditure incurred in inventory management. Many reports were generated for higher management for providing consolidated information about the expenditure incurred in inventory management.  I worked as Oracle DBA for this project having following responsibilities.

Responsibilities:

·         Involved in database management activities like creation of tables, indexes, views, and user security management, importing and exporting data and taking back-ups in Oracle 8i.

·         Upgraded Oracle database 8.1.5.0.0 to 8.1.7.4.0

·         Installed Oracle Enterprise edition 8.1.7

·         Provided support for production environments.

·         Responsible for data validation using shell scripts and data loading procedures using SQL Loader.

·         Analyzed dictionary buffer, exclusive lock waits, database performance and database parameter changes.

·         Analyzed extents of tables and indexes, database reorganization, tablespace administration including creating / adding datafiles and tablespace reorganization.

·         Planned, designed and implemented a complete Backup and Recovery strategy using the cold backup and export backups.

·         Performed Oracle migration from Sun Solaris to IBM AIX servers.

·         Managed shell scripts to take different types of backups and scheduled these scripts through cron jobs.

·         Used STATSPACK utility for oracle 8i databases for performance monitoring and tuning.

·         Tuned the database like memory tuning, sequel tuning & disk I/O tuning.

·         Audited database and its activities by creating Database triggers on important transactional tables.

Environment: Oracle 8.1.7.0/8.1.5.0.0, IBM AIX 4.3, Visual Basic 6.0

TATA CONSULTANCY SERVICES, India                                                           Oct 2000 to Dec 2001

Oracle DBA

Integrated Standard Banking System (ISBS)

ISBS (Integrated standard Banking System) is the software developed by TATA Consultancy  Services on Oracle. It is a retail banking software which covers all the front office functionalities in a typical Indian bank. ISBS has about 600 screens and around 1000 reports. It has modular flexible design having 30 modules. It is highly parameterised with strict security restrictions. It has powerful query facility  and reporting facility with a single window concept. ISBS is the largest selling Banking Software in India having installation in other countries also.

Responsibilities:

·         Installed & configured Oracle 8.0.5 databases.

·         Created the Database, tablespaces, rollback segments, tables and indexes.

·         Installed , configured and administrated STANDBY (Dataguard) database.

·         Sized tablespaces by deciding  the values for the initial, next and pctincrease parameters.

·         Performed Data conversion and application customization.

·         Maintained and administrated  production environment .

·         Monitored space critical objects and  extended tablespaces.

·         Did performance tuning and query optimization, database structuring strategies and procedures for optimum database performance.

·         Tuned the SGA. Monitored the shared Pool, Database buffer cache and Redo log buffers.

·         Monitored Tablespaces and Segment fragmentation.

·         Performed trouble shooting activities, created new users,  and connectivity  issues.

·         Assigned privileges and roles to users.

·         Did backup planning and scheduling with shell scripts.

·         Maintained automated backups in tape drives and in disks.

·         Recovered the Database by applying archive logs.

·         Performed knowledge transter to the onsite Bank DBA.

Environment: Oracle 8.0.5 on Sun Solaris, HP-Ux, Windows 2000, Oracle Forms 4.5

Download Resume Format