Database Engineer with AWS Cloud DB Experience

• Experience as a Database Engineer or similar role with deep knowledge of AWS cloud infrastructure and services for databases implementation and optimization.
  
• Experience with databases on Aurora and MySQL.
  
• Handson experience with AWS Glue AWS Redshift AWS DMS AWS Lambda Amazon EventBridge Queues S3 etc.
  
• SQL skills and experience in database design optimization and performance tuning.
  
• Experience in scripting languages (Python SQL PySpark) for automation and data manipulation tasks.
  
• Understanding of data warehousing concepts ETL processes and data modelling techniques.
  
• Desirable: AWS Data Analytics certification AWS Solutions Architect AWS Big Data or AWS Certified Database Specialty.
  

Requirements

• Mantain scalable database solutions in AWS cloud environments.
  
• Improve ETL processes using AWS Glue and AWS Lambda SNS AWS DMS for data ingestion transformation and loading into Redshift.
  
• Monitor database performance troubleshoot issues and implement solutions to ensure optimal performance and reliability.
  
• Implement and manage data pipelines and workflows using AWS services such as Lambda and S3.
  
• Ensure data integrity security and compliance with organizational standards and industry regulations.
  
• Propose an active monitoring system making an alert and troubleshooting notification and solution more efficient.
  
• Document the changes and processes with detailed architecture diagrams and description of the processes.
  

Understanding of event-driven architectures Distributed systems - How clusters are formed, Quorum management, Failure handling. 3 to 5 years of hands-on Experience in MQ or NATS broker or similar messaging solutions. Understanding of Kafka clustering would be good to have. Knows Client-Server communication aspects - sockets, TLS protocol etc Understands the concept of region and AZs. Provide L2 support production systems like application, database, middleware components, infrastructure and network components. Manage production incidents end-to-end within defined SLAs with focus on resolution rather than who caused it. Interact with various stakeholders such as Release managers, program leads, service managers, development and test leads Review operational readiness requirements such as monitoring and alerting, log rotation and resilience of the components and report the gaps Provide pre-implementation support with activities such as release notes review and implementation dry runs. Protect production components by running health checks monitoring latency and memory utilization. Automate day-to-day activities and propose changes that improve reliability Participate in CAB and provide feedback on change requests Support the DevOps team in testing the promoted pipelines and suggest automation of configuration items. Practice incident management best practices and perform RCA. Participate in disaster recovery tests and operational acceptance tests Analyze the technology stack that makes up the product and optimize recovery time objective. Work with team members spread across and time zones Share knowledge, document improvements and mentor junior resources It is good to have skills using Jenkins to orchestrate builds and link to Sonar, Maven, etc. to build out the CI/CD pipeline. Support deployments of code into multiple lower environments. Supporting current processes needed with an emphasis on automating everything as soon as possible. It is good to have skill to design, Implement, and enhance our deployment automation based on Chef. We need proven experience designing and implementing an overall release and deployment process. It is good to have skill to design and implement a Git based code management strategy that will support multiple environment deployments in parallel. Experience with automation for Branch management, code promotions, and version management. Engage in and improve the whole lifecycle of services from inception and design through deployment, operation, and refinement. Requirements MQ/EB Understanding of event-driven architectures Distributed systems - How clusters are formed, Quorum management, Failure handling. 3 to 5 years of hands-on Experience in MQ or NATS broker or similar messaging solutions. An understanding of Kafka clustering would be good to have. Knows Client-Server communication aspects - sockets, TLS protocol etc Understand the concept of region and AZs. Deployments MTF/Prod, Maintenance items (including stop/start, Disaster Recovery-related activities, etc.), CR for changes in MTF/Prod Good knowledge on Nginx Tools - Log Monitoring Tool - Splunk Application Monitoring tool - Dynatrace Ticketing incident/problem management tool - Remedy Dev-ops Basics - CI-CD Basics, Overview of Git, Bit-bucket, SonarQube, Ansible/Chef Skills - Linux & Shell Scripting ITIL / ITSM PL/SQL Troubleshooting Jenkins - CI/CD Groovy Scripting/Yaml Ansible/Chef Nginx Java / JEE Event-Driven Architectures MQ or NATS broker or similar messaging solutions. Kafka Client-server communication aspects - sockets, TLS protocol Understand the concept of region and AZs.