Data Engineer

Consolidated Analytics, Inc.; Chennai; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Consolidated Analytics, Inc. in Chennai, India, seeks an experienced Database Engineer to manage development, migration, and optimization across SQL Server, MySQL, PostgreSQL, and Snowflake.

The role requires 3+ years of hands-on work, collaboration with software teams, and implementing security, backup, and disaster recovery, with cloud platforms (AWS/Azure/GCP) to enable scalable data solutions. A minimum of three years hands-on experience is required.

Qualifications

• 3+ years hands-on experience in database development, management, architecture, migration and optimization.
• Proven experience with SQL Server, Python and Snowflake is mandatory. MySQL, PostgreSQL are preferable.
• Strong SQL and T-SQL scripting abilities.
• Experience with NoSQL databases (e.g., MongoDB, Cassandra) is preferred.
• Familiarity with cloud platforms and data security practices.

Responsibilities

• Design, develop, and maintain SQL Server and other databases.
• Write efficient queries, stored procedures, and functions.
• Collaborate with application developers to design and optimize database structures.
• Implement and manage database security, backup, and recovery plans.
• Monitor and optimize the performance of the database systems.
• Design and implement database systems based on business requirements.
• Ensure database architecture aligns with enterprise standards and best practices.
• Create and maintain data models and database diagrams.
• Plan and execute data migrations between systems, ensuring data integrity and minimal downtime.
• Optimize database performance through indexing, query tuning, and hardware/software configuration.
• Implement and maintain data replication and clustering solutions.
• Implement database security measures to protect sensitive data.
• Ensure compliance with relevant data protection regulations and policies.
• Conduct regular security audits and vulnerability assessments.
• Provide technical support and troubleshooting assistance for database-related issues.
• Respond to and resolve database access and performance issues.
• Collaborate with development teams to assist with database-related application issues.

Skills

SQL

T-SQL

Python

Snowflake

NoSQL

Data Modeling

Cloud Computing

Backup & Recovery

Indexing & Tuning

Replication & Clustering

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

SQL Server

MySQL

PostgreSQL

Snowflake

MongoDB

Cassandra

AWS

Azure

GCP

Job description

Job Overview:

We are seeking an experienced and highly skilled Database Engineer to join our dynamic team. The ideal candidate will have over 3 years of hands‑on experience in database development, management, architecture, migration, and optimization. Proficiency in SQL Server is mandatory, with additional expertise in Python, Snowflake, and Cloud technologies considered a plus.

Key Responsibilities:

• Database Development and Management:
  • Design, develop, and maintain SQL Server and Other databases (MySQL, PostgreSQL).
  • Write efficient, complex queries, stored procedures, and functions.
  • Collaborate with application developers to design and optimize database structures.
  • Implement and manage database security, backup, and recovery plans.
  • Monitor and optimize the performance of the database systems.
• Database Architecture and Design:
  • Design and implement database systems based on business requirements.
  • Ensure database architecture aligns with enterprise standards and best practices.
  • Create and maintain data models and database diagrams.
• Database Migration and Optimization:
  • Plan and execute data migrations between systems, ensuring data integrity and minimal downtime.
  • Optimize database performance through indexing, query tuning, and hardware/software configuration.
  • Implement and maintain data replication and clustering solutions.
• Security and Compliance:
  • Implement database security measures to protect sensitive data.
  • Ensure compliance with relevant data protection regulations and policies.
  • Conduct regular security audits and vulnerability assessments.
• Support and Troubleshooting:
  • Provide technical support and troubleshooting assistance for database-related issues.
  • Respond to and resolve database access and performance issues.
  • Collaborate with development teams to assist with database-related application issues.

Qualifications:

• Education:
  • Bachelors degree in Computer Science, Information Technology, or a related field.
• Experience:
  • Minimum of 3 years of hands‑on experience in database development, management, architecture, migration, and optimization.
  • Proven experience with SQL Server, Python and Snowflake is mandatory. MySQL, PostgreSQL are preferable.
• Technical Skills:
  • Strong knowledge of SQL and T‑SQL scripting.
  • Experience with NoSQL databases (e.g., MongoDB, Cassandra) is preferred.
  • Familiarity with Snowflake data warehousing solutions.
  • Experience with cloud platforms (e.g., AWS, Azure, GCP) and cloud‑based database services.
  • Knowledge of database security, backup and recovery, and disaster recovery procedures.
  • Understanding of database replication, clustering, and high availability solutions.
• Soft Skills:
  • Excellent problem‑solving and analytical skills.
  • Strong communication and interpersonal skills.
  • Ability to work independently and as part of a team.
  • Detail‑oriented with a focus on accuracy and quality.

Preferred Certifications:

• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified: Data Analyst Associate
• Snowflake SnowPro Certification
• AWS Certified Database - Specialty