Tim Vernon Email & Phone Number

Oracle & SQL Server database administration.

Huntsville, Alabama, Us

Responsible for designing, planning, implementing, and administering of Oracle and SQL Server databases, including hardening, access, and documentation. Responsible the installation, configuration, administration and management of all Oracle and SQL Server processes, including monitoring of database health and performance, to ensure high levels of performance, integrity, availability, and security. Perform requested changes, updates and modifications to database structure and data ensuring technical modifications do not adversely affect database integrity, stability and system availability. Monitor and optimize the performance of the production databases. Perform scheduled and nonscheduled database backups ensuring all database servers are backed up in a way that meets the organization's Recovery Point Objectives (RPO) and test backups to ensure Recovery Time Objectives (RTO) are met. Identify and troubleshoot database issues and the ability to analyze, design, build, test and implement solutions. Mitigate vulnerabilities by ensuring databases have the latest Defense Information Systems Agency (DISA) STIGs and most recent security patches applied. Expert understanding of Structured Query Language (SQL) and Transact-SQL (T-SQL). Experience with virtual environments (VMware/Hyper-V).

Alexandria, Virginia, Us

Provide application life cycle support for the Modification Management Information System (MMIS). (Army Regulation 750-10) The MMIS tool is written with ASP Classic, JavaScript and VBScript. The database used for MMIS is Microsoft SQL Server 2008 R2. Duties include software modifications, database administration tasks, and deployment of application documentation.Perform analyses, development and evaluation of Oracle databases and applications which includes unified data modeling, database modeling and design, relational database architecture, application architecture, metadata and repository creation, and configuration management. Use data mapping, data mining and data transformational analysis tools to design, develop and maintain Oracle databases. Responsible for the preparation of system requirements, source analysis, process analyses, design, and continuous improvement throughout the life cycle of the Logistics Integrated Warehouse (LIW). Serve as administrator and developer for the Class VII Assets dashboard project for the United States Army Materiel Command (USAMC) Logistics Support Activity (LOGSA) using SAP™ Business Objects (BOBJ) Enterprise XI. Assist in the development and administration of the Class VII Assets universe using Universe Designer. Develop reports using SAP™ Business Objects Web Intelligence, SAP™ Crystal Reports and Xcelsius Enterprise for the Class VII Assets dashboard. Create Query as a Web Service (QaaWS) objects to connect warehouse data to the reports on the Class VII Assets dashboard. Manage ORACLE databases in support of the US Army's Integrated Logistics Analysis Program (ILAP), a logistics automation application used to analyze Army maintenance, supply, and financial legacy data. Responsibilities include data integrity checks, administration, configuration, maintenance and analysis of ORACLE and PL\SQL database objects, processes and procedures running on the individual servers across multiple networks.

Albertville, Alabama, Us

Developed HR Performance Appraisal and Merit Increase application with Oracle Forms and Reports 10g. (This project was a 2005 Progress Rail Services Excellence Award Winner.) Provided Oracle Internet Directory (OID) 10g administration. Installed and setup Oracle Application Server 10g on Linux Servers. Provided Oracle Discoverer 10g administration and report development. Provided support during annual employee appraisal period. Provided end-to-end hardware, Linux and Oracle database administration support.

Responsible for the development, deployment, and support efforts for the United States Army Corps of Engineers' Financial Management System (CEFMS). Developed applications and reports with Oracle Forms, Oracle Reports and Procedural Language (PL)/Structured Query Language (SQL). Created stored PL/SQL procedures and functions. Performed runtime improvements on existing packages, procedures, functions and PL/SQL.

Chicago, Illinois, Us

Developed Oracle Application Express (APEX) applications for data collection and managerial reporting. Created stored PL/SQL procedures and functions. Performed runtime improvements on existing procedures, functions and PL/SQL. Develop applications and reports with Oracle Forms, Oracle Reports and PL/SQL. Installed and setup sixteen Oracle 10g R2 and 11g Databases on Linux and Windows servers. Executed and monitored production applications that create primary revenue for department. Provided primary database administration support for Huntsville office.

San Jose, California, Us

Performed Web Administration duties on Oracle Application Server 10g for Business Intelligence team. Project lead for the upgrade to Oracle Discoverer 10g (9.0.4) from previous releases. Primary contact for Worldwide Field Information Technology (IT) group to resolve Oracle software problems on Microsoft Windows platforms. Worldwide system administrator for Oracle Discoverer and Business Intelligence reporting using Oracle Business Objects and Noetix Views. Created standardized reports using Oracle Discoverer, Oracle Reports, and PL/SQL. Obtained Oracle Developer Certificate from University of Alabama Huntsville. Provided primary support for implementation and ongoing use of GEAC Computer Corporation, Ltd (GEAC) Accounts Payable: Millennium (AP:M) and Accounts Payable International (API:M) for SCI’s North American, European, & Asian divisions. Project Lead for AP: M 5.15 beta site testing. Responsible for check reconciliation for the North American division. Member of the GEAC Customer Committee for the 2001 & 2002 GEAC Alliance.