PostgreSQL DBA

Please 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:

• Migration

Experience 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 expertise

Ensuring timely completion of migration tasks

• Real time monitoring

Proactively monitor and manage a large database infrastructure across multiple applications

• Troubleshooting

Provide expert level troubleshooting to quickly identify and resolve database related incidents across a wide array of technologies and platforms

Responsible for participating in root cause analysis and problem resolution

Makes technical decisions during high priority incidents focused on impact remediation and communicates clearly to call participants and leadership

Perform updates/changes during maintenance windows

Understand current capacity issues and the capacity planning processes

Work with team to review change requests

Participate in software deployments

Assimilate organizational objectives into operational action plans

• Change Management

Support a rigorous change control process including creating, reviewing, approving, and implementing change records for database activities

• Vendor Management

Engage, drive, and escalate issues with database vendors related to incident management

• Problem Management

Support a rigorous problem management process including problem creation and review database activities

• Other duties as assigned

Participate in special projects representing database operations on new implementations or troubleshooting deep dives

Identify opportunities for automation of manual tasks

You're the type of person who:

Has excellent communication skills and the ability to deal with clients, vendors, engineers, and managers at various levels

Has the ability to communicate technical concepts to non-technical employees

Has the ability to manage and prioritize multiple incidents with potentially competing priorities

Collaborates well with others to solve problems and actively incorporates input from multiple sources

Has the ability to work with a global team and apply knowledge to coach and mentor team members as required

Is self-motivated, detail oriented, organized, thorough, and able to think "outside the box”

Has a strong desire to learn and grow

Basic qualifications for consideration:

Bachelor's degree in computer science, business, or information technology or equivalent work experience

At least 8+ years' experience working as a PostgreSQL Server DBA in an Enterprise environment.

Experience with backup processes & procedures

Excellent communication (spoken and written) skills

The ability to document standard operational procedures

Knowledge and experience with capacity planning as it pertains to databases

Ability to work Autonomously and as part of a team

Other 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 plus

Hands-on experience working with various recent versions of PostgreSQL. Experience with MS SQL and/or DB2 SQL is a big plus

Knowledge 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 plus

PostgreSQL Certifications are preferred, MCSE/DB2 Certifications are a plus

Travel required: Less than 5% travel