DB2 LUW and SQL Server Database Administrator
At a glance
Mid-level Data Architecture & Governance role at Subaru of Indiana Automotive. Lafayette · no salary stated · we estimate $99,650–$155,000 across the United States.
Subaru of Indiana Automotive has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Install, configure and update DB2 LUW and SQL Server environments, while keeping DB2CDC available
- Use database utilities and diagnostic tools to investigate slowdowns and improve performance
- Build and maintain ETL/ELT workflows that move information from legacy systems into cloud environments
- Write scripts in PowerShell, Bash or Python to automate maintenance, backups and deployments
- Apply database access controls and provide production support through an on-call rotation
What you bring
- A bachelor's degree in computer science, information technology or another technical field
- At least four years administering SQL Server and five years focused on DB2 LUW administration
- Strong T-SQL, SQL tuning, database design, index optimization and DB2 utility skills
- Command-line fluency and the ability to automate tasks with scripts
Who this fits
This mid-level administrator role suits someone with substantial hands-on experience in both SQL Server and DB2 LUW. You'll take part in an on-call rotation providing round-the-clock support for production systems.
From the employer
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.
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.