DevOps Solution Architect

Job Summary:

Seeking a seasoned SQL + ETL Developer with 4+ years of experience in managing large-scale datasets and cloud-based data pipelines. The ideal candidate is hands-on with MySQL, PySpark, AWS Glue, and ETL workflows, with proven expertise in AWS migration and performance optimization.

Key Responsibilities:

• Develop and optimize complex SQL queries and stored procedures to handle large datasets (100+ million records).
• Build and maintain scalable ETL pipelines using AWS Glue and PySpark.
• Work on data migration tasks in AWS environments.
• Monitor and improve database performance; automate key performance indicators and reports.
• Collaborate with cross-functional teams to support data integration and delivery requirements.
• Write shell scripts for automation and manage ETL jobs efficiently.

Required Skills:

• Strong experience with MySQL, complex SQL queries, and stored procedures.
• Hands-on experience with AWS Glue, PySpark, and ETL processes.
• Good understanding of AWS ecosystem and migration strategies.
• Proficiency in shell scripting.
• Strong communication and collaboration skills.

Nice to Have:

• Working knowledge of Python.
• Experience with AWS RDS.

Company - Apptware Solutions

Location Baner Pune

Team Size - 130+

Job Description -

Cloud Engineer with 8+yrs of experience

Roles and Responsibilities

● Have 8+ years of strong experience in deployment, management and maintenance of large systems on-premise or cloud

● Experience maintaining and deploying highly-available, fault-tolerant systems at scale

● A drive towards automating repetitive tasks (e.g. scripting via Bash, Python, Ruby, etc)

● Practical experience with Docker containerization and clustering (Kubernetes/ECS)

● Expertise with AWS (e.g. IAM, EC2, VPC, ELB, ALB, Autoscaling, Lambda, VPN)

● Version control system experience (e.g. Git)

● Experience implementing CI/CD (e.g. Jenkins, TravisCI, CodePipeline)

● Operational (e.g. HA/Backups) NoSQL experience (e.g. MongoDB, Redis) SQL experience (e.g. MySQL)

● Experience with configuration management tools (e.g. Ansible, Chef) ● Experience with infrastructure-as-code (e.g. Terraform, Cloudformation)

● Bachelor's or master’s degree in CS, or equivalent practical experience

● Effective communication skills

● Hands-on cloud providers like MS Azure and GC

● A sense of ownership and ability to operate independently

● Experience with Jira and one or more Agile SDLC methodologies

● Nice to Have:

○ Sensu and Graphite

○ Ruby or Java

○ Python or Groovy

○ Java Performance Analysis

Role: Cloud Engineer

Industry Type: IT-Software, Software Services

Functional Area: IT Software - Application Programming, Maintenance Employment Type: Full Time, Permanent

Role Category: Programming & Design

Key Responsibilities:

• Work with the development team to plan, execute and monitor deployments
• Capacity planning for product deployments
• Adopt best practices for deployment and monitoring systems
• Ensure the SLAs for performance, up time are met
• Constantly monitor systems, suggest changes to improve performance and decrease costs.
• Ensure the highest standards of security

Key Competencies (Functional):

• Proficiency in coding in atleast one scripting language - bash, Python, etc
• Has personally managed a fleet of servers (> 15)
• Understand different environments production, deployment and staging
• Worked in micro service / Service oriented architecture systems
• Has worked with automated deployment systems – Ansible / Chef / Puppet.
• Can write MySQL queries

• Public clouds, such as AWS, Azure, or Google Cloud Platform
• Automation technologies, such as Kubernetes or Jenkins
• Configuration management tools, such as Puppet or Chef
• Scripting languages, such as Python or Ruby

• Proficient in Linux Commands line and troubleshooting.
• Proficient in AWS Services. Deployment, Monitoring and troubleshooting applications in AWS.
• Hands-on experience with CI tooling preferably with Jenkins.
• Proficient in deployment using Ansible.
• Knowledge of infrastructure management tools (Infrastructure as cloud) such as terraform, AWS cloudformation etc.
• Proficient in deployment of applications behind load balancers and proxy servers such as nginx, apache.
• Scripting languages: Bash, Python, Groovy.
• Experience with Logging, Monitoring, and Alerting tools like ELK(Elastic-search, Logstash, Kibana), Nagios. Graylog, splunk Prometheus, Grafana is a plus.

Job description

The role requires you to design development pipelines from the ground up, Creation of Docker Files,  design and operate highly available systems in AWS Cloud environments. Also involves Configuration Management, Web Services Architectures, DevOps Implementation, Database management, Backups, and Monitoring.

Key responsibility area
- Ensure reliable operation of CI/CD pipelines
- Orchestrate the provisioning, load balancing, configuration, monitoring and billing of resources in the cloud environment in a highly automated manner
- Logging, metrics and alerting management.
- Creation of Bash/Python scripts for automation
- Performing root cause analysis for production errors.

Requirement
- 2 years experience as Team Lead.
- Good Command on kubernetes.
- Proficient in Linux Commands line and troubleshooting.
- Proficient in AWS Services. Deployment, Monitoring and troubleshooting applications in AWS.
- Hands-on experience with CI tooling preferably with Jenkins. 
- Proficient in deployment using Ansible.
- Knowledge of infrastructure management tools (Infrastructure as cloud) such as terraform, AWS cloudformation etc.
- Proficient in deployment of applications behind load balancers and proxy servers such as nginx, apache. 
- Scripting languages: Bash, Python, Groovy.
- Experience with Logging, Monitoring, and Alerting tools like ELK(Elastic-search, Logstash, Kibana), Nagios. Graylog, splunk Prometheus, Grafana is a plus.

Must Have:
Linux, CI/CD(Jenkin), AWS, Scripting(Bash,shell Python, Go), Ngnix, Docker.

Good to have
Configuration Management(Ansible or similar tool), Logging tool( ELK or similar), Monitoring tool(Ngios or similar), IaC(Terraform, cloudformation).

Why you should join us

- You will join the mission to create positive impact on millions of peoples lives

- You get to work on the latest technologies in a culture which encourages experimentation - You get to work with super humans (Psst: Look up these super human1, super human2, super human3, super human4)

- You get to work in an accelerated learning environment

What you will do

- You will provide deep technical expertise to your team in building future ready systems.

- You will help develop a robust roadmap for ensuring operational excellence

- You will setup infrastructure on AWS that will be represented as code

- You will work on several automation projects that provide great developer experience

- You will setup secure, fault tolerant, reliable and performant systems

- You will establish clean and optimised coding standards for your team that are well documented

- You will set up systems in a way that are easy to maintain and provide a great developer experience

- You will actively mentor and participate in knowledge sharing forums

- You will work in an exciting startup environment where you can be ambitious and try new things :)

You should apply if

- You have a strong foundation in Computer Science concepts and programming fundamentals

- You have been working on cloud infrastructure setup, especially on AWS since 8+ years

- You have set up and maintained reliable systems that operate at high scale

- You have experience in hardening and securing cloud infrastructures

- You have a solid understanding of computer networking, network security and CDNs

- Extensive experience in AWS, Kubernetes and optionally Terraform

- Experience in building automation tools for code build and deployment (preferably in JS)

- You understand the hustle of a startup and are good with handling ambiguity

- You are curious, a quick learner and someone who loves to experiment

- You insist on highest standards of quality, maintainability and performance

- You work well in a team to enhance your impact

• You have a Bachelor's degree in computer science or equivalent
• You have at least 7 years of DevOps experience.
• You have deep understanding of AWS and cloud architectures/services.
• You have expertise within the container and container orchestration space (Docker, Kubernetes, etc.).
• You have experience working with infrastructure provisioning tools like CloudFormation, Terraform, Chef, Puppet, or others.
• You have experience enabling CI/CD pipelines using tools such as Jenkins, AWS Code Pipeline, Gitlab, or others.
• You bring a deep understanding and application of computer science fundamentals: data structures, algorithms, and design patterns.
• You have a track record of delivering successful solutions and collaborating with others.
• You take security into account when building new systems.