Objective

Seeking a senior/principal engineer, development or DBA position within an Oracle-driven company.

Credentials

Fifteen years of Oracle experience Master of Science in Computer Information Systems fourteen years of business operations experience including material planning, production planning, and manufacturing.

Professional Experience Technical Services Engineer

Confidential

• Upgrade Technical Services databases from
• Change and customize OnLine Care web application settings and data for customer enhancement requests and application issues. Maintain PL/SQL, SQL, Javascript JS , and XML application components using HTML, Oracle SQL Developer, Eclipse, Subversion SVN , Squirrel, Firefox, Chrome, Internet Explorer, Weblogic, and SwiftMQ.
• Convert IBM ILOG Business Rule Management System BRMS rules to Groovy scripts and implement Groovy scripts in the OnLine Care web application.
• Maintain and create application file feed descriptions for healthcare claims, providers, procedures, diagnoses, substances and other application features.
• Analyze issues/defects and write custom processes to fix production database issues using SQL and PL/SQL. This includes large data changes greater than one hundred million rows , fixing data warehouse refreshes, creating custom tables and indexes to support the change, tuning SQL where needed and working with the DBA team to ensure the change process meets their security, time window and performance needs.
• Set-up and maintain Technical Service application Weblogic, SwiftMQ and Oracle 11.2 database environments.
• Work with software development, quality assurance, project management, release engineering and application hosting teams to implement changes and resolve issues.
• Provide support and train other Technical Service Engineers in Oracle database, PL/SQL and SQL.
• Participate in weekly client support rotation.
• Explore and test application installation automation by removing the application installer, applying/combining configuration information from multiple application versions, and restoring production/staging backups using Recovery Manager RMAN .
• Investigate, document and implement application version changes including configuration, feeds, rules Groovy scripts , and Crystal reports. Attend project sprint meetings and work with Research and Development and Product Management to understand upcoming application changes.
• Define, scope and write custom report and file extracts using Crystal Reports, SQL, and PL/SQL for Marketing, Provider and other teams as needed.

Oracle Database Engineer

Confidential

• Responsible for introducing application change into the Oracle 10.2 RAC Real Application Cluster production databases largest was 40 terabytes including: working with disparate application teams to construct and communicate Oracle database release process standards participating in design and code reviews recommending change where appropriate - including PL/SQL and SQL tuning with application teams across the company approving and deploying new application releases and application change to the production databases. Provide project management for application introduction into production on occasion and mentor developers as needed.
• Work with all levels of management and project managers to understand priorities, deliverables and issues.
• Received a Recognition Award given to employees for extraordinary efforts and accomplishments in October 2009 the award was for project leadership, preparation and coordination of a major deployment effort.
• Design course content and provide training to employees including: PL/SQL training 24-hour class , Oracle SQL training for over 300 employees from all departments in three states from 2010-2012 , and selected to design and provide System Development Life Cycle training SDLC to business groups, including all levels of management up to Executive Vice-President.
• Participate in projects managed using Agile methodology trained in Agile methodology in 2011 and selected to participate in a pilot Agile project.
• Evaluate new Oracle functionality proposed for use in production and make recommendations on usage.
• Introduce and evaluate new client data tools ERwin Data Modeler, Toad, PL/SQL Developer, and Oracle SQL Developer . Test and approve client data tool upgrades and work with server team to develop implementation plans. Track license usage to ensure license compliance.
• Establish and document processes and standards for the Oracle DBA team using Microsoft Visio and Word.

Senior Software Developer

Confidential

• Enhanced and maintained PL/SQL code for an Oracle 10.2 data warehouse seven terabytes application in an Oracle 10.2 Real Application Cluster RAC environment.
• Responsible for all aspects of application change including: writing and reviewing design and deployment requirements coding and tuning application code and schema design creating and executing unit tests suggesting test approaches to Quality Assurance constructing Extract/Transform/Load ETL processes using Oracle External Tables, triggers and PL/SQL packages and building data extracts to publish data for inter-departmental use.
• Supported and assisted other Oracle developers and Quality Assurance personnel as needed.
• Provided development estimates and project status to the project manager and management. Identified project issues as they arise and communicate these in a timely manner.
• Contributed to internal process improvement including: proactively recommending application tuning improvements, assisting in the formation of group standards and process improvements, and encouraging a team effort in working with the Oracle Database Administrators.

Principal Software Engineer

Confidential

• Researched and evaluated Oracle 11.1 and recommended implementation options for clinical trial software products.
• Maintained the Oracle database for clinical trial software products including: tuning application PL/SQL , SQL, and database performance implementing bug fixes in PL/SQL and database documenting software functionality and design using software review and approval processes, and upgrading applications and database requirements for Oracle database version changes. Done in Windows 2000/2003 Server and Redhat Enterprise Linux 3 and 4 AS environments.
• Contributed to the design and introduction of a reporting/data warehousing project into a clinical trial software application using replication Oracle Streams and materialized views. Product was showcased at Bio-IT World and was awarded Bio-IT World Best of Show in the Clinical Trials and Research category in 2005.
• Trained and supported engineering, technical support, quality assurance and product management personnel users, developers and senior management in Oracle 10.2, Oracle 9.2 and Oracle 8.1.7.
• Served as cross-product Oracle person for: SQL and PL/SQL tuning, database performance evaluation and tuning using Automatic Workload Repository AWR and Statspack, schema design questions, Oracle database version upgrade recommendations and guidance, Oracle 10g feature testing and recommendations, cross-product upgrade from Oracle 9.2 to Oracle 10.2, and occasional production support for Oracle issues.

Oracle DBA Confidential Managed

• Taught, assisted and supported Oracle developers with SQL tuning, schema design, and PL/SQL design and develop automated process and scripts for Oracle developers using PL/SQL and packages support developers in ETL and data warehouse activities. Also trained DBA's in Oracle 8.1.7 and 9.2 databases.
• Oracle 8.1.7 to Oracle 9.2 database upgrade project including: RMAN backup and recovery, Enterprise Manager with Management Server and Intelligent Agent usage, Oracle 8i to 9i data migration, document processes, set up test database, and author project plan.
• Managed multiple Oracle 8.1.7 healthcare claims databases including: backup and recovery with RMAN, transportable tablespaces, tuning using Statspack, monitoring, patching, configuring, maintaining, and resource planning on a Windows 2000 Advanced Server platform.

Oracle DBA Confidential

• Managed more than a dozen Oracle 8.1.7 databases 60-300 gigabytes in their entirety, including backup and recovery, tuning, patching, configuration, monitoring, and resource planning in a Windows 2000 environment.
• Supported, taught, and assisted Oracle developers with SQL statement tuning and PL/SQL.
• Provided Oracle technical support to external customers.
• Managed production data warehouse healthcare claims environment for customers.

Oracle DBA Confidential

Oracle 8.1.5 production database in a Sun Solaris environment including backup and recovery with RMAN, tuning, monitoring, patching the database, automating database startup and shutdown, and auditing.

• Provided Oracle support, expertise and assistance for SQL statement tuning, SQL Loader, and PL/SQL.

Senior Oracle Developer

• Enhanced HR benefits administration for external customers using a custom schema design in an Oracle 8.1.5 database in a Windows NT environment mentored up and coming Oracle developers improved custom salary planning application in an Oracle database in a Sun Solaris environment

Information Technologist

• Rewrote legacy database application, converted UK-based manufacturing operation to Oracle, and supported various departments A/R, A/P, purchasing, manufacturing, and engineering using Oracle Manufacturing and Financial applications in a Sun Solaris environment.
• Information Technologist Helped the company to take its first step towards a large-scale, global implementation of Oracle applications.
• Supported Oracle Manufacturing and Financial applications and upgraded global operations from Oracle 10.6 to Oracle 10.7 in an HP-UX environment. Upgrade involved manufacturing and financial applications and affected nearly 1,000 corporate users in North America and Europe.
• Boston to Tokyo. Effort included DEC DBMS database, VMS cluster, and a variety of mission-critical business applications in FOCUS databases and in the ASK/MANMAN ERP applications.
• Provided internal and external customer support for Cellular Management Information System CMIS and FOCUS databases on a VMS platform.
• Served as production planner, material planner, and production team lead.
• Lead and participated in cross-functional Quality Improvement Teams. Leveraged Total Quality Management TQM tools for process improvement.