10 Aug
|
Tata Communications
|
Bengaluru
10 Aug
Tata Communications
Bengaluru
Database Administrator (DBA)
Job Summary:
We are looking for an experienced DBA with solid 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 syst
📌 Database Administrator (Bengaluru)
🏢 Tata Communications
📍 Bengaluru