About MDA Edge
Sourced by ZipRecruiter
Industry
Custom software development services
Company size
51 - 200 Employees
Headquarters location
Los Altos, CA, US
Job description
Job Summary:
MDAEdge is a company seeking a SQL Server Database Engineer to join their Data Services Team within the Technology Services department. The role involves developing and maintaining a custom Student Information System, working closely with application developers and technical teams to improve system architecture and deliver quality software products.
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:
Required:
• 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...
• 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.
Preferred:
• 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.
Company:
The world doesn't have a talent shortage. It has a talent alignment problem. MDA Edge exists to fix that. Founded in , the company is headquartered in Sheridan, WY, US, , with a team of 51-200 employees. The company is currently Growth Stage.
MDAEdge is a company seeking a SQL Server Database Engineer to join their Data Services Team within the Technology Services department. The role involves developing and maintaining a custom Student Information System, working closely with application developers and technical teams to improve system architecture and deliver quality software products.
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:
Required:
• 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...
• 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.
Preferred:
• 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.
Company:
The world doesn't have a talent shortage. It has a talent alignment problem. MDA Edge exists to fix that. Founded in , the company is headquartered in Sheridan, WY, US, , with a team of 51-200 employees. The company is currently Growth Stage.
mdaedge.com
Frequently asked questions
Q: What skills or qualities help someone succeed as a Database Engineer?
A: To succeed as a Database Engineer, key technical skills include proficiency in database management systems (DBMS) such as MySQL, PostgreSQL, or MongoDB, as well as expertise in data modeling, normalization, and query optimization. Additionally, strong programming skills in languages like Java, Python, or C++ are essential for developing database applications and scripts. Soft skills like effective communication, problem-solving, and collaboration are also crucial for working with cross-functional teams to design, implement, and maintain databases that meet business requirements.\n\nThese technical and soft skills enable Database Engineers to design and develop scalable, efficient, and secure databases that support business growth and innovation, ultimately driving career growth and effectiveness in the role.
Q: What is the career path for a Database Engineer?
A: A Database Engineer's typical career progression involves starting as a Junior Database Engineer or Database Administrator, where they design, implement, and maintain databases to support business applications. As they gain experience, they can move into mid-level roles such as Senior Database Engineer or Database Architect, where they lead database design, optimization, and scalability efforts. Ultimately, senior Database Engineers can transition into leadership positions like Technical Lead or Director of Database Engineering, overseeing database strategy and team management, or pursue specialized roles like Data Scientist or Cloud Architect.