Database Administrator Sql Server

--EXPERIENCE--

October **** - Present City of Fort Collins

Fort Collins, CO

Position: Senior Database Administrator – Oracle, SQL Server

As a Database Administrator, I managed and administered Oracle and SQL Server databases, including installation, schema changes, and RMAN-based backup and recovery. I supported JDE EnterpriseOne, GIS, Sire, and Fleet management systems, ensuring optimal database availability and performance. My responsibilities included monitoring and optimizing database processes, installing and patching Oracle software, and tuning Oracle instance components like SQL and PL/SQL. I approved and controlled production schema changes, conducted capacity planning, and provided technical troubleshooting and consultation to development teams. I also interfaced with Oracle Corporation for technical support and handled multiple SQL databases, focusing on performance tuning, data integrity, and optimizing SQL code performance. My experience includes working with Oracle Database Appliance (ODA), Real Application Clusters (RAC) 12c, and Exadata 18c.

I was the architect responsible for migrating 30 Oracle database instances from versions 12c and 18c on various platforms (Windows, ODA, Exadata) to Oracle 19c using the new CDB and PDB technology.

March 2006 – October 2007 SIEMENS Power Generation Inc.

Charlotte, NC

Position: Senior Database Administrator – Oracle, SQL Server

As a Database Administrator, I managed Oracle database administration tasks, including installation, schema changes, backup, and recovery. I provided support for Auto Time software, generating reports for HR and Accounting, and assisted users with software installation and upgrades. Additionally, I configured Auto Time for optimal performance and supported SQL Server 2005 databases and related applications.

Nov 2005 – March 2006 DexMedia

Denver, CO

Position: Database Administrator (DBA Consultant)

As a Database Administrator, I handled Oracle Database Administration procedures for versions 8i, 9i, and 10g, including installation, schema changes, tablespace management, user security management, and memory and disk space management. I performed database tuning, monitored backups using RMAN and SQL-BackTrack, and ensured overall database performance and security.

July 2004 – Sept 2005 Ciber

Commonwealth, NY

Position: Database Administrator (DBA Consultant)

As a Database Administrator, I managed Oracle 9i Database Administration procedures, including installation, schema changes, tablespace management, user security management, memory, and disk space management. I performed database tuning using StatsPack and created detailed reports for Disney to optimize their data warehouse database, including table partitioning. I provided support for Xerox Capital on the Oracle 9i database for a data warehouse project using Oracle Enterprise Manager. I designed and built a data mart for the billing system using Informatica, gathering user requirements and writing reports based on those needs. Additionally, I created new tables and views for developers, managed database backups using SQL-BackTrack, and handled the creation and management of users and Oracle schemas, including import and export operations using OEM.

March 2004 - July 2004 American Management Association

Saranac Lake, NY

Position: Database Administrator (DBA Consultant)

As a Database Administrator, I managed Oracle 8i and 9i Database Administration procedures, including installation, schema changes, backup and recovery, tablespace management, user security management, and memory and disk space management. I administered Oracle APPS 11.0.28 and handled the installation and support of 9iAS and 10g. My responsibilities included supporting Oracle Apps 11.0.28, addressing concurrent manager errors, and cleaning up pending CM processes. I moved and compiled packages, SQL, and forms from test to production, and was responsible for starting and stopping all Oracle processes. By utilizing StatsPack, I improved the performance of production and test databases. I also managed the migration of production databases to test environments and reconfigured app profiles. Additionally, I maintained support for Oracle Apps in training and development environments, refreshing them from production. I provided support for the AMA data warehouse Epiphany, handled database recovery and backup using RMAN and SQL-BackTrack, and managed database security and connectivity across different servers.

June 2000 - Feb 2003 Great West Life

Greenwood Village, CO

Position: Database Administrator (DBA) & Unix Solaris System Administrator

As a Database Administrator, my key responsibilities included managing Oracle databases (versions 7.3 and 8i) with tasks such as installation, schema changes, backup and recovery, tablespace management, user security, and memory and disk space management. I provided 24x7 on-call support throughout the year and managed 8 production databases and 3 development databases on Sun Solaris UNIX using Oracle Enterprise Manager and TOAD. I configured disk raw devices in UNIX for Oracle installation and maintained Oracle Forms 6i and Apache Web Servers. I supported Oracle Apps 11.0.28, addressing concurrent manager errors and cleaning up pending CM processes. I was responsible for moving and compiling packages, SQL, and forms from test to production, and managed all Oracle processes. My role involved working directly with programmers and users to ensure optimal performance, creating SQL scripts to automate repetitive tasks, and administering databases ranging from 20 to 100 GB. I performed data migration using Oracle SQL Loader, maintained a stable production environment, monitored performance, and conducted performance-tuning tasks. Additionally, I handled Solaris system administration duties, including monitoring the operating system, managing disk space, and performing hardware upgrades and user administration.

July 1995 – June 2000 Denver Water

Denver, CO

Position: Database Administrator (DBA) / Senior Analyst

As a Database Administrator, my key responsibilities included supporting and managing Oracle databases (versions 8.05 and 7.3) and overseeing 16 production databases in a Microsoft NT 4.0 environment. My duties encompassed database installation, development, backup, recovery, and ensuring database integrity. I provided JD Edwards software support, addressing issues at the client/server levels, tuning system and database performance, and handling modifications and software installations. I utilized Oracle Enterprise Manager 2.4 for database management and gathered business requirements to support data warehouse development. I conducted data quality studies, focusing on data cleansing and transformations, and used Informatica PowerMart ETL tools. Additionally, I developed and administered the Denver Water data warehouse and designed and created an internet/intranet site using MS FrontPage 98 and MS Visual InterDev for database connectivity. I administered and maintained all security aspects of MS IIS 4.0 on NT 4.0 servers and designed and developed key applications using Microsoft Access 7.0. I also administered and maintained SQL Server for six months, including installation and configuration.

July 1995 – June 2000 Metro Transit System

Seattle, WA

Position: Information Systems and Business Process Analyst

I was responsible for the support, maintenance, and enhancement of Timetable and Bus Stop Systems using Ingres Windows 4GL. I converted the APC system from Interact/EXEC to TSO/REXX and applied my knowledge of transit business processes and architecture. I conducted needs assessments, recommended solutions for efficient manual and automated workflows, and designed, developed, and tested program solutions. Additionally, I evaluated and recommended computer tools for both client and analyst use.

July 1995 – June 2000 Prairie State Life Insurance Company

Seattle, WA

Position: Computer Operator / Programmer

As a Computer Operator for the Wang VS/7310, my duties included periodic backup and restoration of data files, generating and running batch files, and troubleshooting and installing printers, terminals, and personal computers. I developed business programs in COBOL and provided modification and maintenance support for agent claims systems, user menus, billing, new business, and cancellation systems.

--EDUCATION—

May 1988 Mesa State College

Grand Junction, Colorado

Bachelor of Science, Computer Science

--PROFESSIONAL COURSES--

July 2000 Developing Oracle 8i PL/SQL Program Units; Oracle10g SQL and PL/SQL

Denver, CO

February 2000 Oracle8i Administration; Oracle10g Performance Tuning;

Oracle8i Backup and Recovery

Denver, CO

May 2002 Fundamentals of Data Warehousing

Denver, CO

June 2008 Solaris UNIX System Administration

Denver, CO

April 2013 Operating Systems: Unix Sun Solaris 8, Windows NT, MS Windows, ODA,Linux,VMS.

Denver, CO

January 01-13’ Databases : ORACLE 11g, ORACLE 12C ODA-RAC, SQL server 20012 - 20016

Denver, CO

Contact this candidate