PostgreSQL DBA - eTeam Inc.
Alpharetta, GA
About the Job
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
o Experience with On-Prem to Cloud Migrations (Backup/Restore, Export/Import, Load Testing, Bench Marking Old Vs New Environments)
o Act as the PostgreSQL SME to provide expert level of migration expertise
o Ensuring timely completion of migration tasks
" Real time monitoring
o Proactively monitor and manage a large database infrastructure across multiple applications
" Troubleshooting
o Provide expert level troubleshooting to quickly identify and resolve database related incidents across a wide array of technologies and platforms
o Responsible for participating in root cause analysis and problem resolution
o Makes technical decisions during high priority incidents focused on impact remediation and communicates clearly to call participants and leadership
o Perform updates/changes during maintenance windows
o Understand current capacity issues and the capacity planning processes
o Work with team to review change requests
o Participate in software deployments
o Assimilate organizational objectives into operational action plans
" Change Management
o Support a rigorous change control process including creating, reviewing, approving, and implementing change records for database activities
" Vendor Management
o Engage, drive, and escalate issues with database vendors related to incident management
" Problem Management
o Support a rigorous problem management process including problem creation and review database activities
" Other duties as assigned
o Participate in special projects representing database operations on new implementations or troubleshooting deep dives
o 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
o 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, ClientSE/DB2 Certifications are a plus
" Travel required: Less than 5% travel
As a Senior Database Administrator, responsibilities include:
" Migration
o Experience with On-Prem to Cloud Migrations (Backup/Restore, Export/Import, Load Testing, Bench Marking Old Vs New Environments)
o Act as the PostgreSQL SME to provide expert level of migration expertise
o Ensuring timely completion of migration tasks
" Real time monitoring
o Proactively monitor and manage a large database infrastructure across multiple applications
" Troubleshooting
o Provide expert level troubleshooting to quickly identify and resolve database related incidents across a wide array of technologies and platforms
o Responsible for participating in root cause analysis and problem resolution
o Makes technical decisions during high priority incidents focused on impact remediation and communicates clearly to call participants and leadership
o Perform updates/changes during maintenance windows
o Understand current capacity issues and the capacity planning processes
o Work with team to review change requests
o Participate in software deployments
o Assimilate organizational objectives into operational action plans
" Change Management
o Support a rigorous change control process including creating, reviewing, approving, and implementing change records for database activities
" Vendor Management
o Engage, drive, and escalate issues with database vendors related to incident management
" Problem Management
o Support a rigorous problem management process including problem creation and review database activities
" Other duties as assigned
o Participate in special projects representing database operations on new implementations or troubleshooting deep dives
o 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
o 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, ClientSE/DB2 Certifications are a plus
" Travel required: Less than 5% travel
Source : eTeam Inc.