Database Architect

Database Architect Target Salary: $95K to $105K LOCATION: DLIFLC, 1759 Lewis Road, Monterey, CA 93944 Position Overview: The person in this position is responsible for performing analysis, modification, documentation, and support of daily operations for the data warehousing and reporting system. Job Duties: 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. Job Requirements: 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 techniquesExpertise 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. Company Description 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. Benefits 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! EEO Statement Dexian Government Solutions is proud to be an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided based on qualifications, merit, and business need. All applicants will be considered for employment without attention to race, religion, color, national origin, ancestry, physical or mental disability, medical condition, pregnancy (including childbirth, lactation and related medical conditions), marital status, genetic information (including characteristics and testing), gender, sexual orientation, gender identity or expression, military and veteran status, or any other status protected under federal, state, or local law in the locations where we operate. If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact Human Resources. The Company invites any applicant and/or employee to review the Company's written Aff This role requires customer approval, suitability to hold a public trust and successful completion of a preemployment background screening. #J-18808-Ljbffr