Lead Infrastructure Engineer (Amazon Redshift)

AWS Cloud Database Administrator

Summary

Need 8+ years experience in:

• Designing, setting up, and administrating Amazon Redshift
• Data modelling - physical and logical
• Best practices Redshift - workload management, data partitioning/sorting, security, data security, backup, auditing, key management, and encryption
• Document and implement best practices Redshift - workload management, data partitioning/sorting, security, data security, backup, auditing, key management, and encryption
• Working knowledge of AWS Lake formation.
• Experience in data replication, application scalability and high-availability architecture
• Query optimization and database tuning skills
• Working knowledge of one of scripting languages (Python, etc.)
• UNIX shell scripting, PL/SQL, and SQL skills
• Knowledge and experience with AWS offerings (Aurora PostgreSQL, OpenSearch, EC2, S3, etc.)
• Experience with NOSQL database (MongoDB or DynamoDB)
• AWS Data Analytics, Specialty certification a plus
• Working knowledge of AWS Lake formation
• Experience in designing and implementation of Data replication, application scalability and high-availability architecture
• Experienced in Query optimization and database tuning skills
• Led and implemented Backup and Disaster Recovery (DR) strategy for AWS and other databases with planning and execution based on RPO/RTO objectives and SLAs
• Working knowledge of one of scripting languages (Python, etc.)
• Experienced in UNIX shell scripting, PL/SQL, and SQL skills
• Knowledge and experience with related AWS data offerings (Aurora PostgreSQL, OpenSearch, EC2, S3, etc.)
• Working Knowledge of related AWS real-time streaming offerings like Kinesis or similar technology
• Experience with NOSQL database (MongoDB or DynamoDB) is a big plus
• AWS Data Analytics, Specialty certification a plus
• Provide AWS Cloud Database Administration and expand utilization of Cloud-based tools including Amazon Relational Database Service (RDS), Aurora, Redshift, Dynamo DB, etc.
• Automate provisioning, operation, monitoring and troubleshooting of the database and data lake infrastructure
• Automation experience leveraging solutions like Terraform Ansible
• Provide consistent database maintenance, optimization and best practices inputs to existing Redshift and SQL databases, data lake, SQL engines, and applications
• Provide Disaster Recovery (DR) planning and execution with RPO/RTO objectives and SLAs
• Create smart solutions for the problems we encounter with a willingness to do maintenance type jobs
• Set up, operate, and scale databases in the Cloud
• Utilize knowledge of Data Migration, Data Warehouse/Data Lake, ETL/ELT, Database design & implementation, data provisioning, scalability, availability & performance
• Collaborate with Architects and provide guidance on designing AWS Cloud database solutions
• Deploy and Administer Data Warehouse/ Data Lake solutions using Amazon Web Services
• Capacity planning and analysis of growth patterns of data to plan for future storage requirements
• Develop data migration plans to migrate legacy on-premises databases into AWS data stores
• Use knowledge of EDW, Data Lake, ETL/ELT, Relational/Non-Relational Databases, Postgres, SQL, etc.
• Guide database-related activities, and develop strategies to improve utilization and performance
• Work with Data Engineering, Master Data Management, Data Governance, & Machine Learning
• Provide guidance on Data provisioning
• Develop automation for repeatable processes across teams
• Work with cross-functional teams to ensure successful delivery of features and improvements
• Monitor, identify, and resolve performance issues within AWS database technologies
• Lead and implement Backup and Disaster Recovery (DR) strategy for AWS and other databases
• Configure, test, and implement database applications
• Upgrade database software and apply patches
• Provide troubleshooting and debugging
• Ensure that best practices are follow and maintained
• Participate in DevOps activities
• Work effectively in a virtual delivery environment
• Collaborate with software development, business intelligence, data science, and other teams

Qualifications:

• 10+ years of overall experience in IT including hands-on Development and Systems engineering background
• Minimum of 8-10 years of IT experience of which at least 5 years must be in AWS Cloud Automation and Administration.
• Must be well versed in writing Terraform plans, Ansible playbooks, and Python code.
• 3-5 years of experience in a Site Reliability Engineering role
• Experience with Datacenter migration and Enterprise Cloud transformation efforts
• Experience with SRE principles and transformation
• 3+ years of experience with implementation of Containerization (Kubernetes), Cloud technologies (AWS, Azure, or Google, etc.), DevOps tool chain (Ansible, Jenkins, Artifactory, bitbucket, etc.), and technical patterns (IaC, Automated Provisioning/Release, CI/CD, etc.)
• Solid understanding of Software coding techniques and experience with full spectrum of Software engineering (Build, Integration, Test, Releasing and Deployment) leveraging Python.
• Experience in Developing and/or challenging engineering solutions/practices and collaborating with peers within and outside of immediate team, including customers (Dev, Architects, Engineers)
• 8+ years of Database Design, Administration, Deployment, and Support
• 4 years of progressive expertise with Redshift or another analytic column store, or external columnar data format, like Parquet or ORC, combined with a SQL engine, like Hive, Presto, or Impala.
• Experience with AWS Services, especially, Data Pipeline, Glue, Kinesis, Redshift Spectrum
• Experience in schema design and data modeling
• Knowledge and hands-on expertise with Structured Query Language (SQL)
• Strong interpersonal communication and ability to solve complex problems
• Experience in debugging
• Excellent knowledge of data backup, recovery, integrity for database solutions

Roles & Responsibilities:

• Communicates Architectural decisions, plans, goals, and strategies, while highlighting short-term trade-offs vs. long-term commitments and costs
• Engage in and improve the end-to-end Lifecycle of services, starting from Inception & design, deployment, operations, and refinement
• Support activities, including System design consulting, developing software platforms and frameworks, capacity planning, and launch reviews
• Systems Scalability and sustainability leveraging automation and strive to improve our systems with changes that improve reliability and velocity
• Experience with Enterprise Cloud transformation efforts
• Be part of our Cloud journey and as a member of our team help lead Software automation and reliability for our platform
• Actively participate and help guide customers on using Cloud-native design and architecture patterns.
• Provide Consultation on Technology infrastructure planning and engineering for assigned systems; Assesses the implications of technology strategies on infrastructure capabilities
• Build strategy to migrate Legacy applications by conversion to multiple Microservices and hosting on AWS Cloud platform.
• Leverage Cloud-native architecture components including Containers, immutable infrastructure, Microservices, Service Mesh etc., to build highly available and Fault tolerant applications.
• Research on the global technology trends and their applicability to FEPOC products in support of our internal development teams and business.
• Promotes and ensures Modern application design, applies engineering best practices in the development and operations life cycle and mitigates vulnerabilities.
• Monitors and manages the Stability, Availability, and Performance of enterprise systems and platforms across IT domains
• (e.g., Systems, Network, Storage, Security) by analyzing systems to identify problems, trends, and opportunities for improvement.
• Maintain and continually improve (patch and upgrade) our Cloud-based infrastructure.
• Makes data-driven recommendations and decisions, and continuously improves the overall efficacy and efficiency of our software delivery