Database Specialist (Job Code: DBS)

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.

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.