Senior Database Architect/Senior Database Engineer

Job not on LinkedIn

🔥 1 minute ago

🇺🇸 United States – Remote

⏰ Full Time

🟠 Senior

🔙 Backend Engineer

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Precise Software Solutions, Inc.

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2003

🏛️ Government

🤖 Artificial Intelligence

🤝 B2B

Government • Artificial Intelligence • B2B

Precise Software Solutions, Inc. is a government-focused IT services company that delivers agile, secure, and scalable cloud, data, and application modernization solutions to federal, state, and local agencies. The company provides digital experience design, data and analytics, mission enablement, and AI/ML services to help public-sector clients improve citizen engagement, interoperability, and mission performance. Precise emphasizes culture and leadership while executing contract-based work for government customers.

📋 Description

• Participate directly in requirements elicitation and analysis sessions with business users, Business Analysts, application teams, and government customers • Translate functional, technical, performance, security, and operational requirements into database and data architecture solutions • Help stakeholders visualize application data entities, relationships, structures, interfaces, and processing requirements • Evaluate technical alternatives and communicate architectural trade-offs • Recommend architectures that satisfy current requirements while supporting anticipated growth and modernization • Develop conceptual, logical, and physical data models • Establish logical database architecture as the foundation for physical implementation • Design scalable, high-performance relational database architectures • Create and maintain database architecture diagrams using Erwin, Visio, or comparable tools • Define schemas, relationships, constraints, partitioning, indexing, and storage strategies • Apply normalization and denormalization techniques • Establish database naming conventions, modeling standards, metadata standards, and architectural guidelines • Design high availability, replication, disaster recovery, backup, business continuity, and data retention solutions • Evaluate relational and NoSQL database technologies • Design and develop Oracle database solutions for enterprise applications • Develop and review PL/SQL, SQL queries, stored procedures, packages, functions, triggers, DDL scripts, and database deployment scripts • Create database objects and scripts supporting application releases • Perform and support data migrations and database transformation activities • Troubleshoot application issues involving database logic, scripts, scheduled jobs, and data processing • Support application developers with database design and development decisions • Document database deployment procedures for FDA database administrators • Estimate database sizing, retention requirements, transaction patterns, and growth projections • Analyze latency and throughput requirements • Conduct workload analysis and capacity planning • Monitor and evaluate database performance and identify bottlenecks • Perform SQL and PL/SQL performance tuning • Develop indexing, partitioning, caching, and query optimization strategies • Design database solutions for cloud and hybrid environments • Support modernization and migration of legacy on-premises databases to cloud platforms • Evaluate managed database services, traditional platforms, and cloud-native technologies • Support Infrastructure as Code and automated database provisioning • Design architectures aligned with federal security and compliance requirements • Recommend controls for encryption, access control, auditing, logging, monitoring, backup, recovery, and data protection • Work with cybersecurity teams to meet applicable federal security controls • Establish data architecture standards and support metadata, data dictionary, governance, lifecycle, retention, archival, and disposition activities • Integrate database changes into application CI/CD processes • Develop repeatable database deployment and rollback processes • Automate database provisioning, deployment, monitoring, and maintenance • Serve as a senior technical advisor and participate in architecture reviews and technical design sessions • Communicate architecture concepts to government customers, business users, developers, infrastructure teams, security teams, and project leadership • Collaborate with Business Analysts and application architects • Mentor database administrators, developers, and engineers • Review team database designs and implementation approaches • Anticipate future data, performance, integration, and technology needs

🎯 Requirements

• Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Management, or a related discipline, or equivalent combination of education and relevant professional experience • 8+ years of progressive database experience • At least 5 years of database architecture or application database architecture experience • Demonstrated database architecture responsibility on at least two significant enterprise application or modernization projects • Experience designing databases rather than solely administering existing database environments • Experience working directly with customers and business stakeholders during requirements analysis and solution design • Strong experience developing conceptual, logical, and physical data models • Experience using data modeling and architecture tools such as Erwin and/or Microsoft Visio • Strong relational database architecture and design knowledge • Advanced knowledge of Oracle databases and PL/SQL • Experience with SQL, PL/SQL, DDL, stored procedures, packages, functions, triggers, and database scripting • Strong understanding of database naming conventions and data modeling standards • Experience with application database development • Experience designing database solutions for mission-critical enterprise applications • Strong understanding of database performance tuning, indexing, workload analysis, and capacity planning • Experience estimating database size and growth based on projected data volumes • Understanding of database latency, concurrency, parallel processing, distributed processing, and scalability considerations • Knowledge of high availability, disaster recovery, replication, backup, and recovery strategies • Experience with at least one major cloud platform such as AWS or Microsoft Azure • Strong written and verbal communication skills • Ability to explain complex technical concepts to technical and non-technical stakeholders • Strong analytical, problem-solving, and strategic-thinking skills • Ability to obtain and maintain a Public Trust background investigation • Preferred: experience supporting FDA, HHS, or other federal government programs • Preferred: experience modernizing legacy applications and database architectures • Preferred: experience migrating on-premises databases to cloud environments • Preferred: experience with Oracle Data Pump and Oracle 19c or other current enterprise Oracle releases • Preferred: knowledge of PostgreSQL, SQL Server, MySQL, or other relational database platforms • Preferred: experience with NoSQL technologies such as MongoDB, DynamoDB, Cassandra, or Cosmos DB • Preferred: experience with data warehousing, ETL/ELT, and data lake architectures • Preferred: experience with UNIX/Linux shell scripting and scheduled processing • Preferred: experience supporting CI/CD pipelines for database deployments • Preferred: experience using Infrastructure as Code technologies such as Terraform, CloudFormation, ARM, or Bicep • Preferred: experience with enterprise integration and data exchange platforms • Preferred: experience implementing database auditing and monitoring solutions • Preferred: familiarity with federal security requirements including FISMA, NIST SP 800-53, and FedRAMP • Preferred: understanding of master data management, metadata management, and enterprise data governance • Preferred: experience with Oracle Forms, WebLogic, Exadata, or related Oracle enterprise technologies • Preferred certifications: Oracle Database certification; AWS database or solutions architecture certification; Microsoft Azure Database Administrator Associate; Microsoft Azure Solutions Architect Expert; Certified Data Management Professional (CDMP); TOGAF or comparable architecture certification

🏖️ Benefits

• Comprehensive Health Benefits (Medical, Dental and Vision) • Flexible Spending Accounts (FSA) & Health Savings Account (HSA) • Retirement Plan with 4% match and discretionary match at year end • Paid Time Off (PTO): 15 days of PTO accrued per year • 7 holidays + 3 Floating holidays • 2 Innovation days (paid training days) • Short Term and Long-Term Disability • Paid Parental Leave • Paid Jury Duty leave • Life and AD&D Insurance • Critical Illness Insurance • Training and Development • Wellness Incentives & Discount programs • Employee Referral Program • Annual Charity Donation Match • Awards and Recognition