Lead Infrastructure Engineer (Amazon Redshift)

AWS Cloud Database AdministratorSummaryNeed 8+ years experience in:Designing, setting up, and administrating Amazon RedshiftData modelling - physical and logicalBest practices Redshift - workload management, data partitioning/sorting, security, data security, backup, auditing, key management, and encryptionDocument and implement best practices Redshift - workload management, data partitioning/sorting, security, data security, backup, auditing, key management, and encryptionWorking knowledge of AWS Lake formation.Experience in data replication, application scalability and high-availability architectureQuery optimization and database tuning skillsWorking knowledge of one of scripting languages (Python, etc.)UNIX shell scripting, PL/SQL, and SQL skillsKnowledge and experience with AWS offerings (Aurora PostgreSQL, OpenSearch, EC2, S3, etc.)Experience with NOSQL database (MongoDB or DynamoDB)AWS Data Analytics, Specialty certification a plusWorking knowledge of AWS Lake formationExperience in designing and implementation of Data replication, application scalability and high-availability architectureExperienced in Query optimization and database tuning skillsLed and implemented Backup and Disaster Recovery (DR) strategy for AWS and other databases with planning and execution based on RPO/RTO objectives and SLAsWorking knowledge of one of scripting languages (Python, etc.)Experienced in UNIX shell scripting, PL/SQL, and SQL skillsKnowledge 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 technologyExperience with NOSQL database (MongoDB or DynamoDB) is a big plusAWS Data Analytics, Specialty certification a plusProvide 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 infrastructureAutomation experience leveraging solutions like Terraform AnsibleProvide consistent database maintenance, optimization and best practices inputs to existing Redshift and SQL databases, data lake, SQL engines, and applicationsProvide Disaster Recovery (DR) planning and execution with RPO/RTO objectives and SLAsCreate smart solutions for the problems we encounter with a willingness to do maintenance type jobsSet up, operate, and scale databases in the CloudUtilize knowledge of Data Migration, Data Warehouse/Data Lake, ETL/ELT, Database design & implementation, data provisioning, scalability, availability & performanceCollaborate with Architects and provide guidance on designing AWS Cloud database solutionsDeploy and Administer Data Warehouse/ Data Lake solutions using Amazon Web ServicesCapacity planning and analysis of growth patterns of data to plan for future storage requirementsDevelop data migration plans to migrate legacy on-premises databases into AWS data storesUse 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 performanceWork with Data Engineering, Master Data Management, Data Governance, & Machine LearningProvide guidance on Data provisioningDevelop automation for repeatable processes across teamsWork with cross-functional teams to ensure successful delivery of features and improvementsMonitor, identify, and resolve performance issues within AWS database technologiesLead and implement Backup and Disaster Recovery (DR) strategy for AWS and other databasesConfigure, test, and implement database applicationsUpgrade database software and apply patchesProvide troubleshooting and debuggingEnsure that best practices are follow and maintainedParticipate in DevOps activitiesWork effectively in a virtual delivery environmentCollaborate with software development, business intelligence, data science, and other teamsQualifications:10+ years of overall experience in IT including hands-on Development and Systems engineering backgroundMinimum 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 roleExperience with Datacenter migration and Enterprise Cloud transformation effortsExperience with SRE principles and transformation3+ 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 Support4 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 SpectrumExperience in schema design and data modelingKnowledge and hands-on expertise with Structured Query Language (SQL)Strong interpersonal communication and ability to solve complex problemsExperience in debuggingExcellent knowledge of data backup, recovery, integrity for database solutionsRoles & Responsibilities:Communicates Architectural decisions, plans, goals, and strategies, while highlighting short-term trade-offs vs. long-term commitments and costsEngage in and improve the end-to-end Lifecycle of services, starting from Inception & design, deployment, operations, and refinementSupport activities, including System design consulting, developing software platforms and frameworks, capacity planning, and launch reviewsSystems Scalability and sustainability leveraging automation and strive to improve our systems with changes that improve reliability and velocityExperience with Enterprise Cloud transformation effortsBe part of our Cloud journey and as a member of our team help lead Software automation and reliability for our platformActively 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 capabilitiesBuild 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