Sign upLog in

Data Warehouse Architect 3

Sunrise Systems Inc

Lansing, MI

Apply
JOB DETAILS
SKILLS
Bash Scripting, Business Solutions, Cloud Computing, Data Mining, Data Recovery, Data Warehousing, Database Extract Transform and Load (ETL), Decision Support, Disaster Recovery, Ecosystems, Identify Issues, 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
2 days ago
Job Title: Data Warehouse Architect 3
Job ID: 26-03333
Location: Lansing, MI, 48917
Duration: 12 months of contract
 
Job Description
 
Top Skills
 
  • Teradata database
  • Teradata Tools and Utilities (TTU)
  • Teradata backup & recovery
  • Performance tuning and resource optimization
  • Extract Transform Load (ETL)

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 by DTMB 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, DTMB 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.
 
Contact:
Vinay Kumar:  Vinay.c@sunrisesys.com Direct: (732) 837-0448 | URL: Sunrise Systems Inc.

About the Company

S

Sunrise Systems Inc

Sunrise Systems was founded in 1990 with a clear vision to deliver world-class staffing service solutions in all labor categories, including IT consulting and solutions; all with the commitment to provide service that exceeds expectations and become the most trusted name in the industry. More than two and a half decades later, we pride ourselves on being at the forefront of the staffing industry. Combining our deep industry expertise, insights, and global resources, we have partnered with our clients to connect them with top professionals across several different industries.

We provide cost-effective Managed Staffing Solutions, Information Technology and Information Technology Consulting Services to several Fortune 500 companies and U.S. Government agencies. We provide our clients with flexible engagement models and customized products that are budget and time specific. Understanding the challenges that every business faces, we offer our services either on-site at the clients' site or from one of our globally distributed technology centers. Our onshore and offshore development capabilities ensure that we excel at meeting customer requirements every single time.

Our collective business experience spans over two and a half decades and ranges from:

  • Business, management, and technical fields
  • Information technology consulting and software solutions.
  • Providing strategic support for the development and long-term growth of new business ventures across several industries including but not limited to; accounting, banking, finance, and recruitment.
  • Motivating technology staff and establishing partnerships with Fortune 500 companies

Sunrise Systems has a vast range of competence in:

  • Design, development, and support of cloud-based solutions from simple to highly complexed
  • Database administration of multi-platform applications, complex databases, and web-based environments that include all aspects of installation, planning, maintenance, and monitoring.
  • Data processing and data migration
  • Application re-engineering and platform migration
  • Working with the Information Systems and end-user communities at all levels to resolve issues and establish consensus.
COMPANY SIZE
100 to 499 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
1990
WEBSITE
http://www.sunrisesys.com/

Resume Resources

Free Resume TemplatesFree Resume Builder