Microsoft SQL Server Administrator

Wintrio Llc
Silver Spring, United States of America
6 days ago

Role details

Contract type
Permanent contract
Employment type
Part-time / full-time
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Silver Spring, United States of America

Tech stack

Data analysis
Azure
Backup Devices
Computer Programming
Databases
Data Governance
ETL
Database Queries
Database Security
Disaster Recovery
Failover Clustering
Log Shipping
Microsoft SQL Server
Performance Tuning
Query Optimization
Role-Based Access Control
SQL Stored Procedures
SQL Databases
Systems Integration
T-SQL
Transaction Data
Backup and Restore
Enterprise Software Applications
System Availability
Grafana
Database Performance
Amazon Web Services (AWS)
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