Database Engineer

Role : Database Engineer (SQL/AWS/ETL)

Location: Columbus, OH

Work Mode : hybrid (3 days onsite, 2 days WFH)

Job Description:

candidates with Database knowledge & ETL knowledge will get 100% preference

Must have strong AWS experience. Everything is being moved to public cloud

I will be doing performance tuning, stored procedures, views, triggers, and indexes. candidate must be strong here

Must have very strong DBMS knowledge on SQL server, Postgres (Oracle)

Must have good data modeling experience; will be working with architecture team to perform data modeling

Should have strong CICD and data warehouse concepts

Should have good ETL experience (Informatica or Abinitio is fine)

Looking for 8 10 years experience

MUST have

cloud, preferably AWS

DBMS knowledge on SQL Server and Postgres

hands-on experience with Stored procedures, views, triggers, and indexes. performance tuning

hands-on experience with data modelling

Required qualifications, capabilities, and skills.

8 to 10 years of strong SQL skills; SQL Server and PostgreSQL are preferred. experience in any other RDBMS is plus.

Hands-on practical experience delivering database design, database administration, development, testing, and operational stability.

Hands-on practical experience on Data modeling.

Hands-on experience with Stored procedures, views, triggers, and indexes. performance tuning.

5 years of experience in Database technologies (MS-SQL Server, Postgres, Aurora Postgres)

2 years of experience in AWS technologies, especially Aurora and Amazon RDS

Proficiency in automation and continuous delivery methods

Proven understanding of agile methodologies such as CI/CD, Applicant resilience, and Security

Proven experience in understanding requirement related to extraction, transformation, and loading (ETL)

Formal training or certification on software engineering concepts and 3 years applied experience.

Ability to independently design, build, test, and deploy code. He or she should be able to lead by example and guide the team with his/her technical expertise.

Ability to identify risks and issues for the project and manage them accordingly.

Hands-on practical experience in system design, application development, testing, and operational stability

Experience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languages.

Proficient in coding in one or more programming languages

Experience across the whole Software Development Life Cycle

Proven knowledge of software applications and technical processes within a technical discipline (e.g., cloud, artificial intelligence, etc.).

Python and spark knowledge are pluses.

Additional technologies like Liquibase and other automated deployment tools

Preferred qualifications, capabilities, and skills

Knowledge about Database engineering and Data warehousing Concepts.

Experience with Agile-based project methodology.

Ability to identify risks and issues for the project and manage them accordingly.

Knowledge or experience on ETL technologies like Informatica or Ab-initio would be preferable.

People management skills would be given preference but is not mandatory.

Job responsibilities

Execute software solutions, design, development, and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or break down technical problems.

Write secure and high-quality code and maintain algorithms that run synchronously with appropriate systems.

Produce architecture and design artifacts for complex applications while being accountable for ensuring design constraints are met by software code development.

Apply knowledge of tools within the Software Development Life Cycle toolchain to improve the value realized by automation.

Apply technical troubleshooting to break down solutions and solve technical problems of basic complexity.

Gather, analyze, synthesize, and develop visualizations and reports from large, diverse data sets in service of the continuous improvement of software applications and systems.

Proactively identify hidden problems and patterns in data and use these insights to drive improvements to coding hygiene and system architecture.

Contribute to software engineering communities of practice and events that explore new and emerging technologies.

Add to the team culture of diversity, equity, inclusion, and respect.

Skills:

• SQL
• AWS
• ETL
• CICD