Job Description
Essential
Criteria
Qualification:
BE/B Tech or PG in lT / CS or equivalent
Experience
& Skills:
- Minimum 4 years of experience in development of T SQ/PL-SOL programming
- Work experience must span over 2 turn-key projects as a DBD
Job Objective:
The Database Developer's role is to design database schemas, all type of database objects like tables, views stored procedures, functions etc. including maintaining databases while ensuring high levels of data availability. The Database Developer will evaluate and advise on all technology components for database management systems and applications. As part of the role they will be responsible for implementing data dashboards to all levels of the department
Primary
responsibilities:
- 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 procedure for other developers working on the Business Access Layer / Service Layer using T-SQL / PL-SQL scripts.
- Configuration and Designing of Reporting Services Report.
- Conduct research and make recommendations on database products services, protocols, and standards in support of procurement and development efforts.
- Develop implement, and maintain change control and testing processes for modifications to databases. Coordinate and work with other technical staff to develop relational databases and secondary databases. Identify inefficiencies in current databases and investigate solutions.
- Diagnose and resolve database access and performance issues.
- Plan and coordinate data migrations between systems.
- 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