Kerja Sepenuh Masa, Database Administrator (Dba) di Aventra Group Federal Territory - Maukerja

About Aventra Group

Aventra Group is a technology-driven organization delivering innovative digital and enterprise solutions to global clients. We focus on building scalable, secure, and high-performance systems that enable business growth and transformation.

Role Overview

We are looking for a skilled and detail-oriented Database Administrator (DBA) with strong primary experience in Microsoft Azure SQL and secondary exposure to Oracle Database, Azure Cosmos DB, PostgreSQL, and MongoDB to manage, maintain, optimize, and secure cloud-native, hybrid, and enterprise database environments. The DBA will ensure high performance, security, availability, and scalability of critical data systems while supporting business applications, development teams, and cloud transformation initiatives.

Key Responsibilities

Administer, configure, and maintain Microsoft Azure SQL Database, Azure SQL Managed Instance, and SQL Server environments across cloud, on-premises, and hybrid deployments

Plan and implement Azure SQL database resources, including sizing, provisioning, scaling, monitoring, and cost-aware configuration

Monitor database performance and optimize queries, indexing, execution plans, storage, and resource utilization

Ensure database availability, reliability, and security across development, test, staging, and production environments

Implement backup, restore, high availability, disaster recovery, geo-replication, and failover strategies for Azure SQL and SQL Server platforms

Manage database upgrades, patching, migrations, and modernization initiatives from on-premises SQL Server, Oracle Database, PostgreSQL, MongoDB, or other RDBMS/NoSQL platforms to Azure SQL or cloud-native database services

Provide secondary administration and operational support for Oracle Database, Azure Cosmos DB, PostgreSQL, and MongoDB environments, including monitoring, basic troubleshooting, access management, and coordination with application teams

Troubleshoot performance issues, outages, blocking, deadlocks, capacity constraints, and data inconsistencies

Implement and maintain data integrity, role-based access controls, encryption, auditing, compliance, and secure database administration practices

Collaborate with development, cloud, DevOps, and application teams to design efficient, scalable, and secure database structures

Automate routine database maintenance, monitoring, alerting, and operational tasks using T-SQL, PowerShell, Azure Automation, or related tooling

Document database environments, operational processes, architecture decisions, runbooks, and best practices

Requirements

Required Qualifications

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field

4+ years of experience as a Database Administrator, Database Engineer, or similar role

Primary hands-on experience administering Microsoft Azure SQL Database, Azure SQL Managed Instance, and/or SQL Server on Azure Virtual Machines

Strong experience with SQL Server administration, T-SQL, stored procedures, indexing, performance tuning, query optimization, and database design

Experience in database backup, restore, high availability, disaster recovery, replication, failover, and business continuity planning

Practical understanding of Azure database monitoring, security, access management, encryption, auditing, and compliance practices

Secondary experience or working knowledge of Oracle Database, Azure Cosmos DB, PostgreSQL, and MongoDB administration will be advantageous

Ability to support database migration, modernization, and cloud adoption initiatives involving Azure SQL services

Strong analytical, troubleshooting, documentation, and stakeholder communication skills

Preferred Qualifications

Microsoft Certified: Azure Database Administrator Associate or relevant Microsoft Azure SQL certification will be an added advantage

Microsoft Azure Fundamentals, Azure Data Fundamentals, or related Microsoft certification preferred

Relevant secondary certifications or training in Oracle Database, PostgreSQL, MongoDB, or Azure Cosmos DB will be an added advantage

Experience with Azure Monitor, Log Analytics, Query Performance Insight, SQL Insights, Azure Defender for SQL, and database alerting frameworks

Experience with cloud database platforms beyond Azure, such as AWS RDS or Google Cloud SQL, will be advantageous

Familiarity with DevOps tools, CI/CD pipelines, Infrastructure as Code, and database deployment automation

Knowledge of scripting languages such as PowerShell, Python, or Shell scripting

Experience in large-scale enterprise, regulated, or mission-critical database environments

Key Skills

Microsoft Azure SQL Administration

SQL Server Administration

T-SQL, Query Optimization & Performance Tuning

Azure SQL Database & Azure SQL Managed Instance

Secondary Database Platforms: Oracle Database, Azure Cosmos DB, PostgreSQL & MongoDB

Backup, Recovery, High Availability & Disaster Recovery

Database Security, Access Control & Compliance

Cloud Migration & Database Modernization

Automation, Monitoring & Scripting

Troubleshooting & Problem-Solving

Collaboration & Communication

Skills

No specific skills listed.

Benefits

No benefits information provided.