Spigot Software - PostgreSQL Database Administrator (4-15 yrs)

Job Description :

- Experience in PostgreSQL,AWS Aurora and RedShift Database Administration.

- Install, monitor, and maintain PostgreSQL software, implement monitoring and alerting, implement backup and recovery processes, provide system and SQL performance tuning.

- Fulfill user requests ranging from access control, backup, restore, refresh to non-production to performance tuning.

- Provides online & on call coverage for production support and administration.

- Responsible for the monitoring and uptime of all production databases.

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

- Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.

- Develop Stored Procedures and Database Triggers in support of application development.

- Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.

- Responsible for regular backups and recovery of databases.

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

- Responsible for pro-active remediation of database operational problems.

- Responsible for Query tuning and preventative maintenance.

- Data Encryption : Implementing encryption at rest and in transit (e.g., SSL, TDE).

- Auditing and Compliance : Ensuring that databases comply with relevant regulations and performing regular audits.

Database Upgrades and Patch Management :

- Should have experience in patroni clusters.

- Experience in Shell scripting and automations

- Strong verbal and written communication skills

- Should have ability to work independently.

- Willingness to work in different shifts including night shift for 24/7 support.

Good to have :

- Knowledge of other database technologies Greenplum,Oracle etc

- Exposure to automation techniques/tools and languages.

- Experience with performance tuning and monitoring.

Soft Skills :

- Strong problem-solving and analytical abilities.

- Excellent communication skills, both verbal and written.

- Ability to work independently and in a team-oriented, collaborative environment.

- Attention to detail and a proactive approach to tasks and issues.