Senior Database Developer

Astor & Sanders; McLean (VA); Híbrido; USD 120.000 - 150.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

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

Descripción de la vacante

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.

Formación

• 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.

Responsabilidades

• 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.

Conocimientos

Appian

SQL

Oracle

PL/SQL

Data Modeling

Agile

Data Migration

Educación

Bachelor’s Degree in Computer Science

Herramientas

IBM DB2

Oracle

AWS RDS

Configuration Management tools

Descripción del empleo

Senior Database Developer

Astor & Sanders Corporation (Astor) is an award-winning IT solutions provider headquartered in McLean, VA seeking a Senior Database Developer with Appian experience. This is a full-time and hybrid position.

Roles & Responsibilities:

• Collaborate with internal business resources and technical teams/SMEs to understand data sources
• Design, build, maintain, and optimize databases
• Develop database objects including stored procedures, tables, views and table-valued functions.
• Write complex queries involving common table expressions, window functions and subqueries for reporting.
• Develop, test and execute the migration of data from an IBM DB2 to database to an Oracle database.
• Translating business functions into conceptual, logical and physical data models.
• Optimize database tables including the application of triggers, indices and constraints.
• Enforce the successful application of any security standards necessary for the database, potentially including encryption at rest.
• Performance tuning and query optimization
• Data migration from legacy data base and perform transformations to the data to fit in the new data base
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports
• Support development teams in developing SQL queries

Requirements

• Bachelor’s Degree in Computer Science or other related discipline
• 5+ years’ experience as Database Developer/Programmer.
• 5+ years’ experience integrating data from disparate sources
• 5+ years’ experience in Agile development methodologies
• Strong understanding of MDM policies including cleansing, normalization and standardization.
• Demonstrated experience with Configuration Management tools
• Ability to design and create effective data models
• Proficient in developing stored procedures using PL/SQL and developing efficient views
• Experience with performance tuning
• Experience in Data Mapping and Data Migration
• Experience with databases such as Oracle and AWS RDS
• Understanding of data security and data access controls and design aspects
• Strong verbal and written communication skills
• Must demonstrate ability to work under high pressure in a complex multi-threaded environment
• Demonstrated capability to learn, rapidly utilizing good problem solving skills
• Desire to learn and document new tools
• Prior experience architecting databases and warehouses for Appian BPMS solutions a plus

Benefits

Astor & Sanders Corporation (www.astor-sanders.com) offers a unique, stimulating and challenging environment that fosters individual growth and rewards performance. Astor & Sanders Corporation ( #Astor ) is an Equal Opportunity Employer.

Some of our competitive benefits include:

• Generous Paid Time Off (PTO) and all Federal Holidays off
• Comprehensive Health and Dental Insurance Coverage
• Retirement Savings Plan
• Pre-Tax Benefit Programs
• Wellness and Work-Life Support
• Professional Development
• Performance and Referral Bonuses
• Life and Disability Insurance