Database Administrator (SQL Server / AWS)

Yashwe; United States; Remote; USD 110,000 - 170,000; Full time

Job summary

Yashwe is seeking a Database Administrator to own and support our production SQL Server environment in AWS. You will keep databases reliable, secure and performant, collaborating closely with the development team on schema design, query tuning, deployments and data pipelines.

Responsibilities include administering SQL Server in AWS (RDS/EC2), resolving performance issues, writing and optimizing T-SQL, and ensuring security and documentation.

Qualifications

• 7+ years of hands-on SQL Server administration, including production support.
• Experience running SQL Server in AWS.
• Strong SQL and T-SQL skills, with a track record of performance tuning.
• Working knowledge of data pipeline tools such as dbt.
• Comfort working collaboratively with development teams.

Responsibilities

• Administer and support production SQL Server databases running in AWS (RDS and/or EC2), including monitoring, backups, recovery, patching and high availability.
• Troubleshoot and resolve performance issues, blocking and production incidents
• Write, review and optimise T-SQL, including stored procedures, views and indexing strategies.
• Partner with developers on database design, code reviews, release deployments and data changes
• Support data pipelines and transformations built with tools such as dbt
• Maintain security, access controls and documentation for database environments
• Participate in on-call rotation / after-hours maintenance windows

Skills

SQL Server

T-SQL

Performance tuning

AWS

dbt

Tools

RDS/EC2

PowerShell

CI/CD for databases

Job description

We're looking for a Database Administrator to own and support our production SQL Server environment in AWS. You'll keep our databases reliable, secure and performant, and work closely with the development team on schema design, query tuning, deployments and data pipeline work.

What you'll do

• Administer and support production SQL Server databases running in AWS (RDS and/or EC2), including monitoring, backups, recovery, patching and high availability.
• Troubleshoot and resolve performance issues, blocking and production incidents
• Write, review and optimise T-SQL, including stored procedures, views and indexing strategies.
• Partner with developers on database design, code reviews, release deployments and data changes
• Support data pipelines and transformations built with tools such as dbt
• Maintain security, access controls and documentation for database environments
• Participate in [on-call rotation / after-hours maintenance windows]

What you bring

• [7]+ years of hands-on SQL Server administration, including production support
• Experience running SQL Server in AWS
• Strong SQL and T-SQL skills, with a track record of performance tuning
• Working knowledge of data pipeline tools such as dbt
• Comfort working collaboratively with development teams

Nice to have

• Exposure to PostgreSQL and Amazon Aurora MySQL
• Familiarity with infrastructure-as-code, CI/CD for databases or scripting (PowerShell, Python)
• AWS certifications