Mark Norman Email & Phone Number

Colorado Springs, Colorado Area

Oracle DBA Team lead - Cloud Managed Services • Onboarding new clients.• Technical Lead to Core DBA Team • Stabilize new and existing client’s systems• Define DBA Service offering• Establish Standards for Leveraged Services • Establish on call and escalation procedures, 800 service numbers and paging alert solutions. Sr Oracle DBA and Team Lead Centroid 04/2011 to 05/2014Lead DBA at AK Steel and Steel Dynamics • Replaced departing Team Lead and quickly came up to speed to support this environment.• Supporting 46 databases running Oracle V7, 8, 9i, 10g, 11g.• Many opportunities to exercise disaster recovery skills due to aging hardware failures.• Migrated over 40 database from legacy platforms to VM platforms stabilizing the environment.• Responsibilities include designing, installing, upgrading, patching, tuning, monitoring and troubleshooting databases.• Utilized Shareplex for Standby databases• Implemented a new backup solution using EMC Data Domain. • Implemented Oracle Enterprise Manager to monitor all databases.• Managed standby databases.

DBA Team Lead at Hewlett Packard supporting their largest service contract customer. • Team Lead of 4 onshore DBAs and coordinated work for several offshore DBAs.• Upgraded and Migrated databases from one operating system to another. • Utilize AWR reports to analyze Database and SQL performance.• SQL Query analysis and tuning.• Implemented Enterprise Manager to monitor and notify on critical events for 100’s of targets.• Duplicate and restore databases up to 10 Terabytes in size using RMAN.• Disk space analysis and usage tuning for database ranging in size from 100GB to 10TB.• Database upgrades (11g) and patches across test and development systems.• Database migrations from one Operating system to another.• Generate, export and import optimizer statistics to improve performance of queries.• Load production CBO stats into test environments to reproduce production explain plans.• Tune memory parameters to correct buffer cache and shared pool issues.• Troubleshoot and correct database corruption.• Support Goldengate Replication to multiple target databases.

Colorado Springs, Colorado Area

Kincaid was a small company that previously didn’t employ a DBA providing many improvement opportunities.• Provided 24 x 7 support for development, Test, and Production efforts across multiple database architectures including Oracle, Microsoft SQL Server, and MySQL.• Developed an automated process to identify and correct duplicate credit card transactions, which enhanced the company’s offerings and relationships with several key customers.• Developed a web reporting database standard, offloading all reporting from production databases.• Performance analysis and tuning of existing SQL resulting in significantly reduced processing times.• Designed a new database for the Texas WIC program.• Designed a new Corporate Data Model used for all new and existing customers.• Put appropriate backup and recovery procedures in place.• Improved security by implementation of new database roles and users.• Instructed developers in SQL coding methods.• Implemented a process to monitor database jobs and send pages when problems occur.• Developed automated process for updating customer data saving hours of manual efforts.• Cleaned up and reduced file sizes on all databases recovering wasted disk space.• Archived and removed old unused databases.• Work with customers to solve database issues on delivered products.• Designed and implemented new process for credit card settlements to their processors.• Installed Oracle 9i and certified the company’s product on that platform.• Implemented a request-tracking program for all database, IT, Network, QA, and PC requests.

Colorado Springs, Colorado Area

Production and Development DBA for a mixed Oracle and SQL Server environment. Systems and developers where located at locations throughout North America and Mexico. • Provided support for 17 oracle instances and 30 SQL Server databases. • Implemented Oracle OEM to monitor instances thus simplifying on-call administration.• Used Materialized View Replication to create Data Warehouse views of Operational Data.• Implemented Data Partitioning to improve performance and greatly simplify data archival.• Utilized SQL Loader to load and maintain data from ISAM files into a data warehouse which provides reporting capabilities that where previously unavailable.• Applied patches and upgrades to address production issues and increase stability.• Used Metalink and OTN as tools in troubleshooting and correcting Oracle database issues.• Developed DTS packages to migrate data between Oracle and Microsoft SQL Server.• Automated SQL jobs and DTS packages using SQL Server Enterprise manager.• Used SQL Replication to create reporting databases removing reporting load on OLTP systems.• Used Connection Manager to provide access to database behind remote customer firewalls.• Identified poor performing queries and made improvements, reducing run times from hours to minutes.• Programmed stored procedures, triggers and PL/SQL scripts.• Provided off hours support via High Speed VPN access from home office

Colorado Springs, Colorado Area

Data Mart Project utilizing Analysis Services by Microsoft to connect to a Data Mart and build OLAP cubes. This new project required quick learning and implementation of Data Marts, OLAP Technologies and architectures• DBA responsibilities for development and production environments.• Data modeling and implementation of a Data Mart for analyzing marketing data.• Building views to support loading of the Data Mart and OLAP cubes.• Providing Analysis Services Administration.• Developing database upgrade scripts for new releases.• Applying a production paradigm (i.e. backups, passwords, methods, etc.)• Daily Monitoring of production environment.• Review and upgrade of SQL Server database.

Colorado Springs, Colorado Area

Database Architect and DBA for a mixed Oracle and Sybase environment with approximately 40 developers. Responsible for design and maintenance of approximately 12 database instances. • Performed the data analysis, mapping, and development, and execution of the migration strategy which moved the entire audio conferencing systems information from a legacy Sybase database to a new Oracle database.• Upgraded from Oracle 8.0.5 to 8i which improved stability of databases and Name Servers.• Configured Net8 and Oracle Name Server to simplify client PC connections.• Utilized PowerDesigner to design data models and improve communications with developers.• Installed Oracle Enterprise Manager improving the DBA’s productivity.• Used scripts to manage database changes across development, test, user acceptance and production database environments. This method kept the database schemas in sync.• Backed up databases using SQL Backtrack to ADSM storage, reducing disk space used by backups.• Programmed stored procedures, triggers and PL/SQL scripts.• Improved Security by implementing roles and synonyms.

Colorado Springs, Colorado Area

Database architect and Unix Systems administrator for a three-tier intranet based reservation system written using Java applets, Java RMI, and Sybase database products.• Designed and implemented a database to replace legacy non-relational database. Required analyzing, mapping, and migrating data to and from the legacy database to support conversion and existing interfacing applications.• Designed and implemented a warm standby replicated database to insure this mission critical database was always available.• Created and Maintained Logical and Physical data models to facilitate communications with developers and management.• Created and managed development, test, and production database environments.• Implemented a production paradigm across all development and production servers.• Designed and implemented a database to support RSVP system for external customers.• Installed Oracle 8.0.5 on Linux and prototyped data migration methods from Sybase to Oracle.

Colorado Springs, Colorado Area

Lead DBA for a client/server implementation involving multiple large midrange RDBMS servers. The system processes call records for the company’s long distance call traffic and prepares the information for billing and decision support activities. The project lacked a “production paradigm” so the primary task was to stabilize the environments.• Installed and configured 20 Sybase Adaptive Servers, Replication Server, Open Client, Backup Servers, SQL Monitor, and SQL Server Manager. • Compared all databases across development, test and production identifying and correcting database objects that where out of sync, resulting in fewer defect reports from users.• Implemented configuration management of all database objects reducing the possibility that incorrect database objects would be placed in test or production databases.• Stabilized database environments by implementing and automating backup procedures.• Coordinated migration of all database objects through development, test, and production.• Used ERWin to maintain Logical and Physical data models. The printed models improved developer understanding of the database and improved SQL coding productivity.• Implemented Replication Server to create a data archive/data warehouse, reducing the reporting impact on the OLTP system.• Automated startups, and shut down of all server products allowing database to shut down gracefully when the systems are shut down.• Assisted developers with Stored procedure and Trigger coding which later turned into coding standards.

Wichita, Kansas Area

DBA and UNIX Systems Administrator for a distributed database client/server project involving SUN UNIX midrange, IBM AS400 mainframe, UNIX and NetWare database servers, and Windows PC clients. The system was designed to replace 1400 legacy store systems with UNIX servers running Oracle databases with windows clients. Stores replicated data with a data warehouse at the corporate office. • Installed and supported Sun SparcServer and Solaris X86 servers. • Installed and supported Oracle 7.3.4 servers on UNIX and NetWare platforms. • Installed and supported Oracle AS400 Gateway and other Oracle and Sun software. • Implemented a database development environment and set standards for database objects. • Automated backups, startup, and shutdown of all server products. • Participated in UNIX vendor selection process, required review of all Vendor RFI’s.• Implemented configuration management using PVCS to control all database objects, PL/SQL scripts, and UNIX shell scripts. • Coordinated migration of objects through development, test, QA/QC, and production environments. • Introduced data modeling tool to maintain logical and physical data models. • Configured SNA LU6.2 communications with AS400 mainframes. • Recommended and implemented XTERM for windows to improve programmer productivity.• Developed and presented two UNIX fundamentals classes to development staff who where new to the Unix environment.

Colorado Springs, Colorado Area

DBA and Systems Administrator for a client/server implementation involving dissimilar RDBMS’s residing on midrange and mainframe platforms. The system provided order entry functions for services representing nearly 80% of MCI’s gross revenue and would support several thousand users at hundreds of sites nationwide. • DBA and UNIX System Administrator for Sybase SQL Server implementations. • Installed and configured 7 Sybase SQL Servers, 2 Sybase open Server/C Servers, 5 Net Gateway for CICS Servers, 3 Mainframe Client Gateways, 2 Backup Servers, SQL Debug, SQL monitor, and SA Companion. • Stabilized development environment, which had no backups, and lacked a “production paradigm”. • Automated backups, startups, and shutdown of all server products, resulting in servers that nearly never need to be recycled for any reason. • Installed production HP9000 hardware and software in production data center. • Provided System Administration for Sybase Net Gateway mainframe connectivity server.• Implemented the use of HP LVM (Logical Volume Manager) to simplify the installation and maintenance of SQL Server raw volumes on the HP9000 platform. • Implemented configuration management in a UNIX environment to control all database scripts. • Coordinated migration of all databases objects through development, test, and production. • Maintained Logical Data Model that generates Sybase schema and physical data structures. • Configured SNA Plus for HP-UX for LU6.2 connection to IBM Mainframe. • Programmed stored procedures and triggers used to train developers in Transact SQL.

Wichita, Kansas Area

Manager Database and Languages group • Managed Database and Languages groups. A hands on manager responsible for energizing and enabling a staff of 10 employees in various tools, languages, and databases used for software development. • Implemented the company’s first RDMS platform which then became the standard database.• Replaced an existing database computer with a system running Sybase on Sun hardware resulting in significantly reduced cost of operations. • Researched and developed the company’s first client/server applications utilizing SQL Server and Powerbuilder. • Implemented code inspections to provide early defect detection resulting in higher quality and 50% fewer defects in inspected code.Lead Database Analyst • Responsible for the stability and reliability of the company’s relational databases. • Designed, implemented and supported SQL Server databases on SUN 690, SUN SC2000, and Windows. • Developed triggers to support database integrity.Senior Systems Programmer• Implemented and maintained a new Message Control System that became the new standard for all online Cobol systems.• Provided technical support on databases, COBOL, and on-line systems to 60 programmers.• Developed utilities and libraries.• Installed new system software.• Evaluated and recommending new software solutions. • Designed and provided training classes to all new programmers.Lead and Senior Programmer• Responsibilities included: analysis, development and maintenance projects including two accounts payable systems, an OSHA hazardous materials reporting, and a major maintenance project for a work order account system.

Wichita, Kansas Area

Provided pre-sale and post-sale technical support to 16 marketing representatives across Kansas and Oklahoma.• Performed demonstrations of mid-range and mainframe hardware running various commercial and banking software.• Created proposals and responded to customer RFI’s.• Obtained two Legion of Honor awards for outstanding achievement, World Wide Legion of Honor was the highest award available in the company

Bachelor’S Science & Business, Management Information Systems

Associate'S Degree, Information Technology