TECHNICAL PROFICIENCIES:

Languages: SQL, T - SQL, SSIS, .NET (vb, c), C (Objective C, GNU), java, HTML, XML, VBScript, COBOL (VS, z/OS, MicroFocus), EasytrievePlus, REXX (Win, z/OS), ISPF Dialogs and Skeletons, CLIST, JCL

Platforms: Microsoft Windows, IBM z/OS, Linux, Unix, Web Services Architecture, APPC/LU6.2 (SNA), TCP/IP, MQ Messaging Architectures.

RDBMS: Software IBM DB2 for z/OS (through v11), Microsoft SQL Server (2000 through 2015), IBM UDB ( Windows through v10, Linux), MySQL, Oracle, Sybase Adaptive Server Enterprise

Application: Server Software Microsoft IIS (including NLB), Apache Tomcat Application Server, CICS, IBM Websphere Application Server

Vendor: Software Microsoft Visual Studio (2005 through 2010), Idera SQL Server Tools, Redgate SQL Server Management Tools, Microsoft SQL Server Management Studio, Microsoft Office, Microsoft Visio, eclipse, SAP BusinessObjects Enterprise, Crystal Reports, CA-Cool Gen, CA-Platinum for z/OS, CICS TMON, Omegamon for DB2, Compuware File-Aid Suite, Compuware Expeditor, Compuware Strobe, IBM DB2 Performance Monitor, IBM DBA Administration Tools, Quest Software, CA Cool Gen, IBM InfoSphere Optim (Move for DB2), Data Propagator/InfoSphere, IBM Data Studio, IBM QMF, IBM Debug Tool, Sybase PowerDesigner, IBM RACF, Spielberg Systems FileDirector, Clarity OpenWorkbench, ServiceNow Service Desk, IBM InfoSphere Replication Suites, ServiceNow, IBM DataStudio, Serena ChangeMan, twiki, WordPress

PROFESSIONAL EXPERIENCE:

Confidential, Lincoln, Nebraska

Senior Consultant/Enterprise Infrastructure

Responsibilities:

• Responsible for the administration and support of very large (multi - terabyte database systems).
• Provide architectural, application and infrastructure support.
• Manage projects to improve the efficiency and effectiveness of application teams and DBA operations.
• Identify requirements and build repeatable processes to provide consistent and effective operational controls, proactive monitoring, and strict accountable security controls.
• Develop security architectures to enforce international, nation, state, and local privacy and security policies including PII, HIPAA and SOX compliance.
• Act as a consultant to application teams on system development and provide SME related to database design and development.
• Perform root-cause analysis for complex application and system issues and provide recommendations to remediate application and system issues.
• Redesigned internal client-facing and DBA web sites to improve communication and process understanding for business, development and DBA staff.
• Perform project management activities from planning, implementation and project closure activities.
• Conduct interviews for Confidential and Confidential, and develop objective hiring scoring system.

Confidential, Lincoln, Nebraska

IT Consulting

Responsibilities:

• Partner with independent consulting firms as a technical consultant for state governments in areas related to technical architecture and infrastructure relating to their implementation of federal programs and provide recommendations on technologies and impact on existing technical environment.
• Develop and deploy websites based on Wordpress, Joomla, and Drupal.
• RFP development and recommendation of contract requirements and execution.

Confidential, Lincoln, Nebraska

Database Administrator/Specialist/Supervisor

Responsibilities:

• Personnel Management: Hiring recommendations, personnel evaluations, staff development and mentoring. Resolves employee concerns, develop corrective actions, recommend advanced disciplinary action. Recommend resource requirements and scheduling.
• Project Planning: Technical project management (including budgeting, planning, execution, and implementation), managing project scope and risk, request for proposal (RFP) development, review and scoring methodology that spanned program and enterprise initiatives. Formulate project scope and requirements in conjunction with clients and ensure deliverables met the requirements. Identify and remove barriers to successful completion of objectives. Review project plans at phase end points to verify they meet expectations and propose recommendations for future improvement.
• Strategic Planning: Alternatives analysis, cost-benefit analysis, technical innovation planning (change management) and adoption, security planning and architecture for data subject to State and Federal Laws and Regulations. Contract review and negotiation with hardware and software vendors.
• Policy Development: Identify policy requirements and develop and implement I.T. policies, standards, and guidelines to meet internal, federal and state regulatory requirements.
• Day-to-day operational support for Microsoft SQL Server and IBM DB2 Installations including backup/recovery, installation, upgrading, system development and migration, and troubleshooting spanning stand-alone and high-availability clustered systems. Definition and automation of optimization processes such as backups (full and incremental), index optimization, integrity checks, etc. Worked with vendors to troubleshoot, identify and test solutions to system support software (e.g. IBM, CA, etc.).
• Designed methodologies and processes for the automated backup, recovery, and maintenance of DBMS optimization procedures across multiple DBMS systems includes Microsoft SQL Server, IBM UDB for Window, IBM DB2 for z/OS, Sybase, and Oracle.
• Manage technical architecture teams encompassing .NET platform and technologies, and a java stack consisting of an Apache/JSF/DB2 and SQ L Server Platform.
• Develop and maintain help desk processes to support enterprise requests for database personnel assistance, resources, and problem tracking.
• Consulting: Technical expertise in multiple DBMS including DB2 for z/OS, Microsoft SQL Server, MySQL, distributed database system architecture, application connectivity, and performance management. Identified solutions and presented recommendations to diverse cross-agency personnel.
• SDLC: Participated in the full software development lifecycle (SDLC), providing procedural and technical recommendations for efficiency, ensuring general business and functional requirements are met, or propose alternative solutions to ensure they are met in the most cost effective or resource efficient manner.
• Change Management: Participated in the development of procedures to deploy new software releases, identified and proposed solutions to mitigate potential risk, and participated in the identification and resolution of issues associated with new software releases.
• Organizational Change Management: Assisted in the education of technology staff to illustrate the benefits of newer technologies and minimize the resistance to change from established practice.
• Served as a technical expert for multiple large state agencies assessing application architecture, COTS system integration, and system architecture from multiple technologies (e.g. java, .NET, SOA web services), security system design, system troubleshooting/root-cause analysis and performance tuning.
• Provided technical direction and standards to multi-platform development teams, product selection, implementation, and optimization. Logical and physical modeling for large transactional systems working in conjunction with business analysts, development teams, and clients.
• Developed systems to duplicate large volumes of DB2 data using DSN1COPY and allowed replication of data to multiple development databases.
• Developed methods to de-identify data subject to state and federal regulations such as HIPAA and Privacy Act Information.
• Created REXX-based front-end to automate Move for DB2 (Optim) duplication of a DB2 for z/OS system that composed over 300 referentially related entities.
• Developed separate systems to move subsets of data to DB2 for Confidential .
• Implemented help desk support procedures for the teams I managed which integrated with the State ticketing system.
• The system provided accountability and completion of tasks within service level agreements and served system end users and supported technical and development teams.

Confidential, Lincoln, Nebraska

Lead Database Administrator

Responsibilities:

• Directed the activities of a team of DBAs to satisfy the development and operational requirements of a $80M Health and Human Services System consisting of 2,400 server-side DB2 modules and 1,000 batch DB2 modules accessing 350 DB2 tables.
• Designed backup/recovery procedures, application coding standards, application architecture design and security.
• Performed complex troubleshooting and performance tuning across distributed platforms.
• Designed data propagation tasks across multiple DBMS (DB2 for z/OS, DB2 for Confidential, SQL Server) and platforms utilizing technologies such as DB2 Data Propagator (SQL replication), native scripts and Q-REP.
• Participated in enterprise-wide software evaluation, cost-benefit analysis, and selection, architecture, and strategic direction.
• Assisted in the introduction of DB2 stored procedures and their application in the legacy environment and created multiple code generators to increase developer productivity and perform test data management.
• Consulted with the Child Support System and Medicaid systems in the areas of hardware/software selection and application architecture, infrastructure and change management and provided recommendations for architectural improvements to achieve cost and developer efficiencies.
• Maintained direct communications with senior management, external suppliers, and federal auditors.
• Assisted in the acquisition and guidance of the implementation of a reporting system based on Crystal Enterprise.
• Cross-trained team on multiple platforms, performed personnel evaluations and created staff development plans.

Confidential, Lincoln, Nebraska

Database Administrator

Responsibilities:

• Performed the complete database life cycle including logical modeling, physical implementation, change management, and system/application performance tuning.
• Created standards and procedures for DB2 System Administration, Security, backup/recovery, system software installation, maintenance and trouble-shooting.
• Created Application Coding Standards, provide mentoring to development staff.
• Created data driven COBOL Code Generators on z/OS, Windows, and OS/2 and created customized development tools for test data management.

Confidential, Lincoln, Nebraska

Database Administrator

Responsibilities:

• Performed logical data modeling and normalization, physical implementation of logical data models, DB2 System Administration, Security, backup/recovery procedures, system software installation, maintenance and trouble-shooting.
• Created Application Coding Standards and provided mentoring to development staff.
• Third-party vendor software identification and recommendations.
• Participated in pilot projects to identify the application of cutting-edge technologies to create core competencies and was a principal participant in the migration from proprietary DOS/VSE systems to MVS-based systems.
• Performed administration for security and e-mail systems, AdvantageGen (aka Cool:Gen, IEF) encyclopedias, participated in federal audits and handled confidential internal and external confidential information.