Azure Database Administrator L2

Job Title: Database Administrator (Multi-DB Environment)

Overview:

As a Database Administrator (DBA) specializing in Multi-Database Management, you will be a key member of our team responsible for overseeing the design, implementation, and maintenance of various database systems. Leveraging your expertise in managing a diverse range of database technologies, you will ensure the database infrastructure's optimal performance, reliability, and security. Your role will involve collaborating with cross-functional teams to support the organization's database management needs and drive strategic initiatives.

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.

This job description is intended to convey information essential to understanding the scope of the position. It is not an exhaustive list of skills, efforts, duties, responsibilities, or working conditions associated with it. Management may modify or change the duties and responsibilities as required.