Support and maintain InvestClouds development, test and production database estate across numerous DB Technologies (e.g., SQL Server, Oracle, PostgreSQL, etc.)
Work as part of a wider support team to investigate and resolve production outages.
Install and configure new database servers to an established standard and within agreed processes.
Ensure adherence and maintenance of DR, Backup and Recovery procedures.
Monitor database performance, and help support capacity planning
Manage and maintain database security standards and controls.
Troubleshoot and resolve data and performance related issues as required.
Contribute to efforts around patching, upgrade and maintenance work.
Ensure ticketing and change control processes are followed.
Liaise with appropriate vendors to resolve/escalate database issues.
Assist with continued automation of certain database related activities.
Develop and maintain technical documentation of processes and standards.
Work out of hours and weekends when needed or requested by management.
ESSENTIAL SKILLS AND QUALIFICATIONS:
Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience)
At least 8 years of recent production database administration experience.
Deep knowledge of at least one major RDBMS (e.g., Oracle ,SQL Server, PostgreSQL)
Strong experience with performance tuning, query optimization, and indexing strategies
Solid understanding of replication, clustering, and high availability technologies
Practical experience in Database upgrades/migrations and patching
Oracle database tuning and performance analysis skills
Working knowledge of relevant monitoring and management tools
Experienced working on a UNIX/Linux OS with capabilities in shell scripting
Excellent analytical and problen solving skills, identifying root causes and offering solutions
DESIRABLE SKILLS AND QUALIFICATIONS:
Experience with cloud-based databases (e.g., AWS RDS)
Certifications such as Microsoft Certified, Oracle Certified Professional, or similar
Strong clear and concise written and verbal communication skills
