PostgreSQL DBA - Alpharetta, United States - TechDigital Corporation

Description

• 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

• Proactively monitor and manage a large database infrastructure across multiple applications

• 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

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

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

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

• Participate in special projects representing database operations on new implementations or troubleshooting deep dives
• Identify opportunities for automation of manual tasks

• 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

• 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.

• 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