AWS Database Architect

A client is looking for a fully remote AWS Database Architect to join their team. The Database team maintains the HART Database by installing and configuring database, data migration, monitoring system performance, resolving customer tickets within JIRA and supporting system incident troubleshooting calls. Database members closely interact with the government customer to achieve system objectives, provide ticket updates, and system status updates. Database members are expected to be on-call for a week at a time approximately
6 9 times a year. This is a fully remote role working 9-3pm EST for their core hours.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form. The EEOC "Know Your Rights" Poster is available here.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

-Ability to obtain DHS EOD
-Minimum of 5 years of experience as a Database Architect/Engineer
Strong expertise in AWS Aurora PostgreSQL and Oracle database management
-Proficiency in AWS data warehouse solutions (Redshift, RDS)
- Experience designing and implementing data reporting solutions
- Proven experience with database design and Entity-Relationship Diagrams (ERD)
- Experience with ETL processes and data migration from Oracle to PostgreSQL
- Proficiency with PostgreSQL table partitioning techniques and optimization
strategies
- Experience with Jira for project tracking and documentation
- Ability to set up comprehensive database monitoring solutions, writing custom
monitoring queries and scripts
- Ability to write and optimize complex SQL queries
- Familiarity with Jira for issue tracking and project management

-Bachelor's degree in Computer Science, Mathematics, or Related STEM field.
-Experience with AWS database services (RDS, Aurora, Redshift)
- Experience with monitoring tools like CloudWatch, Dynatrace, Grafana, or pgBadger
- Advanced SQL development skills
- Database modeling and normalization techniques
- Database performance tuning and query optimization techniques
- Understanding of high availability and disaster recovery strategies
- Knowledge of data governance and security best practices
- Experience with database high availability and disaster recovery strategies
- Experience with automation tools for database administration tasks
- Scripting skills in Python, Bash, or similar
- Strong O&M (Operations & Maintenance) background, including database upgrades
- Background in agile development environments
- Experience with JIRA Ticketing systems preferred
- Experience with DevOps and Agile methodologies

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.