
Database Administrator
- Singapore
- Permanent
- Full-time
- Lead and manage database changes through change request process & provide status reports to the relevant parties.
- Participate in development projects e.g., logical & physical database design.
- Ability to manage customer in data modeling meeting and review meeting.
- Assist and respond promptly to incidents, investigate & provide temporary &/or permanent resolution of incidents escalated.
- Involvement in performance tuning, performance management, setup of Databases.
- Lead and monitor & measure the performance & availability of databases proactively; implement corrective actions identified to improve performance & availability.
- Lead and monitor the agreed service level, document & maintain the configuration of the databases; provide regular reporting to relevant parties.
- Ensure service level meets requirements. Propose and implement action plan when required. Lead and monitor databases according to standard operations procedures.
- Lead in the implementation of service continuity measures, i.e., backup/restore procedures & disaster recovery plan, to ensure continuous operation of the business.
- Involve and lead in database implementation.
- Keep abreast of database technologies.
- A good team player and leader.
- More than 5 years of experience in installation, configuration, & management of SQL Server databases is mandatory.
- Certification in SQL server.
- More than 2 years of experience of Advanced to Expert skills in all the following:
- SQL Server Clustering & AlwaysOn Availability Group setup & management.
- Writing & debugging complex SQL statements, stored procedures & functions.
- Must be able to design & implement relational tables using the proper degree of normalization & denormalization.
- ER-Diagram Designer Tools.
- Performance Tuning.
- Proper index design & able to identify good & bad index design.
- Identify unused indexes & missing indexes.
- Identify bottlenecks in SQL Statistics, execution plans.
- Database Performance Monitoring using the following:
- SQL Profiler Trace.
- Extended Events.
- Performance Monitoring Tool on SQL Server and Windows Counters.
- Third-Party DB monitoring tools.
- Database Performance Maintenance:
- Index Reorganization/Rebuild.
- Update Statistics.
- Archival Strategies.
- Experience in setting up & managing of DB replication is a value-add.
- Experience in Oracle database installation & administration is a value-add
- Degree in Computer Science or equivalent bachelor certification.