Senior Database Developer – Appian & Data Architecture

Astor & Sanders; McLean (VA); Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

PTO & Federal Holidays

Health & Dental Insurance

Retirement Savings Plan

Pre-Tax Benefit Programs

Wellness & Work-Life Support

Professional Development

Performance & Referral Bonuses

Life and Disability Insurance

Job summary

Astor & Sanders Corporation in McLean, VA is seeking a Senior Database Developer with Appian experience to join our IT solutions team. This is a full-time, hybrid role focused on designing, building and maintaining databases, migrating data, and optimizing performance.

You will collaborate with business resources and developers to translate requirements into data models, implement security controls, and support reporting and ETL processes across systems such as Oracle and AWS RDS.

Qualifications

• Bachelor’s degree in CS or related field.
• 5+ years as Database Developer/Programmer.
• 5+ years integrating data from disparate sources.
• 5+ years in Agile development.
• Knowledge of MDM: cleansing, normalization, standardization.
• Experience with IBM DB2, Oracle, and AWS RDS.
• Proficient in PL/SQL and creating efficient views.
• Experience with data migration and performance tuning.

Responsibilities

• Collaborate with business resources and SMEs to understand data sources.
• Design, build, maintain, and optimize databases.
• Develop stored procedures, tables, views, and table-valued functions.
• Write complex queries using CTEs, window functions, and subqueries.
• Migrate data from DB2 to Oracle.
• Translate business needs into data models (conceptual/logical/physical).
• Optimize tables with triggers, indexes, and constraints.
• Ensure security controls for databases (encryption at rest).
• Perform performance tuning and query optimization.
• Migrate legacy data and transform it to fit new database.

Skills

Appian

SQL

Oracle

PL/SQL

Data Modeling

Agile

Data Migration

Education

Bachelor’s Degree in Computer Science

Tools

IBM DB2

Oracle

AWS RDS

Configuration Management tools

Job description

Astor & Sanders Corporation in McLean, VA is seeking a Senior Database Developer with Appian experience to join our IT solutions team. This is a full-time, hybrid role focused on designing, building and maintaining databases, migrating data, and optimizing performance.

You will collaborate with business resources and developers to translate requirements into data models, implement security controls, and support reporting and ETL processes across systems such as Oracle and AWS RDS.