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.
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