Role: PostgreSQL Database Admin
Experience: 8 years to 12 years
Location: PAN India
Job Description:
- 12 years of IT experience and minimum of 5 years of experience on PostgreSQL database administration Should have worked with the team size of above 10 members technically guided the team Willing to provide 24x7 support flexible to work in the shifts
KEY RESPONSIBILITIES
- PostgreSQL
- Planning for Production Storage and Capacity Management
- Create logical models and build physical models.
- Planning for Production Storage and Capacity Management
- Creation managing migrating PostgreSQL schema tables tablespaces and users roles group in 10x 11x12x13x 14x 15x to Azure Cloud including PaaS Azure database for PostgreSQL single flexible servers
- Performance tuning Query tuning by generating and explaining plan for SQL queries
- Expert in DBA functions like managing databases backup restore scheduling jobs space performance management principles of database replication scalability and high availability
- Expert in Backup Recovery including Pgdump pgdumpall setting up WAL archiving Point in time recovery
- Analyze recommend and implement configuration for Optimized Performance
- Ability to plan hardware capacity requirements for storage memory and CPU Cycles
- Ability to configure and troubleshoot log shipping cascading standbys partial replication continuous recovery detach and reattach slaves
- Understanding of UNIX environment with shell scripting
- Trouble shooting and resolving database issues
- This role may entail shift afterhours support on an oncall basis
- HADR Setup including logical physical standby
- Conforming to client compliances and expectations
- This role may entail shift afterhours support on an oncall basis
- Mandatory Technical skills required.
- Migrating onpremise PostgreSQL to Azure Cloud
- Migrating Azure database for PostgreSQL Single server to Migrating Azure database for PostgreSQL Flexible server
- Security setup Enabling Configuring SSL Certificate Authentication to encrypt data transfer