Stephen Babb Email & Phone Number

Oklahoma City, Oklahoma Area

Responsible for knowledge and proficiency with an enterprise database technology (e.g., Relational, SQL database, In-Memory databases, NoSQL databases and new emerging databases). Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system. Defines optimal conceptual, logical and physical data models that address customer requirement and balances performance and storage. Incorporates security, back-up, and disaster recovery into database designs. Establishes database parameters that maximize database performance. Installs, configures, and patches database management systems (DBMS). Writes database documentation, including data standards, procedures and definitions for the data dictionary (metadata). Controls access permissions and privileges. Ensures that storage and archiving procedures are functioning correctly. Conducts capacity planning. Clones application environments. Ensures availability of related application technology (e.g., web services, applications, batch processors, job schedulers, etc.). Provides Tier III support for the application technology stack. Applies application, security, and database patches. Migrates new software code and break fixes. Verifies shell/SQL scripts, packages, and stored procedures for system enhancements. Installs and configures third party products that integrates with the underlying application.

Oklahoma City, Oklahoma Area

Database administration responsibilities include Oracle database software installation and upgrades, patch analysis, database logical and physical design, performance tuning, database object management, implementation of backup and recovery strategies and database monitoring. Team lead responsibilities included managing DBA team during absence of Senior Manager and creating a summarize team status report delivered to Director, participating in weekly team lead meeting discussing goals, objectives and current issues. IBM Websphere application and http server administration responsibilities included software installation, configuration and upgrades, patch analysis and monitoring.Key Contributions:1. Served as the primary Oracle database administrator for several mission critical web application databases.2. Designed, configured and implemented an application hub which eliminated an administration and configuration vulnerability associated with the enterprise integration software migrating to the Disaster Recovery server, reduced database server overhead, reduce software licensing, and improved the manageability of database and integration software maintenance.3. Served as the Oracle database and IBM Websphere application and web server technical lead for the implementation of an online ordering system implemented in our Singapore office generating 5 billion dollars in revenue per year.4. Facilitated a monthly global DBA team meeting discussing Oracle, Microsoft and Open Source database technologies.5. Installed, configured, implemented and administered an Oracle Enterprise Management server monitoring 100+ development, staging and production database servers.

Oklahoma City, Oklahoma Area

Database administration responsibilities include Oracle and MSSQL database software installation and upgrades, patch analysis, database logical and physical design, database object management, implementation of backup and recovery strategies, database monitoring and SQL statement tuning. Lawson application administration responsibilities include application patch analysis and implementation, data dictionary administration and database reorganization. IBM MQ-Series administration responsibilities included software installation and upgrades, patch analysis, queue cluster logical and physical design, object management and monitoring.Key Contributions:1. Served as the primary Oracle database designer and administrator of the flower order gathering system that processes and routes over 10,000,000 orders annually across the United States.2. Served as the primary Oracle database administrator of the Lawson financial application database.3. Served as the primary MSSQL data modeler of a hosted electronic florist directory.4. Served as the IBM MQ-Series cluster designer and administrator of the flower order gathering system.

Oklahoma City, Oklahoma Area

Serving in a senior consultant capacity, the following services were performed for numerous clients in either an Oracle or Microsoft SQL Server environment: logical and physical database design, database performance tuning, database upgrades, database installation and configuration, implementation of backup and recovery strategies, hot backup installation and configurations, remote database administration & performance monitoring. Additional consulting services included providing design, development and implementation of operational systems, application interfaces and data migration procedures utilizing SQL, Oracle PL/SQL, Oracle Forms and Reports, IBM MQ-Series, Tivoli, Microsoft Visual Basic and Transact SQL, and Cold Fusion.Key Contributions:1. Designed, developed and provided a database administration shared services product to multiple customers within a three state region that substantially increased efficiencies in database monitoring and troubleshooting, which significantly reduced the client’s risk.2. Designed, developed and provided a database security audit services product to multiple customers within a three state region.3. Designed, developed and instructed Oracle database administration courses tailored to individual customer requirements.4. Served as the primary Oracle database designer and administrator during development of an application for a major electric utility company in Oklahoma City area. Designed and implemented the backend database, based upon developer needs, for an application to automate the scheduling of the company’s electric generators. The database now supports 24/7 hourly scheduling of generators under the company’s control, which directly affects the National Power Grid.5. Provided database administration support in an ongoing capacity on the underlying databases that supported a city in the state of Kansas Police Department’s 24/7 911 applications.

Witchita, Ks

Responsible for design, development, support and enhancement of lodging billing & claims processing system utilizing SQL and PL/SQL development techniques as well as proven Oracle Forms 5.0 and Oracle Reports 3.0 development techniques. Served as Project leader performing business workflow analysis, application and data model design audit, and user interface analysis. Database administration responsibilities included database logical and physical design, database object management, data migration and SQL statement tuning. Provided Oracle DBA services for Oracle Financials implementation. Application developer responsibilities included user liaison and data gathering, application analysis, design and development, user training, prepared test data, operational procedures, system documentation and standards. Developed and supported custom interfaces into Oracle Financials.Key Contributions:1. Orchestrated successful conversion from mainframe to client/sever environment.2. Reengineered data entry screens to improve speeds of average transactions per hour, per representative.3. Served as key troubleshooter and user liaison to solve organizational, data quality and process issues between end users and outsourced consultants.4. Overcame initial staff resistance to technology changes by outlining benefits and remaining available for variety of transition needs.