Senior PostgreSQL DBA: Design, Security & Automation

TechDigital Group; Fort Worth (TX); In loco; USD 80.000 - 120.000; Tempo pieno

Descrizione del lavoro

An established industry player is seeking an experienced PostgreSQL Database Administrator to oversee the installation, configuration, and maintenance of their database systems. This role involves designing databases, managing user access, and implementing robust backup and recovery strategies. The ideal candidate will possess strong SQL skills and a deep understanding of database performance tuning and security protocols. Join a dynamic team where your expertise will contribute to optimizing database environments and ensuring data integrity. This is a fantastic opportunity for those looking to make a significant impact in a collaborative and innovative setting.

Competenze

• 9-12 years of experience as a Database Administrator, focusing on PostgreSQL.
• Strong understanding of SQL, database design principles, and system administration.

Mansioni

• Install, configure, and maintain PostgreSQL databases across various platforms.
• Monitor database performance, optimize queries, and ensure data integrity.

Conoscenze

PostgreSQL

SQL

Database Design

System Administration

Performance Tuning

Backup and Recovery

User Management

Automation Scripting

Formazione

Bachelor's Degree in Computer Science

Certifications in PostgreSQL

Strumenti

pg_dump

pg_restore

pg_basebackup

EXPLAIN

VACUUM

ANALYZE

Descrizione del lavoro

Job Duties
• Provide first-level technical support for laboratory applications, instrument-integrated systems, and laboratory IT infrastructure.
• Perform user administration activities, including user account creation, modification, deactivation, and access management.
• Support onboarding and offboarding of laboratory systems and users.
• Coordinate and execute application software installations, upgrades, patches, and configuration changes for standalone and networked laboratory systems.
• Configure and maintain laboratory applications, instrument interfaces, and related system settings.
• Assist laboratory users in troubleshooting software, hardware, and instrument integration issues involving systems such as HPLC, GC, spectrophotometers, and other analytical instruments.
• Support audit trail reviews, data archival activities, and system maintenance activities.
• Manage and support Windows-based laboratory workstations and network-connected devices.
• Coordinate with desktop, infrastructure, and network support teams to resolve hardware, operating system, and connectivity issues.
• Administer Active Directory components, including computer accounts, Organizational Units (OUs), security groups, permissions, and OU migrations.
• Perform endpoint administration activities, including SCCM client deployment, configuration, troubleshooting, and maintenance.
• Troubleshoot network-related issues, including DNS, DHCP, domain authentication, and connectivity problems affecting laboratory operations.
• Perform and monitor backup and recovery activities for laboratory systems, including standalone and benchtop instruments.
• Support system image restoration, file-level recovery, backup client installation, and backup job monitoring.
• Coordinate monthly patching activities and preventive maintenance schedules.
• Work with vendors and infrastructure teams to resolve hardware failures, maintenance requirements, and system outages.
• Support compliance with GLP, GMP, FDA, 21 CFR Part 11, and applicable regulatory requirements.
• Ensure laboratory systems are maintained and operated in accordance with approved SOPs, Work Instructions (WIs), validation documentation, and quality procedures.
• Update and maintain SOPs, technical documentation, configuration records, user guides, and operational procedures.
• Create, document, and implement change requests in accordance with established ITIL-based change management processes.

Required Qualifications
• Bachelor's degree in information technology, Computer Science, Life Sciences, Engineering, or a related discipline.
• 8+ years of experience in a laboratory or IT support role.
• Working knowledge of Windows operating systems, Active Directory, SCCM, networking concepts, backup and recovery solutions, and endpoint management.
• Familiarity with laboratory instruments and integrated laboratory software platforms.
• Understanding of ITIL processes, including Incident, Problem, Change, and Service Request Management.
• Knowledge of regulatory requirements, including GLP, GMP, FDA regulations, and 21 CFR Part 11.
• Strong troubleshooting, communication, documentation, and stakeholder management skills.