As a Database Administrator (DBA) specializing in PostgreSQL, you will be responsible for managing, maintaining, and optimizing our database systems. Experience with Oracle is a plus. You will play a critical role in ensuring data availability, reliability, and security while supporting our Agile development methodology. You will work closely with our development and infrastructure teams to deliver high-performance, scalable, and reliable database solutions.
Key Responsibilities:
- Database Management: Manage and administer PostgreSQL and Oracle databases, including installation, configuration, performance tuning, and troubleshooting,
- Data Security: Implement and maintain robust security measures to protect sensitive data, ensuring compliance with industry standards and regulations,
- Database Monitoring: Monitor database health, performance, and availability. Proactively address issues and implement scaling strategies as needed,
- Backup and Recovery: Develop and maintain backup and recovery plans, ensuring data is consistently backed up and recoverable in case of data loss or system failure,
- Database Optimization: Identify and implement performance optimization strategies, including query optimization, indexing, and system tuning for PostgreSQL and Oracle,
- Scalability: Collaborate with the development team to plan for database scalability as the application grows,
- Automation: Automate routine database maintenance tasks to improve efficiency and reduce human error,
- Agile Methodology: Work closely with cross-functional Agile teams to support fast-paced development cycles and maintain a culture of continuous improvement,
- Documentation: Maintain comprehensive documentation of database systems, configurations, and processes.