Database Developer

Xpressbees; New Delhi, Pune District, Gurugram District; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Xpressbees seeks a qualified Database Developer to design, implement, test and maintain robust databases. You will collaborate with developers to ensure data reliability, performance and system consistency across services.

Responsibilities include configuring clusters, optimiser queries, and implementing stored procedures. Experience migrating from SQL Server to Postgres is valued, along with strong communication across teams.

Qualifications

• Experience with PostgreSQL and MySQL databases.
• Deployment, maintenance and monitoring of DBs on AWS.
• Strong understanding of database design, queries and optimization.

Responsibilities

• Set up, configure and monitor database clusters with master/slave configurations and failover.
• Optimise queries and manage locking/deadlocks in production.
• Create/maintain tables, views, indexes and triggers; develop stored procedures.

Skills

PostgreSQL

MySQL

AWS

Database design

Query optimisation

Education

Bachelor of Computer Science

Job description

Role Description: We are looking for a qualified Database developer to design stable and reliable databases as per our company’s needs. You will be responsible for developing, testing, improving, and maintaining new and existing databases to help retrieve data effectively. As part of our team, you will work closely with developers to ensure system consistency.

Key Responsibilities:

• Set up, configure, manage & monitor database clusters with master, slave configurations, and failover.
• Cost optimisation of Amazon instances using databases.
• Optimise database queries and ensure that table locking/deadlocks happen in production
• Create and maintain database tables, views, indexes and triggers.
• Develop and maintain stored procedures.
• Knowledge of database design principles, query optimisation, index management, and integrity
• checks, statistics and isolation levels.
• Experience in migration from SQL Server to Postgres.
• Work with all levels of development from analysis through implementation and support.
• Interact with business analysts and UI developers to establish/clarify their requirements
• Skilled at optimising large, complicated SQL statements & Stored Procedures.
• Measure database performance and troubleshoot complex database issues and IO bottlenecks.
• A good attitude towards work and flexibility are desired

Required Skills & Qualifications:

• Experience and Knowledge of multiple databases, such as Postgres/Mysql
• Experience and Knowledge of installation, deployment and maintenance of DB's.
• Experience working on AWS
• Excellent verbal and written communication skills.

Education Qualifications:

Bachelor of Computer Science or equivalent