Production Engineer

Job Title: Production Engineer

Location: Plano TX - Onsite

Duration: 6 Months CTH

Notes:

Full Stack Java Developer role focused on Java services and cloud-based microservices architecture.

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.

Requirements:

Java JavaScript Cloud-based Microservices Spring Boot AWS

Build deploy and maintain cloud-native microservices using Java Spring Boot and JavaScript frameworks ensuring high availability and scalability.

Design and implement RESTful APIs and event-driven architectures using AWS services such as Lambda ECS/EKS SQS and SNS.

Develop and maintain CI/CD pipelines with Jenkins GitLab CI or AWS CodePipeline for automated testing and deployment.

Monitor application and infrastructure health using AWS CloudWatch Prometheus Grafana and distributed tracing tools like Jaeger or AWS X-Ray.

Troubleshoot production issues perform root cause analysis and implement fixes to improve system reliability.

Implement security controls including IAM roles OAuth2 JWT and encryption for data in transit and at rest.

Collaborate with cross-functional teams to design fault-tolerant resilient systems with automated failover and recovery.

Optimize cloud resource usage and cost through rightsizing and autoscaling configurations.

Automate operational tasks and incident response using scripting and infrastructure as code (Terraform CloudFormation).

Maintain detailed documentation of system architecture deployment processes and operational runbooks.