> Markdown version of [/jobs/ext/1277519-senior-sql-server-database-developer-administrator](https://www.wearedevelopers.com/jobs/ext/1277519-senior-sql-server-database-developer-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior SQL Server Database Developer/Administrator - **Company:** A P Ventures LLC - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Microsoft Azure, Backup Devices, Information Systems, Databases, Data Dictionary, Data Infrastructure, Extract Transform Load (ETL), Data Migration, Database Schema, Database Security, Entity Relationship Models, Microsoft SQL Server, SQL Azure, Performance Tuning, Service-Oriented Architecture, Software Engineering, SQL Server Integration Services, Database Engines, Database Optimization, Software Troubleshooting, Appian, Database Performance, Information Technology, SQL Server Management Studio (SSMS), Database Backup, Software Version Control, Plan of Action and Milestones - **Published:** July 15, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=659fb4a1d64c75e5 ## About the Role * Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical field; Master's degree preferred. Additional years of directly relevant experience may be substituted for education requirements., * This position supports a U.S. federal government program. Candidates must be U.S. citizens, U.S. nationals, or lawful permanent residents and be able to successfully complete any required federal background investigation. * Minimum eight (8) years of SQL Server administration and development experience, including SQL Server Integration Services (SSIS) and Service Broker. * Demonstrated experience with logical and physical data modeling using Erwin. * Experience with data migration, data correction activities, ETL design, and troubleshooting. * Working knowledge of Appian backend database structures and integration requirements. * Experience with Git/GitHub, Azure DevOps, and CI/CD pipelines supporting database deployments. * Experience managing database updates, patching activities, and implementation of security controls * Experience with Azure SQL and Azure cloud administration concepts. * Experience delivering Entity Relationship Diagrams and data dictionaries as contract deliverables. * Strong troubleshooting, performance tuning, and database optimization skills. Preferred Skills: * Microsoft SQL Server certification (MCSA, MCSE Data Platform, or Azure Database Administrator Associate). * Prior federal agency experience. * Familiarity with NIST security controls applicable to database systems. * Experience supporting large-scale enterprise case management, workflow, or transactional systems. ## Description The Senior SQL Server Database Developer/Administrator owns the SQL Server data tier supporting the organization's Appian-based case management platforms, including database administration, ETL processes, data corrections and migrations, and delivery of entity relationship diagrams and data dictionaries required as recurring contract deliverables., The Senior SQL Server Database Developer/Administrator will: * Administer and develop SQL Server databases, including Database Engine, SSIS, and Service Broker components supporting Appian-based applications and integrated systems. * Deliver and maintain updated Entity Relationship Diagrams (ERDs) and data dictionaries, with updates issued for each release impacting the database schema and final versions delivered at the end of each period of performance. * Perform data corrections, refreshes, and migrations as required or requested by the COR. * Monitor and maintain scheduled ETL processes, batch jobs, and system services; track performance metrics, report results, and escalate issues as appropriate. * Apply database security patches and remediate POA&M findings affecting database components. * Perform logical and physical data modeling using Erwin or equivalent modeling tools. * Support source control management of all database code, scripts, and migration artifacts, ensuring they are properly maintained in the designated repository. * Support IV&V and User Acceptance Testing (UAT) activities related to database changes and deployments. * Collaborate with application development teams to support database performance, reliability, and scalability requirements. * Maintain technical documentation related to database architecture, configurations, and change management activities. ## Related Videos - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Azure-Well Architected Framework - designing mission critical workloads in practice](https://www.wearedevelopers.com/videos/1529-azure-well-architected-framework-designing-mission-critical-workloads-in-practice) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers)