Microsoft SQL Server Administrator
Wintrio Llc
Silver Spring, MD, United States
about 1 month ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
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
Job source
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.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
AJ
Austin Joy
over 4 years ago
LM
Luis Minvielle
Top-Paying Tech Jobs (with Salaries)
over 2 years ago
LM
Luis Minvielle
Fully Remote Software Engineer Jobs
about 2 years ago
BB
Benedikt Bischof
Making Data Warehouses Fast: A Developer’s Story
about 4 years ago
LM
Luis Minvielle
The Most Popular IT Jobs on the Market
over 2 years ago
LM
Luis Minvielle
What’s the Difference between a Junior, Mid, and Senior Developer?
about 3 years ago