Azure Database Administrator

Location: Warsaw (Inflancka 4A) or Remote Work (Poland)

B2B Contract, Targeted Salary: 170 PLN Net/Hour 

#PostgreSQL #MicrosoftSQL #AzureDatabase #SQL #T-SQL #SSMS #AzureRBAC #pgAdmin

Are you ready to join our international team as a Azure Database Administrator? We shall tell you why you should...

What products do we develop?

KMD Elements is a cloud-based solution tailored for the energy and utility market. It offers a highly efficient way to handle complex data validation and advanced formula-based settlements on time series. Designed for the international market, KMD Elements automates intricate calculation and billing processes. Key features include an advanced configuration engine, robust automation capabilities, multiple integration options, and a customer-centric interface. More info can be found here

How do we work?

#Agile #Scrum #Teamwork #CleanCode #CodeReview #E2Eresponsibility #ConstantImprovement

Your 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).  

   

Ideal candidate:  

• Has 3+ years of experience in administering PostgreSQL and Microsoft SQL Server relational databases.  

• Is 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.

• Has experience with optimizing JSON and JSONB data types usage.

• Has experience with database migrations (both logical and physical), using e.g. pg_dump, bacpac, and SqlPackage.

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