Database Administrator

Database Administrator (DBA)

Job Summary

:We are looking for an experienced DBA with strong expertise in PostgreSQL, Oracle, MySQL, Click House, RabbitMQ, and Apache Pulsar. The candidate will manage database performance, availability, security, and support in a Linux-based production environment

.
Key Responsibilitie

s:Database Administration: Install, configure, and maintain PostgreSQL, Oracle, MySQL, and Click House databases Perform database tuning and performance optimization Design schemas, indexes, and partitioning strategies Manage backups, recovery, disaster recovery (DR), and high availability (HA) Perform database upgrades, patching, and migratio

nsPerformance and Monitoring: Monitor database systems using tools like pgAdmin, Oracle OEM, MySQL Workbench Use Prometheus, Grafana, Zabbix for monitoring Identify and resolve performance bottlenecks Optimize CPU, memory, and I/O usa

geSecurity and Compliance: Implement role-based access control (RBAC) Manage encryption (data at rest and in transit) Ensure security standards and compliance polici

esLinux and Infrastructure: Work on Linux systems (RHEL, CentOS, Ubuntu) Perform shell scripting (Bash) Analyse logs and system performance Collaborate with DevOps and infrastructure tea

msMessaging Systems: Administer RabbitMQ and Apache Pulsar Manage queues, topics, partitions Configure replication and high availability Monitor and troubleshoot message flow issu

esData Warehousing: Manage Click House clusters Optimize large-scale data ingestion and queries Support analytics workloads and ETL pipelin

esAutomation and DevOps: Automate DBA tasks using Bash and Python Use Ansible or Terraform (optional) Support CI/CD pipelines for database deploymen

tsIncident Management: Provide production support Troubleshoot outages and issues Perform root cause analysis (RC

A)
Required Skil

ls:Core Database Skills: PostgreSQL, Oracle, MySQL SQL, PL/SQL, stored procedures Query tuning and index

ingAdvanced Skills: Click House (OLAP systems) RabbitMQ and Apache Pul

sarSystem Skills: Strong Linux administration knowledge Apache server basics Bash

andMonitoring Tools: Prometheus, Grafana ELK Stack (Elasticsearch, Logstash, Kiba

na)
Qualifications and Experie

nce:Bachelor s degree in Computer Science or related f

ield5+ years of DBA experi

enceCertifications preferred (Oracle, PostgreSQL, My

SQL)
Nice to Have: Cloud experience (AWS, Azure, GCP) Kubernetes and containerization Kafka, Airflow know

ledgeSoft Skills: Problem-solving skills good communication Ability to work under pressure Attention to d

etailWork Environment: Linux-based systems 24/7 production support environment Collaboration with DevOps and development