Database Developer Tech Lead

Job Responsibilities:

• 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

Education and/or Training:

• Bachelors 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

#LI-REMOTE