PostgreSQL DBA

1 month ago


Alpharetta, United States Omni Inclusive Full time
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


  • Alpharetta, United States Resource Informatics Group Full time

    Job Title: Senior PostgreSQL Database SpecialistJob Summary:As a Senior PostgreSQL Database Specialist at Resource Informatics Group, you will be responsible for designing, developing, and maintaining large-scale PostgreSQL databases. Our ideal candidate has extensive experience in PostgreSQL database administration, development, and optimization.About the...

  • Lead Postgres Dev/DBA

    1 month ago


    Alpharetta, United States Resource Informatics Group Full time

    Lead Postgres DB Developer/DBA Location: Alpharetta, GA (Onsite) Rate: OpenTop Skills: PostgreSQL, Development, DBA, Modelling, Upgrades, Migration, WAL files, Quesry optimization 8-10 years' experience on Postgres Development and Administration. Expert in writing Joins with multiple tables, Indexing, Query's fine tune & Rewrite Query/Joins etc. Expertise in...


  • Alpharetta, United States Vuesol Full time

    Database Administrator (DBA) with YugabyteDB Experience Remote Job Description: We are seeking an experienced Database Administrator (DBA) with expertise in managing, maintaining, and optimizing databases, particularly YugabyteDB. The ideal candidate will be responsible for ensuring high availability, performance, security, and reliability of database...


  • Alpharetta, United States Vuesol Full time

    Database Administrator (DBA) with YugabyteDB Experience RemoteJob Description: We are seeking an experienced Database Administrator (DBA) with expertise in managing, maintaining, and optimizing databases, particularly YugabyteDB. The ideal candidate will be responsible for ensuring high availability, performance, security, and reliability of database...

  • Lead DBA

    3 days ago


    Alpharetta, United States iSoftTek Solutions Inc Full time

    Job DescriptionJob DescriptionJob Title: Lead DBA - PostgresLocation: Alpharetta, GA (100% Onsite - 5 days a week from day 1) Duration: Long TermJob Type: W2Job Description:· 10+ years' experience on Postgres Development and Administration.· Expert in writing Joins with multiple tables, Indexing, Query's fine tune & Rewrite Query/Joins etc.·...


  • Alpharetta, United States Omni Inclusive Full time

    About Omni InclusiveWe are a global organization dedicated to providing innovative solutions in database management and IT services. Our team of experts works tirelessly to deliver exceptional results for our clients, and we are committed to creating a workplace that values diversity, equity, and inclusion. The estimated salary for this role is $150,000 -...