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.