Senior SQL Developer | Experience: 7–9 Years Work | Location: Mysuru – Hybrid

Job Description Senior SQL Developer

Experience: 79 Years

Work Location: Mysuru Hybrid

Job Summary

We are seeking an experienced Senior SQL Developer with strong expertise in database development, performance optimization, database architecture, and data archival strategies. The ideal candidate should have hands-on experience designing, developing, maintaining, and optimizing enterprise-scale database solutions across relational and NoSQL platforms.

The role requires deep technical proficiency in SQL programming, query tuning, indexing, partitioning, ETL support, and high-availability database environments.

Key Responsibilities

• Design, develop, and maintain complex:
• SQL queries
• Stored procedures
• Functions
• Views
• Triggers
• Lead database schema design and architecture for transactional and analytical systems.
• Perform advanced query optimization and performance tuning activities including:
• Indexing
• Partitioning
• Execution plan analysis
• Implement and manage:
• Data archival
• Retention policies
• Data purge mechanisms
• Develop automated archival processes using scripts, jobs, and lifecycle policies.
• Ensure archived data remains secure, auditable, and recoverable.
• Work with both relational and NoSQL databases to support structured and semi-structured data.
• Collaborate with developers, data engineers, analysts, and stakeholders to design efficient data models.
• Support ETL/ELT processes, reporting workflows, and data integrations.
• Troubleshoot production database issues including:
• Performance bottlenecks
• Data inconsistencies
• Query failures
• Participate in:
• Database migrations
• Upgrades
• Cloud and hybrid platform initiatives
• Ensure database integrity, backup, recovery, and security compliance.
• Create and maintain technical documentation for database operations and archival procedures.
• Provide mentoring and technical guidance to junior developers and database teams.

Required Skills & Qualifications

Technical Skills

• Expert-level proficiency in:
• SQL
• T-SQL
• PL/SQL
• Strong experience with relational databases:
• SQL Server
• Oracle
• PostgreSQL
• MySQL
• Hands-on experience with NoSQL databases:
• MongoDB
• Cassandra
• Cosmos DB
• DynamoDB
• Strong knowledge of:
• Database normalization
• Indexing
• Partitioning
• Data modeling
• Query optimization
• Performance tuning
• Experience designing and implementing:
• Data archival strategies
• Retention policies
• High-availability database environments

Additional Skills

• Experience with ETL/ELT workflows and data integration processes.
• Exposure to cloud or hybrid database environments preferred.
• Strong troubleshooting and analytical capabilities.
• Excellent documentation and communication skills.

Educational Qualification

• Bachelors degree in:
• Computer Science
• Information Technology
• Related technical field
• Equivalent practical experience may also be considered.

Preferred Qualifications

• Experience in enterprise-scale application support.
• Knowledge of database security, backup, and disaster recovery practices.
• Exposure to cloud database platforms and modern data engineering ecosystems.
• Experience working in Agile development environments.

Key Competencies

• SQL Development
• Database Architecture
• Query Optimization
• Performance Tuning
• Data Archival & Retention
• ETL/ELT Support
• Relational & NoSQL Databases
• Troubleshooting & Problem Solving
• Technical Leadership
• Enterprise Database Management