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

• 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.

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.

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.

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.

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.

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.

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.
• 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.

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.
• 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.

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%.
• 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.

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

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