DATABASE ADMINISTRATOR

Experienced with Oracle and SQL Server on diverse hardware platforms Intel, Sparc, IBM using Linux, Unix, and Windows operating systems. Experienced with Dataguard, RMAN and 11g Grid Control and is a an ORACLE Certified professional.

Expertise Highlights

Professional Experience

Confidential

Contractor

• Installation, Maintenance and Performance Tuning of Oracle 11gR2 and SQL 2008R2 databases.
• Used Oracle Enterprise Manager Performance and Diagnostic packages to determine the source of performance issues and provide recommendations for resolution for an workflow system that was having numerous performance issues.
• Consolidated Internal Claims System ICS application that was spread over 5 instances on 3 servers to provide improved performance and maintainability.
• Implemented databases for several applications including Chat With Sales, Rate Pages, Property Valuation Guide, Marketing Ad Review and ArcSDE Spatial database .
• Upgraded several databases/schema on HP servers using Oracle 10g to Linux and Oracle 11g.
• Wrote a fix to Lisa 6.1 performance documentation report cleaner function. The results were sent back to the vendor who in turn sent them as a fix to other customer sites.
• Created a script using Bash and Expect to allow the mass change of the Oracle linux account across several hundred servers.
• Performed on-call support during business hours relieving the full-time staff of handling issues along with their project work.

• Database Administrator with primary responsibility of over 50 applications hosted on various databases and servers including Windows Cluster configurations. Also assisted in the administration of several hundred applications that other Database Administrators were responsible.
• Installation, Upgrade and Performance Tuning of Oracle 9i-11g and SQL Server 2000-2008 databases.
• Implemented Oracle 11g Grid Control for all Oracle application within the Enterprise.
• Implemented Dataguard on an Enterprise wide Inpatient and Outpatient Pharmacies and Emergency Department.
• Improved performance of a vendor supplied application by splitting the application databases across two servers. This took the application from being unusable to fully functional.
• Ability to provide and interpret explain plans and statpack reports, provided recommendations for improved performance on queries.
• Implemented interface routines to allow Microsoft SCOM to display messages and status for a Sql Server on the Xymon system monitor used by several teams.
• Implemented interface routines to allow Gird control alerts to be display within Xymon system monitor.
• Developed policies, standards, and procedures for the use of RMAN backup utilities, Automated Storage Management and Grid Control 11g.
• Worked with Oracle Metalink Support to debug a serious ongoing issue withing our GI Laboratory system. Handled the Oracle portion of the debugging effort from filing of the initial service request through resolution of the problem over a period of several months.
• Worked with several vendors McKesson, 3M, Stemsoft during initial assessment through installation of their applications.
• Assisted with server sizing to determine the layout and physical sizing of the database disks on AIX, Linux and Windows systems. Determined growth rates for the databases and assisted the application team in the acquiring additional storage.
• Was the unofficial reference for information on Oracle Dataguard, ASM, RAC had classroom training, no practical experience and Grid.
• Developed watchdog routines for keeping the Oracle Listener and Grid agents running. Improved the routines when a bug in the listener was discovered caused a listener to hang.
• Created a process and procedures to get backup status information from a windows server to display on the Xymon server. Modified the procedure to handle RMAN backups as well as TSM via scheduled process backups.
• Developed a procedure to refresh the Outpatient Pharmacy test databases via transportable tablespaces and SQL.
• Worked with the Windows System Administrator to diagnose a performance problem with SQL Server after an vendor upgrade. Using SQL Profiler, The system administrator and I determined that the problem was a memory constraint in the server 4GB of memory which was causing SQL server to page out its cache.
• Hired initially as the Database Administrator for the Medical Chart Information System MCIS implemented in Oracle 6.0 through 7.3 on Sun hardware and Solaris operating system.

Technical Engineer

• Assisted in the creation of the Fleet Material Services Office FMS0 Introduction to Oracle 7.0 training course.
• Designed a sample application using SQL Forms and SQL Reports.
• Created student laboratories and provided instruction on the creation of and modification of forms and reports using Oracle tools.

Senior Database Administrator

• Tested FIPS 156 compliant repository and data dictionary system using Sybase consisting of testing, networking, communications, conversion routines, data linkages and security for the Air Force Mobility Command at Scott Air Force Base, Illinois.
• Implemented the application developed policies, procedures, and repository database system upkeep utilities on a SunCenter 2000 running Solaris 2.3 operating system and Sybase 9.2 RDBMS.
• Created process and data models for the repository using IDEF tools and methodology.
• Database administrator for the project.

Senior Member Technical Staff

• Analyzed present and future command and control systems to standardize data elements.
• Created standard data representations for the information used in the systems.
• Functioned as the Systems Administrator for the DEC 5000/200 Ultrix 4.2 Platform and Database Administrator for the command data dictionary.
• Maintained the Data Dictionary and the Data Repository Software systems on VAX/VMS and Ultrix systems using APT Workbench, Transact-SQL, and Data Workbench VMS and ULTRIX .
• Customized and Installed the Data Dictionary application on a Sun Workstation.

Computer Programmer/Analyst

Modified an IBM/VMS General Ledger package for the IRS in Detroit. Maintained the program using JCL, TSO, ISPF/PDF and Panvalet.

Database Administrator/Analyst

• Database Administrator/Analyst for the Military Airlift Command Global Command and Control Database Logistical Model.
• Analyzed present and future command and control systems to standardize data elements used by the systems to present the elements in a database model usable by all command systems.
• Functioned as the Systems Administrator for the VAX 3900/VMS 5.23 platform running the command data dictionary.
• Designed an application using SYBASE, APT Workbench, Data Workbench, and Transact-SQL to implement a temporary data dictionary until the command data dictionary was finished.
• Investigated and resolved questions between several current command systems and a new system being added to support Operation Desert Shield/Desert Storm.
• Modeled the Logical Data Model with Excelerator CASE tool V1.9

Technical Staff

• Developed software and documentation for the UH-1 Huey helicopter civilian refit project.
• Senior Member Technical Staff/Application Integrator/Team Lead
• Team Lead for a staff of two Programmers and a Programmer/Analyst for the Advanced Computer Flight Plan ACFP Project.
• Developed a queuing display/adjustment system that allowed multiple requests to be processed, and their priorities reviewed and adjusted within the VAX/VMS batch queues.
• Developed standard application interfaces in FORTRAN for use in INGRESS applications by forms and FORTRAN applications software in VAX/VMS
• Acted as Assistant System Manager and Assistant Database Administrator for the project.
• Formulated and implemented system policies regarding code management administration and user access rights.
• Administered a Novell Netware 286 Ethernet network for the entire office.
• Member of the Technical Staff
• Using STRADIS methodologies and related CASE Tools, created processes for the Airlift Services Industrial Fund Project.
• Designed and coded application and support routines using C, COBOL, and ORACLE rdbms and utilities.
• Resource for answers and assisted team members in developing Oracle 5.1 A Sql Forms and User Exit routines.
• Administered the development local area network.
• Designed a C program to accept a username and password combination and save it in the MS-DOS master environment for reference by other applications.
• Associate Member of the Technical Staff
• Performed systems analysis using STRADIS Methodology
• Performed database normalization and optimization of data stores related to the Airlift Management Briefing component of the ASIFICS Budget System.
• Developed a prototype of the ASIFICS Accounts Payable and Receivable subsystems.
• Developed applications based on specifications using ORACLE 4.1 on a Honeywell DPS/95.
• Functioned as technical focal point for ORACLE SQL questions and guidance.