Database Administrator (New York, NY - US)

Energy Solutions - USA•New York, NY

2d•$121,679 - $147,639•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. Additionally, this position will lead data analysis efforts, develop Power BI dashboards and reports to support strategic decision-making, and contribute to the company's climate solution focus.

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