Description
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 onsite position in Washington DC.
Position Summary:
Astor is looking for a proven Senior Oracle Database Developer/Architect to join our growing team. The ideal candidate will have progressive experience architecting, designing, and modeling schemas, data structures and data warehouses for Oracle databases in multi-tiered environments.
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 with Data modeling tools such as Erwin
- 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
