Melvin Cook

**** ********* **** ***** *******, Virginia 23435

757-***-****(H) 757-***-****

aduw9x@r.postjobfree.com

Career Summary

Database expert experienced with Software Development Life Cycle (SDLC). Successful contributions to multiple SDLC and AGILE methodologies development teams as demonstrated in my work experience history. Twenty plus years direct experience with database design development and optimization of ORACLE database DOD information systems. Customer satisfaction focused with excellent documentation and communication skills.

Education

Christopher Newport University, 1993; Bachelor of Science Information Science

Thomas Nelson Community, 1989; Associate of Science Business Administration

Security Clearance: Active Secret

Certifications: Security + CE 2024, Microsoft OS Security 2015

Professional Training

ITIL Foundation, Microsoft Gold Learning SQL Server 2014, ORACLE 7, 8, 10G, 11G, 12c

(JOPES) Joint Operations Planning and Execution Systems

(DCAPES) Deliberate Crisis Action Planning and Execution Systems

Modeling and Simulation LVC, C2 architecture configuration, C4 operational support

Business Objects Courses Certification, JAVA Programming Language.

Computer Platform Experience MS Windows SQL SERVER (2000, 2005, 2008R2, 20012, 2016) MS Server, SSIS, SSRS :LINUX, UNIX operating systems: NT, MS Client,, ORACLE RDBMS, ORACLE Discoverer Developer, Business Objects, Power Shell, TSQL, C#, Fortran, Pascal, ADA, EASYTREIVE, VISUAL BASIC, VAX/VMS C, HTML, JavaScript, XML, AJAX and Tomcat, IIS, .Net 4.5

Employment History

KAPSUUN GROUP 7/2018 Administrator IV, Database Engineer

3+ years of Naval Risk Management Information and Streamlined Incident Reporting

Developed and deployed logical, and physical data structure for data ingestion and functional solution

Utilized (RDBMS) Oracle, Microsoft SQL Server, Informatics and CASE tools for design concepts

Built and managed data dictionaries, catalogs and design artifacts and integration strategies

Develop, optimize, and document complex data transformations and data mapping models

Develop QC standards for data integrity on both (production & development) platforms

Provided database engineering at the enterprise level for web applications deployments

Experienced with data warehousing concepts and data analytics on internal or external platforms

5+ years of experience with Agile practices guidelines for IT Service Management

4+ years of experience with systems architecture and design schemas, key candidates and constraints

Worked with stakeholders and Team members to communicate business rules and design documents

Write and optimize in-application SQL, PL/SQL statements for stored procedures and triggers

Support production data migration efforts as required scheduling of contract reporting

DISA STIGS and NIST implementation on MS SQL Server and Oracle RDBMS

Contributed to 5 successful migration projects SDLC stepwise module deployments

GDIT 9/2015 to 7/2018 Senior Principal Database Administrator (National Defense University, JFSC)

Migrating SQL Server 2008r2 instances to SQL Server 2016

Development of Visual Studio SSIS implementation processes to upgrade legacy SOP’s

Assist members of Engineering Team with installation, maintenance, and troubleshooting of web-based applications and applications that leverage SQL database services.

Assist with deployment of system updates and patches utilizing Microsoft System Center Configuration Manager (SCCM), Microsoft System Center Updates Publisher (SCUP), and Windows Software Update Services (WSUS).

Conduct daily system maintenance activities including log reviews and connectivity checks to maintain the infrastructure in a project-ready state.

Implement Microsoft operating systems, services and roles (DNS, Active Directory, etc.) and applications (MS Office) utilizing DISA STIG (Security Technical Implementation Guide) requirements.

Assist members of Engineering Team to deploy and configure various web applications in a secure environment utilizing DISA STIG (Security Technical Implementation Guidelines).

Occasionally travel in support of network events.

Trouble shooting and support web-based applications

Hourly log reviews and connectivity checks

Maintaining NDU applications readiness, hardening systems to prevent IAVA, compliance with Cyber DISA STIG requirements.

Information security domains and inter-relations (network security, application security, incident response)

Administering Database Security features (such as Roles, Privileges, Auditing, DBMS, and ASE)

Multi Operating system deployment (Unix, Linux and Windows) technologies

Data back-up, and recovery of SQL Server 2016 virtual server environments

Data migration for low to high side data synchronization

Define database logical and physical structures, functional capabilities and database security

INTELLECTECHS, INC. 3/2015 to 5/2015 HBSS ORACLE Database ADMIN (NDOC)

Experience with DoD security practices, system hardening, and DISA STIG procedures

Installed, configured, integrated and maintained Oracle 12c and HBSS components

Deployment of Agent modules and approved policies

Performed HBSS configuration to address known IAVA exploits using the Host Intrusion Prevention Systems (HIPS)

Applied STIGS and HBSS Operational requirements and configuration guidelines

Performed troubleshooting of component and applications for proactive monitoring of databases

Assisted Cyber Team and IA personnel in reviewing current intelligence and relevant threats and assist in development of appropriate resolutions

Data Management Group Federal (DMG) Inc. 6/2013 to 2/2015 Lead Senior Database Administrator

Installed MS SQL Server 2012 database software, patches, configuring Internet Information Server (ISS) components

Migrated database applications from physical servers to MS Sever 2012 virtual server

Corrected operations issue with GOTS software application versions updates and compatibility issues

Performed Data Link library (DLL), ASP .Net, and IIS updates

Database Failover clustering

Redesigned existing SQL Server Reporting Services reports

Coordinated distributed network security requirement policy standards compliance

Implemented dramatic performance improvement, application tuning and optimization by SQL Profile query performance tuning advisor, show plan, activity monitor.

CROSSWORKS Technologies Inc. 10/2012 to 6/2013 (Database Architect) Navy Safety Center (NSC) Norfolk

Implemented dramatic performance improvement, application tuning and optimization by SQL Profile query performance tuning advisor, show plan, activity monitor for Naval Safety Center.

Provided a HL7 relational model design to capture information related to occupational safety hazards

TEKSYSTEMS INC 8/2012 to 10/2012 Army Capabilities Integration Center Fort Eustis, Virginia

Provided ETL solution for EXCEL formulas migration into SSIS packages for loading into DW.

Developed of Business Intelligence (BI) components with recommendations provided for organizations data solutions.

Performed SQL stored procedure functionality maintenance.

Sabre Corp 1/2007 to 7/2012 Navy Marine Corps Public Health (NMCPH) (Senior DBA) Portsmouth, VA

Managed development team of 2 DBAs and 5 programmers

Performed Daily Health Level 7 message extracts data loading (ETL) data population requirement

Mentored Junior DBA and programmer graduates from ODU on stipends

Developed SSIS packages process to streamline procedures and organize databases processes.

Provided recommendations for organizations data solutions

Performed configuration management by addressing user security access skill levels as a requirement necessity.

Managed and implemented COOP, backup schedule, business rules enforcement, data architectures, capacity expansion planning and database data dictionary documentation information and ER diagram

Coordinated data source vendors CDC, CHCS, PHIN and DMDC data ETL import/export database packages

Posted Deployment Health Assessment on line (OLAP) monitoring, daily operations maintenance of SQL Server Report Services (SSIS) development processes

Maintained system performance tuning utilizing SQL Server SQL Profiler, Query Analyzer, System Monitor, Activity Monitor, SQL Trace, stored procedure, and Logs in DISA compliant system environment

General Dynamics AIS 09/2001 to 01/2007 (Principal Software Engineer/ Database System Integrator) Defense Transformations and Simulation, JTASC, Joint Forces Command (JFCOM), Suffolk VA.

Supported C4 integration system development of relational databases requirements and Web based GUI applications development of system interfaces accessing AEF constructs, TPFDD libraries, (DCAPES) and logical data structures Civil Engineer Software life cycle (JOPES) at (Air Combat Command)

Lead DOD STIGs compliance technical analyses project for implementing in a phased requirement analysis and conceptual design approach at (ACCCE Langley Air Force Base VA) Aerospace Expeditionary Force Center (AEFC).

Other Employment from 07/1993 until 09/2001

City of Portsmouth 11/2000 to 09/2001 (Oracle Specification Liaison), Portsmouth, VA

Norfolk Public Schools 11/1996 to 11/2000 (ORACLE Database Administrator), Norfolk, VA

VEDA INC 01/1996 to 11/1996 (System/Integrator Models and Simulation) JFCOM Suffolk VA

ORACLE 8, UNIX and Windows operating systems based software

Supported Joint Live Virtual Constructive (JLVC) exercises managing Joint High Level Architectures (HLA) and Models and Simulations (M&S) federation in accordance with DOD and IEEE standard

Installed and managed COTS/GOTS products as required Network configuration of distributed interactive simulation, TCP/IP protocols and network troubleshooting

Support all phases HLA M&S upgrades lifecycle management, JTDS tests and exercises, military domain simulation models support, service models validation and improvements

Mission Command (MC) databases hands-on implementation, joint tactical models and simulation environment software maintenance

Development Pearl scripts for interactive Menu access and mission reporting on distributed network

Clearance level DOD TS/SCI at the Joint Training Analysis Simulation Command (JFCOM), Suffolk VA

Information Technology Solutions 5/1993 to 1/1996 (ADA programmer) TRADOC FT EUTIS VA

Contact this candidate