Data Modeler/SQL Database Developer

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.

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.

• 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.

• 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.

Physical Requirements: While performing the duties of this job, the employee is regularly required to sit for extended periods, use a computer keyboard and mouse, and communicate verbally and in writing. The employee may occasionally need to stand, walk, bend, or lift up to 15 pounds. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this role.

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.

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.