Project Database Administrator

**Project Database Administrator (DBA)**

**Job Overview**:
We are seeking a highly skilled and motivated Project Database Administrator (DBA) with
be responsible for designing, implementing, and maintaining databases for various projects
while also ensuring optimal performance, data integrity, and security. Additionally,
proficiency in data warehouse concepts and tools is required to support our organization's
data analytics and reporting needs.

Key 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 up to 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.

Qualifications:

- Bachelor's degree in Computer Science, Information Technology, or a related field.
Proven experience as a Database Administrator, with a focus on project-based work.
Proficiency in database management systems (e.g., Oracle, MySQL, SQL Server,
PostgresSQL).
- Hands-on experience with data warehouse concepts, tools, and technologies (e.g., ETL
tools, data modeling, OLAP).
- Proficiency in SQL and scripting languages (e.g., Python, PowerShell) for automation and
data manipulation tasks
- Strong analytical and problem-solving skills with the 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.

Preferred Skills:

- Certification in Database Administration (e.g., 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).

Pay: RM12,000.00 - RM15,000.00 per month

Application Question(s):
**Education**:

- Bachelor's (preferred)