Database Engineer

Roles and responsibilities

• Provide expert technical consultancy and guidance to EGIT dealing within the technology area and act as lead technical member in the project team delivering the work packages assigned.
• Develop IT Solutions that meet customer requirements. Ensure that the design is robust, appropriate and of high quality and conforming to corporate standards and in line with the technical strategy.
• Ensure that the developed architecture/solution meets the service level requirements in terms of expected availability, capacity, continuity, security, performance and reliability.
• Foster the development of high-performing technical teams to meet strategic architectural objectives.
• Develop solution architectures for assigned projects with the established EA standards and also support the development of technology advancements and adaptation of new technologies.
• Collaborate with other IT Technology teams to implement ongoing monitoring of the relevant technology to ensure level 1 & 2 incidents are configured within EMS.
• Guide Project Manager/Technology team managers for solution definition, technical design and development of in-house developed solutions. These are to be delivered as per agreed costs and timescales to meet signed-off functional, technical and process requirements.
• Ensure that assigned incidents are resolved within the agreed service levels and problems are defined and analysed in line with the Problem Management Process. Ensure that solutions to problems meet the architectural and security standards within the technology area and that impact on the business is minimised. Own and manage changes within the technology area.
• Publish and maintain high-quality documentation for the technology area. Working within the standard templates and documentation guidelines which includes detailed design, configuration details, support procedures, operations manuals and deployments architecture.
• Manage 'End-of-life' replacement of equipment and/or software within the technology area to ensure conformance to technical standards and support the technology initiatives and directions. Ensure the process and enhancement specifications are translated into effective programs with error-free code using the enterprise development tools, methods and languages.

Qualifications & Experience
To be considered for the role, you must meet the below requirements:
Degree or Honours (12+3 or equivalent) in Information Technology and 5+ Years of experience.
Knowledge/Skills

• Agile and DevOps practice, Servant leadership principles. Experience in databases, Rational, NoSQL and Distributed SQL databases and cloud DBaaS and with leading public clouds, VMware-based private cloud.
• Knowledge of Terraform, Ansible, Jenkins and shell scripting. Experience with continuous availability deployments - RAC, Oracle ADG, Enterprise Manager, Oracle Golden Gate.
• Experience in environments requiring low latency, high throughput, availability and scalability.
• Experience in the usage of Oracle DBs in public clouds - Amazon AWS, MS Azure. Cloud-aware architectures deployment and support background, both for IaaS DBaaS (AWS Aurora etc).
• Experience in automation in large-scale database environments, Ansible, Jenkins, Terraforms, and shell scripting in CI/CD environments. Everything is a code approach. Git and code maintenance experience.
• Skilled in performance tuning, capacity management and troubleshooting large Oracle DB deployments with continuous availability requirements.
• Experience with other RDBMS - MS SQL, PostgreSQL - both IaaS and DBaaS.
• Experience with distributed SQL databases - Yugabyte, MariaDB, CockroachDB.
• Knowledge in cloning, refreshing production applications and databases to non-production instances, automated cloning, and automated DB patching.
• Knowledge in software engineering for database intensive applications and general database administration in enterprise critical environments. Experience with developing and maintaining backend Java, NodeJS and .Net applications using relational and NoSQL database. Experience with frameworks like Spring, Spring Data. Experience with database migrations, source code management, code refactoring, SQL writing and optimization for various relational databases, high availability and performance tuning.

Desired candidate profile

As a Database Engineer, several key skills and qualifications are essential for success in the role. Here are some important ones:

1. Database Design: Strong understanding of database architecture and design principles, including normalization and denormalization.
2. SQL Proficiency: Expertise in SQL (Structured Query Language) for querying, updating, and managing databases effectively.
3. Database Management Systems (DBMS): Familiarity with various DBMS platforms (e.g., MySQL, PostgreSQL, Oracle, SQL Server) and their specific features.
4. Performance Tuning: Skills in optimizing database performance, including indexing, query optimization, and resource management.
5. Backup and Recovery: Knowledge of data backup and recovery strategies to ensure data integrity and availability.
6. Data Modeling: Ability to create and maintain data models that support business requirements and ensure efficient data access.
7. ETL Processes: Experience with Extract, Transform, Load (ETL) processes to integrate data from various sources into the database.
8. Security Practices: Understanding of database security measures, including user authentication, access controls, and encryption.
9. Problem-Solving Skills: Strong analytical skills to troubleshoot database issues and implement effective solutions.
10. Collaboration: Ability to work closely with software developers, system administrators, and other stakeholders to support application development and data needs.

These skills are crucial for effectively managing databases, ensuring data integrity, and supporting the organization’s data-driven initiatives.