Senior Database Architect

Overview

Full Time

Skills

Inspection
Public Health
SOA
Relational Databases
Stored Procedures
Data Flow
Reporting
Data Acquisition
Systems Analysis/design
Recovery
Continuous Improvement
Data Structure
Storage
Accessibility
Interfaces
Technical Support
Training
Computer Hardware
Problem Solving
Conflict Resolution
Research
Emerging Technologies
Technical Writing
System Documentation
Security Clearance
Database Architecture
Computer Science
Information Systems
Microsoft SQL Server
Oracle
RDBMS
Cloud Computing
Microsoft Azure
Amazon RDS
Data Modeling
Extract
Transform
Load
Performance Tuning
Database Migration
SQL Azure
Migration
DevOps
Automated Testing
Continuous Integration
Continuous Delivery
Database
Analytical Skill
Communication
Agile
Mentorship
Legal
Authorization

Job Details

Overview

DecisionPoint Corporation is seeking a Senior Database Architect to join our team supporting the USDA Food Safety and Inspection Service's Public Health Information System (PHIS). In this role, you will be responsible for designing, optimizing, and migrating relational databases in both on-premises and cloud environments (including Azure Gov Cloud), as PHIS evolves toward a modern, service-oriented architecture.

This position is fully remote.

Duties & Responsibilities

  • Designs, maintains, enhances, codes, and migrates relational databases, queries, stored procedures, and jobs in both cloud and non-cloud environments, including migrations to cloud platforms
  • Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output/reporting capabilities
  • Develops data models and leads data acquisition, access analysis/design, and archive, recovery, and load strategy design and implementation
  • Coordinates new data development to ensure consistency and integration with existing data structures
  • Reviews business requests for data and data usage; researches and integrates new or improved data feeds
  • Participates in continuous improvement efforts to enhance performance and functionality
  • Designs data structures to support database production, storage, maintenance, and accessibility
  • Develops user interfaces (screens) and queries; tests designed database applications
  • Performs hardware and software upgrades and maintenance as required
  • Provides technical support, guidance, and training to end users and development teams
  • Maintains current knowledge of relevant hardware and software applications
  • May serve as team or technical task lead, offering problem-solving expertise and mentoring lower-level staff
  • Participates in special projects as required
  • Conducts technical and subject matter research on emerging technologies to assess impacts on application execution
  • Analyzes and documents client needs and requirements
  • Writes, modifies, and maintains technical documentation and specifications, including system documentation, entity-relationship diagrams, data models, and data dictionaries
Qualifications
  • Ability to obtain and maintain a Public Trust clearance.
  • Minimum 7 years of professional experience in database architecture, design, and administration.
  • Bachelor's degree in computer science, Information Systems, or a related field (or equivalent experience).
  • Technical Skills:
    • Expertise in SQL Server (on-prem and Azure Managed Instances), Oracle, or similar RDBMS.
    • Proficiency with cloud database services (Microsoft Azure SQL Database/Managed Instance, Amazon RDS/Aurora).
    • Strong skills in data modeling (logical and physical), ETL processes, and performance tuning.
    • Experience with database migration tools and strategies (e.g., Azure Database Migration Service).
    • Familiarity with Agile/DevOps practices, automated testing, and CI/CD pipelines for database deployments.
  • Excellent analytical, written, and verbal communication; proven ability to work collaboratively in cross-functional Agile teams; strong mentorship capabilities.
Our Equal Employment Opportunity Policy
  • EEO and Affirmative Action Policy: DecisionPoint Corporation is an Equal Employment Opportunity and Affirmative Action employer. It is the policy of DecisionPoint Corporation to provide equal employment opportunity in accordance with all applicable Equal Employment Opportunity/Affirmative Action laws, directives and regulations to all employees and qualified applicants without regard to race, ethnicity, color, religion, national origin, sex, age, disability status, pregnancy, sexual orientation, gender identity, genetic information, protected veteran status, or any other protected status under Federal, State or Local laws.
  • Pay Transparency Policy: In accordance with Presidential Executive Order 13665, DecisionPoint Corporation will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
  • Authorization to Share Resume and Personal Information: By expressing your interest and submitting your resume for this position, you authorize DecisionPoint Corporation to share your resume, as well as personal information included on the resume, with its subsidiaries, affiliates and teaming partners for the purpose of considering you for this position and other available positions requiring comparable skills, education and experience. Should DecisionPoint Corporation. or its affiliates and teaming partners wish to initiate pre-employment discussions, you will be asked to complete an employment application and related employment documents.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Decisionpoint Corporation