Database Engineer (SQL/AWS/ETL)

Database Engineer (SQL/AWS/ETL)

Location: Columbus, OH - 299684 hybrid (3 days onsite 2 days WFH)

Experience :8 + years required for this role

Note: Submit candidates from OH State

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

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

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 - postgres

- Hands on experience with Stored Proc, views, triggers, 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 is 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 Modelling.

• Hands on experience with Stored Proc, views, triggers, indexes. performance tuning.

• 5+ years of experience in Database technologies MS-SQL Server, Postgres, Aurora Postgres

• 2+ plus 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 Resiliency, 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. Should be able to lead by example and guide the team with his/her technical expertise.

• Ability to identify risks/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 is plus.

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/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 maintains 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 reporting from large, diverse data sets in service of continuous improvement of software applications and systems.

• Proactively identify hidden problems and patterns in data and uses 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 team culture of diversity, equity, inclusion, and respect.