Sr 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
