Job Description

Location : Petaling JayaSalary : RM 12,000 - 15,000job descriptionJob Responsibilities:

• Database Design and implementation. Collaborate with project teams to understand database requirements. Design and implement database solutions that meet project objectives. Ensure proper indexing, normalization, and optimization for efficient data retrieval and storage.
• Database Management. Administer and maintain databases. Monitor and optimize database performance. Troubleshoot and resolve database-related issues.
• Data Security. Implement and maintain data security measures to protect sensitive information. Define and enforce access controls and authentication mechanisms.
• Backup and Recovery. Develop and implement database backup and recovery strategies. Regularly test and validate backup procedures.
• Performance Tuning. Identify and address performance bottlenecks. Optimize database queries and processes for improved efficiency.
• Data Warehouse. Implement and manage data warehouse solutions, including ETL processes, data modelling and dimensional modelling
• Develop and maintain data warehouse architecture, including data integration, transformation and aggregation processes.
• Design and optimize data warehouse queries and reports to support business intelligence and analytics initiatives.
• Documentation. Create and maintain comprehensive documentation for database systems. Keep documentation upto date with changes and configurations.
• Collaboration. Work closely with project managers, system engineers, and system administrators. Provide technical guidance and support to project teams regarding database related matters.
• Capacity planning. Monitor database usage trends and plan for future capacity needs. Propose and implement scalability solutions as needed.

Job Requirements:

• Bachelor Degree in Computer Science, Information Technology or equivalent.
• Proven experience as Database Administrator with focus on project-based work.
• Proficiency in database management systems (eg. Oracle, MySQL, SQL Server, PostgresSQL)
• Hands-on experience with data warehouse concepts, tools and technologies (e.g., ETL tools, data modelling, OLAP).
• Proficiency in SQL and scripting languages (e.g. Python, PowerShell) for automation and data manipulation tasks.
• Strong analytical and problem-solving skills with ability to troubleshoot complex database and data warehouse issues.
• Strong knowledge of database design, normalization and optimization.
• Experience with database security and access control.
• Familiarity with backup and recovery procedures
• Excellent troubleshooting and problem-solving skills
• Effective communication and collaboration skills
• Possess certification in Database Administration (Oracle Certified Professional, Microsoft certified - Azure Database Administrator Associate).
• Experience with cloud-based databases (e.g. AWS RDS, Azure SQL Database)
• Knowledge of database automation and scripting (e.g. PowerShell, Python)
• Familiarity with project management methodologies (e.g. Agile, Scrum)

Successful candidate will be offered the following:

• 5 days work week
• Free snacks, coffee and tea

Our Client
The company is a leading IT Converged Infrastructure and enterprise management provider in Malaysia.

ExecSearch