SUMMARY:

• I’m an accomplished Oracle DBA/developer with exposure to Oracle’s RDBMS from version 5 to 12c. I possess strong SQL*Plus and bash shell scriptings skills
• Seeking to leverage my wide array of technical and professional expertise to grow as an Oracle DBA/developer for your company

TECHNICAL SKILLS:

DBMS: Oracle v5, v6, v7, 8i, 8i with OPS, 9i, 10g, 11g and 12c

Languages: PL/SQL, SQL*Plus, Pro*COBOL, COBOL, Pascal, SQL*Forms v3.0SQL*Menu v5.0 and SQL*ReportWriter v1.0 and v1.1

DBA Utilities: Explain Plan, Export/Import, SQL*Loader, Utlbstat, Utlestat, PerfstatSQL*Net v1, SQL*Net v2, SQL*DBA, Statspack, ASH, AWR, ADDMActive DataGuard, Export/Import and Expdp/Impdp

OS: DEC VAX/VMS, HP - UX 9.x thru 11.x, Sun Solaris 5.x and Red Hat Linux RHEL7.x

PROFESSIONAL EXPERIENCE:

Confidential, Lowell MA

Principal Oracle Engineer

Responsibilities:

• Provided Oracle application specific SME to other company assets
• Reviewed access policies and Oracle usage as required by the security officers
• Executed performance audits using all available data sources. Resolved any performance issues with Oracle parameter or SQL code changes
• Provided 24 by 7 by 365 Oracle and high level application support for NetNumber’s growing customer base
• Developed PL/SQL scripts, SQL scripts and bash scripts to resolve defects in the company’s product offerings
• Provided training collateral and on-going training sessions for developers and support engineers
• Developer for Oracle based TITAN facilities. These include, but not limited to:
• Database backup
• Iimbedded ad-hoc reporting
• Script maintenance
• Master high availability
• Developed tools and scripts to automate Oracle and application functions
• Aided in the development and review of test facilities to extend QA coverage
• Key contributor of company wide knowledge base for technical information

Principal Database Administrator

Responsibilities:

• Provided technical leadership and direction for up to two other DBAs
• Provided technical leadership to MII Network Operations group members
• Provided support for more than 30 databases world-wide
• Created PL/SQL and SQL*Plus scripts to manipulate data as required
• Drafted company-wide Oracle standards. Including but not limited to naming conventions, PL/SQL best practices, and user access policies.
• Developed and implemented application and Oracle monitoring procedures
• Developed suite of scripts for the networ operations center (NOC) to use in identifying and correcting problems
• Aided developers in upgrading and improving SQL code
• Upgraded hardware, software and database to handle increased throughput
• Aided system administrators in tuning Oracle related kernel parameters
• Provided 24 by 7 coverage for application and database issues
• Developed disaster recovery procedures to different classes of databases
• Developed database and application knowledge base for company use
• Fostered collaborative development environment between developing

Database Manager

Responsibilities:

• Provided technical leadership and direction for two DBAs and three data analysts
• Assisted in the upgrade of 3 production databases Sun E6500 to E10000with limited downtime. Part of the company’s Y2K compliance project
• Developed suite of scripts for the NOC to use to identify and correct problems
• Developed automated data extraction process for QA testing
• Debugged and isolated software and data issues
• Developed application notification software
• Automated data purging procedures
• Provided 24 by 7 coverage for application and database issues
• Developed software suite to compare database schemas

Principal Database Administrator

Responsibilities:

• Provided technical leadership and direction to three other DBAs support15 production databases world-wide
• Lead Administrator for over 20 databases
• Provided technical guidance to developers and users
• Aided in the development of a centralized and decentralized database environment to support multiple character sets and a world-wide sales organization
• Provided 24 by 7 coverage for database and application issues
• Developed and implemented automated scripts to monitor database activity
• Created data monitoring and cleanup scripts as necessary

Senior Programmer Analyst/Database Administrator

Responsibilities:

• Managed staff of up to four developers
• Provide technical and administrative leadership for all software operated bythe company
• Aided in the design, development and maintenance of in-house software suiteto support the company’s requirement. Software suite included but limited toorder entry, sales history and purchasing
• Customized third party software to better suit needs of the company
• Co-developed and implemented an integrated scheduling package
• Provided 24 by 5 application and database support
• Performed Oracle tuning as needed
• Integrated client-server database solution to extend the life of hardware platform
• Migrated Oracle software suite from one VAX platform to another in 30 days

Programmer Analyst

Responsibilities:

• Provide technical support for third party financial software packages
• Aided in the conversion of applications off a DEC platform to an IBM platform
• Developed and implemented an Oracle based ad-hoc reporting system