Job Description
• Provide support to application development teams, including database design, database generation, coding, and database support;
• Developing / maintaining Tables, Database links, Synonyms, Stored Procedures, Functions, Packages, Triggers, Cursors, Views, and Indexes;
• Modeling tables, databases, solutions to customer problems and needs;
• Plan and perform scheduled changes (patching, maintenance, deployment, decommission, configuration, performance tuning) for all hardware and software used to support the database infrastructure;
• Ensure that organizational data is secure.
• Provide a seamless flow of information throughout MIFOTRA, considering both backend data structure and frontend accessibility for end-users.
• Responsible for designing, testing, planning, implementing, protecting, operating, managing and maintaining MIFOTRA’s databases.
• Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
• Develop strategies and implement solutions for managing back-ups, restoration and replication;
• Responsible for designing, developing, implementing, and periodically testing a backup and recovery plan for the databases.
• Prepare IPPIS Quality Plan Reports
• Report customs system errors and recommend necessary fix.
• Provide Activity Completion Reports.
Minimum Qualifications
-
Bachelor’s Degree in Computer Science
3 Years of relevant experience
-
Bachelor’s Degree in Computer Engineering
3 Years of relevant experience
-
Bachelor’s Degree in Information and Communication Technology
3 Years of relevant experience
-
Master’s Degree in Computer Science
1 Year of relevant experience
-
Bachelor’s Degree in Information Systems
3 Years of relevant experience
-
Master’s Degree in Information Systems
1 Year of relevant experience
-
Bachelor’s Degree in Information Technology
3 Years of relevant experience
-
Master’s Degree in Information Technology
1 Year of relevant experience
-
Bachelor’s Degree in Business Information Technology
3 Years of relevant experience
-
Bachelor’s Degree in Computer Systems
3 Years of relevant experience
-
Master’s Degree in Computer Systems
1 Year of relevant experience
-
Master’s Degree in Business Information Technology
1 Year of relevant experience
Competency and Key Technical Skills
-
Integrity
-
Strong critical thinking skills and excellent problem solving skills.
-
Inclusiveness
-
Accountability
-
Communication
-
Teamwork
-
Client/citizen focus
-
Professionalism
-
Commitment to continuous learning
-
Interpersonal skills
-
1 year of experience in administering, managing and tuning databases
-
1 year of experience with programming languages such PL/SQL coding
-
Proficient SQL Server relational database management system
-
Ability to oversee and manage the IPPIS databases system.
-
Knowledge of all database versions
-
Proficient in designing, writing, editing, and debugging programs and databases
-
Proficient in web application security and database security
-
Good understanding of the data modeling
-
Good writing and Communication skills, teamwork.
-
Problem-solving and Analytical skills
-
Business awareness and understanding of business requirements of IT
-
A willingness to keep up to date with developments in new technology.