Apply on Employer Site

Talen Energy · 16 hours ago

Senior Data Specialist

Allentown, PA

Full-time

Hybrid

Senior Level

7+ years exp

Talen Energy is one of the largest competitive energy and power generation companies in North America. In this role, you will design, implement, and manage modern data platforms and database environments, focusing on relational database management systems and cloud services.

EnergyEnergy ManagementOil and Gas

No H1B

U.S. Citizen Only

Responsibilities

Install, configure, maintain, and tune self-hosted Oracle and SQL Server databases

Perform backup, restoration, disaster recovery, patching, and capacity planning activities

Support audit and compliance activities

Support application development and business relations teams for project and operational needs

Manage routine patching and update processes

Manage Amazon RDS instances (including PostgreSQL, Oracle, SQL Server, Aurora and integrate with applications and AWS services

Implement data pipelines with tools such as AWS Glue, AWS DMS

Configure and support Amazon Athena for data stored in s3 and cross platform federated queries

Drive modernization to leverage platforms such as Iceberg, Parquet, s3 Tables

Operate within a multi-account AWS environment

Architect and implement with proper governance and security

Use Infrastructure as Code (IaC) tools, with preference for AWS CloudFormation, to automate and manage environments

Leverage source control (Git, Azure DevOps) for code collaboration and management

Design cost-conscious cloud architectures, optimizing storage, compute, and data transfer costs. Build in a manner to maximize value for cloud spend and avoid waste

Perform basic Linux and Windows system administration tasks in support of data platforms and as a backup to system administrators

User and permission management

File system and storage configuration

Monitoring and troubleshooting OS-level performance issues

Utilize Commvault or similar enterprise backup solutions for database and data platform production

Ensure all data is backed up as scheduled and test for integrity of backups

Monitor and correct backup failure issues

Configure and manage cloud native backup solutions for Amazon RDS backups, EBS snapshots, and AWS Backup

Implement data platforms using security best practices, including encryption, network segmentation, logical access, and compliance controls

Assist in configuration of IAM roles and policies

Participate in audit and compliance activities, ensuring adherence to regulatory and internal standards and controls (Including Nuclear industry requirements, SOX, NERC-CIP)

Partner with architects, data engineers, and cross-functional stakeholders

Mentor junior engineers and promote best practices in data management

Pursue professional development through training programs, certifications, and industry conferences

Seek opportunities for process improvement and optimization

Keep up-to-date with the latest trends, technologies, and best practices in cloud computing, infrastructure management, and data platforms

Innovate and experiment to find new and better ways to solve technical challenges

Qualification

Oracle databasesAWS servicesSQL proficiencyData Lake architectureData Fabric architectureLinux administrationWindows administrationCommvault backup solutionsCollaborationMentoringContinuous learning