Senior Database Designer

Overview

Full Time

Skills

UI
Information Technology
Network
Microsoft
Tier 1
Recruiting
Training
Partnership
Finance
Accounting
Security Clearance
Legacy Systems
Data Architecture
Application Development
Batch Processing
DevSecOps
Sprint
Computer Science
Information Systems
Security+
Customer Engagement
Oracle
PL/SQL
Optimization
RDBMS
Normalization
Performance Tuning
Data Management
Data Modeling
Data Dictionary
Data Quality
Access Control
Encryption
Data Masking
DoD
Data Integration
Migration
Extract
Transform
Load
Oracle GoldenGate
Real-time
Data Migration
Data Mapping
Soft Skills
Conflict Resolution
Problem Solving
Analytical Skill
Database Architecture
Communication
Collaboration
Management
Adaptability
Attention To Detail
Database Administration
CISSP
Financial Software
Military
Annuities
Cloud Computing
Database
Microsoft Azure
Amazon Web Services
Disaster Recovery
High Availability
Database Design
FISMA
FedRAMP
Regulatory Compliance
Data Governance
Agile
Scrum
Government Contracting

Job Details

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.
If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.

Seeking a Senior Database Designer to support the Defense Finance and Accounting Service (DFAS) in the ongoing modernization of the Defense Retired & Annuitant Pay System (DRAS-M). This role is critical to consolidating eight disparate legacy subsystems into a single, modernized Oracle database architecture that will serve 2.9 million military retirees and their beneficiaries. The candidate will contribute to building a secure, high-performance, cloud-native database environment that supports the transition to a government-owned, government-operated pay system.

Clearance - Public Trust


Job Duties and Responsibilities:

  • Lead the development of a unified database structure that integrates data from eight distinct legacy systems into a single Oracle-based architecture

  • Design comprehensive database schema's using Oracle technologies, creating detailed entity-relationship diagrams and defining normalization strategies

  • Establish secure data architecture incorporating row-, column-, and cell-level access controls while supporting replacement of sensitive identifiers such as Social Security Numbers

  • Collaborate with software engineers, DevSecOps teams, and government stakeholders to ensure database structure supports modular application development and seamless incremental deployment


Technical Responsibilities

  • Design, develop, and maintain Oracle 19c or newer database systems with advanced schema design techniques

  • Implement relational database normalization, performance tuning, and indexing strategies that enable efficient real-time and batch processing

  • Collaborate with cross-functional teams including software engineers, DevSecOps teams, and government stakeholders

  • Participate in Agile ceremonies including backlog refinement and sprint planning processes

  • Define and maintain data mappings between legacy and modernized structures to support incremental migration

  • Support test data generation and guide integration of secure data migration pipelines using ETL processes and tools

  • Other duties as assigned.

Education & Experience

  • Bachelor's degree in computer science, Information Systems, Database Management, or related field

  • Minimum 7 years of experience in senior database design and architecture roles

  • Experience supporting government or defense agency systems preferred

  • Security + CE/ IAT Level II certification

Technical Skills

Database Technologies:

  • Proficiency in Oracle 19c or newer database systems

  • Advanced PL/SQL programming and optimization

  • Strong experience with relational database normalization, performance tuning, and indexing

Data Management:

  • Familiarity with data modeling, entity-relationship diagrams, and data dictionary creation

  • Experience supporting or participating in ETL processes for data migration

  • Understanding of data quality analysis and governance practices

Security & Compliance:

  • Understanding of database access control, encryption, and data masking practices

  • Knowledge of Zero Trust security principles and federal compliance frameworks

  • Familiarity with DoD environments and security standards

Data Integration & Migration:

  • Working knowledge of ETL processes and tools

  • Experience with Oracle GoldenGate or other real-time data migration platforms

  • Understanding of data mapping and transformation techniques

Soft Skills

  • Strong problem-solving and analytical thinking abilities for complex database architecture challenges

  • Excellent communication skills to collaborate effectively across Agile teams

  • Ability to work collaboratively with cross-functional teams including government stakeholders

  • Self-motivated with strong time management skills for managing multiple database deliverables

  • Adaptability to changing priorities and evolving government requirements

  • Detail-oriented approach to maintaining data governance and compliance standards

Preferred Qualifications

  • Advanced degrees or professional certifications in database management or related fields

  • CISSP Professional certifications

  • Experience with government financial systems or defense contractor environments

  • Knowledge of DFAS operations and military retirement/annuity systems

  • Experience with cloud-based database architectures (Azure, AWS)

  • Familiarity with disaster recovery and high availability database design

  • Experience with FISMA, FedRAMP, and other federal compliance frameworks

  • Background in data governance, classification, and retention policies

  • Experience with Agile/Scrum methodologies in government contracting environments

  • Job Requirements (Education/Skills/Experience):

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 CCS Global Tech