Job Description

Overview:

ore 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.

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.

Skills Required:
Strong expertise in SQL and relational database systems (SQL Server, MySQL, PostgreSQL, or Oracle). Proven experience in query optimization and database performance tuning. Familiarity with transaction isolation levels, replication, and clustering. Experience with database monitoring tools and performance profiling. Knowledge of cloud-based database services (Azure SQL, AWS RDS, GCP SQL). Strong analytical and problem-solving skills. * Excellent communication and collaboration abilities.