JobCubby JobCubby
Sign up
Subaru

DB2 LUW and SQL Server Database Administrator

Subaru Lafayette, Indiana, United States

Motor Vehicle Manufacturing · 5,001-10,000 employees

5 d ago
dba Senior (5-10 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.

About the role

The Database Administrator will manage, maintain, and optimize DB2 LUW and SQL Server environments while ensuring system security and availability. They will also design data integration pipelines and develop automation scripts to streamline infrastructure maintenance and cloud data movement.

What they look for

DB2 LUW SQL Server Database Administration Performance Tuning ETL/ELT Pipelines PowerShell Bash Python T-SQL Cloud Integration Database Security Automation Scripting DB2CDC Index Optimization Physical Database Design

Requirements

Candidates must hold a bachelor's degree in a technical field and possess at least 4 years of SQL Server experience alongside 5 years of DB2 LUW administration. Proficiency in T-SQL, database tuning, and automation scripting is required for this role.

Full description

DB2 LUW and SQL Server Database Administrator

Information Technology Department

Position Summary:

The Database Administrator is responsible for the installation, maintenance, performance optimization, and security of DB2 LUW, DB2CDC, and Microsoft SQL Server environments supporting critical business operations. This role develops automation solutions, manages database infrastructure, and designs data integration pipelines that enable seamless movement of data from legacy systems to cloud platforms. The position also provides operational support for production environments.

Outline of duties:

  • Installation & Infrastructure Maintenance: Install, configure, and upgrade DB2 LUW instances, fix packs, and Microsoft SQL Server environments (2016 through 2022).
  • Maintain DB2CDC environment ensuring system availability
  • Performance Engineering: Monitor, troubleshoot, and optimize database performance using native utilities including DB2 Explain, Execution Plans, Profiler, and Extended Events.
  • Cloud Integration: Design, build, and maintain robust ETL/ELT pipelines to extract data from legacy systems and load it seamlessly into cloud environments.
  • Database Automation & Scripting: Develop and implement automation scripts using PowerShell, Bash, or Python to streamline routine maintenance, backups, and deployments.
  • Security & Compliance: Enforce enterprise database security controls and user access management policies.
  • Operational Support: Participate in an on-call rotation schedule to deliver 24/7 technical support for business-critical production environments.
  • All other duties as assigned.

Minimum Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, or an equivalent technical field.
  • 4+ years of hands-on experience administering Microsoft SQL Server environments and 5+ years of dedicated DB2 LUW database administration.
  • Core Technical Skills: Deep proficiency in T-SQL, advanced SQL tuning, physical database design, index optimization, and fundamental DB2 utilities (LOAD, EXPORT, RUNSTATS).
  • Operating Systems: Strong command of command-line operations and automation scripting

Desired Qualifications:

  • Cloud Platforms: Hands-on operational experience architecting or managing data services within Microsoft Azure.
  • Certifications: Professional industry credentials such as Microsoft Certified: Azure Database Administrator Associate or IBM Certified Database Administrator (v11.x).

Subaru of Indiana Automotive, Inc. is an equal opportunity employer committed to employing a diverse workforce.

Similar roles