Position Details
Postgresql Database Administrator Dba Apply
Responsibilities:
- Install and configure PostgreSQL database servers on-premises.
- Optimize database configuration settings for performance and reliability.
- Monitor database performance and resource usage.
- Identify bottlenecks and implement performance tuning measures.
- Use tools and scripts to analyze query performance and recommend optimizations.
- Develop and implement backup and recovery strategies to ensure data integrity and availability.
- Regularly review and update security policies and protocols.
- Plan and execute database migrations and upgrades with minimal downtime.
- Collaborate with developers and application teams to design efficient database schemas.
- Ensure normalization and indexing strategies are applied for optimal data retrieval.
- Diagnose and resolve database-related issues and errors.
- Provide support to application developers in optimizing database interactions.
Requirements:
- Maintain detailed documentation of database configurations, procedures, and policies.
- Document changes made to the database environment and maintain an inventory of databases.
- Develop scripts for automation of routine DBA tasks (e.g., backups, monitoring).
- Recommending hardware upgrades or changes as necessary.
- Work closely with development, network, and security teams to ensure database systems align with overall IT strategy.
- Communicate effectively with stakeholders regarding database status, issues, and plans.
- Ensure databases comply with relevant regulations and standards (e.g., GDPR, HIPAA).
