Sunshine Training & Placement Services
Location
Chennai | India
Job description
Responsible for maintaining the company's database systems including backup, performance tuning, capacity planning, monitoring critical events and documentation.ROLES AND RESPONSIBILITIES:- Create and manage multiple databases and assist in capacity planning.- Monitor, maintain database systems and troubleshoot problems that may arise.- Maintain data integrity and security (manage roles and permissions of database users).- Familiar with Tools 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.- Create and manage constraints and indexes.- Should be able to write and optimize existing queries.- Should have good knowledge is querying json dataset (MySQL)- Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.- Proactive archiving and shrinking of databases.- Manage production, QA and development database environments.- Create detailed documentation including diagrams of database infrastructure.- Learn relevant business processes and understand the data flow, criticality and dependencies.- Effectively coordinate and communicate with all the stakeholders.- Set up and maintain database infrastructure for the company's BI needs..- Well versed with one any RDMS and Big Data systems. (ref:hirist.tech)
Job tags
Salary
