Senior Database Administrator

Lumileds; Bayan Lepas; On-site; MYR 180,000 - 240,000; Full time

Job summary

Lumileds seeks a senior Database Administrator for its Manufacturing IT Department in Penang. You will administer Oracle, MSSQL and MySQL databases, tuning for performance and ensuring global availability, while engaging with users to understand requirements.

This role involves backups, DR design, data migrations, and collaboration with developers in a fast-paced, global environment at Lumileds Penang campus.

Qualifications

• 5+ years of professional experience in database administration and architecture (Oracle and MSSQL).
• Expert debugging and performance optimization knowledge.
• Analyze and tune SQL queries and database objects to improve performance.
• Analyze execution plans and identify opportunities for indexing and design improvements.
• Work with developers to troubleshoot database performance issues.
• Perform database performance monitoring, analysis and optimization.
• Strong written and verbal communication skills.
• Provide 24x7 support and ensure database availability.
• Knowledge of PL/SQL and Materialized views; data backup, recovery, security and integrity.
• DB setup, upgrade and patching; capacity monitoring; data migrations when required.

Responsibilities

• T-SQL programming and managing large databases.
• Ensure database availability and tune for optimal use.
• Propose optimization of infrastructure and design with business cases.
• Monitor performance and set thresholds to avoid outages.
• Backups, recovery, testing and disaster recovery.
• Implement data partitions and archiving solutions.
• Comply with environment, security, health and safety requirements.
• Collaborate with application developers to troubleshoot performance issues.
• Perform data migration jobs and scripts as required.
• Maintain technical documentation and prioritize tasks under pressure.

Skills

T-SQL Programming

Oracle DB

MSSQL

MySQL

Performance tuning

Backup & recovery

Data security

Data migration

PL/SQL

Database design

Communication

Documentation

22x7 support

Data partitioning

Query optimization

Education

Bachelor's degree

Job description

Lumileds International is a global leader in LED technology, innovation, and solutions for the automotive, display, illumination, mobile, and other markets where light sources are essential. Our approximately 3,300 employees operate in over 15 countries to partner with our customers to deliver solutions for lighting, safety, and well-being.

The Lumileds environment is fast-paced, cutting-edge, intelligent and fun! We are looking for exceptional talent to join our team! To learn more, visit lumileds.com.

Who You Are:

This is a senior level of functional and technical contribution in the Manufacturing IT Department. The person requires a high level of creativity in accomplishing complex assignments independently and as an important technical contributor to a project team.

Position Summary:

This is a senior level of functional and technical contribution in the Manufacturing IT Department. Support Lumileds’ growth ambitions by providing world class Manufacturing IT support on a global level. You will administer complex large databases for Lumileds. You need to interact with peers and our key users to understand their requirements. This position works within Lumileds Manufacturing IT department and is responsible for the administration, development and maintenance of SQL solutions in RDBMS including Oracle, MSSQL and MySQL.

What You Will Do:

• T-SQL Programming.
• Experience working with large databases.
• Ensure that the databases are available and are tuned to proper specifications for optimal use.
• Recommends and provides business cases for optimization of infrastructure and design.
• Proactive monitor on performance and evaluate warning and threshold points to avoid outages.
• Responsible for backups, recovery, testing and disaster recovery.
• Implement data partitions and other active archiving solutions.
• Comply with environment, security, health and safety requirements.

What You Will Bring (REQUIRED Qualifications):

• 5+ years of professional and hands on experience in the administration and architecture of databases, in particular ORACLE and MSSQL, additional experiences in MySQL and other RDBMS are a plus.
• Expert knowledge in debugging and analyzing database problems, and good knowledge on performance optimization.
• Analyze and tune SQL queries, stored procedures and database objects to improve performance.
• Analyze execution plans and identify opportunities for query optimization, indexing and database design improvements.
• Work closely with application developers to troubleshoot and resolve SQL/database performance issues.
• Perform database performance monitoring, analysis and optimization.
• Excellent oral and written communication skills.
• Provide 24 x 7 support and ensure DB availability
• Knowledge of Materialize views and PL/SQL programming
• Good knowledge of data backup, recovery, security and integrity
• Knowledge in DB setup, upgrade and patching
• Take ownership of performance and capacity monitoring aspects of the DB.
• Execution of data migration jobs and scripts as required.
• Detail-oriented and organized with strong quantitative and analytic skills.
• Good interpersonal, written, and oral communication skills.
• Technical documentation skills.
• Able to prioritize and execute tasks in a high-pressure environment.
• Bachelor's

Field of Study

• Computer Science, or related field.

Years of Experience (Minimum)

• 5 - 7 years

Lumileds is an Equal Employment Opportunity Employer