Database Specialist

Key Responsibilities:

• Design, develop, and maintain efficient database systems using PostgreSQL and Oracle.

• Conduct advanced performance tuning, query optimization, and troubleshooting for maximum efficiency.

• Review and refine database and table architecture to improve scalability and performance.

• Implement, monitor, and manage automated database backup and recovery strategies.

• Design and execute data retention strategies, including database purging and archival processes.

• Ensure database security by implementing and maintaining robust security protocols.

• Collaborate with developers to optimize database integration with backend systems.

• Provide proactive recommendations for enhancing database performance and resource utilization.

• Document database architectures, processes, and optimization techniques for future reference.

Required Skills and Qualifications:

• 6+ years proven experience working with databases and queries

• Strong expertise in PostgreSQL, Oracle, and other relational database systems.

• Proven experience in database performance tuning, query optimization, and architecture review.

• Proficiency in writing and managing complex SQL queries, stored procedures, and triggers.

• Expertise in implementing database backup, recovery, and purging strategies.

• Knowledge of database security best practices.

• Ability to collaborate effectively with cross-functional teams and stakeholders.

• Strong analytical, problem-solving, troubleshooting skills, and communication