Engineering Jobs in Dallas County, TX
216 positions found — Page 4
Generative AI Developer Location: Dallas TX/ Tampa FL/New Jersey
- Hybrid Fulltime/FTE Salary: Market Client: Bank Role Overview We are seeking an experienced Senior Generative AI Developer to design and implement cutting-edge AI solutions leveraging Retrieval-Augmented Generation (RAG) techniques.
The ideal candidate will have strong expertise in Python programming, FastAPI, and cloud platforms (AWS, Azure, or GCP).
This role requires a deep understanding of system architecture design, scalable APIs, and end-to-end AI solution development.
Key Responsibilities Architect and develop Generative AI applications using RAG frameworks for enterprise-scale solutions.
Design and implement robust system architectures for AI-driven platforms ensuring scalability, security, and performance.
Build and optimize APIs using FastAPI for seamless integration with AI models and data pipelines.
Collaborate with cross-functional teams to integrate AI solutions into existing systems and workflows.
Implement data ingestion, preprocessing, and retrieval mechanisms for large-scale knowledge bases.
Ensure compliance with best practices for cloud deployment (AWS, Azure, or GCP).
Conduct performance tuning and optimization of AI models and APIs.
Stay updated with the latest advancements in Generative AI, LLMs, and RAG methodologies.
Required Skills & Qualifications 8+ years of professional experience in software development and system design.
Strong proficiency in Python and experience with FastAPI for API development.
Hands-on experience with Generative AI frameworks and RAG architectures.
Solid understanding of system and architecture design principles for distributed applications.
Experience deploying solutions on any major cloud platform (AWS, Azure, GCP).
Familiarity with vector databases, embedding models, and retrieval pipelines.
Strong problem-solving skills and ability to work in a fast-paced environment.
Preferred Qualifications Experience with LLM fine-tuning, prompt engineering, and model evaluation.
Knowledge of containerization (Docker) and orchestration (Kubernetes).
Exposure to CI/CD pipelines and DevOps practices.
Email:
You also will work with the premium brand within their Freezer Chiller vertical.
Client Details A globally recognized manufacturer in the food‑processing sector, this company specializes in advanced cooling, freezing, and heat‑transfer systems used in large‑scale production environments.
Its portfolio includes high‑efficiency spiral and impingement technologies designed for continuous freezing, chilling, steaming, and proofing across a wide range of food applications.
The organization is known for engineering tailored systems that integrate seamlessly into existing production lines, emphasizing energy efficiency, product consistency, and rapid thermal performance.
With decades of experience supplying spiral systems to food producers worldwide, it maintains a strong focus on research, development, and technical support-from system design through installation and ongoing service.
Description Expect frequent travel (50% or more) throughout North America for customer visits, equipment demonstrations, and industry events.
Occasional international travel may be required for team meetings or major trade shows.Strategic Leadership Build and execute a comprehensive North American sales strategy within your first six months.
Growth‑Focused Mindset Allocate the majority of your efforts toward acquiring new customers while maintaining strong relationships with existing strategic partners.
High‑Value Project Management Lead complex, consultative, and long‑cycle capital‑equipment sales efforts, including projects ranging from mid‑scale to large multi‑million‑dollar investments.
Cross‑Functional Collaboration Work closely with affiliated business units and regional teams across the Americas to maximize shared opportunities and coordinated market reach.
Technical Partnership Collaborate with engineering specialists in Europe to develop tailored freezing and chilling solutions that meet the rigorous performance and compliance demands of North American processors.
The company is an Equal Employment Opportunity employer and encourages applications from all qualified individuals.MPI does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or based on an individual's status in any group or class protected by applicable federal, state or local law.
MPI encourages applications from minorities, women, the disabled, protected veterans and all other qualified applicants.
Profile Extensive experience (5+ years) in industrial capital‑equipment sales, ideally involving thermal‑processing, cooling, or freezing systems.
Commercial Agility Comfortable managing long sales cycles, multi‑stakeholder negotiations, and large CAPEX decision processes.
Industry Knowledge Strong familiarity with factory operations and food‑processing environments, particularly in protein or bakery segments.
Mobility Ability and willingness to travel frequently across North America and to international industry events.
Salary Competitive compensation aligned with experience and performance expectations.
Job Offer Competitive Pay: High base salary with an uncapped commission structure.
Full Support: Comprehensive benefits package including Health/Dental/Vision, 401(k) match, and generous PTO.
Tools for Success: Company vehicle/allowance, expense account, and the latest tech (laptop/phone).
Autonomy: A remote-first environment that trusts you to manage your territory like your own business.
Compensation & Benefits Medical, dental, and vision insurance Health Savings Account with employer contribution Flexible Spending Account options Employer‑paid life and disability coverage Employee Assistance Program Paid holidays and paid time off 401(k) plan Additional wellness and support benefits MPI does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or based on an individual's status in any group or class protected by applicable federal, state or local law.
MPI encourages applications from minorities, women, the disabled, protected veterans and all other qualified applicants.
About GEMCO
Founded in 2014 and headquartered in Indianapolis, GEMCO Constructors is a national mechanical, electrical, plumbing, building automation, and service contractor. Licensed in over 30 states, GEMCO delivers design-build solutions across diverse markets with a focus on safety, quality, and innovation.
Position Summary
The Senior Project Manager/Estimator – Industrial Plumbing leads large-scale industrial plumbing projects from concept to completion and manages estimating activities that support project acquisition. This role oversees planning, design, budgeting, scheduling, and execution to ensure compliance with quality, safety, and financial goals. *Please note, this job is for our Charlotte, NC location.*
Key Responsibilities
- Manage all phases of industrial plumbing projects including installation, retrofits, and upgrades.
- Develop and monitor schedules, budgets, and resources while identifying and mitigating risks.
- Oversee subcontractors, ensure quality standards, and maintain safety compliance.
- Act as the main client contact, managing communication and scope changes.
- Review drawings and specifications to prepare accurate estimates and bid proposals.
- Solicit vendor pricing, perform take-offs, and coordinate bid submissions.
- Mentor and develop project staff, fostering teamwork and accountability.
- Collaborate with business development on bids and client relationships to support growth.
Requirements
Qualifications
- Bachelor’s degree in Construction Management, Mechanical Engineering, or related field preferred; equivalent experience considered.
- 7–10 years of industrial plumbing project management experience.
- Proven success delivering large-scale projects on time and within budget.
- PMP certification or Master Plumber License preferred.
- Strong technical knowledge of plumbing systems, estimating software, and construction management tools.
- Excellent leadership, communication, and problem-solving skills.
- Ability to work on-site, including standing, walking, and climbing ladders.
- Regular travel to job sites and flexibility to meet project deadlines.
Summary
Why GEMCO
Join a fast-growing national contractor offering competitive pay, comprehensive benefits, and opportunities for impact and growth.
Benefits Include:
- Company-paid health benefits
- HSA with company contribution and match
- 401(k) with company match
- Paid Time Off and annual bonuses
- Phone and vehicle allowance
GEMCO is an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, disability, or veteran status.
CarMax, the way your career should be!
Principal Engineer – Network, Cloud & Identity (ISE / NAC)
About This Role
CarMax is modernizing and scaling its technology platforms to support secure, reliable, and resilient digital experiences. As a Principal Engineer within the Solutions Delivery and Engineering organization, you will provide senior technical leadership across enterprise networking, cloud networking, and automation, with a specific focus on Identity Services Engine (ISE) and Network Access Control (NAC).
This role combines hands-on technical expertise with architectural guidance and cross-team influence. You will partner with engineering teams, operational support teams, architects, and leadership to implement, support, and evolve secure network platforms that support both cloud and on-premise environments.
Key Responsibilities
- Provide senior technical leadership for enterprise network and cloud networking platforms, ensuring reliability, scalability, and security.
- Partner with technology leadership to support large, cross‑organizational initiatives and address complex technical challenges.
- Collaborate with engineering, architecture, and product teams to design and deliver network and identity solutions aligned with business needs.
- Influence technical standards, patterns, and best practices across teams, with an emphasis on security, automation, and operational efficiency.
- Lead design and implementation efforts for network access control (NAC) and identity-based network security solutions.
- Mentor and guide engineers through technical reviews, design discussions, and problem resolution.
- Participate in on-call rotation to support scheduled change windows and incident response for enterprise networks.
- Display high level leadership skills, being able to drive the overall vision of the organization.
- Stay current with industry trends in networking, cloud connectivity, automation, and identity services, and apply relevant advancements where appropriate.
Role Summary
The Principal Engineer is a senior individual contributor role focused on technical depth, architectural consistency, and engineering excellence. This position requires strong problem-solving skills, the ability to work across organizational boundaries, and experience influencing technical direction without direct authority. You will be expected to balance strategic thinking with hands-on involvement, particularly in complex or high-impact initiatives related to network security and identity.
Required Qualifications
- Bachelor’s Degree in Computer Science, Decision Science, Engineering, Statistics, or a related field, or equivalent alternative education, skills, and/or practical experience is preferred.
- 7+ years of work experience required in Network, Cloud Network, Network Security, and other areas directly relevant to Network/Cloud/Automation responsibilities and tasks; multiple certifications preferred.
- Demonstrated experience working in large, complex enterprise environments.
Technical Experience
Network, Cloud, and Automation
- 7+ years of experience with enterprise routing, switching, firewalls, and wireless networks, with HPE Aruba and Fortinet experience preferred.
- 5+ years of experience designing, building, and operating network infrastructure in cloud platforms, with Azure preferred.
- Strong understanding of hybrid networking models connecting on‑premise environments with public cloud platforms.
- Experience with network automation and scripting using languages such as Python, Ansible or PowerShell.
- Proven ability to design and support highly available and resilient network architectures.
- Experience driving technical improvements or standards across multiple teams.
Identity, NAC, and Cisco ISE
- Hands-on experience designing, implementing, and supporting Cisco Identity Services Engine (ISE) in enterprise environments.
- Strong knowledge of Network Access Control (NAC) concepts and implementations for wired, wireless, and device administration use cases.
- Experience configuring authentication and authorization policies within Cisco ISE.
- Experience implementing and supporting TACACS+ for device administration and role-based access control.
- Ability to act as a technical subject matter expert for ISE and NAC, providing guidance to engineering teams and stakeholders.
Professional Skills
- Strong analytical and troubleshooting skills, with the ability to resolve complex technical issues.
- Clear and effective communication skills, both written and verbal.
- Ability to work independently while also collaborating across teams and disciplines.
- Attention to detail and a focus on operational stability and security.
- Interest in continuous improvement through automation and process optimization.
Work Location and Arrangement - This role can be based out of the following locations:
- Midtown: This role will be based out of the CarMax Midtown Office (Richmond, VA) and associates will work onsite 5 days per week
- Plano: This role will be based out of the Dallas Tech Hub (Plano, TX) and associates will work onsite 2 days per week.
Work Authorization: Applicants must be currently authorized to work in the United States on a full-time basis. Sponsorship will not be considered for this specific role.
About CarMax
CarMax disrupted the auto industry by delivering the honest, transparent and high-integrity experience customers want and deserve. This innovative thinking around the way cars are bought and sold has helped us become the nation’s largest retailer of used cars, with over 250 locations nationwide.
Our amazing team of more than 25,000 associates work together to deliver iconic customer experiences. Along the way, we help every associate grow their career and achieve their best, at work and in their community. We are recognized for our commitment to training and diversity and are one of the FORTUNE 100 Best Companies to Work For®.
Required Skills & Experience
-5+ years of Product Management experience with ownership of product roadmaps and delivery
-Strong experience delivering BI, reporting, and data visualization products
-Hands‑on experience with BI and analytics tools, with Tableau or similar visualization platforms strongly preferred
-Proven ability to translate business requirements into intuitive, high‑quality dashboards and reporting experiences
-Experience working with APIs, data platforms, and analytics ecosystems at a conceptual/product level
-Strong stakeholder management skills across executive, business, and technical audiences
Nice to Have Skills & Experience
-Experience working in global or international environments
-Second language proficiency
-Exposure to enterprise or franchise‑based business models
Job Description
Insight Global is seeking a Senior Product Manager to lead the strategy, development, and rollout of enterprise business intelligence, reporting, and data visualization solutions across international markets. This role owns the product roadmap for how data is visualized, distributed, and consumed by stakeholders ranging from executives to regional and franchise leaders.
This position is not focused on sourcing, integrating, or transforming raw data. Instead, the role is centered on defining and delivering high‑impact reporting and visualization solutions, including decisions around buy vs. build, tooling strategy, and how insights are best presented to drive decision‑making.
The Senior Product Manager will partner closely with engineering, analytics, and global business leaders to ensure reporting solutions are scalable, standardized, and aligned to real business needs.
Key Responsibilities:
-Define and execute the product vision and roadmap for BI, reporting, and visualization solutions across international markets
-Connect business needs and regional asks to effective data visualization, reporting distribution, and insight delivery
-Own product strategy for BI and analytics tooling from a business value and user‑experience perspective
-Determine buy vs. build decisions for reporting and visualization platforms to best support executive, operational, and franchise audiences
-Partner with engineering, analytics, and platform teams to deliver reliable, well‑rendered reporting solutions (without owning raw data ingestion or transformation)
-Drive global standardization of dashboards, reporting frameworks, and visualization best practices while accommodating regional requirements
-Collaborate with stakeholders to define success metrics, adoption measures, and business impact of reporting solutions
-Manage third‑party vendors and BI technology partners, ensuring alignment to product goals and reporting standards
-Support regional initiatives, new market launches, and leadership reporting needs through scalable BI enablement
Project description
The customer is looking for a JavaFS / Spring / C# / CSS
Responsibilities
Collaborates with leaders, business analysts, project managers, IT architects, technical leads and other developers, along with internal customers, to understand requirements and develop needs according to business requirements
Maintains and enhances existing enterprise services, applications, and platforms using domain driven design and test-driven development
Troubleshoots and debugs complex issues; identifies and implements solutions
Creates detailed project specifications, requirements, and estimates
Researches and implements new technologies to enhance current processes, security, and performance
Supports the development of coding standards and adheres to best practices and security guidelines
Works closely with software architects and technical leads to ensure decisions meet long-term enterprise growth needs"
Skills
Must have
Bachelor's degree in Computer Science, Computer Engineering, Technology, Information Systems (CIS/MIS), Engineering or related technical discipline, or equivalent experience/training
5+ years of experience designing, developing, and implementing large-scale solutions in production environments TOP Skills Required: Java FullStack / focus on Front End
REACT .NET/C# SQL DataFactory UI Skills, Licenses & Certifications
Proficiency in Full Stack Development
Proficiency with the following technologies:
Programming Languages: C# required, PySpark and Python is a plus.
Frameworks: Spring/SpringBoot, FastAPI, .Net Core, .Net Framework
Front End Technologies: CSS, jQuery, AJAX, Hands on experience in Single Page Architectures such as React is required
Source Control: GitHub, Azure DevOps
CICD: GitHub Actions, Azure DevOps
Data management: PostgreSQL, MS SQL
Integration/APIs Technologies: Kafka, REST, GraphQL
Cloud Providers such as Azure
Other Dev Ops Toolchain: Selenium, SonarQube, GitHub, Kibana, New Relic 10. Proficiency in Networking and security concepts: OAuth, VNet Injection, VNet Integration, Private Endpoints, Azure Firewall 1
Proficiency in object-oriented design techniques and principles 1
Proficiency in Development Tools: Visual Studio, Visual Studio Code, SQL Server Management Studio, Azure Data Studio
Ability to concisely convey ideas verbally, in writing, in code, and in diagrams
Ability to work through others by cooperatively sharing responsibilities
Proficiency in Agile methodologies, such as SCRUM
Job Title: Network Operations Manager - NMS
Job Type: Full time - Permanent
Location: Richardson, TX – Onsite
Job Summary
- Lead the implementation and evolution of the client’s proprietary managed service systems that use network intelligence to maintain, optimize, and enhance customer networks.
- This technical leadership role balances hands-on implementation with team coordination, process improvement, and product development to enable scalable and efficient operations.
- Implement and support the network management systems that power the client’s managed services, including Ciena Navigator, Nokia WS-NOC, and NFM-P, along with related proprietary software platforms.
- Deliver proactive lifecycle management through Managed Software Services (MSS), including remote upgrades, security patching, and platform maintenance across customer optical NMS environments.
- Collaborate closely with the client’s software development and network engineering teams to identify and implement capabilities that leverage network intelligence data to proactively detect, communicate, and automatically resolve issues—transforming raw telemetry into actionable insights that prevent customer-impacting events network
ROLES & RESPONSIBILITIES
Network Intelligence and Service Delivery Optimization
- Collaborate with software development and network engineering teams to identify and implement features that transform network telemetry into proactive issue detection, communication, and automated resolution
- Drive automation and tooling improvements to increase efficiency and reduce manual effort
- Expand the internal knowledge base to accelerate implementation and troubleshooting
- Develop reporting on service delivery metrics, upgrade pipelines, and resource utilization
Service Delivery & Technical Leadership
- Lead delivery of Managed Software Services (MSS) – NMS upgrades, security patches, and maintenance – through direct execution or team delegation
- Provide technical escalation and approve upgrade strategies, rollback procedures, and risk mitigation plans
- Coordinate with customers' engineering and PM teams to manage scope changes, resolve delivery issues, and maintain high satisfaction
- Stay current on vendor software releases, security vulnerabilities, and industry best practices
- Manage vendor relationships for support, licensing, and technical escalations
Business & Operational Management
- Serve as primary point of contact for MSS and support quarterly business reviews
- Support sales and account management to refine and close new MSS opportunities
- Track operational budgets and drive profitability for MSS engagements
- Define and track KPIs: upgrade success rate, on-time delivery, customer satisfaction, and team utilization
Team Development & Culture
- Lead and mentor high-performing team with clear roles, responsibilities, and career progression
- Conduct performance reviews and provide coaching on technical capabilities and customer service excellence
- Foster a culture of proactive service delivery, continuous improvement, and technical innovation
QUALIFICATIONS
Required Experience
- 5+ years of experience in network operations, managed services, or telecom service delivery with strong technical foundation in enterprise IT infrastructure
1. Linux/Windows environments, database management, virtualization platforms
- Lifecycle management: system updates, security patches, and firmware upgrades
- Administering storage arrays and ensuring RAID/disk redundancy is in place
- Managing software license files tied to NMS platforms
- Maintaining replication and backup jobs
- 2+ years in leadership roles managing technical, service delivery teams
- Working knowledge of optical networking technologies (DWDM, OTN) in relation to Network Management Systems (Ciena Navigator/MCP, Nokia WaveSuite, or similar platforms)
- Proven track record delivering Managed Services with SLA commitments and customer satisfaction goals
- Experience with remote service delivery models, maintenance window planning, and change management
- Familiarity with ITIL service management framework and best practices
- Vendor management and escalation experience with telecom equipment manufacturers and software providers
Preferred Qualifications
- ITIL Foundation, PMP, or relevant vendor and technical certifications (Ciena, Nokia, VMware, Hyper-V)
- Experience in both service provider and enterprise networking environments
- Knowledge of network automation using Python, Ansible, or similar tools
- Experience with agile project delivery methodologies
- Leadership & Soft Skills
- Strong written and verbal communication skills
- Proven ability to develop and mentor technical talent
- Strong problem-solving skills and ability to make sound decisions under pressure
- Experience working with remote team members and customers
- Ability to balance strategic planning with hands-on technical problem solving
- Customer-focused mindset with commitment to service excellence
Education
Bachelor's degree in Telecommunications, Electrical Engineering, Computer Science, or related field; or equivalent experience
Optomi, in partnership with a leading logistics company is seeking a Senior Full Stack Java Developer (Java / Kafka / Spring Boot / AWS) to support and modernize critical systems within the Mechanical organization. This team maintains locomotives, railcars, and detector systems that capture millions of operational and safety data points across the network.
About the Position: The role focuses on refactoring legacy microservices, scaling event-driven architectures, re-platforming rules engines, and building cloud-native, resilient, high-volume IoT data pipelines. This is a high-impact engineering role where your work directly influences safety, reliability, and operational efficiency across one of the largest transport networks in the US.
Apply Today if your Background Includes:
- 6+ years of Full Stack experience with a backend emphasis in Java Spring Boot development.
- Strong event-driven architecture + Kafka experience
- Proven experience modernizing legacy microservices & distributed systems
- AWS Cloud experience
- Hands-on Python experience for backend/data workflows
- DevSecOps mindset: automated testing, CI/CD, secure coding
- Experience supporting both greenfield and legacy systems
- Strong relational DB experience (Postgres preferred)
- Experience handling IoT or high-volume sensor data pipelines
- Familiarity with open-source tooling and cloud-agnostic architectures
- Ability to mentor junior engineers and provide technical leadership
What the Right Professional Will Enjoy!
- Fully remote work opportunity with up to 20% travel.
- Opportunity to work with a fast-growing team focused on modernization, cloud adoption, and automation.
- Direct impact on safety, rail operations, and national freight logistics.
- Work on high-volume IoT, event-driven architectures, cloud-native systems.
- Exposure to AI/GenAI, automation, and open-source tooling
- Leadership opportunities with junior developers
Responsibilities:
- Modernize legacy microservices and distributed systems supporting mechanical operations and detector networks.
- Design and implement backend services using Java, Spring Boot, event-driven patterns, and Kafka.
- Scale and optimize high-volume IoT data pipelines (30M+ incoming data points from sensors/detectors).
- Lead architecture, design, and deployment efforts for new and existing services.
- Refactor and support large rules-engine frameworks (600+ rulesets).
- Contribute to cloud-native development (AWS preferred; Azure acceptable; cloud agnostic mindset encouraged).
- Use Python for backend workflows, automation, and data processing tasks.
- Build automated CI/CD and testing frameworks following DevSecOps best practices.
- Work with Postgres and relational databases to tune, model, and integrate data.
- Mentor junior developers and support a strong engineering culture focused on speed, clarity, and automation.
- Collaborate across teams to build scalable, modern systems.
- Support both new development and the existing application footprint.
Remote working/work at home options are available for this role.
Title: Technical Product Manager - Senior
Location: Dallas, TX 75202 (Onsite)
Duration: 12 Months
Top Skills:
- Product Manager who worked on VOC (Voice of Customer) with B2C digital/e-commerce front end experience is required.
- Strong partnership and influence with UX teams is required.
- Expertise in middle and lower acquisition funnel
- Strong understanding of VOC, Data insights and biased for action
- Excellent storyteller, expert in understand customer value “WHY” and coming up with “WHAT” & partnering on “HOW” and “WHEN”
- Experience as software engineer, working through SDLC, and at least 5 years of experience as a Product Owner post engineering background is preferred
We are seeking a Senior Lead Developer to lead the development and deployment of our backend services. In this role, you will be the bridge between our PostgreSQL database and React frontend, responsible not only for writing high-performance Python code but also for architecting the CI/CD pipelines that bring our applications to life. You will ensure our integration layers are scalable, secure, and automatically deployed.
Key Responsibilities
• API & Backend Development: Design and maintain production-grade RESTful APIs using Python (FastAPI, Flask) with a focus on asynchronous processing.
• Database Engineering: Architect relational schemas and write optimized SQL in PostgreSQL, ensuring data integrity and query performance.
• React Integration: Partner with frontend teams to define API contracts, handle state-consistent data fetching, and implement secure authentication (JWT/OAuth2).
• CI/CD & Deployment: Build and manage automated deployment pipelines (e.g., Azure DevOps or Jenkins) to move code from local environments to staging and production.
• Containerization & Cloud: Package applications using Docker and manage deployments on cloud platforms or container orchestrators (Kubernetes/ECS).
• System Reliability: Implement automated testing (PyTest), logging, and monitoring to ensure high availability of integration services.
Technical Requirements
• Experience: 10+ years of professional backend development with a heavy emphasis on Python and API architecture.
• PostgreSQL Expert: Advanced SQL knowledge, including indexing strategies, migrations (Alembic/Flyway), and performance profiling.
• DevOps Tooling: Hands-on experience with Docker and building CI/CD pipelines for Python applications.
• Frontend Literacy: Solid understanding of React (Hooks, Context API) and how it consumes complex JSON structures.
• Infrastructure as Code (Bonus): Familiarity with Terraform or AWS CloudFormation is a significant plus.
The "Lead" Expectation
At the 10-year mark, we expect more than just "feature delivery." We are looking for a candidate who:
• Automates Everything: If a task is done twice, they write a script or a CI job for it.
• Designs for Failure: Implements proper error handling, retries, and health checks in the API layer.
• Collaborates Across the Stack: Can jump into a React component or a Postgres execution plan to find the root cause of a bottleneck.
