TalentAQ

TalentAQ

PostgreSQL Database Administrator

ITFull Time5-6 years

Required Skills
14 skills

PostgreSQL
SQL
Teradata
Alteryx
Shell scripting
Big Data
Cloudera
Jenkins
Ansible
GIT
Backup and Restore
Performance Tuning
Automation
CICD

Job Description

Optimize and Enhance: Configure, monitor, and improve #PostgreSQL databases to ensure peak performance. Strategic Planning: Allocate system storage and meticulously plan storage requirements. Data Integrity: Plan and execute backup, restore, and recovery processes; manage data replication seamlessly. Performance Mastery: Conduct query analysis for troubleshooting and performance tuning (indexes, partitioning, statistics). Stay Updated: Apply the latest database and server OS software patches and upgrades. Automation Guru: Automate DBA activities, alerts, and reporting for efficiency. Documentation Expert: Create comprehensive documents on DBA processes and automatic jobs. Holistic Awareness: Maintain a keen awareness of infrastructure and software around the database. Proactive Improvement: Provide innovative suggestions to enhance the database and its usage. Additional Responsibilities: Teradata Database: Perform essential DBA tasks such as monitoring, user management, space management, and user support. Participate in the CICD process and support Teradata database components. Troubleshoot SQL failures and performance issues. #Big Data (Cloudera): Collaborate with other teams to support troubleshooting and internal processes.
Optimize and Enhance: Configure, monitor, and improve #PostgreSQL databases to ensure peak performance. Strategic Planning: Allocate system storage and meticulously plan storage requirements. Data Integrity: Plan and execute backup, restore, and recovery processes; manage data replication seamlessly. Performance Mastery: Conduct query analysis for troubleshooting and performance tuning (indexes, partitioning, statistics). Stay Updated: Apply the latest database and server OS software patches and upgrades. Automation Guru: Automate DBA activities, alerts, and reporting for efficiency. Documentation Expert: Create comprehensive documents on DBA processes and automatic jobs. Holistic Awareness: Maintain a keen awareness of infrastructure and software around the database. Proactive Improvement: Provide innovative suggestions to enhance the database and its usage. Additional Responsibilities: Teradata Database: Perform essential DBA tasks such as monitoring, user management, space management, and user support. Participate in the CICD process and support Teradata database components. Troubleshoot SQL failures and performance issues. #Big Data (Cloudera): Collaborate with other teams to support troubleshooting and internal processes.

Similar Jobs

7011 jobs available

SQL Server
PostgreSQL
performance tuning
+14 more
Flint Middle-East
ITContract5-7 years
PostgreSQL
MySQL
MongoDB
+8 more
PostgreSQL
MySQL
MongoDB
+5 more
Oracle
PostgreSQL
RDBMS
+9 more
Database Management
Performance Tuning
Data Security
+3 more
Oracle
MS SQL Server
SQL
+10 more