Job Description
Position Description :
Must have 8+ years DBA working experience with PostgreSQL +.6+ version and good understanding of Oracle Database and Microsoft SQL Server.
Knowledge about PostgreSQL Architecture.
PostgreSQL Installation & Configuration.
Database user roles and Security related permission.
User creation, object Backup & Restore.
Creating and Managing PostgreSQL Databases.
Client Authentication.
Backup, Recovery and PITR.
Monitoring disk usage.
Transferring Data.
Moving Transaction Logs.
Reliability and WAL configuration.
PostgreSQL Index Management.
High Availability Failover Replication setup.
DR Replication monitoring and configuration.
Implementing PostgreSQL related tools(PGAdmin).
Monitor database performance and recommend improvements for operational efficiency.
PostgreSQL encryption tool (pgcrypto)
PostgreSQL migration tool (ora2pg, sqlserver2pgsql )
Practical knowledge and experience with managing PostgreSQL and SQL / Server database environments.
Deep knowledge of database systems, and the use of them on virtual and physical systems.
Deep knowledge of performance monitoring techniques and analysis tools.
Capability to write clear and structured technical documents.
Must be knowledgeable and experienced in managing PostgreSQL on multiple operating systems including Microsoft Windows, Linux (RHEL) and Kubernetes in OpenShift platform
Experienced in setting up PostgreSQL clusters and supporting databases cluster in on-prem and hybrid cloud environment, and specifically in AWS RDS instance.
Strong skills in UNIX / Linux Shell Scripting
Experience in implementing Postgres STIG implementation, testing, and other vulnerability remediation.
Working Knowledge of connection poolers (pgPool and pgBouncer).
Install, monitor and maintain PostgreSQL software, implement monitoring and alerting.
Experience in building high-scalable clusters, failover and hot standby solutions based on Maximum available architecture
Experience in architecting, configuring, setting up Enterprise Fail over manager or similar technology for High availability solution.
Experience in leading efforts related to system and SQL performance tuning and assisting business process integration with various data sources.
Ability to work well with development and infrastructure teams in doing database design, changes and enhancement to new and existing applications
Proven ability to provide High Availability and Disaster Recovery solutions.
Maintain operational documentation (e.g., procedures, task lists, architecture blueprints)
Strong Troubleshooting Skills
Ability to maintain a positive attitude while working with high demands and short deadlines that leads to working after hours.
Skills : Change Management
Change Management
ITIL
Postgre SQL
Problem Management
0,,0,,0,,0
Must have 8+ years DBA working experience with PostgreSQL +.6+ version and good understanding of Oracle Database and Microsoft SQL Server.
Knowledge about PostgreSQL Architecture.
PostgreSQL Installation & Configuration.
Database user roles and Security related permission.
User creation, object Backup & Restore.
Creating and Managing PostgreSQL Databases.
Client Authentication.
Backup, Recovery and PITR.
Monitoring disk usage.
Transferring Data.
Moving Transaction Logs.
Reliability and WAL configuration.
PostgreSQL Index Management.
High Availability Failover Replication setup.
DR Replication monitoring and configuration.
Implementing PostgreSQL related tools(PGAdmin).
Monitor database performance and recommend improvements for operational efficiency.
PostgreSQL encryption tool (pgcrypto)
PostgreSQL migration tool (ora2pg, sqlserver2pgsql )
Practical knowledge and experience with managing PostgreSQL and SQL / Server database environments.
Deep knowledge of database systems, and the use of them on virtual and physical systems.
Deep knowledge of performance monitoring techniques and analysis tools.
Capability to write clear and structured technical documents.
Must be knowledgeable and experienced in managing PostgreSQL on multiple operating systems including Microsoft Windows, Linux (RHEL) and Kubernetes in OpenShift platform
Experienced in setting up PostgreSQL clusters and supporting databases cluster in on-prem and hybrid cloud environment, and specifically in AWS RDS instance.
Strong skills in UNIX / Linux Shell Scripting
Experience in implementing Postgres STIG implementation, testing, and other vulnerability remediation.
Working Knowledge of connection poolers (pgPool and pgBouncer).
Install, monitor and maintain PostgreSQL software, implement monitoring and alerting.
Experience in building high-scalable clusters, failover and hot standby solutions based on Maximum available architecture
Experience in architecting, configuring, setting up Enterprise Fail over manager or similar technology for High availability solution.
Experience in leading efforts related to system and SQL performance tuning and assisting business process integration with various data sources.
Ability to work well with development and infrastructure teams in doing database design, changes and enhancement to new and existing applications
Proven ability to provide High Availability and Disaster Recovery solutions.
Maintain operational documentation (e.g., procedures, task lists, architecture blueprints)
Strong Troubleshooting Skills
Ability to maintain a positive attitude while working with high demands and short deadlines that leads to working after hours.
Skills : Change Management
Change Management
ITIL
Postgre SQL
Problem Management
0,,0,,0,,0
💡 Quick Summary
Seeking a career-building opportunity? The PostgreSQL Consultant position is now open for candidates interested in the Database Administrator sector. This role in Bengaluru offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
