Manager - Customer Interaction Suite

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 Responsibilities:
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 migrations
Performance 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 usage
Security and Compliance: Implement role-based access control (RBAC) Manage encryption (data at rest and in transit) Ensure security standards and compliance policies
Linux and Infrastructure: Work on Linux systems (RHEL, CentOS, Ubuntu) Perform shell scripting (Bash) Analyse logs and system performance Collaborate with DevOps and infrastructure teams
Messaging Systems: Administer RabbitMQ and Apache Pulsar Manage queues, topics, partitions Configure replication and high availability Monitor and troubleshoot message flow issues
Data Warehousing: Manage Click House clusters Optimize large-scale data ingestion and queries Support analytics workloads and ETL pipelines
Automation and DevOps: Automate DBA tasks using Bash and Python Use Ansible or Terraform (optional) Support CI/CD pipelines for database deployments
Incident Management: Provide production support Troubleshoot outages and issues Perform root cause analysis (RCA)

Required Skills:
Core Database Skills: PostgreSQL, Oracle, MySQL SQL, PL/SQL, stored procedures Query tuning and indexing
Advanced Skills: Click House (OLAP systems) RabbitMQ and Apache Pulsar
System Skills: Strong Linux administration knowledge Apache server basics Bash and
Monitoring Tools: Prometheus, Grafana ELK Stack (Elasticsearch, Logstash, Kibana)

Qualifications and Experience:

Bachelor s degree in Computer Science or related field

5+ years of DBA experience

Certifications preferred (Oracle, PostgreSQL, MySQL)

Nice to Have: Cloud experience (AWS, Azure, GCP) Kubernetes and containerization Kafka, Airflow knowledge
Soft Skills: Problem-solving skills good communication Ability to work under pressure Attention to detail
Work Environment: Linux-based systems 24/7 production support environment Collaboration with DevOps and development teams