Mid to Senior SQL Server DBA/Developer
Salário Estimado
R$ 12.870,00 - R$ 19.305,00
Descrição da Vaga
We are seeking a highly skilled Mid - to Senior SQL Server DBA/Developer.
This is a hands-on, technical role responsible for administering, optimizing, modernizing, and supporting mission-critical SQL Server environments for a federal civilian agency in the Washington D.
C. area.
The ideal candidate has deep expertise in SQL Server internals, strong T-SQL development skills, takes ownership of work, collaborates effectively across teams, and thrives in a high-performance, data-driven environment.
Salary range: $109K - $129K Key Responsibilities Database Administration & Operations • Install, configure, patch, and upgrade SQL Server instances (2016, 2019, 2022)
Requisitos
- T-SQL Development & Code Quality
- Automate tasks using T-SQL, PowerShell, CMD, batch scripting, and dbatools
- 7+ years of hands-on SQL Server DBA and development experience in production environments
- Strong expertise in HA/DR, Always On, and Failover Clustering
- Advanced T-SQL coding, troubleshooting, and performance tuning skills
- Extensive experience with SSIS and SSRS
- Experience creating SQL Agent Jobs, Maintenance Plans, Task Scheduler jobs, and DBMail configuration
- Strong knowledge of SQL Trace, Extended Events, DMVs, and system tables
- Experience with PowerShell, CMD, and batch scripting
- Experience patching and upgrading SQL Server instances
- Strong understanding of database security, encryption, masking, and access control
- Hands-on experience with Azure SQL and/or cloud-based database environments
- Excellent verbal and written communication skills
- Strong critical thinking and analytical problem-solving abilities
- Detail-oriented with strong documentation discipline
- Ability to work independently and collaboratively across cross-functional teams
- Accountable, proactive, and committed to continuous improvement
Responsabilidades
- Database Administration & Operations
- Install, configure, patch, and upgrade SQL Server instances (2016, 2019, 2022)
- Manage Development, QA, Staging, and Production environments
- Configure and support Windows Server Failover Clustering (WSFC)
- Implement and maintain backup/recovery strategies and disaster recovery testing
- Create and maintain SQL Server Agent Jobs, Maintenance Plans, and Windows Task Scheduler jobs
- Configure and test Database Mail (DBMail)
- Monitor and optimize system health using DMVs, Extended Events, SQL Trace, Query Store, and wait statistics
- Performance Tuning & SQL Server Internals
- Perform advanced performance tuning, indexing strategy design, and execution plan analysis
- Deep understanding of SQL Server engine internals including MAXD
- OP, cardinality estimator behavior, compatibility levels, memory and tempdb configuration
- Identify and resolve blocking, deadlocks, parameter sniffing, and other performance bottlenecks
- Use diagnostic tools such as sp_whoisactive, Idera, and Plan Explorer
- Design, develop, and optimize advanced T-SQL (stored procedures, functions, triggers, views)
- Peer-review SQL code and enforce development best practices
- Refactor existing stored procedures for performance and maintainability
- Identify and fix database code bugs; implement workarounds when necessary
- Troubleshoot application-related data issues and collaborate with software developers to resolve defects
- Data Integration, Automation & Modernization
- Design and maintain SSIS packages and SSRS reports
- Import and export data across diverse source and destination systems
- Participate in SQL Server upgrades and modernization initiatives
- Support Infrastructure-as-Code and DevOps collaboration practices
Benefícios
Vagas Semelhantes
R$ 16k - 25k/mês
• *About FullStack** FullStack is the most transparent IT talent network, connecting highly skilled individuals with top global companies and Silicon Valley startups for remote, on-demand projects. We focus on building a trusted, high-performance network where talent can thrive in a positive, respec...
Full Stack AI Engineer – BuilderEx
R$ 12k - 18k/mês
Remote position, only for professionals based in Argentina or Uruguay At Ryz Labs we are looking for a Full Stack AI Engineer – BuilderEx to build intelligent, secure, and scalable identity experiences across our platforms. In this role, you will work end-to-end—from frontend UX to backend services ...
Mid to Senior SQL Server DBA/Developer
R$ 16k - 25k/mês
We are seeking a highly skilled Mid - to Senior SQL Server DBA/Developer. This is a hands-on, technical role responsible for administering, optimizing, modernizing, and supporting mission-critical SQL Server environments for a federal civilian agency in the Washington D.C. area. The ideal candidate ...
Federal Payroll/T&A - MSSQL DBA/Developer - Mid to Senior
R$ 13k - 19k/mês
We are seeking a highly skilled Mid - to Senior SQL Server DBA/Developer with Federal Payroll/Time & Attendance support experience. This is a hands-on, technical role responsible for administering, optimizing, modernizing, and supporting mission-critical SQL Server environments for a federal civilia...
Informações
Análise de Vaga com IA
Estimativa salarial, match de tecnologias e análise de requisitos feitos com Inteligência Artificial
Quer se preparar melhor? Pratique entrevistas com IA no Recrutadoria ou melhore suas habilidades no BitMentor