Dear Candidate,
I hope this message finds you well! We have an exciting opportunity at our company Tata Business Hub for a DBA role, and based on your experience and skill set, I believe this role could be a great fit for you.
Company Details : Tata Business Hub is a digital first B2B organization setup by TATA Group to holistically address the needs of Emerging Businesses. We value the pivotal role of emerging businesses in our Nations economic growth and prosperity, and believe in empowering them to be deeply aware, widely connected and digitally integrated. Offering a host of economical and highly relevant business capabilities, Tata Business Hub aims to be the catalyst, propelling emerging businesses into new frontiers of growth and performance.
At Tata Business Hub, our ambition is vast-
We want to become the pre-eminent company that works for MSMEs in India
Grow their business
Solve their challenges
Optimize their processes
Job Overview:
Database Administrator (DBA)
Key Responsibilities:
1. Database Design & Architecture:
- Design and implement database architectures tailored to business needs.
- Work with application developers to design, test, and deploy database schemas that are optimized for application performance.
- Ensure scalability of database systems for business growth.
- Define and implement database standards and best practices across the organization.
- Architect high-availability database solutions and implement failover strategies for mission-critical applications.
2. Database Maintenance & Management:
- Install, configure, and upgrade database software to latest version.
- Monitor database performance and implement optimizations (e.g., indexing, query optimization).
- Perform routine database maintenance tasks including patching, tuning, and monitoring .
- Conduct database capacity planning and resource allocation to meet business needs.
- Troubleshoot and resolve database-related issues and performance bottlenecks.
3. Backup & Disaster Recovery:
- Design and implement backup and recovery strategies to ensure data integrity and availability.
- Monitoring backup tests
- Implement and maintain disaster recovery procedures to ensure minimal downtime in case of a system failure or disaster.
- Test, update, and document disaster recovery plans to ensure business continuity.
- Coordinate with stakeholders to ensure that backup requirements and retention policies are met.
4. Database Replication & High Availability:
- Manage, and troubleshoot database replication (master-slave, multi-master, etc.) for high availability and fault tolerance.
- Monitor and troubleshoot replication lag, conflicts, and other related issues to ensure data consistency and system reliability.
- Optimize replication configurations to minimize downtime and improve performance.
5. Security & User Management:
- Implement and enforce database security policies, including user access controls, password management, and encryption.
- Configure and manage database user roles, permissions, and access controls.
- Regularly audit user access to ensure compliance with security standards and regulatory requirements.
- Ensure database security by configuring firewalls, securing communication channels, and applying encryption at rest and in transit.
- Respond to and manage security vulnerabilities, including applying patches and updates to mitigate risks.
- Work with the development and operations teams to optimize cloud database environments for performance, security, and cost-efficiency.
7. Performance Monitoring & Tuning:
- Continuously monitor database performance and perform proactive tuning.
- Identify slow-running queries and optimize them to improve overall system performance.
- Review database query execution plans and recommend changes to optimize performance.
- Use profiling and benchmarking tools to identify bottlenecks and optimize system resources.
8. Documentation & Reporting:
- Document all database configurations, procedures, backup strategies, and troubleshooting steps.
- Provide regular reports on database health, backups, and performance metrics.
- Prepare and maintain documentation on high availability, disaster recovery, and failover procedures.
- Maintain a knowledge base of common issues and troubleshooting steps for future reference.
9. Collaboration & Support:
- Work closely with development teams to ensure that database architectures meet the needs of application and business processes.
- Provide support for application developers, including advising on best practices for database queries, data access, and performance tuning.
- Assist in database migrations and version upgrades with minimal disruption to business operations.
- Provide after-hours support as needed for critical database issues and system outages.
Required Skills & Qualifications:
Education & Experience:
- Bachelors degree in Computer Science, Information Technology, or a related field (or equivalent experience).
- Minimum of 4 years or more of experience as a Database Administrator or in a similar role.
- Proven experience managing relational databases (e.g., MySQL, PostgreSQL, Oracle, SQL Server) and non-relational databases (e.g., MongoDB, Cassandra).
Technical Skills:
- Strong understanding of Linux/Unix systems and shell scripting.
- In-depth knowledge of database replication strategies and high-availability configurations.
- Experience with backup and recovery strategies and disaster recovery implementation.
- Proficiency in database performance tuning, query optimization, and indexing.
- Solid understanding of database security best practices and user management.
- Familiarity with monitoring tools such as Prometheus, or CloudWatch.
- Knowledge of infrastructure-as-code tools (e.g., Terraform, Ansible) for database automation is a plus.
Soft Skills:
- Strong problem-solving and troubleshooting skills.
- Excellent communication and documentation skills.
- Ability to work independently and collaborate effectively in cross-functional teams.
- Strong attention to detail and a proactive approach to system maintenance.
- Ability to handle multiple tasks and prioritize effectively in a fast-paced environment.
If you're a motivated individual with a keen eye for quality and a desire to drive excellence in every project, we invite you to apply and join our team.
Looking forward to hearing from you.
