₹11L – ₹24L a year estimatetypical for IT Jobs in India, 965 posts
Posted 6 days ago
Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Administer and support production SQL Server databases running in AWS (RDS and/or EC2), including monitoring, backups, recovery, patching…
Troubleshoot and resolve performance issues, blocking and production incidents
Write, review and optimise T-SQL, including stored procedures, views and indexing strategies
Must-have skills
SQLdbt
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
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)
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
