Database Architect

17 hours ago


Dallas, Texas, United States Photon Full time
Database Engineer

We are seeking a highly skilled and experienced Database Engineer to join our growing team at Photon. As a key member of our digital modernization team, you will be responsible for designing, developing, and maintaining our critical databases, ensuring high performance, reliability, and security.

Key Responsibilities:
  • Design and develop efficient database schemas in collaboration with stakeholders.
  • Create comprehensive database documentation, including ER diagrams, data models, and data dictionary.
  • Develop and execute DDL scripts for creating, altering, and maintaining database objects.
  • Manage database deployments and upgrades using tools like Datical.
  • Implement and maintain data migration strategies and processes.
  • Develop and maintain data quality control procedures.
  • Automate database tasks using scripting languages (e.g., Python, Shell).
  • Analyze database performance metrics, identify bottlenecks, and implement solutions for optimization.
  • Optimize queries and indexes for improved performance and reduced query execution times.
  • Implement database caching strategies to enhance performance.
  • Ensure compliance with security policies and regulations.
  • Implement security measures such as user access controls, data encryption, and auditing.
  • Monitor database security logs and investigate suspicious activity.
  • Manage and maintain database instances on AWS EC2 and RDS.
  • Implement and optimize database deployments in a cloud environment.
  • Understand and leverage AWS database services (e.g., DynamoDB, Redshift).
  • Implement and manage Oracle Virtual Private Database (VPD) for data access control.
  • Utilize Oracle Real Application Security (RAS) for database security and auditing.
  • Design and implement secure views in Snowflake for data access control.
  • Configure and manage row-level access policies in Snowflake.
  • Optimize Snowflake queries and storage for cost-efficiency and performance.
Requirements:
  • Bachelor's degree in Computer Science, Information Systems, or related field.
  • 5+ years of experience as a Database Engineer or equivalent role.
  • Strong understanding of relational database concepts and principles.
  • Proven experience with database design and development using SQL.
  • Hands-on experience with data modeling tools (e.g., ERwin, Visio).
  • Expertise in database performance optimization techniques and tools.
  • Experience with database automation tools (e.g., Datical, Liquibase).
  • Proficiency in scripting languages (e.g., Python, Shell) for database administration.
  • Experience with AWS EC2 and RDS services.
  • Deep understanding of Oracle VPD and RAS features.
  • Experience with Snowflake secure views and row access policies.
  • Strong analytical and problem-solving skills.
  • Excellent communication and interpersonal skills.


  • Dallas, Texas, United States Lorven technologies Full time

    Position: MongoDB Database Architect / Database Systems Engineer Company: Lorven Technologies Job Type: Contract Job Summary: Lorven Technologies is seeking a highly skilled MongoDB Database Architect to join our team. As a MongoDB Database Architect, you will be responsible for designing, implementing, and maintaining large-scale MongoDB databases. Key...


  • Dallas, Texas, United States Tekvivid Inc Full time

    Job Title: Database Solutions ArchitectJob Summary:We are seeking a skilled Database Solutions Architect to facilitate our transition from legacy systems to new data centers. As a key member of our team, you will be responsible for designing and implementing database solutions that meet the needs of our business.Key Responsibilities:Design and implement...

  • Database Architect

    3 days ago


    Dallas, Texas, United States Photon Full time

    Database EngineerWe are seeking a highly skilled and experienced Database Engineer to join our growing team at Photon. As a key member of our Digital Modernization team, you will be responsible for designing, developing, and maintaining our critical databases, ensuring high performance, reliability, and security.Key Responsibilities:Database Design &...

  • Database Architect

    2 weeks ago


    Dallas, Texas, United States Request Technology, LLC Full time

    Job Summary:Request Technology, LLC is seeking a highly skilled Database Administrator to join our team. As a key member of our database administration team, you will be responsible for designing and maintaining databases and database solutions that operate within prescribed resource limits and meet company standards.Key Responsibilities:Database Design and...

  • Database Architect

    1 week ago


    Dallas, Texas, United States Yoh, A Day & Zimmermann Company Full time

    Job Summary:We are seeking a skilled Database Developer/DBA to join our team at Yoh, A Day & Zimmermann Company. As a key member of our team, you will be responsible for designing, implementing, and maintaining databases to support our business operations.Key Responsibilities:Database Design and Development: Create and maintain views, functions, stored...


  • Dallas, Texas, United States Lorven technologies Full time

    Job Title: MongoDB DeveloperAbout the Role:We are seeking a highly skilled MongoDB Developer to join our team at Lorven Technologies. As a MongoDB Developer, you will be responsible for designing, implementing, and maintaining scalable and efficient MongoDB databases.Key Responsibilities:Design and implement MongoDB databases to meet the needs of our...


  • Dallas, Texas, United States SmartRun Technologies Inc Full time

    Job OverviewWe are seeking a highly skilled Healthcare Data Architect and Analyst to join our team at SmartRun Technologies Inc.Key ResponsibilitiesDevelop Strategic Data Architecture: Design and implement a robust data architecture for our enterprise analytics platform, ensuring seamless integration with healthcare use cases.Lead Technical Design and...

  • Security Architect

    3 days ago


    Dallas, Texas, United States Prudent Technologies and Consulting, Inc. Full time

    Job Title: Security ArchitectWe are seeking a highly skilled Security Architect to join our team at Prudent Technologies and Consulting, Inc.Job Summary:The Security Architect will be responsible for designing and implementing robust security solutions to protect our clients' technology infrastructure. This role requires a strong understanding of security...


  • Dallas, Texas, United States PureSoftware Ltd Full time

    Job Title: Cloud Data ArchitectJob Summary:PureSoftware Ltd is seeking a highly skilled Cloud Data Architect to join our team. As a Cloud Data Architect, you will be responsible for designing and implementing data applications on premises and cloud, ensuring the governance model on the database architecture, and participating in the development of database...


  • Dallas, Texas, United States Forhyre Full time

    Position OverviewForhyre is seeking a Technical Architect to spearhead the design and implementation of our IT frameworks, ensuring that our systems are architecturally sound and aligned with business objectives.In this capacity, you will be a pivotal communicator, adept at converting intricate requirements into actionable architectural plans. We value...

  • Data Architect

    1 week ago


    Dallas, Texas, United States Tata Consultancy Services Full time

    Job Title: Data ArchitectAbout the Role:We are seeking a highly skilled Data Architect to join our team at Tata Consultancy Services. As a Data Architect, you will play a critical role in defining the strategy for data purging, identifying and categorizing data based on predefined criteria, and interfacing with customer stakeholders to get approval for the...


  • Dallas, Texas, United States Syntricate Technologies Full time

    Salesforce Solutions Architect Location: Remote (Flexible) Employment Type: Full-timeAs a Salesforce Solutions Architect at Syntricate Technologies, you will play a pivotal role in the development and enhancement of Salesforce applications. Your responsibilities will include:Overseeing various forms of standard Salesforce development and customization...


  • Dallas, Texas, United States Federal Reserve Bank of Cleveland Full time

    Job DescriptionWe are seeking a highly skilled Senior Solution Architect to join our Federal Reserve Financial Services (FRFS) team. As a key member of our Solution Architecture team, you will be responsible for designing and engineering complex technology solutions across multiple platforms, ensuring high performing, high volume transaction processing.The...


  • Dallas, Texas, United States PureSoftware Ltd Full time

    Job Title: Cloud Data ArchitectJob Summary:PureSoftware Ltd is seeking a highly skilled Cloud Data Architect to join our team. As a Cloud Data Architect, you will be responsible for designing and implementing data architecture solutions on Azure Cloud. You will work closely with our development team to ensure that our data solutions are scalable, secure, and...


  • Dallas, Texas, United States SSi People Full time

    Position Overview:This role is for a seasoned Software Architect who will play a pivotal role in guiding the development of enterprise-grade microservices within the Business Lending sector.Key Responsibilities:Engage with cross-functional teams to identify both functional and non-functional requirements for new software solutions.Oversee modifications to...

  • IT Systems Architect

    3 weeks ago


    Dallas, Texas, United States Forhyre Full time

    Job OverviewForhyre is seeking a skilled Technical Architect to conceptualize and structure our IT frameworks, ensuring that our systems are architecturally sound and aligned with business objectives.In this position, you will be a key communicator, adept at translating intricate requirements into actionable architectural designs. Your background in software...


  • Dallas, Texas, United States Elite Tech Inc Full time

    Job Title: Enterprise Architect with AWS and Azure ExpertiseAbout the Role:We are seeking an experienced Enterprise Architect to join our team at Elite Tech Inc. as a Senior Enterprise Architect with Cloud and AI/ML Experience. The successful candidate will be responsible for designing and implementing cloud-based solutions using AWS and Azure.Key...


  • Dallas, Texas, United States Protagona Full time

    Job OverviewAs a Cloud Solutions Architect at Protagona, you will be instrumental in steering the technical strategy for client engagements, ensuring alignment with their business goals and objectives. Your expertise will be vital in designing a comprehensive solution that encompasses security, performance, availability, maintainability, and...


  • Dallas, Texas, United States Amazon Web Services, Inc. Full time

    About the RoleWe are seeking a highly motivated Solutions Architect to join our team at Amazon Web Services, Inc. as part of our growing GovTech business. As a Solutions Architect, you will play a key role in helping to establish Amazon Web Services (AWS) as a leading technology platform for Government Technology companies.Key ResponsibilitiesOwning the...


  • Dallas, Texas, United States Tekvivid Inc Full time

    Job Title: Mobile ArchitectAbout the Role:We are seeking a highly skilled Mobile Architect to join our team at Tekvivid Inc. As a Mobile Architect, you will be responsible for designing and developing native hybrid and cross-platform mobile apps for iOS and Android devices.Key Responsibilities:Architect and develop mobile applications for iOS and Android...