We provide IT Staff Augmentation Services!

Systems Dba Resume

3.00/5 (Submit Your Rating)

Oakton, VA

SUMMARY

  • He has over 10 years Oracle DBA experience in production support as well as development support. He has managed dba group and has also been the lead dba.
  • As a DBA manager, he has instructed and managed groups of dbas.
  • Also as a systems dba, he has installed Oracle 7 - 9, 10g, 11g, 12c. Backup and recovery plans were created and implemented As a physical DBA, created backup and recovery strategies and implemented them, installed and maintained oracle systems .
  • Oracle Applications, Oracle web server and forms servers. Installed and configured Oracle Applications including HR, GL, AR, AP, FA, as well as all the manufacturing modules. Oracle Application versions 10.X and 11i and 12c.
  • Supported systems on Unix: HPUX, AIX, Dec Alpha, Sun, and Windows, Client Server environments as well as web environments. Performance tuning on SQL code as well as physical database design. Created logical and physical ERD models and created them in the database.

TECHNICAL SKILLS

  • Oracle 10g,11g,12c
  • Managed dba groups of 5 or more
  • Taught Courses for Oracle
  • Oracle PL/SQL SQL/Plus Scripting
  • Oracle Applications including Financials, and Manufacturing
  • Unix scripting for the Oracle database
  • Windows server set up for the Oracle Applications
  • 12C OEM, OEM
  • Oracle AWR & ADDM
  • Oracle Goldengate
  • Oracle DBA Masters

PROFESSIONAL EXPERIENCE

Confidential, Oakton, VA

Systems DBA

Responsibilities:

  • Manage Backup and Recovery Program for all Oracle Databases.
  • Install, implement and configure RMAN.
  • Experienced in Encryption and Oracle TDE, Oracle Wallet.
  • Created Oracle partition tables and applied patches as per the requirements of the partitioning module and upgrade Oracle and DBMS software.
  • Regular practice of Disaster Recovery Scenarios.
  • Adding and deleting node to RAC environment.
  • Troubleshoot network issues to connect to database.
  • Dealt with Oracle by opening an SR or calling their customer support whenever necessary.
  • Restored databases on different hosts.
  • Installation and configuration of OGG 11g /12c for high availability, OGG upgrades, patching.
  • Upgraded OGG from 11g to 12C, upgrades from OGG 12.1.2 to OGG 12.2.01.
  • Troubleshooting daily issues encountered like GG abended, extract/replicat abended.
  • Set up 12C OEM for alerts and thresholds.
  • Designed, Developed and implemented shell scripts for database monitoring activities
  • Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace.
  • Perform Backup and Recovery through RMAN.
  • Strong exposure in Installing / configuring / maintaining RAC, Data Guard, Physical / Logical Standby environments.
  • Applied Quarterly CPU (CRITICAL PATCH UPDATES) on the different environments.
  • Initiated cronjobs to review alert logs and dump files to check for any ORA - errors.
  • Used Oracle AWR & ADDM to monitor database activities and performance tuning.
  • Code Unix shell scripts to automate database backup jobs, performance monitoring.
  • Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
  • Installed, migrated, configured and tested Oracle databases in various environments.
  • Extremely dedicated, self-motivated, Pro-Active and willing to assume responsibility.
  • Export and Import of User, Tables and Database using Data Pump Utility.
  • Maintained encryption on various databases using Oracle TDE.
  • Proficient with encryption algorithms which allows TDE onto column and tablespace encryption.
  • Very familiar with Dynamic Views and Dictionary Tables.
  • Preventive Maintenance & re-orgs.
  • Installed, migrated and tested Oracle databases in various environments.
  • Patch standalone database and RAC databases
  • Refresh databases using RMAN
  • Perform Backup and Recovery through RMAN.
  • Installed, created and configured 10g, 11g and 12c databases
  • Database sizing, Capacity Planning.
  • Work closely with application developers and system administrators Automated various tasks through Crontab.
  • Provided full DBA support for Oracle Applications in Production, Test and Development environments
  • Performance Tuning of SQL and Databases parameters.
  • Manage security and grants for database users.
  • Written RMAN scripts for various day to day jobs.
  • Performance Tuning of database, SQL tuning for Application.
  • Performance Tuning of DBs using SQL trace, TKPROF, Explain Plan
  • Physical and Logical database design.
  • Database sizing, Capacity Planning.
  • Analyze database objects.
  • Upgraded oracle clients as per application needs.
  • Configured Agents on different platforms to communicate with Gird Control.
  • Configured and maintain Grid Control Repository.
  • Configured Listener from multiple homes in one server.
  • Provided full DBA support for Oracle Applications in Production, Test and Development environments
  • Worked very closely with ORACLE for Data Guard implementation

Confidential, Tampa, FL

Systems DBA

Responsibilities:

  • Oracle 9i RDBMS iAS, 9i and 10G
  • Discoverer, SQLbacktrack
  • ERD Modeling and Design
  • Installations, performance tunings
  • Patch Installs and Backup and Recovery Plans
  • Production Monitoring and Storage Management
  • Production Support including SQL Troubleshooting
  • EDW - Data warehouse support.
  • Production Support including SQL Troubleshooting
  • Managed a group of DBA’s

Confidential, Boston, MA

DBA Engineer

Responsibilities:

  • Oracle 9i
  • Performance tuning
  • Managed DBA Activities
  • Backup and recovery
  • Installations

Confidential

Oracle Applications DBA Manager

Responsibilities:

  • Oracle 9i installation and configuration and RAC
  • Backup and Recovery Strategy created and implemented
  • Maintained patches and security patches
  • Applied patches and cloned applications
  • Managed DBA Activities and Other DBAs
  • Created backup and recovery model as well as performance monitoring
  • 9i RDBMS

Confidential

Oracle Applications DBA Manager

Responsibilities:

  • Backup and Recovery implemented and revised
  • 8i installed and maintained.
  • Managed the DBA Group and created standards
  • Managed software budget
  • Created backup strategy including the use of SQLbacktrack
  • Applied patches and cloned
  • Worked with BCV’s (Timefinder) and created processes
  • Created backup and recovery model as well as performance monitoring

Confidential

Oracle Applications DBA Manager

Responsibilities:

  • Oracle 11i Apps on Windows 2000
  • Created standards and implemented dba codes and changes
  • Created backup and recovery model as well as performance monitoring
  • CLONED Oracle Applications Environment, setup Iwatch and SQLBACKTRACK
  • Installed and configured MULTI ORG, MRC, and multiple tier environments.

We'd love your feedback!