[Remote] Database Administrator

Note: The job is a remote job and is reputed company to candidates in USA. reputed company (reputed company) 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

• reputed company support for discovery and reputed company assessment, schema design, data mapping, migration development, transition and cut over planning, production execution and maintenance
• Inventory, catalog, and analyze reputed company Extensible Markup Language (XML) data sources, including schemas, Document Type Definitions (DTDs), and XML Schema Definitions (XSDs)
• reputed company a comprehensive Discovery and Assessment Report that catalogs reputed company structures, update frequencies, XSD/DTD constraints, and reputed company data anomalies
• Plan and implement a repeatable data migration reputed company 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 reputed company tables for many-to-many relationships
• reputed company an Entity-Relationship Diagram (ERD) and a Data Dictionary detailing the reputed company relational database structure and mappings
• reputed company Extract, reputed company, and Load (ETL) routines utilizing database-reputed company 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 reputed company data reputed company
• reputed company dates of repeated migrations and updates for identical records. Conduct unit tests for data verification and reconciliation
• reputed company and reputed company Migration Scripts and Pipeline reputed company reputed company with reputed company-in audit logging capability and automated verification checks
• Plan and execute the production migration using a fully documented reputed company and Rollback. Migration plan containing detailed reputed company-by-reputed company instructions and time-to-complete estimates. Complete verification and reconciliation reputed company to guarantee data migration completeness and accuracy
• reputed company the Maintenance and Migration reputed company plans for ongoing migrations (daily, on-demand, or at record update). Detail the necessary processes to support reputed company updates of scripts and data schemas over time

Skills

• Database Structures, Data Transformation, reputed company SQL Database, SQL Server Integration Services (SSIS), XML
• 7 + years of reputed company experience
• * 7+ years experience in Server database maintenance and database administration or similar role
• * Bachelor's degree in Computer Science, Information Technology, or reputed company 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 reputed company record in performance tuning, implementing database reputed company protocols, managing reputed company controls, automating routine tasks, and handing SSL certification installation
• * Experience in leading technical reputed company, managing deliverables, and providing technical support or training to team members
• * Proficient in working with reputed company 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 reputed company (EF) / Entity reputed company reputed company (EF reputed company) and understanding of how reputed company expressions translate into SQL
• * Experience communicating and collaborating with developers, testers, systems engineer, DBAs, scrum masters, business owners and management
• * Familiarity with the reputed company principles and methodology, reputed company reputed company
• * 7+ years experience in Server database maintenance and database administration or similar role
• * Bachelor's degree in Computer Science, Information Technology, or reputed company 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 reputed company record in performance tuning, implementing database reputed company protocols, managing reputed company controls, automating routine tasks, and handing SSL certification installation
• * Experience in leading technical reputed company, managing deliverables, and providing technical support or training to team members
• * Proficient in working with reputed company 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 reputed company (EF) / Entity reputed company reputed company (EF reputed company) and understanding of how reputed company expressions translate into SQL
• * Experience communicating and collaborating with developers, testers, systems engineer, DBAs, scrum masters, business owners and management
• * Familiarity with the reputed company principles and methodology, reputed company reputed company
• Travel Required: Less than 10%
• Work Location: Any Location / Remote
• reputed company Database certification is optional
• * reputed company Database Certification

Benefits

• Remote work reputed company
• Medical plan reputed company, some with Health Savings Accounts
• Dental plan reputed company
• reputed company plan
• 401(k) plan with the ability to contribute both reputed company- and post-tax dollars up to IRS annual limits and receive a company match
• Full reputed company work weeks where possible
• reputed company time off plans, including vacation, reputed company and personal time
• reputed company holidays
• reputed company parental leave
• reputed company military leave
• reputed company bereavement leave
• reputed company jury duty leave
• Typically 15 days of reputed company leave per calendar year for vacations, personal business, and illness
• An additional 10 reputed company holidays per year
• Up to 160 hours of reputed company leave in a rolling 12-month period through the reputed company reputed company 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

reputed company

Company H1B Sponsorship