The Intersect Group | Database Architect

6 days ago

dallas, United States The Intersect Group Full time

The Intersect Group is seeking a Database Architect for our direct healthcare client, where you will join an existing team of Developers and Analyst to ensure data assets are of proper quality and highly available to their business decision process. This role shall build and architect MS SQL database systems/servers, while collaborating closing with integration and reporting teams to deliver best possible solutions. This is a hands-on role that will also optimize databases for scalability and performance, lead projects and provide technical guidance to other developers, both onshore and offshore.



Needed:

  • 10+ years of experience in Data Architecture, database development, integration, and related areas
  • 5+ years of hands-on experience optimizing SQL Server databases for scalability and performance
  • 3+ years working with SQL Server in Azure – either on VM or Managed Instance
  • 3+ years working with offshore team
  • Exceptional knowledge of Microsoft SQL Server internals and optimization on a VM/Azure
  • Ability to quickly grasp and articulate dependencies between processes and data
  • Strong ability to analyze systems and data and pay attention to detail
  • Excellent communication, organizational and time management skills
  • Takes initiative and can manage and complete multiple concurrent projects in a timely manner


Preferred:

  • Bachelor’s degree or equivalent combinations of education and experience
  • Experience leading projects
  • Experience working with Snowflake, Databricks, Azure Data Factory, Power BI


Duties:

  • Build and oversee the data architecture design, and manage database systems
  • Create databases and provide access to users while meeting security requirements
  • Ensure optimal performance and scalability for SQL Servers in Azure – either on VM, Managed Instances, or SQL DBs
  • Identify system bottlenecks, and optimize performance to ensure timely deliverables
  • Work with developers on indexing and query-tuning, and provide guidance in building optimal code
  • Work with IT team to review and refine procedures for disaster recovery and high availability
  • Monitor SQL Servers, disk space, resource utilization and ensure capacity needs are met
  • Leverage SQL and Azure tools to monitor jobs, optimize processes and build better solutions
  • Work closely with offshore/onshore developers and users and coordinate on deliverables
  • Take ownership to maintain a high level of uptime and performance for all databases and services
  • Assist with managing source code and deployments, and implement best-practices
  • Develop and implement database/reporting policies and procedures, including those for architecture, security, disaster recovery, performance, and service provision
  • Assist with streamlining data integration processes, improving efficiencies, reducing effort related to development and support, while providing security, flexibility and scalability
  • Build and maintain strong relationship between different business units and onshore/offshore teams
  • Research and evaluate new tools/features Azure (Data Lake, Databricks, Purview, Fabric, etc.) and assist in building Proof-of-Concept.

  • The Intersect Group | Database Architect

    7 days ago

    dallas, United States The Intersect Group Full time

    The Intersect Group is seeking a Database Architect for our direct healthcare client, where you will join an existing team of Developers and Analyst to ensure data assets are of proper quality and highly available to their business decision process. This role shall build and architect MS SQL database systems/servers, while collaborating closing with...

  • Database Architect

    7 days ago

    Dallas, United States The Intersect Group Full time

    The Intersect Group is seeking a Database Architect for our direct healthcare client, where you will join an existing team of Developers and Analyst to ensure data assets are of proper quality and highly available to their business decision process. This role shall build and architect MS SQL database systems/servers, while collaborating closing with...

  • Database Architect

    6 days ago

    Dallas, United States The Intersect Group Full time

    The Intersect Group is seeking a Database Architect for our direct healthcare client, where you will join an existing team of Developers and Analyst to ensure data assets are of proper quality and highly available to their business decision process. This role shall build and architect MS SQL database systems/servers, while collaborating closing with...

  • The Intersect Group | ETL/Integration Developer | dallas, tx

    1 month ago

    dallas, United States The Intersect Group Full time

    INTEGRATION DEVELOPERRole and Responsibilities:The Intersect Group is seeking an Integration Engineer for our direct client, where you will join their Data Governance team and will help ensure that data assets are of proper quality and highly available. The role includes developing data integration processes and maintaining and supporting them in Microsoft...

  • The Intersect Group | Cloud Engineer

    3 weeks ago

    dallas, United States The Intersect Group Full time

    The Intersect Group is partnered with our client who has an opening for a Cloud Engineer in their Dallas office. In this role, you will be responsible for designing, developing, managing, and implementing cloud-based solutions, with a primary emphasis on Microsoft Azure and the Office 365 suite. However, you will also work with additional cloud platforms to...

  • The Intersect Group | Cloud Engineer

    2 weeks ago

    dallas, United States The Intersect Group Full time

    The Intersect Group is partnered with our client who has an opening for a Cloud Engineer in their Dallas office. In this role, you will be responsible for designing, developing, managing, and implementing cloud-based solutions, with a primary emphasis on Microsoft Azure and the Office 365 suite. However, you will also work with additional cloud platforms to...

  • The Intersect Group | Cloud Engineer

    6 days ago

    dallas, United States The Intersect Group Full time

    The Intersect Group is partnered with our client who has an opening for a Cloud Engineer in their Dallas office. In this role, you will be responsible for designing, developing, managing, and implementing cloud-based solutions, with a primary emphasis on Microsoft Azure and the Office 365 suite. However, you will also work with additional cloud platforms to...

  • The Intersect Group | Cloud Engineer

    7 days ago

    dallas, United States The Intersect Group Full time

    The Intersect Group is partnered with our client who has an opening for a Cloud Engineer in their Dallas office. In this role, you will be responsible for designing, developing, managing, and implementing cloud-based solutions, with a primary emphasis on Microsoft Azure and the Office 365 suite. However, you will also work with additional cloud platforms to...

  • The Intersect Group | Senior BI Developer/Architect | dallas, tx

    4 weeks ago

    dallas, United States The Intersect Group Full time

    SENIOR BI ANALYSTThis role of a Business Intelligence Developer is a key member of the technology team and serves as the Company’s Internal Snowflake, SQL and Tableau developer. This role will support technology and business intelligence initiatives to deliver optimal returns on investment in coordination with the organization’s goals and core values...

  • Data Integration Specialist

    1 month ago

    Dallas, Texas, United States The Intersect Group Full time

    Job Summary:The Intersect Group is seeking an experienced Data Integration Specialist to join their Data Governance team. This role involves developing and maintaining data integration processes in a Microsoft Azure environment.Key Responsibilities:Integrate healthcare and financial data provided by clients and external vendorsDevelop, test, and support...

  • ETL/Integration Developer

    1 month ago

    Dallas, United States The Intersect Group Full time

    INTEGRATION DEVELOPERRole and Responsibilities:The Intersect Group is seeking an Integration Engineer for our direct client, where you will join their Data Governance team and will help ensure that data assets are of proper quality and highly available. The role includes developing data integration processes and maintaining and supporting them in Microsoft...

  • Database Systems Architect

    2 weeks ago

    Dallas, Texas, United States Photon Full time

    Job Title: Database Systems ArchitectLocation: Dallas, TXEmployment Type: FulltimeAbout the Job:This is a full-time position for a skilled Database Systems Architect. We are looking for an experienced professional with expertise in Oracle database and Informatica PowerCenter tools.Responsibilities:Design and develop complex database systems using Oracle...

  • Server Engineer

    4 months ago

    Dallas, United States The Intersect Group Full time

    Server Engineer IISummary: The Intersect Group is seeking an experienced Server Engineer for our direct banking client, where you will secure, monitor and maintain a primarily Microsoft client/ server environment. You'll be asked to recommend new hardware, tools, applications and processes to enhance the current structure and accommodate for growth, and...

  • Server Engineer

    3 months ago

    dallas, United States The Intersect Group Full time

    Server Engineer IISummary: The Intersect Group is seeking an experienced Server Engineer for our direct banking client, where you will secure, monitor and maintain a primarily Microsoft client/ server environment. You'll be asked to recommend new hardware, tools, applications and processes to enhance the current structure and accommodate for growth, and...

  • Server Engineer

    6 days ago

    Dallas, United States The Intersect Group Full time

    Server Engineer IISummary: The Intersect Group is seeking an experienced Server Engineer for our direct banking client, where you will secure, monitor and maintain a primarily Microsoft client/ server environment. You'll be asked to recommend new hardware, tools, applications and processes to enhance the current structure and accommodate for growth, and...

  • Senior DevOps engineer

    2 months ago

    Dallas, United States The Intersect Group Full time

    Senior DevOps EngineerJob Summary: The Intersect Group is seeking a skilled Senior DevOps Engineer for our direct banking client to lead the design, implementation, and management of our CI/CD pipelines, automation processes, and Azure DevOps infrastructure. This role is integral to enhancing our data process management, following best practices in...

  • Senior DevOps engineer

    2 months ago

    dallas, United States The Intersect Group Full time

    Senior DevOps EngineerJob Summary: The Intersect Group is seeking a skilled Senior DevOps Engineer for our direct banking client to lead the design, implementation, and management of our CI/CD pipelines, automation processes, and Azure DevOps infrastructure. This role is integral to enhancing our data process management, following best practices in...

  • Senior BI Developer/Architect

    4 weeks ago

    Dallas, United States The Intersect Group Full time

    SENIOR BI ANALYSTThis role of a Business Intelligence Developer is a key member of the technology team and serves as the Company’s Internal Snowflake, SQL and Tableau developer. This role will support technology and business intelligence initiatives to deliver optimal returns on investment in coordination with the organization’s goals and core values...

  • Senior BI Developer/Architect

    6 days ago

    Dallas, United States The Intersect Group Full time

    SENIOR BI ANALYSTThis role of a Business Intelligence Developer is a key member of the technology team and serves as the Company’s Internal Snowflake, SQL and Tableau developer. This role will support technology and business intelligence initiatives to deliver optimal returns on investment in coordination with the organization’s goals and core values...

  • Telecommunications Network Architect

    1 month ago

    Dallas, Texas, United States Glotel Inc Full time

    We are seeking a highly skilled Telecommunications Network Architect to join our team at Glotel Inc. Based in Denver, this full-time position offers a competitive salary of $110,000 - $140,000 per annum.Job Overview:As a Telecommunications Network Architect, you will be responsible for designing and implementing new success-based capacity onto our existing...