Current jobs related to Senior Data Warehouse Teradata Database Administrator - Springfield - AB2 Consulting, Inc.

  • Senior Database Administrator

    3 weeks ago

    Springfield, Illinois, United States Leidos Holding Full time

    Job Title: Senior Database AdministratorWe are seeking a highly skilled Senior Database Administrator to join our team at Leidos Holding. As a key member of our database team, you will be responsible for designing, structuring, and maintaining our enterprise database systems.Key Responsibilities:Collaborate with database administrators and subject matter...

  • Senior Data Warehouse Developer

    2 weeks ago

    Springfield, Illinois, United States State of Illinois Full time

    Job Title: Senior Data Warehouse DeveloperJoin the State of Illinois team as a Senior Data Warehouse Developer and contribute to the development of data warehouse systems and models using SSRS, SSIS, Power BI, and SQL department-wide systems used in enterprise operations.Key Responsibilities:Provides analysis, development, and support of data warehouse...

  • Database Administrator

    3 weeks ago

    Springfield, United States Springfield Public Schools, MO Full time

    Job Title: Database AdministratorDepartment: Information Systems Pay Grade: P150 FLSA Status: Exempt Reports to: Manager IV - Information Systems Development GENERAL PURPOSE Responsible for overseeing database administration tasks; this role involves monitoring and maintaining database performance, and implementing necessary optimizations. Tasked with...

  • Senior Database Architect

    2 weeks ago

    Springfield, Virginia, United States Connect Talent Solutions Full time

    Job OverviewAt Connect Talent Solutions, we are seeking a highly skilled Senior Database Architect to join our team. As a key member of our data infrastructure team, you will be responsible for designing, implementing, and administering databases to support our business operations.The ideal candidate will have a strong background in database management, with...

  • Senior Database Manager

    1 week ago

    Springfield, Virginia, United States Connect Talent Solutions Full time

    Job Title: Senior Database ManagerJob Summary:Connect Talent Solutions is a fast-growing, innovative staffing firm offering direct placement, contract, and contract-to-hire solutions. We are uniquely positioned and experienced to support your requirements from IT and engineering to general labor and customer service positions.Key Responsibilities:Manage the...

  • Senior Data Warehouse Developer

    1 week ago

    Springfield, Illinois, United States State of Illinois Full time

    Job SummaryThe State of Illinois is seeking a highly skilled Senior Data Warehouse Developer to join our team. As a key member of our Information Technology department, you will be responsible for designing, developing, and maintaining our data warehouse systems. Your expertise will be crucial in ensuring the accuracy and efficiency of our data management...

  • Database Administrator, Senior

    2 weeks ago

    Springfield, Illinois, United States Praescient Analytics Full time

    Praescient Analytics is seeking a highly skilled Senior Database Administrator to join our team in supporting the Return Review Program (RRP) for an IRS contract.RRP is a mission-critical, automated system that detects and selects potentially fraudulent returns to prevent/stop the issuance of invalid refunds.The successful candidate will administer, develop,...

  • Senior SQL Database Administrator

    2 weeks ago

    Springfield, Illinois, United States ManTech Full time

    Job SummaryManTech is seeking a highly skilled Senior SQL Database Administrator to join our team. As a Senior SQL Database Administrator, you will be responsible for designing, developing, and deploying database solutions to improve organizational knowledge sharing and awareness.The ideal candidate will have 7+ years of experience as a database...

  • Senior Database Developer

    3 months ago

    Springfield, United States Krasan Consulting Services Full time

    We have an opening for a Senior Database Developer with our direct client, the Illinois State Board of Education-(State of Illinois).Job Title: Senior Database DeveloperProject: Early Childhood Programs Job Type: Contract- W2Location: 100 N. 1st Street, Springfield, IL – OnsiteDuration: 2 yearsJob Description:We are seeking Senior Database Developers for...

  • Senior Database Developer

    3 months ago

    Springfield, United States Krasan Consulting Services Full time

    We have an opening for a Senior Database Developer with our direct client, the Illinois State Board of Education-(State of Illinois).Job Title: Senior Database DeveloperProject: Early Childhood Programs Job Type: Contract- W2Location: 100 N. 1st Street, Springfield, IL - OnsiteDuration: 2 yearsJob Description:We are seeking Senior Database Developers for at...

  • Database Administrator

    5 months ago

    Springfield, United States CoxHealth Full time

    Summary Best in Class Work Environment5x Modern Healthcare Best Places to workAmerica’s Greatest Workplaces 2023 – NewsweekBest Employers for New Grads 2023- ForbesGreatest Workplace for Women 2023 - Newsweek Benefits Robust, fully customizable benefits package including Medical/Vision/Dental and more!No cost eCare visitsEmployer-provided mental health...

  • Senior Database Developer

    4 weeks ago

    Springfield, Illinois, United States Krasan Consulting Services Full time

    Job Title: Senior Database DeveloperWe are seeking a highly skilled Senior Database Developer to join our team at Krasan Consulting Services. As a Senior Database Developer, you will be responsible for designing, implementing, and managing complex databases to support our clients' business needs.Key Responsibilities:Design and implement databases using Azure...

  • Senior Data Automation Specialist

    2 weeks ago

    Springfield, Virginia, United States Innovative Data Solutions LLC Full time

    We are seeking a highly skilled Senior Data Automation Specialist to support our mission critical IT infrastructure for the US Government Intelligence, Defense and Homeland Security communities.The ideal candidate will have experience in designing and implementing automation solutions to enhance data capture, data refinement, and processes. Key...

  • Senior Database Developer

    1 month ago

    Springfield, Illinois, United States Krasan Consulting Services Full time

    Job Title: Senior Database DeveloperWe are seeking a highly skilled Senior Database Developer to join our team at Krasan Consulting Services. As a Senior Database Developer, you will play a critical role in designing, implementing, and maintaining complex databases to support our clients' business needs.Key Responsibilities:Design and implement databases...

  • Senior Database Developer

    3 weeks ago

    Springfield, Illinois, United States Krasan Consulting Services Full time

    Job Title: Senior Database DeveloperWe are seeking a highly skilled Senior Database Developer to join our team at Krasan Consulting Services. As a Senior Database Developer, you will play a critical role in designing, implementing, and maintaining complex databases to support our clients' business needs.Key Responsibilities:Design and implement databases...

  • Oracle Database Architect

    2 weeks ago

    Springfield, Illinois, United States Parsons Company Full time

    Job Description:As a Database Administrator for Parsons, you will be responsible for designing, implementing, and maintaining large-scale database systems to support our federal government customers. Your expertise in Oracle databases will be crucial in ensuring the security, performance, and reliability of our systems.Key Responsibilities:Design and...

  • Database Systems Administrator

    1 week ago

    Springfield, Illinois, United States Illinois Secretary of State Full time

    Job Title: Database Systems AdministratorDivision: Data Center ServicesJob Summary:As a Database Systems Administrator at the Illinois Secretary of State, you will serve as a technical expert in database design and implementation. You will participate in the utilization of advanced programming languages and systems, and programming techniques to build and...

  • Oracle Database Administrator

    2 weeks ago

    Springfield, Illinois, United States Swingtech Consulting Full time

    Job Title: Oracle Database AdministratorJob Summary:Swingtech Consulting is seeking an experienced Oracle Database Administrator to support the Financial Services Modernization Branch – Cost Analysis & Research Section. The successful candidate will be responsible for managing and optimizing Oracle databases (version 19 or later), supporting payroll and...

  • Senior Systems Administrator

    2 weeks ago

    Springfield, Illinois, United States Innovative Data Solutions, Inc. Full time

    Job SummaryWe are seeking an experienced Systems Administrator to support our mission-critical IT infrastructure for the US Government Intelligence, Defense, and Homeland Security communities.This position requires a TS/SCI clearance and eligibility to obtain a CI polygraph.Key Responsibilities:Provide on-site and remote resolution support for trouble calls...

  • Database Administrator DB2/SQL

    2 weeks ago

    Springfield, Illinois, United States Illinois Secretary of State Full time

    Job Title:Database Administrator DB2/SQLJob Summary:We are seeking a highly skilled Database Administrator to join our team at the Illinois Secretary of State. The successful candidate will be responsible for designing, implementing, and maintaining databases to support various user departments.Key Responsibilities:Design and build new databases, including...

Senior Data Warehouse Teradata Database Administrator

3 months ago

Springfield, United States AB2 Consulting, Inc. Full time
Job DescriptionJob Description

Primary Responsibilities:

  • Manage, monitor, and maintain OnPrem Teradata hardware/software including patches, replacements, and upgrades with support from Teradata.
  • Plan and execute tasks required to ensure the Teradata system is operational including occasional evening and weekend support for Teradata maintenance.
  • Provide direction to developers on Operational and Design, Development, and Implementation projects to ensure best use of the Teradata system including review/approval of SQL code.
  • Performing database backup and recovery operations using the BAR DSA and NetBackup.
  • Developing of pro-active processes for monitoring capacity and performance tuning.
  • Providing day-to-day support for the EDW users problems like job hands, slowdowns, inconsistent rows, re-validating headers for tables with RI constraints, PPIs and configuration.
  • Maintaining rules set in the Teradata Active System Management (TASM) and supporting workload management.
  • Maintaining the Teradata Workload Manager with the proper partitions and workloads based on Service Levels.
  • Supporting the database system and application server support for the Disaster Recovery (DR) build/test, annual drill, and quarterly maintenance as needed.
  • Actively monitoring the health of the Teradata system and Teradata Managed Servers (TMS) using Viewpoint and other tools and application servers and make preventive or corrective actions as needed.
  • Maintaining access rights, role rights, priority scheduling, and reporting using dynamic workload manager, Database Query Log (DBQL), usage collections and reporting of ResUsage, AmpUsage, security administration etc.
  • Coordinating with the team and customers in supporting database needs and make necessary changes to meet the business, contractual, security, performance, and reporting needs.
  • Supporting internal or external audit process and address vulnerabilities or risk proactively.
  • Prepare and support IRS audit.
  • Coordinating with Teradata to perform Teradata system hardening and delivery of Safeguard Computer Security Evaluation Matrix (SCSEM) Reports as needed, addressing issues in the hardening and vulnerability scan report.
  • Generating and maintaining capacity management, Space, and CPU reports on analyzing the Spool, CPU, I/O, Usage, and Storage resources and proactive monitoring to meet performance and growth requirements.
  • Reviewing and resolving Teradata alerts and communicate any risk / issues or impact to the management, team, and business users through appropriate communication strategy.
  • Performing additional duties that are normally associated with this position, as assigned.

Functional Description:

The DBA is responsible for the overall database delivery of the Enterprise Data Warehouse for the Medicaid agency. It is a critical role involving expertise in working with Medicaid data itself, security, supporting and maintaining hardware and software, and ensuring we are achieving the optimal performance. For example, the DBA is expected to provide a wide range of expertise including the ability to help a user to fetch data (requiring business knowledge) and the technical ability to support a major Teradata upgrade. This role requires regular onsite presence in Springfield, Illinois to perform backup/restore and support onsite maintenance by Teradata (and its subcontractors).

Required Qualifications:

  • Bachelor's degree or equivalent work experience
  • Proven experience of at least 6 8 years as primary Teradata DBA
  • 3+ years of experience as a Teradata DBA on Version 15+
  • 3+ years of experience with Teradata Intelliflex
  • 5+ years of experience writing complex SQL using SQL Assistant/Teradata Studio
  • 3+ years of experience extracting, loading, and transforming structured/unstructured data using Teradata Utilities (FastLoad, Multiload, FastExport, BTEQ, TPT) in a Unix/Linux environment
  • 3+ years of experience performance tuning in a large database (>5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans
  • 3+ years of experience analyzing project requirements and developing detailed database specifications
  • 3+ years of experience identifying and initiating resolutions to customer problems and concerns associated with a query or database business need
  • Data Warehouse or equivalent system experience
  • Location required is Springfield, IL

Preferred Qualifications:

  • Teradata Vantage Certified Master
  • Experience upgrading to Teradata Intelliflex
  • 3+ years identifying and initiating resolutions to customer problems and concerns associated with a Data Warehouse or equivalent system
  • 5+ years logical and physical data modeling experience
  • 5+ years with Erwin or other data modeling software
  • 3+ years working with end users/customers to understand requirements for technical solutions to meet business needs
  • 3+ years working with technical developers to strategize solutions to align with business requirements
  • 3+ years defining standards and best practices and conducting code reviews
  • Experience in Application Server Hardware/Software Administration (Windows/Linux)
  • Experience with State Medicaid / Medicare / Healthcare applications
  • Excellent verbal/written communication, end client facing, team collaboration, and mentoring skills