Talent.com
SQL, DB2 Database Architect
SQL, DB2 Database ArchitectExecRecruitment • Raleigh, NC, US
SQL, DB2 Database Architect

SQL, DB2 Database Architect

ExecRecruitment • Raleigh, NC, US
1 day ago
Job type
  • Full-time
  • Quick Apply
Job description

Job Title :

  • SQL, DB2 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

    Create a job alert for this search

    Database Architect • Raleigh, NC, US

    Related jobs
    Senior SQL Server DBA

    Senior SQL Server DBA

    VirtualVocations • Raleigh, North Carolina, United States
    Full-time
    A company is looking for a Senior SQL Server Database Administrator.Key Responsibilities Own SQL Server platform architecture, including versioning, clustering, and capacity planning Lead advanc...Show more
    Last updated: 30+ days ago • Promoted
    Database Developer

    Database Developer

    VirtualVocations • Raleigh, North Carolina, United States
    Full-time
    A company is looking for a Database Developer (MongoDB & AWS).Key Responsibilities Design and implement high-performance MongoDB solutions for demanding workloads Manage and optimize AWS RDS (My...Show more
    Last updated: 30+ days ago • Promoted
    MO - 4 / 10 - 761423 - SQL Database Administrator

    MO - 4 / 10 - 761423 - SQL Database Administrator

    FHR • Morrisville, NC, US
    Full-time
    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+ ...Show more
    Last updated: 30+ days ago • Promoted
    Sr. Database Developer

    Sr. Database Developer

    Kobie Marketing • Raleigh, NC, US
    Full-time
    Named a Top Workplace in the USA and Top Remote Workplace, Kobie is where the best minds in loyalty come together, driven by passion and innovation. We’re always looking for talented individua...Show more
    Last updated: 4 days ago • Promoted
    AWS Data Architect

    AWS Data Architect

    Random Bit • NC, US
    Full-time
    Quick Apply
    AWS Data Architect / Engineer Company Overview Random Bit is a system modernization partner that specializes in enterprise architecture, solution architecture, data architecture, cl...Show more
    Last updated: 6 days ago
    Database Solutions Developer

    Database Solutions Developer

    VirtualVocations • Raleigh, North Carolina, United States
    Full-time
    A company is looking for a Database Solutions Developer (IBM Sterling REQUIRED).Key Responsibilities : Design and implement middleware solutions, including custom services, adapters, and protocols...Show more
    Last updated: 21 days ago • Promoted
    Senior Database Reliability Engineer

    Senior Database Reliability Engineer

    VirtualVocations • Raleigh, North Carolina, United States
    Full-time
    A company is looking for a Senior Database Reliability Engineer to ensure the performance, scalability, and reliability of its databases and supporting applications. Key Responsibilities Optimize ...Show more
    Last updated: 10 hours ago • Promoted • New!
    Oracle Cloud Architect

    Oracle Cloud Architect

    VirtualVocations • Raleigh, North Carolina, United States
    Full-time
    A company is looking for an ES ORACLE Cloud Architect.Key Responsibilities Customize and integrate Oracle CPQ Cloud with other CRM / ERP applications Manage and implement CPQ Commerce modules, inc...Show more
    Last updated: 30+ days ago • Promoted
    Oracle DBA [Hybrid]

    Oracle DBA [Hybrid]

    Isospin Technologies, LLC • Raleigh, NC, US
    Full-time
    Oracle DBA Raleigh / RTP, NC [Hybrid] 7 Months Skills : Demonstrable skills in designing schema, access patterns, locking strategy, and tuning Oracle Databases in an enterprise environment Required 7 ...Show more
    Last updated: 12 days ago • Promoted
    MO 24410 - 761423 - SQL Database Administrator

    MO 24410 - 761423 - SQL Database Administrator

    Focused HR Solutions • Cary, North Carolina, United States
    Full-time
    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+ ...Show more
    Last updated: 30+ days ago
    PostgreSQL Database Administrator

    PostgreSQL Database Administrator

    Envestnet • Raleigh, NC, US
    Full-time
    PostgreSQL Database Administrator.This is a hybrid role, with in-office work required at our Berwyn, PA or Raleigh, NC office locations. Envestnet is transforming the way financial advice is deliver...Show more
    Last updated: 26 days ago
    Principal Database Programmer

    Principal Database Programmer

    TFS HealthScience • Durham, North Carolina, .US
    Full-time
    Quick Apply
    TFS HealthScience is a leading global mid-size Contract Research Organization (CRO) that partners with biotechnology and pharmaceutical companies throughout their entire clinical development journe...Show more
    Last updated: 6 days ago
    Lead Database Administrator

    Lead Database Administrator

    defi AUTO LLC • Raleigh, NC, US
    Full-time
    It’s an exciting time to join defi!.SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive a...Show more
    Last updated: 19 days ago • Promoted
    PostgreSQL DBA

    PostgreSQL DBA

    Omm IT Solutions • Raleigh, NC, us
    Full-time
    Quick Apply
    Candidate must be located within commuting distance or willing to relocate to Raleigh, NC.Candidate must be available to work on a rotating shift schedule to provide 24 / 7 support, including early m...Show more
    Last updated: 30+ days ago
    Senior Oracle DBA (Hybrid)

    Senior Oracle DBA (Hybrid)

    Serigor Inc. • Durham, NC, US
    Full-time
    The client requires a Senior Oracle DBA to provide development and optimization support to various applications using Oracle database on AWS. Primary responsibilities include managing the applicatio...Show more
    Last updated: 7 days ago • Promoted
    Oracle Certified Data Architect

    Oracle Certified Data Architect

    VirtualVocations • Raleigh, North Carolina, United States
    Full-time
    A company is looking for a Data Architect to support a long-term government contract.Key Responsibilities Lead a team of data analysts and database administrators Design and construct database a...Show more
    Last updated: 1 day ago • Promoted
    Senior Database Engineer

    Senior Database Engineer

    VirtualVocations • Raleigh, North Carolina, United States
    Full-time
    A company is looking for a Senior Database Engineer to join their team.Key Responsibilities Design, configure, and manage MySQL databases hosted on AWS RDS and Aurora Improve existing database s...Show more
    Last updated: 30+ days ago • Promoted
    Database Administrator for PostgreSQL

    Database Administrator for PostgreSQL

    VirtualVocations • Raleigh, North Carolina, United States
    Full-time
    A company is looking for a Database Administrator for PostgreSQL.Key Responsibilities Administer, configure, and maintain PostgreSQL databases ensuring high availability and security Monitor and...Show more
    Last updated: 1 day ago • Promoted