G

Guidehouse

Advises agencies and runs regulated operations

AWS Database Engineer

Database AdministrationConfirmed live in the last 24 hours
Full-timeMcLean, VA, USAIn-person

About the Job

Requirements

  • Must be able to obtain and maintain a Federal or DoD Public Trust, with approved adjudication before onboarding; candidates with an active Public Trust or suitability are preferred.
  • A bachelor's degree is required.
  • At least five years of experience in Oracle database development, database engineering, ETL development, data integration, or related software engineering roles.
  • Strong experience developing Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, views, materialized views, sequences, complex queries, performance tuning, SQL Developer, and SQL*Loader.
  • Ability to design, develop, optimize, troubleshoot, and maintain database solutions for enterprise and mission-critical applications.
  • Experience designing and implementing ETL solutions, data transformation processes, batch processing frameworks, and data migration initiatives.
  • Hands-on experience designing, configuring, administering, monitoring, securing, and troubleshooting AWS database solutions using Amazon RDS for Oracle and PostgreSQL, Amazon Redshift, Amazon S3, AWS Database Migration Service, AWS Schema Conversion Tool, Amazon CloudWatch, AWS Secrets Manager, AWS Key Management Service, IAM, and related AWS database components.
  • Hands-on experience with PostgreSQL and Amazon RDS for PostgreSQL, including SQL and PL/pgSQL development, database administration, performance tuning, indexing, extensions, parameter groups, backup and recovery, high availability, security, monitoring, and troubleshooting.
  • Experience implementing AWS database migration and replication solutions, including source and target endpoint configuration, schema conversion, full-load and change data capture tasks, validation, monitoring, troubleshooting, and cutover support.
  • Experience applying AWS database operational controls for high availability, backup and recovery, performance monitoring, logging, encryption, secrets rotation, least-privilege access, and infrastructure automation.
  • Experience with Matillion ETL or similar cloud-native data integration, orchestration, and data pipeline platforms.
  • Strong understanding of relational database architecture, logical and physical data modeling, entity-relationship diagrams, normalization, indexing, query optimization, transaction management, and referential integrity.
  • Experience analyzing and supporting complex enterprise application databases, schemas, and data models.
  • Experience developing or supporting database unit tests, regression tests, data validation checks, and deployment verification activities.
  • Experience supporting production releases, operational incidents, defect triage, root-cause analysis, and post-release validation in enterprise or mission-critical environments.
  • Ability to troubleshoot and resolve database, data quality, integration, and application performance issues across distributed environments.
  • Experience supporting database and application deployments using CI/CD pipelines, release automation, and DevSecOps best practices.
  • Experience working in Agile software development environments using Scrum, Kanban, or similar methodologies.
  • Experience using source control and application lifecycle management tools such as Git, GitHub, Bitbucket, GitLab, or Azure DevOps.
  • Experience using approved AI-assisted tools or automation practices for code generation, optimization, testing, troubleshooting, documentation, code reviews, knowledge management, and engineering productivity improvements.
  • Understanding of Responsible AI principles, AI governance, cybersecurity, data privacy, and secure AI adoption within enterprise or government environments.
  • Familiarity with AI-enhanced software development lifecycle practices, AI-assisted DevSecOps, intelligent automation, and emerging AI engineering patterns.
  • Strong analytical, problem-solving, communication, and organizational skills, with the ability to manage competing priorities, work independently or collaboratively, and adapt to emerging database, cloud, and AI technologies.

Responsibilities

  • Design, develop, and support Oracle database solutions, including packages, stored procedures, functions, triggers, views, materialized views, and sequences, ensuring high performance, scalability, and maintainability.
  • Develop, enhance, and optimize SQL and PL/SQL code for application functionality, reporting, system integrations, and business operations.
  • Create and maintain database migration scripts, schema updates, release deployment packages, and automated database deployment processes.
  • Design, build, and support ETL workflows, data transformation processes, validation frameworks, and batch data processing solutions.
  • Analyze and interpret complex data models, database schemas, enterprise data flows, entity-relationship diagrams, and data mappings to support business and application requirements.
  • Design, build, configure, administer, and support AWS database and data solutions using Amazon RDS for Oracle and PostgreSQL, Amazon Redshift, Amazon S3, AWS Database Migration Service, AWS Schema Conversion Tool, Amazon CloudWatch, AWS Secrets Manager, AWS Key Management Service, and related AWS services and components.
  • Develop, administer, and optimize PostgreSQL solutions on Amazon RDS, including schemas, functions, procedures, triggers, views, extensions, indexing, partitioning, query tuning, parameter configuration, backup and recovery, high availability, and operational troubleshooting.
  • Implement and support AWS database migration, replication, and modernization across Oracle and PostgreSQL platforms, including schema assessment and conversion, full-load and change data capture workflows, endpoint configuration, data validation, cutover planning, and post-migration verification.
  • Configure and operate AWS database monitoring, logging, backup, recovery, high-availability, encryption, credential-management, and access-control capabilities using Amazon CloudWatch, RDS monitoring features, AWS Secrets Manager, AWS Key Management Service, IAM, and related services.
  • Build and maintain data integration pipelines using Matillion ETL and other enterprise data integration platforms.
  • Troubleshoot and resolve database issues, data quality concerns, application integration challenges, and performance bottlenecks across environments.
  • Perform database performance tuning and optimization using execution plans, indexing strategies, partitioning, optimizer statistics, and Oracle diagnostic and monitoring tools.
  • Collaborate with software engineers, architects, DevOps engineers, and business stakeholders to deliver scalable and reliable data solutions.
  • Participate in Agile development activities, including sprint planning, backlog refinement, daily standups, code reviews, sprint reviews, and retrospectives.
  • Contribute to DevSecOps and CI/CD initiatives by implementing automated testing, deployment, monitoring, and compliance practices for database solutions.
  • Create and maintain technical documentation, including database designs, data mappings, interface specifications, operational procedures, and support guides.
  • Develop and support database unit testing, regression testing, data validation testing, and automated test support for SQL, PL/SQL, ETL, and data migration changes.
  • Support production operations, release deployments, incident troubleshooting, root-cause analysis, and post-deployment validation for mission-critical database and application components.
  • Use approved AI-powered development tools to accelerate SQL and PL/SQL development, code review, troubleshooting, documentation, testing, and knowledge-sharing activities.
  • Identify and implement opportunities to apply AI and intelligent automation to database development, data engineering, deployment, monitoring, operational support, and engineering productivity.
  • Support data governance, security, privacy, and compliance requirements by implementing least-privilege access, auditability, encryption-aware data handling, and controls aligned with Federal standards such as FISMA, NIST, and FedRAMP where applicable.
  • Evaluate emerging database, cloud, AI, and data engineering technologies and recommend improvements that enhance platform capabilities and team productivity.

Desired Qualifications

  • Experience supporting Federal Government or large-scale enterprise applications.
  • Experience supporting Grants Management, Financial Management, Case Management, Regulatory, or workflow-driven systems.
  • Experience with Oracle Data Pump, Oracle GoldenGate, Informatica, Talend, ODI, Liquibase, Flyway, or similar data integration and migration tools.
  • Experience with Amazon Aurora PostgreSQL-Compatible Edition, SQL Server, MySQL, or other enterprise database platforms.
  • Experience supporting cloud modernization, database migration, or application modernization initiatives.
  • Knowledge of Federal data security and compliance practices, including audit logging, least-privilege access, encryption-aware data handling, and security controls aligned with FISMA, NIST, or FedRAMP requirements.
  • Experience with data warehousing concepts, dimensional modeling, enterprise reporting, and business intelligence platforms such as Power BI, Tableau, or Amazon QuickSight.
  • Experience supporting data pipelines and data platforms used for analytics, reporting, AI, and machine learning workloads.
  • Familiarity with AWS cloud-native application and service deployment architectures.
  • Oracle Certified Professional, Oracle Database Administrator Certified Professional, or Oracle SQL Certified Associate certification.
  • Experience evaluating and adopting emerging AI technologies to improve software engineering productivity, database development, operational efficiency, and modernization initiatives.
  • Familiarity with modern AI data architectures, vector databases, retrieval-augmented generation, AI agents, knowledge management systems, and enterprise AI platforms.
  • Experience participating in AI-driven modernization efforts, intelligent automation initiatives, or enterprise data and analytics programs.
  • Hands-on experience with AI-powered development tools such as GitHub Copilot, Microsoft Copilot, Amazon Q Developer, Cursor, ChatGPT Enterprise, Claude, Gemini, or similar platforms.

About the Company

Guidehouse

Advises agencies and runs regulated operations

Guidehouse advises government agencies and companies in regulated industries on strategy, technology and day-to-day operations. Its work combines business advice with software implementation and ongoing management, so a client uses the same firm to plan a change, build the systems and run the resulting processes. Teams modernize cloud platforms, apply data analysis and artificial intelligence, and redesign organizations to meet operating and regulatory requirements. Clients pay for consulting projects and technology work or outsource continuing business functions to its managed services teams. Guidehouse was founded in 2018 and is headquartered in McLean, Virginia.

Company size
10,001+
Company stage
Acquired
Total funding
$750K
Headquarters
McLean, VA
Founded
2018

Recently Posted Jobs

Explore more opportunities at Guidehouse

See more jobs