What are the responsibilities and job description for the Senior Database Administrator (Trino & Postgres) position at PRGX Global, Inc.?
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 :
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
