PostgreSQL Database Administrator

Kissht; Mumbai; On-site; INR 800,000 - 1,500,000; Full time

Job summary

Kissht is seeking a Database Administrator (DBA) with 3-5 years of experience in managing high-volume transactional databases. The ideal candidate will ensure low-latency performance and data security, with a strong understanding of AWS or GCP database services.

The role includes responsibilities such as optimizing infrastructure, maintaining high availability, and ensuring regulatory compliance. Candidates with experience in RDBMS and NoSQL databases will excel in this position.

Qualifications

• 3-5 years of DBA experience.
• Hands-on experience with high-volume transactional systems.
• Strong expertise in RDBMS.

Responsibilities

• Manage and maintain mission-critical databases.
• Ensure high availability and disaster recovery.
• Handle production incidents and RCA.

Skills

High-volume transactional systems

RDBMS (PostgreSQL, MySQL, SQL Server, Oracle)

NoSQL databases (MongoDB, DynamoDB)

AWS and/or GCP database services

Data structures, indexing, query optimization

Tools

Terraform

CloudFormation

Job description

We are seeking a Database Administrator (DBA) with 3-5 years of experience. The role focuses on managing high-volume transactional databases, ensuring low-latency performance, secure data handling, and regulatory compliance. The ideal candidate will have experience with cloud platforms AWS / GCP and a strong understanding of data structures and database internals.

Key Responsibilities

Database Administration & Operations

• Manage and maintain mission-critical databases supporting trading and investment platforms
• Ensure high availability, fault tolerance, and disaster recovery for real-time systems
• Handle production incidents, root cause analysis (RCA), and resolution
• Ensure data consistency and integrity across transactional workflows
• Plan and execute migration of on-premise databases to AWS / GCP
• Optimize infrastructure for cost, scalability, and performance.

Performance Tuning (Low Latency Focus)

• Optimize high-throughput transactional queries
• Design indexing and partitioning strategies for large datasets
• Monitor and reduce query latency for near real-time processing
• Implement database security aligned with fintech regulations
• Manage encryption (at rest and in transit), access control, and secrets management
• Perform database hardening and vulnerability assessments
• Ensure compliance with standards such as SEBI, PCI-DSS, and data protection guidelines

Auditing & Monitoring

• Enable audit logging for sensitive financial transactions
• Track user activity and generate compliance reports
• Implement monitoring and alerting using tools like CloudWatch, Stackdriver, Prometheus, or Grafana

Required Skills & Qualifications

• 3-5 years of DBA experience
• Hands-on experience with high-volume transactional systems
• Strong expertise in RDBMS (PostgreSQL, MySQL, SQL Server, or Oracle)
• Experience with NoSQL databases (MongoDB, DynamoDB)
• Proficiency in AWS and/or GCP database services
• Strong understanding of data structures, indexing, and query optimization
• Experience in database migration, replication, and failover strategies
• Knowledge of Linux/Unix systems

Preferred Qualifications

• Experience working with stock broking platforms or mutual fund distribution systems
• Familiarity with financial data flows (orders, trades, settlements, NAV processing)
• Experience with real-time data streaming (e.g., Kafka)
• Knowledge of Infrastructure as Code (Terraform, CloudFormation)
• Relevant certifications in AWS or GCP

Soft Skills

• Ability to work in high-pressure, time-sensitive environments (e.g., market hours)
• Strong analytical and troubleshooting skills
• Effective communication with engineering, product, and compliance teams