Must have experience of working in 1 major e-Governance project MYSQL
Work Experience must span over 2 turnkey projects as a DBD
Desirable Requirement
Working experience for government clients would be added advantage
Knowledge of Database administration lobs
Scheduling tasks, jobs, data migration
Deliverables
Design, deploy maintain data table structures, stored procedures, reports, and queries optimization.
Database configuration, migration performance monitoring as well as backup data recovery.
Writing efficient stored procedures for other developers working on the Business Access Layer / Service Layer using T-SQL / PL-SQL scripts.
Configuration and Designing of Reporting Services Reports.
Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
Coordinate and work with other technical staff to develop relational databases and secondary databases identify inefficiencies in current databases and investigate solutions.
Develop, implement, and maintain change control and testing processes for modifications to databases.
Ensure all database systems meet business and performance requirements.
Diagnose and resolve database access and performance issues.
Plan and coordinate data migrations between systems.
Develop, implement, and maintain change control and testing processes for modifications to databases. Ensure all database systems meet business and performance requirements.
Produce ad-hoc queries and develop reports to support business needs.
Creation and maintenance of technical documentation. Development and maintenance of Data warehouse.
Implementation of data dashboards to display data in various formats.