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

7334 jobs available

ITContract2-3 yearsRemote
Salesforce
Flows
Process Builder
+7 more
ALTA Computec PLC
IT3+ years
Analytical skills
Problem-solving skills
Scripting Languages
+1 more
Linux
RHEL
Ubuntu
+8 more
ITContract2-3 yearsRemote
Salesforce
Flows
Process Builder
+6 more
EngineeringContract3-5 years
Linux
Networking
Automation
+10 more
Galaxy I Tech
Engineering
DevOps
AWS
RDS
+7 more