SQL Server Database Engineering/ Administrator (DBA)
Spectraforce
US
Remote
25 days ago
Job Description
Title: SQL Server Database Engineering/ Administrator (DBA)
Duration: 5+ months
Location: Remote role
Top Skills Required:
1. SQL Server Database Administration
2. High Availability/Disaster Recovery
3. AWS RDS (SQL Server, Postgresql, DocumentDB and DynamoDB)
Job Summary:
Senior SQL Server Database Administrator to lead the design, administration, performance tuning, security, and availability of mission critical Microsoft SQL Server environments across on premises and cloud platforms. This role requires deep technical expertise, strong troubleshooting skills, and the ability to work closely with application, infrastructure, and security teams to ensure high availability, scalability, and reliability of database platforms.
Key Responsibilities:
SQL Server Administration
• Install, configure, upgrade, patching and maintaining Microsoft SQL Server (2019–2022) in production, non-production, and DR environments
• Manage Always On Availability Groups, Failover Cluster Instances (FCI), Replication, and Log Shipping
• Perform capacity planning and proactive performance monitoring.
• Work with App/Dev teams to perform code reviews and schema validations.
Cloud & Hybrid Database Management
• Manage AWS RDS SQL Server, PostgreSQL, DocumentDB, DynamoDB on hybrid platforms.
• Should have good experience in migration of SQL Server Onprem databases to Cloud RDS/Aurora.
• Migration of databases to Aurora Postgres/MySQL and migrating RDBMS/NoSQL databases.
• Configure MultiAZ, Read replica instances in cloud.
• Should have good understanding and experience in performing AWS DMS, S3/VPC/IAM/Security groups in AWS
• Support database migrations using tools like AWS SCT and work with SSMS, SSRS and other SQL tools
• Optimize RDS/cloud database cost, performance, and scalability.
Performance & Optimization
• Analyze and tune query performance, indexes, execution plans, and blocking/deadlock issues
• Optimize tempdb, memory, CPU, and I/O configurations
• Work with developers to improve SQL code quality and database design
Backup, Recovery & DR
• Design and manage backup and restore strategies.
• Perform recovery in AWS Cloud instances.
• Perform regular DR drills and recovery testing
• Support RPO/RTO objectives for business-critical systems
Automation & Monitoring
• Automate routine SQL Installations and DBA tasks using PowerShell, T SQL.
• Implement and manage monitoring tools (SSMS, CloudWatch)
• Create dashboards, alerts, and runbooks
Production Support & Leadership
• Provide L3/L4 support for database incidents and outages
• Participate in on call rotation for critical systems
• Mentor junior DBAs and review operational procedures
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 55.00/hr.
Duration: 5+ months
Location: Remote role
Top Skills Required:
1. SQL Server Database Administration
2. High Availability/Disaster Recovery
3. AWS RDS (SQL Server, Postgresql, DocumentDB and DynamoDB)
Job Summary:
Senior SQL Server Database Administrator to lead the design, administration, performance tuning, security, and availability of mission critical Microsoft SQL Server environments across on premises and cloud platforms. This role requires deep technical expertise, strong troubleshooting skills, and the ability to work closely with application, infrastructure, and security teams to ensure high availability, scalability, and reliability of database platforms.
Key Responsibilities:
SQL Server Administration
• Install, configure, upgrade, patching and maintaining Microsoft SQL Server (2019–2022) in production, non-production, and DR environments
• Manage Always On Availability Groups, Failover Cluster Instances (FCI), Replication, and Log Shipping
• Perform capacity planning and proactive performance monitoring.
• Work with App/Dev teams to perform code reviews and schema validations.
Cloud & Hybrid Database Management
• Manage AWS RDS SQL Server, PostgreSQL, DocumentDB, DynamoDB on hybrid platforms.
• Should have good experience in migration of SQL Server Onprem databases to Cloud RDS/Aurora.
• Migration of databases to Aurora Postgres/MySQL and migrating RDBMS/NoSQL databases.
• Configure MultiAZ, Read replica instances in cloud.
• Should have good understanding and experience in performing AWS DMS, S3/VPC/IAM/Security groups in AWS
• Support database migrations using tools like AWS SCT and work with SSMS, SSRS and other SQL tools
• Optimize RDS/cloud database cost, performance, and scalability.
Performance & Optimization
• Analyze and tune query performance, indexes, execution plans, and blocking/deadlock issues
• Optimize tempdb, memory, CPU, and I/O configurations
• Work with developers to improve SQL code quality and database design
Backup, Recovery & DR
• Design and manage backup and restore strategies.
• Perform recovery in AWS Cloud instances.
• Perform regular DR drills and recovery testing
• Support RPO/RTO objectives for business-critical systems
Automation & Monitoring
• Automate routine SQL Installations and DBA tasks using PowerShell, T SQL.
• Implement and manage monitoring tools (SSMS, CloudWatch)
• Create dashboards, alerts, and runbooks
Production Support & Leadership
• Provide L3/L4 support for database incidents and outages
• Participate in on call rotation for critical systems
• Mentor junior DBAs and review operational procedures
Applicant Notices & Disclaimers
- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 55.00/hr.