Sign upLog in

Data Warehouse Architect

PSR Associates Inc

Lansing, MI

Apply
JOB DETAILS
SKILLS
Bash Scripting, Business Solutions, Cloud Computing, Consulting, Data Mining, Data Recovery, Data Warehousing, Database Extract Transform and Load (ETL), Decision Support, Disaster Recovery, Ecosystems, Identify Issues, Information Technology & Information Systems, Linux Operating System, Medicaid, Microsoft Windows Azure, NCR Teradata, Operating Systems, Performance Analysis, Performance Tuning/Optimization, Perl Programming Language, Problem Solving Skills, Python Programming/Scripting Language, Release Management/Engineering, Resource Management, Security Auditing, Software Administration, Software Patches, Statistics, Strategic Planning, Systems Administration/Management, Technical Support, Testing, U.S. National Institute of Standards and Technology (NIST), Unix Operating Systems
LOCATION
Lansing, MI
POSTED
Today
PSR Associates is a consulting and talent solutions firm that connects qualified IT professionals with great opportunities. Whether you're looking for a contract or permanent position, we can help you find the right fit for your skills and experience. We have a team of experienced recruiters who know the IT industry inside and out, and we work with you every step of the way to ensure a smooth and successful transition. PSR Connecting Talent, Crafting Success.

Data Warehouse Architect

We are seeking a Data Warehouse Architect to join our team. The selected candidate will work a hybrid schedule consisting of two (2) days each week onsite (Tuesdays and Wednesdays). Lansing, MI and three (3) days each week remotely.

The state maintains an enterprise data warehouse built on the Teradata ecosystem. Below is a list of services; however, this list is not exhaustive.

8+ years required for the following:
  • Teradata database
  • Upgrades, provisioning, software maintenance, scripting BASH, Perl, Python, Glink
  • Teradata ecosystem health monitoring
  • Teradata node management
  • Teradata Viewpoint administration
  • Teradata Tools and Utilities (TTU)
  • PSIM (Platform Service Intelligent Monitoring) administration
  • Teradata vendor upgrades
  • Teradata workload management
  • Teradata backup & recovery
  • Performance tuning and resource optimization
  • Extract Transform Load (ETL)
  • Unix/Linux knowledge
  • Cloud computing fundamentals, resource allocation, networking, preferably MS Azure
  • Statistics
  • Audits & security plans
  • Federal requirements NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc.

The Enterprise Data Warehouse (EDW) service offered provides customers with the ability to conduct high performance analytics, data mining activities, and enhanced decision support capabilities. Currently, the EDW service employs Teradata technology.

This position will serve as a platform administrator for the EDW, consisting of 3 distinct platforms (Production, Development/Disaster Recovery, and Test). The EDW provides enterprise data warehousing services to executive branch department as well as the State Court Administrator Offices statewide. A total of 7 departments are supported, with a user base of over 10,000 and 40 Terabytes of data. This position researches and coordinates long term EDW strategies with all current and potential users, management and vendor personnel. This position defines the technical planning, implementation plan, and delivery of the EDW platform services and supporting technologies to meet the State of Michigan s business requirements and objectives. This includes vendor communication, trouble reporting, escalated troubleshooting, and release/patch management. This position is responsible for providing operating system guidance along with EDW security expertise for the systems as well as advising the Agencies on disaster recovery planning strategies related to the EDW and their business applications. The position is also responsible for platform performance monitoring and resolving performance issues. This position provides direct technical expertise to department DBAs and specialists across the enterprise.


*** Please note that any false information on your resume or application could lead to the offer being withdrawn or even termination after hire.***




About the Company

P

PSR Associates Inc

Resume Resources

Free Resume TemplatesFree Resume Builder