PostgreSQL DBA

PostgreSQL DBAPlease share PostgreSQL DBA profiles who have experience in On-Prem and Cloud, Implementation and migrations from On-Prem to Cloud. As a Senior Database Administrator, responsibilities include:• MigrationExperience with On-Prem to Cloud Migrations (Backup/Restore, Export/Import, Load Testing, Bench Marking Old Vs New Environments)Act as the PostgreSQL SME to provide expert level of migration expertiseEnsuring timely completion of migration tasks• Real time monitoringProactively monitor and manage a large database infrastructure across multiple applications• TroubleshootingProvide expert level troubleshooting to quickly identify and resolve database related incidents across a wide array of technologies and platformsResponsible for participating in root cause analysis and problem resolutionMakes technical decisions during high priority incidents focused on impact remediation and communicates clearly to call participants and leadershipPerform updates/changes during maintenance windowsUnderstand current capacity issues and the capacity planning processesWork with team to review change requestsParticipate in software deploymentsAssimilate organizational objectives into operational action plans• Change ManagementSupport a rigorous change control process including creating, reviewing, approving, and implementing change records for database activities• Vendor ManagementEngage, drive, and escalate issues with database vendors related to incident management• Problem ManagementSupport a rigorous problem management process including problem creation and review database activities• Other duties as assignedParticipate in special projects representing database operations on new implementations or troubleshooting deep divesIdentify opportunities for automation of manual tasksYou're the type of person who:Has excellent communication skills and the ability to deal with clients, vendors, engineers, and managers at various levelsHas the ability to communicate technical concepts to non-technical employeesHas the ability to manage and prioritize multiple incidents with potentially competing prioritiesCollaborates well with others to solve problems and actively incorporates input from multiple sourcesHas the ability to work with a global team and apply knowledge to coach and mentor team members as requiredIs self-motivated, detail oriented, organized, thorough, and able to think "outside the box"Has a strong desire to learn and growBasic qualifications for consideration:Bachelor's degree in computer science, business, or information technology or equivalent work experienceAt least 8+ years' experience working as a PostgreSQL Server DBA in an Enterprise environment.Experience with backup processes & proceduresExcellent communication (spoken and written) skillsThe ability to document standard operational proceduresKnowledge and experience with capacity planning as it pertains to databasesAbility to work Autonomously and as part of a teamOther Database Platform (Oracle, SQL, DB2, etc.) skills are plus.Preferred Skills, Experience, and Education:Experience with Cloud Technology concepts, topologies, and service models (PaaS/SaaS/IaaS, Azure, AWS) is a plusHands-on experience working with various recent versions of PostgreSQL. Experience with MS SQL and/or DB2 SQL is a big plusKnowledge and experience with database management and other monitoring tools (Foglight, Splunk, Extrahop, Dynatrace, etc.)Hands-on experience working with Server partition design and implement.Knowledge and experience on database HA/ DR design and implementation, always-on grouping, replication, mirroring, and log shipping.Knowledge and experience on design and support large database migration strategy.Hands-on experience working with in-place database upgrade experiences on VM and physical servers.Knowledge and experience on database service broker (or similar) troubleshooting is a plusPostgreSQL Certifications are preferred, MCSE/DB2 Certifications are a plusTravel required: Less than 5% travel