Senior Database/AWS Engineer

Job Summary:
The HealthCloud Consultant is a proficient AWS Engineer who is responsible for designing and implementing AWS tenants hosted by client or part of a client Client's tenant. The position requires a deep knowledge of AWS, Networking Technologies, Security Standards and Practices that can be leveraged to build and manage multiple client tenants simultaneously. Because we are a data services/consulting organization, a successful candidate will be effective connecting and managing various client AWS environments and will demonstrate strong presentation skills for client-facing consulting. Mastery is required of our standard Commercial Data Environment (CDE) which includes the following elements:

• EC2 WinServer
• EC2 Linux Server
• Auto Scalability and Cost evaluation
• Redshift / Snowflake / Athena
• Build Data Warehouses and Data Models using Glue or other ETL applications
• Data Normalization, Standardization, error logging, exception handling techniques in DW and AWS
• DocumentDB with Mongo Compatibility
• OpenVPN Server, RDS and NAT Gateway setup
• Setup AI, Client and Data Science platforms like SageMaker, R
• S3 Data Repository and Sftp connections
• Python and API Integration
• DB/AWS Performance Tuning (Esp Large Data Volume with concurrent usage)

Essential Duties and Responsibilities:

• AWS Tenant Building - The AWS Engineer is actively involved in the design of multiple client environments and ensures they are set up and maintained according to best practices. This includes network setup and SSO with various systems, interacting with AWS environment and infrastructure recommendations based on client requirements.
• AWS Tenant Management - The AWS Engineer is actively involved in security, user setup and maintaining AWS resources. Administers, monitor and deploy systems and services on AWS and other remote servers. Ensures the availability, performance and scalability of proposed infrastructure.
• Documentation – The AWS Engineer is responsible for maintaining the documentation of client environments to include the population of network topology drawings and runbooks that detail what was built and how.
• Client/Project Team Meetings - The AWS Engineer is responsible for demonstrating the AWS Environment capabilities of Symphony HDS in client meetings, communicates how the implementation will occur, manages their tasks to complete and contributes in client project team meetings—these are usually daily scrums as required.
• AWS Product Offerings – Contributes to the expansion of technology platforms for new, existing and/or potential HDS product offerings.
• Data Architecture/Data Modeling – AWS Engineer will apply storage and network optimization techniques to create data marts. This role will also interact with large data volumes with a variety of data sets and apply Database administration and query optimization techniques.
• Lead – Group of ETL/AWS Developers

Qualifications

• 5+ years of experience in DW or AWS
• AWS Certified Solution Architect – Recommended
• AWS Developer Associate - Recommended (Or Oracle Certified DBA/Security Professional)
• Successful project experience deploying, automating, maintaining and managing AWS cloud-based production system, with demonstrated skills ensuring the availability, performance, scalability, and security of productions systems.
• Demonstrated project team and consulting experience for either external clients or internal departments
• 3+ years' experience as a multi-tenant support AWS Engineer - Solid hands-on working experience with configuring and maintaining resources on AWS
• 3+ years' experience with Databases (Redshift, DocumentDB, MongoDB, PostgresSQL)
• 3+ years' experience with DocumentDB with Mongo Compatibility
• 3+ years' experience with EC2 instances (configuration, EBS, snapshot, etc.)
• 2+ years' experience with S3 / EMD
• 2+ years' experience with writing Python scripts to develop bulk Redshift loads
• Network Configuration (VPC, Subnet, ACLs, Elastic IP, …)
• Security (IAM, Policies, Root user policies) - Expertise with cloud security, such as managing users, roles, and privileges through IAM & Root user
• ETL (Glue), Pentaho, Spectrum, Talend, Informatica
• Lambda, Athena, Glacier , Snowflake
• VisualCron, Autosys
• Excellent verbal and oral communication