Provide technical guidance and mentorship to the database development team
Design, develop, and optimize database systems to meet business requirements
Recommend improvements to the database architecture and design to enhance scalability, availability, and security
Collaborate with the DevOps team to automate database deployments and integrate with CI/CD pipelines
Create and maintain comprehensive documentation for database systems and processes
Stay updated with the latest database technologies and best practices, and implement improvements as needed
Monitor and optimize database performance, ensuring high availability and reliability
Work closely with software developers, business analysts, and other stakeholders to integrate database solutions with applications
Perform code reviews to support Database development
Optimize database queries and stored procedures for maximum efficiency and performance
Develop complex SQL queries, stored procedures, functions, triggers, and views to support business logic and application functionality
Perform data modeling, including designing schemas, tables, indexes, and relationships, for both transactional and analytical use cases
Troubleshoot and resolve database-related issues reported by application teams
Provide off-hours support when required
Provide on-site disaster recovery assistance when required
Perform all other duties and special projects as assigned
Requirements
Bachelor’s degree in a related field or equivalent work experience
Azure AZ900, DP900, DP-300 training required
Azure certifications such as Microsoft Certified: Azure Database Administrator Associate or Azure Solutions Architect Expert are highly preferred
Minimum 5 years tenure as a Database Administrator
Minimum 3 years' experience with installing, configuring, and supporting Oracle and/or SQL server database environments
Experience with Azure SQL database environments
Understanding of Azure ecosystem and database services like Azure Blob Storage, Azure Data Lake, Azure Key Vault, etc.
Must be well versed with database procedures to include: installation, configuration, backup and recovery, performance tuning, and SQL statement tuning
Experience using ETL tools to document and move data as needed
Experienced with Linux operating system and shell scripting
Experienced with Windows Server operating systems
Experienced with scripting languages and automation tools a plus (AI tools, Infrastructure as Code (IaC), Azure DevOps, PowerShell, and ARM templates)