Sr. Oracle DBA Resume

Title
Sr. Oracle DBA

Primary Skills
Sr Oracle DBA

Location
US-OH-COLUMBUS

Posted
Apr-06-09


SUMMARY:

Over 9 years of increasingly responsible experience in all aspects of Oracle Database Administration in fast growing environment. My expertise involves in Database/ Infrastructure support, Backup and recovery, monitoring and performance tuning, data modeling, development of stored procedures, packages, triggers.
Excellent knowledge in Cluster Ready Services, Enterprise Manager Grid Control, Data Guard, Relational Databases, Data Modeling and Managing Schema objects


TECHNICAL SKILLS:

Systems\ RDBMS\
Solaris(E25K, Sun-Ultra, Sun-Fire), \ Oracle 7.x, 8.x, 9i RAC \
HP, IBM AIX (RS 6000, eSeries P570), \ and 10G RAC\
Linux and Windows Servers (2003, \
2000, NT)\

Software\ Languages\
ERWin, Oracle, SQL*Plus, Toad, \ PL/SQL, C, C++, Centura \
Precise\ and HTML\


PROFESSIONAL EXPERIENCE:

Attorney Generals Office May 08 Till Date
Columbus, OH
Sr. Oracle DBA

Responsibilities:
Involved in the database support for the Production, Development Environments of the Projects, OLLESON, OHLEG, CCH, AFIS, ESORN, etc.
Implemented Data Guard.
Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
24/7 Database support of multi-terabyte Oracle 10g database.
Involved in the maintenance and trouble shooting of RAC Databases and Enterprise Manager Grid Control.
Involved in the Design of Backup and Recovery Strategies using RMAN, and Configuring Oracle Data Guard.
Trained the team of three Database administrators, installation and troubleshooting of RAC, managing disks and disk groups with ASM, use of Enterprise Manager Grid Control, Backup and Recovery using RMAN.
Prepared Installation Procedures for 10.2.0.4 Patch, Documentation for Adding a node to Existing RAC environment and Data Guard.
Involved in the installation of Test Environments, Development Environments for the project.
Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, recovery time allowed etc.
Provided documentation as well as training on process and procedures for infrastructure architecture.

Environment:
Software: Oracle10g RAC, ASM, EM Grid Control, Suse Linux 9, Tivoli


American Red Cross Aug 06 April 2008
DC - VA
Oracle DBA

Responsibilities:
Involved in the database support for the Development Environment of the Project, Bio Arch.
Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
Supporting Data Migration Team for all their activities like, installing source, stage and swing databases, refreshing DM servers with production data, etc.
24/7 Database support of terabyte oracle 10g database.
Involved in the installation, maintenance and trouble shooting of RAC and Single Instance Databases and Enterprise Manager Grid Control.
Involved in the Design of Production Database design, Backup Strategies using RMAN, and Configuring Oracle Streams.
Prepared Installation Procedures in Test Director, Documentation of RAC and Single Instance Databases.
Involved in the installation of Test Environments, Development Environments for the project.
Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, recovery time allowed etc.
Working with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.
Developed UNIX Shell scripts for daily database backups and other scheduled database procedures.
Provided documentation as well as training on process and procedures for infrastructure architecture.

Environment:
Software: Oracle10g RAC, EM Grid Control, Toad, Solaris 10, VeritasClusters


Mellon Bank June 2004 May 2006
Pittsburgh, PA
Oracle DBA

Responsibilities:
Involved in Requirement Analysis, Design, and Implementation of suite of web based financial applications: Merchant Referral Systems, Integrated Claims Environment, Corporate Actions, Account Opening, and Digital photo card.
Performed database administration tasks: database installations, builds, upgrades, object sizing, object creation, cold backups, export/import and sqlload.
Involved in the Installation and Maintenance of RAC.
Worked with developers to setup and maintain development databases. Designed, maintained application data model using Erwin 4.0
Designed backup and recovery plan, implemented with RMAN as centralized backup solution. Performed disaster recovery test for production database.
Modified DB configurations as performance tuning needs.
Created, scheduled db maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, db exports and janitorial day-to-day tasks.
Automated various db monitoring tasks, such as instance availability, backup completion, disk space usage, db job executions, and other error conditions.
Installed Oracle software, applied patches planned, coordinated and migrated databases from 8 to 8i, 9i.
Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
Involved in capacity planning and resource planning.
Identified performance bottlenecks using precise and provided resolutions.
Database and SQL tuning using explain plan and other tuning processes.
Designed data files, log files and control files layout across disks.
Developed code generators for creating auditing triggers and maintenance of user defined data types.

Environment:
Software: Oracle 9i RAC, SQL*Plus, ERWin, Toad and HP-UX


Karur Vysya Bank July 2001 March 2004
Chennai, India
Oracle DBA

Responsibilities:
Involved in Requirement Analysis, Design, and Implementation of Test Environment for UAT, Disaster Recovery Site, and Warehousing database.
Provided database/infrastructure support.
24/7 Database support of Oracle 8i/9i database.
Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, and volatility of the data, recovery time allowed etc.
Using precise identified performance bottlenecks like queries utilizing high CPU, internal lock waits, red log buffer waits and Cartesian joins etc. Resolved such issues by fixing code, tuning query and instance accordingly.
Data modeling and daily management of schema objects.
Implemented many stored procedures, packages and triggers for extracting data to the warehousing database.

Environment:
Software: Oracle, Business Objects, SQL*Plus, SQL Navigator, IBM AIX, Windows 2000 Server


RKITS Sep 1999 June 2001
Hyderabad, India
Oracle Developer/DBA

Responsibilities:
Involved in Requirement Analysis, Design, and Development of the Projects, worklife.com, constructionjobs.com, nursingjobsonline.com
Design and development of Application & Admin Module.
XML schema design for gathering data from co-job sites, validating XML files against schema and load data into database using java.
Application Design, Coding and Performance tuning of PL/SQL code.
Wrote procedures for Searches, using Concatenated Data store.
Developed XML DTD and parsing XML documents to store data gathered from different job boards (Monster, AltaVista, Britannica etc), processed XML files which are retrieved from Business.com for search results using PL/SQL scripts.
Done PL/SQL coding using web tool kit, which renders HTML pages.
Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, and export/imports.

Environment:
Software: Oracle 8i/9i, Oracle 9i AS, SQL*Plus, Toad, Windows NT/2000


Evolus (I) Pvt., Ltd Dec 1997 June 1999
Bangalore, India
Oracle/Centura Developer

Responsibilities:
Involved in Requirement Analysis, Design, and Implementation of the modules HR Management, Address Management, Application Services, System Services.
Involved in the coding of the module HR Management using Centura Team Developer.
Supported the on-site implementation team for the modules HR Management, Address Management, Application Services and System Services.
Bug fixing, maintenance of the modules and developing the patches for the database.

Environment:
Software: Oracle, SQL*Plus, Toad, ERWin, Centura, Windows NT


EDUCATION:

M. Sc. in Computer Science, India

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in COLUMBUS, OH | Resumes in Ohio

View other Sr. Oracle DBA resumes, Database Administrator resumes