Key Skills: PostgreSQL, PostgreSQL database, Data Engineer, Data Engineering
Roles and Responsibilities:
- Design, install, configure, and maintain PostgreSQL database systems.
- Perform database tuning, optimization, and capacity planning.
- Implement backup and recovery strategies, including disaster recovery planning.
- Monitor database performance and proactively address issues.
- Ensure database security, compliance, and access control.
- Collaborate with development and infrastructure teams to support application requirements.
- Automate routine tasks and improve operational efficiency.
- Lead database migration and upgrade projects.
Skills Required:
- Strong expertise in PostgreSQL database administration and engineering
- Advanced knowledge in performance tuning, indexing, and optimization techniques
- Experience with backup, restore, and disaster recovery strategies
- Proficiency in scripting and automation for DB operations
- Understanding of database security, access control, and compliance
- Hands-on experience with monitoring tools and high-availability setups
- Strong collaboration and troubleshooting skills with cross-functional teams
Education: Bachelor's Degree in related field