Database Developer

We are looking for a hands-on Database Developer responsible for developing, optimising, and automating database solutions across application, reporting, and data integration workloads. The role requires strong experience in PostgreSQL, SQL development, PL/pgSQL functions, stored procedures, views, ETL/ELT processes, data validation, and database automationThe candidate should be able to work closely with application, data engineering, reporting, and platform teams to build reliable, high-performance database logic and data pipelines.

Responsibilities:

• Write and optimise complex SQL queries, views, functions, stored procedures, and database scripts.
• Develop PostgreSQL functions and procedures using PL/pgSQL.
• Build and maintain ETL/ELT processes for data movement, transformation, validation, and reconciliation.
• Automate recurring database processes such as data loads, refreshes, archival, cleanup, reconciliation, and reporting jobs.
• Support application teams with efficient database logic, data access patterns, and query optimisation.
• Create and maintain tables, indexes, partitions, views, materialised views, and database objects.
• Perform data analysis, data correction, data migration, and production data fixes as required.
• Optimise slow queries using execution plans, indexing, partitioning, query rewriting, and database best practices.
• Work on batch jobs, scheduled jobs, scripts, and automation using SQL, Python, Shell scripting, Airflow, or similar tools.
• Ensure data quality, accuracy, consistency, and source-to-target reconciliation.
• Support reporting, dashboards, MIS, analytics, and operational data requirements.
• Follow database coding standards, version control, deployment, rollback, and release processes.
• Troubleshoot production issues related to SQL performance, failed jobs, data mismatches, locking, and database errors.

Requirements:

• Strong hands-on experience in PostgreSQL.
• Strong SQL development skills, including joins, CTEs, window functions, aggregation functions, procedures, and views.
• Good experience with PL/pgSQL, stored procedures, functions, triggers, and database scripting.
• Experience in ETL/ELT development, data transformation, data loading, and reconciliation.
• Good understanding of indexing, partitioning, query tuning, execution plans, and performance optimisation.
• Experience in database automation using SQL, Python, shell scripts, Airflow, cron, or similar schedulers.
• Understanding of data modelling, normalisation, denormalisation, and table design.
• Ability to work with large datasets and optimise batch processing workloads.
• Good knowledge of data validation, exception handling, logging, audit trails, and error handling.
• Understanding of Git, CI/CD, deployment scripts, and database change management.
• 5-10 years of experience in database development, SQL development, ETL development, or data engineering.
• Strong hands-on experience in PostgreSQL development and database process automation.
• Experience working on production systems, reporting workloads, batch jobs, and business-critical data pipelines.

Preferred Skills:

• Experience with ClickHouse, MongoDB, Redis, Kafka, or Elasticsearch is an added advantage.
• Exposure to data warehouse, data lake, CDC, Kafka-based ingestion, or analytics platforms.
• Experience in financial services, wealth management, broking, banking, fintech, or capital markets is preferred.

Ideal Candidate Profile:

• The ideal candidate should be a strong hands-on database developer who can write clean and optimised SQL, build PostgreSQL functions, automate database processes, support ETL/ELT jobs, and troubleshoot data or performance issues.
• The candidate should be comfortable working with application teams, data engineering teams, reporting teams, and production support teams.
• They should be able to independently handle SQL development, database object creation, query optimisation, data validation, reconciliation, automation scripts, and production data fixes.