Database Specialist

• Database Design & Development: Design, develop, and maintain PostgreSQL schemas that support high-volume, multi-tenant financial workloads — including normalization, data modelling, constraints, declarative partitioning, and appropriate use of native types (JSONB, arrays, ranges, UUID, enums).

• SQL & PL/pgSQL Development: Write and review complex SQL, PL/pgSQL functions and procedures, triggers, views, and materialized views to support data extraction, reporting, and system integration needs.

• Performance Optimization: Analyze and tune slow queries using EXPLAIN (ANALYZE, BUFFERS), pg_stat_statements, and auto_explain. Design effective indexing strategies (B-tree, GIN, GiST, BRIN, partial, expression, and covering indexes), manage table/index bloat, tune autovacuum, and optimize server parameters (shared_buffers, work_mem, effective_cache_size, checkpoint and WAL settings).

• Cloud Database Administration (Azure & AWS): Provision, configure, and operate managed PostgreSQL instances in the cloud, including:

◦ Azure: Azure Database for PostgreSQL – Flexible Server; zone-redundant and same-zone HA, read replicas, server parameter groups, built-in PgBouncer, storage/IOPS scaling, private endpoints and VNet integration, Azure Monitor and Log Analytics, Azure Backup and point-in-time restore.

◦ AWS: Amazon RDS for PostgreSQL and Aurora PostgreSQL; Multi-AZ deployments and failover, read replicas and Aurora reader endpoints, parameter/option groups, RDS Proxy, snapshots and PITR, Performance Insights, CloudWatch metrics and alarms, IAM database authentication, Secrets Manager integration.

• Standalone / Self-Managed PostgreSQL Administration: Install, configure, harden, and operate PostgreSQL directly on Linux servers (on-premise, VMs, or cloud IaaS) without a managed service layer, including:

◦ End-to-end installation and upgrade of PostgreSQL from packages or source; management of postgresql.conf, pg_hba.conf, and pg_ident.conf.

◦ OS-level tuning for database workloads — kernel parameters, hugepages, filesystem and storage layout, tablespaces, I/O scheduler, memory and swap configuration, ulimits, and systemd service management.

◦ Building and operating HA clusters using tools such as Patroni, repmgr, or pg_auto_failover, with etcd/Consul, and HAProxy / Keepalived / virtual IPs for failover and connection routing.

◦ Backup and recovery using pgBackRest, Barman, WAL-G, or pg_basebackup, with WAL archiving and validated point-in-time recovery.

◦ Independent monitoring, alerting, and log management (Prometheus + postgres_exporter, Grafana, pgBadger, Zabbix, Nagios, or similar), since no cloud-native metrics are provided.

◦ Capacity planning, patching, security hardening, and OS/database lifecycle management.

• High Availability, Backup & Recovery: Design and regularly test backup, restore, and disaster recovery procedures. Manage streaming and logical replication, WAL archiving, PITR, failover/switchover runbooks, and defined RPO/RTO targets.

• Upgrades & Migrations: Plan and execute PostgreSQL major and minor version upgrades with minimal downtime. Support migrations to PostgreSQL from other engines (e.g., SQL Server, MySQL, Oracle) and between clouds, using tools such as AWS DMS, Azure Database Migration Service, pglogical, or logical replication.

• Connection & Scale Management: Implement and tune connection pooling (PgBouncer, pgpool-II, RDS Proxy), read/write splitting, and workload isolation for high-concurrency application traffic.

• Data Security & Compliance: Implement and maintain role-based access control, row-level security (RLS), TLS enforcement, encryption at rest via Azure Key Vault / AWS KMS, pgcrypto, and auditing via pgaudit. Ensure database practices meet financial-industry security and compliance requirements.

• Extensions & Tooling: Evaluate and manage PostgreSQL extensions relevant to our workloads (pg_stat_statements, pg_partman, pgaudit, pgcrypto, postgres_fdw, pg_repack, TimescaleDB, PostGIS, Citus as applicable).

• Collaboration: Work closely with software developers, DevOps, data analysts, and IT teams to review schema changes and queries before release, and to translate business requirements into sound database solutions.

• Troubleshooting: Diagnose and resolve database issues including lock contention and deadlocks, long-running transactions, transaction ID wraparound risk, replication lag, bloat, connection exhaustion, and network/connectivity problems.

• Documentation: Maintain comprehensive documentation of schemas, ER diagrams, query patterns, tuning decisions, runbooks, and administrative procedures.

Requirements

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

• 4+ years of hands-on experience with PostgreSQL, covering design, development, and administration in production environments.

• Proven experience operating managed PostgreSQL in the cloud is required — Azure Database for PostgreSQL (Flexible Server) and/or Amazon RDS / Aurora PostgreSQL. Experience with both Azure and AWS is strongly preferred.

• Proven experience running standalone / self-managed PostgreSQL on Linux is required — installation, configuration, OS-level tuning, HA cluster setup (Patroni / repmgr / pg_auto_failover), and self-managed backup tooling (pgBackRest / Barman / WAL-G).

• Working proficiency in Linux administration and shell scripting (Bash), sufficient to operate and troubleshoot a database host independently.

• Strong command of SQL and PL/pgSQL, including window functions, CTEs, and advanced query constructs.

• Deep understanding of PostgreSQL internals: MVCC, vacuum and autovacuum, the query planner and statistics, WAL, transaction isolation levels, and locking behaviour.

• Solid experience with indexing strategy, query plan analysis, and end-to-end query optimization.

• Practical experience with backup/restore, PITR, replication, and high-availability configurations.

• Experience with schema version control and migration tooling (Flyway, Liquibase, Alembic, or similar).

• Experience with SQL Server, MySQL, or other relational database systems is a plus.

• Experience with ETL processes and tools is a plus.

• Excellent problem-solving skills and attention to detail.

• Ability to work independently and collaboratively in a team environment.

• Strong written and verbal communication skills.

Requirements

• PostgreSQL certification (EDB, or equivalent cloud database certifications such as Azure Database Administrator Associate / AWS Database Specialty).

• Experience with Infrastructure as Code for database provisioning and configuration management (Terraform, Bicep, ARM, CloudFormation, Ansible).

• Experience running PostgreSQL in containers or Kubernetes (Docker, CloudNativePG, Crunchy Postgres Operator, Zalando Postgres Operator).

• Familiarity with DevOps practices and CI/CD pipelines for database changes (Azure DevOps, GitHub Actions, Jenkins).

• Monitoring and observability experience with tools such as pgwatch2, Prometheus + Grafana, Datadog, pgBadger, Azure Monitor, or CloudWatch.

• Experience with data warehousing and BI tools (Azure Synapse, Amazon Redshift, Power BI, Tableau).

• Experience with distributed or time-series PostgreSQL extensions (Citus, TimescaleDB).

• Knowledge of NoSQL databases (e.g., MongoDB, Redis, Cassandra) is an advantage.

• Exposure to big data technologies (e.g., Spark) is a plus.

• Prior experience in FinTech, trading, or other high-transaction, regulated domains.

Benefits

• Unique experience in the Fin-Tech industry, with a leading, fast-growing company.

• Good atmosphere at work and a comfortable working environment.

• Coverage for Self + Family (Spouse and up to 2 Children).

• Attractive leave benefits including Maternity, Paternity Benefit, Vacation Leave & Leave Encashment.

• Reward & Recognition – Monthly, Quarterly.

• Loyalty benefits & Leaves.

• Employee referral program.