DB2 LUW and SQL Server Database Administrator
Subaru of Indiana Automotive
Lafayette, IN, United States
10 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.indeed.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
4 years minimum
Working hours
Regular working hours
Job source
Tech stack
Automation of Tests
Microsoft Azure
Backup Devices
Bash Shell
Cloud Computing
Profiling
Databases
Data as a Services
Data Infrastructure
Data Integration
Extract Transform Load (ETL)
IBM DB2
+16 more
Database Security
Python (Programming Language)
Microsoft SQL Server
SQL Azure
Performance Tuning
Windows PowerShell
Transact-SQL
Scripting
Cloud Platform System
System Availability
Database Performance
Information Technology
Cloud Integration
Data Pipelines
Legacy Systems
User Administration
Job description
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.
Requirements
- 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).
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.indeed.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦