Database Engineer plans, designs, develops, and manages an organization's databases to ensure efficient data storage, access, and security. Collaborates with users to design, code, test, debug, and deploy databases that meet requirements and organizational needs. Being a Database Engineer writes queries, stored procedures and functions for database development. Monitors databases' performance, scalability, and security and modifies procedures to optimize database designs. Additionally, Database Engineer evaluates existing database design to determine necessary updates, performance tuning, and integration requirements. Possesses comprehensive knowledge of database technologies and solid coding and computer system skills. Requires a bachelor's degree. Typically reports to a manager. The Database Engineer work is closely managed. Works on projects/matters of limited complexity in a support role. To be a Database Engineer typically requires 0-2 years of related experience. (Copyright 2024 Salary.com)
Job Title: Database Engineer
Location: Columbus, OH (Hybrid)
Duration: 6 months contract to hire Job Description:
Supplier Notes:
handling database
Tunning, creating table.
data modelling
public cloud - AWS preferred.
Columbus, OH
Postgres database
Python knowledge
5-6 years total 10 years
M, T, T
3 rounds of interview
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.
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, analyse, 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.