480 Database Architect jobs in the United States

Req ID: 36325

Summary

Database Architect

Washington D.C

Are you ready to enhance your skills and build your career in a rapidly evolving business climate? Are you looking for a career where professional development is embedded in your employer's core culture? If so, Chenega Military, Intelligence & Operations Support (MIOS) could be the place for you! Join our team of professionals who support large-scale government operations by leveraging cutting-edge technology and take your career to the next level!

We deliver essential technology services to our customers in support of their missions to sustain national security and economic interests. SecuriGence is seeking a mission-focused Database Architect to join our team in support of the FCC Enterprise Engineering and Architecture Services (EE&AS) Program, leading the design and implementation of modern data lake and data fabric architectures supporting secure, scalable, and compliant data platforms across AWS and Azure environments. This role supports public sector initiatives, including cloud modernization, data integration, and mission-critical analytics for federal and government clients.

Responsibilities

Data Management & Architecture

• Develop data management strategies ensuring high availability

• Lead large-scale data management, warehousing, or analytics projects

• Design and implement federated data architectures, including data lakes, lakehouses, and data fabrics, to support multi-source integration and cross-agency data sharing

• Architect secure and resilient data pipelines using AWS (S3, Lake Formation, Glue) and Azure (Data Lake Storage Gen2, Synapse, Purview)

Technical Leadership

• Demonstrate industry leadership in database design and development, data warehousing, data governance, or data sciences

• Provide technical guidance and leadership to the development team

• Optimize database performance through appropriate design and configuration

• Develop scalable ingestion, transformation, and analytics solutions using cloud-native services (e.g., AWS Redshift, Azure Data Factory, Databricks)

• Integrate structured, semi-structured, and unstructured data sources into centralized repositories for reporting, ML/AI, and decision support

Governance, Security & Compliance

• Ensure data security and privacy by following industry best practices

• Apply federal standards such as NIST SP 800-53, FedRAMP, and FISMA to ensure data confidentiality, integrity, and availability

• Establish and enforce metadata management, data lineage, and audit traceability using tools like AWS Glue Data Catalog and Azure Purview

• Support Privacy Act, CUI, and PII data handling across the data lifecycle

Stakeholder Engagement & Delivery

• Collaborate with stakeholders to understand business requirements and design data models that meet those requirements

• Develop and maintain data dictionaries and metadata repositories

• Collaborate with federal data stewards, program managers, and system integrators to develop and align data architecture to agency mission needs

• Contribute to technical documentation, data architecture blueprints, and roadmap planning artifacts in support of modernization initiatives

• Other duties as assigned

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, or related field

• Education requirement may be substituted with 4+ years of relevant experience

• 7+ years of experience in database and data architecture, with at least 1 year designing and delivering solutions in AWS and/or Azure

• Must be legally authorized to work in the United States without employer sponsorship, now or at any time in the future

• Ability to obtain a Public Trust (PT); Current PT preferred

Knowledge, Skills and Abilities:

• Extensive knowledge of databases, primarily Oracle and other relational and non-relational databases such as Netezza, Oracle, SQL, PostgreSQL, and RDF

• Expertise in data lake and data fabric concepts, metadata cataloging, and federated query systems

• Proficiency in SQL, Python, Spark, and infrastructure-as-code (e.g., Terraform, CloudFormation, Bicep)

• Familiarity with DevSecOps pipelines and CI/CD integration for data deployments

• Experience leading large-scale data management, warehousing, or analytics projects

• Demonstrated industry leadership in database design and development, data warehousing, or data sciences

• Solid understanding of data mining, acquisitions, database architecture, administration, data migration, replication, archive recovery, design, modeling, analysis, and metadata repository creation

• Strong communication and data presentation skills

How you'll grow

At Chenega MIOS, our professional development plan focuses on helping our team members at every level of their careers to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there's always room to learn.

We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their careers.

Benefits

At Chenega MIOS, we know that great people make a great organization. We value our team members and offer them a broad range of benefits.

Learn more about what working at Chenega MIOS can mean for you.

Chenega MIOS's culture

Our positive and supportive culture encourages our team members to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them be healthy, centered, confident, and aware. We offer well-being programs and continuously look for new ways to maintain a culture where we excel and lead healthy, happy lives.

Corporate citizenship

Chenega MIOS is led by a purpose to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our team members, and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities.

Learn more about Chenega's impact on the world.

Chenega MIOS News-

Tips from your Talent Acquisition Team

We want job seekers exploring opportunities at Chenega MIOS to feel prepared and confident. To help you with your research, we suggest you review the following links:

Chenega MIOS web site -

Glassdoor -

LinkedIn -

Facebook -

#DICE

Teleworking Permitted?

Yes

Teleworking Details

Hybrid Schedule

Estimated Salary/Wage

USD $140,000.00/Yr. Up to USD $175,000.00/Yr.

Chenega Corporation and family of companies is an EOE.

Equal Opportunity Employer/Veterans/Disabled

Native preference under PL 93-638.

We participate in the E-Verify Employment Verification Program

Database Architect

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: Secret

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Continental US

The Opportunity:

Are you ready to revolutionize financial auditability and transportation logistics? We're seeking talented Database Architects to join our team in implementing a cutting-edge software system that will transform how businesses manage their finances and supply chains. From program management and cybersecurity to systems engineering and process optimization, we have exciting opportunities across multiple disciplines. *

If you're passionate about leveraging technology to streamline operations and enhance transparency, this is your chance to make a significant impact. Join us in building the future of financial and logistical management - your expertise could be the key to our success!

*Positions contingent upon contract award.

Responsibilities:

Intermediate:

• Designs and implements strategies for enterprise database systems.

• Establishes and enforces standards for database operations, programming, and security.

• Designs and constructs large relational databases to meet complex business requirements.

• Leads the integration of new systems with existing warehouse structures.

• Refines system performance and functionality through ongoing optimization efforts.

• Develops and maintains comprehensive database documentation.

• Manages data migration projects and complex ETL (Extract, Transform, Load) processes.

• Implements and maintains robust database security measures and best practices.

Senior:

• Designs and implements comprehensive strategies for enterprise database systems.

• Establishes and enforces standards for database operations, programming, and security across the organization.

• Leads the design and construction of large-scale relational databases to meet complex business requirements.

• Oversees the integration of new systems with existing warehouse structures, ensuring seamless data flow and consistency.

• Drives continuous improvement in system performance and functionality through advanced optimization techniques.

• Develops and maintains enterprise-level database documentation and best practices.

• Leads complex data migration projects and oversee ETL (Extract, Transform, Load) processes.

• Implements and manages robust database security measures, ensuring compliance with industry standards and regulations.

Subject Matter Expert/SME:

• Designs and implement cutting-edge strategies for enterprise database systems, setting the technological direction for the organization.

• Establishes and evolves standards for database operations, programming, and security across the enterprise.

• Architects and constructs large-scale, high-performance relational databases to meet complex business requirements and future scalability needs.

• Leads the integration of new systems with existing warehouse structures, ensuring seamless data flow and optimal performance.

• Drives continuous refinement of system performance and functionality through innovative optimization techniques.

• Provides expert guidance on data modeling, normalization, and advanced database design principles.

• Oversees and optimizes complex data migration projects and ETL (Extract, Transform, Load) processes.

• Develops and implements forward-thinking database security strategies to protect critical data assets.

Qualifications:

Required:

Intermediate:

• Bachelor's degree in Computer Science, Information Technology, Database Management, or a related field (equivalent combination of education and experience may be considered in lieu of degree)

• 3-8 years of experience in database architecture or related roles

• US Citizen with ability to obtain and maintain Secret clearance upon hire

• Strong proficiency in relational database management systems (e.g., Oracle, SQL Server, PostgreSQL).

• Advanced knowledge of SQL and database design principles.

• Experience with data modeling, normalization, and optimization techniques.

• Solid understanding of database security and performance tuning.

• Excellent problem-solving and analytical skills.

• Strong communication and teamwork abilities

Senior:

• Bachelor's degree in Computer Science, Information Technology, Database Management, or a related field (equivalent combination of education and experience may be considered in lieu of degree)

• 8-11 years of extensive experience in database architecture and management

• US Citizen with ability to obtain and maintain Secret clearance upon hire

• Expert-level proficiency in multiple relational database management systems (e.g., Oracle, SQL Server, PostgreSQL).

• Advanced knowledge of database design principles, data modeling, and normalization techniques.

• Extensive experience in database performance tuning and optimization.

• Strong understanding of data warehousing, business intelligence, and analytics.

• Proven ability to lead teams and manage complex database projects.

• Excellent problem-solving, analytical, and communication skills

Subject Matter Expert/SME:

• Master's degree in Computer Science, Information Technology, Database Management, or a related field (equivalent combination of education and experience may be considered in lieu of degree)

• 12+ years of progressive experience in database architecture, with a proven track record of leading enterprise-scale database initiatives

• US Citizen with ability to obtain and maintain Secret clearance upon hire

• Recognized thought leader in database technologies with contributions to industry practices or academic research.

• Expert-level proficiency across multiple database platforms and technologies.

• Comprehensive mastery of database architecture, design patterns, and emerging data technologies.

• Extensive experience in database security, compliance, and governance at a global scale.

• Proven ability to lead and mentor high-performance database teams.

• Outstanding communication skills, capable of influencing C-level executives and technical teams alike

Desired:

Intermediate:

• Experience with NoSQL databases and big data technologies. Knowledge of data warehousing and business intelligence concepts.

• Proficiency in database performance tuning and query optimization.

• Familiarity with cloud-based database services (e.g., Amazon RDS, Azure SQL Database, Google Cloud SQL).

• Experience with data analytics tools and techniques.

• Knowledge of version control systems for database schema management

• Relevant database certifications (e.g., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator Associate)

Senior:

• Master's degree

• Experience with NoSQL databases and big data technologies (e.g., Hadoop, Spark).

• Expertise in data warehousing architectures and methodologies.

• Proficiency in cloud-based database services and migration strategies.

• Knowledge of machine learning and AI applications in database management.

• Experience with database high availability and disaster recovery solutions.

• Familiarity with DevOps practices for database development.

• Relevant advanced database certifications

Subject Matter Expert/SME:

• PhD

• Contributions to database technology standards or patents. Expertise in NoSQL databases, big data technologies, and data lakes.

• Advanced knowledge of cloud-native database architectures and services.

• Experience with AI/ML applications in database management and optimization.

• Proficiency in data analytics, business intelligence, and data visualization technologies.

• Track record of successful large-scale database transformations and migrations.

• Relevant advanced certifications (e.g., Oracle Certified Master, Microsoft Certified: Azure Database Administrator Expert)

This position is contingent on funding and may not be filled immediately. However, this position is representative of positions within CACI that are consistently available. Individuals who apply may also be considered for other positions at CACI.

___

What You Can Expect:

A culture of integrity.

At CACI, we place character and innovation at the center of everything we do. As a valued team member, you'll be part of a high-performing group dedicated to our customer's missions and driven by a higher purpose - to ensure the safety of our nation.

An environment of trust.

CACI values the unique contributions that every employee brings to our company and our customers - every day. You'll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.

A focus on continuous growth.

Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground - in your career and in our legacy.

Your potential is limitless. So is ours.

Learn more about CACI here. (

___

Pay Range : There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. Learn more here ( .

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is:

$75,200-$158,100

CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.

Database Architect

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: Secret

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Continental US

The Opportunity:

Are you ready to revolutionize financial auditability and transportation logistics? We're seeking talented Database Architects to join our team in implementing a cutting-edge software system that will transform how businesses manage their finances and supply chains. From program management and cybersecurity to systems engineering and process optimization, we have exciting opportunities across multiple disciplines. *

If you're passionate about leveraging technology to streamline operations and enhance transparency, this is your chance to make a significant impact. Join us in building the future of financial and logistical management - your expertise could be the key to our success!

*Positions contingent upon contract award.

Responsibilities:

Intermediate:

• Designs and implements strategies for enterprise database systems.

• Establishes and enforces standards for database operations, programming, and security.

• Designs and constructs large relational databases to meet complex business requirements.

• Leads the integration of new systems with existing warehouse structures.

• Refines system performance and functionality through ongoing optimization efforts.

• Develops and maintains comprehensive database documentation.

• Manages data migration projects and complex ETL (Extract, Transform, Load) processes.

• Implements and maintains robust database security measures and best practices.

Senior:

• Designs and implements comprehensive strategies for enterprise database systems.

• Establishes and enforces standards for database operations, programming, and security across the organization.

• Leads the design and construction of large-scale relational databases to meet complex business requirements.

• Oversees the integration of new systems with existing warehouse structures, ensuring seamless data flow and consistency.

• Drives continuous improvement in system performance and functionality through advanced optimization techniques.

• Develops and maintains enterprise-level database documentation and best practices.

• Leads complex data migration projects and oversee ETL (Extract, Transform, Load) processes.

• Implements and manages robust database security measures, ensuring compliance with industry standards and regulations.

Subject Matter Expert/SME:

• Designs and implement cutting-edge strategies for enterprise database systems, setting the technological direction for the organization.

• Establishes and evolves standards for database operations, programming, and security across the enterprise.

• Architects and constructs large-scale, high-performance relational databases to meet complex business requirements and future scalability needs.

• Leads the integration of new systems with existing warehouse structures, ensuring seamless data flow and optimal performance.

• Drives continuous refinement of system performance and functionality through innovative optimization techniques.

• Provides expert guidance on data modeling, normalization, and advanced database design principles.

• Oversees and optimizes complex data migration projects and ETL (Extract, Transform, Load) processes.

• Develops and implements forward-thinking database security strategies to protect critical data assets.

Qualifications:

Required:

Intermediate:

• Bachelor's degree in Computer Science, Information Technology, Database Management, or a related field (equivalent combination of education and experience may be considered in lieu of degree)

• 3-8 years of experience in database architecture or related roles

• US Citizen with ability to obtain and maintain Secret clearance upon hire

• Strong proficiency in relational database management systems (e.g., Oracle, SQL Server, PostgreSQL).

• Advanced knowledge of SQL and database design principles.

• Experience with data modeling, normalization, and optimization techniques.

• Solid understanding of database security and performance tuning.

• Excellent problem-solving and analytical skills.

• Strong communication and teamwork abilities

Senior:

• Bachelor's degree in Computer Science, Information Technology, Database Management, or a related field (equivalent combination of education and experience may be considered in lieu of degree)

• 8-11 years of extensive experience in database architecture and management

• US Citizen with ability to obtain and maintain Secret clearance upon hire

• Expert-level proficiency in multiple relational database management systems (e.g., Oracle, SQL Server, PostgreSQL).

• Advanced knowledge of database design principles, data modeling, and normalization techniques.

• Extensive experience in database performance tuning and optimization.

• Strong understanding of data warehousing, business intelligence, and analytics.

• Proven ability to lead teams and manage complex database projects.

• Excellent problem-solving, analytical, and communication skills

Subject Matter Expert/SME:

• Master's degree in Computer Science, Information Technology, Database Management, or a related field (equivalent combination of education and experience may be considered in lieu of degree)

• 12+ years of progressive experience in database architecture, with a proven track record of leading enterprise-scale database initiatives

• US Citizen with ability to obtain and maintain Secret clearance upon hire

• Recognized thought leader in database technologies with contributions to industry practices or academic research.

• Expert-level proficiency across multiple database platforms and technologies.

• Comprehensive mastery of database architecture, design patterns, and emerging data technologies.

• Extensive experience in database security, compliance, and governance at a global scale.

• Proven ability to lead and mentor high-performance database teams.

• Outstanding communication skills, capable of influencing C-level executives and technical teams alike

Desired:

Intermediate:

• Experience with NoSQL databases and big data technologies. Knowledge of data warehousing and business intelligence concepts.

• Proficiency in database performance tuning and query optimization.

• Familiarity with cloud-based database services (e.g., Amazon RDS, Azure SQL Database, Google Cloud SQL).

• Experience with data analytics tools and techniques.

• Knowledge of version control systems for database schema management

• Relevant database certifications (e.g., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator Associate)

Senior:

• Master's degree

• Experience with NoSQL databases and big data technologies (e.g., Hadoop, Spark).

• Expertise in data warehousing architectures and methodologies.

• Proficiency in cloud-based database services and migration strategies.

• Knowledge of machine learning and AI applications in database management.

• Experience with database high availability and disaster recovery solutions.

• Familiarity with DevOps practices for database development.

• Relevant advanced database certifications

Subject Matter Expert/SME:

• PhD

• Contributions to database technology standards or patents. Expertise in NoSQL databases, big data technologies, and data lakes.

• Advanced knowledge of cloud-native database architectures and services.

• Experience with AI/ML applications in database management and optimization.

• Proficiency in data analytics, business intelligence, and data visualization technologies.

• Track record of successful large-scale database transformations and migrations.

• Relevant advanced certifications (e.g., Oracle Certified Master, Microsoft Certified: Azure Database Administrator Expert)

This position is contingent on funding and may not be filled immediately. However, this position is representative of positions within CACI that are consistently available. Individuals who apply may also be considered for other positions at CACI.

___

What You Can Expect:

A culture of integrity.

At CACI, we place character and innovation at the center of everything we do. As a valued team member, you'll be part of a high-performing group dedicated to our customer's missions and driven by a higher purpose - to ensure the safety of our nation.

An environment of trust.

CACI values the unique contributions that every employee brings to our company and our customers - every day. You'll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.

A focus on continuous growth.

Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground - in your career and in our legacy.

Your potential is limitless. So is ours.

Learn more about CACI here. (

___

Pay Range : There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. Learn more here ( .

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is:

$75,200-$158,100

CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.

Job DescriptionJob Description

As THE leader in transit technology, Clever Devices' vision is to make meaningful contributions to worldwide mobility. Our goal is to be the leading provider of exciting technology that improves the quality of mobility in communities around the world

We are seeking a highly skilled SQL Database Administrator (DBA) / SQL Administrator to manage and maintain our database and IT infrastructure. The ideal candidate will be a database guru with deep expertise in SQL Server administration, optimization, and troubleshooting, as well as possessing strong SQL administration and supporting server and infrastructure skills. You will be responsible for ensuring database availability, security, and performance while also managing server infrastructure and IT systems.

Key Responsibilities:

• Database Administration:
  • Install, configure, and maintain SQL Server databases, on-prem, hosted, and in Azure.
  • Monitor database performance, tuning queries, and optimizing indexes.
  • Perform backups, restores, and disaster recovery planning.
  • Implement and manage database security, including access controls and encryption.
  • Implement and manage HA/DR scenarios (including AOAG, shared storage clusters, third party solutions) for unique deployment situations.
  • Develop and maintain database documentation and best practices.
• Collaboration & Support:
  • Work closely within the ITS team on SQL health and performance
  • Lead as needed for SQL maintenace, backups, monitoring, and reporting
  • Design HA/DR scenarios for on-prem, hosted, and cloud deployments
  • Work closely with developers to optimize queries and improve application performance.
  • Provide deep dive investigation for application and database-related issues.
  • Develop and maintain documentation for IT processes and database configurations.

Qualifications & Skills:

• Required:
  • 7+ years of experience in SQL Server database administration.
  • Strong experience with Windows Server and/or Linux administration.
  • Expertise in SQL performance tuning, indexing, and query optimization.
  • Proficiency in backup strategies, disaster recovery, and high-availability solutions.
  • Hands-on experience with PowerShell, Bash, or similar scripting .
  • Strong troubleshooting and problem-solving skills.
• :
  • Experience with cloud platforms, DBaaS offerings (Azure).
  • Knowledge of virtualization technologies (VMware, Docker, etc.).
  • Familiarity with NoSQL databases (MongoDB, Cassandra, etc.) is a plus.
  • Certifications such as Microsoft Certified: Azure Database Administrator Associate, MCSA, or RHCSA.

Why Join Us?

• Competitive salary and benefits package.
• Opportunity to work with cutting-edge technologies.
• Dynamic and collaborative work environment.
• Professional growth and training opportunities.

If you are a guru-level SQL DBA with strong supporting skills , we would love to hear from you! Apply now and take the next step in your career.

Clever Devices is an Affirmative Action/Equal Opportunity Employer

The compensation range posted for this position represents the anticipated minimum and maximum compensation for this position based upon a good faith and reasonable estimate. The exact compensation offered will depend on several factors such as the candidate’s experience, skills, training, education and/or physical location; internal equity; and, budget.

In addition, Clever Devices Ltd. offers a variety of benefits to eligible employees, including health insurance coverage, wellness and family support programs, life and insurance, retirement savings plans, paid leave programs, education-related programs, paid holidays and time off, and many others, depending on the level and position offered. Many of these benefits are subsidized or fully paid for by the company.

This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice based on business need.

PENNYMAC

Pennymac is (NYSE: PFSI) is a specialty financial services firm with a comprehensive mortgage platform and integrated business focused on the production and servicing of U.S. mortgage loans and the management of investments related to the U.S. mortgage market.

At Pennymac, our people are the foundation of our success and at the heart of our dynamic work culture. Together, we work towards a unified goal of helping millions of Americans achieve aspirations of homeownership through the complete mortgage journey.

A Typical Day

Pennymac is seeking a highly skilled and experienced Database Architect to design, implement, and manage our critical data infrastructure. You will play a pivotal role in shaping our data strategy, ensuring the performance, scalability, security, and availability of our database systems. This is an exciting opportunity to work with a diverse technology stack, including Microsoft SQL Server, PostgreSQL, Delphix, various NoSQL databases including DynamoDB, and AWS cloud services. You will be expected to bring an expert-level focus to automation across all aspects of database management and deployment, including infrastructure provisioning using Terraform or OpenTofu, experience with SQL Server to PostgreSQL migrations, deep expertise in query optimization across all database platforms (both SQL and NoSQL), and a strong understanding of SQL and NoSQL database principles.

The Database Architect will:

• Design and implement robust and scalable database solutions leveraging Microsoft SQL Server, PostgreSQL, various NoSQL databases, ensuring optimal query performance from the outset.

• Develop and maintain data models, database schemas (both relational and NoSQL), stored procedures, with a focus on automation for deployment and management and inherent query efficiency.

• Architect and implement data replication and masking strategies using Delphix, with a strong emphasis on automated provisioning and configuration, including support for Microsoft SQl / PostgreSQL.

• Design and manage database infrastructure on AWS, including RDS for SQL Server and PostgreSQL, DynamoDB and other NoSQL services, and other data-related services, leveraging Infrastructure-as-Code (IaC) principles and automation tools, specifically Terraform or OpenTofu, while ensuring cost-effective and performant database configurations for both SQL and NoSQL environments.

• Proactively identify opportunities for automation across database operations, including provisioning, patching, backups, monitoring, performance tuning, with a strong focus on automating infrastructure deployment using Terraform or OpenTofu and automating performance analysis and optimization across all database types.

• Develop and implement expert-level automation scripts and frameworks using tools such as Python, PowerShell, AWS CLI, and other relevant technologies, including specific tooling for PostgreSQL and NoSQL database management and migration, as well as performance monitoring and optimization, and integration with Terraform or OpenTofu for infrastructure automation.

• Actively monitor and analyze query/data access performance across Microsoft SQL Server, PostgreSQL, and various NoSQL databases, identifying and resolving performance bottlenecks specific to each type.

• Develop and implement advanced query/data access optimization techniques, including index tuning (where applicable), query/data access pattern rewriting, and the use of database-specific performance analysis tools for both SQL and NoSQL databases.

• Optimize database performance across different database platforms through automated monitoring, alerting, and self-healing mechanisms, with a strong emphasis on query/data access efficiency and leveraging infrastructure automation where possible.

• Collaborate with development teams to understand data access patterns for various database backends (SQL and NoSQL) and design efficient and effective database solutions, ensuring seamless integration with automated deployment pipelines and optimal query/data access performance.

• Design and implement database schema and data model changes for Microsoft SQL Server, PostgreSQL, and NoSQL databases that are fully compatible with automated CI/CD pipelines and optimized for data retrieval and manipulation, with infrastructure dependencies managed by Terraform or OpenTofu.

• Develop and maintain highly sophisticated scripts and automation for database deployments and migrations within CI/CD workflows, minimizing manual intervention and ensuring consistency across database platforms (SQL and NoSQL), with built-in performance testing and validation, and infrastructure provisioning handled by Terraform or OpenTofu.

• Document database designs, configurations, and automation workflows in detail, including specific documentation for PostgreSQL and NoSQL environments and migration processes.

• Stay up-to-date with the latest trends and technologies in database management, cloud computing, and automation, with a strong focus on both Microsoft SQL Server and PostgreSQL ecosystems, including advanced query optimization techniques and the evolving landscape of IaC tools like Terraform and OpenTofu, as well as the latest developments in NoSQL database technologies and best practices.

• Provide technical guidance and mentorship to other team members, promoting a culture of automation and best practices for managing diverse database environments, including Microsoft SQL Server, PostgreSQL, DyanmoDB, and various NoSQL databases, with a strong emphasis on writing and optimizing efficient queries/data access patterns and leveraging Terraform or OpenTofu for infrastructure management.

What You’ll Bring

• Bachelor's degree in Computer Science, or a related field. Master's degree preferred.

• Minimum of 5-7 years of experience as a Database Architect or in a similar role.

• Minimum of 5-7 years of experience with Microsoft SQL Server, including database design, administration, performance tuning, and high availability solutions, with a strong focus on automation and expert-level query optimization skills.

• Significant experience with PostgreSQL, including database design, administration, performance tuning, high availability, and replication, with a deep understanding of PostgreSQL-specific query optimization techniques.

• Significant hands-on experience with Delphix for data masking, virtualization, and replication, including advanced automation of workflows and support for PostgreSQL.

• Proven experience designing, implementing, and managing NoSQL databases, particularly DynamoDB on AWS, including data modeling, performance optimization, and scalability strategies. Experience with other NoSQL databases (e.g., MongoDB, Cassandra) is a plus.

• Deep understanding of AWS cloud services related to data, such as RDS for SQL Server and PostgreSQL, DynamoDB and other NoSQL services, S3, and data warehousing solutions (e.g., Redshift, Snowflake), and a proven ability to automate their deployment and management using IaC tools, specifically Terraform or OpenTofu, while ensuring optimal performance and cost-efficiency across all database types.

• Solid understanding of database security principles and best practices, with experience implementing automated security controls across different database platforms, including Microsoft SQL Server, PostgreSQL, and NoSQL databases.

• Expertise in data modeling techniques (e.g., relational, dimensional, NoSQL) with consideration for automated deployment across various database systems and optimal query/data access performance.

• Expert proficiency in writing complex SQL queries and stored procedures for both Microsoft SQL Server and PostgreSQL, with a strong focus on generating scripts for automated deployment and writing highly efficient queries, as well as understanding data access patterns and optimization techniques for NoSQL databases.

• Expert-level skills in scripting languages (e.g., Python, PowerShell) and automation frameworks for database tasks, with specific experience automating PostgreSQL and NoSQL database administration, maintenance, and performance analysis, and integration with Terraform or OpenTofu.

• Significant experience in planning and executing database migrations, particularly to and from PostgreSQL, including schema conversion, data migration, validation, and thorough performance testing and optimization on the target system, with infrastructure adjustments automated using Terraform or OpenTofu. Experience with data migration strategies for NoSQL databases is highly desirable.

• Proven experience in designing and implementing fully automated CI/CD pipelines for database changes using tools such as Jenkins, GitLab CI, AWS CodePipeline, or similar, with specific expertise in managing PostgreSQL and NoSQL database schema/data model changes and migrations within these pipelines, including automated performance testing, rollback strategies, and infrastructure provisioning using Terraform or OpenTofu.

• Demonstrated expertise in query/data access optimization techniques and tools for Microsoft SQL Server, PostgreSQL, and NoSQL databases (e.g., execution plans, index analysis, query hints, understanding NoSQL data access patterns and performance considerations).

• Strong hands-on experience with Infrastructure-as-Code (IaC) tools, specifically Terraform or OpenTofu, for provisioning and managing database infrastructure on AWS, including NoSQL services like DynamoDB.

• Excellent problem-solving, analytical, and communication skills, with the ability to articulate complex automation and migration strategies for diverse database environments, as well as provide clear recommendations for query/data access optimization and infrastructure management across SQL and NoSQL systems.

• Ability to work independently and collaboratively in a fast-paced environment, driving automation and efficient migration initiatives, with a strong focus on performance and infrastructure efficiency across all database technologies.

Why You Should Join

As one of the top mortgage lenders in the country, Pennymac has helped over 4 million lifetime homeowners achieve and sustain their aspirations of home. Our vision is to be the most trusted partner for home. Together, 4,000 Pennymac team members across the country are guided by our core values: to be Accountable, Reliable and Ethical in all that we do.

Pennymac is committed to conducting a business that makes positive contributions and promotes long-term sustainable growth and to fostering an equitable and inclusive environment, where all employees and customers feel valued, respected and supported.

Benefits That Bring It Home: Whether you're looking for flexible benefits for today, setting up short-term goals for tomorrow, or planning for long-term success and retirement, Pennymac's benefits have you covered. Some key benefits include:

• Comprehensive Medical, Dental, and Vision

• Paid Time Off Programs including vacation, holidays, illness, and parental leave

• Wellness Programs, Employee Recognition Programs, and onsite gyms and cafe style dining (select locations)

• Retirement benefits, life insurance, 401k match, and tuition reimbursement

• Philanthropy Programs including matching gifts, volunteer grants, charitable grants and corporate sponsorships

• We value the hard work and dedication of our employees. In addition to a competitive salary, positions may offer bonus opportunities.

To learn more about our benefits visit:

Compensation: Individual salary may vary based on multiple factors including specific role, geographic location / market data, and skills and experience as defined below:

• Lower in range - Building skills and experience in the role

• Mid-range - Experience and skills align with proficiency in the role

• Higher in range - Experience and skills add value above typical requirements of the role

Some roles may be eligible for performance-based compensation and/or stock-based incentives awarded to employees based on company and individual performance.

Salary

$95,000 - $155,000

Work Model

OFFICE

During the 2024 election cycle, Switchboard worked with over 2,700 campaigns from school board to Senate and Presidential races, strengthening Democratic digital fundraising and organizing programs up and down the ballot. In addition to the automated messaging platform that we launched in 2021 through which organizations have sent billions of messages, over the last year we've continued to build out an integrated suite of tools, including an emailer, forms builder, and fundraising analytics dashboards, with the goal of bringing together coordination across outreach channels, powerful analytics, and an easy-to-use platform.

As a Database Architect, you'll play a foundational role in architecting and building infrastructure and web applications for Switchboard, leveraging modern technology platforms and frameworks. We're looking for an engineer who has experience with and is excited about designing and implementing solutions to complex scaling problems. Ideal candidates should have experience with a variety of database solutions as well as experience working closely with full stack engineers.

As a member of our small team, you'll take on significant ownership over large parts of our codebase that are critical to the success of the product.

Responsibilities Include:

• Architecting our application databases and associated infrastructure to scale effectively for our needs.
• Partnering with full stack engineers to improve the performance of our applications where they interface with databases.
• Advocating for and implementing modern database practices across engineering.
• Building processes and systems to ensure high levels of data integrity and security as we grow.
• Helping establish and contributing to a positive engineering culture, with best practices around testing, code quality, security, and automation to help reduce errors and maintenance costs.

• 5+ years managing and improving database architecture for large-scale web applications, with an eye towards adaptability, scalability, and reliability.
• Knowledge of Python and AWS infrastructure
• Knowledge of Postgres best practices, as well as experience with additional data stores such as DynamoDB, Redis, etc
• Experience setting up and managing cloud-hosted databases, distributed systems, and data pipelines. (e.g. we use Aurora on AWS)
• Communicate effectively within teams and with outside partners.
• Comfortable taking on projects in new areas for them, learning quickly to develop the expertise and execute on those projects.

• $160k-$215k annual salary and an equity grant depending on experience
• Switchboard covers 100% of health, dental, and vision coverage for employees and 75% for dependents
• 21 days of paid time off plus federal holidays
• Unlimited sick leave
• 12 weeks paid parental leave for parents of any gender, including adoptive parents
• 401(K) match with immediate vesting

DecisionPoint Corporation is seeking an experienced Database Architect to join our team supporting the Personnel Enterprise Decision Support System (PEDSS) contract.

This position is fully remote.

Design and model data structures, define indexing and relational strategies.
• Collaborate with developers to optimize data access and reporting.
• Support integration with Army HR systems such as IPPS-A and SAMAS
• Perform other duties as assigned to support team goals and project requirements.

• Active Secret clearance
• Bachelor's degree and 2-3 years in database architecture.
• Skills in data modeling, normalization, entity-relationship diagrams.

• 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.

Design strategies for enterprise databases, data warehouse systems, and multidimensional networks.
• Set standards for database operations, programming, query processes, and security.
• Model, design, and construct large relational databases or data warehouses.
• Create and optimize data models for warehouse infrastructure and workflow.
• Integrate new systems with existing warehouse structure and refine system performance and functionality.

• Active Secret Clearance
• U.S. Citizenship Required for the purposes of obtaining/holding a U.S. security clearance
• BS/BA degree
• 8 years of database architecture experience
• 2 years of the experience with distance learning and knowledge management related technologies
• 2 years of experience with systems communication systems and networks