Database Engineer(SQL Performance & Optimization) are responsible for Analyze and optimize SQL queries, indexes, and stored procedures to improve application performance. They have to Collaborate with development teams to design efficient database schemas and ensure scalability.
Duties & Responsibilities
- Analyze and optimize SQL queries, indexes, and stored procedures to improve application performance.
- Collaborate with development teams to design efficient database schemas and ensure scalability.
- Monitor database health, troubleshoot bottlenecks, and implement proactive performance improvements.
- Work on transaction isolation strategies (e.g., RCSI) and replication setups to balance performance and consistency.
- Automate routine database maintenance tasks and performance checks.
- Ensure high availability, disaster recovery, and backup strategies are in place.
- Stay updated with emerging database technologies and recommend improvements.
- Communicate in a professional manner when interacting with coworkers and external customers
- Participate in internal and external technical reviews, as required
- Other duties and projects as assigned
Skills Required
- Excellent time management, resource organization and priority establishment skills, and ability to multi-task in a fast-paced environment and ability to work independently and as part of a team
- Core SQL expertise: Advanced query writing, stored procedures, triggers, indexing strategies.
- Database performance tuning: Query optimization, execution plan analysis, partitioning, caching, and indexing.
- Database design & architecture: Normalization, schema design, data modeling, and scalability planning.
- Monitoring & troubleshooting: Experience with profiling tools (e.g., SQL Profiler, Query Store, Performance Monitor).
- Hands-on with RDBMS: Strong knowledge of MS SQL Server, MySQL, PostgreSQL, or Oracle.
- Optimization techniques: Locking, concurrency control, transaction isolation levels (e.g., RCSI), and replication strategies.
- Scripting & automation: Familiarity with Python/PowerShell for automation of DB tasks.
- Cloud & modern DB platforms: Exposure to Azure SQL, AWS RDS, or Google Cloud SQL.
- Soft skills: Problem-solving mindset, ability to collaborate with developers, and clear communication of technical findings
Qualifications
- Have HEART. To work here, you must be:
- Humble self-aware and respectful
- Effective measurably move the needle& immeasurably add value
- Adaptable innately curious and constantly changing
- Remarkable stand out in some way
- Transparent openly and honestly sharing knowledge
- 6 to 10 years experience with software development post BE/B.Tech, ME/M.Tech or MCA
- Should have worked with Scaled Agile Framework
