KEY RESPONSIBILITIES
– 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
…