Role overview

Qualifications

3plus years of experience in Microsoft SQL Server environment with primary focus on development
Very strong skills in T-SQL development, including query optimization
Experience in DevOps area including CI/CD pipelines, powershell, Azure DevOps (ADO)
Strong verbal and written communication skills

Responsibilities

Develop, maintain, and update SQL Server stored procedures, views, SSIS packages, and SSRS reports
Identify opportunities to make improvements in T-SQL code and implement them
Design, build, and implement databases to support new software development
Optimize the reports and underlying stored procedures that take longer to run

Key facts

Remote from: Michigan (USA)
Full time
Mid-level (2-5 years)
Data Engineer
English

Hard skills

SQL (Programming Language)

About the company

MDA Edge

Our objective is to establish an exceptional ecosystem by connecting individuals, technology, and prospects through the application of human intelligence.MDA Edge is a process-oriented company and our expertise lies in providing comprehensive Workforce Solutions, specifically focusing on Contingent Staffing, Bulk/Project Staffing, RPO/KPO/BPO, and Direct Hire services. We cater to a wide range of industries, including Infrastructure Consulting, Engineering Consulting, IT Consulting, Healthcare, Life Sciences, Pharmaceutical Consulting, Consumer Goods, Education, Transportation & Logistics, Media & Entertainment, Telecom, BFSI, Manufacturing, Utilities & Energies, and Corporate Recruitment. Moreover, we have developed a dedicated focus on Government Consulting.Our company prides itself on a meticulous approach, ensuring that we meet your specific needs. We have established a robust network of highly skilled professionals who are readily available to fulfill your requirements. With a strong commitment to excellence, we consistently deliver exceptional results for clients in India, Denmark, France, Germany, Ireland, Japan, Spain, Thailand, the USA, Canada and Mexico, with ongoing expansion efforts to serve more new regions in the near future.We consistently uphold the highest standards of quality by providing resources, time, and materials to design, implement, and support efficient operations for organizations. Our track record of measurable accomplishments demonstrates our commitment to cultivating a balanced work and societal ecosystem.Our continuous growth, successful customer engagements, and strong customer retention exemplify our achievements. Furthermore, our passion lies in streamlining complex business processes through the application of suitable technology, which has been integral to our success.We extend an invitation to join our dynamic workplace, offering rapid growth opportunities, excellent employee benefits, and a positive work-life balance.

Company details

Company typeScaleup

Company size201 - 500

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Job Summary:

Database Engineer will be a part of the Data Services Team within the Technology Services department.
This position will report directly to the Manager of Data Services and be part of a team of IT Data professionals responsible for development and maintenance of a custom Student Information System.
In this role, you will be working on an agile software development team and developing software products.
The Database Engineer is a detail-oriented problem solver as well as a visionary focused on finding ways to improve system architecture and build a solid backbone to our data systems.
The mission of the Database Engineer is to work closely with a team of application developers and technical teams to address high-impact problems using thoughtful and informed analysis.
This role requires someone with a penchant for improving existing systems and processes where possible.
Success in this role is also dependent on being organized and conducting regular communication with cross functional product teams and to deliver great software products.

DUTIES AND RESPONSIBILITIES:

Develop, maintain, and update SQL Server stored procedures, views, SSIS packages, and SSRS reports.
Identify opportunities to make improvements in T-SQL code and implement them.
Design, build, and implement databases to support new software development.
Complete SSRS Report writing, which includes an understanding of the underlying data, data structure and business terminology.
Optimize the reports and underlying stored procedures that take longer to run.
Troubleshooting data issues, validating result sets, performing unit testing.
Help write and optimize in-application SQL statements.
Collaborate with other team members and stakeholders.

QUALIFICATIONS:

3+ years of experience in Microsoft SQL Server environment with primary focus on development.
Very Strong skills in T-SQL development, including query optimization, building and modifying stored procedures, functions, and creating tables and views.
Advanced knowledge of T-SQL, including transactions, (begin..try, merge, common table expressions, ROW_NUMBER/OVER, bulk insert, filtering and covering indexes, computed columns, etc..).
Experience in DevOps area including CI/CD pipelines, powershell, Azure DevOps (ADO), etc...
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Strong experience in providing ownership, management, design, development and support to OLTP systems.
Ability to navigate and understand large complex database structures for sourcing data.
Experience in Agile development environment.
Strong verbal and written communication skills, with an ability to express complex technical concepts in business terms and complex business concepts in technical terms.
Excellent problem solving and root cause analysis skills.
Excellent written and verbal communication.
Flexible, team player, "get-it-done” personality.
Ability to multi-task and context-switch effectively between different activities and teams.
Microsoft certifications are a plus Please click here to learn more about our core values.

Must Have Skills:

Minimum of 3 years of experience in Microsoft SQL Server environment.
Very strong skills in T-SQL development.
Experience in DevOps area including CI/CD pipelines, powershell, Azure DevOps (ADO).

Nice to Have Skills:

Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Strong experience in providing ownership, management, design, development and support to OLTP systems.
Ability to navigate and understand large complex database structures for sourcing data.
Experience in Agile development environment.