Database Developer

Alacriti; Hyderabad; On-site; INR 600,000 - 900,000; Full time

Job summary

Alacriti seeks a Database Developer with 2-3 years of hands-on experience in PostgreSQL, MySQL, and AWS database services. You will design, optimize, and maintain database objects, implement robust data migrations, and monitor cloud-based environments for performance and reliability.

The role requires strong SQL, scripting (Shell/Python), and collaboration with cross-functional teams to ensure scalability, security, and high availability in a fast-paced setting.

Qualifications

• 2-3 years of experience in PostgreSQL, MySQL, and AWS Database Services.
• Strong expertise in SQL query development, stored procedures, functions, triggers, performance tuning, and database optimization.
• Experience with AWS services such as Aurora, RDS, CloudWatch, and Performance Insights.
• Proficiency in Shell Scripting or Python.
• Strong analytical, problem-solving, and collaboration skills in a fast-paced environment.

Responsibilities

• Develop, maintain, and optimize SQL queries, stored procedures, functions, triggers, views, and database objects in PostgreSQL and MySQL.
• Design and implement efficient database solutions while ensuring data integrity, consistency, and security.
• Perform SQL query tuning and database performance optimization to improve application responsiveness.
• Monitor database performance using AWS CloudWatch, Performance Insights, and database logs.
• Support database administration activities, including user and role management, permissions, and maintenance.
• Execute data migration, data validation, and database deployment activities across environments.
• Troubleshoot and resolve database-related issues to minimize downtime.
• Assist development teams in designing optimized database schemas and queries.
• Monitor database health and propose improvements for high availability.
• Support replication, backup, and recovery for PostgreSQL and MySQL.
• Develop automation scripts in Shell (Bash) or Python for DBA tasks.
• Work with AWS Database Services such as RDS and Aurora.
• Analyze logs, execution plans, and performance metrics to identify trends.
• Collaborate with senior DBAs and cross-functional teams for production releases.
• Create and maintain technical documentation for configurations and procedures.
• Follow security, compliance, and change-management standards when changing databases.

Skills

PostgreSQL

MySQL

SQL queries

Stored procedures

Triggers

Views

Indexes

Performance tuning

Execution plans

Shell scripting

Python

AWS CloudWatch

Performance Insights

Amazon RDS

Amazon Aurora

Tools

AWS CloudWatch

Performance Insights

Amazon RDS

Amazon Aurora

Shell (Bash)

Python

Job description

Position Summary:

We are looking for a skilled Database Developer with 2-3 years of experience in PostgreSQL, MySQL, and AWS Database Services to join our team.

The ideal candidate will have strong expertise in SQL query development, stored procedures, functions, triggers, performance tuning, and database optimization. This role involves developing and maintaining database objects, troubleshooting database issues, monitoring database performance, and supporting data migration activities. The candidate will work closely with development teams and Senior Database Administrators to ensure high availability, performance, and reliability of cloud-based database environments.

Experience with AWS services such as Aurora, RDS, CloudWatch, and Performance Insights, along with proficiency in Shell Scripting or Python, will be an added advantage. The ideal candidate should possess strong analytical, problem-solving, and collaboration skills, with the ability to thrive in a fast-paced environment.

Role & responsibilities:

• Develop, maintain, and optimize SQL queries, stored procedures, functions, triggers, views, and database objects in PostgreSQL and MySQL.
• Design and implement efficient database solutions while ensuring data integrity, consistency, and security.
• Perform SQL query tuning and database performance optimization to improve application responsiveness.
• Monitor database performance using AWS CloudWatch, Performance Insights, and database logs to identify and resolve performance bottlenecks.
• Support database administration activities, including user and role management, permissions, and database maintenance.
• Execute data migration, data validation, and database deployment activities across environments.
• Troubleshoot and resolve database-related issues, ensuring minimal downtime and timely resolution.
• Assist application development teams in designing optimized database schemas and writing efficient SQL queries.
• Monitor database health proactively and recommend improvements to ensure high availability and system stability.
• Support replication, backup, and recovery processes for PostgreSQL and MySQL databases.
• Develop automation scripts using Shell (Bash) or Python to simplify database administration and operational tasks.
• Work with AWS Database Services such as Amazon RDS and Amazon Aurora to manage cloud-hosted databases.
• Analyze database logs, execution plans, and performance metrics to identify trends and implement preventive measures.
• Collaborate with Senior Database Administrators and cross-functional teams to support database operations and production releases.
• Create and maintain technical documentation for database configurations, procedures, and best practices.
• Follow database security, compliance, and change management standards while implementing database changes.

Technical skills Required :

• Strong proficiency in PostgreSQL and MySQL database development.
• Expertise in writing and optimizing SQL queries, stored procedures, functions, triggers, views, and indexes.
• Experience with database performance tuning, query optimization, and execution plan analysis.
• Knowledge of AWS Database Services, including Amazon RDS, Amazon Aurora, CloudWatch, and Performance Insights.
• Understanding of database replication, backup, recovery, and data migration processes.
• Experience in user, role, and permission management within PostgreSQL and MySQL.
• Proficiency in Shell (Bash) scripting or Python for automation and database administration tasks.
• Familiarity with database monitoring, logging, troubleshooting, and performance analysis tools.
• Understanding of database security, high availability, and best practices.