Consultant Specialist

Requirements

• Qualification: A Bachelor degree or equivalent experience with a major or minor in Computer Science or related field.
• Good understanding of PostgreSQL Architecture, security, operational knowledge
• Deep understanding of how PostgreSQL manages data, including tablespaces, data files, indexes, WAL (Write-Ahead Logging), and key processes like Postmaster and bgwriter
• Proficiency in installing, configuring, and upgrading PostgreSQL instances.
• Expertise in identifying and resolving performance bottlenecks, including SQL query optimization, index tuning, and server parameter adjustments.
• Good to have expertise in automating routine DBA task like log management, backups, schema migration, indexing and monitoring.
• Strong knowledge of various backup strategies (e. g. , pg_basebackup, WAL archiving) and recovery procedures to ensure data integrity and availability.
• Experience in Applying Patches and troubleshooting patch failure issues.
• Strong work experience in Unix\Linux Operating system and Shell Scripting
• Experience in implementing and managing replication solutions
• Streaming replication (primary/standby setup).
• Logical replication.
• Experience on Postgres failover and load balancing.
• Understanding of user roles, privileges, authentication methods, and best practices for securing PostgreSQL databases.
• Ensure database security by implementing best practices, including encryption, access control and auditing.
• Monitor and mitigate vulnerabilities in Postgres SQL environments.
• Ability to implement and utilize monitoring tools to track database health, performance metrics, and identify potential issues.
• Proficiency in scripting languages (e. g. , Bash, Python) for automating routine tasks, deployments, and maintenance
• Advanced knowledge of SQL for querying, data manipulation, and database object management
• Data migration from existing version to new versions
• Backup & restore from Prod to non-prod.
• Good to have experience in cross technology migration to Postgres ( ie. From oracle \SQL server to Postgres)
• Strong analytical and problem-solving abilities to diagnose and resolve complex database issues
• Effective communication skills for collaborating with development teams, system administrators, and other stakeholders
• Ability to work effectively within a team environment.