Database Engineer

• *HCLTech**

is a global technology company, home to 220,000+ people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.

We are seeking an experienced and proactive Database Engineer with Strong Admin Skills to join our technology team. The successful candidate will be responsible for the management, optimization, and migration of our application database schemas. This role is essential in ensuring the performance, reliability, and scalability of our database environment as we transition from on-premises Oracle databases to a cloud-based PostgreSQL infrastructure.

The ideal candidate will have a strong background in database administration, a deep understanding of cloud database technologies, and a collaborative mindset to work effectively with our DevOps and application development teams

• *Key Responsibilities:
• Oversee the administration of approximately 6 database schemas on Oracle databases, ensuring their stability and performance.
• Take part in leading and execution on the planned migration of our database environment from Oracle to Cloud SQL for PostgreSQL.
• Develop and implement migration strategies, ensuring data integrity and minimal downtime.
• Supervise and review all changes made to database schemas, including the analysis of change and rollback scripts, utilizing tools like Liquibase.
• Collaborate with the DevOps team to integrate and improve the schema update process within our CI/CD pipelines.
• Conduct regular analysis of database usage patterns to identify and propose optimization opportunities, such as the creation of indexes, partitions, views, and constraints.
• Proactively analyze and identify discrepancies between different database schemas, proposing and implementing changes for alignment and standardization.
• Recommend and implement schema and query changes to enhance database performance.
• Employ a range of techniques to analyse problems and evaluate multiple solutions against engineering, business & strategic criteria
• Collaborate to achieve consensus on topics and issues and contribute to communities
• Identify and resolve barriers to business deliveries implementing solutions which iteratively deliver value
• Design solutions using common design patterns with a range of design tools & techniques
• Conduct peer reviews to ensure designs are fit for purpose, extensible & re-usable
• Deliver end to end first-class engineering solutions across a range of technology platforms
• Improve delivery standards, working practices, tools & solutions and driving adoption of automation tools
• Ensure stable and reliable production environments and high-quality service delivery to customers
• Investigate production incidents & lead remediation, analyze services & components
• Design & build solutions which are secure & controlled
• Investigate & report on issues and potential risk events within designs and solutions
• *Skills & Qualifications:

Mandatory

• Proven experience as a Database Administrator, Database Engineer, or in a similar role.
• Strong proficiency in managing PostgreSQL databases.
• Demonstrable experience with database migration projects, preferably from Oracle to a cloud-based solution like PostgreSQL.
• Hands-on experience with cloud database services (PostgreSQL) .
• Experience with database change management tools such as Liquibase.
• Solid understanding of SQL and procedural database languages (e.g., PL/SQL, PL/pgSQL).
• Experience with database performance tuning and optimization techniques.
• Familiarity with DevOps principles and practices related to database management.
• Excellent analytical and problem-solving skills.
• Strong communication and collaboration abilities.
• Team player who shares and collaborates, a keen listener and quick learner
• Communicates clearly and influences using coherent, fact and benefit-based proposals
• Enables experimentation and fast learning approaches to creating business solutions
• Understands key elements of security, risk & control

Nice to have

• Experience in banking projects
• Experience with Agile Projects
• *What do we offer?**
• 1066 RON monthly budget in Benefit Online Platform
• 25 vacation days/year.
• Life Insurance cover.
• The employees working on bank holidays will benefit either a paid day off in the next 30 days + 100% of the hourly base salary for that specific day OR 200% of the hourly base salary for that specific day.
• Childbirth allowance of 7000 RON after 1 year in HCLTech.
• In the first 8 weeks, the company will pay the difference of up to 100% for the parental leave granted to pregnant employees.
• Unfortunate events allowance of 7000 RON for first degree relative granted from day 1 in HCLTech.
• Internal trainings and certifications.
• HCLTech is committed to protecting and securing the privacy and confidentiality of the Personal Data which it collects directly or indirectly from you when applying for a job at HCLTech either directly or through a third-party human resources agency. This notice (the “Notice”) outlines and explains how HCL Technologies Limited including its subsidiaries, local employing entities, associates, and affiliated companies [collectively referred to as “HCLTech”, “us,” “our”, or “we”] will process your Personal Data in accordance with applicable privacy legislation(s).*

Candidate Data Privacy Notice | HCLTech