Senior Database Administrator

CXC; Selangor; On-site; MYR 100,000 - 150,000; Full time

Job summary

A technology solutions company in Selangor is seeking an experienced SQL Database Specialist to analyze and optimize SQL queries for improved performance. Candidates should have over 5 years of experience in MySQL, with skills in query optimization and data analysis. The role requires onsite work from Monday to Friday, with potential on-call support depending on project needs. This position offers a dynamic work environment and opportunities for professional growth.

Qualifications

• Minimum 5 years of experience in MySQL and database management.
• Skilled in SQL query optimization.
• Experienced in data analysis using SQL and reporting.

Responsibilities

• Analyze and optimize expensive SQL queries to improve performance.
• Provide comparison reports on loading and processing times.
• Develop complex SQL queries for data analysis.

Skills

SQL query optimization

Performance tuning

Complex query development

Data analysis using SQL

Database integrity

Job description

Scope of Work

1. Analyze and optimize expensive SQL queries to improve database performance and reduce load times.
2. Provide comparison reports detailing loading and processing times for optimized SQL queries.
3. Develop complex SQL queries based on business and technical requirements to support data analysis and decision-making.
4. Maintain database integrity, performance, and security at optimal levels.
5. Conduct performance tuning to ensure systems can efficiently handle increased data volume and user load.
6. Collaborate with developers and stakeholders to provide technical support and implement necessary database modifications for project support and maintenance.

Qualifications

• Minimum 5 years of experience in MySQL and database management
• Skilled in SQL query optimization, performance tuning, and complex query development
• Experienced in data analysis using SQL and reporting
• Strong understanding of database integrity, backup procedures, and maintenance best practices

Working Hours & Arrangement

• Monday to Friday, 8:00 AM – 5:00 PM [ONSITE]
• On-call support may be required depending on project criticality, which can be offset accordingly