Job Summary
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:
- Bachelor’s 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.