Database Architect

The person in this position is responsible for performing analysis, modification, documentation, and support of daily operations for the data warehousing and reporting system., * Responsibilities include supporting the data development/sustainment lifecycle, including data profiling, ETL and data model design and development/sustainment, testing, and support.

• The duties will include planning, installation, maintenance during or after-work hours, troubleshooting, and managing all Database Developer servers and applications.
• Achieves organizational goals by defining, integrating, and upgrading a comprehensive architecture to support applications, platforms, and databases.
• Maintains database by determining structural requirements and developing and installing solutions.
• Ensures security of all information and computer systems and digital data.
• Ensures adherence to government regulations and guidelines for technological systems and safeguarding of data.
• Defines infrastructure for design and integration of internet computing systems by analyzing information requirements, studying business operations and user-interface requirements, and directing development of physical database.
• Confirms architecture capability and flexibility to support high availability web applications by developing analytical models and completing validation tests.
• Determines platform architecture, technology, and tools.

• Educational requirements include an AA/AS Degree in a related discipline from an accredited college or university or three years of related experience.
• Minimum of 5 years of experience designing and developing data warehouses
• Proven track record of successfully implementing complex data warehouse projects
• Experience with relational database design/modeling using tools.
• Expert-level SQL coding/querying skills in SQL Server and/or MySQL
• Proficient in SQL and advanced SQL query optimization techniques
• Expertise in data warehouse technologies like Snowflake, Redshift, or Teradata
• Knowledge of ETL tools and methodologies
• Familiarity with data modeling concepts (dimensional, star schema, snowflake schema)
• Understanding of data analysis, business principles, and operations
• Software architecture and design
• Network design and implementation
• Ability to clearly present technical information to fellow technical professionals as well as non-technical peers

Required to Start Qualifications:

• IAT Level II Certification is required to Start (CCNA Security, CSA+, GICSP, GSEC, Security+ CE, or SSCP) Certification
• A NACLC Public Trust Clearance is required to Start., This role requires customer approval, suitability to hold a public trust and successful completion of a preemployment background screening.

Our robust benefits package includes Open Paid Time Off, 11 Federal Paid Holidays & 5 Paid Sick Days, Company-paid Life/AD&D, Company-paid Short Term and Long-Term Disability, Health Insurance with Company Contribution, 401k Plan with Company Match, Employee Recognition Program, opportunity for Employee Referral Bonus, opportunity for annual Performance Bonus and much more!

Dexian Government Solutions is an award-winning, ISO 9001:2015 certified, business and GSA contract holder providing diversified Information Technology services to both Civilian and Defense agencies. Services include Software Development, Systems Integration, Data Management, Project Management, Operations & Maintenance, Cybersecurity, and Training and Audio/Visual (AV) Solutions. Dexian Government Solutions has received several recognitions, including rankings on “Top 50 Companies to Watch”, Washington Technology’s Annual “FAST 50”, and Inc. 500’s List of “Fastest Growing Private Companies”. The Dexian Government Solutions team is comprised of individuals who are dedicated to the success and sustainability of our customers and their missions. Our combination of technical expertise, big business experience, and small business agility allows us to promptly provide our customers with exceptional IT and engineering solutions.