Database Administrator - Data Governance

We are seeking a Database Administrator with strong data engineering fundamentals to join a fast-paced Information Systems Team. The majority of your time will be spent on data engineering, data governance, and Python-driven automation, with database administration responsibilities making up a smaller but essential portion of the work.

You will own our data governance initiatives, including building a PII classification system, designing and managing the data access layer and permissions model, and developing the automation that keeps our data platform reliable and secure. Our environment includes PostgreSQL, Amazon Redshift, API-based data sources, and flat files in S3\.

Working cross-functionally with Development, QA, and Operations, you will implement operational best practices, streamline data pipelines, and maintain proactive monitoring across all environments. You will also help expand access to trusted, self-service analytics that support strategic decision-making across engineering, operations, and business teams.

Responsibilities include but are not limited to:

• Design and implement data governance policies, procedures, and frameworks across the organization
• Build and maintain a PII classification system to identify, tag, and protect sensitive data
• Develop Python and PySpark automation for data pipelines, operational tooling, and workflow orchestration
• Design and manage the data access layer, including database users, roles, and permissions to ensure proper access controls
• Contribute to system design decisions for a scalable, maintainable data platform
• Integrate and manage data across PostgreSQL, Redshift, API-based sources, and flat files in S3
• Perform core database administration tasks including performance monitoring, query and index tuning, and troubleshooting bottlenecks and capacity constraints
• Implement and maintain data security controls, including encryption, auditing, and compliance measures
• Ensure data integrity and availability through robust backup, recovery, and disaster recovery strategies
• 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
• Support reporting and dashboard development for business stakeholders
• Document data governance frameworks, security protocols, and administration procedures
• Write maintainable, testable, efficient code that is clear to engineers unfamiliar with the system

Minimum Qualifications:

• Bachelor's degree in any field or equivalent experience required
• 5 years of experience in data engineering, database administration, or a related data platform role
• Expert-level Python scripting for automation, data pipelines, and operational tooling; PySpark experience strongly preferred
• Strong system design skills and the ability to architect scalable data solutions
• Hands-on experience with data governance practices (e.g., PII classification, lineage, security, quality)
• Expertise with relational databases (e.g., PostgreSQL, Redshift, MySQL, SQL Server) including schema design, query tuning, and index strategy
• Working knowledge of database security and access controls, including roles/permissions, auditing, and encryption concepts
• 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
• Strong SQL skills, including complex queries and performance optimization
• Ability to translate business needs into analytical deliverables and communicate findings to technical and non-technical stakeholders

Preferred Qualifications:

• Experience with AWS data services (Redshift, S3, Glue, Lambda); candidates with equivalent experience on other cloud platforms are encouraged to apply, as PySpark and data engineering skills transfer across platforms
• Experience building or maintaining dashboards and reports (Power BI and/or Tableau); training will be provided for the right candidate
• Experience with backup/recovery concepts and disaster recovery preparedness
• Background in any data-intensive industry; energy sector experience is not required