shemsu dabesa

• Installation, creation and configuration of the databases (PostgreSQL Clusters, Oracle,
MySQL, SQL servers, etc..) for testing, staging and production.
• Perform MOSIP micro-services migration between servers and platforms.
• Implement and monitor database access management for NIDP platform users and services.
• Generating pg-Badger reports and identifying the most time-consuming queries, frequent
errors, and potential performance issues.
• Configuring logical & physical backups using pg-dump and BARMAN utilities respectively
on local and cloud storages.
• Design and implement high availability (HA) and replication strategies using PostgreSQL
tools (e.g., streaming replication, Patroni, DCS/etcd, HAProxy) to ensure data continuity,
failover support, and minimal downtime.
• Develop and test robust disaster recovery and backup plans, ensuring rapid data restoration
and minimal downtime in the event of data loss.
• Implement advanced tuning strategies, including indexing, partitioning, and query
optimization, to improve responsiveness and maximize throughput across database systems.
• Assess and recommend emerging database technologies, considering cost-benefit analyses to
inform decisions that align with organizational objectives.
• Analyze database usage and performance trends to guide capacity planning, ensuring
resources are allocated to meet growth and operational needs.
• Establish and enforce database security policies to ensure compliance with organizational IS
policy and protect sensitive data from unauthorized access.
• Conduct regular security audits and vulnerability assessments, implementing proactive
remediation strategies to mitigate potential risks.
• Collaborate with development, server/storage, and DevOps teams to integrate database
systems effectively, supporting seamless data flow within the broader architecture.
• Lead the response to complex database incidents, conducting root cause analysis and
implementing corrective actions to prevent recurrence.
• Mentor junior database administrators and engineers, providing expertise in database design,
optimization, and troubleshooting practices.
• Maintain comprehensive documentation of installations, configurations, incident resolutions,
contributing to a knowledge base that aids in skill development and knowledge transfer.
• Work with the companys management to understand the companys data needs and to plan
the goals of the database.
• Working closely with stakeholders in the company to make sure that the databases meet the
companys expectations and provide full support when required.
• Stay informed of industry trends and advancements in database technology, conducting
research to guide future database strategies and introducing innovative solutions as
appropriate.

• End-to-end project lifecycle management for all projects of the company like BNPL, IFB,
NID, Invoice financing, Embedded Finance, SOC2 Type 2 and ISO 27001 .
• Overseeing timelines, budgets, scope, quality, and cross-functional teams to ensure
successful delivery of the products.
• Preparing project charter and RACI matrix.
• Keeping project team members and stakeholders informed, responsible, and involved
• Working with and acting as the focal point for the remote consultant team
• Tracking project progress and guarantee improved status visibility using JIRA and MS
project.
• Scheduling and leading project calls & meetings with both internal and external
participants
• Managing communications using internet-based communication and collaboration tools
• Supporting the product owner in managing communications with stakeholders and
managing projects requirement for deliverables
• Leading, directing, and motivating project teams to reach goals, objectives, and
deliverables.
• Coordinating project resources, tracks progress, and reports to stakeholders.
• Identifying risks, create mitigation strategies, and communicate effectively with all
stakeholders.
• Preparing change logging, risk register and resource management templates.
• Collaborate with stakeholders and team members

• Leading selection of preferred data management technologies, the development of future
enterprise data architecture and create models for new database development and/or
changes to existing ones.
• Installation, creation and configuration of the databases (Oracle, MySQL, SQL servers,
and Percona XtraDB Clusters)
• Working closely with stakeholders in the company to make sure that the databases meet
the companys expectations.
• Monitoring AWS RDS (Amazon Relational Database Service).
• Explore potential new technologies to assist the company in coping with the
globalization.
• Creating and maintaining security for the database and creating standards for all users to
ensure that the database system is safe.
• Develop and implement database performance monitoring process.
• Help define back-up & recovery strategy, backup and restore data to prevent data loss
• Work with an organizations management to understand the companys data needs and to
plan the goals of the database.
• Provide off hours support as required
• Manage and/or provide guidance to junior members of the team.

 Database performance tuning, monitoring, and working on report performance enhancement. Database capacity planning and Ensuring High Availability.
 Managing & monitoring all databases (Production as well as UAT) of the company.
 Ensuring the security & integrity of all databases of the company
 Change Management (Performing impact analysis before changes are made on the databases: testing changes, implementing changes, and documenting them)
 Ensuring the compliance of all databases of the company to PCI DSS (Ensure systems meets the PCI standards).
 Managing and monitoring the functionality and status of RAC databases & data guard environments.
 Data archival and purging for performance and space reclaim regularly using different methodologies (Purging from tables and rebuilding the indexes).
 Taking regular backups of the databases and monitoring backups (Check all scheduled backups are successful).
 Automation of daily and repeated tasks using the Job schedule and Cron (Shell scripting)
 Validating backup and restore functionality, accuracy and integrity/consistency i.e. validate and verify backups without doing actual restores.
 Developing annual activity plan based on the overall annual plan of the company
 Preparing weekly, monthly and quarter reports on the planned and other related activities and presenting those reports.
 Writing and maintaining necessary documentation to rebuild the current systems configuration should major problems arise.
 Contacting oracle support & application vendor when support is needed and providing them with necessary input data to diagnosis and troubleshoot problems.
 Coordinate with vendors, technology partners in selecting new solutions and maintaining the existing devices.

• Preparing annual plans and budgets of the division
• Planning, organizing, leading & controlling the design, implementation and integration of
all production & UAT databases.
• Change Management (Performing impact analysis before changes are made on the
databases: testing changes, implementing changes, and documenting them)
• Leading the deployment of new application, database systems, updates, patches or fixes
on production systems.
• Providing assignments to and supervising the daily activities of DBAs.
• Authorize the proper execution of the duties & responsibilities of the division.
• Ensuring the security & integrity of all databases.
• Proposing & implementing database systems enhancements.
• Ensuring the compliance of all databases of the company to PCI DSS.
• Ensuring High Availability (managing and monitoring the functionality and status of
RAC databases & data guard environments)
• Data archival and purging for performance and space reclaim regularly.
• Preparing weekly & monthly report on the planned activities of the division.
• Writing and maintaining necessary documentation to rebuild the current systems
configuration should major problems arise.
• Contacting oracle support & application vendor when support is needed and providing
them with necessary input data to diagnosis and troubleshoot problems.

•Monitoring over all companys IT infrastructure.
•Coordinating and working with teammate.
•Developing database backup and recovery procedure and policy based on the overall company’s IT policy
•PCI DSS & company standards security implementation
•Configuring and monitoring RMAN & Data pump backups.
•Verifying /checking that all database instances are up and running
•Ensuring that databases are available 24x7 to users when they need access to data
•Managing and monitoring the functionality and status of RAC databases and environments
•Managing and monitoring the functionality and status of physical standby databases (Data Guard) environments(RAC Data Guard)
•Managing Oracle Database Users
•Reviewing, managing and backing up the audit logs/Audit Trails at regular intervals.
•Database performance tuning & monitoring.
•Organizing daily & weekly reports and submitting to COO (Chief Operation Officer)
•Writing and extracting different reports against the databases and submitting to concerned person/units as per their request.
•Database SLAs and Contract Administration with Oracle and product vendor.

• Develops the annual operating and capital expenditure plan for infrastructure.
• Leads the development of the infrastructure and operations strategy and roadmap
• Working with and leading a team effectively in order to achieve the desired goals
• Proactively monitoring health of all IT infrastructures to ensure 24/7 availability.
• Provides leadership, coaching and direction to the Infrastructure team.
• Developing computing systems backup and recovery procedure and policy.
• PCI DSS & company standards security implementation
• Managing and monitoring the security and performance of all IT infrastructures
• Organizing daily & weekly reports and submitting to COO (Chief Operation Officer)
• Database SLAs and Contract Administration with Oracle and product vendors.
• Maintain data integrity and security (manage roles and permissions of database users).
• Effectively coordinate and communicate with all the stakeholders.

• Database storage space management
• Installation and configuration of Oracle Software, Oracle Solaris and oracle Web logic
• Ensuring High Availability
 Verifying /checking that all database instances are up and running
 Ensuring that databases are available 24x7 to users when they need access to data
 Installing & Configuring RAC databases.
 Managing and monitoring the functionality and status of RAC databases and environments
 Configuring and monitoring physical standby databases (Data Guard).
• Developing database backup and recovery procedure and policy based on the overall company’s IT policy
• Configuring logical & physical backups using data pump utility and RMAN respectively and scheduling them to be run automatically at given interval and monitoring backups (Check all last night backups are successful)
• Monitoring and validating backup’s functionality, accuracy & integrity or consistency i.e. Validating & verifying backups without performing the actual restores at some regular intervals.
• Restoring production databases to test environment using both data pump utility and RMAN restore and recovery options.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 13c & configuring oracle database repository (oracle database 12c)
• PCI DSS & company standards security implementation
• Maintaining confidentiality of work related information and materials, confidentiality with regard to the information being processed, stored or accessed.
• Managing Database Users
 Enrolling database system user and granting appropriate privileges and roles to these users based on the principle of least privileges.
 Ensuring that only authorized users have access to databases
 Creating user profile and assigning to users if needed
 Altering, locking and dropping users when needed
• Setting up or enabling & configuring database auditing
 Monitoring and recording selected user database actions
 Enabling auditing of the SYS connections, and users connecting with the SYSDBA or SYSOPER privilege.
 Reviewing, managing and backing up the audit logs/Audit Trails at regular intervals once database auditing is enabled.
• Change Management
 Developing change management procedure.
 Performing impact analysis before changes are made on the databases: testing changes, implementing changes, and documenting them
• Database performance tuning.
 Tuning Performance of the databases by tuning crucial instance parameters that have high performance impact on databases.
 Monitoring performance, diagnosing performance problems and determining ways to optimize database performance (over all tuning).
 Generating AWR and ADDM reports & implementing recommendations from the reports.
 Identifying most resource intensive queries & taking appropriate actions.
 Identifying blocking sessions & taking corrective actions.
 Identifying candidate indexes for rebuilding & rebuilding them as needed
 Identifying foreign Keys with no Index and creating index on them as needed
• Supporting and Working with Teammates in relevant issues
 Working with application, system and network administrators in relevant areas to achieve the company’s objectives, vision and mission.
 Providing necessary full database related supports when required.
 Helping System users through a series of actions, either face to face or over the telephone to resolve different issues.
 Writing and extracting different reports against the databases and submitting to concerned person/units when requested
 Identifying the root cause and troubleshooting or resolving problems when they happen
 Document system problems and resolutions for future reference
• Writing and maintaining necessary documentation to rebuild the current infrastructure should major problems arise.
• Log and maintain issues with Oracle Support I.e. Contacting oracle support when support is needed and providing them with necessary input data to diagnosis and troubleshoot problems

• Installation and configuration of Oracle Software, Oracle Solaris and oracle Web logic
• Ensuring High Availability
• Configuring logical & physical backups using data pump utility and RMAN respectively.
• Restoring production databases to test environment to test various scenarios.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 13c.
• PCI DSS & company standards security implementation
• Managing Database Users, and configuring database auditing
• Database storage space management (Both at OS and database levels)
• Database performance tuning.
• Generating AWR and ADDM reports & implementing recommendations.
• Writing and maintaining necessary documentation to rebuild the current infrastructure
should major problems arise.
• Database SLAs and Contract Administration

•Plan and review database storage requirements
•Training staff on oracles SQL fundamentals, Administration, security, auditing, RMAN backup etc…
•Co-ordinate and work as part of a team and provide full support when required to achieve the vision and the goals of the company
•Organizing weekly report and submitting to division head/lead
•Responsible for proactive monitoring and maintenance of database.
•Monitor database performance, diagnose performance problems, and tune the database as necessary.
•Monitor alert log entries
•Check all crons and Oracle Jobs are completed without any error
•Support the roll-out of new applications
•Maintaining confidentiality of work related information and materials
•Maintain confidentiality with regard to the information being processed, stored or accessed.
•Document system problems and resolutions for future reference
•Comply with standards and policies and procedures
•Maintain database integrity and security
•Support development team in relevant issues
•Help users through a series of actions, either face to face or over the telephone to resolve issues.
•Generate relevant reports
•Communicating product venders when support is needed and providing them with necessary information they need.

• Leading the deployment of new application, database systems and updates
• Plan and review database and application storage requirements
• Configuring and managing Oracle Stream replication to decentralize databases
• Training staff on oracle SQL fundamentals, administration, security, auditing, RMAN
• Co-ordinate and work as part of a team and provide full support when required.
• Monitor database performance, diagnose performance problems, and tune databases
• Support development team in relevant issues and in the roll-out of new applications
• Organizing weekly report and submitting to division manager
• Document system problems and resolutions for future reference
• Maintain database integrity and security
• Communicating product venders when support is needed.

• Designing database based on design methodology to support business applications.
• Design and implement necessary modifications to enable databases accommodate newly
introduced structures or changes
• Configuring and managing replication systems through Talend (ETL) tool
• Performance tuning of Jboss application server.
• Designing a report by using jasper reporting tool
• Automation of daily and routine tasks using the Job schedule and Cron (Shell scripting).
• Configuring and monitoring RMAN & Data pump backups
• Database performance tuning
• Support development team in relevant issues and the roll-out of new applications
• Document system problems and resolutions for future reference
• Writing and extracting different reports against the databases and submitting to
concerned person/units as per their request.
Key achievements:
• Upgrade and data migration
◦ Oracle database from Standard Edition to Enterprise Edition.
◦ MS SQL server 2008 database to oracle 11g Enterprise Edition.
• Implementation of real time replication of data in distributed environments to ensure high
availability of databases using Oracle Streams.
• Restoring and recovering completely corrupted database

• Supervise the administration and maintenance of the banks databases.
• Identify, evaluate and recommend hardware or software technologies to achieve desired
database performance.
• Co-ordinate and work as part of a team and provide full support when required
• Provide guidance to database team on database structures and features.
• Maintain database disaster recovery procedures to ensure continuous availability
• Installing and configuring J2ee application Server and deploying FLEXCUBE.
• Creating multiple oc4j instances and tuning them.
• Monitoring the functionality and performance of application servers.
• Monitoring storage space usage and availability of the databases
• Taking the backup of the databases (logical and physical) and validating the backups.
• Restoring and recovering RMAN backup on new server to test the validity of the backup.
• Tuning Performance of the database.
• Maintaining confidentiality of work-related information, materials and the information
being processed, stored or accessed.

• Configuring and managing replication systems using HVR replication tool
• Creating different database objects like views, procedures and triggers as needed
• Training junior database officers on the companys database architectures.
• Developing good backup and recovery strategies & taking backup of the companys
databases (logical & physical) and validating the backups
• Controlling the security of the databases, enrolling database users and granting them the
necessary roles and privileges
• Allocating system storage and planning future storage requirements for the database
• Monitoring alert log and trace files
• Maintaining confidentiality of work-related information and materials
• Generating various reports when needed

• Installation of Oracle 10g/11g software.
• Creating development, test, UAT and production databases
• Enrolling system users and granting them the necessary roles
• Taking the backup of the databases (logical and physical) & validating the taken backups
• Checking the availability of free space both on hard disk and table spaces
• Checking for the log and trace files to take corrective action proactively
• Database performance tuning and monitoring
• Ensuring security of databases

• Supporting tax payers on different issues
• Joining new computers to the network of the company
• Trouble shooting network and printer problems
• Formatting end users computer on demand and installing different software and Anti
viruses
• Installing oracle client software and configuring oracle forms and reports
• Training end users on how to use the systems.
Key achievements:
• Implementing real time replication of data in distributed environments to ensure high
availability of databases using HVR (High Volume Replicator) third party software.
• Restoring and recovering completely corrupted database (physical corruption of
databases) by using RMAN restore and recovery options