Senior Middleware Architect
Martin Marietta Materials

Job Info

---

Senior Middleware Architect

Information Technology

RALEIGH, North Carolina

Description

Position Summary

Martin Marietta Materials, Inc. is seeking a Senior Middleware Architect for a position at the company's Raleigh headquarters. The Senior Middleware Architect will design, develop and deploy ETL software, and reports needed to support a variety of business needs. This position requires extensive work with T-SQL and PL/SQL in an SQL Server and Oracle database environments. In addition, this person must be able to work independently or within small teams.

Job Duties

\u25CF Design, develop and implement ETL/ ELT solutions for data ingestion, cleansing, business rules execution and data distribution.

\u25CF Design, develop, test and support programs and services using Visual Studio, Microsoft .NET, C#.

\u25CF Design and develop SSIS Packages

\u25CF Design and develop SSRS Reports

\u25CF Build database solutions on prem and in Azure cloud.

\u25CF Write complex SQL statements, procedures, and packages in both

Oracle and Sql Server databases.

\u25CF Gather requirements and business process knowledge in order to transform the data in a way that's geared towards the needs of end users.

\u25CF Maintain and improve already existing processes.

\u25CF Create technical specification documents.

\u25CF Unit tests and regression tests software solutions

Minimum Education and Experience

\u25CF Bachelor's degree in Computer Science or Information Systems

Minimum Requirements

\u25CF 6+ years of experience using Microsoft Technologies (SQL Server and Visual Studio)

\u25CF 6+ years of experience using SQL Server Reporting Services (SSRS).

\u25CF 6+ years of experience using SQL Server Integration Services (SSIS).

\u25CF 6+ years of experience writing stored procedures, packages, functions, creating tables, indexes and views in both Microsoft Transact-SQL and within Oracle PL/SQL

\u25CF 6+ years of experience within Microsoft C# .NET development

\u25CF 3+ years of experience developing scripts in PowerShell

\u25CF 2+ years of experience tuning and optimizing complex queries using Query Execution Plan and SQL Profiler.

\u25CF 2+ years of experience involving SSIS packages with C# script tasks.

\u25CF 2+ years of experience setting up and manage SQL Server Agent Jobs.

Preferred Skills

\u25CF Experience with application integration using ETL, middleware, APIs, REST web services.

\u25CF Experience using code versioning tools, preferably with Azure DevOps

\u25CF Experience deploying, integrating and supporting ECM solutions such as Hyland Onbase

\u25CF Experience with application and database security

\u25CF Experience with report development within Power BI, Tableau, and Crystal Reports

Equal Opportunity Employer/Veterans/Disabled

This job has expired.