AWS Database Engineer
REI Systems2 years ago
Sterling, VA, USASenior
Responsibilities
- Design, develop, maintain, and optimize Oracle and PostgreSQL database solutions for enterprise applications.
- Create complex SQL, PL/SQL, and PL/pgSQL code, including packages, procedures, functions, triggers, views, materialized views, and sequences.
- Configure, administer, monitor, secure, and optimize AWS database services, including Amazon RDS, Redshift, S3, DMS, SCT, CloudWatch, Secrets Manager, KMS, and IAM.
- Perform database migrations, schema conversion, replication, CDC, validation, reconciliation, cutover planning, and post-migration verification.
- Develop ETL workflows, data transformation processes, batch processing solutions, data integration pipelines, and data quality checks.
- Implement database backup, recovery, high availability, encryption, access control, audit logging, credential management, and least-privilege controls.
- Support CI/CD pipelines, automated database deployments, unit testing, regression testing, deployment verification, production releases, and incident resolution.
- Maintain database designs, data mappings, deployment procedures, operational guides, and technical documentation.
- Use approved AI-assisted development tools for SQL development, optimization, testing, troubleshooting, documentation, and automation.
- Collaborate with application developers, cloud architects, DevOps engineers, data engineers, product owners, Agile teams, and federal stakeholders.
Requirements
- At least 5 years of professional experience in database engineering, Oracle development, ETL, data integration, or related software engineering.
- Strong hands-on experience with Oracle SQL and PL/SQL, including stored procedures, packages, functions, triggers, views, materialized views, complex queries, and performance tuning.
- Experience with SQL Developer and SQL*Loader.
- Hands-on experience with Amazon RDS for Oracle, Amazon RDS for PostgreSQL, Amazon Redshift, Amazon S3, AWS DMS, AWS SCT, Amazon CloudWatch, AWS Secrets Manager, AWS KMS, and IAM.
- Strong PostgreSQL and Amazon RDS for PostgreSQL experience, including PL/pgSQL development, administration, indexing, optimization, backup and recovery, high availability, and troubleshooting.
- Experience with database migrations and replication using AWS DMS and AWS SCT, including schema conversion, endpoint configuration, full-load migrations, CDC, validation, and cutover activities.
- Experience designing ETL workflows, data transformation, batch processing, data migration, and cloud-native data integration solutions such as Matillion ETL.
- Experience with relational database architecture, data modeling, normalization, indexing, transaction management, referential integrity, query optimization, database testing, and deployment verification.
- Experience supporting production database environments, incident management, root-cause analysis, application releases, CI/CD pipelines, DevSecOps practices, and database deployment automation.
- Experience with version control and development tools such as Git, GitHub, GitLab, Bitbucket, or Azure DevOps.
- Familiarity with AI-assisted development, responsible AI, data privacy, cybersecurity, and secure enterprise technology adoption.
- Ability to obtain and maintain a Federal Public Trust clearance; active Public Trust or federal suitability determination is preferred.
- Bachelor’s degree in Business, Engineering, Computer Science, or a related field; a master’s degree is preferred.
- Preferred experience includes federal systems, GrantSolutions, Oracle Data Pump, Oracle GoldenGate, Informatica, Talend, Oracle Data Integrator, Liquibase, Flyway, Amazon Aurora PostgreSQL-Compatible Edition, SQL Server, MySQL, data warehousing, Power BI, Tableau, Amazon QuickSight, FISMA, NIST, FedRAMP, vector databases, RAG, AI agents, and enterprise AI platforms.
- Preferred certifications include Oracle Certified Professional, Oracle Database Administrator Certified Professional, or Oracle SQL Certified Associate.
Benefits
- Hybrid work arrangement requiring two days per week at REI Systems’ Sterling, Virginia office.
- Professional development opportunities and meaningful projects.
- Flexibility to spend time with family and friends.
Tech Stack
Categories
BackendData Engineering
About REI Systems
REI Systems provides full-lifecycle software engineering, data analytics, and modernization services to U.S. federal, state, and local agencies and nonprofits, including grants and case management solutions and cloud implementations. The privately held, 100% employee-owned firm delivers consulting and systems integration and supports programs at agencies such as the FDA. Founded in 1989 and headquartered in Sterling, Virginia, it focuses on open source, SaaS, and application modernization.