Talent.com
SQL Database Architect, Raleigh, NC, US
SQL Database Architect, Raleigh, NC, USIntellibee Inc • Raleigh, NC, United States
serp_jobs.error_messages.no_longer_accepting
SQL Database Architect, Raleigh, NC, US

SQL Database Architect, Raleigh, NC, US

Intellibee Inc • Raleigh, NC, United States
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Overview

Technical Specialist- Expert (Data Engineer)

Typical Experience : 84+ months

The Sr. Data Solutions Engineer is a senior level resource that will serve as the Database Architect for the North Carolina Division of Motor Vehicles (NC DMV) Modernization initiatives.

The Sr. Data Solutions Engineer role will aid in the development of a new cloud environment by assisting the NCDIT 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
  • J-18808-Ljbffr

    #J-18808-Ljbffr

    serp_jobs.job_alerts.create_a_job

    Database Architect • Raleigh, NC, United States

    Job_description.internal_linking.related_jobs
    SAP S4 HANA Database Architect and Engineer

    SAP S4 HANA Database Architect and Engineer

    International Staff Consulting • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    This client is a leading producer in the steel industry has plants all over the world and they are looking to grow this department out. Need US Citizens or Green Card Holders only due to ITAR / EAR co...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    SQL Administrator

    SQL Administrator

    Sunrise Systems • Raleigh, North Carolina, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Experience in troubleshooting and resolving database problems; Experience with following : .Backups restores and High Availability (Always on),. Installation and configuration of SQL 2014, 2016 and 20...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30
    Principal Data Architect (Raleigh)

    Principal Data Architect (Raleigh)

    Eliassen Group • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    Our client, a leader in their industry, has an excellent opportunity for a Principal Data Architect to work on a 12-month+ contract with an option to hire if the fit is right in Raleigh, NC.This po...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    Principal Database Engineer Oracle Modernization

    Principal Database Engineer Oracle Modernization

    insightsoftware • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    As a Principal Database Engineer specializing in database architecture, optimization, and modernization, you will serve as the technical authority for all database initiatives across the Equity Man...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Cloud Architect

    Cloud Architect

    eTeam • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    Must Have Skills (Top 3 technical skills only) •.As a Cloud Architect, you will play a pivotal role in our team, designing, developing, and optimizing cloud solutions to meet the needs of our clien...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Database Administrator III

    Database Administrator III

    PLANIT Group • Raleigh, NC, United States
    serp_jobs.job_card.permanent
    PlanIT Group is seeking a Database Administrator III to support our Federal customer in the Washington, DC area.The ideal candidate will be responsible for performing complex functional activities ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    MO 24410 - 761423 - SQL Database Administrator

    MO 24410 - 761423 - SQL Database Administrator

    Focused HR Solutions • Cary, North Carolina, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Candidate will work 100% on-site in Raleigh, NC.In-person Interview on 1st Round Required.Our direct client has an opening for a SQL Database Administrator position # 76125.This position is for 6+ ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30
    Senior Tableau Specialist

    Senior Tableau Specialist

    Cynet Systems • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    Expert-level technical / functional development skills in Tableau and Cognos.Strong technical skills with database analysis and query tools, such as SQL, SAS, or Business Objects.Data aggregation, vi...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Senior Database Administrator

    Senior Database Administrator

    Highmark Health • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    CANDIDATE MUST BE US Citizen (due to contractual / access requirements).We are seeking a Database Administrator with experience in PostgreSQL databases within Google Cloud Platform (GCP), as well kno...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Global PA Data Services Enterprise Architect

    Global PA Data Services Enterprise Architect

    ABB • Cary, NC, United States
    serp_jobs.job_card.full_time
    At ABB, we help industries outrun - leaner and cleaner.Here, progress is an expectation - for you, your team, and the world. As a global market leader, we'll give you what you need to make it happen...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Staff Solution Architect - AI / Datacenter Solutions (26865)

    Staff Solution Architect - AI / Datacenter Solutions (26865)

    Supermicro • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    Supermicro is a Top Tier provider of advanced server, storage, and networking solutions for Data Center, Cloud Computing, Enterprise IT, Hadoop / Big Data, Hyperscale, HPC and IoT / Embedded customers...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Database Administrator 3-IT

    Database Administrator 3-IT

    Oracle • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    Work with a world class team to provide enterprise-wide, Oracle Database Administration support for production systems and provide DBA services to application development teams, including database ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Remote Database Architects (Professional, Scientific, and Technical Services) - AI Trainer ($100-$180 per hour)

    Remote Database Architects (Professional, Scientific, and Technical Services) - AI Trainer ($100-$180 per hour)

    Mercor • Cary, North Carolina, US
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Mercor is recruiting • •Database Architects who work in the Professional, Scientific, and Technical Services • • as independent contractors working on a research project • •for one of the world’s top A...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    MO - 4 / 10 - 761423 - SQL Database Administrator

    MO - 4 / 10 - 761423 - SQL Database Administrator

    FHR • Morrisville, NC, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Candidate will work 100% on-site in Raleigh, NC.In-person Interview on 1st Round Required.Our direct client has an opening for a SQL Database Administrator position # 76125.This position is for 6+ ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30
    Database Team Lead

    Database Team Lead

    GovCIO • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    GovCIO is currently hiring for Database Team Lead todeploy and manage databases supporting customer applications.This position will be located in Radford, VA and will be a remote position.Senior da...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Informatica Database Administrator

    Informatica Database Administrator

    ASM Research, An Accenture Federal Services Company • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    The Informatica Administrator is responsible for the installation, configuration, monitoring, maintenance, and optimization of Informatica software tools used for data and application integration, ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Manager, Cloud Architect

    Manager, Cloud Architect

    KPMG • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    Known for being a great place to work and build a career, KPMG provides audit, tax and advisory services for organizations in today's most important industries. Our growth is driven by delivering re...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Enterprise Data Architect - Raleigh, NC / Phoenix, AZ

    Enterprise Data Architect - Raleigh, NC / Phoenix, AZ

    First Citizens Bank • Raleigh, NC, United States
    serp_jobs.job_card.full_time
    This is a hybrid role with the expectation that time working will regularly take place inside and outside of a company office in either Raleigh, NC or Phoenix, AZ. This position establishes and impl...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted