Database Engineer

Job summary

Working as part of a dynamic and fast-growing engineering team the Database Engineer will play an important part in our modernisation programme and work on application development projects. The individual will work closely with technical leads developers and DevSecOps to assist in both logical and physical database design along with database query and performance tuning.

Responsibilities

• Be the owner and driver of database schema and architecture for the specific software modules and how they interact with other internal and external enterprise applications. - Responsible for the data layer architecture of the platform. - Design and maintain the multitenancy and data security mechanism for the platform. - Collaborate in the extensibility of the architecture by incorporating modern database architecture principles with a SaaS best practice in mind. - Responsible for the security performance and scalability of the application from a database architecture and engineering perspective. - Take existing DB model/design and remove technical debt by rearchitecting the model with contemporary best practices and design. - Support teams with development of NoSQL databases using normalized data. - Gather database metrics perform analytics and display reports. APPLICATION OF KNOWLEDGE PROBLEM SOLVING & INNOVATION - Extensive experience in architecting relational databases such as Microsoft SQL Server or Oracle. - Knowledge of various versions of MSSQL (2012-2019) and/or Oracle (10g-21c) to support existing client databases. - Excellent understanding of data modelling and data schema design. - Knowledge of logical and technical database application design - Experience in Performance Tuning Query Optimization using Performance Monitor SQL Profiler and other related monitoring and troubleshooting tools. - Expert knowledge in the data mart and data analysis tools. - Basic Knowledge in all key components of Cloud including SaaS containerization etc. INTERACTION Meritsoft Development/Engineering and Operations teams Senior Management teams across Meritsoft Cognizant Studio team and wider Accelerator Core team Occasionally Legal Compliance and Security