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 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 field5+ years of DBA experience Certifications preferred (Oracle, PostgreSQL, My SQL) 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 Show more