Job title: Database
Admin
Experience:
5-8 Years
Notice
period: Immediate to 15 days
Location: Bangalore
JD:
Responsibilities:
· Database Architecture and Design:
· Lead the design and implementation
of database architectures for relational (e.g., Microsoft SQL Server, Oracle,
MySQL, PostgreSQL) and NoSQL (e.g., MongoDB, Azure Cosmos DB) databases,
ensuring scalability, reliability, and performance.
· Database Deployment and
Configuration:
· Deploy and configure database
instances across different environments, including on-premises and cloud-based
platforms (e.g., Azure, AWS), while adhering to best practices and security
standards.
· Performance Optimization:
· Monitor database performance and
resource utilization, identifying and resolving bottlenecks through
optimization techniques such as indexing, query tuning, and database parameter
tuning.
· High Availability and Disaster
Recovery:
· Implement and maintain high
availability solutions, including clustering, replication, and failover
mechanisms, to ensure continuous availability of critical databases. Develop
and test disaster recovery strategies to minimize downtime and data loss.
· Security and Compliance:
· Establish and enforce database
security policies and access controls to safeguard sensitive data. Ensure
compliance with regulatory requirements and industry standards (e.g., GDPR,
SOC) by implementing appropriate security measures and auditing practices.
· Backup and Recovery:
· Design and maintain backup and
recovery solutions to protect against data loss and facilitate rapid recovery
during system failures or disasters. Regularly test backup procedures to verify
integrity and reliability.
· Database Monitoring and Alerting:
· Implement comprehensive monitoring
and alerting solutions to proactively identify issues and ensure the health and
performance of database systems. Utilize monitoring tools and dashboards to
track key metrics and trends.
· Automation and Scripting:
· Develop and maintain automation
scripts and workflows to streamline routine database administration tasks, such
as provisioning, patching, and configuration management. Leverage scripting
languages (e.g., PowerShell, Python) and automation tools to improve efficiency
and consistency
· Capacity Planning and Scaling:
· Conduct capacity planning exercises
to forecast future resource requirements and scale database infrastructure
accordingly. Collaborate with infrastructure teams to allocate resources
effectively and optimize cost.
· Documentation and Knowledge Sharing:
· Create and maintain documentation
for database configurations, procedures, and troubleshooting guides. Share
knowledge and best practices with team members through training sessions and
documentation repositories.
· Incident Response and Problem
Resolution:
· Respond to database-related
incidents and service interruptions in a timely manner, following established
incident management processes. Conduct root cause analysis and implement corrective
actions to prevent recurrence.
Qualifications:
· Bachelor's degree in Computer
Science, Information Technology, or related field.
· 5-8 years of experience as a
Database Administrator, focusing on managing multiple database platforms.
· Proficiency in designing, deploying,
and maintaining relational and NoSQL databases.
· Hands-on experience with database
administration tasks, including installation, configuration, backup and
recovery, performance tuning, and security management.
· Strong understanding of database
architecture, data modeling, and SQL query optimization techniques.
· Experience working with cloud-based
database services (e.g., Azure SQL Database, Amazon RDS) and familiarity with
Infrastructure as Code (IaC) principles are desirable.
· Excellent problem-solving skills and
attention to detail.
· Effective communication and
collaboration abilities, with the capacity to work in a cross-functional team
environment.
· Relevant certifications (e.g., MCDBA
or Microsoft Azure Database Administrator Associate) is a plus.