> Markdown version of [/jobs/ext/3006238-database-architect](https://www.wearedevelopers.com/jobs/ext/3006238-database-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Database Architect - **Company:** Synergy Rents, LLC - **Location:** Reston, VA, United States (Remote available) - **Experience:** Expert - **Salary:** $157,500.0 - $225,000.0 - **Contract:** Permanent contract - **Skills:** Testing (Software), Agile Methodology, Amazon Web Services, Unit Testing, Microsoft Azure, Cloud Computing, Cloud Database, Cyber Security, Information Systems, Databases, Continuous Integration, Data Validation, Extract Transform Load (ETL), Data Migration, DevOps, Identity and Access Management, PostgreSQL, Liquibase, Microsoft Visio, Online Transaction Processing, Oracle (Applications), Performance Tuning, PostGIS, Lucidchart, Software Engineering, Spatial Data Infrastructures, PL-SQL, SQL*Plus, SQL Databases, SQL Server Integration Services, Web Applications, Esri GIS (Software), Scripting, Freeform SQL, Sql Optimization, Gitlab-ci, Information Technology, Cloudwatch, Oracle Cloud Infrastructure, Splunk, Software Version Control, Legacy Systems, Jenkins - **Published:** September 19, 2026 - **Apply:** https://jobs.localjobnetwork.com/apply/add/88386288/1 ## About the Role * Design and develop databases, schemas, PL/SQL, SQL*Plus, and scripts. * Support Agile modernization of legacy systems, including Oracle SDO/Esri PostgreSQL/PostGIS migrations. * Work independently with strong analytical and problemsolving skills. * Develop, implement, and test software on a modernized technology stack., * 7+ years Oracle development (tables, views, procedures, scripts). * 5+ years SQL/PLSQL; Oracle 19 experience. * PL/SQL unit testing experience. * PostgreSQL experience. * Enterprisewide application development. * Strong communication with management and development teams., Note: The U.S. Department of Education Database of Accredited Postsecondary Institutions and Programs located at https://amspub.abet.org/aps/name-search?searchType=institution identifies accredited postsecondary institutions. In Lieu of education requirement listed, candidate must have the required certification or will obtain required certification within 6 months of the start date. Certification requirement(s) for this role is AN IASAE II certification (CASP+CE, CLSSP associate) or CSSLP., * Ability to attain Federal Government Position of Trust. Ability to obtain a public trust clearance. * Must be a U.S. citizen * Must pass a background investigation ## Description * Translate requirements with product owners, analysts, and design leads. * Create tables, views, procedures, and scripts for web application support. * Write and optimize complex SQL queries to support application * Participate in Agile development processes and ability to adapt to changing requirements * Lead onpremise cloud database migration efforts. * Establish scalable enterprise database architecture and standards. * Implement EA principles for cost reduction, security, and performance improvements. * Serve as technical lead across multiple projects; define architecture and quality procedures. * Advise clients on secure, scalable database architecture. * Collaborate with management across multiple departments and functional areas. Core Competencies Architecture & Modeling * Logical/physical/conceptual data modeling; ERWin/Lucidchart/Visio use. * Schema design for OLTP/reporting workloads; enforcement of DB standards. PostgreSQL & PostGIS * PL/pgSQL scripting; indexing/partitioning; vacuum/maintenance tuning. * Spatial data modeling, transformation, optimization. Oracle & PL/SQL * Advanced PL/SQL (packages, triggers, procedures). * Bulk operations, tuning, SDO spatial experience; complex hierarchical queries. Cloud & Infrastructure * Cloudready DB designs (AWS/Azure/OCI). * HA/DR strategies, IAM/security models, cloud migration tooling (AWS DMS, ETL pipelines). ETL & Data Migration * ETL tools (ODI, SSIS, Informatica); custom migration scripts. * Data validation, reconciliation, cutover/rollback planning. DevOps / CI/CD * Automated DB deployments (Liquibase, Flyway, Jenkins, GitLab CI). * Version control for DB artifacts; automated unit testing. Performance & Monitoring * SQL optimization, plan analysis; Splunk/CloudWatch/Oracle monitoring. * Troubleshooting largescale performance bottlenecks. Leadership * Mentor developers; lead Agile technical decisionmaking. * Define coding standards, architecture reviews, and best practices. Soft Skills * Strong communication, stakeholder alignment, analytical thinking. * Ability to make independent architecture decisions across projects., * A BS degree in Information Technology, Cybersecurity, Data Science, Information Systems, or Computer Science, from an ABET accredited or CAE designated institution fulfills the educational requirement . ## Related Videos - [Our journey with Spring Boot in a microservice architecture](https://www.wearedevelopers.com/videos/511-our-journey-with-spring-boot-in-a-microservice-architecture) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [DevOps Maturity Check – a way to balance autonomy and alignment](https://www.wearedevelopers.com/videos/58-devops-maturity-check-a-way-to-balance-autonomy-and-alignment) - [Database Magic behind 40 Million operations/s](https://www.wearedevelopers.com/videos/748-database-magic-behind-40-million-operations-s) - [#90DaysOfDevOps - The DevOps Learning Journey](https://www.wearedevelopers.com/videos/548-90daysofdevops-the-devops-learning-journey) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)