Addis Ababa,
VisionFund Micro-Finance Institution S.C.
Major Responsibilities:Create and manage multiple databases and assist in capacity planningMonitor, maintain database systems and troubleshoot problems that may ariseContinuously monitors and evaluates the efficiency and effectiveness of all database resources; identifies opportunities for improvement and provides recommendations Maintain data integrity and security (manage roles and permissions of database users).Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve themDevelop strategies and implement solutions for managing back-ups, restoration and replication.Create and manage constraints and indexes.Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.Ensure the smooth migration whenever there is a need for database upgrades. Ensure the consistency and integrity of data during the migration. Modifies the database structure, as necessary, from information given by application developersAnalyze system problems , perform root cause analysis and propose solutions Proactive housekeeping/archiving and shrinking of databasesEnsure the deployment of patches, new releases, installs software, manages database environment, monitors performance, and troubleshoots alerts.Customize system reports based on user inquiries if applicable Create detailed documentation including diagrams of database infrastructureLearn relevant business processes and understand the data flow, criticality and dependencies.Effectively coordinate and communicate with all the stakeholders (internal teams and clients).Ensure EOD, EOM and EOY processes done successfully
Addis Ababa,
VisionFund Micro-Finance Institution S.C.
Major Responsibilities:Create and manage multiple databases and assist in capacity planningMonitor, maintain database systems and troubleshoot problems that may ariseContinuously monitors and evaluates the efficiency and effectiveness of all database resources; identifies opportunities for improvement and provides recommendations Maintain data integrity and security (manage roles and permissions of database users).Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve themDevelop strategies and implement solutions for managing back-ups, restoration and replication.Create and manage constraints and indexes.Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.Ensure the smooth migration whenever there is a need for database upgrades. Ensure the consistency and integrity of data during the migration. Modifies the database structure, as necessary, from information given by application developersAnalyze system problems , perform root cause analysis and propose solutions Proactive housekeeping/archiving and shrinking of databasesEnsure the deployment of patches, new releases, installs software, manages database environment, monitors performance, and troubleshoots alerts.Customize system reports based on user inquiries if applicable Create detailed documentation including diagrams of database infrastructureLearn relevant business processes and understand the data flow, criticality and dependencies.Effectively coordinate and communicate with all the stakeholders (internal teams and clients).Ensure EOD, EOM and EOY processes done successfully