[Remote] Database Administrator

Note: The job is a remote job and is open to candidates in USA. General Dynamics Information Technology (GDIT) provides technology solutions and mission services to government, defense, and intelligence organizations. The Database Administrator will support the U.S. Courts Product Development Office by designing relational schemas, assessing and migrating XML data, developing ETL workflows, and maintaining data migration, verification, and reconciliation processes.

Responsibilities

• Provide support for discovery and source assessment, schema design, data mapping, migration development, transition and cut over planning, production execution and maintenance
• Inventory, catalog, and analyze all Extensible Markup Language (XML) data sources, including schemas, Document Type Definitions (DTDs), and XML Schema Definitions (XSDs)
• Provide a comprehensive Discovery and Assessment Report that catalogs source structures, update frequencies, XSD/DTD constraints, and discovered data anomalies
• Plan and implement a repeatable data migration strategy of XML data into a normalized relational database schema
• Design a normalized relational schema and map XML hierarchies to tables, keys, and indexes. Establish parent-child relationships and junction tables for many-to-many relationships
• Provide an Entity-Relationship Diagram (ERD) and a Data Dictionary detailing the target relational database structure and mappings
• Develop Extract, Transform, and Load (ETL) routines utilizing database-native SQL (such as T-SQL) embedded with XPath/XQuery expressions, or language-specific XML parsers
• Create and maintain an audit log of migrated and unmigrated records for each data source
• Track dates of repeated migrations and updates for identical records. Conduct unit tests for data verification and reconciliation
• Generate and deliver Migration Scripts and Pipeline Source Code with built-in audit logging capability and automated verification checks
• Plan and execute the production migration using a fully documented Runbook and Rollback. Migration plan containing detailed step-by-step instructions and time-to-complete estimates. Complete verification and reconciliation check to guarantee data migration completeness and accuracy
• Provide the Maintenance and Migration Interval plans for ongoing migrations (daily, on-demand, or at record update). Detail the necessary processes to support continuous updates of scripts and data schemas over time

Skills

• Database Structures, Data Transformation, Microsoft SQL Database, SQL Server Integration Services (SSIS), XML
• 7 + years of related experience
• * 7+ years experience in Server database maintenance and database administration or similar role
• * Bachelor's degree in Computer Science, Information Technology, or related field. Also, experience may be considered in lieu of degree
• * Strong SQL proficiency in SQL query development, data modeling, schema optimization, and preliminary data analysis based on business/customer requirements
• * Hands-on experience installing, configuring, administering and troubleshooting relational databases, including backup and recovery operations
• * Proven track record in performance tuning, implementing database security protocols, managing access controls, automating routine tasks, and handing SSL certification installation
• * Experience in leading technical projects, managing deliverables, and providing technical support or training to team members
• * Proficient in working with complex XML schemas and hierarchical data structures including XPath and XQuery
• * Proven experience in designing and implementing reliable SQL Server Integration Services (SSIS) workflows that incorporate robust error handling, logging, data validation, transformations, and performance optimization
• * Experience with SQL Server XML data types and capabilities, including storing, querying, parsing, transforming, and validating XML using XPath and XQuery
• * Strong hands-on experience with Entity Framework (EF) / Entity Framework Core (EF Core) and understanding of how LINQ expressions translate into SQL
• * Experience communicating and collaborating with developers, testers, systems engineer, DBAs, scrum masters, business owners and management
• * Familiarity with the Agile principles and methodology, SAFe Framework
• * 7+ years experience in Server database maintenance and database administration or similar role
• * Bachelor's degree in Computer Science, Information Technology, or related field. Also, experience may be considered in lieu of degree
• * Strong SQL proficiency in SQL query development, data modeling, schema optimization, and preliminary data analysis based on business/customer requirements
• * Hands-on experience installing, configuring, administering and troubleshooting relational databases, including backup and recovery operations
• * Proven track record in performance tuning, implementing database security protocols, managing access controls, automating routine tasks, and handing SSL certification installation
• * Experience in leading technical projects, managing deliverables, and providing technical support or training to team members
• * Proficient in working with complex XML schemas and hierarchical data structures including XPath and XQuery
• * Proven experience in designing and implementing reliable SQL Server Integration Services (SSIS) workflows that incorporate robust error handling, logging, data validation, transformations, and performance optimization
• * Experience with SQL Server XML data types and capabilities, including storing, querying, parsing, transforming, and validating XML using XPath and XQuery
• * Strong hands-on experience with Entity Framework (EF) / Entity Framework Core (EF Core) and understanding of how LINQ expressions translate into SQL
• * Experience communicating and collaborating with developers, testers, systems engineer, DBAs, scrum masters, business owners and management
• * Familiarity with the Agile principles and methodology, SAFe Framework
• Travel Required: Less than 10%
• Work Location: Any Location / Remote
• IBM Database certification is optional
• * IBM Database Certification

Benefits

• Remote work option
• Medical plan options, some with Health Savings Accounts
• Dental plan options
• Vision plan
• 401(k) plan with the ability to contribute both pre- and post-tax dollars up to IRS annual limits and receive a company match
• Full flex work weeks where possible
• Paid time off plans, including vacation, sick and personal time
• Paid holidays
• Paid parental leave
• Paid military leave
• Paid bereavement leave
• Paid jury duty leave
• Typically 15 days of paid leave per calendar year for vacations, personal business, and illness
• An additional 10 paid holidays per year
• Up to 160 hours of paid leave in a rolling 12-month period through the GDIT Paid Family Leave program for eligible employees
• Short- and long-term disability benefits
• Life insurance
• Accidental death and dismemberment insurance
• Personal accident insurance
• Critical illness insurance
• Business travel and accident insurance

Company Overview

Company H1B Sponsorship