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

Database Administration
Schema Creation
Schema Management
+13 more
ITFull-Time3-5 years
MySQL
Oracle
MS SQL
ITFull Time3-5 years
MySQL
Oracle
MS SQL
PostgreSQL
Odoo DB
SQL Server
Snowflake
CosmosDB
+1 more