Talent.com
SQL Database Architect

SQL Database Architect

ExecRecruitmentRaleigh, NC, US
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.job_description

Job Title :

  • SQL Database Architect Location :  Raleigh, NC Typical Experience :   84+ months The Sr.
  • Data Solutions Engineer is a senior level resource that will serve as the Database Architect for the Division of Motor Vehicles Modernization initiatives.
  • The Sr.
  • Data Solutions Engineer role will aid in the development of a new cloud environment by assisting the DMV Modernization Team with the design, management, and maintenance of data flow as it pertains to cloud technology.
  • Additionally, this role will also be responsible for data analysis, data profiling, data cleansing, data governance, in preparation for data conversion of the existing environment.
  • The ideal candidate will be able to develop & maintain cloud data strategy, evaluate data elements and structure, and ensure the smooth integration of data internal and external to cloud initiatives.
  • This position will direct a team two database programmers to complete the data analysis.

Additionally, the position will assist in a leadership role :

  • Execution of cloud design and implementation strategies.
  • Evaluation and selection of the appropriate data frameworks.
  • Establishment of standards, best practices for data conversion, data mapping, data cleansing, and data migration as it evolves from legacy to cloud-based technologies.
  • Design of system integration containing database permissions, keys, and access for authorized data usage and reporting.
  • Process Instruction of infrastructure movement techniques and data transfers using multiple ETL / ELT sources.
  • Responding to technical issues timely and effectively.
  • Leading and solicit database programmers, application teams, security, and infrastructure teams to monitor cloud privacy, performance, and load.
  • Capturing lessons learned and transitional knowledge to assist the Leadership Team in establishing a mentoring path that provides technical exposure and develops the next generation of DIT leaders and technical staff.
  • Additional Roles and Responsibilities The Sr.
  • Data Solutions Engineer position will also serve in a lead role in the application support team’s quality assurance for operations and maintenance initiatives.
  • The resource will serve as Subject Matter Expert (SME) with the following expected responsibilities :

  • Lead the design of data conversion, cleansing, migration, and frameworks while ensuring security and data integrity.
  • Design and enforce policies based on Data Quality, Data Security, Data retention, Data Stewardship.
  • Document the data model & data mapping, create a data dictionary, define columns and data relationships.
  • Maintain the end-to-end vision of the data flow diagram and develop logical data models into physical data repositories.
  • Use data cleansing & governance tools to administer, manage and script database functions based on user inputs and data quality principles.
  • Design and deliver Data integration solutions based on current DB2 and future Microsoft SQL Server systems.
  • Identify project impacts on Business Process Models for our business stakeholders as it relates to Software Development Lifecycle methodology.
  • Coordinate with all other solution architects to assist the Enterprise Services Team with the delivery of software solutions.
  • Skill Matrix :

  • Database Design Required 10 Years SQL Server, DB2 experience.
  • Required 10 Years Database back up, maintaining table partitions Required 5 Years Database Conversion, Cleansing, Migration Required 10 Years Application development or application support or application testing or a combination of those experiences.
  • Required 10 Years Software development lifecycle methodologies Required 10 Years Ability to create and maintain required documentation.
  • This includes documenting customer requirements, design flows and systems flow.
  • Required 10 Years Leading or Supervising an IT Team Required 5 Years Written and verbal communications are clear, concise and achieve intended objectives Required 10 Years Problem Diagnosis skills [i.e., discovery, replication, troubleshooting, resolution, verification, communication and / or escalation as required] Required 10 Years Experience with writing test cases, executing those cases and leading technical training Required 10 Years BS / BA degree in Computer Science, Information Technology, Computer Engineering; MS degree in Computer Science or equivalent or an MBA Required 5 Years MS Azure or MS Cloud certification Highly desired 2 Years SQL Server SSIS management and / or framework Highly desired 2 Years Parquet text maintenance knowledge Nice to have 2 Years Must reside in North Carolina and can report on-site at short notice Required Benefits at IntelliBee Long-Term Stability :

  • Join us on a multi-year opportunities with room to grow.
  • Comprehensive Health Coverage :

  • Access quality healthcare benefits to keep you and your family well.
  • Future Planning :

  • Enroll in our 401(k) program and invest in your financial security.
  • GC Assistance :

  • We support immediate Green Card processing, if required.
  • Please apply on our secured job site at <

  • / / intellibee.my.salesforce-sites.com / apps / jobs?id=a0AUU000003RnhF>
  • or email careers@intellibee.com Powered by JazzHR

    serp_jobs.job_alerts.create_a_job

    Database Architect • Raleigh, NC, US

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Data Engineer with GCP Certification

    Data Engineer with GCP Certification

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Engineer (Gen AI).Key Responsibilities Install and test Looker and Looker Studio extensions or API plugins Identify and deprecate unused Looker dashboards Enhanc...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Geoprocessing and Database Analyst

    Geoprocessing and Database Analyst

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Project Management Support Analyst (Geoprocessing and Database).Key Responsibilities Collaborate in the implementation of project activities with federal, municipal, ac...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Data Operations Associate

    Data Operations Associate

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Operations Associate-Client Ads.Key Responsibilities Maintain, audit, and improve advertiser and catalog data to support business growth Collaborate with Sales, C...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Staff Database Engineer

    Staff Database Engineer

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Staff Database Infrastructure Engineer.Key Responsibilities Design and rearchitect infrastructure platform components for high availability, scalability, reliability, a...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Business Intelligence Developer

    Senior Business Intelligence Developer

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Business Intelligence Developer - Product & Platform Innovation.Key Responsibilities Collaborate with cross-functional teams to drive data enablement and support...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Data Team Lead

    Data Team Lead

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Head of Data to lead its data team and manage data infrastructure.Key Responsibilities Lead a data team while contributing hands-on technical expertise Manage the enti...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_less
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    SAS / SQL Data Analyst

    SAS / SQL Data Analyst

    VirtualVocationsRaleigh, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a SAS / SQL Data Analyst / Engineer - Claims / Healthcare.Key Responsibilities : Submit claim records and risk adjustment data to CMS while ensuring compliance and accuracy ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Data Cleansing Lead

    Data Cleansing Lead

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Lead (Oracle).Key Responsibilities Perform data analysis, cleansing, and conversion Review and provide oversight on the System Integrator's Data Cleansing work D...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Advanced Analytics Expert

    Advanced Analytics Expert

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for an Advanced Analytics Expert to collaborate with teams and utilize advanced analytics for data-driven decision-making. Key Responsibilities Builds advanced analytics solut...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Senior Big Data Engineer

    Senior Big Data Engineer

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Big Data Engineer to join their team.Key Responsibilities Support the transition from a monolithic application to loosely coupled microservices Ensure data is c...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    PMP Certified Data Manager

    PMP Certified Data Manager

    VirtualVocationsRaleigh, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Lead / Manager with PMP.Key Responsibilities Ensure seamless data transition from the legacy pension administration system to COPS 2. Enhance data quality and integri...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Principal Database Programmer

    Principal Database Programmer

    VirtualVocationsRaleigh, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Principal Database Programmer.Key Responsibilities Provide training and mentoring to (Senior) Database Programmers on CDMS systems and processes Plan client deliverabl...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    ADABAS DB2 Database Specialist

    ADABAS DB2 Database Specialist

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for an ADABAS / DB2 Database Specialist to provide expert-level technical support in a remote setting. Key Responsibilities Plan, install, configure, and implement SAG ADABAS so...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_less
    • serp_jobs.job_card.promoted
    DataBricks Database Administrator

    DataBricks Database Administrator

    VirtualVocationsRaleigh, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a DataBricks Database Administrator (DBA).Key Responsibilities Modernize the data warehouse environment by migrating to Azure Databricks Architect, design, and perform o...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Epic Certified BI Developer

    Epic Certified BI Developer

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for an IT Data Solutions Developer Associate.Key Responsibilities Analyze, develop, and improve BI solutions to meet business needs Collaborate with operations teams to desi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Azure Data Engineer

    Azure Data Engineer

    TEKsystemsRaleigh, NC, United States
    serp_jobs.job_card.full_time
    Candidates must be local to North Carolina.The company is continuing to scale their Azure, Data and AI service offerings to internal stakeholders and partners. The Web Services team is in serious ne...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Data Scientist III - Risk Adjustment

    Data Scientist III - Risk Adjustment

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Scientist III - Risk Adjustment Compliance.Key Responsibilities Develop models to detect coding anomalies and identify high-risk areas Create analytical tools to ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Epic Certified Data Engineer II

    Epic Certified Data Engineer II

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Engineer II.Key Responsibilities Design and develop data pipelines and integrate new business data into the Data Warehouse while adhering to best practices Collab...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Data Engineer

    Data Engineer

    Spectraforce TechnologiesRaleigh, NC, United States
    serp_jobs.job_card.full_time
    There is an On Call Rotation to cover Production Support coverage (target rotation is every 4-6 weeks, for one full week), depending on staffing availability while working remotely, candidates shou...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    ETL Data Architect

    ETL Data Architect

    VirtualVocationsDurham, North Carolina, United States
    serp_jobs.job_card.full_time
    A company is looking for an ETL Data Architect to design and develop enterprise-wide application systems.Key Responsibilities Collaborate with business partners and teams to identify technical an...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day