Database Engineer

Columbus, OH, United States

Database Engineer

BCforward is currently seeking a highly motivated Database Engineer in Columbus, OH area!

Our client is one of the oldest financial institutions and offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporations. Their history spans over 200 years and today are the leaders in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.

Job Title: Database Engineer

Type: W2 (Strictly No C2C and no sponsorship available)

Location: Columbus, OH (Hybrid)

Duration: 6 Months Contract to Hire

Hybrid Model: 3 Days onsite 2 days remote

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

NICE To Have

- CICD and data warehouse concept

- ETL knowledge

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.

Required qualifications, capabilities, and skills.

* 4 to 7 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.

About BCforward:

BCforward began as an IT business solution and staffing firm. Founded in 1998, BCforward has grown with our customers needs into a full-service personnel solutions organization. Headquartered in Indianapolis, Indiana, BCforward also operates numerous delivery centers across North America and India. We are currently the largest consulting firm and largest MBE certified firm in Indiana. Our uninterrupted growth has allowed BCforward to deliver uniquely configured IT staffing and project solutions for over years of catering to our customersspecific needs. BCforward currently maintains a team of over 5000 global resources. With our additional brand, Stafforward, together we have the capabilities to deliver services for a variety of industries in both public and private sectors which allows us to address your most challenging needs.

www.BCforward.com

www.facebook.com/bcforward

This posting is not an offer of employment. All applicants must be authorized to work in the United States and willing cooperate with a background check and drug screen, to the extent permitted by federal and local laws up to, and including, both criminal and financial reviews. The submission of intentionally false or fraudulent information in response to this job posting shall render the applicant ineligible for the position. BCforward is an equal opportunity employer. Any subsequent offer of employment shall be considered employment at will regardless of the anticipated assignment duration.

Interested candidates please send resume in Word format Please reference job code 223308 when responding to this ad.