Postgresql DBA minimum 5yrs experience, immediate joiners preferred

0 years

0 Lacs

Posted:2 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

This job is with Allianz Commercial, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.

Primary Skill set : Azure PostgreSQL Database Administrator
    • Managing and administrating Azure PostgreSQL (Flex Server in Azure)
    • Maintain the Data security in Azure
    • Implement Backup and DR strategy with automation
    • Automate the DB deployment and closely work with L3 Team
    • Team player - Help the other team members to grow
    • SQL Performance tuning and PostgreSQL Server Tuning
    • Strong knowledge about indexing and rebuild index
    • Implement the monitoring for PostgreSQL using Azure metrics and Azure functions
    • Strong understanding about Azure geo-redundant backups and its implementation
    • Backup and recovery of PostgreSQL DB
    • Strong understanding about Roles and Privilege assignments
    • Terraform and Ansible knowledge along with AzureCLI
    • Vacuum - DB Stats gather
100%

Duties And Responsibilities

Technical ScopeCreating/Managing Table Partitions, DB Reorganization, Rebuild, Truncate, Purge and Gather Stats.Controlled and monitored user access to the database including granting and revoking privileges and roles, allocation of resource limits and table space Management.Using Oracle Enterprise Manager for monitoring and maintaining Clusters, RAC databases and other Targets. Monitoring Oracle Database Server to ensure proper database Availability, Performance and Capacity and Oracle server load, User sessions and long running operations on the Server. Alert Handling and Monitoring tasks. Managing Database Connectivity, networking and Storage Monitoring and resolving Lock Conflicts in oracle database. Basic day-to-day Admin commands Linux/Unix Monitoring Systems Performance (CPU, Memory, I/O). Basic Shell scripting & automating the routine tasks through shell scripts. Tune database queries Monitor application related jobs and data replication activities.Secondary Skill set: Azure Cloud, Oracle Databas

Having a basic understanding or exposure to AI tools would be a plus.

Familiarity with basic AI tools is considered an advantage.

Basic knowledge or experience with AI tools will be beneficial.

Exposure to AI tools, even at a basic level, is a value-add.

A fundamental grasp of AI tools will be an added benefit.

100%Allianz Group is one of the most trusted insurance and asset management companies in the world. Caring for our employees, their ambitions, dreams and challenges, is what makes us a unique employer. Together we can build an environment where everyone feels empowered and has the confidence to explore, to grow and to shape a better future for our customers and the world around us.We at Allianz believe in a diverse and inclusive workforce and are proud to be an equal opportunity employer. We encourage you to bring your whole self to work, no matter where you are from, what you look like, who you love or what you believe in.We therefore welcome applications regardless of ethnicity or cultural background, age, gender, nationality, religion, disability or sexual orientation.Join us. Let's care for tomorrow.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You