• 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 • 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, 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 • Work closely with application developers to integrate database systems with applications and ensure efficient data flow • 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

• Creates database system designs and architectures in line with the organization's technical needs • Designs, implements, and ensures that database systems achieve 100% uptime with 24/7/365 operational availability • Develops proposed systems which meet the required database and interface specifications, based upon identified business needs • Troubleshoots and resolves critical problems across various tiers in the database systems • Communicates software development initiatives and plans related database changes including database upgrades and data migrations • Researches and provides both business and technical solutions based on business needs and specifications

• Development, maintenance and further development of database-driven reporting solutions • Implementation of advanced programming logic at the database level (T-SQL) • Creation of complex SQL queries as well as stored procedures and views • Development and optimization of reports with DevExpress (Web) • Analysis and sustainable resolution of backend and reporting issues • Further development of backend components based on .NET (C#, VB.NET) • Close collaboration with internal business units to implement reporting requirements • Direct communication with clients and support for customer-specific reporting solutions

• Development of web applications using Python technologies • Collaboration within agile development teams • Application of best practices in DevOps and DevSecOps • Configuration and use of GeoNode platforms and version control tools