Senior Database Engineer

Location

Chennai | India

Job description

• The position is for a Senior Database Engineer, who has experience working with large data focused projects, and whose responsibility is around the transformation of data from legacy systems to modern cloud microservice based applications, along with working towards better methods of exploiting this data in terms of analytics and reporting
• Currently we are in the middle of a large programme to transform a legacy estate to AWS, and therefore there is a large amount of data hosted in platforms such as Oracle and SQL server that needs to be linked in with new microservices, using CDC technology, along with making this and new microservice mastered data available for both end user reporting and downstream consumption of other data platforms
• This role involves working with business SME s, product owners, architects, and developers, hence excellent communication and analysis skills are required
• There will also be attendance to various senior stakeholder meetings to explain project progress, design ideas and decisions etc, so good communication & planning skills are essential, with the ability to put things into non-technical terms for the wider audience

About You

This would suit someone with a background in complex data transformation projects, from legacy to cloud preferably, and who is looking to work on fast moving projects and contribute to design decisions. A proven track record in delivering projects is an advantage.

Key Skills & Experience

• Proficiency in one or more database systems such as Amazon Aurora MySQL, PostgreSQL, Microsoft SQL Server, Oracle, DynamoDB, etc.

• Expert level hands-on experience in designing, developing, and maintaining complex SQL queries, stored procedures to support various business applications.

• Design, implement, and maintain scalable and high-performance database solutions.

• Experience with data modelling tools and implementation of database schemas, ensuring optimal performance, data integrity, and scalability.

• Perform advanced performance tuning and optimization of database systems.

• Implement and maintain database monitoring solutions to proactively identify and address potential issues.

• Proven experience of implementing different indexing strategies to improve query performance.

• Develop scripts and automation tools to streamline database management tasks.

• Familiarity with version control systems for database schema changes (e.g., Git).

• Knowledge of AWS DMS, Lambda, S3, Step Functions, CloudWatch, Redshift, Glue, Event Bridge.

• Change Data Capture understanding.

• CI/CD - Pipeline setup and repository (Bitbucket) knowledge.

• Automated testing design and setup.

• Experience with large-scale data environments.

• Data Warehousing concepts, design and loading strategies.

• Experience with Integration / Ingestions of data sources into a Data Lake / Data Platforms.

• Excellent organisational skills, proactive, self-starter with a curious approach to data and its value.

• Microservice architecture understanding.

• AWS SNSSQS pub/sub/queue concepts.

• JIRA - Kanban Boards, agile methodology.

• Working with product management, product owners, data architects, business stakeholders.

• Excellent Communication & Planning.

Desirable Skills & Experience

• Python - Script writing

• JenkinsTerraform - Infrastructure as code

Job tags

Salary