Sr. Executive - PostgreSQL DBA

PostgreSQL DBA 

PostgreSQL Database Administrator specializing in managing and supporting related applications like LabWare Laboratory Information Management System (LIMS) database.

Responsibilities

• Database Management:

  • Installation, configuration, and upgrades of PostgreSQL database servers for application - LIMS, CAPA generator(GenAI)

  • Monitoring database performance and ensuring high data availability.

  • Optimizing and tuning the database for peak performance, including query optimization and indexing.

  • Implementing and testing robust data backup and recovery strategies, including point-in-time recovery.

  • Ensuring database security, managing user access, and enforcing security policies and compliance.

  • Troubleshooting and resolving database issues, including deadlocks and lock contention.

  • Managing database access and permissions based on the principle of least privilege.

  • Maintaining documentation for database systems, including standards, procedures, and definitions.

  • Participating in disaster recovery planning and executing recovery procedures as needed.

  • Planning and coordinating PostgreSQL database administration for accurate and effective data use.

• Performance Tuning and Optimization:

  • Monitoring database performance and proactively identifying and addressing potential issues.

  • Optimizing SQL queries and database tuning for efficient LIMS operations.

  • Adjusting configuration parameters (e.g., shared_buffers, work_mem) to align with LIMS workload requirements.

  • Creating and managing indexes strategically to improve query response times.

  • Partitioning large LabWare LIMS tables to improve query performance and management.

• Security and Compliance:

  • Implementing security and backup procedures to safeguard sensitive LIMS data.

  • Configuring and managing roles and privileges to control access to LIMS data and functionality.

  • Enabling detailed auditing and logging to track and monitor database activity for suspicious behavior.

  • Ensuring compliance with relevant data security regulations (e.g., according to AST Consulting, GDPR, HIPAA, California Consumer Privacy Act (CCPA), and the Stop Hacks and Improve Electronic Data Security (SHIELD) Act).

  • Regularly reviewing user privileges and security configurations.

• Collaboration and Support:

  • Collaborating with LabWare LIMS developers and system administrators to design and manage database systems efficiently.

  • Providing support and resolving issues related to PostgreSQL databases supporting LabWare LIMS.

  • Working with external data sources and integrating with third-party tools as needed.

  • Providing technical guidance and training to other team members. 

Qualifications

Key qualifications for this role include a Diploma/ Bachelor's degree in a relevant field and proven experience as a PostgreSQL DBA, preferably with LIMS experience. A strong understanding of PostgreSQL architecture, SQL, database optimization, backup/recovery, and security best practices is essential. Familiarity with high-availability solutions, scripting languages, and Linux is also beneficial. Relevant PostgreSQL certifications are a plus. 

Skills

Necessary skills include strong analytical and problem-solving abilities, excellent communication and collaboration skills, the ability to work independently, attention to detail, and a commitment to best practices. On-call availability may also be required. 

This profile highlights the blend of general PostgreSQL expertise and specific LabWare LIMS knowledge needed for this position.