Lead Infrastructure Engineer

5 days ago

Washington DC, District of Columbia, United States Samprasoft Full-time

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, Te