What are the responsibilities and job description for the Database Engineer position at Artech L.L.C.?
Job Family Description: Database Engineer
Bill rate flexible - 100 usd cap
Polaris McCoy Center (54101) - ONLY
RTH at 602 - The role not eligible for Client employer sponsored immigration support
Preferred qualifications, capabilities, and skills
Casual
Roles and Responsibilities: see JD
Category
Name
Required
Importance
Level
Last Used
Experience
Database Platforms Oracle No 1 Intermediate 5-6 Within 1 Year
Packaged Applications Informatica No 1 Intermediate 5-6 Within 1 Year
Programming Languages Data Modeling Yes 1 Intermediate 7-8 Currently Using
Protocols SQL Server No 1 Intermediate 7-8 Currently Using
Specialties Data Analysis Yes 1 Intermediate 7-8 Currently Using
Specialties Development Yes 1 Intermediate 7-8 Currently Using
Specialties SQL Query Yes 1 Intermediate 7-8 Currently Using
Specialties Architecture No 1 Intermediate 5-6 Within 1 Year
Specialties DBA No 1 Intermediate 5-6 Within 1 Year
Specialties Logical Design No 1
Additional Skills: see above
Bill rate flexible - 100 usd cap
Polaris McCoy Center (54101) - ONLY
RTH at 602 - The role not eligible for Client employer sponsored immigration support
- hybrid: MTT - Day 1 in the office & hybrid model observance is a MUST
- Interview process- 3 rounds : 1- HM- behavioral/general tech; 2 - technical - panel-HM + Team; 3 2 line manager - all zoom
- 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
- CICD and data warehouse concept
- ETL knowledge
- 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.
- 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.
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.
- 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.
Casual
Roles and Responsibilities: see JD
- Either skills or additional skills are required
Category
Name
Required
Importance
Level
Last Used
Experience
Database Platforms Oracle No 1 Intermediate 5-6 Within 1 Year
Packaged Applications Informatica No 1 Intermediate 5-6 Within 1 Year
Programming Languages Data Modeling Yes 1 Intermediate 7-8 Currently Using
Protocols SQL Server No 1 Intermediate 7-8 Currently Using
Specialties Data Analysis Yes 1 Intermediate 7-8 Currently Using
Specialties Development Yes 1 Intermediate 7-8 Currently Using
Specialties SQL Query Yes 1 Intermediate 7-8 Currently Using
Specialties Architecture No 1 Intermediate 5-6 Within 1 Year
Specialties DBA No 1 Intermediate 5-6 Within 1 Year
Specialties Logical Design No 1
Additional Skills: see above
Database Administrator
Big Lots -
Columbus, OH
Database Architect
Northwest Bank -
Columbus, OH
Database Developer I
Stellar Consulting Solutions, LLC -
Baltimore, OH
