What you will do
- Design, develop, and maintain conceptual, logical, and physical data models based on business and application requirements.
- Create and maintain database schemas, tables, views, indexes, and relationships to ensure data integrity, security, and performance.
- Implement database designs by writing and executing Data Definition Language (DDL) scripts, including CREATE and ALTER statements.
- Develop, maintain, and integrate database components across different database management systems (DBMS).
- Translate business and application requirements into efficient database structures, stored procedures, functions, and triggers.
- Develop database prototypes, including schemas, SQL queries, and test datasets, for stakeholder validation before production deployment.
- Prepare and execute database test plans, including unit testing of stored procedures and data integrity validation.
- Write, optimize, and maintain complex SQL queries to support application functionality.
- Troubleshoot database issues and perform query optimization, indexing, and execution plan analysis to improve performance.
- Implement database security policies, access controls, and encryption mechanisms in accordance with organizational standards.
- Design and support database migration, backup, and recovery strategies to ensure data availability and business continuity.
- Assist with database deployment, installation, configuration, and release management activities.
- Prepare and maintain technical documentation covering database designs, development processes, testing, and deployment.
- Collaborate with development, testing, infrastructure, and business teams to ensure successful database integration and delivery.
What you bring
- Knowledge of conceptual, logical, and physical data modelling techniques.
- Familiarity with data modelling tools such as Oracle SQL Developer Data Modeler, Hackolade, and NoSQL Workbench.
- Experience with database development and administration tools such as Oracle SQL Developer, DBeaver, pgAdmin, and SQL Workbench/J.
- Good knowledge of relational databases such as PostgreSQL and Oracle.
- Understanding of NoSQL databases such as MongoDB, DynamoDB, Cassandra, and Azure Cosmos DB.
- Strong knowledge of SQL for database development, data manipulation, and query optimization.
- Knowledge of procedural SQL languages such as PL/SQL (Oracle) and PL/pgSQL (PostgreSQL).
- Familiarity with database unit testing frameworks such as utPLSQL and SQLTest.
- Understanding of database release management and deployment processes.
- Knowledge of Agile methodologies, including Scrum and Kanban.
- Understanding of continuous integration and iterative database schema changes.
- Knowledge of database performance optimization techniques, including query tuning, indexing, and execution plan analysis.
- Understanding of database backup, recovery, replication, clustering, and high availability.
- Knowledge of database security, access management, encryption, and compliance practices.
How you work
- Analyse business and application requirements and translate them into effective database designs.
- Develop and maintain structured, scalable, secure, and high-performing database solutions.
- Write clean, efficient, and optimized SQL queries, stored procedures, functions, and database scripts.
- Identify and troubleshoot database performance issues and implement appropriate solutions.
- Prepare clear and structured technical documentation.
- Conduct database testing and ensure data accuracy, integrity, and reliability.
- Deliver technical presentations and communicate effectively with different stakeholders.
- Maintain high-quality standards throughout database development and deployment.
- Adapt to evolving database technologies and integrate them into existing architectures.
- Work effectively within Agile development teams and collaborate with cross-functional stakeholders.
- Participate in multilingual meetings and communicate effectively in an international, multicultural environment.
- Demonstrate good analytical, technical, communication, and problem-solving skills.
What you can expect
- Opportunities to work with relational and NoSQL database technologies.
- Exposure to enterprise database development, data modelling, and database integration projects.
- Opportunities to work with modern database tools and technologies.
- Collaboration with international teams across development, testing, and infrastructure.
- Opportunities for continuous technical learning and professional development.
- Exposure to Agile methodologies and structured database delivery practices.