Sr. Database Administration / System Analyst / Sr. Programmer Analyst/ GIS Coordinator

OVERVIEW

Offering 18 years of outstanding system, application and database experience, with superior customer, technical, and maintenance support. Motivates subordinates and team members with strong organizational and effective communication skills. Consistently increasing knowledge of system, application and database systems, with the experience and training required to effectively perform as a Database Administrator, System Analyst, or Sr. Programmer Analyst for Oracle, Sql Server, Unix, Windows 2000/2003, and a multiple array of applications.

IT EXPERTISE

• Databases: Oracle, Sql Server 2000, 2005 2008, Informix
• Software: PL/Sql, TSql, C Programming, VB, Creating scripts. Supporting, designing, and
• troubleshooting several vendor applications. ODBC, GIS ESRI including ArcMap, ArcCatalog, ArcIMS , Netware, Windows 2000/2003, NT, Unix SCO and AIX, Crystal Reports, XML, Reporting Services, SSIS Packages, DTS Packages.
• Applications: CCG/Faster Fleet Maintenance , RTA Fleet Maintenance ,
• Recware Recreation , Permits Plus Building Permitting , IVR Selectron Voice Response System , AccelaGIS GIS interface with Permits Plus , GIS/ESRI GIS Software , Hansen Water/WasteWater System , Sire Electronic Document Storage , STARS Risk Management , Address Engine Address Warehouse App , JD Edwards, Gasboy Fuel Management App , IFAS/Bitech Financial App , ArcIMS Web Interface for GIS

SIGNIFICANT ACCOMPLISHMENTS

DATABASE ADMINISTRATION

• Migration of SQL Server 2000 databases to SQL Server 2005, including DTS Package migration to SSIS.
• Implementation of Reporting Services
• City-Wide Implementation and continued support of a GIS City-Wide System, including Address Maitnenace.
• Successful migration from Oracle 9i to Sql Server.
• Successful migration from Oracle8i to 9i on a Unix platform.
• Migration or Oracle 8 databases to 8i.
• Full installation/ implementation of Oracle 8i on a Unix platform and implemented GIS database.
• Migrated Oracle and Access databases to Sql Server 2000.
• Migrated Sql Server 7 database to Sql Server 2000.
• Installing/supporting a Sql Server 2000 Clustered Database Environment
• Maintaining and Administering Backup/Recovery Process on Oracle and Sql Server using RMAN and Tivoli.

SYSTEM ADMINISTRATION

• Installation of Tivoli Data Protection for Oracle and SQL Server.
• Create and monitor scripts on Unix relating to Oracle databases.
• Create and monitor security for users on Unix.
• Monitor processes and jobs.
• Monitor backup and recovery.
• Create filesystems and volume groups and monitor.

SYSTEMS ANALYST/PROGRAMMER

• Project Management for Implementation for Teleworks System.
• Project Management for Coordination of GIS Implementation and ongoing projects.
• Project Management for Implementation of Wireless/Mobile Module for Hansen Water/Utilities Application
• Project Management for Address Engine Application.
• Project Management and Implementation for AccelaGIS and Accela Wireless.
• Project Management for several new applications Risk Management, Public Works, Community Development, Fleet, Recreation, Electric, and Water, GIS/Addresses, Imaging
• Full system development life cycle of several applications over the last 13 years.
• Continue support of applications including designing, debugging, training, and technical support.
• Support and implementation of several department for our Image Scanning/Management System Sire/Alphacorp , includes interfaces with ISeries Financial System for Treasury, A/P, and Sales Tax.

OTHER ACCOMPLISHMENTS

• Received high scale ratings by superiors for technical abilities and troubleshooting skills.
• Commended by management for excellent customer service skills and persistence on difficult projects with critical deadlines.
• Commended by management for excellence in taking on new projects/applications with no previous experience and moving forward with them to implement and deploy to the rest of the city. ex. GIS/ArcIMS

PROFESSIONAL EXPERIENCE

Confidential

Sr DBA

Currently one of 4 DBA's that support the Production databases. I support all the databases for the company, along with working on the migrations and upgrades of various large databases. These migrations include moving databases, logins, files etc from one site either Clearwater to/from Kansas City. I also perform daily maintenance and tasks for all databases, including but not limited to, backup and recovery full and transactional for a point in time restore , replication for our reference databases, so we have these databases available for reference across various data sites , data migrations, daily update tasks for data, updating statistics, dbcc check, Performance Monitor, maintenance plans,etc. I also work with Reporting Services and create and support SSIS packages.

Confidential

Sr DBA - Contractor

• A Contractor employed by A-Tek to work on a Project for the USDA NRCS Division. I was the SR DBA for the Production Operations Team. I worked on migrations of large databases/applications to a site in Kansas City. These migrations include moving databases,
• logins, files etc from our Fort Collins site to another data center off site. I also perform daily
• maintenance and tasks for all NRCS databases, including but not limited to, backup and recovery
• full and transactional for a point in time restore , logshipping to be able to create a Failover site if needed , replication for our reference databases, so we have these databases available for
• reference across various data sites , data migrations, daily update tasks for data, updating
• statistics, dbcc check, Performance Monitor, maintenance plans,etc. I also was the DBA responsible for the implementation of MS CRM implementation for the USDA to track contracts, etc.

Confidential

Owner/Administration

• I sold this company before I moved back to Florida. I was the owner of this company. We do service and new installation of Residential and Commercial Heating and Air Conditioning in all of Northern Colorado.
• Administer all business duties. Accounts Payable, Receivable, Payroll. Hire of new employees, estimates, etc.

Confidential

Sr. Database Administrator

• Migration of GIS System and Hansen Water Management System from Oracle 9i to Sql Server 2005 in a cluster environment/vmware environment.
• Migration of all applications/databases from Sql Server 2000 to Sql Server 2005 cluster environment/vmware environment.
• Implement a City wide Address Engine Warehouse and application to maintain city addresses and interface with other applications in the city .
• Extensive use of DTS packages. Utilized these packages to migrate data outside of SQL Server and within SQL Server. Built packages to interface SQL Server data to other databases such as DB2 AS400 Systems, Workers Compensation payments and moving financial data from several departments to the City Financial System for General Ledger and Accounting purposes. , and Oracle Systems as well as gathering data to send to outside sources ACH payments .
• Backup/ Recovery using SQL Server and Tivoli. Full and Transactional backups for point in time restores.
• Tuning of databases with SQL Server including rebuilding of indexes and daily maintenance such as update statistics and dbcc check.

Confidential

Programmer/Analyst

I coordinated various projects, a financial project, IFAS BiTech Software, supporting the application, maintaining the system and troubleshooting, also implemented for several agencies, a fleet maintenance project, FASTER C/S CCG Systems, Inc., full implementation for this project, support of the application, and maintaining the system. I worked with Oracle and Informix database. Programming languages such as Oracle, SQL, and 4GL. The majority of my work involved a Unix server, but we also ran a Windows NT server and a Novell server.

Confidential

Computer Operator I Working Title: Programmer/Analyst

• performed detailed programming, designing/implementation, and troubleshooting of all files for a combination of departments. I performed new installations of hardware and software. I have detailed knowledge of XENIX and UNIX Operating Systems, along with detail knowledge and training of FilePro Plus 16 4.1 . I also have experience working with Novell Netware and Win 95. I have also worked with an AS400 system and have done basic troubleshooting for the system printer connection and display connections . I have working knowledge of Basic Programming and C . I have detailed experience using Microsoft Office, Windows 95, Windows 3.11, DOS, and several other software packages.
• have detailed knowledge of a XENIX and UNIX Operating System, along with detail knowledge and training of FilePro Plus 16 4.1 . My basic job duties were receiving invoices, issuing Purchase Orders, inventory control, performing year-end inventory count, and detailed programming and designing of all files for a combination of departments.
• was a temporary employee. I operated a Radio Shack TRS80. I entered invoices, received and issued parts and performed some programming.
• was a CBE student full-time student and working part-time which was approved by the school and was included in determining my grade for the year. My general job duties included entering parts received from invoices, issuing parts from repair orders and work orders, and control over inventory for Vehicle Maintenance, Mechanincal Equipment Repair, and Industrial Equipment Repair Departments. I also answered an eight line phone, typed memos and