Sr Middleware Architect

Senior Middleware ArchitectInformation TechnologyRALEIGH, North CarolinaDescriptionPosition SummaryMartin 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 bothOracle 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 solutionsMinimum Education and Experience? Bachelor’s degree in Computer Science or Information SystemsMinimum 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 ReportsEqual Opportunity Employer/Veterans/Disabledrecblid xf9wu9811kv3u8b2jq3du8pnhtk3nz