JOB TITLE: Sr. Database Developer / Administrator

LOCATION: Remote – US Based

COMPANY OVERVIEW

At APV, we’re more than a technology company — we’re a mission-driven powerhouse transforming organizations through advanced technology and human ingenuity. Our expertise spans AI/ML, data architecture, low-code/no-code development, Agile DevSecOps, and cloud services, delivering scalable and meaningful solutions.

In our Emerging Technology Lab, innovation drives progress. Our teams create intelligent chatbots, AI-powered assistants, robotic process automation (RPA), essay graders, and data analytics platforms. If you’re passionate about solving complex challenges and shaping the future, APV is the place for you. Since 2007, we’ve partnered with federal and state agencies to deliver IT, training, and consulting solutions that achieve mission-critical outcomes. Built on accountability, integrity, and quality, we go beyond expectations. With 70+ prime contracts and a proven record of client success, APV continues to grow — and we’re looking for exceptional talent to grow with us.

At APV, we Always Provide Value

POSITION SUMMARY

Owns database engineering, administration, and ETL operations for the CPSRMS SQL Server environment and the Data Repository/Warehouse, ensuring data integrity, performance, and accurate technical documentation (data dictionary, ERDs) across the system's operations and maintenance lifecycle.

DUTIES

• Administer the SQL Server Database Engine, SSIS packages, and Service Broker supporting CPSRMS and Data Repository/Warehouse ETL processes.

• Perform data corrections, refreshes, and migrations as requested by the COR.

• Monitor and maintain scheduled ETL jobs, batch processes, and database-dependent APIs; report on performance and downtime.

• Maintain and deliver an updated Entity Relationship Diagram and Data Dictionary with every release that impacts the database schema.

• Apply database patches and upgrades, generally scheduled outside CPSC business hours.

• Perform logical and physical data modeling (Erwin) for new development and enhancements.

• Lead root-cause analysis and remediation of data-related defects and database security vulnerabilities.

• Coordinate with the development team on schema changes and integration with other agency systems and data platforms.

EDUCATION

• Bachelor’s degree in computer science or related field.

REQUIRED QUALIFICATIONS

• Minimum of 8 years of applicable experience
• Expert-level SQL Server administration (Database Engine, SSIS, Service Broker).
• ETL design, development, and performance tuning.
• Logical and physical data modeling using Erwin.
• T-SQL development and query optimization.
• Windows Server administration; working knowledge of IIS.
• Experience supporting mission-critical, high-availability production databases.

PREFERRED QUALIFICATIONS

• Familiarity with Elasticsearch and/or Redis in a supporting capacity.
• Experience with federal data security and PII-handling requirements (NIST, FISMA, Privacy Act).
• Prior experience supporting a government incident-management or case-management data warehouse.
• Git, GitHub, and Azure DevOps experience.

ABOUT APV

APV is an Equal Employment Opportunity employer. All qualified applicants are considered without regard to race, color, religion, sex, national origin, age, disability, genetic information, sexual orientation, gender identity, veteran status, or marital status.