- 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 procedures ? 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.
Functional Area:IT Software - DBA / Datawarehousing