We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

East Brunswick, NJ

PROFESSIONAL SUMMARY:

  • Over 20 years of experience as an Oracle DBA managing Oracle production, QA and development databases on various platforms
  • Support more than 75 databases 24/7
  • Experience tuning databases and applications
  • Experience using rman and export/import for database backup and recovery
  • Provide production support for Oracle NON - RAC and RAC databases
  • Communicate effectively with technical and non-technical colleagues and clients
  • Set database standards and procedures to improve application upgrades
  • Write scripts to automate process which increases productivity and reduces error
  • Remote DBA for customer support
  • Saved the company money by creating multiple customer schemas in one database vs one customer schema per database
  • Train development and customer service reps to use database performance monitoring tools to provide faster resolution

TECHNICAL SKILLS:

Databases: Oracle12c, 11g, 10g, 10g RAC, 9i, 8i, 7

Tools: /Utilities: Export/Import, datapump, SQL*Plus, RMAN, SQL*Loader, Database Performance Analyzer, LAB128, MKS Tools, PLSQLDeveloper, SQLDeveloper, FogLight, OEM

Operating Systems: Windows, Unix OS (Red Hat Linux, Solaris, HP), VMWare

Languages: SQL and PLSQL, DOS and Unix shell scripting

OTHER SKILLS:

  • Ability to juggle multiple priorities
  • Ability to adapt to changes
  • Ability to work on my own and in a team
  • Ability to analyze and troubleshoot problems

EXPERIENCE:

Confidential, East Brunswick, NJ

Senior Oracle DBA

Responsibilities:

  • Install/upgrade/patch Oracle software.
  • Capacity planning.
  • Create and manage databases for Production, QA, Development and Demos.
  • Database and application performance tuning, export/import (expdp/impdp), database restore.
  • Internal/external production support.
  • Write Unix shell scripts and DOS batch scripts.
  • Developed procedures to automate repetitive tasks.
  • Design process for automating export on demand.
  • Designed and developed a process to “Scramble” data to be HIPAA compliant.
  • Developed a process to keep track of builds applied to a schema.
  • Software evaluation. Provide remote DBA service to clients.
  • Used DPA(Ignite), LAB128, OEM, Statspack, PLSQLDev, Foglight and SQL scripts to monitor databases.
  • Train others on diagnosing performance issues. Migrate Oracle to new versions.
  • Evaluate tools for Oracle database monitoring. When necessary, create service requests with Oracle to resolve database issues.

Confidential, New York, NY

Systems Developer

Responsibilities:

  • Interface with users.
  • Designed, coded and tested data input screens and Pro*C application for the Confidential .
  • This system maintains prices for various materials and locations.
  • Oracle*Forms and Pro*C were used to develop the application on an OS2 server.

Confidential, New York, NY

Programmer Analyst

Responsibilities:

  • Database Administration. Interface with users.
  • Designed, coded and tested data input screens and reports for the Investor Services Information Systems (ISIS).
  • This is a portfolio management system. SQL*Forms V3.0 and SQL*Reportwriter were used to develop the application on an HP server.

Confidential, New York, NY

Database Administrator/Programmer Analyst

Responsibilities:

  • Database Administration. Interface with users.
  • Conversion of data from previous system.
  • Designed, coded and tested the data input screens for the department.
  • The system monitors the relationships between the members, members' pension, firms, clerks and seats.
  • SQL*Loader was used to load the data from the previous system.
  • SQL*Plus and PL/SQL were used to massage the data.
  • SQL*Menu and SQL*Forms V3.0 were used to develop the input screens.

Confidential, New York, NY

Programmer/Analyst

Responsibilities:

  • Heavy Interface with users, Designed, coded and tested the data input screens and reports for a total banking system to support the offshore branch and the International Banking Facility (IBF).
  • This system produces financial and regulatory reports. In addition, data entry screens were developed for creating and updating journals and customer information.
  • The above system was developed on the VAX/VMS. SQL*Forms V3.0 was used to develop the input screens. SQL*Plus, PL/SQL, SQL*Reportwriter, SQL*Report and
  • Pro*C were used to develop the reports.

Confidential, New York, NY

Systems Analyst

Responsibilities:

  • Interface with users.
  • Designed, coded and tested the data input screens and reports for the Remarketing Fee System.
  • This system helps the syndicate accountants monitor the firm's fees on secondary municipal issues.
  • This system produces an open receivables, trial balance, monies received report and billing letters.

Hire Now