Note: The job is a remote job and is open to candidates in USA. ETHOS - Talent & Advisory is seeking a Database Administrator with strong data engineering fundamentals to join their fast-paced Information Systems Team. The role focuses on data governance, Python-driven automation, and database administration, requiring collaboration with various teams to implement best practices and enhance data accessibility for decision-making.
Responsibilities
- 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
Skills
- 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
- 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
Company Overview