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

7914 jobs available

PT. Permana Solutions
IT5 years
routing
switching
security
PT. Permana Solutions
IT5 years
VMware
RHEL
HPE server
+2 more
switches
routers
Cisco
+16 more