Database Administrator (Chicago, IL- US)
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. Additionally, this position will lead data analysis efforts, develop Power BI dashboards and reports to support strategic decision-making, and ensure the integrity and performance of the company's data. This is a hybrid work opportunity with offices in Oakland, CA, Orange, CA, Portland, OR, Chicago, IL, and Boston, MA.
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
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
Benefits
- medical
- dental
- vision insurance
- retirement package
- Employee Stock Ownership Plan (ESOP)