Postgresql DBA

Job Description

13 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 shiftsPrimary skillsKEY RESPONSIBILITIESPostgreSQLPlanning for Production Storage and Capacity ManagementCreate logical models and build physical modelsPlanning for Production Storage and Capacity ManagementCreation 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 serversPerformance tuning Query tuning by generating and explaining plan for SQL queriesExpert in DBA functions like managing databases backup restore scheduling jobs space performance management principles of database replication scalability and high availabilityExpert in Backup Recovery including Pgdump pgdumpall setting up WAL archiving Point in time recoveryAnalyze recommend and implement configuration for Optimized PerformanceAbility to plan hardware capacity requirements for storage memory and CPU CyclesAbility to configure and troubleshoot log shipping cascading standbys partial replication continuous recovery detach and reattach slavesUnderstanding of UNIX environment with shell scriptingTrouble shooting and resolving database issuesThis role may entail shift afterhours support on an oncall basisHADR Setup including logical physical standbyConforming to client compliances and expectationsThis role may entail shift afterhours support on an oncall basisGood working experience all HA and DR solutionsMandatory Technical skills requiredMigrating onpremise PostgreSQL to Azure CloudMigrating Azure database for PostgreSQL Single server to Migrating Azure database for PostgreSQL Flexible serverSecurity setup Enabling Configuring SSL Certificate Authentication to encrypt data transfer

Keyskills :
flexibleazureserver