Database Administrator (Chicago, IL- US)

Energy Solutions•Chicago, IL

1d•Hybrid

About The Position

Energy Solutions is seeking a Database Administrator to join their Information Systems Team. This role is crucial for ensuring the security, reliability, and high availability of the company's database environments. The Database Administrator will work cross-functionally with Development, QA, and Operations to implement best practices, streamline deployment pipelines, and maintain proactive monitoring. A key aspect of this role involves leading data analysis efforts to provide actionable insights, including developing and maintaining Power BI dashboards and reports to support strategic decision-making across engineering, operations, and business teams. This is a hybrid work opportunity.

Requirements

Bachelor's degree in any field or equivalent experience required
5 years of experience in a database administration (DBA) role or equivalent
Experience managing production database environments for reliability, performance tuning, access control, and security
Experience partnering with Development/QA/Operations to support deployments, environment health, and incident response
Experience building or maintaining dashboards/reports (Power BI and/or Tableau) and performing structured data analysis for business users
Expertise with relational databases (e.g., PostgreSQL, MySQL, SQL Server) including schema design considerations, query tuning, and index strategy
Strong skills in database monitoring, profiling, and troubleshooting (capacity, bottlenecks, query performance, indexing)
Working knowledge of database security and access controls, including roles/permissions, auditing, and encryption concepts
Experience with backup/recovery concepts and supporting disaster recovery preparedness (validation, documentation, restoration readiness)
Familiarity with scripting (Python, Bash) for automation and operational tooling
Experience supporting data governance practices (e.g., lineage, security, quality, governance)
Ability to translate business needs into analytical deliverables (datasets, reports, dashboards) and communicate findings to technical and non-technical stakeholders

Responsibilities

Manage, maintain, and optimize company databases for performance, reliability, security, and scalability
Perform database administration tasks (primarily relational, with exposure to NoSQL)
Create and manage database users, roles, and permissions to ensure proper access controls
Monitor database performance and troubleshoot bottlenecks, capacity constraints, and indexing issues
Evaluate and tune queries, indexes, and configurations to optimize database performance
Implement and maintain data security controls, including encryption, auditing, and compliance measures
Establish and enforce data governance policies and procedures across the organization
Document database administration procedures, security protocols, and governance frameworks
Ensure data integrity and availability through robust backup, recovery, and disaster recovery strategies
Perform data analysis to identify trends, patterns, and insights supporting business decision-making
Design and implement logical data models that inform physical design and scalable architecture
Build usable datasets that expand access to self-service analytics and improve decision-making
Write maintainable, testable, efficient code that is clear to engineers unfamiliar with the system