Senior Middleware Architect

Martin Marietta   Raleigh, NC   Full-time     Information Services / Technology (IT)
Posted on June 30, 2024
Apply Now

Senior Middleware Architect

Information Technology

RALEIGH, North Carolina

 

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


Martin Marietta

Raleigh , NC
" "