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.