Production Engineer (Contract To Hire)

Production Engineer (Contract To Hire) PrideNow - 3.2 Plano, TX Job Details Temp-to-hire $60 - $64 an hour 7 hours ago Qualifications Cost management Oracle Enterprise Manager Data transformation pipeline development Incident management Cloud data warehouses Procedural guides DevOps IT system monitoring System design Database security management Technology security practices Snowflake Automating deployment processes Information security compliance Access control implementation SRE Improving database performance Technical writing Technical troubleshooting support Data validation Root cause analysis Cloud monitoring PL/SQL Python System performance monitoring Full Job Description •6 months (Contract To Hire)

Responsibilities:

3-4 years of experience in production engineering and site reliability engineering (SRE) to design, implement, and maintain highly available, scalable, and resilient systems. Own end-to-end operational responsibilities include monitoring, incident response, root cause analysis, capacity planning, and automation to ensure optimal system performance and reliability in production environments. Collaborate cross-functionally with development, QA, and infrastructure teams to streamline CI/CD pipelines, automate deployments, and enforce best practices for security, compliance, and disaster recovery. Utilize a broad set of tools and technologies to proactively detect, troubleshoot, and resolve production issues, minimizing downtime and improving service-level objectives (SLOs) and service-level agreements (SLAs).

Requirements:

Snowflake Developer, Oracle, Python Develop, maintain, and optimize data pipelines and workflows using Snowflake and Oracle databases to ensure reliable data availability in production. Write and optimize advanced SQL and PL/SQL queries and stored procedures for efficient data processing and transformation. Automate data ingestion, validation, and monitoring tasks using Python scripting and orchestration tools like Apache Airflow or Prefect. Monitor database health, query performance, and resource utilization using Snowflake Resource Monitors, Oracle Enterprise Manager, and cloud monitoring tools. Troubleshoot and resolve production incidents related to data inconsistencies, pipeline failures, or performance degradation. Implement security best practices, including role-based access control, data masking, and encryption in Snowflake and Oracle environments. Collaborate with DevOps teams to integrate database changes into CI/CD pipelines using Git, Jenkins, or Azure DevOps. Perform root cause analysis for recurring issues and implement automation to reduce manual intervention. Manage cloud resource costs by tuning Snowflake warehouse sizes and Oracle instance configurations. Document operational procedures, runbooks, and system architecture for knowledge sharing and compliance. #Pnow123

Pay:

$60.00 - $64.00 per hour

Work Location:

In person