Note: The job is a remote job and is open to candidates in USA. Zeektek is seeking a PostgresSQL DBA / Data Engineer for a 6+ month contract position. The role will begin in staging and partner with engineering on Liquibase strategy, privilege management, database cleanup, reporting, performance, and overall database stability, with production changes managed through an established change-control process.
Responsibilities
• Begin the work in staging, with any production changes performed through our established change-control process
• Have the DBA partner with engineering on the Liquibase strategy, privilege model, database cleanup, reporting, and overall database stability
• Establish a reliable migration strategy, validate schemas across environments, and create safe deployment and rollback procedures
• Complete and validate the transition away from using the PostgreSQL superuser for application connectivity
• Establish appropriate least-privilege application users, credential rotation, and ensuring deployments remain stable
• Review and clean up stale or orphaned data, unused database objects, and other database hygiene issues that currently make troubleshooting and deployments more difficult
• Support our reporting requirements through query and performance tuning, report-friendly views or data structures where appropriate, and guidance to ensure reporting remains accurate and performant as the schema and privilege model evolves
Skills
• • Database assessment and data integrity analysis
• • Data cleanup, remediation, and migration support
• • Relational data modeling and database design fundamentals
• • Advanced SQL and data investigation
• • Data profiling, reconciliation, and quality validation
• • Data lineage, source-of-truth, and auditability practices
• • Integration and incoming-data analysis, including HCAI data needs
• • Data access, privacy, security, and role-based reporting considerations
• • Reporting-ready dataset and semantic-layer design
• • Business intelligence, dashboard development, and report design
• • Business requirements gathering and stakeholder facilitation
• • Metric, KPI, and business-definition development
• • Data dictionary, metric glossary, report specification, and process documentation
• • Portfolio-wide reporting standards, templates, and governance
• • Report/dashboard intake, prioritization, testing, validation, publishing, and maintenance
• • Accessible data visualization and dashboard usability
• • User training, office hours, self-service reporting, and data-literacy enablement
• • Legacy-vendor transition and system modernization support
• • Agile/Scrum, Jira/Confluence, and Software Development Lifecycle (SDLC) collaboration
• • Cross-functional partnership with product, program, development, DevOps, SecOps, support, and leadership
• • Continuous improvement and scalable process standardization
Benefits
• 100% remote work
Company Overview
• Zeektek is an IT recruiting and solutions firm. It was founded in 2016, and is headquartered in Granite Bay, California, USA, with a workforce of 11-50 employees. Its website is https://www.zeektek.com.