Database Architect/Senior Database Engineer

Job Description

Job Description:\n\nDescription:\n \nPosition Summary\nPrecise Software Solutions, Inc. is seeking an experienced Database Architect / Senior Database Engineer to support a large, mission-critical FDA modernization program. This individual will serve as a senior technical resource responsible for translating business and application requirements into scalable, secure, high-performing database architectures and data models.\n\nThis role requires more than traditional database administration. The successful candidate must be a strategic thinker and experienced application database architect who can participate directly in requirements analysis, engage with government customers and business stakeholders, visualize future-state data needs, and establish the logical and physical database architecture required to support modernized applications.\n\nThe Database Architect will work closely with Business Analysts, application architects, developers, infrastructure engineers, cybersecurity teams, DBAs, and government stakeholders to design database solutions that balance performance, scalability, security, reliability, maintainability, compliance, and cost.\n\nThe ideal candidate has successfully architected databases for multiple enterprise applications and understands the distinction between administering an existing database and designing the database architecture that applications will depend upon.\n\nSuccessful candidates must be able to obtain and maintain a Public Trust background investigation.\n\nThis position is contingent upon a contract award\n\nKey Responsibilities \nRequirements Analysis and Solution Architecture\n\n Participate directly in requirements elicitation and analysis sessions with business users, Business Analysts, application teams, and government customers.\n Translate functional, technical, performance, security, and operational requirements into database and data architecture solutions.\n Help stakeholders visualize how application requirements translate into data entities, relationships, structures, interfaces, and processing requirements.\n Identify architectural considerations including: \n \n Expected data volumes and future growth.\n Transaction volumes and workload patterns.\n Data latency requirements.\n Availability and recovery requirements.\n Concurrent processing requirements.\n Parallel processing and multiple database instance requirements.\n Integration and data exchange requirements.\n \n Evaluate technical alternatives and communicate architectural trade-offs to technical and non-technical stakeholders.\n Recommend the simplest architecture that satisfies current requirements while supporting anticipated growth and modernization.\n\nDatabase Architecture and Data Modeling\n\n Develop conceptual, logical, and physical data models based on application and business requirements.\n Establish the logical database architecture first as the foundation for the physical database implementation.\n Design scalable, high-performance relational database architectures.\n Create and maintain database architecture diagrams using tools such as Erwin, Visio, or comparable modeling tools.\n Define database physical structures, schemas, relationships, constraints, partitioning, indexing, and storage strategies.\n Apply appropriate normalization and denormalization techniques based on application and performance requirements.\n Establish and enforce database naming conventions, modeling standards, metadata standards, and architectural guidelines.\n Design solutions supporting high availability, replication, disaster recovery, backup, business continuity, and data retention.\n Understand and design distributed database architectures and processing strategies where appropriate.\n Evaluate appropriate use of relational and NoSQL database technologies.\n\nOracle and Database Development\n\n Design and develop Oracle database solutions supporting enterprise applications.\n Develop and review: \n \n PL/SQL\n SQL queries\n Stored procedures\n Packages\n Functions\n Triggers\n DDL scripts\n Database deployment scripts\n \n Create database objects and scripts required to support application releases.\n Perform and support data migrations and database transformation activities.\n Troubleshoot application issues involving database logic, PL/SQL, SQL, stored procedures, UNIX shell scripts, scheduled jobs, or data processing.\n Support application developers with database design and development decisions.\n Document database deployment procedures for implementation by FDA database administrators in higher environments.\n\nPerformance, Scalability, and Capacity Planning\n\n Estimate database sizing based on expected data volumes, retention requirements, transaction patterns, and growth projections.\n Analyze latency and throughput requirements for database and application interactions.\n Design database architectures capable of supporting high-volume and parallel processing workloads.\n Conduct workload analysis and capacity planning.\n Monitor and evaluate database performance.\n Identify performance bottlenecks and recommend architectural or configuration improvements.\n Perform SQL and PL/SQL performance tuning.\n Develop effective indexing, partitioning, caching, and query optimization strategies.\n Optimize database solutions for performance, reliability, scalability, and cost.\n\nCloud and Modernization Architecture\n\n Design database solutions for cloud and hybrid environments.\n Support modernization and migration of legacy on-premises database solutions to cloud platforms.\n Experience with database services in one or more of the following: \n \n AWS\n Microsoft Azure\n Google Cloud Platform\n \n Evaluate managed database services, traditional database platforms, and cloud-native database technologies based on application requirements.\n Design architectures that support modernization, scalability, automation, resiliency, and security.\n Support Infrastructure as Code and automated database provisioning using technologies such as Terraform, CloudFormation, ARM, or Bicep where applicable.\n\nSecurity and Compliance\n\n Design database architectures consistent with federal security and compliance requirements.\n Implement or recommend controls for: \n \n Encryption at rest and in transit\n Role-based access control\n Least-privilege access\n Database auditing\n Logging and monitoring\n Backup and recovery\n Data protection\n \n Support security documentation and vulnerability analysis activities.\n Work with cybersecurity teams to ensure database solutions meet applicable federal security controls.\n Experience with or understanding of frameworks such as: \n \n FISMA\n NIST SP 800-53\n FedRAMP\n \n Ensure database integrity, confidentiality, availability, and audit readiness.\n\nData Governance\n\n Establish and maintain database and data architecture standards.\n Define and enforce naming conventions.\n Promote data quality, consistency, integrity, and traceability.\n Support metadata management and data dictionary development.\n Define database documentation standards, procedures, and data definitions.\n Support data lifecycle, retention, archival, and disposition requirements.\n Apply master data management principles where appropriate.\n\nDevOps and Database Automation\n\n Integrate database changes into application CI/CD processes.\n Support source control of database objects, scripts, and configuration artifacts.\n Develop repeatable database deployment and rollback processes.\n Automate database provisioning, deployment, monitoring, and maintenance where appropriate.\n Collaborate with DevSecOps and infrastructure teams to improve consistency and repeatability across environments.\n\nTechnical Leadership and Collaboration\n\n Serve as a senior technical advisor for database architecture decisions.\n Lead or participate in architecture reviews and technical design sessions.\n Communicate database architecture concepts clearly to government customers, business users, developers, infrastructure teams, security teams, and project leadership.\n Work closely with Business Analysts to ensure database designs accurately reflect business requirements.\n Collaborate with application architects to ensure alignment between application and database architectures.\n Mentor database administrators, developers, and engineers.\n Review database designs and implementation approaches developed by other team members.\n Influence technical decisions through analysis, expertise, and collaboration rather than relying solely on authority.\n Anticipate future data, performance, integration, and technology needs.\nRequirements:\n\n Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Management, or a related discipline, or equivalent combination of education and relevant professional experience.\n 8+ years of progressive database experience.\n At least 5 years of database architecture or application database architecture experience.\n Demonstrated database architecture responsibility on at least two significant enterprise application or modernization projects.\n Experience designing databases rather than solely administering existing database environments.\n Experience working directly with customers and business stakeholders during requirements analysis and solution design.\n Strong experience developing conceptual, logical, and physical data models.\n Experience using data modeling and architecture tools such as Erwin and/or Microsoft Visio.\n Strong relational database architecture and design knowledge.\n Advanced knowledge of Oracle databases and PL/SQL.\n Experience with:\n\n o SQL\n o PL/SQL\n o DDL\n o Stored procedures\n o Packages\n o Functions\n o Triggers\n o Database scripting\n\n Strong understanding of database naming conventions and data modeling standards.\n Experience with application database development.\n Experience designing database solutions for mission-critical enterprise applications.\n Strong understanding of database performance tuning, indexing, workload analysis, and capacity planning.\n Experience estimating database size and growth based on projected data volumes.\n Understanding of database latency, concurrency, parallel processing, distributed processing, and scalability considerations.\n Knowledge of high availability, disaster recovery, replication, backup, and recovery strategies.\n Experience with at least one major cloud platform such as AWS or Microsoft Azure.\n Strong written and verbal communication skills.\n Ability to explain complex technical concepts to technical and non-technical stakeholders.\n Strong analytical, problem-solving, and strategic-thinking skills.\n Ability to obtain and maintain a Public Trust background investigation.\n\nPreferred Qualifications \n\n Experience supporting FDA, HHS, or other federal government programs.\n Experience modernizing legacy applications and database architectures.\n Experience migrating on-premises databases to cloud environments.\n Experience with Oracle Data Pump.\n Experience with Oracle 19c or other current enterprise Oracle releases.\n Knowledge of PostgreSQL, SQL Server, MySQL, or other relational database platforms.\n Experience with NoSQL technologies such as MongoDB, DynamoDB, Cassandra, or Cosmos DB when appropriate.\n Experience with data warehousing, ETL/ELT, and data lake architectures.\n Experience with UNIX/Linux shell scripting and scheduled processing.\n Experience supporting CI/CD pipelines for database deployments.\n Experience using Infrastructure as Code technologies such as Terraform, CloudFormation, ARM, or Bicep.\n Experience with enterprise integration and data exchange platforms.\n Experience implementing database auditing and monitoring solutions.\n Familiarity with federal security requirements including FISMA, NIST SP 800-53, and FedRAMP.\n Understanding of master data management, metadata management, and enterprise data governance.\n Experience with Oracle Forms, WebLogic, Exadata, or related Oracle enterprise technologies is beneficial.\n\nPreferred Certifications\nOne or more of the following certifications is desirable but not required:\n\n Oracle Database certification\n AWS database or solutions architecture certification\n Microsoft Azure Database Administrator Associate\n Microsoft Azure Solutions Architect Expert\n Certified Data Management Professional (CDMP)\n TOGAF or comparable architecture certification\n\nKey Competencies\nThe successful candidate will demonstrate:\n\n Strategic thinking\n Customer engagement\n Requirements analysis\n Database architecture judgment\n Strong data visualization and modeling skills\n Excellent communication\n Technical leadership\n Attention to detail\n Strong documentation skills\n Collaboration and stakeholder management\n Decision-making under uncertainty\n Ability to balance performance, security, cost, calability, and maintainability\n Ability to anticipate future architectural needs rather than addressing only immediate technical issues\n\nABOUT US\nPrecise Software Solutions, Inc. is a mission-focused technology services company delivering secure digital platforms, infrastructure, and operational IT services to government organizations. A CMMI Level 3–appraised company, Precise partners with agency technology leaders and solution providers to design, build, operate, and modernize enterprise IT solutions that support critical public missions combining agility, innovation, and performance to deliver measurable results. \nPrecise specializes in cloud and hybrid infrastructure, platform engineering, security operations and compliance, application modernization, and data platforms and analytics. The company is known for its agile, delivery-driven approach and innovative engineering practices, applying operational rigor and performance-focused execution to improve system resilience, security, and scalability across complex government environments.\n\nBENEFITS AND PERKS\n\n Comprehensive Health Benefits (Medical, Dental and Vision) \n Flexible Spending Accounts (FSA) & Health Savings Account (HSA) \n Retirement Plan with 4% match and discretionary match at year end\n Paid Time Off (PTO): 15 days of PTO accrued per year; 7 holidays+ 3 Floating holidays; 2 Innovation days (paid training days)\n Short Term and Long-Term Disability\n Paid Parental Leave \n Paid Jury Duty leave \n Life and AD&D Insurance \n Critical Illness Insurance\n Training and Development \n Wellness Incentives & Discount programs\n Employee Referral Program \n Annual Charity Donation Match \n Awards and Recognition\n\nEqual Employment Opportunity Statement\nPrecise Software Solutions is committed to providing a workplace free from discrimination and harassment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, age, national origin, disability, sexual orientation, gender identity or expression, marital status, genetic information, protected veteran status, or other legally protected status.\n\nWe are an inclusive organ