JOBSEARCHER

Lead Infrastructure Engineer (Amazon Redshift)

SamprasoftWashington, DCAugust 25th, 2026
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