SUPER RESUME
< Back
Edit this resume to make it your own!

Your Name

Oracle Database Administrator

Leesburg, VA

your.email@example.com
111-222-3333
www.your-website.com

Summary

  • 12+ years of experience in Information Technology with a focus in Database Administration in Oracle 11g, 10g, and other older versions of Oracle.
  • Strong knowledge of GoldenGate in RAC/stand alone environment.
  • Handled very large database over 3TB in size in a complex distributed environment.
  • Expertise on Oracle Production / Development Support, Database Administration and Maintenance.
  • Well versed in logical and physical database design, configuration, upgrade, production planning, capacity planning, sizing, security management, performance tuning, standby databases and backup & recovery procedures.
  • Worked on multiple Node Oracle 10g/11g RAC.
  • Thorough knowledge of UNIX and Windows Operating Systems, mainly RHEL, AIX on the UNIX side.
  • Strong in Database Management, UNIX skills, excellent understanding of Oracle data dictionary and Oracle tunable parameters.
  • Extensive experience in Database and Application Performance tuning using explain plan, Tkprof, Statspack, AWR, ADDM reports.
  • Used BCV systems from Veritas with EMC Storage.
  • Worked with monitoring tools such OEM , Netcool.
  • Strong experience in PL/SQL support.
  • Sound knowledge of Unix Shell Scripting.
  • Extensive experience with Oracle 10g/11g DataGuard.
  • Sound familiarity of RMAN.
  • Configured Oracle Enterprise Manager in Oracle 10g/12c Grid Control.
  • Upgraded all database version from 8.0 to 11.2.0.2.
  • Applied Database/Security/MLR/CPU/PSU and Application Patches.
  • Created Test/UAT environment by Migrating data from production.
  • Worked on Oracle Virtual Private Database Technology (VPD)
  • Used Advanced Replication (Materialized View).
  • Have used Work Flow Ticketing systems like Jira, Solve, Digital Workflow, Salesforce and Service Now.

Work Experience

Oracle Database Administrator

Neustar Inc,

Oct 2008Current

Neustar was originally founded in 1996 to meet the many technical and operational challenges that arose when the U.S. Government mandated local number portability. Today, they are trusted to solve complex global communications challenges by enabling seamless connectivity across a myriad of networks, technologies and applications for carriers and enterprises alike.

Responsibilities:
  • Supporting 200+ databases as Oracle Production DBA on Oracle 10g, 11g databases with Unix.
  • Supporting multiple applications with completely different availability, support, performance and replication requirements.
  • Extensively use GoldenGate for supporting 5 9's availability applications. Support no-outage maintenance/upgrades using bi-directional replication. Setting up, supporting, maintaining and troubleshooting multiple goldengate systems.
  • Upgraded 9i and 10g databases to 11g Databases.
  • Created/Installed Oracle 10g/11g RAC clusters.
  • Used various replication technologies like Multimaster, Advanced Rep (Mview) and streams for replication purposes for reporting and DR sites.
  • Extensive use for 10g and 11g Data Guard technology with and without Data Guard Broker and Fast start Failover (FSFO) options.
  • Used Oracle OEM and shell scripts for Database Monitoring and Control
  • Support Application Jobs and processes.
  • Performance Tuning and re-organization.
  • Working on solving critical issues.
  • Providing after hours remote support.
  • Supporting Change Management.
  • Automating the daily database activities by preparing shell scripts.

Senior Oracle Database Administrator

Sircon Corporation,

Mar 2008Oct 2008

Sircon is a software and services company focused on serving the needs of the insurance industry. Sircon's solutions are aimed at reducing complexity associated with regulation and compliance. Sircon helps companies and individual producers in the insurance industry keep track of requirements needed to be legal to sell insurance in all 50 states as well as facilitate the processing of licenses, license renewals, continuing education filing, contracting and other activities related to insurance compliance.

Responsibilities:
  • Worked as a Oracle Production DBA (as contractor through Hudson Data LLC) on Oracle 8i, 9i and 10g databases within Unix and Windows Platforms
  • Used Symantic i3 for Database Monitoring and Control
  • Upgrading all 9207 databases to 9208 Databases
  • Upgraded Oracle 8i database on a Windows platform to Oracle 9i on a Unix platform
  • Use VPD as a measure of data security.
  • Oracle 9i was used for Standby for DR Purposes
  • Advanced Replication (Materialized View) for replicating the data to the client (customer) location.
  • Support Application Jobs and processes.
  • Performance Tuning and re-organization.
  • Working on solving critical issues.
  • Providing after hours remote support.
  • Supporting Change Management.
  • Automating the daily database activities by preparing shell scripts.

Environment: Oracle Enterprise Server 8i/9i/10g/11g, Oracle Enterprise Manager (OEM), HP/UX, SunOS 5.9, Win 2k.

Senior Oracle Database Administrator

Commonwealth Bank of Australia, AU

Oct 2006Jan 2008

The Commonwealth Bank is one of Australia's leading financial institutions with businesses in New Zealand, Asia and the United Kingdom. They are leading providers of integrated financial services including retail, premium, business and institutional banking, funds management, superannuation, general and life insurance, broking services and finance company activities. Electronic Data Systems (www.eds.com) was engaged to take care of IT requirements of this bank.

Responsibilities:
  • Worked as a Oracle Production/Development DBA (as employee of EDS Data systems)
  • Responsible for the Production and Development of Standby databases, Data Guard & RMAN, Transportable table spaces
  • Provided Oracle (V8, 8i, 9i, 10g, 10g RAC) technical support for customers in database backup/recovery, RMAN, standby DB, Data Guard, partition management, performance turning and security.
  • A complete installation/configuration of Oracle 10G Grid Control OEM over the complete environment.
  • Performance tuning, re-organizations of tablespaces & mount points etc.
  • Backup strategy & Configured RMAN for database back ups.
  • Capacity Planning of the Databases.
  • Cloning very large production database into development environment.
  • Improve overall performance by analysis, job scheduling, load balancing, re-organizing.
  • Part of the new initiative project team.
  • Providing after hours remote support.
  • Liaison between customer and vendors.
  • Upgraded Oracle 9i to 10g.
  • Implemented Database on a fresh environment.
  • Brought Architectural changes to database as per the need of the client and the business.
  • Implemented Change Request to deploy the changes to production database.
  • Creating Test/UAT environment by Migrating data from production.
  • Handling multiple applications/accounts/projects on different UNIX HP-UX/Sun platforms and Oracle versions of size up to more than 3 TB individually.

Environment: Oracle Enterprise Server 10g, Oracle 10g RAC, 9.2.0, 8.1.7, 8.0.6 Oracle Enterprise Manager (OEM), RMAN, HP/UX , SunOS 5.9, WIN2K

Senior Database Administrator

Telstra,

Apr 2005Oct 2006

Telstra is Australia's leading telecommunications and information services company, with one of the best known brands in the country. They offer a full range of services and compete in all telecommunications markets throughout Australia. Electronic Data Systems (www.eds.com) was handling the database administration and production support for this organization.

Responsibilities:
  • Worked as a Oracle Production/Development DBA (as employee of EDS Data systems)
  • Planning/Establishing new environments with Oracle 9i
  • Defining and implementing suitable backup policy
  • Creating Stand-by Database support systems.
  • Migration/upgrading of oracle database to different versions and platforms.
  • Testing/Approving new tools and utilities for DBA activities like taking backups, monitoring, etc.
  • Production Support and Maintenance.
  • Capacity Planning.
  • Implemented Databases on fresh environments.
  • Used SQL Server 2000 for Daily monitoring and operations as well as user and space management.
  • Brought Architectural changes to database as per the need of the client and the business.
  • Used Oracle OEM for monitoring the databases.
  • Performance tuning
  • Responsible for Oracle 9i as Standby database.
  • Upgrading Oracle 8i to 9i.
  • Maintenance activities.
  • Worked on new projects - planning and design.
  • Re-organization of Databases
  • Monitoring and Resolving Issues.
  • Applying Database, Application and Security Patches.
  • Created Test, development, quality and production databases

Environment: Oracle Enterprise Server 9.2.0, 8.1.7 and 8.0.6. Oracle Enterprise Manager (OEM), TOAD, Arbor/Kennan Billing System, RMAN, SQL Server 2000, HP/UX 11.11, SunOS 5.8, WIN2000 & WIN2003.

Senior Database Administrator

IBM - International Business Machine Corp,

May 2004Apr 2005

A company that needs no introduction; IBM is into all aspects of information technology right from hardware manufacturing to software development, product development, product support, project management and IT outsourcing. This project was for a telecom domain taking care of all aspects of its IT business.

Responsibilities:
  • Worked as a Oracle Production/Development DBA
  • Installation and Upgrading Oracle 8i to 9i.
  • Monitoring and fixing the daily database problems at segment, extent, data file and table space level.
  • Monitoring the fragmentation activities of data objects, reorganizing the schemas, database.
  • Tracking the growth of database and planning for future space requirements within existing resources.
  • Automating the daily database activities by preparing shell scripts.
  • Working with teammates for satisfying there requirements like creating objects, tablespaces, schemas, partitioning, grants, privileges and helping the developers in developing efficient code.
  • Dealing with High Availability and also Disaster recovery for 24 x 7 hour mission critical applications.
  • Identifying the Parent child relationship, load frequencies and dependencies of datasets.
  • Modifying the shell scripts and stored procedures of datasets as per requirements.
  • Production support of 24x7 databases.
  • Prepared database (cold and hot) backup / restore scripts and recovery plan for Disaster Discovery using RMAN and Veritas netback tools.
  • Used OEM for monitoring of other databases.

Environment: Oracle 9i, 8i and 8, TOAD, RMAN, HP/UX 11.11, SunOS 5.8, WIN2000 & WIN2003, OEM

Senior Oracle Database Administrator

Bharti Televentures,

Aug 2003May 2004

Bharti Enterprises is one of India's leading business groups with interests in telecom, agri business, insurance and retail. While a joint venture with TeleTech Inc., USA marked Bharti's successful foray into the Customer Management Services business, Bharti Enterprises' dynamic diversification has with the company venturing into telecom software development. TeleTech Inc. is a Telecom environment with around 30 Production databases (V8, 8i and 9i) and more than 80 Development and Test Databases on different UNIX platforms biggest database being bigger than 1.5TB.

Responsibilities:
  • Worked as a Oracle Production/Development DBA
  • Planning and Implementation of backup and recovery strategies.
  • Using BCV systems from Veritas with EMC Storage for high availability and reporting purposes.
  • Using RMAN for taking backups.
  • Involved in proper capacity planning to ensure proper sizing of DB.
  • Performance Tuning using analyzing, Statspack, Tkprof and other oracle utilities
  • Created database links for maintenance of distributed databases
  • Space management in database and at OS level using OFA standards
  • Creation of Tablespaces and adding new data files.
  • Re-organization of Databases using various methods like exp/imp, copy, move and partitioning.
  • Liaise with vendor for product /database support.
  • Capacity planning of the databases.
  • Worked extensively with Oracle Corp via TAR and OWC and onsite.
  • Worked on Partitioned tables and indexes.
  • Created Dash Board reports for all the databases in Datacenter.
  • Tuned SQL queries by generating execution plans to ensure the usage of indexes.

Environment: Oracle 8, 8i, Arbor/Kennan Billing System, HP-UX, Solaris 5.7, Toad, OEM, WIN2k, RMAN

Oracle - DBA

EZ Software Systems India, IN

Jun 2001Aug 2003

Responsibilities:
  • Software Development
  • Software and Database Testing
  • Database Design
  • Database Daily Operations
  • Monitor Backups
  • User Management like creating user with required level of access and attaching them to profile.
  • Monitoring Scheduled Jobs.
  • Monitoring Job Queues (User Requests)
  • Writing SQLs and PL/SQLs for the application team.
  • Unlocking/Resetting password as per the user request.

Environment: Oracle 8, Sybase, Power Builder, WinNT.

Oracle Database Analyst

Kaizen Software Systems,

Oct 2000Jun 2001

Kaizen Software Systems is a custom software development firm. They offer full cycle custom software programming services, from product idea, offshore software development to outsourcing support and enhancement. They employ a large pool of software engineers coming from different backgrounds. Worked as Executive on projects AIMS and Plant Manufacturing System (PMS)

Responsibilities:
  • Software Development
  • Software and Database Testing
  • Database Design
  • Database Daily Operations
  • Monitor Backups
  • User Management like creating user with required level of access and attaching them to profile.
  • Monitoring Scheduled Jobs.
  • Monitoring Job Queues (User Requests)
  • Writing SQLs and PL/SQLs for the application team.
  • Unlocking/Resetting password as per the user request.

Environment: Oracle 8, Sybase, Power Builder, WinNT.

Education

Bachelor of Commerce

University of Allahabad India, Allahabad, Uttar Pradesh

Education

Aptech,

Additional Information

Technical Proficiency: 
Database: Oracle 8i / 8.x/ 9i /10g /11g, MS-Access, SQL Server 2000/2005, Sybase 
Operating Systems: SUN OS 5.9, HP-UX 11i, LINUX, WINDOWS (NT 4.0, XP, 2000)
Resume Builder | Resume Templates | Resume Examples | About Us | Privacy Policy | Terms of Use | Help Articles | Contact Us
Super-Resume.com © 2013-2017