Data Administrator Jobs, IT Jobs In Kenya, Stima Sacco Jobs

Position: Data Afdministrator

Location: Nairobi

Job description

Reporting to the Head of ICT, the job holder will be responsible for managing and administering multiple MS SQL database systems including back -up, performance tuning, capacity planning, monitoring critical events and documentation

Responsibilities

  • Managing SQL Server databases through multiple product lifecycle environments, from development to mission-critical production
  • Configuring and maintaining database servers and processes, including monitoring of system health and ensure high levels of performance
  • Developing strategies and implementing solutions for managing back-ups, restoration and replication
  • Implementing strategies for database high availability and scalability and will with project teams to ensure a smooth deployment of new services and
  • Maintaining data integrity, security and access – monitoring user access, developing and maintaining system security in line with standards and ensuring compliance to all standards and
  • Maintaining, tuning, use tools like SQL Profiler for database Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
  • Appling data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
  • Proactive housekeeping/archiving and shrinking of databases
  • Independently analyzing, solving, and correcting issues in real time, providing problem resolution end-to-end.
  • Refining and automating regular processes, track issues, and documenting changes
  • Assisting developers with complex query tuning and schema
  • Providing 24×7 support for critical production
  • Performing scheduled maintenance and support release deployment activities after
  • Sharing domain and technical expertise, providing technical mentorship and cross-training to other peers and team
  • Providing monthly reports on database systems availability, incidences, and system breaches and recommending possible

Qualifications

  • Bachelor’s degree in computer science or equivalent education from a recognized institution.
  • 3+ years’ experience in administering Microsoft SQL server databases in a financial institution
  • Certification on SQL database administration
  • Extensive experience writing T-SQL and stored procedures and query tuning on high- transaction
  • Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experienced in ETL (Extract-Transform-Load) development / data
  • Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
  • Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
  • Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication
  • Knowledge of other databases like MySQL, No SQL databases and In-memory databases and MCTIP certification will be an added advantage
  • Strong Knowledge of Database
  • Experience working with Windows server, including Active Directory
  • Experience working with Microsoft Dynamics Nav 2016 ERP will be an added advantage
  • Ability to develop procedure documents and maintain detailed database related
  • Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new

How to Apply

Qualified applicants should send their Application Letter and Detailed CVs to [email protected] on or before 5pm on 14th February 2020 indicating the position applied for as the subject line.

Must Read>>> 3 Reasons Why Your Job Search Is Not Working