Database Administrator

About Us Hamsa is building the new operating system (O/S) for global finance. The company is growing fast with $400B on platform in 2025 and $1T in 2026. Serving the world's largest financial institutions, Hamsa's Unified Ledger, an AI-enabled shared financial data layer, solves the core issues of interoperability, privacy, and speed. The Role We are seeking a highly skilled Senior Database Engineer with deep expertise in PostgreSQL, along with database-related DevOps experience. The role focuses on designing, optimizing, and maintaining large-scale database environments, with particular emphasis on SQL performance tuning, indexing strategies, query optimization, database scalability, and cost-efficiency improvements. The ideal candidate will have strong DevOps skills for database automation and CI/CD pipelines, plus additional knowledge in financial business systems and blockchain technologies to support advanced data-driven solutions across finance, distributed systems, and large-scale analytics. Responsibilities Lead the implementation of scalable PostgreSQL and cloud data warehouse architectures to support business-critical fintech applications. Proactively monitor system performance and troubleshoot bottlenecks using advanced profiling and warehouse optimization techniques. Drive initiatives to improve database cost-efficiency in cloud environments while ensuring the platform can scale with global demand. Develop standards, operational runbooks, and automated pipelines for safe, seamless schema changes. Ensure all data platforms adhere to strict governance, security protocols, and international financial compliance standards. Act as a subject matter expert for developers and data engineers to refine schema designs and data pipelines. Requirements At least 3–5 years of production experience with PostgreSQL . Mastery of SQL optimization, including advanced indexing, partitioning strategies, and deep execution plan analysis. Understanding of AWS-hosted services (RDS/Aurora) and containerization tools like Docker and Kubernetes . Proven ability to design and manage high availability (HA), failover mechanisms, and complex disaster recovery (DR) strategies. Deep understanding of engine-level operations such as MVCC, vacuuming, and checkpointing. Proficiency in infrastructure-as-code (Terraform or Ansible) and scripting for automation (Python/Bash). Experience in DevOps for databases , including CI/CD integration (e.g., Liquibase) and automation for provisioning and patching. Nice to Have Background in high-frequency trading, payment platforms, or large-scale financial systems. Experience or interest in distributed ledger technology (DLT) and its integration with traditional database systems. Exposure to hybrid data solutions involving NoSQL systems (e.g., Cassandra or MongoDB). Familiarity with real-time data streaming architectures (Kafka, CDC) and modern observability tools like Prometheus or Grafana. #J-18808-Ljbffr