Sign upLog in
See more jobs

Data Modeler/SQL Database Developer

Aptive
  • Remote
  • Remote
  • Full-time
3 days ago

Job Description

Job Summary:

Data Modeler / SQL Database Developer

Full-Time | Remote | Contingent Upon Contract Award

Position Summary

Aptive Resources is seeking a Data Modeler / SQL Database Developer to support the Veterans Health Administration (VHA) Office of Research and Development (ORD), Health Systems Research (HSR), and the Center for Information Dissemination and Education Resources (CIDER).

The Data Modeler will provide hands-on technical support for a large Microsoft SQL relational database used to support research administration, compliance activities, data collection, reporting, information dissemination, and operational and leadership requests. The position requires someone who can both maintain a production database environment and work directly with program stakeholders to translate business and reporting needs into reliable database solutions. The underlying HSR system is a SQL relational database accessed through a secure VA intranet environment.

Primary Responsibilities:

The Data Modeler will:

  • Administer and maintain large Microsoft SQL Server relational databases.
  • Design, create, modify, and manage SQL tables, schemas, and database structures.
  • Develop, execute, maintain, and optimize stored procedures, queries, scripts, and utilities.
  • Develop and modify SQL reports supporting recurring and ad hoc reporting requirements.
  • Manage and monitor automated SQL Server jobs and scheduling.
  • Monitor database performance, reliability, integrity, and availability.
  • Support database backup, recovery, permissions, access controls, and security.
  • Troubleshoot database, server, application, and data-related issues.
  • Implement new database and application specifications and modify existing solutions as requirements evolve.
  • Coordinate with Web Developers on implementation, integration, testing, and debugging of web-based applications.
  • Respond quickly to reported problems, system alerts, and priority requests.
  • Provide technical recommendations to the Program Director and other HSR/ORD research leaders and managers.
  • Develop and maintain clear technical documentation.
  • Support ad hoc technical projects and special requests.
Minimum Qualifications:
  • 4–5 years of SQL database administration and programming experience.
  • 3–5 years of experience developing complex database operations, queries, and scripts.
  • Demonstrated knowledge of Microsoft SQL Server database administration and related products.
  • Experience with database design and technical documentation.
  • Experience supporting database backup, recovery, security, and data integrity.
  • Strong troubleshooting and problem-solving skills.
  • Ability to communicate technical issues and recommendations clearly to technical and non-technical stakeholders.
Desired Qualifications:
  • Experience with SQL Server Reporting Services (SSRS).
  • Experience with Microsoft Access.
  • Working knowledge of web development technologies such as HTML, JavaScript, ColdFusion/CFML, Java, XML, and OLAP.
  • Experience supporting web applications backed by Microsoft SQL Server.
  • Previous experience supporting VA, VHA, federal health, or healthcare research environments.
About Aptive:

About Aptive. Aptive partners with federal agencies to achieve their missions through improved performance, streamlined operations and enhanced service delivery. Based in Alexandria, Virginia, we support more than a dozen agencies including Veterans Affairs, Transportation, Defense, Homeland Security and the National Science Foundation. We specialize in applying technology, creativity and human-centered services to optimize mission delivery and improve experiences for millions of people who count on government services every day. Founded: 2012. Employees: 300+ nationwide.

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. About Aptive: Aptive partners with federal agencies to achieve their missions through improved performance, streamlined operations and enhanced service delivery. Based in Alexandria, Virginia, we support more than a dozen agencies including Veterans Affairs, Transportation, Defense, Homeland Security and the National Science Foundation. We specialize in applying technology, creativity and human-centered services to optimize mission delivery and improve experiences for millions of people who count on government services every day. Founded: 2012. Employees: 300+ nationwide.

Numbers & Facts

LocationRemote (
Remote
)
Job TypeFull-time

Skills

  • Access Controlunmatched
  • Adobe ColdFusionunmatched
  • ColdFusion Markup Language (CFML)unmatched
  • Communication Skillsunmatched
  • Data Collectionunmatched
  • Data Modelingunmatched
  • Data Qualityunmatched
  • Data Recoveryunmatched
  • Database Administrationunmatched
  • Database Backupunmatched
  • Database Designunmatched
  • Database Programmingunmatched
  • Database Recoveryunmatched
  • Database Technologyunmatched
  • Debugging Skillsunmatched
  • Federal Governmentunmatched
  • Financial Reportingunmatched
  • Governmentunmatched
  • HTML (HyperText Markup Language)unmatched
  • Healthcareunmatched
  • Healthcare Administrationunmatched
  • Homeland Securityunmatched
  • Identify Issuesunmatched
  • Integration Testingunmatched
  • Internet Applicationunmatched
  • Internet Technologyunmatched
  • Javaunmatched
  • JavaScriptunmatched
  • Leadershipunmatched
  • Microsoft Access Databaseunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft SQL Server DBA (Database Administration)unmatched
  • OLAP (OnLine Analytical Processing)unmatched
  • Performance Analysisunmatched
  • Performance Managementunmatched
  • Problem Solving Skillsunmatched
  • Production Systemsunmatched
  • Relational Databases (RDBMS)unmatched
  • Research & Development (R&D)unmatched
  • Research Administrationunmatched
  • SQL (Structured Query Language)unmatched
  • SQL Databasesunmatched
  • SQL Server Reporting Services (SSRS)unmatched
  • Scripting (Scripting Languages)unmatched
  • Service Deliveryunmatched
  • Software Administrationunmatched
  • Stored Proceduresunmatched
  • Technical Supportunmatched
  • Technical Writingunmatched
  • Technical/Engineering Designunmatched
  • Web Programmingunmatched
  • XML (EXtensible Markup Language)unmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder