PostgreSQL Admin

Job Description

Role Overview:As a PostgreSQL Database Administrator (DBA) at our company based in Chennai, you will be responsible for the installation, configuration, and maintenance of PostgreSQL databases. Your role will involve performance tuning, query optimization, and database indexing to ensure optimal database functionality. Additionally, you will work on PostgreSQL replication, clustering, and high availability setups such as streaming replication and Patroni. Your expertise in PostgreSQL internals, including transaction management and query optimization, will be essential for this role. You will also be proficient in writing and troubleshooting SQL queries, stored procedures, and functions, as well as implementing database backup/restoration and disaster recovery strategies.Key Responsibilities:- Experience as a PostgreSQL Database Administrator (DBA).- Hands-on experience with PostgreSQL database administration, including installation, configuration, and maintenance.- Perform performance tuning, query optimization, and database indexing in PostgreSQL.- Implement PostgreSQL replication, clustering, and high availability setups like streaming replication and Patroni.- Knowledge of PostgreSQL internals, transaction management, indexing, and query optimization.- Write and troubleshoot SQL queries, stored procedures, and functions proficiently.- Manage database backup/restoration and disaster recovery strategies.- Utilize PostgreSQL monitoring tools effectively.Qualifications Required:- 5 to 9 years of experience as a PostgreSQL Database Administrator (DBA).- Strong expertise in PostgreSQL database administration.- Proficiency in performance tuning, query optimization, and database indexing in PostgreSQL.- Familiarity with PostgreSQL replication, clustering, and high availability setups.- In-depth knowledge of PostgreSQL internals, transaction management, and query optimization.- Ability to write and troubleshoot SQL queries, stored procedures, and functions.- Experience with database backup/restoration and disaster recovery strategies.- Familiarity with PostgreSQL monitoring tools. Role Overview:As a PostgreSQL Database Administrator (DBA) at our company based in Chennai, you will be responsible for the installation, configuration, and maintenance of PostgreSQL databases. Your role will involve performance tuning, query optimization, and database indexing to ensure optimal database functionality. Additionally, you will work on PostgreSQL replication, clustering, and high availability setups such as streaming replication and Patroni. Your expertise in PostgreSQL internals, including transaction management and query optimization, will be essential for this role. You will also be proficient in writing and troubleshooting SQL queries, stored procedures, and functions, as well as implementing database backup/restoration and disaster recovery strategies.Key Responsibilities:- Experience as a PostgreSQL Database Administrator (DBA).- Hands-on experience with PostgreSQL database administration, including installation, configuration, and maintenance.- Perform performance tuning, query optimization, and database indexing in PostgreSQL.- Implement PostgreSQL replication, clustering, and high availability setups like streaming replication and Patroni.- Knowledge of PostgreSQL internals, transaction management, indexing, and query optimization.- Write and troubleshoot SQL queries, stored procedures, and functions proficiently.- Manage database backup/restoration and disaster recovery strategies.- Utilize PostgreSQL monitoring tools effectively.Qualifications Required:- 5 to 9 years of experience as a PostgreSQL Database Administrator (DBA).- Strong expertise in PostgreSQL database administration.- Proficiency in performance tuning, query optimization, and database indexing in PostgreSQL.- Familiarity with PostgreSQL replication, clustering, and high availability setups.- In-depth knowledge of PostgreSQL internals, transaction management, and query optimization.- Ability to write and troubleshoot SQL queries, stored procedures, and functions.- Experience with database backup/restoration and disaster recovery strategies.- Familiarity with PostgreSQL monitoring tools.

Keyskills :
Performance tuningQuery optimizationClusteringSQL queriesStored proceduresDatabase backupPostgreSQL Database AdministratorPostgreSQL database administrationDatabase indexingPostgreSQL replicationHigh availability setupsFunctionsDisaster recove