Senior Software developer – Data architect

Responsibilities What will you contribute? Designing and implementing the reference data model (RDM) for different database engines, such as Oracle, MS SQL Server and Postgres, to ensure consistency and compatibility across the organisation’s data sources. Maintaining and building new strong relationships with clients Developing and maintaining database upgrade scripts to facilitate the migration of data from older versions to newer ones, while preserving data integrity and quality Optimising the performance of the parallel runs implementation, which allows multiple processes to access and manipulate data concurrently, by using development skills and tools to identify and resolve bottlenecks and errors This role requires strong problem solving skills when collaborating with the support team to manage database related issues, such as performance problems, data corruption or loss, and hardware failures, by providing troubleshooting assistance, data recovery solutions, and hardware sizing recommendations Maintaining the build toolset for RedHat and Windows platforms, which enables the deployment and configuration of the organisation’s data solutions on different operating systems Participating in the design of the SaaS solution database, if needed, by providing input and feedback on the data architecture, schema, security, scalability, and reliability aspects Responsibilities & Deliverables : Playing a key role in supporting and growing TCM’s ALM IQ market which is $10M in revenue and has 62 clients. ALM IQ is TCM’s big bet with $5M additional revenue projected in the next 5 years Insuring database performance stability by monitoring, testing, and tuning the database systems and queries, as well as applying best practices and standards for data management and quality Reporting to the product owners on the progress, status, and issues of the data architecture and development projects, as well as providing suggestions and solutions for improvement and innovation Maintaining regular contact with clients to follow-up their cases, such as providing technical support, resolving data-related problems, or delivering customised data solutions Securing client data by implementing and enforcing data security policies and procedures, such as encryption, authentication, authorisation, backup, and recovery Required Experience : Strong knowledge in database management : partitioning, PL / SQL, PSQL, etc. Postgres SQL expertise would be appreciated. Interpersonal skills Knowing docker and Kubernetes principles is wished Build toolchain : Scons, python, and Shell scripts, with docker containers DBA graduate Computer Science graduate Experience of at least 5 years in DBA role, plus development activities.