Job title
sr postgres dba
employment type
full-time
work authorization requirements
authorized to work in mexico without sponsorship
language requirements
fluent english
about prgx
prgx is the global leader in source-to-pay data analytics and software, and tech-enabled profit recovery services. We provide software and services to maximize revenue recovery and drive margin improvement for our clients. For more information about prgx, visit
job duties & responsibilities
* install, configure, monitor, maintain, and troubleshoot postgresql databases across various environments (development, testing, production). This includes managing replication (streaming, logical), backups, and recovery procedures.
* analyze and optimize database performance, including query optimization, indexing strategies, and server configuration tuning to ensure high throughput and low latency.
* design, implement, and maintain high availability (ha) and disaster recovery (dr) solutions to ensure continuous database operation and data integrity.
* implement and enforce database security policies, manage user permissions, and ensure compliance with relevant data security standards.
* work closely with development, devops, and other engineering teams to design, implement, and optimize database solutions for applications. Provide support and guidance on database-related issues.
* develop and utilize scripts (e.g., bash, python) to automate routine database tasks, improve efficiency, and streamline operations.
* implement and manage database monitoring tools to proactively identify and resolve performance or availability issues.
* create and maintain comprehensive documentation for database environments, standards, and procedures.
* plan for future storage requirements and database growth, and design scalable database architectures.
knowledge & qualifications
* extensive experience as a dba, with a 6+ years focus on postgresql.
* deep understanding of postgresql architecture, features, and best practices.
* proficiency in sql and experience with complex query optimization.
* experience with database monitoring tools and performance analysis.
* knowledge of high availability and disaster recovery techniques.
* scripting skills (e.g., bash, python, ansible, awx) for automation.
* strong analytical and problem-solving abilities.
* excellent communication and collaboration skills.
* experience with mssql is required.
* experience with mongodb or other document databases is beneficial.
our commitment to equal opportunity
prgx is an equal opportunity employer.we comply with all applicable local, national, and international laws regarding non-discrimination and equal employment. We do not discriminate based on any legally protected characteristic and are committed to fostering an inclusive, respectful, and equitable workplace. Reasonable accommodations are available for qualified individuals in accordance with local laws and best practices.
physical requirements
ability to sit or stand for extended periods of time, manual dexterity for typing, writing, or using office equipment, visual acuity for reading screens and documents, ability to lift or carry light items such as laptops, and speech and hearing ability for calls, virtual meetings, and in-person communication
data privacy
your personal data will be handled in accordance with applicable data protection laws. We only collect information necessary for recruitment and will not share your data without your consent.
#j-18808-ljbffr