Database Administrator
Summary
Production DBA in Bengaluru administering MySQL/MariaDB/PostgreSQL plus NoSQL platforms (MongoDB, Aerospike, ClickHouse, Redis): installs, upgrades, patching, backups/DR, replication/HA, query and config tuning, security/access control, monitoring, RCA, and on-call support. Linux/shell scripting expected; cloud and monitoring tool exposure preferred.
Role & responsibilities
35 years of hands-on DBA experience in production environments, with strong command of MySQL, MariaDB, or PostgreSQL (SQL, indexing, transactions, locking/concurrency, execution plans). • Hands-on experience in performance tuning, backup/recovery, replication/HA, and database security. • Practical experience with at least one NoSQL/distributed database such as MongoDB, Aerospike, ClickHouse, Redis, or equivalent Strong Linux/Unix fundamentals and shell scripting, with an automation mindset. • Strong troubleshooting, analytical, problem-solving, communication, and RCA skills. • Ability to work independently and learn new database technologies quickly. • Comfort working across multiple database technologies and supporting production systems, including on-call as required. • Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related technical discipline preferred. Preferred Skills • Cloud & DevOps: Basic exposure to AWS, Azure, or GCP; experience with cloud database services and infrastructure automation. • Monitoring: Experience with database and infrastructure monitoring using Prometheus, Grafana, ELK/OpenSearch, CloudWatch, or equivalents. • Scale & Migrations: Experience with multiple database technologies, large-scale/high-volume production databases, database migration/upgrade projects, or performance benchmarking. The Scope of Your Influence 1. Database Administration & Maintenance: • Administer production and non-production databases, including installation, configuration, upgrades, patching, and ongoing maintenance. • Manage database environments across MySQL, MariaDB, PostgreSQL, and NoSQL/distributed platforms such as MongoDB, Aerospike, and ClickHouse. • Execute database upgrades, patching, and migration projects in coordination with dependent application teams. 2. Monitoring & Troubleshooting: • Monitor availability, health, capacity, performance, replication, and resource utilization to maintain uptime and reliability. • Troubleshoot production issues, providing root cause analysis (RCA) and implementing fixes in a timely manner. • Participate in on-call support as required and in post-incident reviews. 3. Performance Tuning & Optimization: • Perform SQL/query tuning, execution-plan analysis, indexing, and configuration optimization. • Troubleshoot locks, blocking, deadlocks, and resource bottlenecks. • Identify opportunities to improve database efficiency through benchmarking and capacity analysis. 4. Backup, Recovery & High Availability: • Implement and maintain backup, restore, and recovery processes for business-critical databases. • Set up and manage high-availability and replication architectures. • Implement disaster-recovery processes and participate in DR testing and RCA. 5. Security & Access Management: • Manage database users, roles, privileges, and access controls. • Implement auditing and database security best practices. • Review access and audit trails regularly to keep database environments aligned with security best practices.
Preferred candidate profile
Perks and benefits