Senior Database Developer

Lalaith Astor Technical Consulting House; United States; Remote; USD 145,000 - 170,000; Full time

Job summary

A leading consulting house seeks a Senior Database Developer to support the Department of Homeland Security. The ideal candidate will lead database design and maintenance, ensuring data integrity and compliance. This role requires extensive experience with federal data systems and ETL processes. The position is remote but requires commuting distance to Washington, D.C. Competitive salary offered.

Qualifications

• 15+ years of experience supporting federal programs.
• Expert-level proficiency with SQL and relational database design.

Responsibilities

• Design, develop, and maintain enterprise databases.
• Develop and optimize ETL processes and data pipelines.
• Ensure data quality, security, and compliance with DHS policies.

Skills

Database Management

Data Analysis

Problem-Solving

Data Governance

Communication

Education

Bachelor’s degree in computer science

Tools

SQL Server

Oracle

PostgreSQL

ERwin

Job description

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_19_20

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_20_21TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_21_22

LATCH is seeking a Senior Database Developer to support the Department of Homeland Security’s Office of Homeland Security Statistics (OHSS). This role will lead the design, development, and maintenance of complex database solutions to support data-driven reporting and analytics. The ideal candidate will have extensive experience with federal data systems, ETL pipelines, and database architecture. This position is contingent upon contract award.

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_22_23TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_23_24

Job Location

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_24_25TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_25_26

Remote: commuting distance to Washington, D.C.

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_26_27TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_27_28

Responsibilities and Duties

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_28_29TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_29_30

Job responsibilities and duties will include, but are not limited to, the following:

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_30_31TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_31_32

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_32_33
• Design, develop, and maintain enterprise databases to support reporting and analytics
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_33_34TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_34_35
• Develop and optimize ETL processes and data pipelines
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_35_36TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_36_37
• Implement data modeling, normalization, and integration strategies
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_37_38TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_38_39
• Manage stored procedures, functions, triggers, and database performance tuning
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_39_40TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_40_41
• Ensure data quality, security, and compliance with DHS policies
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_41_42TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_42_43
• Support data warehousing and data governance initiatives
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_43_44TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_44_45
• Collaborate with developers, analysts, and stakeholders to translate business needs into technical solutions
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_45_46TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_46_47
• Document database architecture, workflows, and standard procedures
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_47_48

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_48_49TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_49_50

Required Qualifications and Skills

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_50_51TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_51_52

The selected candidate must have the following qualifications and skills:

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_52_53TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_53_54

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_54_55
• Demonstrated expertise with database management systems, including SQL Server, Oracle, or PostgreSQL.
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_55_56TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_56_57
• Extensive experience designing, implementing, and maintaining relational databases, data warehouses, and ETL processes.
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_57_58TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_58_59
• Proficiency in Data Analysis, Data Modeling, and Data Integration, including familiarity with tools like ERwin or similar data modeling software.
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_59_60TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_60_61
• Experience with Data Governance frameworks and practices to ensure data quality and compliance.
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_61_62TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_62_63
• Bachelor’s degree in computer science, Information Systems, or related field
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_63_64TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_64_65
• Expert-level proficiency with SQL and relational database design
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_65_66TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_66_67
• Strong experience with ETL processes and data integration tools
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_67_68TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_68_69
• Ability to design and implement data models and schemas to support complex reporting
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_69_70TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_70_71
• Skilled in database performance tuning and query optimization
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_71_72TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_72_73
• Experience with database scripting, automation, and version control
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_73_74TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_74_75
• Strong understanding of data governance, data quality, and metadata management
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_75_76TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_76_77
• Excellent problem-solving and analytical skills
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_77_78TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_78_79
• Ability to work independently and collaboratively in a remote or hybrid environment
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_79_80TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_80_81
• Strong written and verbal communication skills
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_81_82

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_82_83TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_83_84

Desired Qualifications and Skills

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_84_85TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_85_86

It is desirable that the candidate has the following qualifications and skills:

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_86_87TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_87_88

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_88_89
• Experience developing stored procedures, functions, and triggers to support automated report generation and data transformation
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_89_90TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_90_91
• Familiarity with cloud-based database platforms (e.g., AWS RDS, Azure SQL, Google Cloud SQL)
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_91_92TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_92_93
• Strong knowledge of federal data security frameworks (e.g., FISMA, FedRAMP), especially for systems managing statistical and immigration-related data
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_93_94TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_94_95
• Understanding of data governance frameworks used in DHS or similar agencies
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_95_96TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_96_97
• Exposure to data warehousing modernization efforts in large-scale federal environments
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_97_98

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_98_99TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_99_100

Required Experience

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_100_101TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_101_102

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_102_103
• 15+ years of experience supporting federal programs, with extensive onsite experience navigating agency policies, change control, and compliance
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_103_104TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_104_105
• Demonstrated success managing large relational databases (PostgreSQL, SQL Server, or Oracle) in production federal environments
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_105_106TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_106_107
• Experience implementing ETL pipelines and data integration solutions across siloed systems
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_107_108TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_108_109
• Proven ability to design and optimize complex schemas to support real-time dashboards and automated reporting
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_109_110TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_110_111
• Hands-on experience with performance tuning for high-volume query environments
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_111_112TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_112_113
• Proficient in developing database logic to support policy-driven reporting, data aggregation, and audit traceability
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_113_114TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_114_115
• Strong familiarity with DHS security protocols, including backup, recovery, access controls, and data masking in compliance with FISMA/FedRAMP
TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_115_116

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_116_117TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_117_118

Job Type: Full-time

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_118_119TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_119_120

Background Check: Requires a DHS Public Trust background check

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_120_121TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_121_122

Pay: $145,000.00 - $170,000.00 per year

TGM_PAGESPEED_LAZY_ITEMS_INGORED_BLOCK_122_123