Microsoft SQL Server Administrator

Wintrio Llc
Silver Spring, MD, United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Part-time / full-time
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours

Tech stack

Data Analysis Microsoft Azure Backup Devices Computer Programming Databases Data Governance Extract Transform Load (ETL) Database Queries Database Security Disaster Recovery Failover Clustering Log Shipping
+20 more
Microsoft SQL Server Performance Tuning Query Optimization Role-Based Access Control SQL Stored Procedures SQL Databases Systems Integration Transact-SQL Transaction Data Backup and Restore Enterprise Software Applications System Availability Grafana Database Performance Amazon Relational Database Service Information Technology SolarWinds (Software) Redgate Database Monitoring Vulnerability Analysis

Job description

  • It is a fairly part-time and a fully remote role; however, there can be a need to visit the Agency’s data center in Silver Spring, MD in case of an outage or per client’s request.
  • It is a multi-year project where the need is for an individual to “proactively” identify/implement areas of improvement and infuse automation around routine tasks (backups, recovery, patching, upgrades, etc.). Tangible progress/results and client satisfaction are of paramount importance here.
  • An individual must have a strong knowledge and understanding around consolidating and optimizing data sources, with an emphasis on improving data quality and process automation.
  • We are seeking an experienced Microsoft SQL Server Administrator (MSSQL DBA) to manage, maintain, secure, and optimize our SQL Server database environments. The ideal candidate will possess strong expertise in database administration, T-SQL development, stored procedures, query optimization, performance tuning, backup/recovery, and troubleshooting complex database issues.
  • This role requires a highly analytical professional who can support mission-critical applications by ensuring database reliability, security, scalability, high availability, and optimal performance., * Install, configure, upgrade, patch, and maintain Microsoft SQL Server environments across development, testing, and production.
  • Design, develop, maintain, and optimize complex stored procedures, functions, views, and T-SQL scripts.
  • Write efficient SQL queries for reporting, integrations, ETL processes, and application support.
  • Analyze execution plans and optimize queries for maximum performance.
  • Monitor and tune database performance to minimize latency and maximize throughput., * Design, implement, and maintain backup, recovery, and disaster recovery strategies, including full, differential, and transaction log backups.
  • Perform database restore validation and recovery testing.
  • Support and maintain high-availability solutions, including Always on Availability Groups, Failover Clustering, Log Shipping, and Replication.
  • Ensure database environments meet Recovery Point Objective (RPO) and Recovery Time Objective (RTO) requirements.

Security & Compliance

  • Implement and maintain database security best practices, including role-based access control, least-privilege permissions, encryption, and auditing.
  • Ensure compliance with organizational, regulatory, and data governance standards.
  • Conduct vulnerability assessments and assist with remediation efforts.

Requirements

  • Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent experience).
  • 5+ years of hands-on experience administering Microsoft SQL Server.
  • Strong experience with T-SQL programming, stored procedures, query optimization, and performance tuning.
  • Candidate must be a US Citizen and reside in the US., * Experience with future cloud migration and hybrid infrastructure environments, including Microsoft Azure SQL and AWS RDS.
  • Experience with database monitoring and observability tools such as SolarWinds or Redgate SQL Monitor.
  • Experience supporting legacy enterprise applications with heavy stored procedure dependencies, complex joins, cross-database queries, batch synchronization processes, and transactional data integrity requirements is highly preferred.

Soft Skills

  • Strong analytical and problem-solving skills.
  • Excellent troubleshooting abilities.
  • Strong written and verbal communication skills.
  • Attention to detail and commitment to operational excellence.

Benefits & conditions

  • [Full-time / Part-time / Contract position.]
  • [Remote / Hybrid / On-site.]
  • Standard business hours Monday through Friday.
  • Occasional travel may be required to support customer meetings, workshops, or operational activities.
  • Occasional after-hours or emergency support may be required, as applicable., * Healthcare (Medical, Dental, and Vision)
  • Flexible Spending Account (FSA) and Health Savings Account (HSA)
  • 401(k) and Retirement Savings Plan
  • Annual Bonus and Profit Sharing Opportunities
  • Paid Time Off (PTO) and Vacation
  • Employee Assistance Program (EAP)
  • Life, Personal, and Voluntary Disability Insurance

About the company

This position offers opportunities to work with modern technologies, support mission-critical Federal programs, and contribute to cloud modernization, cybersecurity, artificial intelligence (AI), data analytics, software engineering, and digital transformation initiatives. At WINTrio, we foster an employee-driven culture that values innovation, collaboration, technical excellence, and continuous professional development.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.wintrio.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:36 min

Critical infrastructure and performance skills for modern developers

Andrew Holway · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

10:40 min

Visualizing Prometheus open metrics using custom Grafana dashboards

Stijn Polfliet · LIVE

1:52 min

Evolution of distributed SQL database management systems

Akmal Chaudhri Akmal Chaudhri · LIVE

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · WWC 2021

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

Videos

See all

Related articles

See all