Azure PostgreSQL Database Administrator

Role & responsibilities

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

Duties and Responsibilities

Configuring and using Flashback Features for an Oracle database.

Creating/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.

Thanks & Regards

Sushma Patil

HR Cordinator

92700 05035

sushma.patil@in.experis.com