• 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 • 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 • Perform database deployments • 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 for both transactional and analytical use cases • Provide support for troubleshooting and resolving database-related issues reported by application teams • Configure and manage Azure Databases, including automated backups, replication, and high-availability options • Implement and manage database security including encryption, access controls, and auditing to meet industry standards and regulatory requirements • Ensure disaster recovery strategies are in place, including point-in-time restore and geo-replication for Azure SQL Database • Provide off-hours support when required • Provide on-site disaster recovery assistance when required • Perform all other duties and special projects as assigned