DB2 LUW and SQL Server Database Administrator
Subaru of Indiana Automotive
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.
Vacancy posted 6 days ago
Similar jobs that could be interesting for youBased on the DB2 LUW and SQL Server Database Administrator in Lafayette, IN vacancy
- IPMG is looking for a skilled and detail-oriented IT Systems Administrator to administer, maintain, secure, and improve our internal technology systems. This full-time position plays an important role in supporting Microsoft 365, identity and access management, business...SuggestedFull timeWork at officeRemote workHome officeMonday to FridayFlexible hours
- 1 day ago Be among the first 25 applicants Are you our next System Administrator? Do you love tackling technical challenges to manage IT infrastructure for customers? Are you proactively pursuing the latest breakthroughs in system performance? Can you connect every dot...SuggestedFull timeLocal areaRemote work
- ...an enterprise environment. This position will support PC/laptop hardware and software, deskside break/fix issues, IMAC activities, server and network support, and various IT projects. Key Responsibilities Repair, test, image, and clean PCs, laptops, monitors, printers...SuggestedMonday to FridayFlexible hours
$22 - $23 per hour
...Maintain IT asset inventory and perform hardware replacements, data backups, and end-user data transfers. Provide hands-on support for server and network infrastructure, including installations, configurations, maintenance, and troubleshooting. Assist with server backups,...SuggestedContract workLocal areaImmediate start$21 - $28 per hour
...configurations, upgrades, patch, and other maintenance actives of server equipment Perform backup, recovery, and security procedures... ..., and maintenance of physical network Perform network system administration task both planned or during emergency Skills And Qualifications...SuggestedHourly payMinimum wageWork experience placementWork at officeLocal area$21 - $23 per hour
Location 3701 South Street,Lafayette, IN, 47905,United States Base Pay $21.00 - $23.00 / Hour Job Category Information Technology Employee Type Full-Time Non-Exempt Contact information Phone (***) ***-**** Description POSITION SUMMARY This role requires a combination of...Full timeWork experience placementWork at officeLocal areaFlexible hours$54.32k - $57.71k
Job Summary Purdue IT | West Lafayette, Indiana Under the guidance of Network Operations leadership, the Associate Network Administrator provides operational support for the Purdue University network infrastructure, including wired, wireless, wide area network (WAN), local...Casual workLocal areaNight shiftAfternoon shift- Job Description Job Description Ready to Build a Career, Not Just Take a Job? At Leading Edge Solutions , we’re not your standard tech company—we’re a family-run business that’s been powering the automotive industry for over 22 years . We specialize in supporting...Full timeLocal areaRemote work
Leading Edge Solutions, Inc
Lafayette, IN20 days ago $70.8k
...Position Description: The Database Administrator is responsible for administering maintaining and optimizing database environments in support of enterprise applications and data services. This role applies knowledge of database platforms performance tuning disaster...Full timeContract workWork at officeLocal area- ...processes, and analytical tools utilizing platforms such as Power BI, SQL, Palantir, and related technologies. Collaborate with system... ...reporting platforms. Knowledge of relational and dimensional database design principles. Experience with supply chain modeling,...Work at office
- Job Description Job Description Benefits: Flexible schedule Opportunity for advancement Profit sharing This Is Not Your Average Tech Job Are you a hands-on I.T. or Telecom professional looking for something beyond the desk? AMG Tech Support is seeking...Hourly payFor contractorsImmediate startFlexible hours
HARDY INDUSTRIES
Lafayette, IN3 days ago - ...performance data into a master schedule platform and deliver project/program status reports as required Light programming (e.g., MS Access or SQL) helpful Knowledge of Excel, VBA, and Access for reporting and analysis Excellent verbal and written communication skills Detail‑...Daily paidFull timeTemporary workLocal areaRelocation
$56.6k - $139.3k
...priorities. Preferred Qualifications Bachelors degree in a business-related field or Information Systems Management. Experience with SQL Agile methodologies user stories and test scripts. Ability to explain technical concepts clearly to business and development teams...Full timeLocal areaCogent Infotech
Lafayette, IN23 days ago$82.56k
...applications; using common programming languages, tools, and techniques, such as PHP, JavaScript, Python, Shell scripting, and SQL databases; working with researchers to integrate computing techniques into research activities An equivalent combination of education and...Work at office- ...device management (MDM) for iOS and Android devices within the enterprise environment. • Demonstrate working knowledge of networks, servers, audio/visual systems, smart devices, and telecommunications in support of a broad range of IT needs. • Perform other duties as...Full timeWork experience placementWork at officeLocal areaRemote workAll shiftsShift workAfternoon shift
- ...Salesforce CRM Analytics, Salesforce Reports, Tableau, Snowflake and SQL, this position will take data projects from requirements... ...requirements and solutions. Knowledge and understanding of relational databases and related knowledge management techniques, including data...Immediate start
- ...firm. Collaboration with the infrastructure team may include endpoint management automated setup PowerShell scripting and systems administration depending on experience and development goals. Initiative and practical ideas are encouraged to reduce manual work improve...Full timeWork at officeRemote work
- ...from single or multiple systems. Troubleshooting the reporting database environment and reports Evaluating changes and updates to... ...Visualization. Data Cleaning. MATLAB. R. Python. SQL and NoSQL. Machine Learning. Linear Algebra and Calculus....Full timeH1bImmediate start
- ...how it works) # Stronger technical foundations (DSA OOP APIs SQL pipeline design) # Mock interview reps (realistic simulation feedback... ...correctly and having the right guidance. Please note: Resume databases are shared with clients and interested clients will reach out...Full timeH1b
- ...modernization andcontinued development of web applications databases APIs and relatedsoftware systems. The position reports to... ...NET Framework / .NET Core JavaScript/Html/CSS jQuery Python SQL Microsoft SQL Server Visual Studio. -Design develop test maintain software...Full time
- ...analysis Six Sigma and/or Lean manufacturing experience Experience with Adaptive Insights, Tableau, Power Query, Power BI, and/or SQL a plus Strong written and verbal communication skills for working with and explaining financial data to employees at a variety of...Work at office
$123.2k
...investigate operational issues and identify opportunities to improve product adoption and user experience. The ideal candidate brings strong SQL expertise experience with data visualization and reporting and the ability to translate complex data into meaningful business...Full timeLocal area$138.6k
...IdentityIQ rules workflows provisioning certifications connectors aggregations and lifecycle processes . Proficiency with SQL relational databases Unix/Linux and shell scripting . Experience with REST APIs web services and enterprise integrations . Understanding...Full timeLocal area$95.7k
...responsibilities: The developer will implement reusable components improve SQL and application performance and support infrastructure... .... . Strong hands on AWS experience across compute storage databases messaging and orchestration including services such as Lambda...Full timeLocal area- ...cloud platforms (Databricks, Snowflake, AWS/Azure), PySpark, and SQL. Ensure all data pipelines and platform integrations strictly... ...batch data architectures via REST APIs, message brokers, and database integrations. Domain Competency (Scientific & Process Focus)...Full timeContract workFor contractors3 days per week
$95.7k
...security. . Working knowledge of Angular including components services routing RxJS and API integration. . Practical Python and SQL skills for scripting APIs and data processing including JSON/XML; familiarity with Pandas Boto3 or PySpark is a plus. . Experience...Full timeLocal area$65.3k
...managers to deliver features end to end. Integrate APIs with databases (Oracle now and either PostgreSQL or MySQL in the future). Write... ...to be successful in this role: Experience coding Java based SQL driven applications. Java RESTful API experience Desired...Full timeContract workWork at officeLocal area$97.3k
...IDMC . Hands on experience with AWS services such as EMR ECS Glue Redshift S3 SNS SQS Lambda and CloudWatch . Strong Python and SQL skills including work with Redshift PostgreSQL or Oracle . Experience supporting data warehouses and large scale data pipelines...Full timeLocal area$71.7k
...interoperability frameworks .Strong business analysis and data analysis experience .Expertise in writing and optimizing complex SQL queries across large datasets .Experience with data platforms such as Databricks Teradata Snowflake AWS Athena or similar...Full timeWork at officeLocal area$58.1k
...enable MLflow MLOps GenAI and LLM use cases. .Design and develop reporting and visualization solutions using Power BI Databricks SQL Dashboards Tableau or similar platforms. .Participate in solution design workshops client presentations architecture reviews and technical...Full timeLocal area
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to DB2 LUW and SQL Server Database Administrator. Be the first to apply!
