EDUCATION AND/OR TRAINING:

• Bachelor’s degree in a related field or equivalent work experience
• Additional education, certifications, or other distinctions are a plus
• Proficient in various desktop tools including MS Office Programs (i.e. Outlook, Excel, Word, PowerPoint, Project, Visio, SharePoint etc.)
• 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

RELEVANT WORK EXPERIENCE:

• Minimum 5 years tenure as a Database Administrator Experienced with relational architecture and Data Warehouse
• 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)
  

  LI-BS1

• Technical Leadership:
• Provide technical guidance and mentorship to the database development team.
• Design, develop, and optimize database systems to meet business requirements.
• Recommends improvements to the database architecture and design to enhance scalability, availability, and security.
• Collaborates with the DevOps team to automate database deployments and integrate with CI/CD pipelines
• Documentation:
• Create and maintain comprehensive documentation for database systems and processes.
• Innovation:
• Stay updated with the latest database technologies and best practices, and implement improvements as needed.
• Database development support: Focus on providing database development support which includes;
• 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
• Perform database deployments
• Optimize database queries and stored procedures for maximum efficiency and performance
• Develops complex SQL queries, stored procedures, functions, triggers, and views to support business logic and application functionality
• Performs data modeling, including designing schemas, tables, indexes, and relationships, for both transactional and analytical use cases
• Provides support for troubleshooting and resolving database-related issues reported by application teams
• Works closely with application developers to integrate database systems with applications and ensure efficient data flow
• Azure Cloud Database Management:
• Configures and manages Azure Databases, including automated backups, replication, and high-availability options
• Implements and manages database security, including encryption, access controls, and auditing, to meet industry standards and regulatory requirements.
• Ensures disaster recovery strategies are in place, including point-in-time restore and geo-replication for Azure SQL Database
• Stays current with Azure database services and industry trends, incorporating new features and best practices as appropriate
• General Database support:
• Provides off-hours support when required
• Provides on-site disaster recovery assistance when required
• Perform all other duties and special projects as assigned