PRGX
Senior Database Administrator (Trino & Postgres)
PRGX, Atlanta, Georgia, United States, 30383
About PRGX Global, Inc
ABOUT PRGX
We provide the business intelligence to unlock incremental value from data and expand impact across our clients' organizations for healthier whole businesses. PRGX pioneered Recovery Audit nearly 50 years ago and is now the global leader in source-to-pay analytics and margin expansion. PRGX empowers clients in more than 30 countries with the business intelligence to recover $1.2 billion in annual cash flow, unlocking value and improving the overall health of organizations across the world. We collaborate with supplier communities to realize improved profits and deliver the tools to optimize processes, finding immediate and lasting value. With end-to-end technology and deep vertical expertise that underpins our recovery, preventive, and analytics solutions, we provide the actionable insights to minimize leakage, optimize cash flow, and shape stronger, healthier businesses. F or additional information on PRGX, please visit www.prgx.com .
Job Description
SUMMARY:
As part of the Infrastructure Operations & DBA organization, this position will drive best-in-class data virtualization and scalable data architectures. The Sr. Database Administrator (Trino and Postgres) will lead platform deployments, migrations, and upgrades across the enterprise Trino cluster environment(s) and Postgres database engines. This candidate will also provide level 3 subject-matter expertise support when issues arise on the platform requiring escalation. In addition to providing support and administration, this resource will be responsible for leading and recommending architectures that streamline data pipeline support, ensure stability and scalability, and maintain strategic focus on innovative technology solutions.
JOB DUTIES & RESPONSIBILITIES:
· Develop and maintain solutions which automate configuration, deployment, scaling, monitoring, and support of the company’s core distributed data systems.
· Collaborate and drive system architecture(s) for Trino as a scalable query engine and as an Enterprise shared service.
· Management oversight for system lifecycle- Installations, upgrades, and BAU maintenance- across Trino cluster and Postgres database architectures.
· Own updates to coordinator and worker node configuration files, including catalog properties files, for data source configuration.
· Streamline integration with applications and user distributions; ability to improve performance through query optimization and executions.
· Ensure collection of logs and Java thread dumps across environments where necessary to drive improvements or troubleshoot.
· Drive best practice implementations for Trino cluster tuning and monitoring.
· Support for adding custom binary files and customer configuration files, such as custom connectors or UDF
· Build and support materialized views, ensure log monitoring is kept up to date.
· Support of PostgreSQL database clusters, architectures, and implementations.
WORK EXPERIENCE AND EDUCATION REQUIREMENTS:
· 8+ years of total IT experience within a large-scale or data-driven enterprise.
· 3+ years of experience developing and administering Trino/distributed data query engine deployments.
· 3+ years PostgreSQL database administration experience preferred.
· Expert SQL skills including query tuning for Starburst Trino and PostgreSQL; domain knowledge of data quality/data entitlement.
· Bachelor’s degree in computer science, software engineering, or related field preferred.
· Experience leading architectures and best-practice recommendations with product development for data-driven solutions.
· Experience managing complex delivery pipelines across multiple product groups.
· Advanced understanding of database technology and administration; hands-on experience analyzing root causes and issues.
· Familiarity with reporting vs. transactional databases, sharding, and spatial databases.
· Familiarity with Mongo, Cosmos, and Azure-native database solutions is a plus.
· Experience working in a fast-paced and highly collaborative global team.
· Strong analytical and critical thinking skills.
· Self-starter with sense of urgency and desire to make an impact.
WORKING CONDITIONS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is occasionally required to remain stationary; move; lift and/or move up to 15 pounds. The employee must regularly sit; use hands to finger, handle, or feel; reach with hands and arms; communicate. Specific vision abilities required by this job include close vision.
Equal Opportunity Employer
Skills & Requirements Qualifications
PRGX provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, age, sex, national origin, disability status, genetic information, Protected Veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
ABOUT PRGX
We provide the business intelligence to unlock incremental value from data and expand impact across our clients' organizations for healthier whole businesses. PRGX pioneered Recovery Audit nearly 50 years ago and is now the global leader in source-to-pay analytics and margin expansion. PRGX empowers clients in more than 30 countries with the business intelligence to recover $1.2 billion in annual cash flow, unlocking value and improving the overall health of organizations across the world. We collaborate with supplier communities to realize improved profits and deliver the tools to optimize processes, finding immediate and lasting value. With end-to-end technology and deep vertical expertise that underpins our recovery, preventive, and analytics solutions, we provide the actionable insights to minimize leakage, optimize cash flow, and shape stronger, healthier businesses. F or additional information on PRGX, please visit www.prgx.com .
Job Description
SUMMARY:
As part of the Infrastructure Operations & DBA organization, this position will drive best-in-class data virtualization and scalable data architectures. The Sr. Database Administrator (Trino and Postgres) will lead platform deployments, migrations, and upgrades across the enterprise Trino cluster environment(s) and Postgres database engines. This candidate will also provide level 3 subject-matter expertise support when issues arise on the platform requiring escalation. In addition to providing support and administration, this resource will be responsible for leading and recommending architectures that streamline data pipeline support, ensure stability and scalability, and maintain strategic focus on innovative technology solutions.
JOB DUTIES & RESPONSIBILITIES:
· Develop and maintain solutions which automate configuration, deployment, scaling, monitoring, and support of the company’s core distributed data systems.
· Collaborate and drive system architecture(s) for Trino as a scalable query engine and as an Enterprise shared service.
· Management oversight for system lifecycle- Installations, upgrades, and BAU maintenance- across Trino cluster and Postgres database architectures.
· Own updates to coordinator and worker node configuration files, including catalog properties files, for data source configuration.
· Streamline integration with applications and user distributions; ability to improve performance through query optimization and executions.
· Ensure collection of logs and Java thread dumps across environments where necessary to drive improvements or troubleshoot.
· Drive best practice implementations for Trino cluster tuning and monitoring.
· Support for adding custom binary files and customer configuration files, such as custom connectors or UDF
· Build and support materialized views, ensure log monitoring is kept up to date.
· Support of PostgreSQL database clusters, architectures, and implementations.
WORK EXPERIENCE AND EDUCATION REQUIREMENTS:
· 8+ years of total IT experience within a large-scale or data-driven enterprise.
· 3+ years of experience developing and administering Trino/distributed data query engine deployments.
· 3+ years PostgreSQL database administration experience preferred.
· Expert SQL skills including query tuning for Starburst Trino and PostgreSQL; domain knowledge of data quality/data entitlement.
· Bachelor’s degree in computer science, software engineering, or related field preferred.
· Experience leading architectures and best-practice recommendations with product development for data-driven solutions.
· Experience managing complex delivery pipelines across multiple product groups.
· Advanced understanding of database technology and administration; hands-on experience analyzing root causes and issues.
· Familiarity with reporting vs. transactional databases, sharding, and spatial databases.
· Familiarity with Mongo, Cosmos, and Azure-native database solutions is a plus.
· Experience working in a fast-paced and highly collaborative global team.
· Strong analytical and critical thinking skills.
· Self-starter with sense of urgency and desire to make an impact.
WORKING CONDITIONS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is occasionally required to remain stationary; move; lift and/or move up to 15 pounds. The employee must regularly sit; use hands to finger, handle, or feel; reach with hands and arms; communicate. Specific vision abilities required by this job include close vision.
Equal Opportunity Employer
Skills & Requirements Qualifications
PRGX provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, age, sex, national origin, disability status, genetic information, Protected Veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.