NCS is a leading technology services firm, operating across Asia Pacific in over 20 cities, providing services and solutions in consulting, digital, technology, cybersecurity and more. We believe in the power of technology to make extraordinary things happen and to create lasting impact and value for our people, communities and partners. We bring together people and expertise to harness the best of technology. Our diverse 12,000-strong workforce has delivered a wealth of large-scale, mission-critical, and multi-platform projects for governments and enterprises in Singapore and the APAC region.
Job DescriptionDatabase Administrator
What will you do?
- 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.
The ideal candidate should possess:
- 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 & Always on 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.
We are driven by our AEIOU beliefs—Adventure, Excellence, Integrity, Ownership, and Unity—and we seek individuals who embody these values in both their professional and personal lives. We are committed to our Impact: Valuing our clients, Growing our people, and Creating our future.
Together, we make the extraordinary happen.
Additional InformationLearn more about us at ncs.co and visit our LinkedIn career site.
Top Skills
NCS Group Singapore Office
Singapore, 5 Ang Mo Kio Street 62, NCS Hub, Singapore, 569141
