Skills - Exp required
? Installation, configuration and upgrading of PostgreSQL server software and related products.
? Knowledge of creating and maintaining Tables, Partitioning, indexes, Global Temporary Tables, Triggers, stored
? Implement and maintain database security (create and maintain users and roles, assign privileges).
? Establish and maintain sound backup and recovery policies and procedures on all instances
? Monitoring, troubleshooting & resolution of failed tasks & database issues, taking action on issues reported by
proactive monitoring setup and having a sense of urgency to fix issues ASAP.
? Perform database tuning and performance monitoring.
? Setup replication modes on Postgre Server
? Setup and maintain documentation and standards.
? Perform general technical trouble shooting and give consultation to development teams.
? Maintain all Postgre SQL Instances
? Implement and maintain alerts on Postgre Servers
Must Have Skills
? Expertise with PostgreSQL Server. Minimum 1 yr experience in PostgreSQL Server.
? Experience on Linux / UNIX platforms and familiar with Linux I/O, memory, filesystems and commands
? Experience in installation and configuration of DB server on Linux / UNIX platforms independently
? Knowledge of ALL backup and recovery scenarios.
? Knowledge of the physical/logical database design.
? Experience in code migration, database change management and data management through the various stages of
the development life cycle.
Hand on with Linux scripting.
Skills Nice to have
? Good to have knowledge on writing Nested and complex DB scripts.
? Good communication skills with management, development teams, client and systems administrators.