Database Administrator

Role: Database Administrator

Based in: Hebbal, Bengaluru

About the Company

TerraPay is a global fintech company dedicated to providing seamless payment solutions. Our mission is to empower businesses and individuals by enabling secure and efficient transactions across borders. We foster a culture of innovation, collaboration, and inclusivity, ensuring that our team members thrive in a dynamic work environment.

About the Role

The Senior DBA will be responsible for designing, maintaining, and optimizing TerraPay's mission-critical databases across multiple environments. This role demands deep expertise in database architecture, performance tuning, security, and high availability, combined with strong problem-solving and leadership skills to support global fintech operations.

Responsibilities

• Database Design & Architecture
• Design and maintain scalable database schemas, models, and architectures aligned with application and business requirements.
• Ensure normalization, optimization, and adherence to industry best practices.

• Performance & Query Optimization
• Analyze and optimize slow-running queries to improve application performance.
• Implement indexing strategies, database tuning, and resource optimization.
• Continuously monitor performance metrics to ensure system stability.

• Backup, Recovery & High Availability
• Develop and maintain robust backup and recovery strategies.
• Perform restoration testing to meet RPO/RTO targets.
• Manage replication setups and high availability configurations.

• Database Security & Access Control
• Implement and enforce database security policies, auditing, and compliance controls.
• Manage user creation, roles, privileges, and access segregation.
• Ensure secure handling of credentials and privileged accounts.

• Data Migration & Replication
• Plan and execute data migrations across environments and platforms.
• Maintain replication strategies for real-time or near-real-time synchronization.

• Production Support & Maintenance
• Provide L2/L3 support for production incidents and escalations.
• Conduct routine maintenance tasks such as patching, vacuuming, reindexing, and health checks.
• Ensure proactive monitoring and resolution of database issues.

• PostgreSQL DBA Activities
• Perform specialized PostgreSQL administration tasks including configuration tuning, WAL management, and cluster maintenance.
• Manage PostgreSQL extensions, monitoring tools, and environment optimization.

• Operational Excellence
• Handle high-volume database support tickets weekly, covering optimization, maintenance, and incident resolution.
• Document operational processes and contribute to continuous improvement initiatives.

Qualifications

• Bachelors/Masters degree in Computer Science, Information Technology, or related field.
• 4+ years of experience in database administration, with deep knowledge of PostgreSQL and other relational database management systems (RDBMS).
• Experience working with AWS cloud environments, including Amazon RDS setup, management, monitoring, and optimization.
• Proven experience in performance tuning, high availability, and disaster recovery.
• Strong knowledge of database security, compliance, and access control.
• Hands-on experience with replication, migration, and clustering.
• Excellent problem-solving, analytical, and communication skills.
• Ability to work in fast-paced, global fintech environments.

Required Skills

• Detail-oriented with a focus on reliability and scalability.
• Strong ownership mindset and ability to handle mission-critical systems.
• Collaborative team player with cross-functional coordination skills.
• Passion for continuous learning and adopting new database technologies.