Stephen Kamau

Experience

• 

  The Copycat Limited

  May 2013 - Dec 2015

  Database Engineer

  • Supported a team of partners to provide 24/7 technical support for a critical application at an uptime of 99.9% and an average ticket resolution time of 1 hour. • Proactively developed strategies and objectives specific to relative area(s) of expertise and assisted the Department Manager in developing overall departmental strategies (both shorter and longer term) by conducting weekly meetings to discuss project roadmaps, removing roadblocks and having the team track the deliverables. • Planned, installed, designed, and supported over 50 new and existing database processes resulting in an increase in database capacity of up to 50% and a reduction in downtime by up to 40%. • Executed proactive and reactive assessment, maintenance, and update of hardware and software on a variety of systems to ensure compliance with system standards. Processed an average of 60 tickets per month and assigned priorities to ensure maximum productivity. Show less

• 

  Premier Bank

  Dec 2015 - Nov 2017

  Oracle Database Administrator

  • Improved database management operations by 25% by reviewing and improving the process by which database management activities completed by the database administrators and support staff. • Directed the efforts of others to achieve the strategic and operational objectives of the group, and developed standards, including the improvement of database performance by 25% over a 6 month period. • Developed and implemented a backup and recovery strategy as well as cloning and recovery validation for all technology stacks and ERP application components. Reduced the time required to restore an ERP instance from 8 hours to 2 hours. • Completed 100% of high priority incidents within one hour, resolved 90% of all incidents within one business day and exceeded customer satisfaction goals by 25%. • Created detailed documentation for the project by using a database management system accessible to all project participants that enabled the project to be completed 15% faster than scheduled. Show less

• 

  Safaricom PLC

  Dec 2017 - Nov 2021

  Senior Database Administrator

  • Developed a strategy to reduce the number of support tickets by 20% by assisting the Database Engineers in developing overall departmental strategies over the next 4 months. • Developed and implemented the evaluation criteria and questionnaires for the assessment teams to determine the current database solutions and development roadmaps. The criteria and questionnaires reduced the assessment time from 8 hours to 4 hours, in turn reducing the assessment costs by 300%, and ultimately increasing the number of assessments completed from 3 to 5 per month. • Instituted tangible guidelines and methodologies that enhanced database support from 80% to 96% availability, resulting in a 20% improvement to the organization's bottom line. • Created, tracked and updated project schedule, communicate project status to the team members and to Project management. • Upgraded database systems to the new vendor release and provided ongoing progress to leadership, system owners, and peers regarding health of the environment and status of testing, by scheduling weekly meetings, by sending weekly e-mails to all stakeholders, and by providing metrics and detailed explanations of progress and issues. • Created detailed documentation for functional or technical design that can be understood and used by all project participants, resulting in a 75% reduction in errors and a 10% improvement in team collaboration. Show less

• 

  TechnoRoots Limited

  Sept 2021 - now

  Technical Consultant

  Assist with technical leadership and mentoring. Prepare technical solutions review technical solutions. Enable provisioning and ongoing support of our Oracle hosted client solutions. Systems Administration in Oracle and Amazon Cloud (AWS). Developing, maintaining, supporting, and optimizing key functional areas, particularly, network infrastructure, server infrastructure, data communications, and telecommunications systems. Conduct calls with various internal departments to identify project scope, requirements and create deployment plans. Advising Technical Architect on projectsParticipate in the production of Technical Architect Document to include Conceptual Technical Models, Platform, Performance, Dependability, Security, Operational Requirements, Integration and Interface, Project Infrastructure, and Batch Infrastructure Requirements, Training, and Disaster Recovery Plans, Performance Testing Approach, Technical Infrastructure ProcessesAssistance in Performance Test Plan/Benchmark Plan definition. To provide and deliver development services around Oracle Middleware Solutions and Technologies. Show less

• 

  Cellulant

  Nov 2021 - Sept 2024

  Principal Database Administrator

  • Created a database management system for tracking project progress and data access permissions, resulting in a 67% increase in productivity. • Delivered weekly summary reports to management, system owners, and peers regarding health of the environment and status of testing. Used Excel to produce weekly metrics for all SQL Servers, including number of databases, system health status, backup status, and high priority alerts. • Automated the process of updating customers’ contact information in the database. This process previously done manually by customer service staff, saving the company more than $50,000 annually. • Improved cost and efficiency by identifying non-standard licenses and practices in the development environment, and devising and implementing a plan to correct the issues, resulting in a 70% reduction in costs. • Developed and executed a strategic plan to implement a backup and recovery strategy that reduced critical application downtime by 98% through the implementation of automation procedures, reducing the time required to recover from a disaster by 80%. Show less

• 

  Equity Bank Limited

  Mar 2024 - now

  Senior Manager - Databases

  • Responsible for overseeing and managing the organization's database systems. This involves designing, implementing, andmaintaining database structures to ensure optimal performance and data integrity.• Key role in disaster recovery planning and execution, implementing and testing backup and recovery solutions to minimize dataloss and downtime. Developing and implemented backup and recovery strategies, reducing data loss incidents and ensuring dataintegrity and availability for critical business operations.• Optimizing database performance through performance analysis, tuning, capacity planning, and sizing for large-scale databases,resulting in a 40% reduction in storage costs and improved resource utilization, leading to significant cost savings for thecompany.• Conducting regular audits of data security and accessibility by identifying inconsistencies and implementing corrective actions asnecessary.• Increasing efficiency in software development processes through effective collaboration with developers to design databases thatsupport application requirements.• Resolving complex technical issues through expert troubleshooting skills and change management to minimize disruption to business operations. Show less