Senior Database Developer

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

• 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

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