Data Modeler, SQL Database Developer
Posted 5hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Modeler developing and maintaining Microsoft SQL databases for Aptive’s federal Veterans Health Administration projects. Supporting research administration, reporting, compliance, and web applications.
Responsibilities:
- 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 for 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 to reported problems, system alerts, and priority requests
- Provide technical recommendations to the Program Director and HSR/ORD research leaders and managers
- Develop and maintain technical documentation
- Support ad hoc technical projects and special requests
Requirements:
- 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) is desired
- Experience with Microsoft Access is desired
- Working knowledge of HTML, JavaScript, ColdFusion/CFML, Java, XML, and OLAP is desired
- Experience supporting web applications backed by Microsoft SQL Server is desired
- Previous experience supporting VA, VHA, federal health, or healthcare research environments is desired
Benefits:
- Full-time employment
- Remote work arrangement











