PayTech Africa, Nairobi, Kenya Dec 2022-Current
Database Administrator.
Responsibilities:
- Perform installation, configuration of Oracle database on linux, windows and VMware.
- Determining and implementing best practices for Oracle Setup, Installation, Configuration, Monitoring, Backup and Recovery.
- Upgrading Oracle Database from 9i to 10g and 11g.
- Developing different databases at various implementation of projects.
- Administering of production and replica databases in premise and AWS cloud.
- Database Installations, Deployments and Optimizations.
- Review and Optimize database queries to manage database optimal performance.
- Writing and converting SQL server stored procedures to Postgres.
- Implement automated tools to monitor query performance on the database (i.e. pgAdmin, Microsoft SQL)
- Database development, maintenance and Migrations (MySQL, PostgreSQL and MSSQL).
- Ensuring database security.
- Working with Developers to ensure database design can scale.
- Software Installation and configuration as per defined requirement specifications.
- Ensure that the company is adaptable to evolving compliance regulations.
- Review and Optimize database queries to manage database optimal performance.
- Participate in brainstorming sessions with the engineering team and contribute ideas to our technology, infrastructure, and processes.
- Automating scripts i.e. schema backups, queries and reporting scripts.
KEI TATA LOGISTICS, Nairobi, Kenya Jan 2022- Nov 2022
Full Stack Software & Database Administrator.
Responsibilities:
- Configuring and administering of SQL servers.
- Database backup, restoring remote and local servers/machines.
- Database development, maintenance and Migrations (MySQL, PostgreSQL and MSSQL).
- Ensuring database security
- Upgrading, installing, and configuring application software and computer hardware.
- Troubleshooting and providing technical support to employees.
- Performing regular security tests and security monitoring.
- Provide operational support to existing Company solutions.
- Managing and administering cloud applications and technologies.
- Designing custom software applications according to company specifications, including feasibility studies, design documentation, and implementation plans.
- Software development Laravel php framework.
- Developing of RESTFUL APIS development for Vue js framework and Flutter application.
- Software Installation and configuration as per defined requirement specifications.
- Dev Ops. Configuring Linux servers and maintaining them.
- Website maintenance in liaison with the marketing department for content.
- Introduction of new technology, methodologies, and tools to improve business efficiency.
- Providing advice on appropriate hardware configuration.
- Designing custom software applications according to the company requirements.
- Conducting configuration tests to verify it executes the required functions and meets company needs.
- Developing training materials to help company use new software products effectively.
- Recommending software technological solutions that best meet the company’s needs while considering budgetary concerns.
- Provide operational support to existing Company solutions.
- Web hosting, third party software solutions.
Mbitrix Technologies, Nairobi, Kenya Jan 2020 - Jan 2022
Full Stack Software & Database Developer.
Responsibilities:
- Full stack Laravel frontend and Backend software developer. Developing of RESTFUL APIS development for Vue js framework and Flutter application.
- Configuring and administering of SQL servers.
- Database development, maintenance, Manipulation and Migrations (MySQL and SQL).
- Dev Ops. Configuring Linux servers and maintaining them.
- Reviewing database management system procedures and suggested improvements.
- Oversee the administration of user accounts, permissions, and access rights in Active Directory in line with information security policy.
- Provide operational support to existing Company solutions.
- Introduction of new technology, methodologies, and tools to improve business efficiency.
- Ensure that the company is adaptable to evolving compliance regulations.
- Introduction of new technology, methodologies, and tools to improve business efficiency.
- Web hosting, third party software solutions.
- Improve existing programs by reviewing specifications and objectives and making necessary changes.
- Populating a database with new information or transfer existing data into it.
- Responsible for database security and also preventing data loss.
- Responsible for the physical and network security.
- Configured backups and logs to disk and storage manager, improving backup time.
- USSD (Unstructured Supplementary Service Data) Menus.
- Linux server Administration.
COMPULYNX LTD, Nairobi, Kenya Jan 2019 - Dec 2019
Software & Database Support Engineer.
Responsibilities:
- Databases development and maintenance (MySQL and MSSQL).
- Installing, maintaining and upgrading Microsoft sql server.
- Testing databases and programs, correcting errors and making modifications when necessary.
- Maintain company and clients’ records.
- Server and database management.
- Provide operational support to existing Company solutions.
- Identifying and analyze database system industry trends to keep management informed.
- Modifying database management systems, making changes whenever needed.
- Creating backup copies of data.
- Populating a database with new information or transfer existing data into it.
- Configuring backups and logs to disk and storage manager, improving backup time.
