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

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