Our Client operates in the fields of information technology, data center outsourcing, contact center, smart buildings, consumer electronics, social media development, food and beverage, land transport and PET re-manufacturing.Key Responsibilities:

• Database Management:

• Install, configure, and maintain PostgreSQL, Oracle, and MySQL databases.
• Monitor database performance and ensure high levels of performance, availability, and security.
• Implement and maintain database security (roles, privileges, etc.).
• Perform database tuning and optimization.
• Plan and implement backup and recovery strategies.
• Ensure data integrity and manage database replication.

• Database Design and Architecture:

• Design and implement database schemas, tables, and objects to support business requirements.
• Collaborate with development teams to design and optimize database queries, stored procedures, and indexing.
• Provide guidance on database design to ensure scalability, performance, and reliability.

• Performance Monitoring and Tuning:

• Monitor and optimize database performance using tools like pgAdmin, Oracle Enterprise Manager, and MySQL Workbench.
• Identify and resolve bottlenecks in database operations.
• Analyze and resolve complex database issues (locking, deadlocking, replication conflicts, etc.).

• Database Security and Compliance:

• Implement security measures to protect sensitive data and ensure compliance with industry regulations.
• Monitor and audit database activity to ensure compliance with security policies.
• Develop and maintain database documentation and standard operating procedures.

• Automation and Scripting:

• Automate routine database tasks using scripts (e.g., Bash, Python, PowerShell).
• Develop and maintain automation tools for database provisioning, backup, and monitoring.

• Disaster Recovery Planning:

• Develop and implement disaster recovery plans to ensure data availability and integrity in the event of a failure.
• Test and validate backup and recovery procedures regularly.

• Collaboration and Support:

• Work closely with the development and operations teams to support application deployment and performance tuning.
• Provide database support and troubleshooting to ensure minimal downtime and quick resolution of issues.
• Mentor junior DBAs and provide technical leadership within the team.

Required Skills:

• Technical Expertise:

• Proficient in PostgreSQL database administration.
• Basic to intermediate knowledge of Oracle database administration.
• Strong SQL skills and experience with database scripting languages.
• Understanding of database security, backup, and recovery strategies.
• Familiarity with performance tuning and query optimization.

Experience and Education:

• Bachelors degree in Computer Science, Information Technology, or a related field.
• A minimum of 3-5 years of experience in database administration, primarily in PostgreSQL, with exposure to Oracle.

Reeqwest