Senior Database Engineer — Public Sector Data Architect

appian; McLean (VA); Hybrid; USD 120,000 - 190,000; Full time

Job summary

Appian is seeking a Senior Database Engineer in McLean, VA to design, develop, and maintain a complex data architecture supporting DoW initiatives. You will work with RDMS and NoSQL databases, migrate legacy data, and ensure high availability and performance for mission-critical systems.

You will join the Public Sector Customer Success team, collaborating across Appian to deliver scalable data solutions, implement ETL processes, and integrate database objects into modern DevOps pipelines.

Qualifications

• Bachelor's degree in a technical field (CS/Engineering/IS/Math).
• 3+ years in data engineering designing/implementing tables, views, procedures, functions.
• Proficiency in SQL, NoSQL languages (SQL, MQL, CQL).
• U.S. citizenship with ability to obtain DoD Secret Clearance.

Responsibilities

• Design and develop database architectures and data models to support contract requirements.
• Assess legacy DB structures for incompatibilities and migration risks before cloud moves.
• Migrate legacy stored procedures, triggers, views, and functions to target languages (PL/SQL, SQL).
• Update hardcoded queries to be compatible with new engine.
• Establish ETL to transform legacy data into the new environment.
• Configure, implement, and monitor enterprise database clusters.
• Tune database objects and create indices for performance.
• Integrate database objects into CI/CD pipelines and source control.
• Develop data generation scripts for automated testing.

Skills

Relational databases

NoSQL databases

SQL

Data modeling

Education

Bachelor's degree

Tools

AWS Cloud

PostgreSQL

SQL Server

MariaDB

Oracle

Snowflake

Azure DevOps

Job description

Appian is seeking a Senior Database Engineer in McLean, VA to design, develop, and maintain a complex data architecture supporting DoW initiatives. You will work with RDMS and NoSQL databases, migrate legacy data, and ensure high availability and performance for mission-critical systems.

You will join the Public Sector Customer Success team, collaborating across Appian to deliver scalable data solutions, implement ETL processes, and integrate database objects into modern DevOps pipelines.