> Markdown version of [/jobs/ext/1977807-sql-server-dba](https://www.wearedevelopers.com/jobs/ext/1977807-sql-server-dba). 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).

---

# SQL Server DBA

- **Company:** TriosysIT Inc.
- **Location:** United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Admin Tools, Software Applications, Databases, Data Dictionary, Data Governance, Software Debugging, Job Scheduling, Microsoft Office, Microsoft Visio, Microsoft SQL Server, Team Foundation Server, Performance Tuning, Sqlprofiler, Standard Sql, Software Engineering, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Database Engines, Web Applications, Physical Data Models, Perfmon, SQL Server Management Studio (SSMS), Commvault
- **Published:** August 7, 2026
- **Apply:** https://www.dice.com/job-detail/b9b3ccbe-b2dc-404a-b5e9-098772ed03ec

## About the Role

1. Resources shall have two (2) years of public sector experience working with SQL databases on health and human services projects. Child support enforcement program experience is preferred.

 2. Solid experience in complete Software Development Life Cycle (SDLC) of software and web applications including analysis, design, development, integration, implementation, maintenance, debugging, testing, and reports.

Technical Requirements

Contractor resources shall meet the following requirements:

 1. Master's degree in computer applications or related field and minimum 5 years of experience

 2. Databases: Microsoft SQL Server

 3. Tools: SQL Server Management Studio, SQL Profiler, SSIS, SSRS, SSAS, Import Export Utility, BCP, Commvault Backup and Recovery tool, Perfmon Admin Tool, ARGENT Scheduler, ERWIN, MS VSS, TFS, MS Office and MS Visio.

## Description

1. Install, configure, and maintain Microsoft SQL Server Databases in a highly distributed, secure enterprise environment.

 2. Maintains Development, Staging, Training and Production environments.

 3. Review SQL code, optimizing code, checking coding standards against ANSI standards.

 4. Maintains data standards, including adherence to the Data Protection Act

 5. Monitoring performance and working with SQL profiler and Database Engine Tuning Advisor for tuning queries, indexes, to find performance issues, etc.

 6. Develop SSIS packages, scheduled them as jobs and deploy packages in SQL Server Integration Services.

 7. Implementation of SQL logins, users, roles and authentication modes as a part of security policies

 8. Create and monitor NAS backups and maintain backups as per State and federal retention policies.

 9. Analyze, solve, and correct the production issues based on help desk tickets.

 10. Create, maintain and monitor nightly batch jobs using Argent Job scheduler and Argent Queue Engine.

 11. Creates physical data model and maintains/modifies as needed

 12. Assists with complex queries

 13. Review execution plans to determine where indexes can be built to improve performance

 14. Writes database documentation, including data standards, procedures and definitions for the data dictionary ('metadata')

 15. Controls access permissions and privileges

 16. Develops, manages and tests backup and recovery plans

 17. Ensures that storage, archiving, backup and recovery procedures are functioning correctly

 18. Conducts capacity planning

 19. Provide 24x7 support for critical production systems and Participate in on-call duty


## 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)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Database DevOps with Containers](https://www.wearedevelopers.com/videos/145-database-devops-with-containers)
- [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)
- [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)
- [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)

## 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 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Software Developer Salary in South Africa](https://www.wearedevelopers.com/magazine/232-software-developer-salary-in-south-africa)