Database Administrator

Job Title : Database Administrator (DBA) Location : Jalan PJS 8/9, 46150 Petaling Jaya, Selangor Salary : RM5,000 - RM6,000 No. of Positions: 1 + 1 Job Summary: We are looking for a detail-oriented Database Administrator (DBA) to manage and maintain our databases. As a DBA, you will ensure the performance, security, and reliability of our database systems. You will be responsible for designing, implementing, and maintaining database systems that support the organization’s data needs. If you have a strong background in database management and enjoy problem-solving, we encourage you to apply. Key Responsibilities: Database Design and Architecture: Design and implement database structures based on project requirements. Create and manage database schemas, tables, views, and indexes. Ensure that the database design is scalable, efficient, and supports future growth. Database Installation and Configuration: Install, configure, and maintain database management systems (DBMS), such as MySQL, PostgreSQL, Oracle, SQL Server, or NoSQL databases like MongoDB. Set up and configure database servers, ensuring high availability and optimal performance. Performance Monitoring and Optimization: Monitor database performance to identify potential issues such as slow queries, resource contention, or storage problems. Implement database performance tuning strategies, including query optimization, indexing, and caching. Regularly analyze database health and take proactive measures to maintain optimal performance. Backup and Recovery: Design and implement robust backup strategies to ensure the integrity and availability of database systems. Perform regular database backups and test recovery procedures. Troubleshoot and resolve any database-related issues to prevent data loss. Security Management: Implement and enforce database security policies, including user authentication, data encryption, and access control. Monitor database access and activity for any unauthorized access or security breaches. Ensure compliance with relevant data privacy and security regulations (e.g., GDPR, HIPAA). Database Maintenance: Perform regular database maintenance tasks, including updates, patches, and software upgrades. Manage database storage and ensure efficient use of resources, including optimizing disk space and storage configurations. Conduct routine database health checks and address any performance or reliability concerns. Troubleshooting and Issue Resolution: Diagnose and resolve database-related issues, including performance bottlenecks, query failures, and connectivity issues. Investigate and resolve database errors, crashes, and integrity issues. Provide on-call support for database-related emergencies and system outages. Database Documentation: Maintain comprehensive documentation of database configurations, procedures, and operational practices. Document database performance issues and resolutions to improve troubleshooting processes. Collaboration and Support: Collaborate with development teams to support database-related development tasks such as writing SQL queries, optimizing database interactions, and ensuring best practices are followed in code. Provide technical support to users and other teams for database-related queries and issues. Work closely with system administrators and DevOps teams to manage database server infrastructure. Database Upgrades and Migration: Plan and execute database upgrades, migrations, and schema changes with minimal disruption to business operations. Ensure the smooth migration of data between environments (e.g., from development to production) while maintaining data integrity. Technical Skills and Qualifications: Experience: Proven experience as a Database Administrator (DBA) or in a similar role. Experience with both relational and NoSQL database management systems (e.g., SQL Server, MySQL, PostgreSQL, MongoDB, Oracle). Strong knowledge of database design principles, indexing, and normalization. Database Management Systems (DBMS): Expertise with one or more of the following DBMS platforms: Oracle, Microsoft SQL Server, MySQL, PostgreSQL, MongoDB, MariaDB. Experience with cloud-based databases (e.g., AWS RDS, Azure SQL, Google Cloud SQL) is a plus. SQL & Scripting: Advanced knowledge of SQL and the ability to write complex queries, stored procedures, and triggers. Familiarity with scripting languages (e.g., Bash, PowerShell, Python) to automate database administration tasks. Backup and Recovery: Expertise in database backup and disaster recovery strategies. Hands-on experience with backup tools and recovery methods to ensure data integrity and business continuity. Performance Tuning: Strong ability to diagnose and resolve database performance issues, including query optimization, indexing, and resource allocation. Experience with database profiling and monitoring tools (e.g., SQL Profiler, pgAdmin, MySQL Workbench). Security: Knowledge of database security best practices, including encryption, access control, and secure user management. Familiarity with security protocols and industry regulations (e.g., PCI-DSS, GDPR). High Availability and Scalability: Experience in designing and implementing high-availability database systems (e.g., replication, clustering, sharding). Experience with database clustering and load balancing solutions. Operating Systems: Proficiency with Linux, Windows Server, and cloud environments (AWS, Azure, Google Cloud). Experience with containerization (e.g., Docker) and orchestration tools (e.g., Kubernetes) is a plus. Soft Skills: Strong problem-solving skills, with the ability to diagnose complex database issues and provide efficient solutions. Excellent communication skills, both written and verbal, for clear documentation and collaboration with cross-functional teams. Ability to work under pressure, particularly in situations involving critical system outages or performance problems. Strong attention to detail and commitment to ensuring the integrity, availability, and security of data. Preferred Qualifications: Bachelor’s degree in Computer Science, Information Technology, or a related field. Database certifications (e.g., Oracle Certified Professional, Microsoft Certified Database Administrator, AWS Certified Database – Specialty) are a plus. 3+ years of experience in database administration or a related field. What We Offer: Competitive salary and benefits package. A dynamic work environment with opportunities for professional growth and development. Access to cutting-edge database technologies and cloud platforms. Opportunities to work on high-impact projects that contribute to the success of the organization. How to Apply: Please submit your resume and cover letter, highlighting your experience with database management and your qualifications for this role. We look forward to reviewing your application!