ITUS (Integrated Thermal Utility System) – Database Administrator Specialist
Location: Hybrid; Newark, NJ; Must be within driving distance of Newark, NJ
Years of experience: 10+ years
Visa: US Citizen or GC only
Notes from call with Manager:
Two important skills specifically: Admin of AWS Cloud databases such as aurora postgres, redshift, documentDB. Other specific skills are experience with cloud formation templates or terraform or lambda functions, requires skills in python as well.
Focusing on New and existing databases
At least 3 years, 5 is ideal. Someone who can hit ground running as soon as they are on
Databases ranked: Flexible not too picky. Automation and self service with Postgres and not redshift will consider. Good with redshift and automation, that will work as well. As long as they have familiarity with one or two databases, they can pick up other databases as well.
Cloud formation templates, writing python, using lambda functions, Terraform. Common programming languages and platforms that AWS Databases specialists are familiar with.
Glue is not necessary, but nice to have.
Will be within a scrum team, once in a while if there is emergency on weekend but does not occur often.
Certifications are not a must, but nice to have.
As long as a candidate is super hands on and hits ground running, that is ideal candidate.
No Specific domain experience is necessary, Is nice to have if worked in Financial or Insurance industry though.
Soft Skills that are must: Good Comm skills, Team player, self starter, self motivated, does not need supervision, deliver results fast, done this and worked in scrum team in past.
Interview: 60 minute with group of 3 people. Technical discussion, Intros, then technical, then questions at end.
Job Description:
As an AWS Cloud Database Administrator and Infrastructure as Code Developer, you will be responsible for delivering high-quality database administration services to App/Dev Teams, including provisioning, configuration, maintenance, and optimization of Amazon Redshift, Aurora PostgreSQL and DocumentDB Databases using Cloud Formation Templates and Terraform. You will work closely with our IT teams to assess database infrastructure, identify areas for improvement, and implement effective solutions to ensure optimal performance and reliability.
In-depth knowledge of Amazon Redshift database administration, DocumentDB database administration and Aurora PostgreSQL database administration including installation, configuration, and maintenance is necessary for the position. Strong analytical and problem-solving skills, with the ability to diagnose and resolve complex database issues; Excellent communication and interpersonal skills, with the ability to effectively interact with internal teams are necessary.
Develop Infrastructire as Code for provsioning, configurations, and maingtenance of Amazon Redshift, DocumentDB and Aurora PostgreSQL Databases according to best practices and requirements. Experience with infrastructure as code (IaC) tools such as AWS CloudFormation or Terraform is a must.Proficiency in scripting with Python, lambda and Step Functions.
Develop and implement backup and recovery strategies to safeguard critical data and minimize downtime.Deep understanding of database concepts and experience with Redshift, DocumentDB, Aurora PostgreSQL is a must.
Optimize database performance through query tuning, index optimization, and database schema refinement. Experience with monitoring and logging tools, particularly AWS CloudWatch is a must.
Provide technical support and troubleshooting assistance for Database related issues and incidents.
Skills in database performance tuning, backup and recovery, and high availability setups.
Develop and implement high availability and disaster recovery solutions. Experience in administration, managing and optimizing databases like Redshift, DocumentDB and Aurora PostgreSQL.
Use of CI/CD pipelines and tools like Jenkins to provision databases and develop solutions for developer Self Service.
Document database configurations, procedures, and troubleshooting steps for knowledge sharing and future reference.
Several years (3-5+ years) of experience working with AWS cloud services, including experience with database administration and infrastructure development.
Hands-on experience in designing, deploying, and managing cloud infrastructure.