Database Administrator

6 days ago

Singapore HOPERUN SOFTWARE SINGAPORE PTE. LTD. Full time

Roles & Responsibilities About the Role: We are looking for an experienced Database Administrator (DBA) with deep, hands-on expertise in AWS RDS Aurora PostgreSQL . The ideal candidate is not only proficient in general PostgreSQL operations and tuning, but also has a strong command of AWS RDS-specific configurations , monitoring , and performance optimization . This role is critical in ensuring the stability, performance, and scalability of our production databases that support mission-critical applications in the supply chain and enterprise domain. Key Responsibilities: 1. Health Monitoring Review and interpret CloudWatch alarms and Performance Insights dashboards. Monitor database connections , CPU utilization , and storage I/O metrics. Ensure proactive issue detection and alert configuration to maintain database health. 2. Log Analysis Regularly review PostgreSQL error logs for warnings, errors, and abnormal patterns. Identify and resolve authentication failures or connection issues . Analyze slow query logs to identify and resolve performance bottlenecks. Monitor autovacuum activities and manage table/index bloat effectively. 3. Capacity Planning Analyze historical trends in storage growth , compute resource utilization , and connection load . Forecast future capacity needs and recommend scaling strategies. Review and optimize backup storage plans to balance cost and availability. 4. Performance Analysis and Optimization Conduct deep-dive database performance reviews and tuning exercises. Identify and optimize resource-intensive queries and stored procedures. Monitor wait events , lock contention , and long-running transactions . Assess connection pooling strategies (e.g., PgBouncer, RDS Proxy) for effectiveness. Review and fine-tune PostgreSQL parameters for optimal throughput and latency. Provide monthly performance reports and recommend improvement actions. Requirements: Technical Skills 5+ years of experience managing PostgreSQL databases in production. 3+ years of hands-on experience specifically with AWS RDS Aurora PostgreSQL . Strong understanding of: RDS performance tuning and parameter groups Read replica and failover configuration IAM authentication and encryption (KMS) Backup, snapshot, and PITR strategies Security, compliance, and maintenance best practices Deep expertise in AWS RDS advanced configuration , including parameter groups, option groups, and Aurora-specific features like serverless scaling and global databases. Proven experience in PostgreSQL tuning and analyzing execution plans, including query optimization, indexing, and vacuuming. Strong proficiency in AWS services : CloudWatch, Performance Insights, IAM for database access, and VPC configurations. Excellent problem-solving skills and ability to work in a fast-paced, collaborative environment. Preferred Qualifications: AWS Certified Database – Specialty (or equivalent hands-on experience). Experience with Aurora Global Database , multi-AZ deployment, and cross-region replication . •Knowledge of CI/CD pipelines and infrastructure as code (e.g., Terraform, CloudFormation) for database provisioning. Experience supporting databases in high-availability enterprise environments . Tell employers what skills you have RDSScalabilityPostgreSQLFailoverAmazon AWSPipelinesAWSMySQLAmazon AuroraThroughputTuningReplicationDatabase AdministrationPerformance TuningAuthenticationEncryptionDatabases

  • Database Administrator

    5 days ago

    Singapore PERSOL APAC Full time $80,000 - $120,000 per year

    Job Description:Perform logical and physical database design and creation, changes or removal of database, provide technical consultancy and advice on the usage of database software, advise application developers and owners on optimisation of database usage, SQL code and monitor availability of database, listener and other related processes;review all daily...

  • Database Administrator

    2 weeks ago

    Singapore THE RAINFOREST SPORTS HUB PTE. LTD. Full time

    Design, install, configure and maintain database systems, including monitoring, tuning and troubleshooting issues. - Provide a seamless flow of information by keeping the database running smoothly. - Ensure data security and integrity, including implementation of access controls, backups and recovery plans. - Develop and maintain database documentation,...

  • Database Administrator

    2 weeks ago

    Singapore DCI CONSULTANTS PRIVATE LIMITED Full time

    **Roles & Responsibilities** **Database Administrator Job Responsibilities**: - Install and maintain the performance of database servers. - Develop processes for optimizing database security. - Set and maintain database standards. - Manage database access. - Performance tuning of database systems. - Diagnose and troubleshoot database errors. - Recommend...

  • Database Administrator

    3 hours ago

    Singapore ZENTACT SYSTEMS PTE. LTD. Full time

    **Position: Database Administrator** **Duration: 4-5 months** **Location: Singapore **Job details: - 4-8 years of experience in database management - Strong knowledge of: - IBM database administration - DB scripting - Installation, management, and support - SQL and NoSQL databases - JSON - Database design principles - SQL script writing for data...

  • Database Administrator

    2 weeks ago

    Singapore DATA CONNECT TECHNOLOGIES PTE. LTD. Full time

    Proficient in working with various types of databases such as but not limited to, Microsoft SQL, MySQL, Oracle, PostgreSQL, Amazon RDS and Aurora. - Responsible for administrating databases hosted in both on-premises and cloud environment such as but not limited to Microsoft Azure, Amazon Web Service, Google Cloud Platform and Alibaba Cloud, in terms of...

  • Database Administrator

    2 weeks ago

    Singapore ITCONNECTUS PTE. LTD. Full time

    Database Administrator RESPONSBILITY: Provision databases with required licenses. Implement data security and recovery control. Monitoring health, performance, user access and security. Managing parameters for database optimization. Implement configuration management for business continuity plans and automate disaster recovery measures. Support systems to...

  • Database Administrator

    1 week ago

    Singapore Epergne Solutions Full time

    Get AI-powered advice on this job and more exclusive features. Install, configure, and maintain database systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL). Monitor database performance, implement tuning, and ensure high availability and disaster recovery . Manage backups, restores, and data security across environments. Support database design,...

  • Database Administrator

    1 week ago

    Singapore GECO Asia Pte Ltd Full time

    Get AI-powered advice on this job and more exclusive features. Direct message the job poster from GECO Asia Pte Ltd We are looking for passionate Database Administrators/Engineers to join a critical and long-term project. This role is part of an upskilling programme that offers current DB professionals (MSSQL, SQL, Oracle, IBMDB2, MongoDB, and other DB...

  • Database Administrator

    6 days ago

    Singapore ITCONNECTUS PTE. LTD. Full time

    Roles & Responsibilities Database Administrator RESPONSBILITY: . Provision databases with required licenses. . Implement data security and recovery control. . Monitoring health, performance, user access and security. . Managing parameters for database optimization. . Implement configuration management for business continuity plans and automate disaster...

  • Database Administrator

    2 days ago

    Singapore Cloud Kinetics Full time

    Database Maintenance and Administration:- Installation, configuration, fine-tuning (in coordination with Apps Team), patching, and performance optimization.- - DB Backup and Recovery:- Planning, implementation and on-boarding, testing backup, and recovery procedures.- - Troubleshooting:- Identifying and resolving database issues.- - Database Design and...