Senior Data Engineer

3 - 7 years

5 - 9 Lacs

Posted:20 hours ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

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.

    Mock Interview

    Practice Video Interview with JobPe AI

    Start Python Interview
    cta

    Start Your Job Search Today

    Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

    Job Application AI Bot

    Job Application AI Bot

    Apply to 20+ Portals in one click

    Download Now

    Download the Mobile App

    Instantly access job listings, apply easily, and track applications.

    coding practice

    Enhance Your Python Skills

    Practice Python coding challenges to boost your skills

    Start Practicing Python Now
    Symplr logo
    Symplr

    Software Development

    Houston Texas

    RecommendedJobs for You

    chennai, tamil nadu, india

    hyderabad, telangana, india

    chennai, tamil nadu, india

    chennai, tamil nadu, india