Job Title

Role: Database Administrator Based in: Hebbal, BengaluruAbout the CompanyTerraPay 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 RoleThe 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.ResponsibilitiesDatabase 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. QualificationsBachelors/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 SkillsDetail-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.