We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

5.00/5 (Submit Your Rating)

East Brunswick, NJ

Hire Now

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
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship