Description
Profile Database Developer (SQL Server or MYSQL)
Educational Qualification - (B.E. / B.Tech) or (PG in IT /CS or Equivalent)
Total Experience - 6 Years
Essential Requirement
• Knowledge of Database administration jobs
• 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