PostgreSQL

HCL International have many opportunities for Nurses to experience life in the Middle East. If sunshine, excellent career progression and tax free salaries attracts you, read on. We are recruiting for the following specialties: Medical Services, Surgical Services, Maternal/Child Health Services, Critical Care, Ambulatory Care and Emergency Room. HCL International is a FREE service. Once we have found you a job you will be employed by the hospital in Abu Dhabi, Dubai or Al Ain.

• Should have Minimum 8 years of relevant experience in PostgreSQL, Oracle, MSSQL, MYSQL but at least over 4 years in PostgreSQL as L3/L4 support
• PostgreSQL Associate/Professional certifications is preferred.
• Must have strong knowledge on documentation and industry best practices on PostgreSQL
• Must have experience in PostgreSQL database architecture, , installation on Unix & Windows platforms
• Responsible for Provisioning and Decommissioning PostgreSQL (Enterprise DB)
• Expertise in migration from Oracle, MSSQL to PostgreSQL
• Responsible for Major Upgrades/Patching PostgreSQL (Enterprise DB etc.)
• Responsible for configuration & maintenance of backups and recovery of databases
• Responsible for Database Security, Compression, Encryption and Decryption
• Responsible for maintenance on databases (e.g., Vacuum, Reindexing, Archiving)
• Responsible for pro-active remediation of database operational problems
• Responsible for Performance tuning of database, Query tuning, system tuning, resource contention analysis
• Responsible for configuration & maintenance of standby replication methodologies like Streaming replication, hot standby, WarmStandby, Cascade replication and Synchronous replication for disaster recovery.
• Responsible for maintain security and integrity controls.
• Tuning autovacuum parameters to ensure up to date table stats and reclaim space
• Develop SQL reports that meet client expectations for the application (used by custom application)
• Responsible for Configuring log analyzation tools like pgFouine and pgbadger etc
• Installing and configuring nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively
• Daily log analysis using pgbadger tool and query tuning
• Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc
• Maintaining custom vacuum strategies at table and db level
• Performance Tuning experience
• Develops project plans for implementing database environments. Provides input to technical projects and oversees the tactical aspects of all database related tasks.

• Minimum Experience : 8 Years
• A candidate should have least over 4 years in PostgreSQL as L3/L4 support.