The role is responsible for day-to-day administration of the client's Database Infrastructure and related systems. The Sr.
Database Engineer shall have expert understanding of Database systems, it will be primarily but not limited to SQL Server, Oracle DB, MySQL, and MariaDB, additional knowledge of Oracle Middleware, Mongo DB and Cassandra would be beneficial.
â¢ Provide excellent technical support for MS SQL Server and Oracle Database environment.
â¢ Provide operational support for DB issues initiated from Incidents or Changes.
â¢ Provide solutions and root-cause analysis of system performance and failure related issues.
â¢ Work on an onsite shift-rota and provide off site 24x7 support.
â¢ Work on projects and provide close liaison with project teams to ensure the smooth transition of new databases and initiatives into the Production environment.
â¢ Working closely with manager and team members.
â¢ Review and recommend options to improve the effectiveness of the database infrastructure.
â¢ Establish / maintain best practices, processes and procedures to underpin the operations of the business.
â¢ Performance monitoring / Testing and capacity planning.
â¢ Creation / maintenance of full system documentation, including DR documentation.
â¢ Innovation â continually looking at ways to improve infrastructure, for a faster and more efficient environment.
Requirements for the role :
â¢ Excellent working knowledge of SQL Servers from SQL 2012 to 2017. Including
â¢ Excellent working knowledge of SQL Replication, AlwaysOn and HA features.
â¢ Experience of performance and tuning optimising SQL DBâs
â¢ Excellent working knowledge of Oracle RDBMS 10g to 19c
â¢ Excellent working knowledge of Oracle RAC
â¢ Excellent working knowledge of Oracle Forms
â¢ Experience using a scripting language to automate tasks
â¢ Experience of monitoring and alerting tools for DBâs
â¢ 5+ yearsâ minimum experience in technical support as an SQL and Oracle DBA
â¢ Experience of ITIL v3 standards or a certificate in ITIL v3 foundation skills beneficial
â¢ Degree educated preferable.
â¢ Strong knowledge of Data Architecture concepts
â¢ Strong Patch Management experience
â¢ Prefer a Sr. Database Engineer person with a Dev-Ops, forward thinking mindset
â¢ MySQL, MariaDB, MongoDB, Cassandra experience a plus
â¢ Oracle Middleware experience a plus
â¢ Candidate will be a DBA with strong SQL Server and Oracle experience.
â¢ The candidate will be a member of a Database Administration team providing infrastructure services and operational support across a global company.
â¢ An ideal candidate would have experience working within a financial institution or similar environment.
â¢ There is a third-line and out-of-hours support requirement, which operates on a rota