Senior Data Engineer
symplr
Full-time
On-site
Bangalore, Karnataka, India
Senior Jobs
Overview
- 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.
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.