Junior Database Administrator

Job Summary:

The Database Administrator will take ownership of the databases across our clients' (Azure SQL Server) the optimal performance of all database tables, stored procedures, and views. This role involves identifying issues and making recommendations for infrastructure changes as needed.

Key Responsibilities:

1. Database Design and Management:

• Design, create, and maintain databases to meet the organizations requirements.
• Ensure data integrity and efficient data structures.
  
  
  

2. Setup and Maintain Data Factory for Power BI Reporting:

• Establish and manage data factory pipelines to support Power BI reporting needs.
  
  
  

3. Database Performance Tuning and Optimization:

• Monitor and enhance database performance through query optimization and indexing.
• Implement best practices for optimizing database performance.
  
  
  

4. Data Backup and Recovery:

• Set up and manage backup and recovery processes to safeguard data integrity.
  
  
  

5. Security and Access Control:

• Enforce security protocols to protect sensitive data.
• Manage user access permissions and roles.
  
  
  

6. Database Software Installation and Configuration:

• Install, configure, and upgrade database software as required.
  
  
  

7. Monitoring and Troubleshooting Database Issues:

• Proactively monitor database systems for issues and troubleshoot as needed.
• Implement solutions to prevent recurrence of problems.
  
  
  

8. Collaborating with Developers and BI Developers:

• Work closely with application developers and business intelligence developers to ensure seamless integration with the database systems.
  
  
  

9. Database Documentation:

• Maintain comprehensive documentation of database schemas, configurations, and processes.
  
  
  

Qualifications and Skills:

• Bachelors degree in computer science or a related field. (advantageous)
• Minimum of 1 years of experience as a Database Administrator.
• Relevant certifications, such as Microsoft Certified: Azure Database Administrator. (advantageous)
• In-depth knowledge of specific database management systems, particularly SQL Server.
• Proficiency in SQL and expertise in database query optimization.
• Familiarity with best practices for database security.
• Strong problem-solving and troubleshooting skills.
• Effective communication and teamwork abilities.