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

7677 jobs available

ITFull-Time2-5 years
SCCM
System Center Configuration Manager
SCOM
+8 more
Database developer
Data Engineer
Node.js
Express.js
Next.js
+17 more
Linux
System Administration
Automation
+7 more
Linux
System Administration
Automation
+8 more
ITFull Time5-10 yearsRemote
Salesforce
SFDC Communities
Pardot
+8 more