Lead Database Engineer

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

Here at Appian, our values of Intensity and Excellence define who we are. We set high standards and live up to them, ensuring that everything we do is done with care and quality. We approach every challenge with ambition and commitment, holding ourselves and each other accountable to achieve the best results. When you join Appian, you’ll be part of a passionate team dedicated to accomplishing hard things, together.

Database Engineers in Appian’s Public Sector Customer Success department build the scalable foundation behind mission-critical systems that power the world’s most demanding enterprises and government organizations.

Location: McLean, VA | Work Model: In-Office / Hybrid

About the Team

Appian’s Customer Success Public Sector team builds mission driven solutions that ensure peak performance, high availability, and data security for key Department of War (DoW) initiatives. We empower government organizations to modernize legacy systems using AI-Powered Process Automation and Enterprise-Grade Orchestration, ensuring seamless data access at scale.

The Opportunity

As a Database Engineer, you will design, develop, and maintain a complex data architecture to support our long-term DoW efforts. With extensive experience with Relational Database Management Services (RDMS) and NoSQL databases, you will architect a data architecture for the program that will be capable of handling extremely large datasets, migrate legacy data into the modern architecture, and ensure high availability and performance for the systems being implemented.

What You’ll Do

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

Required Qualifications

• Bachelor’s Degree: B.S. or B.A. in Computer Science, Engineering, Information Systems, Mathematics, or a related technical field. (Note: Degree is strictly required).
• Experience: 5+ years of professional experience in data engineering, including hands-on experience designing, planning, and implementing tables, views, stored procedures, and functions.
• Core Technical Skills: Deep proficiency in both relational (RDBMS) and NoSQL database technologies, along with mastery of query languages including SQL, MQL, and CQL.
• Database Platforms: Professional experience designing, planning, and implementing new stored procedures, views, tables, and functions specified by business requirements.
• Core Technical Skills: Strong proficiency in both SQL and NoSQL database languages including SQL, MQL, CQL, etc. Hands-on experience technologies such as Microsoft SQL Server, MariaDB, Postgres, Oracle and AWS Cloud, Snowflake, Data Bricks.
• Security & Clearance: Active DoD Secret Clearance (or ability to obtain). Must be a U.S. Citizen (required for Public Sector efforts).
• Travel: Willingness to travel up to 10% annually for customer engagement.

Preferred Qualifications

• Cloud & Security Certifications: AWS Certified Database Specialty, AWS Certified Solutions Architect, CompTIA Security+, or platform-specific certifications from Oracle or Microsoft.
• Migration Expertise: Demonstrated experience migrating complex schemas across database engines (e.g., Oracle to PostgreSQL/MariaDB or SQL Server to MySQL).
• DevOps & Code: Familiarity with Python, Java, C#, XML, JSON, Jenkins, Azure DevOps, and RHEL8.

The base salary range provided represents a good faith and reasonable estimate of the range at the time of posting. In addition to the base salary, this position is eligible for a government clearance differential. Actual compensation will be dependent on a number of factors including, but not limited to, the candidate’s relevant work experience, qualifications, internal peer equity, and market and business conditions that exist when extending an offer. A discretionary bonus may be awarded in recognition of individual and company performance.

In addition, Appian provides generous benefits offerings that include a 401(k) plan with company match, flexible time off, paid parental leave, medical, dental, and vision plans, life insurance, disability insurance, wellness programs, flexible spending accounts, health savings account contributions, an employee referral bonus program, and learning and development resources. Certain positions may be eligible for equity awards.

Pay and benefits are subject to change at any time, consistent with the terms of any applicable compensation, commission, bonus, or benefit plans.

Base Salary Range

$125,000 - $250,000 USD

Tools and Resources

• Training and Development: During onboarding, we focus on equipping new hires with the skills and knowledge for success through department-specific training. Continuous learning is a central focus at Appian, with dedicated mentorship and the First-Friend program being widely utilized resources for new hires.
• Growth Opportunities: Appian provides a diverse array of growth and development opportunities, including our leadership program tailored for new and aspiring managers, a comprehensive library of specialized department training through Appian University, skills based training, and tuition reimbursement for those aiming to advance their education. This commitment ensures that employees have access to a holistic range of development opportunities.
• Community: We’ll immerse you into our community rooted in respect starting on day one. Appian fosters inclusivity through our 8 employee-led affinity groups . These groups help employees build stronger internal and external networks by planning social, educational, and outreach activities to connect with Appianites and larger initiatives throughout the company.

Appian offers a comprehensive benefits package designed to support your health, wellbeing, and financial future. Benefits may include health coverage, Employee Assistance Program (EAP) with free mental health support, life and disability insurance, an Employee Stock Purchase Program (ESPP), a retirement/pension plan, wellness dollars, tuition reimbursement, family-forming benefits and more. Benefits vary by country—please ask your Talent Acquisition contact for details specific to the location you are applying to.

About Appian

Appian provides AI automation for mission-critical work. We automate complex processes in large enterprises and governments. Our platform is known for its unique reliability and scale. We’ve been automating processes for more than 25 years and understand enterprise operations like no one else. For more information, visit appian.com . [Nasdaq: APPN]

Appian is an equal opportunity employer that strives to attract and retain the best talent. All qualified applicants will receive consideration for employment without regard to any characteristic protected by applicable federal, state, or local law.

Appian provides reasonable accommodations to applicants in accordance with all applicable laws. If you need a reasonable accommodation for any part of the employment process, please contact us by email at [e-mail] . Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Appian Corporation ’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service‑connected disability.

A "recently separated veteran" means any veteran during the three‑year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Voluntary Self-Identification of Disability

Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp .

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

• Alcohol or other substance use disorder (not currently using drugs illegally)
• Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
• Blind or low vision
• Cancer (past or present)
• Cardiovascular or heart disease
• Celiac disease
• Cerebral palsy
• Deaf or serious difficulty hearing
• Diabetes
• Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
• Epilepsy or other seizure disorder
• Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
• Intellectual or developmental disability
• Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
• Missing limbs or partially missing limbs
• Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
• Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
• Neurodivergence, for example, attention‑deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
• Partial or complete paralysis (any cause)
• Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
• Short stature (dwarfism)
• Traumatic brain injury

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.