Technical Specialist - PostgreSQL (4-6 yrs)

Join Our Innovative Team as a Technical Specialist! and we are seeking a talented Technical Specialist to join our dynamic team.

Experience : 4+ years.

Location : Chennai.

Notice period : Less than 15days.

Responsibilities :

- Delivering and maintaining required documentation.

- Ensuring implementation of non-functional requirements on agreed technical and architectural standards.

- Defining, documenting, communicating and enforcing required standards, guidelines and best practices.

- Performing capacity planning.

- Performing trend analysis and forecasts.

- Compiling and deliver required reporting.

- Problem solving and in-depth root cause analysis.

- Analyzing system performance, make and implement recommendations on systems improvements and system tuning.

- Designing and delivering on continuity requirements.

- Ensuring optimum utilization and configuration of installed infrastructure.

- Planning, scoping and delivery of projects.

- Roadmap/ Upgrade path.

- Automation of administrative tasks.

- Cloud Experience.

Mandatory Skills :

- Installing PostgreSQL Software.

- Creating & Managing PostgreSQL Databases & Cluster.

- Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.

- Develop procedures for automated monitoring and proactive intervention, reducing any need for downtime.

- Responsible for regular maintenance on databases (i.e., Vacuum, Reindexing, Archiving).

- Managing Database Storage Structures.

- Administering User Security.

- Managing Data Concurrency.

- Managing Undo Data.

- Implementing Database Auditing.

- Database Maintenance.

- Performance Management.

- Responsible for query tuning.

- Backup and Recovery Concepts.

- Performing Database Backups & Recovery.

- Moving Data.

- Patch Management.