Database Administrator at BURN

About the role

Burn is looking for a Database Administrator who will play a critical role in managing and maintaining an organization's database systems. Their primary responsibility will be to ensure that the databases are secure, efficient, and available to support the BURN's data needs.

Duties and Responsibilities:

Database Design and Implementation:

• Design and create database structures based on organizational needs.
• Install and configure database management systems (DBMS) such as MySQL, Postgrel, SQL Server, or others.

Database Maintenance:

• Perform regular backups and recovery operations to ensure data availability and integrity.
• Monitor database performance, and identify, and resolve performance bottlenecks.
• Apply software patches and updates to keep databases secure and up to date.

Security and Access Control:

• Implement and maintain database security measures to protect sensitive data.
• Define and enforce access control policies, including user roles and permissions.

Data Migration and Integration:

• Plan and execute data migration projects between databases or systems.
• Develop and maintain data integration processes for seamless data flow.

Performance Optimization:

• Optimize database queries and indexes to improve overall system performance.
• Identify and address performance-related issues promptly.

High Availability and Disaster Recovery Planning:

• Develop and maintain disaster recovery plans and procedures to minimize and prevent data loss in case of system failures.
• Configure and maintain high availability solutions to ensure uninterrupted database access, even during hardware failures.

Scaling and Capacity Planning:

• Plan for database scalability, both vertically and horizontally, to accommodate growing workloads efficiently.

Monitoring and Alerts:

• Set up database monitoring solutions to track performance and health.
• Create alerts for critical events and performance thresholds.

Documentation:

• Maintain comprehensive documentation of database configurations, procedures, and policies.

Collaboration:

• Collaborate with application developers, system administrators, and other IT teams to ensure database-related requirements are met.

Training and Support:

• Provide training and support to end-users and other team members on database-related issues and best practices.

Any other duties assigned by the manager:

Skills and Experience:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• Proven experience as a Database Administrator or in a similar role.
• Proficiency in managing and administrating various database systems, including relational databases (e.g., MySQL, PostgreSQL, SQL Server) and NoSQL databases (e.g., Amazon DynamoDB).
• Experience with scripting and automation tools (e.g., Python, AWS CLI) is a plus.
• Experience in AWS Database services (e.g., RDS, Aurora, Amazon DynamoDB, Redshift, Database Migration Service, RDS Proxy) is desired.
• Proficiency in Azure services, including Azure SQL Database, Azure Cosmos DB, and related Azure tools is an added advantage.
• Familiarity with database design principles and data modeling.
• Experience with database security and access control.
• Knowledge of backup and recovery processes.
• Strong problem-solving skills and the ability to troubleshoot complex database issues.
• Strong communication and interpersonal skills.
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator, AWS Certified Database – Specialty, MySQL Database Administrator, PostgreSQL Certified Professional).