About the role
Responsibilities:
- High Availability and Disaster Recovery (HA/DR): Design and manage complex HA solutions, including Oracle RAC (Real Application Clusters), Oracle Data Guard, SQL Server Always On Availability Groups, and Failover Clustering.
- Installation and Configuration: Deploy and upgrade multiple versions of Oracle (e. g., 12c, 19c) and Microsoft SQL Server on physical, virtual, and cloud environments.
- Performance Tuning: Proactively monitor system health, tune SQL queries, optimise indexes, and manage database configurations to prevent performance degradation.
- Security and Compliance: Implement robust security measures, manage user permissions, apply patches, and ensure compliance with data governance policies.
- Backup and Recovery: Establish and test comprehensive backup strategies to guarantee rapid recovery from system failures or data corruption.
Requirements:
- Education: Bachelor's degree in computer science, IT, or a related STEM field.
- Professional Experience: Typically 5+ years of hands-on DBA experience in enterprise-level, 24/7 production environments.
- Certifications: Preferred certifications include Oracle Certified Professional (OCP) or relevant Microsoft SQL Server credentials.
- Soft Skills: Strong analytical problem-solving, excellent communication for cross-team collaboration, capability of balancing multiple priorities effectively and the ability to handle on-call support duties.
- Hands-on experience with Warehouse Management Systems (WMS) or similar supply chain solutions is strongly preferred.
- Basic understanding of supply chain systems and their interaction with broader business processes.
- General familiarity with automation infrastructure in distribution and logistics environments.
- Regular and reliable attendance.
Technical Skills Required:
- Database Engines: Expert-level knowledge of Microsoft SQL Server and Oracle Database architecture.
- Languages: Proficiency in SQL, T-SQL (SQL Server), and PL/SQL (Oracle) for scripting and automation.
- Infrastructure: Understanding of underlying operating systems (Windows Server, Linux/Unix), networking, and storage technologies like ASM (Automatic Storage Management).
- Tools: Experience with management consoles like SSMS (SQL Server Management Studio) and OEM (Oracle Enterprise Manager).