Sql Server Database Developer

DYANNA HESS-MILLER

Manassas, Virginia 703-***-****

******.****-******@*******.***

PROFESSIONAL SUMMARY

Results-driven Senior Database Developer with 15+ years of experience designing, building, and optimizing database solutions for high-profile federal agencies and private-sector clients. Adept in Oracle, SQL Server, and PostgreSQL development, with deep expertise in ETL design, data architecture, and secure cloud data migrations (AWS GovCloud). Proven ability to lead cross-functional teams, manage full SDLC cycles, and deliver enterprise-scale solutions that align with mission-critical business goals.

CORE SKILLS AND TOOLS

•Database Development: Oracle •

11g/12c, MS SQL Server (2008–2019),

PostgreSQL, T-SQL, PL/SQL

•Data Architecture: Data Modeling, • Schema Design, Data Migrations, Dimensional Modeling (SCD)

•Project Tools: JIRA, Confluence, ServiceNow, Visual Studio, OBIEE, Fusion Middleware

ETL & BI Tools: SSIS, SSRS,

Informatica, Ab Initio, DataStage, Power BI, Tableau

Additional Tech: Python (beginner), SAP, Teradata, Netezza, UNIX Shell, HTML

• Cloud & DevOps: AWS GovCloud, CI/CD, GitHub, Team Foundation Server

•Federal Clients: DoS, DHS, DOC, DEA, DoD (Army, Navy, Air Force, Marines), NAVAIR

PROFESSIONAL EXPERIENCE

APPLICATION DEVELOPER III

Walker Health Force- HUMANA MILITARY Remote

June 2024 – June 2025

•Leading migration of SQL Server objects and SSIS packages into a new Enterprise Data Warehouse.

•QA testing and validating database transformations prior to production release.

•Refactored legacy stored procedures, packages, and tables to comply with EDW standards.

Senior Database Engineer / Independent Consultant Dyanna Hess- Miller, LLC Manassas, Va

September 2022 - Current

•TrustedQA/NAVAIR (Feb 2023 – Oct 2023): Led data analysis for DECKPLATE, focusing on Naval Aviation operational data (maintenance, flight, inventory, supply).

•Huntington Bank (Sep 2022 – Jan 2023): Re-engineered QRM application, migrating business logic from pre-processing tables into the application's ETL layer.

SENIOR DATA ARCHITECT/DEVELOPER

Incadence Strategic Solutions remote Client Serving: Department of State.

March 2022 - September 2022

•Designed and implemented a SQL Server-based data mart for the OSIS II program.

•Built ETL pipelines using SSIS to integrate SharePoint, Unanet, and Excel data sources.

•Deployed cloud-based solutions in AWS GovCloud, ensuring FedRAMP compliance.

SENIOR DATABASE DEVELOPER

Kaimetrix remote

Client Serving: Department of Homeland Security DHS.

January 2021 - February 2022

•Delivered full-lifecycle SQL Server development including SSIS, SSRS, and stored procedures.

•Optimized T-SQL for performance and implemented automated data integrations.

ORACLE DATABASE ADMINISTRATOR

Snap LLC Washington, DC

Client Serving: Department of Commerce.

January 2020 - December 2021

•Upgraded Oracle databases (11g to 12c), managed patching (CPU, PSU), and secured deployments.

•Administered Fusion Middleware, WebLogic, and OBIEE, including RMAN-based recovery.

SENIOR SQL DATABASE DEVELOPER/ETL DEVELOPER

SOSI, Inc Rosslyn, VA

Client Serving: Department of State.

March 2019 - September 2019

•Built high-performance Oracle and SQL Server solutions for Passport System under Agile/DevOps.

•Managed production deployment support and database lifecycle documentation.

SENIOR DATA ARCHITECT/DEVELOPER

Incadence Strategic Solutions Manassas, Va Client Serving: Department Of Defense .

August 2018 - July 2019

•Designed and built Oracle 12c schema and ETL processes for ATIS (Army Training Information System) prototype using Ab Initio.

•Led data conversion from legacy systems (SQL Server, GIS, Excel) and guided DevOps integration in AWS GovCloud.

SENIOR SQL DATABASE DEVELOPER/ETL DEVELOPER

The Select Group/STG Rosslyn, VA Client Serving: Department of State.

November 2017 - August 2018

•Delivered robust PL/SQL and T-SQL solutions and maintained database object libraries in TFS.

•Supported mission-critical deployments for Passport Services.

SENIOR SQL DATABASE DEVELOPER/ETL DEVELOPER

KPMG/11th Hour Services Navy Yard, Washington, DC Client Serving: Department Of Defense(Navy FMO).

May 2017 - November 2017

•Engineered Treasury reconciliation workflows using Informatica and PostgreSQL.

•Supported Navy's FIAR goals through transformation of large-scale financial datasets.

SENIOR SQL DATABASE DEVELOPER/ETL DEVELOPER

InterImage, Inc Crystal City, VA

Client Serving: Army Review Boards Agency.

November 2015 - May 2017

•Developed and maintained ETL processes and data interfaces for the ARBA data warehouse using SSIS/SSRS solutions and optimized T-SQL procedures to support reporting and SharePoint portals.

•Provided backup DBA support and managed SOP documentation.

EDUCATION AND CERTIFICATIONS

Certification - Cobol Programming/Database Design Mainframe Corporate Computing

June 1997

PUBLICATIONS AND RECOGNITION

Featured in Marquis Who's Who for Excellence in Database Architecture

24-7 Press Release Article

Contact this candidate