PLSQL / PostgreSQL Developer

Job Description :

• Create and manage multiple databases and assist in capacity planning.
• Monitor, maintain database systems and troubleshoot problems that may arise.
• Maintain data integrity, monitoring and security (manage roles and permissions of database users).
• Use tools like Profiler 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.
• Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
• Proactive housekeeping / archiving and shrinking of databases. Job Description Senior
• Database Administrator.
• 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 (internal teams and clients).
• Experience : 4 – 6 yrs