Database Administrator
Summary
Database Administrator owning PostgreSQL infrastructure for DGePay's payment gateway in Dhaka: performance tuning, replication and high availability, backups/PITR and disaster recovery, security and Bangladesh Bank compliance, monitoring with Grafana/Prometheus, and automation via scripting, while collaborating with backend and DevOps teams.
DGePay | Payment Gateway Platform
Company: DGePay Services Limited
Department: Engineering / Technology
Product: DGePay – Payment Gateway Platform
Position: Database Administrator (DBA)
Employment Type: Full-time
Work Location: Dhaka, Bangladesh
Experience: 5–8 years
Job Summary
DGePay Services Limited is seeking a skilled Database Administrator (DBA) to manage, maintain, secure, and optimize the database infrastructure supporting DGePay, its payment gateway platform. The successful candidate will ensure database availability, performance, scalability, security, and data integrity across development, UAT, staging, and production environments.
Because DGePay processes sensitive customer and financial transaction data, the role requires strong production PostgreSQL administration experience, sound transaction-management practices, and a disciplined approach to auditability, backup, recovery, and regulatory controls.
Key Responsibilities
Database Administration & Management
- Install, configure, maintain, and administer PostgreSQL database servers and instances.
- Manage database environments across development, UAT, staging, and production.
- Design and maintain database schemas, tables, indexes, constraints, views, functions, and stored procedures.
- Manage database users, roles, privileges, and access policies using least-privilege principles.
- Perform database upgrades, patching, routine maintenance, and configuration management.
- Maintain accurate database architecture, configuration, and operational documentation.
Performance Optimization
- Monitor database performance, resource utilization, and query execution.
- Analyze and optimize SQL queries using EXPLAIN and EXPLAIN ANALYZE.
- Apply effective indexing, partitioning, query tuning, and database maintenance strategies.
- Monitor connection pools, locks, deadlocks, long-running transactions, and replication lag.
- Identify capacity and performance bottlenecks and implement corrective actions.
- Optimize database workloads for high-volume financial transactions and concurrent users.
High Availability & Disaster Recovery
- Design, configure, and maintain PostgreSQL replication and high-availability solutions.
- Implement automated backup, restore, and point-in-time recovery (PITR) procedures.
- Manage WAL archiving and validate backup integrity.
- Develop, document, and periodically test disaster recovery procedures.
- Define and monitor agreed Recovery Point Objective (RPO) and Recovery Time Objective (RTO) targets.
- Conduct restoration tests and DR drills to validate business continuity readiness.
Database Security & Compliance
- Apply database hardening, role-based access control, and privileged-access management.
- Protect sensitive customer and financial information through appropriate encryption and access controls.
- Maintain database audit logs and investigate suspicious or unauthorized activity.
- Support internal audits, VAPT exercises, and regulatory compliance assessments.
- Follow applicable Bangladesh Bank guidelines and DGePay information security policies.
- Maintain segregation of duties and controlled access to production databases.
Financial Transaction Data Management
- Preserve ACID transaction properties and data consistency across payment operations.
- Support database design and optimization for payment processing, settlements, refunds, reversals, and reconciliation.
- Maintain traceable transaction records, audit trails, and appropriate data-retention controls.
- Collaborate with backend developers on reliable transaction boundaries, isolation levels, and concurrency control.
- Assist with investigation of transaction discrepancies and database-level production incidents.
- Help prevent unauthorized or untraceable modification of financial records.
Monitoring & Automation
- Implement database monitoring, alerting, and health-check mechanisms.
- Monitor CPU, memory, disk I/O, storage capacity, connections, replication status, and query performance.
- Build or maintain monitoring dashboards using Grafana, Prometheus, and PostgreSQL monitoring tools.
- Automate routine administration, backup validation, maintenance, and reporting using scripts.
- Configure actionable alerts for database failures, storage thresholds, replication issues, and abnormal activity.
Development & DevOps Collaboration
- Work closely with backend developers, DevOps engineers, QA, and infrastructure teams.
- Review schema changes, SQL scripts, and database migration plans before deployment.
- Establish safe database change-management and release practices through CI/CD workflows.
- Support production deployments, incident response, root-cause analysis, and post-incident reviews.
- Contribute to database capacity planning, infrastructure sizing, and environment standardization.
Skill Requirements:
- Primary Database: Strong hands-on PostgreSQL administration experience.
- SQL: Advanced SQL, query optimization, execution plans, and troubleshooting.
- Database Design: Schema design, normalization, indexing, partitioning, and constraints.
- Performance Management: VACUUM, ANALYZE, connection pooling, locks, and workload tuning.
- High Availability: Streaming replication, failover concepts, and replication monitoring.
- Backup & Recovery: pg_dump, pg_basebackup, WAL archiving, and PITR.
- Security: Role-based access, auditing, encryption, and least-privilege access.
- Monitoring: Grafana, Prometheus, and PostgreSQL monitoring utilities.
- Operating Systems: Linux administration (Ubuntu, Debian, or RHEL).
- Infrastructure: Docker, virtualization, storage, and server resource management.
- Automation: Bash/Shell scripting; Python or PowerShell is an advantage.
- DevOps: Git, CI/CD concepts, and database migration/deployment practices.
Educational Qualifications
- Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or a related discipline.
- Relevant professional certifications in database administration are an advantage.
Experience & Additional Advantages
- 3–5 years of professional experience in database administration, including hands-on PostgreSQL production operations.
- Experience managing high-volume transactional databases in fintech, banking, payment gateways, or financial institutions is highly preferred.
- Practical experience with replication, failover, backup validation, and disaster recovery.
- Understanding of financial transaction processing, settlement, refunds, reversals, and reconciliation.
- Familiarity with PCI DSS, ISO 27001, and Bangladesh Bank IT/security guidelines is an advantage.
Key Performance Indicators (KPIs):
- Database Availability: Meet the agreed database availability target (e.g., 99.9%), subject to the approved service and infrastructure SLA.
- Performance: Proactively identify and resolve query, capacity, and database performance bottlenecks.
- Backup Reliability: Maintain successful scheduled backups and perform documented restoration verification.
- Disaster Recovery: Maintain tested DR procedures and meet agreed RPO/RTO targets.
- Security: Maintain controlled access, auditability, and timely remediation of identified database security issues.
- Data Integrity: Protect the consistency, completeness, and traceability of financial transaction records.
- Incident Management: Respond to database incidents within agreed operational response and resolution targets.
- Documentation: Keep architecture, access, backup, recovery, and operational documentation current.
- Automation: Reduce repetitive manual DBA activities through safe, maintainable automation.
Professional Competencies
- Strong analytical, diagnostic, and problem-solving skills.
- High attention to detail and commitment to data accuracy.
- Ability to work calmly and methodically during production incidents.
- Ownership and accountability for production database reliability and security.
- Effective communication and collaboration with engineering and infrastructure teams.
- Ability to work independently while following change-management and approval procedures.
- Strong commitment to confidentiality and information security.
Why Join DGePay Services Limited?
- Work on DGePay, a mission-critical payment gateway platform.
- Contribute to scalable, secure, and highly available financial technology infrastructure.
- Collaborate with experienced engineering and technology professionals.
- Influence database architecture, operational standards, and infrastructure strategy.
DGePay Services Limited
Building Secure, Scalable & Innovative Digital Solutions
Skills
Sign in to read and join the discussion.