Production Engineer

Job Description:

Onsite

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.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.