Database Administrator (PostgreSQL)

Job Title: Database Administrator (PostgreSQL) Client: Malaysian Palm Oil Certification Council (MPOCC) Preference: Malaysian (Local), Project starts from Jan 2025 Location: Menara UOA Business Park , Shah Alam – Accessible with LRT Working Mode: Contract (12 Months) - Extendable, Full Time Salary: RM 5,000 – RM 6,000 (Per Month) Notice Period: Immediate Joiner / 1 month and negotiable JOB OVERVIEW: We are seeking an experienced Database Administrator (DBA) with a strong background in PostgreSQL to join our growing team. The ideal candidate will be responsible for managing, optimizing, and securing our PostgreSQL database systems. This includes overseeing all aspects of database administration, including installation, upgrades, performance monitoring, backups, recovery, and migration. You will play a key role in ensuring the database is highly available, secure, and running at optimal performance, supporting the needs of the business and ensuring smooth database operations. ________________________________________ JOB RESPONSIBILITIES: • Database Migration: Plan, execute, and oversee the migration of databases from legacy systems to PostgreSQL or between different PostgreSQL environments. Manage and coordinate downtime and minimize service disruptions during the migration process. • Apply Updates and Patches: Regularly apply updates, patches, and version upgrades to ensure database security and performance. Ensure the compatibility of patches with existing systems and test updates in a non-production environment before deployment. • Performance Monitoring: Monitor and analyze database performance, identifying bottlenecks and areas of improvement. Proactively optimize database performance through query optimization, hardware resources allocation, and other techniques. • Health Checks: Perform regular database health checks to ensure the system is running efficiently and troubleshoot any issues that arise. Ensure databases are maintained with high availability and minimal downtime. • Set up Alerts: Configure and maintain monitoring systems for database performance, setting up alerts for unusual activities or potential performance issues. Address potential problems proactively and escalate issues as needed. • Schema Design: Design and maintain the database schema, ensuring the data is organized efficiently to meet business requirements. Work closely with application developers to ensure database schema designs are aligned with application logic. • Data Modeling: Design and implement logical and physical data models, ensuring data integrity and scalability. Collaborate with business analysts and developers to define and implement data structures. • Change Management: Manage database changes and ensure proper documentation, testing, and approval procedures are followed before deployment. Work with stakeholders to assess the impact of database changes on applications and business processes. • SQL Query Optimization: Analyze and optimize complex SQL queries to improve performance. Implement best practices for indexing and query design to reduce response time and improve database efficiency. • Index Management: Create, modify, and maintain database indexes to ensure fast data retrieval and optimal performance. Regularly review and optimize indexing strategies based on system usage patterns. • Capacity Planning: Plan and forecast future database capacity needs based on current system usage, growth projections, and business requirements. Manage database resources and scale systems to accommodate business needs and traffic growth. • Backup and Recovery: Implement and manage database backup and recovery processes to ensure data integrity and business continuity. Regularly test backups to ensure that data can be restored quickly and accurately. • Containerization via Docker: Set up and manage PostgreSQL databases in containerized environments using Docker for development, testing, and production systems. Ensure proper configuration, scaling, and management of containers. • Clustering and High Availability: Implement and manage PostgreSQL clustering, replication, and high-availability solutions. Ensure that database systems are resilient and available, even in the event of hardware or software failures. ________________________________________ REQUIRED QUALIFICATIONS: • Experience: Minimum 3 to 5 years of hands-on experience working with PostgreSQL in a professional capacity, managing large and complex databases. • Technical Skills: Proficient in database migration, performance tuning, health checks, SQL query optimization, and backup/recovery techniques. • Expertise in schema design, data modeling, and index management. • Experience with PostgreSQL clustering, replication, and high availability configurations. • Proficiency in Docker and containerized environments. • Strong understanding of database change management processes and tools. • Education: Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience). • Certifications (Preferred): PostgreSQL Certified Professional or equivalent certification. ________________________________________ PREFERRED QUALIFICATIONS: • Experience with other relational database management systems (RDBMS), such as MySQL, Oracle, or SQL Server. • Familiarity with cloud platforms like AWS or Azure, specifically for PostgreSQL database management and migration. • Experience with automation tools (e.g., Ansible, Terraform) for database provisioning and management.