SQL Data Developer - Database Solutions

Job Title : SQL Data Developer

Location : Mysore / Mysuru

Experience : 5-7

Job Summary :

We are seeking an experienced Senior SQL Developer with a minimum of 5 - 7 years of hands-on experience in designing, developing, maintaining, and optimizing database solutions. The role requires deep expertise in SQL, strong database architecture skills, experience with performance tuning, data archival strategies, and the ability to support enterprise-scale applications and data platforms.

Key Responsibilities :

- Design, develop, and maintain complex SQL queries, stored procedures, functions, views, and triggers to support business applications and reporting needs

- Lead database design and schema architecture for large-scale transactional and analytical systems

- Perform advanced query optimization and performance tuning, including indexing, partitioning, and execution plan analysis

- Implement and manage data archival, retention, and purge mechanisms to optimize performance and support compliance requirements

- Develop and maintain automated archival processes using jobs, scripts, or lifecycle policies

- Ensure archived data is secure, auditable, and recoverable when required

- Work with both relational and NoSQL databases to support structured and semi-structured data use cases

- Collaborate with application developers, data engineers, business analysts, and stakeholders to translate requirements into efficient data models

- Support ETL/ELT processes, data integrations, and reporting workflows

- Troubleshoot and resolve production database issues, including data inconsistencies and performance bottlenecks

- Participate in database migrations, upgrades, and cloud or hybrid platform initiatives

- Ensure data integrity, security, backup, and recovery across database systems

- Create and maintain technical documentation for database designs, archival processes, and operational procedures

- Provide technical leadership and mentoring to junior developers and database team members

Required Skills and Qualifications :

- Bachelor's degree in computer science, Information Technology, or a related field (or equivalent experience)

- 5+ years of professional experience as an SQL Developer or Database Developer

- Expert-level proficiency in SQL (T-SQL, PL/SQL, or equivalent)

- Strong experience with relational databases such as SQL Server, Oracle, PostgreSQL, or MySQL

- Hands-on experience with NoSQL databases (e.g., MongoDB, Cassandra, Cosmos DB, DynamoDB)

- Proven experience designing and implementing data archiving and retention strategies

- Strong knowledge of database normalization, indexing, partitioning, and data modeling

- Demonstrated experience in performance tuning and query optimization

- Experience supporting high-availability and high-volume database environments