Database Engineer

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.