DB2 LUW and SQL Server Database Administrator

Subaru • Lafayette, IN

6d

About The Position

The Database Administrator is responsible for installing, maintaining, optimizing the performance of, and securing DB2 LUW, DB2CDC, and Microsoft SQL Server environments that support critical business operations. The role develops automation solutions, manages database infrastructure, and designs data integration pipelines to move data from legacy systems to cloud platforms. It also provides operational support for production environments and participates in an on-call rotation providing 24/7 technical support for business-critical production environments.

Requirements

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

Nice To Haves

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

Responsibilities

• Install, configure, and upgrade DB2 LUW instances, fix packs, and Microsoft SQL Server environments (2016 through 2022).
• Maintain the DB2CDC environment to ensure system availability.
• Monitor, troubleshoot, and optimize database performance using native utilities, including DB2 Explain, Execution Plans, Profiler, and Extended Events.
• Design, build, and maintain ETL/ELT pipelines to extract data from legacy systems and load it into cloud environments.
• Develop and implement automation scripts using PowerShell, Bash, or Python to streamline routine maintenance, backups, and deployments.
• Enforce enterprise database security controls and user access management policies.
• Participate in an on-call rotation to provide 24/7 technical support for business-critical production environments.
• Perform all other duties as assigned.

What This Job Offers

• Job Type: Full-time