• AWS Database Architect

    Insight Global (Herndon, VA)


    Job Description

    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 (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .

     

    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/ .

     

    Skills and Requirements

     

    -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 null

    We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].