Senior Middleware Architect

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

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

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

● Design and develop SSIS Packages

● Design and develop SSRS Reports

● Build database solutions on prem and in Azure cloud.

● Write complex SQL statements, procedures, and packages in both

Oracle and Sql Server databases.

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

● Maintain and improve already existing processes.

● Create technical specification documents.

● Unit tests and regression tests software solutions

Minimum Education and Experience

● Bachelor's degree in Computer Science or Information Systems

Minimum Requirements

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

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

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

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

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

● 3+ years of experience developing scripts in PowerShell

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

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

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

Preferred Skills

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

● Experience using code versioning tools, preferably with Azure DevOps

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

● Experience with application and database security

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

Equal Opportunity Employer/Veterans/Disabled