Description :

Educational Qualification

• (B.E. / B.Tech) or (PG in IT /CS or Equivalent)

No. of resources

• 4

Total Experience

• 6 Years

Essential Requirement

•  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.
•  Writing SQL Jobs in MySQL
•  Writing SQL Jobs