Senior Database Engineer — Hybrid, Public Sector

Appian Corporation; McLean (VA); Hybrid; USD 125,000 - 250,000; Full time

Benefits offered by this job

401(k) plan with company match

Paid parental leave

Medical, dental, and vision plans

Tuition reimbursement

Job summary

Appian Corporation in McLean, VA is seeking a seasoned Database Engineer to design, develop, and maintain a scalable data architecture for DoW initiatives. You will migrate legacy data, optimize for performance, and ensure high availability across RDMS and NoSQL platforms.

You will work with SQL, MQL, and CQL across SQL Server, MariaDB, Postgres, Oracle, AWS, Snowflake, and Data Bricks, while collaborating with DevOps to integrate CI/CD pipelines.

Qualifications

• Bachelor’s degree is strictly required.
• 5+ years of professional experience in data engineering and hands-on experience designing, planning, and implementing tables, views, stored procedures, and functions.
• Deep proficiency in both relational (RDBMS) and NoSQL database technologies and mastery of SQL, MQL, and CQL.
• Experience designing, planning, and implementing stored procedures, views, tables, and functions as per business requirements.
• Strong proficiency in SQL and NoSQL languages including SQL, MQL, CQL and hands-on experience with SQL Server, MariaDB, Postgres, Oracle, AWS Cloud, Snowflake and Data Bricks.
• Active DoD Secret Clearance (or ability to obtain); U.S. citizenship is required for Public Sector efforts.
• Willingness to travel up to 10% annually for customer engagements.

Responsibilities

• Design and develop database architectures and data models to support the customer’s contract requirements, collaborating with the Appian team to build logical and physical data models.
• Analyze legacy database structures to identify incompatibilities and migration risks before moving workloads to the cloud.
• Convert legacy code (stored procedures, triggers, views, functions) into target-compatible languages; rewrite logic as needed.
• Identify and update hardcoded SQL queries to ensure compatibility with the new database engine.
• Establish ETL functions to clean, transform, and transport legacy data into the new environment.
• Configure, implement, and monitor enterprise database clusters.
• Tune database objects for performance and create indices as needed.
• Integrate existing and new database objects into CI/CD pipelines for reliability.
• Set up source control for database architecture code, stored procedures, and ETL objects.
• Develop complex data generation scripts for automated functional and performance testing.

Skills

RDBMS

NoSQL

SQL

MQL

CQL

Data modeling

ETL

CI/CD

Cloud

DoD clearance

Education

Bachelor’s Degree in CS/Engineering/IS/Math

Tools

Microsoft SQL Server

MariaDB

Postgres

Oracle

AWS Cloud

Snowflake

Data Bricks

Jenkins

Azure DevOps

Job description

Appian Corporation in McLean, VA is seeking a seasoned Database Engineer to design, develop, and maintain a scalable data architecture for DoW initiatives. You will migrate legacy data, optimize for performance, and ensure high availability across RDMS and NoSQL platforms.

You will work with SQL, MQL, and CQL across SQL Server, MariaDB, Postgres, Oracle, AWS, Snowflake, and Data Bricks, while collaborating with DevOps to integrate CI/CD pipelines.