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 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 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 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 technology
Experience with NOSQL database (MongoDB or DynamoDB) is a big plusAWS 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 SLAsCreate 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
No matching similar jobs found for matching similar jobs near Washington, DC
No similar jobs found