SEARCH

Oracle DBA Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
ORACLE DBA
Career Overview
An enthusiastic, self motivated and initiator professional (DBA) looking for a stable position in a growing organization to utilize my experience and knowledge.
Summary of Skills
  • Technical help desk experience
  • Strong analytical skills
  • Strong collaborative skills
  • Document management        
  • Excellent problem solving skills
  • GUI and tools
  • Structured query language (SQL) expert
  • UNIX/LINUX  
  • Optimizing and performance tuning
Work Experience
June 2014
to
June 2015
JPMorgan ChaseNew York City, NYOracle DBA
  • Responsibilities: Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g.
  • Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
  • Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.
  • Used AWR, ADDM and statspack Reports for troubleshooting performance issues and Capacity Planning
  • Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
  • Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
  • Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "runInstaller" and perl based utility "opatch".
  • Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
  • Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
  • Utilized Oracle streams to Capture, Propagate and apply the transfer of data, transactions and events within managed Databases.
  • Experienced in Data Center migration of databases to prepare the proof of concept, DB migration procedures and scripts, developed templates that include check list for migrating the databases.
  • Perform Database upgrades, migrations; take logical exports from the QA, DEV etc instances and importing the data on to the production systems etc.
  • Establish Backup policy using RMAN and VNB (Veritas Net Backup).
  • Also managed Backup, Restore using Data Pump, Traditional Export and Import Utilities.
  • Worked with Partition Tables.
  • Partitioned Tables and sub-partitions as per the requirement of the Applications to improve performance and data management.
  • Used Datapump export/ import to instantiate SCN to avoid conflict at destination, created different rule sets to propagate and apply process.
  • Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance Expert in Space monitoring, Functions, Procedures, Triggers & Packages, and Object Management.
  • Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
  • Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
  • Supported & maintained the Production/Development databases on various servers Extensively worked on setting up auditing in many databases we supported Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
  • Database reorganizations and refresh schema-using Export/Import.
  • Creating the database, table spaces, tables, indexes, setting privileges and user logins Used hints for SQL tuning and optimization Performed Explain Plan analysis for Query Optimization and SQL tuning Environment: Windows, Oracle 11g, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL*Plus.
April 2013
to
May 2014
FitgoRichmond, VAOracle DBA
  • Performed Installation and configuration of Oracle database on Unix platform.
  • Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
  • Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
  • Used SQL TRACE, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Maintained the data integrity and security using integrity constraints and database triggers.
  • Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
  • Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
  • Install and configure block change tracking to work with RMAN Merged incremental backups.
  • Applied patches and responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
  • Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
  • Provided 24X7 supports for all the production and development databases.
  • Environment: Oracle Unix11, Oracle Streams, RMAN, Data Pump, SQL TRACE,.
October 2010
to
March 2012
Diebold IncGaithersburg, MDJunior Oracle DBA
  • Managed in-house Oracle Databases running on various operating systems like Windows NT and Linux.
  • Installation of Oracle Database and Oracle products.
  • Implementing Backup/Recovery Strategies.
  • Using Enterprise Backup utilities for backup.
  • Writing scripts for backup and recovery.
  • Database tuning, backup and recovery and general day to day running of the system.
  • Systems analysis and design.
  • System tuning for better performance.
  • Creating users and maintaining database security.
  • Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
  • Designing and enforcing standards and naming conventions.
  • Co-coordinated, and delivered Oracle courses such as Database Administration, database security, enterprise backup and recovery solutions, PL/SQL concepts.
  • Writing UNIX shell scripts for backup and recovery.
  • Supervised the installation and configuration of Oracle databases on Linux and Windows NT Writing SQL scripts to monitor database performance.
  • Writing SQL Loader control files for data loading to the payroll system.
  • Problem trouble shooting and resolution.
  • Database installation and instance creation.
  • Creating project plans and implementation schedules.
  • Environment: Oracle 11g, Oracle 10g, RMAN, ASM, STATSPACK, SQL*Plus.
February 2010
to
August 2010
AmerigasPlano, TXBusiness Analyst
  • Responsibilities: Developed CBA's (cost benefit analysis) documents for projects.
  • Assisted the project manager in the creation of the project charter & vision document during the inception phase of the project Assisted project manager in conducting SCRUM meetings.
  • Involved in scope definition of the projects and enhancements Worked with business units in different time zones to define requirements and UAT sessions.
  • Developed a work plan detailing the tasks and effort required to achieve the scope of the project Conducted meetings with technical team and upper management and acted as a liaison Worked with lender integration projects and developed high level view of data requirements and performed data analysis.
  • Applied project management knowledge and expertise to gauge system performance and assess risk Directly involved in introduction and implementation of RUP in United guaranty's latest projects.
  • Created Vision document, Use cases, UCMS, Activity Diagrams and other RUP artifacts to document business and technical requirements.
  • Assisted project team with tracking issues during UAT, creation of test plans with QA team and perform UAT when necessary.
  • Environment: Microsoft Visio, Lotus Notes, Microsoft Excel, Microsoft Word.
December 2009
to
March 2010
Bolstos instituteLaurel, MDORACLE DBA/Intern
  •  As an Oracle Database Administrator having hands on experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, migration, data modeling and documentation.
  • Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, administration and maintenance of Oracle 11g Worked extensively on Oracle Installation, Oracle Version Upgrade, Migrations (from 10g to 11g) and patching Involved in performance tuning and database reorganizations.
  • Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.
  • Performed SAN analysis and provided recommendations Wrote several Purging shell scripts on Linux which have been using as standard script at the workplace Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean-up, data archiving, etc Developed RMAN scripts for database back up and recovery including- hot and cold backup Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes Installed Oracle 11g with ASM and OCFS2 File systems.
  • Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
  • Worked with the implementation and extension of a conceptual data model.
  • Maintain conceptual, logical and physical data models along with corresponding metadata.
  • Team player with excellent interpersonal, analytical and communications skills Wrote scripts to inform the DBA's regarding the status, performance and space management of the database Participated in planning and implementation of off-site Disaster-Recovery planning and testing Worked with development and operations staff in resolving problems quickly and efficiently Installed, configured and maintained Physical, Logical.
  • Performed backup & recovery of large databases and provided 24X7 production support to high critical databases Proficient in all the phases of Software Development Life Cycle (SDLC) as well as Software Implementation Life-Cycle (SILC).
  • Knowledgeable in using Grid Control and OEM Features and worked with databases which have critical and BLOB data Monitored and managed various database components (logical & physical) like table- spaces, segments Worked extensively on Shell scripting for backup, recovery and maintenance for databases.
Education and Training
2012
Prince's georges community collegeLargo, MD, USAAssociate of Science: Computer Science
Additional Information
  • TECHNICAL ENVIRONMENT Willing to relocate anywhere. Authorized to work in the US for any employer
Technical Skills and Qualifications
Administrative, ASM, auditing, Backup, Capacity planning, Catalog, communications skills, interpersonal, concept, data analysis, data management, data migration, Database Administration, Disaster-Recovery planning, documentation, Linux, Managing, migration, Enterprise manager, Optimization, Oracle [...], Oracle Enterprise Manager, PL/SQL, payroll, project management, project plans, QA requirement, assess risk, Scheduling, SQL Loader, statistics, Systems analysis and design, Tables, Team player, troubleshooting, UNIX Administration, Upgrade, Utilities, Vision
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • JPMorgan Chase
  • Fitgo
  • Diebold Inc
  • Amerigas
  • Bolstos institute

School Attended

  • Prince's georges community college

Job Titles Held:

  • Oracle DBA
  • Junior Oracle DBA
  • Business Analyst
  • ORACLE DBA/Intern

Degrees

  • Associate of Science : Computer Science

Similar Resumes

View All
Oracle-DBA-resume-sample

Oracle DBA

Germantown, Maryland