OBJECTIVE

Seek opportunity supporting software development projects utilizing Oracle/Microsoft database, support data modeling role, coding in PL/SQL package, procedure and function using advanced features, and T-SQL language. Support all phases of the software development life cycle, as well as, provide Oracle DBA support to development, QA and production environment. Support traditional Database Administrator responsibilities that include installation, upgrade, patch, migration and conversion. Possess strong database and application-side performance tuning skills. Experience leveraging Oracle Designer, Erwin and PowerDesigner to create conceptual, logical and physical database designs for OLTP/OLAP application. Experience using Toad, Oracle Developer, RMAN, Export/Import, DataPump, Oracle RDBMS versions 5-to-11g, Oracle Web Server, Oracle Enterprise Manager, and supported projects hosted on SQL Server Studio 2005/2008/2012.

EXPERIENCE

Confidential

Support the role of Oracle DBA developer. 90 of my time is directly allocated to writing ad hoc queries against production Oracle database environment in response to questions from internal business community and development team. I serve operations and development management team on application and database performance tuning matters. I proto-type partitioning scenario against HOPS largest table of 60 Gig and tune all dependency related stored procedure queries. As result of my tuning analysis and findings on partitioning will help guide management to make more informed decisions regarding the proper use of Oracle technology. In my spare time I query data dictionary table for high cost queries, generate SQL explain plans and improve query performance.

ORACLE DBA/SQL Engineer

Confidential

Support role of Oracle DBA and provide PL/SQL development support to multiple scrum teams on HzERM project. Conduct data analysis of HzERM database structures and develop data integrity clean-up scripts intended for deployment at customer sites. Utilize Erwin to review HzERM database design of bed management and other functional areas. Provide on-call support on-rotation and supported Oracle database cloning and upgrade request. Oracle DBA supported daily database build process and upgrade/patch process internally using Oracle PL/SQL and shell scripts. McKesson management team eliminated HzERM business unit in November 2011 that is approximately 6 months after my arrival, and employees given opportunity to transfer to other business unit within McKesson in a narrow time frame or seek employment outside Mckesson. On January 2012, I accepted an opportunity supporting SQL Engineer role on Paragon project. As SQL Engineer I coded database-side using T-SQL to create API layer for the .net and PowerBuilder Web and client-side Hospital systems. Supported Rules Engine project which is a customized rules-based product required to support government mandated initiative to facilitate meaningful use throughout patient care process, while utilizing customized rules stored within a BizTalk database. I developed SQL Audit approach for Auditing PHI data using Broker Service External Activator to propagate messages from a generic trigger that adapts to any table and ETL stored procedures dynamically interact to changing message propagated by table events.

ORACLE DBA Developer/Data Modeler

Confidential

Provide Oracle DBA/development support for multiple scrum teams at Ericsson. Support the design, build and unit test phases of AMS REORG and CONVERTDB utility to facilitate and resolve emergency scenarios that occurred on production AMS servers. Both, AMS REORG and CONVERT DB was coded utilizing a combination of shell scripting and PL/SQL language to extend functional life of black box systems that supported movie-on-demand services. Provide emergency production support to Ericsson most valued customers like Comcast and Verizon. Support application and database tuning of AMS for production customers and development.

ORACLE DBA Developer/Data Modeler

Confidential

Support role of Oracle Database Administrator, Data Modeler and PL/SQL developer for VCG StaffSuite product. Support rapid-iterative development environment, support QA deployment and provide database production support. Support and maintained server-side PL/SQL coding of Vertex, GL packages, GL Predictability, Eligibility, Nightly Processes and Lockbox. Maintain and develop database server-side installer software that is used to support New Install, Upgrade, and Patch process used for development, QA and customer production environments. Develop database-side installer software and appropriate documentation used by VCG support team to upgrade and migrate StaffSuite customers from Oracle RDBMS 9i to 10g 10.2.0.28. Develop and document Oracle backup and recovery procedures leveraging Oracle Export/Import, Oracle Data Pump and RMAN in support of multiple Oracle homes. Pursued best practices and guidelines to identify and improve StaffSuite performance. Significant performance improvements realized through a combination of tuning high cost SQL, re-normalization, indexing, code re-engineering, and proper Oracle database installation and configuration. Support database-modeling task using Power Designer. Power Designer and utilized for generating DDL for physical database and generate application-side persistence layer. DDL is generated for new install, upgrade and patch releases of StaffSuite. Both, DDL and data changes for StaffSuite is carefully managed under software control and well defined proven processes that guarantee consistent and accurate back-end deployment. Support VCG support teams in troubleshooting Oracle database production issues and develop Hot Fixes. Support physical database conversion of StaffSuite from Oracle to SQL Server 2005 and reverse engineering tasks. Support conversion of Oracle PL/SQL to SQL Server T-SQL. Provide development support for SQL Server 2000/2005 and code control process for Pointwing.

Custom Software Development,

Confidential

• Supported Lockheed Martin: February 2006-December 2006. Provide part-time support as Oracle Database Administrator/Data Modeler to Lockheed Martin OASD PA Pentagon project and full-time support from June 2005 - Mid December 2005. Supported Oracle database migration from Oracle 8i and 9i RDBMS servers operating on Solaris and Windows to Oracle 10g RDBMS release 2. Maintain Oracle Forms/Reports applications that support operations for Pentagon Office of Public Affairs.
• Supported EDS/VA My HealtheVet: July 2004 - May 2005. Contract through NEWGEN to provide support for EDS/VA My HealtheVet project as an Oracle Database Administrator/Data Modeler. Supported 8 instances of Oracle 9i that serve development, system test and user acceptance and test environment. Provided routine database maintenance responsibilities, installation, configuration and patching as required. As data modeler, produced logical and physical database design to support information requirements for My HealtheVet project. Supported 100 of back-end development of API using PL/SQL, cron job initiated reporting and synchronization between Oracle and LDAP Directory Server. Facilitated data modeling and JAD sessions provided estimates and supported design and build scripts.
• Supported ProObject in support of FDA DARRTS project: December 2003 - May 2004. Support Data Modeling and Database Engineering role to produce conceptual, logical and physical database design to support information requirements for FDA DARRTS project.
• Supported Nextel IT operations project: August 2003 - November 2003. Provided DBA/data modeling support to multiple projects associated with Telco Data Warehouse. Utilized Oracle Designer to create conceptual, logical and physical database design for multiple data warehousing projects. Engaged on sideline projects installing Oracle 8.1.7 and Oracle 9i RDBMS, Oracle Designer and Oracle Application Server on Windows and Red Hat Linux 2.1 AS.
• Supported USGS supporting BASIS project: August 2002 - May 2003. Provide Oracle development and DBA support with USGS supporting BASIS project. Responsible for day-to-day operations related to achieving software maintenance deliverable goals and customer guidance. Hands-on experience with performance-tuning Application and Database, enhancing PL/SQL Web Modules to satisfy performance objectives, troubleshooting Application, Middle Tier and Database issues, streamline procedures to improve quality control and improve efficiency. BASIS application is based on Oracle PL/SQL Web technology, generated using Oracle Designer, hosted via 9iAS and Oracle 8i RDBMS.
• Supported NFR project: March 2001 - May 2002. Provide Oracle database management and database design support for NFR Security project. Supported installation, configuration and maintenance of Oracle RDBMS version 8.1.7 and Oracle 9i AS operating on Red Hat Linux, Solaris and Windows 2000 Server. Installed, configured, and maintained Oracle Designer 6i and Developer 6i tools utilized for analysis, design and build of Rosie, Vulnerability and NFRDB Enterprise system. Sole responsibility for conceptual, logical and physical database design of Rosie, Vulnerability, and NFRDB Enterprise system. Designed, built and hosted Rosie and Vulnerability web-enabled application 100 generated applications using Designer 6i. Created installation and tuning documentation for NFRDB Enterprise system. Supported typical Oracle DBA responsibilities.
• Supported AT T/GRC International for GCSS-Army project: February 2000 - December 2000. Provided technical lead on Property Accountability application for GCSS-Army. Responsibilities involved analysis, design, and build utilizing Oracle Designer version 2.1.2. Support conceptual, logical and physical database design requirements for Property Accountability. Supported 100 generation methods to generate client and server side build of Property Accountability utilizing Oracle Designer 6i.
• Supported DOA Forestry Service project: May 1998 - December 1999. Supported new development and conversion of Infra application from Data General to IBM. Analysis, design, and build captured utilizing Oracle Designer 2000 version 1.3.2 to support database build and client side functionality to support Miscellaneous Features, Work Items, Asset Management, Capitalization and Leasing.
• Supported RADOS, Inc: February 1999 - February 2000. Supported RADOS, Inc., by providing Oracle DBA support to Nuclear Power customers. Supported Oracle RDBMS installation and configuration to four servers, two Reader servers, and client workstations. Supported installation, configuration of Oracle SQL Net and proprietary application software, and supported performance-tuning responsibilities of database and on-going support to RADOS.
• Supported Orange Systems project: December 9, 1993 - June 15, 1994. Support Orange Systems upgrade of Subscription Management System. Tasked with maintenance and new development of screens and reports using SQL Forms 3.0, Trifox, SQL Operator and Oracle Version 7.0 RDBMS to support the development of Subscription Management System. Development was performed on a SUN SPARCserver MP, SUN OS and XTerm workstations.
• Supported TechForce project: July 1993 - December 3, 1993. Supported Cincinnati Bell Information System CBIS on an Oracle development project for FmHA. Developed the Dollar Analysis Loan Restructuring System DALR and provided support in the system documentation. Development occurred on an AT T 3B2 system with Unix System V, Oracle RDBMS V6, SQL Forms 3.0, PL SQL and SQL Plus.
• Supported National Computer System, Englewood, Colorado, June 1988 - August 1989. Support National Computer System in maintenance work on a Student Loan Portfolio System. Specialized in design, development, and maintenance using SQL Forms, SQL Plus, and SQL Reports. The development platform was a 386 microcomputer operating under SCO Xenix System V and ORACLE RDBMS version 5.

Contracting Experience

ORACLE DBA/CASE Designer, Confidential

• Designed and built an Oracle Web Server application DLAMP . Installed and configured development environment using Oracle RDBMS 7.3.2.3.1, Designer 2000 1.3.2 Database Repository, and Oracle Web Server 2.1 on Windows NT. Leveraged 100 generation from Oracle Designer 2000 tool. Supported role of Web Database Application Developer, and supported 100 of DBA responsibilities. Produced application and installation documentation, plus providing installation support of DLAMP for UNISYS customer.
• Supported The Maxim Group, Rockville, MD. July 1997 - February 1998. Assigned to provide full life-cycle development support for Data Tracking Services, Inc. Tasked to complete a two-to-four month project involving full life-cycle development utilizing Designer 2000 to build client server and Oracle Web Server 2.1 application to support business operations for a start-up company. Installed and configured development environment using Oracle RDBMS 7.3.2.3.1, Designer 2000 1.3.2 Database Repository, and Oracle Web Server 2.1 on Windows NT. Captured and documented requirements of two hundred entities and domains, one hundred plus business functions, and associated CRUD and IRUN during conceptual modeling.
• Supported The Registry, Rockville, MD. November 1996 - July 1997. Contractor of The Registry/SSI, tasked to support OAO development effort of the Fleet Logistics System FLS for US Coast Guard. Developed the quality assurance check list/guide to support OAO's effort to complete analysis. Developed Requirement Management System RMS , which associates Designer 2000 Repository Objects and Properties to CASE Reports and CASE Tools, and their association to customer requirements like Military Standard 498 . RMS provided OAO a standard, a methodology, from which to approach analysis, design and build for FLS. In conjunction with OAO and SSI, I assisted with the development and documentation of OAO's methodology and approach using RMS, as proof of concept.
• Supported Pacific Data Group, Portland, OR. July 1, 1996 - September 13, 1996. Support application conversion from Access to Oracle for Wells Fargo Bank and affiliates. NASCAR system generated vendor route schedule, and instructs vendor on task to perform per stop. My involvement included installation, configuration and Database Administration task associated with Oracle 7.2.2.4 on Windows NT, plus installation and configuration of Designer/Developer 2000 tools for client workstation. Supported analysis, design and build, and produced and maintained conceptual, logical and physical models using Oracle Designer 2000. Responsible for conceptual, logical and physical database design, performance tuning and capacity planning estimates.
• Supported Pacific Data Group, Portland, OR. September 28th., 1994 - April 1st, 1996. Support Standard Insurance Company Retirement Investment Division on Oracle project to provide daily management of equity and guarantee funds - a portfolio management system. Built Unitization Engine and Quarter Close System using Stored Objects i.e. Oracle Procedures and Functions, SQL, PL SQL and Unix Script's . Designed and generated Oracle reports to support auditing and customer financial statements using SQL Reportwriter 1.1. Built debugging tools using Oracle Forms 4.5 and Oracle Reports 2.5. Supported system and integration testing. Development environment represents a mixture of host base and client server technology using MS Windows 3.1 and SoftTerm to interface with Sequent and Mainframe.
• Supported Comsys, Idaho Falls, ID. July 21, 1994 - September 18th., 1994. Support Halliburton NUS on Oracle project developing of a Radiological Data Management System for the Nuclear Power Industry. My role involved design and build of Signature Control Module and Permits Module.
• Supported Comsys/American Management System: May 1992 - June 1993.Support American Management System tasked with Oracle development project for the Saudi Air Defense Force Institute. As senior developer my responsibility involved the development of TARS Training Accessment and Recording System using SQL Forms 3.0 and Oracle RDBMS Version 6.

EXPERIENCE/W2

Oracle DBA

Confidential

Supported Oracle conversion project for the Air Force Office of Scientific Research. Assigned the task of evaluating host based and client server options to support 150 users running Oracle applications and office automation programs. Involved in hardware evaluation process to identify the optimum database server platform for Client Server architecture. Tasked with benchmarking AFOSR data model on SUN SPARCserver 690 MP, Sequent 2000/200, and Pyramid T4 operating under Unix and ORACLE version 6.

Oracle DBA/Technical Lead/Forms and Report

Confidential

Technical lead member of an Oracle development team commissioned to design and develop a companywide integrated computer system to manage cost and scheduling for a major construction management operation. The operating environment consisted of a wide area network supporting four file servers and a database server utilizing Oracle Server for OS/2 version 6.0.31, and ORACLE tools. Supported Oracle RDBMS, Oracle Forms and Reports tool installation and configuration, and developed workstation and file server configuration standards for the organization. Handpicked Oracle development team and performed the responsibilities of Database Administrator, System Administrator, System Designer and Oracle Developer.

Oracle DBA and Forms/Report Developer

Confidential

Developed and implemented Supply Planning System and Gas Operation System using ORACLE Server for OS/2 on a Novell local area network LAN . Operated as System Administrator, Database Administrator and ORACLE developer. Supported installation, configuration, and implemented ORACLE products and applications for workstations and the database server. Supported the development of Supply Planning System and Gas Operation System.

Oracle DBA and Forms/Report Developer

Confidential

Member of an ORACLE conversion team commissioned to develop an information retrieval system for engineers requiring manufacturer of parts information stored as CAD drawings, text and images. Supported hardware and software installation and configuration of terminals, 386 server, SCO Xenix System V, and ORACLE version 5. Performed the duties of Database and System Administrator roles plus development.