Posted:6 days ago|
Platform:
Work from Office
Full Time
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.
USV
Upload Resume
Drag or click to upload
Your data is secure with us, protected by advanced encryption.
Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.
We have sent an OTP to your contact. Please enter it below to verify.
Navi Mumbai, India
4.5 - 9.5 Lacs P.A.
5.0 - 9.0 Lacs P.A.
6.0 - 7.0 Lacs P.A.
Chennai
6.0 - 10.0 Lacs P.A.
Coimbatore, Bengaluru
9.0 - 13.0 Lacs P.A.
Bengaluru
16.0 - 17.0 Lacs P.A.
Hyderabad
6.0 - 10.0 Lacs P.A.
Noida, Hyderabad, Bengaluru
20.0 - 30.0 Lacs P.A.
7.0 - 9.0 Lacs P.A.
7.0 - 12.0 Lacs P.A.