Flag job

Report

Revalsys Technologies - Lead SQL Developer - Amazon RDS

Min Experience

5 years

Location

Hyderabad, Telangana, India

JobType

full-time

About the job

Info This job is sourced from a job board

About the role

Role Overview

The Lead SQL Developer will be responsible for designing, developing, and optimizing enterprise-level SQL queries, procedures, and data models.

This is a hands-on leadership role that requires deep expertise in SQL programming, data warehousing concepts, and performance tuning, combined with the ability to mentor junior developers and coordinate with cross-functional teams.

Key Development & Data Engineering

  • Design, write, and optimize complex SQL queries, stored procedures, triggers, functions, and views.
  • Develop and maintain ETL/ELT workflows to support data integration and transformation processes.
  • Build and manage data models, data dictionaries, and schema designs for structured databases.
  • Collaborate with BI, analytics, and application development teams to deliver efficient data solutions.

Performance Tuning & Optimization

  • Analyze and troubleshoot slow-performing queries and implement performance improvements.
  • Use indexing, partitioning, and best practices to optimize database performance.
  • Conduct regular query profiling, execution plan analysis, and load testing.

Leadership & Project Ownership

  • Lead and mentor a team of SQL/database developers, promoting clean code practices and technical excellence.
  • Participate in requirement gathering and technical solution design with stakeholders.
  • Own delivery timelines, ensure data quality, and manage release cycles.

Data Governance & Security

  • Ensure compliance with data governance and security policies, including data masking, encryption, and role-based access.
  • Maintain data integrity, accuracy, and consistency across environments.

Documentation & Standards

  • Maintain detailed technical documentation, including ER diagrams, data flow diagrams, and code repositories.
  • Enforce coding standards, naming conventions, and version control practices.

Technical Skills & Skills

  • SQL (Advanced Level) Complex joins, subqueries, window functions, stored procedures, triggers
  • RDBMS Platforms Microsoft SQL Server, PostgreSQL, MySQL, Oracle
  • ETL Tools SSIS, Talend, Apache NiFi, or similar
  • Data Warehousing Snowflake, Redshift, Google BigQuery, or Azure Synapse
  • Performance Tuning Execution plans, indexing, partitioning, database optimization
  • Version Control Git, Bitbucket

Preferred / Bonus Skills

  • Cloud Platforms Azure SQL, AWS RDS, GCP BigQuery
  • NoSQL Databases MongoDB, Cassandra (as per use case)
  • Scripting Languages Python, Shell scripting for automation
  • BI/Reporting Tools Power BI, Tableau, Looker (for integration knowledge)
  • DevOps/DataOps Concepts CI/CD pipelines, automated testing for data workflows

Qualifications

  • Bachelors or Masters degree in Computer Science, Information Technology, or related field.
  • 58 years of relevant experience in SQL/database development and data engineering.
  • Proven experience leading SQL development projects and mentoring junior engineers.
  • Strong analytical and problem-solving skills.
  • Excellent verbal and written communication abilities.

What We Offer

  • Opportunity to lead mission-critical data engineering efforts in a fast-growing company.
  • Collaborative, innovation-first work environment.
  • Access to modern data tech stack and cloud platforms.
  • Competitive salary and performance-linked incentives.
  • Learning support, certifications, and career advancement opportunities

(ref:hirist.tech)

About the company

Revalsys Technologies

Skills

sql
java
c