24 Oct
|
V2Soft
|
Bengaluru
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.
- Robust 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.
- 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.
- 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.
- 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
📌 Database Administrator (Bengaluru)
🏢 V2Soft
📍 Bengaluru