Our client in the Insurance
Brokerage Industry is in need of a Systems Administrator
Under the general guidance
and supervision of the Group CTO, the Systems Administrator is responsible for
installing, configuring, administering, deploying and supporting the SQL Server
Relational Database Management System (RDBMS) and the multiple databases it
hosts.
S/he will work closely with
the Network Administrator to ensure that the LAN/WAN is appropriately
configured to allow optimal and secure operations of the enterprise
systems.
In addition, s/he will also
work in collaboration with Systems Developers to ensure that the databases
developed are secure, and optimally tuned for scalability, reliability,
availability, effectiveness and efficiency.
They would be expected to
participate and contribute in the brokerage systems development process, and in
providing technical support to users to optimize the use of database tools for
data entry, processing and reporting.
The Systems Administrator
will also be responsible for specifying database infrastructure and service
requirements, and managing the engagement with external consultants and vendors
providing a range of outsourced Systems and database technical support
services.
Knowledge and skills in
systems development; network and software troubleshooting is a tremendous asset
in fulfilling the functions of this position.
Principal Accountabilities
System Administration
- Installing,
configuring, managing and supporting the SQL Server Relational Database
Management System (RDBMS) and the multiple databases and corresponding
applications it hosts and supports.
- Performing
administration of database servers in an enterprises environment, including
production, development, testing, and training servers to support: backup
and recovery procedures; replication; index maintenance; monitoring system
performance and optimizing/tuning stored procedures and indexes; creating
ad-hoc SQL queries; integrating data files and databases from disparate
systems; data mining and cleansing of legacy databases; troubleshooting
and isolating and resolving performance problems, etc.
- Designing
database schemas, data transformation rules, procedures for managing and
refreshing data, and implementing databases through appropriate modular
stored procedures and triggers, among others. Following coding policies
and standards as well as configuration management/version control
policies.
- Providing
comprehensive documentation of the RDBMS environment and database/data
warehouse structures.
- Keeping
abreast of changing technology trends to enable continuous process
improvements, cost-effective and standards-based implementations.
- Performing
other related duties as may be required by the functions of this position.
Monitoring and providing periodic reporting on the overall state and
performance of the hosted databases, and comprehensively documenting all
systems environment.
- Providing
support to the Systems Development and Support Teams, as appropriate, to
ensure that timely and adequate resources are allocated to support these
teams and the functions that they have to deliver; both developmental and
support (maintenance, troubleshooting, etc.).
- Developing
and specifying database requirements and subsequently planning and project
managing the engagement and Service Level Agreements with external
consultants and vendors providing a range of outsourced ICT services.
Key Competencies
- Planning and
organizing
- Professionalism
- Technological
awareness
- Multitasking
and prioritization
- Integrity,
Discretion and Business Ethics
- Fairness
- Dedication
to Continuous Improvement
- Operational
leadership
- Interpersonal
skills and team orientation
- Communication
Education, Experience and
Knowledge
- Degree in
Computer Science, Management Information Systems, Engineering, or other
relevant field.
- Database
certification(s); Microsoft Certifications are preferred.
- Minimum of 2
years relevant work experience as a network administrator in a Windows
environment.
- At least 2
years Relational Database Management System administration and Business
Intelligence/Data Warehousing in an environment with multiple production
databases experience, especially in SQL, and/or Database certification
(MCDBA, etc.) will be an advantage.
- Systems
administration and/or development experience will also be an added
advantage.
- Working
knowledge of database design, optimization, and troubleshooting, as well
as Microsoft SQL RDBMS.
- Prior
hands-on professional experience must include an overall knowledge of
database design, optimization, and troubleshooting.
If you believe you qualify
for this position, please send your CV and details of your current and expected
remuneration to: resume@interviewupconsulting.com and on Subject header indicating
position applied for or application will be rejected.
Only qualified candidates
will be contacted