We provide IT Staff Augmentation Services!

Lead Oracle Dba Resume

CA

Professional Summary

  • Result oriented, analytical and self-driven professional seasoned with 12 years of working in a dual role of design/architecture and production support.
  • Experience in Installation/Administering Oracle 10g, 9i, 8i Databases of varying landscapes and sizes.ญญญญญญญ
  • Excellent hands-on in database administration over Dedicated Servers, Parallel Servers, Data Guard Servers, Distributed Servers and Very Large Databases (VLDB) of sizes over 23 Terra Bytes on multiple instances which includes tuning, backup & recovery procedures.
  • Extensive experience in data center configuration and migration.
  • Extensive experience with Oracle patching/ cloning and configuration.
  • Extensive experience with implementation of Oracle Advance security Wallet Manager.
  • Experience with Oracle stream for the data replication for data mart.
  • Experience of implementation of DR (Disaster Recovery) plan with different approach like Dataguard / Oracle streams.
  • Experience with implementation of Audit and security implementation on oracle databases.
  • Extensive experience in Database Upgrades & Migration from oracle 8i to oracle 9i, oracle 9i to 10g with cross-platform migrations.
  • Experience using OEM, Grid control, Erwin, Toad for database administration, monitoring and design.
  • Worked extensively on Backup & Recovery online/offline using RMAN, BCV technology & User-Managed physical/logical backups using Import/Export. Along with performing DR drills using BCV’s and Tape recoveries.
  • Experience on Performance Tuning & Capacity Planning pro-active and re-active actions for optimal performance complying with business SLA’s.
  • Excellent communication, interpersonal and leadership skills along with very good understanding and experience working in a highly qualified environment.

Technical Skills
Databases: Oracle 10g/9i/8i
Operating system: UNIX, HPUX, AIX, Linux, Solaris, Windows
Applications: SQL Navigator, SSH, Reflection X
Monitoring Tools: Oracle 10g Grid Control, OEM, Toad, Net IQ, Veritas
Backup & Disaster Recovery: RMAN, Dataguard
Performance & Tuning Tools: AWR/Statspack reports, ADDM, TKPRF/Trace Analyzer, Oracle 10g OEM Grid control, RDA

Certification:

Oracle9i and Oracle10g Certified Database Professional (OCP), ITIL V3

Professional Experience

Client : Confidential, CA Aug ‘10 – Till date
Role : Lead Oracle DBA

Responsibilities

  • Partner with architects of different other engineering / application teams to engineer complex technical product in order to provide palpable business solutions to various business divisions as a part of DBA Engineering project activities.
  • Oracle streams implementation/administration for live reporting server, database consolidation, zero downtime migration.
  • Architecting Oracle Fail safe environments for site critical databases, including configurations, failover testing, tuning, creating standards etc.
  • Supervising application of One-Off, patchsets and PSU patches Oracle patches for 10g RDBMS and clusterwares.
  • Designing processes and procedures, setting up standards, creation of scripts for installation of Oracle Server software, creation of databases, setup backup using RMAN, DR solutions using tape backup.
  • Leading the efforts of performance tuning to scale up the test results in tune with the requirement of the application team.
  • Optimizing the downtime for maintenance by coordinating with the different application teams involved in the maintenance activity.
  • Strictly followed Change Control/Change management procedures as laid down by the organization in a highly qualified environment.

Environment : Solaris, Oracle 11.x/10.2.x/Cluster-ware, Oracle Grid control, Dataguard, Oracle streams, Toad

Client : Confidential,Pittsford, NY July ‘07 – Aug ‘10
Role : Database Architect/ Sr. Oracle DBA

Responsibilities:

  • Responsible for 24*7 supporting more than 30 Oracle databases (10g/9i) running on Aix 5.x, HP-UX 11i wherein the major chunk of the databases hold data of OLTP, DSS and other enterprise applications as a Database
  • Implemented, administered, reorganized and subsequently tuned all Oracle databases (development – production) databases with datacenter migration from Pittsford, NY (oracle 9i on HP UNIX) to Georgetown, TX (oracle 10g on AIX Unix) that save the company an estimated $3 million a year.
  • By Implementing the Advance Security Wallet Manger on oracle 10g database, solve many audit and application connectivity issue.
  • Successfully migrated Oracle 9i databases to Oracle 10g databases
  • Responsible for analyzing and designing the process to implement the oracle patch sets available in Oracle.
  • Responsible key member in designing/testing/implementing enterprise level move from user-managed backups to RMAN on Oracle 10g environments.
  • Configured database cloning to copy production to other prod copy (for adoc report purpose) using Business Continuity Volumes (BCVs).
  • Responsible for Validating Database integrity, security, auditing through SOX twice years to ensure the databases are FDA compliant.
  • Involved in performing Disaster Recovery drills twice a year for all production systems using BCV splits of remote standby databases and tape recovery for non-BCV enabled systems.
  • Maintaining strong working relationship with customers (UNIX, storage, developers and team leads).
  • Prepare validation documents for database setup (installation, configuration, operation, etc.) in a FDA regulated environment.
  • Strictly followed Change Control/Change management procedures as laid down by the organization in a highly qualified environment.

Environment : AIX/HP-UX/Windows, Oracle 11.x/10.2.x/9.8.x, SQL Server 2005, SQL, PL/SQL, Korn/C-Shell Script, Toad

Client : Confidential,Jan ‘07 – Jul ‘07
Role : Oracle Database Administrator

Responsibilities

  • An active member in upgrading & migrating 9i databases to 10g for both OLTP and data warehouses.
  • For data-mart design, Implemented Oracle Stream (Advance replication) on oracle 10g.
  • Involved in creating, maintaining and refreshing required Oracle instances/databases for development, test and production environments.
  • Provided DBA support to the application development and acceptance team, both onsite and offshore for loading and testing data in 10g databases.
  • Implemented Oracle\'s Advanced Features such as Partition table, Partition Index, Function Based Indexes
  • Was responsible for setting up standards for database maintenance and monitoring.
  • Responsible for Report generation, monitoring disk usage, keeping systems healthy for the production environment.
  • Implemented changes into the existing cron jobs as per the business needs.
  • In conjunction with the security administrator established and managed user access, along with designing and implementation of user environments, also establishing enterprise level security standards.
  • Extensively used metalink for resolving technical issues, opening SR and use collaborative support for database related issues.
  • Responsible for documenting important scripts and administration of server environment.
  • Responsible for conducting weekly meeting, tele/video conference with clients, development teams both onsite as well as offshore.

Environment : AIX- Unix/ Oracle 10g, Sqlplus, PLญญ/SQL, Sql Loader, TOAD, Erwin, Korn shell script, Perl Script

Client : Confidential,June ‘06 – Jan ‘07
Role : Oracle Database Administrator

Responsibilities

  • Responsible for providing on call production support for 24x7 databases running on oracle 9i.
  • Performed day-to-day DBA activities like patching, performance tuning, space management, backup & recovery, query optimization, testing and implementation.
  • Responsible for installation and configuration of oracle 9i over Aix and Windows platforms.
  • Worked through all the stages of SDLC and was involved in requirement analysis.
  • Responsible for doing the capacity planning.
  • Implemented replication among the distributed sites using materialized views.
  • Performed Database Cloning to create TEST and DEV instances
  • Responsible for development of database schemas based on project requirement, database setup & configuration
  • Responsible for optimizing instance performance and throughput so as to keep in pace with SLA.
  • Implemented table and index partitioning for enhancing the query performance for demanding applications.
  • Supporting development team with in SQL query optimization using SQL Trace, Explain Plan, SQL Query Analyzer and Optimizer Hints.
  • Involved in implementing and managing backup & recovery strategies using user managed process.
  • Responsible for scheduling backup scripts in cron to run on timely basis according the strategy.

Environment : AIX/Windows, Oracle 9i, Crystal Reports, Erwin, TOAD

Client :Confidential,Feb ‘03 – June ‘06
Role : Oracle Database Administrator

Responsibilities

  • Maintenance of Oracle Databases as per the requirement.
  • Managing the logical objects of the Database.
  • Rebuilding Index to rectify segment fragmentation.
  • Checking Alert Log file for errors and taking necessary actions to rectify them.
  • Frequent analysis of objects or schemas to improve the speed of the database.
  • Taking hot Backups.
  • Export / Import of Tables and Full Database.
  • Killing unwanted user sessions or processes.
  • Monitoring the database growth, Re-Organization of Tables.
  • Installing Oracle clients & ODBC for users.

Environment : AIX/Windows, Oracle 9i

Client :Confidential,Lab Jul ‘02 – Jan ‘03

Responsibilities

  • Troubleshooting desktop issues for the users.
  • Setting up the network for the users
  • Installing windows, oracle client and setting up hardware for the users.
  • Managing the hardware asset for the company.

Client : Confidential, June ‘00 – Jul ‘02

Responsibilities

  • Installing Oracle clients on user machines.
  • Checking alert logs and user logs.
  • Tablespace management

Education

  • Bachelor of Engineering

Hire Now