Senior Database Developer
Systems Integration & DevelopmentMclean, VA
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.1
Reclaim your time by letting our AI handle the grunt work of job searching.
We continuously scan millions of openings to find your top matches.
Overview
Schedule
Full-time
Career level
Senior-level
Remote
Hybrid remote
Benefits
Health Insurance
Dental Insurance
Disability Insurance
Job 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 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.
- 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
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.
FAQs About Senior Database Developer Jobs at Systems Integration & Development
What is the work location for this position at Systems Integration & Development?
This job at Systems Integration & Development is located in Mclean, VA, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.
What pay range can candidates expect for this role at Systems Integration & Development?
Employer has not shared pay details for this role.
What employment applies to this position at Systems Integration & Development?
Systems Integration & Development lists this role as a Full-time position.
What experience level is required for this role at Systems Integration & Development?
Systems Integration & Development is looking for a candidate with "Senior-level" experience level.
What benefits are offered by Systems Integration & Development for this role?
Systems Integration & Development offers following benefits: Health Insurance, Dental Insurance, Disability Insurance, Life Insurance, Paid Holidays, Paid Vacation, Career Development, 401k Matching/Retirement Savings, and Health & Wellness Programs for this position. Actual benefits may vary depending on the employer's policies and employment terms.
What is the process to apply for this position at Systems Integration & Development?
You can apply for this role at Systems Integration & Development either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.