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
Numbers & Facts
Location
McLean, VA
Skills
Applications Securityunmatched
Business Analysisunmatched
Content Developmentunmatched
Cryptographyunmatched
Data Migrationunmatched
Data Modelingunmatched
Database Administrationunmatched
Database Optimizationunmatched
Database Programmingunmatched
IBM DB2unmatched
Oracle Databaseunmatched
Performance Tuning/Optimizationunmatched
Proof of Conceptunmatched
Query Optimizationunmatched
SQL (Structured Query Language)unmatched
Stored Proceduresunmatched
Test Plan/Scheduleunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.