About the role
Developing a cloud-based solution tailored for the energy and utility market.
Our expectations
- 3+ years of experience in administering PostgreSQL and Microsoft SQL Server relational databases
- Familiar with Microsoft Azure and its database services, such as: Azure SQL Database, Azure Database for PostgreSQL (Flexible Server), Azure Monitor, Log Analytics, Azure Backup
- Experience with optimizing JSON and JSONB data types usage
- Experience with database migrations (both logical and physical), using e.g. pg_dump, bacpac, and SqlPackage
- Proficient in SQL, T-SQL, and pgSQL
- Knows how to use administrative tools like SQL Server Management Studio (SSMS), and pgAdmin
- Understands best practices in data security, auditing, and access management (including Azure RBAC, Managed Identities)
Nice to have
- Experience with on-premise SQL databases
- Certification: DP-300 – Administering Relational Databases on Microsoft Azure
- Certifications: AZ-104
Main responsibilities
- Administer and maintain database environments including Azure Database for PostgreSQL (Flexible Server / Hyperscale) and Azure SQL Database
- Monitor database performance and troubleshoot issues, including performance tuning, and index management
- Create, test, and manage backups and Disaster Recovery procedures (e.g., Point-in-time Restore, Geo-Redundancy)
- Participate in data migration projects, including compatibility analysis, planning, execution, and testing
- Automate administrative tasks using scripting and tools such as Azure DevOps pipelines, Python, and Azure CLI
- Collaborate with Platform and ETL teams to deliver best possible performance of daily operations
- Implement and oversee security and compliance policies (e.g., RBAC, auditing, encryption at rest and in transit)
