Database Administrator- PostgreSQL

4 - 8 years

0 Lacs

Posted:5 days ago| Platform: Shine logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

As a Database Administrator (DBA) at our organization, you play a crucial role in managing and optimizing our data infrastructure. Your responsibilities include ensuring the performance, scalability, availability, and security of our data ecosystem. You will have the opportunity to work with a variety of databases, from traditional relational databases to modern analytical databases like ClickHouse and StarRocks. **Key Responsibilities:** - Designing, configuring, and maintaining databases (OLTP & OLAP) for scalability and high availability. - Managing and optimizing ClickHouse and StarRocks clusters for analytics and reporting workloads. - Overseeing relational databases like PostgreSQL, MySQL, and MongoDB. - Monitoring performance, troubleshooting bottlenecks, and implementing tuning strategies. - Implementing backup, recovery, and disaster recovery plans. - Ensuring data security, compliance, and access controls. - Collaborating with engineering and product teams to design efficient data models. - Supporting data pipelines and integrations with ETL/ELT processes. - Automating monitoring, alerts, and database maintenance using modern tools. **Qualifications Required:** - 3-6 years of experience as a Database Administrator or Data Engineer. - Strong hands-on expertise with ClickHouse and/or StarRocks. - Experience with PostgreSQL, MySQL, or MongoDB. - Proficiency in database tuning, indexing, partitioning, and query optimization. - Experience with replication, sharding, and clustering in high-volume systems. - Solid understanding of Linux system administration related to databases. - Knowledge of scripting (Python, Bash, SQL) for automation. - Hands-on experience with cloud database services (AWS RDS, GCP, or Azure). **Additional Details:** Unfortunately, there are no additional details about the company provided in the job description. As a Database Administrator (DBA) at our organization, you play a crucial role in managing and optimizing our data infrastructure. Your responsibilities include ensuring the performance, scalability, availability, and security of our data ecosystem. You will have the opportunity to work with a variety of databases, from traditional relational databases to modern analytical databases like ClickHouse and StarRocks. **Key Responsibilities:** - Designing, configuring, and maintaining databases (OLTP & OLAP) for scalability and high availability. - Managing and optimizing ClickHouse and StarRocks clusters for analytics and reporting workloads. - Overseeing relational databases like PostgreSQL, MySQL, and MongoDB. - Monitoring performance, troubleshooting bottlenecks, and implementing tuning strategies. - Implementing backup, recovery, and disaster recovery plans. - Ensuring data security, compliance, and access controls. - Collaborating with engineering and product teams to design efficient data models. - Supporting data pipelines and integrations with ETL/ELT processes. - Automating monitoring, alerts, and database maintenance using modern tools. **Qualifications Required:** - 3-6 years of experience as a Database Administrator or Data Engineer. - Strong hands-on expertise with ClickHouse and/or StarRocks. - Experience with PostgreSQL, MySQL, or MongoDB. - Proficiency in database tuning, indexing, partitioning, and query optimization. - Experience with replication, sharding, and clustering in high-volume systems. - Solid understanding of Linux system administration related to databases. - Knowledge of scripting (Python, Bash, SQL) for automation. - Hands-on experience with cloud database services (AWS RDS, GCP, or Azure). **Additional Details:** Unfortunately, there are no additional details about the company provided in the job description.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You