APPLICATIONS PROGRAMMER

APBA TG HUMAN RESOURCE PTE. LTD.; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

A recruitment agency in Singapore seeks a Database Administrator with at least 5 years of experience in managing various enterprise-level database systems including Oracle, SQL Server, PostgreSQL, and MySQL. The ideal candidate will possess hands-on experience in installation, configuration, backup strategies, and performance tuning. Responsibilities include database management, implementation of security measures, and assisting with data migrations. This position offers opportunities for growth in a dynamic environment.

Qualifications

• At least 5 years of experience in managing enterprise-level databases like Oracle, SQL Server, PostgreSQL, and MySQL.
• Proficient in database design, backup strategies, and performance tuning.
• Hands-on experience in scripting for database administration tasks.

Responsibilities

• Manage and maintain database systems including installation and configuration.
• Implement backup strategies and disaster recovery procedures.
• Monitor database performance and resolve any bottlenecks.
• Plan and execute data migrations between different database systems.

Skills

Oracle Database management

SQL Server management

PostgreSQL management

MySQL management

Database Design and Modeling

Backup and Recovery

Performance Monitoring and Tuning

Automation and Scripting

Tools

Oracle Enterprise Manager

SQL Server Management Studio

pgAdmin

MySQL Workbench

ETL tools

Job description

Database Administrator with at leastfive (5) years of experience in managing and maintaining at least one (1)type of enterprise-level database systems. The candidate should possessin-depth knowledge and hands‑on experience with the following database managementsystems:

Oracle:

• Proficientin Oracle Database installation, configuration, and maintenance
• Experiencewith Oracle Real Application Clusters (RAC) and Data Guard
• Skilledin performance tuning, query optimization, and indexing strategies
• Familiaritywith Oracle Enterprise Manager for database administration

MicrosoftSQL Server:

• Expertisein SQL Server installation, configuration, and maintenance
• Experiencewith SQL Server Always On Availability Groups
• Proficientin T‑SQL programming and query optimization
• Skilledin using SQL Server Management Studio and related tools

PostgreSQL:

• Proficientin PostgreSQL installation, configuration, and maintenance
• Experiencewith PostgreSQL replication and high availability solutions
• Skilledin PL/pgSQL programming and query optimization
• Familiaritywith pgAdmin and other PostgreSQL management tools

MySQL:

• Expertisein MySQL installation, configuration, and maintenance
• Experiencewith MySQL replication and clustering (e.g., MySQL Group Replication)
• Proficientin SQL programming and query optimization for MySQL
• Skilledin using MySQL Workbench and related administration tools

Generalskills and responsibilities across all supported databases:

• Database Design and Modeling:
  • Proficientin designing efficient database schemas and data models
  • Experiencein normalisation and denormalisation techniques
• Backupand Recovery:
  • Implementingand managing backup strategies for all supported databases
  • Experiencein point-in-time recovery and disaster recovery planning
• Securityand Access Control:
  • Implementingand managing database security measures
  • Proficientin user access management and auditing
• PerformanceMonitoring and Tuning:
  • Usingmonitoring tools to track database performance
  • Skilledin identifying and resolving performance bottlenecks
• CapacityPlanning:
  • Experiencein database capacity planning and resource allocation
  • Proficientin forecasting storage and performance requirements
• HighAvailability and Disaster Recovery:
  • Implementingand managing high availability solutions for all supported databases
  • Experiencein setting up and testing disaster recovery procedures
• DataMigration:
  • Skilledin planning and executing data migrations between different databasesystems
  • Experiencewith ETL tools and processes
• Automationand Scripting:
  • Proficientin scripting for database administration tasks (e.g., Python,PowerShell, Bash)
  • Experiencewith database automation tools
• CloudDatabase Services:
  • Familiaritywith cloud-based database services (e.g., Amazon RDS, Azure SQLDatabase, Google Cloud SQL)
  • Experiencein migrating on-premises databases to cloud platform