Database Developer

Washington, DC
Sep 19, 2023
Oct 19, 2023
Full Time
Job Summary

Aptive Resources is seeking a Database Developer, to be part of a team, to support the Department of Veterans Affairs (VA) Office of Performance Analysis and Integrity (PA&I) for the Veterans Benefit Administration (VBA) Enterprise Data Warehouse (EDW). EDW is the source for all data and information about Veterans benefits data. It contains relevant data from each of VBA's transactional systems and arrays the data in a variety of business intelligence reporting for executive managers, business lines and claims processing teams in VBA's Regional Offices. EDW data is used for fraud detection and prevention, financial auditing, and reports to Congress. It is the source for all legal reporting requirements, to include the Government Performance Accounting Act, the American Recovery and Reinvestment Act and the Federal Funding Accountability and Transparency Act of 2006.

The Database Developer must have experience with diverse IT projects both large and small within an Oracle environment. You will work within a diverse team and multiple firms supporting one mission. This position will deliver database enhancements to the current data warehouse, evolving to a more efficient structure that meets the growing demands of retrieving data, conducting analyses, and producing integrated reports to VBA business areas.

This position is onsite in Washington, D.C. at the VA facility during the normal operating hours of 0800 - 1700 EST Monday to Friday, excluding Federal holidays.

Primary Responsibilities

Operations and Maintenance (O&M)
  • Working with EDW's one Oracle M8 Supercluster database and thirteen (13) application servers operating on Windows and UNIX platforms, provide dedicated, technical O&M database updates and support for EDW and its end users.
  • Analyze complex business problems, track down required information, document requirements, and develop technical solutions.
  • Support business customers by providing insight into data warehouse structures Education and Knowledge.
  • Create, modify, and test SQL and PL/SQL code in EDW Oracle databases.
  • Conduct code reviews and participate in technical design.
  • Establish and enforce quality, security, and compliance requirements.
  • Integrate data from multiple source systems, enabling a central view across the enterprise.
  • Execute a sound methodology for conducting routine and ad hoc database maintenance.
  • Analyze known or potential risks and their subsequent impact on the development, deployment, and maintenance of the database applications.
  • Execute methodologies for increasing database optimization and standardization.
  • Produce and maintain accurate system documentation.

EDW Application Support:
  • Maintain ongoing communications with application support teams regarding database issue resolution and general database support.
  • Maximize the value that applications derive from database services.

Database Management, Architecture, Design and Development
  • Support a single common data model for all data of interest, integrating the data regardless of the data's source using common design and normalization, while organizing and disambiguating repetitive data.
  • Maintain data history, even if the source transaction systems do not.
  • Improve data quality, by providing consistent codes and descriptions, flagging, or even fixing/cleansing bad data.
  • Restructure the data so that it makes sense to business users, making decision-support queries easier to write, while helping support the accelerated development of business intelligence and reporting capabilities.
  • Restructure the data so that it delivers excellent query performance, even for complex analytic queries, without impacting the operational systems.
  • Understand and optimize materialized views and partitioning schemes.
  • Provide subject matter expertise in database development tools and various optimization techniques.

Minimum Qualifications

  • Bachelor's degree in computer science, Computer Engineering or other related degree.
  • 2+ years of Oracle Database development experience, including SQL and PL/SQL and Release 12.2.
  • Knowledge of Agile Development Methodologies.
  • Experience creating Shell scripts.
  • Experience in operations and maintenance (O&M) support.
  • Highly organized, systematic and proactive in delivering materials and meeting client expectations within a fast-paced environment.
  • Demonstrated knowledge in problem identification, alerting, troubleshooting, and incident resolution.
  • Capable self-starter with a drive to get all types of work done and high attention to detail.
  • Ability to obtain and maintain public trust clearance.
  • Legal authorization to work in the U.S.

Desired Qualifications

  • Oracle Database PL/SQL Developer Certified Professional.
  • Requisite skills and technical expertise to utilize modeling and data analytics tools.
    • Oracle Database Modeling,
    • C Sharp
    • Microsoft Excel, and all Microsoft Office Suite
  • Ability to design secure cloud database services and analyze related security requirements and solutions.
  • Experience with baseline O&M plan and updates for new data sources or large-scale reports.
  • Ability to level lock contention in transaction processing systems caused by attempts to run large, long-running, analysis queries in transaction processing databases.
  • Knowledge of Government Consulting environment.
  • Strong critical thinking and analytical skills.
  • Ability to communicate thoughts, ideas and solutions logically both written and orally.
  • Strong critical thinking and analytical skills.
  • Proven ability to organize, prioritize, and work well with others.
  • Ability to get up to speed quickly on complex issues; desire to work in a fast-paced, rapidly evolving environment.
  • Experience in communicating detailed and technical concepts to a diverse audience.

About Aptive

Aptive is a modern federal consulting firm focused on human experience, digital services, and business transformation. We harness creativity, technology, and culture to connect people and systems to impact the world. We're advisors, strategists, and engineers focused on people, above all else.

We believe in generating success collaboratively, leaving client organizations stronger after every engagement and building trust for the next big challenge. Our work inspires people, fuels change and makes an impact. Join our team to be part of positive change in your community and our nation.

EEO Statement

Aptive is an equal opportunity employer. We consider all qualified applicants for employment without regard to race, color, national origin, religion, creed, sex, sexual orientation, gender identity, marital status, parental status, veteran status, age, disability, or any other protected class.

Veterans, members of the Reserve and National Guard, and transitioning active-duty service members are highly encouraged to apply.

Similar jobs