Database Administrator Business Analyst - Hybrid Remote

Job Category: Information Technology

Requisition Number: DATAB
002409

• Posted :
  October 12, 2026
• Full-Time
• Hybrid

Showing 1 location

Pay Grade:

M09

POSITION SUMMARY

Administers, supports, secures, and optimizes Hoosier Energy’s enterprise Microsoft SQL Server databases and database-driven applications. Designs, develops, and supports Power BI reporting and analytics solutions and administers the Alation Data Catalog in support of data governance, stewardship, metadata management, and data literacy. Partners with business units, application owners, developers, vendors, Data Owners, and Data Stewards to deliver reliable, secure, recoverable, and well-governed data services while identifying opportunities to improve business processes through data and technology solutions.

DUTIES AND RESPONSIBILITIES

Database Administration

• Administer, monitor, maintain, secure, and optimize Microsoft SQL Server databases.
• Plan and execute database installations, configurations, upgrades, migrations, and patching.
• Implement and maintain backup, restore, high-availability, disaster-recovery, replication, and failover capabilities.
• Monitor database health, storage, capacity, availability, and performance and proactively resolve risks and bottlenecks.
• Perform query analysis, indexing, execution-plan review, statistics maintenance, and T-SQL performance tuning.
• Design and maintain database structures, standards, access methods, maintenance plans, SQL Server Agent jobs, alerts, and automation.
• Administer users, roles, permissions, encryption, auditing, and related security controls.
• Ensure data confidentiality, integrity, availability, recoverability, and compliance.
• Document database architecture, configurations, procedures, standards, and support runbooks.

Database Applications Support

• Provide Tier 2 and Tier 3 support for SQL Server-based business applications and enterprise systems.
• Troubleshoot database connectivity, data integrity, stored procedures, views, functions, triggers, jobs, permissions, integrations, and performance.
• Partner with application owners, developers, business analysts, infrastructure, Cybersecurity, and vendors to resolve production issues.
• Support application upgrades, testing, releases, integrations, deployments, and migrations across development, test, and production.
• Review, optimize, test, debug, and document application-specific database logic and interfaces.
• Develop monitoring and automation to identify and address database and application issues proactively.
• Follow change, incident, problem, and documentation practices and participate in after‑hours maintenance or support when required.

Business Analysis, Analytics, and Power BI

• Work with business units to analyze processes, document requirements, identify data needs, and recommend technology or process improvements.
• Design, develop, deploy, administer, and support Power BI dashboards, reports, paginated reports, semantic models, and datasets.
• Develop and optimize Power BI data models, DAX measures, calculated columns, and Power Query transformations to deliver secure, high‑performing, user‑friendly, and well‑governed analytics solutions.
• Implement and maintain row‑level security, role‑based access, workspace governance, refresh schedules, gateways, deployment processes, and monitoring.
• Develop and support ETL/ELT and data integration processes using SQL Server Integration Services, SQL Server Agent, Power Query, and other approved technologies.
• Collaborate with stakeholders to translate requirements into scalable reporting and analytics solutions.
• Optimize reliability, performance, usability, and adoption across source databases, integrations, semantic models, and reports.
• Promote…