Prometheus Query Syntax Jobs in Usa

Job Description

NoSQL DBA with Mongo DB, Casandra, Couchbase, Elastic Search

We are seeking an experienced Database Engineer with strong expertise in MongoDB and working knowledge of additional NoSQL technologies including Elasticsearch, Cassandra, and Couchbase. The ideal candidate will be responsible for designing, implementing, and maintaining high-performance database solutions that support our enterprise applications and data infrastructure.

Primary Skills (MongoDB):

• 5+ years of hands-on experience with MongoDB in production environments

• Expert-level knowledge of MongoDB architecture, replication, and sharding

• Proven experience with MongoDB performance tuning and optimization

• Strong understanding of MongoDB Atlas and cloud-based deployments

• Proficiency in MongoDB query optimization and index design

• Experience with MongoDB backup, recovery, and disaster recovery strategies

• Knowledge of MongoDB security best practices and implementation

• Familiarity with MongoDB aggregation framework and data modeling

Secondary Skills (Nice to Have):

• 2+ years of experience with Elasticsearch for search and analytics

• Working knowledge of Cassandra for distributed database management

• Familiarity with Couchbase for caching and document storage

• Understanding of NoSQL database selection criteria and trade-offs

Technical Requirements:

• 7+ years of overall database administration and engineering experience

• Strong proficiency in scripting languages (Python, Bash, JavaScript)

• Experience with database monitoring tools and APM solutions

• Knowledge of Linux/Unix systems administration

• Understanding of containerization technologies (Docker, Kubernetes)

• Experience with CI/CD pipelines and infrastructure as code

• Familiarity with cloud platforms (AWS, Azure, or GCP)

KEY RESPONSIBILITIES

MongoDB Database Management:

• Design and implement MongoDB database architectures for scalability and high availability

• Perform capacity planning and resource optimization for MongoDB clusters

• Configure and maintain replica sets and sharded clusters

• Develop and enforce MongoDB coding standards and best practices

• Monitor database performance and implement tuning strategies

• Manage database security, including authentication, authorization, and encryption

• Execute backup and recovery procedures ensuring data integrity

• Troubleshoot complex database issues and performance bottlenecks

Multi-Database Support:

• Assist with Elasticsearch cluster configuration and index management

• Support Cassandra deployments for high-throughput workloads

• Provide guidance on Couchbase implementation for caching solutions

• Evaluate and recommend appropriate NoSQL solutions based on use cases

• Maintain documentation for all database platforms

Collaboration & Development:

• Work closely with development teams on database design and optimization

• Review database schemas and queries for performance improvements

• Participate in code reviews focusing on database interactions

• Provide technical guidance and mentorship to junior team members

Operations & Maintenance:

• Implement monitoring and alerting solutions for database health

• Perform regular maintenance tasks including patching and upgrades

• Develop disaster recovery plans and conduct failover testing

• Maintain database documentation and runbooks

• Participate in on-call rotation for production support

PREFERRED QUALIFICATIONS

• MongoDB Certified DBA or Developer certification

• Experience with data migration projects across different database platforms

• Knowledge of data modeling for both relational and NoSQL databases

• Understanding of microservices architecture

• Contributions to open-source database projects

Visa Status: US Citizen or Green Card Only

Location: Irving, TX (Local Candidates Only)

Employment Type: Full-time / Direct Hire

Work Environment: Hybrid (Monday thru Thursday - in office / Friday - at home)

***MUST HAVE 10+ YEARS EXPERIENCE AS A DATA ENGINEER***

***US Citizen or Green Card Only***

The AWS Senior Data Engineer will own the planning, design, and implementation of data structures for this leading Hospitality Corporation in their AWS environment. This role will be responsible for incorporating all internal and external data sources into a robust, scalable, and comprehensive data model within AWS to support business intelligence and analytics needs throughout the company.

Responsibilities:

• Collaborate with cross-functional teams to understand and define business intelligence needs and translate them into data modeling solutions
• Develops, builds and maintains scalable data pipelines, data schema design, and dimensional data modelling in Databricks and AWS for all system data sources, API integrations, and bespoke data ingestion files from external sources. Includes Batch and real-time pipelines.
• Responsible for data cleansing, standardization, and quality control
• Create data models that will support comprehensive data insights, business intelligence tools, and other data science initiatives
• Create data models and ETL procedures with traceability, data lineage and source control
• Design and implement data integration and data quality framework
• Implement data monitoring best practices with trigger based alerts for data processing KPIs and anomalies
• Investigate and remediate data problems, performing and documenting thorough and complete root cause analyses. Make recommendation for mitigation and prevention of future issues.
• Work with Business and IT to assess efficacy of all legacy data sources, making recommendations for migration, anonymization, archival and/or destruction.
• Continually seek to optimize performance through database indexing, query optimization, stored procedures, etc.
• Ensure compliance with data governance and data security requirements, including data life cycle management, purge and traceability.
• Create and manage documentation and change control mechanisms for all technical design, implementations and systems maintenance.

Target Skills and Experience

• Bachelor's or graduate degree in computer science, information systems or related field preferred, or similar combination of education and experience
• At least 10 years' experience designing and managing data pipelines, schema modeling, and data processing systems.
• Experience with Databricks a plus (or similar tools like Microsoft Fabric, Snowflake, etc.) to drive scalable data solutions.
• Experience with SAP a plus
• Proficient in Python, with a track record of solving real-world data challenges.
• Advanced SQL skills, including experience with database design, query optimization, and stored procedures.
• Experience with Terraform or other infrastructure-as-code tools is a plus.

We're Hiring: Ivalua Techno-Functional Lead Consultant

Location: Sunnyvale, CA (Onsite – 3 days/week)

We are looking for an experienced Ivalua Techno-Functional Lead Consultant with strong expertise in procurement systems, SQL, and integrations. The ideal candidate will have deep hands-on experience working with the Ivalua platform, supporting procurement processes, and collaborating with cross-functional teams to deliver scalable solutions.

This role requires a strong understanding of sourcing and procurement workflows, technical integration capabilities, and the ability to work closely with stakeholders and third-party solution providers.

Key Responsibilities

• Lead and support Ivalua implementation, configuration, and enhancement projects.
• Write and optimize SQL queries to generate reports, retrieve data, and support integrations.
• Build and support API integrations and EAI connections with other enterprise applications.
• Configure Ivalua modules, including workflows, callbacks, and solution design.
• Provide production support, including troubleshooting priority bugs and fixes.
• Work with stakeholders to improve sourcing and procurement processes.
• Participate in project release processes and system improvements.
• Maintain strong collaboration with clients and third-party solution providers.

Required Skills & Experience

• 8+ years of hands-on experience with Ivalua in a project role within industry or consulting.
• L2 (preferred) or L3 certification in any of the following areas from Ivalua: P2P, INT, or SQL.
• Strong experience working with SQL queries to build reports, retrieve data, and support integrations.
• Deep understanding of Ivalua solutions and API development.
• Strong knowledge of sourcing and procurement processes and their business value drivers.
• Experience with configuration modules including design, workflows, and callback creation.
• Experience supporting production issues, priority bugs, and fixes.
• Knowledge of project release processes.
• Excellent analytical, problem-solving, and communication skills.
• Experience building strong client relationships and collaborating with third-party solution providers.

Job Description

Working on day-to-day Snowflake Admin activities like, Storage Integration (AWS & GCP buckets), Integration setup (Notification, API & Email)

Setup of Inbound & Outbound Data shares as per the project requirements.

IP Allow listing as per the Project requirements, after review/approval of Platform Manager.

New Application Onboarding guidance and provide in-depth knowledge around the costing & billing aspects as per the standards.

Analyzing the Snowflake Warehouse Usage and provide best recommendations as per the trend and cost optimization.

Providing guidance around the usage of Cloud Toolkit API's and reading the secrets and manage the passwords in Keeper Vault Services.

Configure and optimize Snowflake accounts, virtual warehouses, databases, schemas, and user roles.

Monitor platform performance and ensure optimal configuration and scaling of compute resources.

Implement and manage data security measures including role-based access control, data encryption, and user authentication.

Monitor query performance and optimize SQL queries for better efficiency, Analyze and resolve performance bottlenecks and resource contention issues, Utilize Snowflake's advanced features such as clustering keys, materialized views, and result caching to enhance performance.

Implement backup and recovery strategies to ensure data durability and availability, Manage data archiving, replication, and failover processes.

Develop and maintain scripts for automating administrative tasks and workflows, Utilize tools and frameworks for continuous integration and deployment (CI/CD).

Provide technical support and troubleshooting for Snowflake-related issues, collaborate with Snowflake support to resolve platform-specific issues

Knowledge in any RDBMS database like Teradata or Oracle

Knowledge of programming languages such as Python or JavaScript.

Experience with data visualization tools (e.g., Tableau, Power BI).

24*7 support model experience

Salary Range: $64,000 - $125,000 a year

#LI-CM2

Role: AWS Cloud Engineer

Location: San Antonio, TX (On-Site)

• Identify and select the data sources, Tables, Relationships between different entities in Snowflake.

• Establish a secure connection between Snowflake and AWS Neptune via AWS service stack by securing extracted data storing in S3 for transformation before loading into AWS Neptune.

• Collaborate with current platform team to understanding data structure to implement data extraction processes from Snowflake.

• Load the extracted data into AWS S3 for graph model transformation.

• Analyze the data, relationships, entities mappings to determine the necessary graph schema.

• Design nodes, edges, and properties for the graph schema using entities definitions.

• Implement the graph schema in AWS Neptune.

• Creating indexes to improve query performance

• Review and refine schema based on query patterns and performance based on mutually agreed design

• Define the transformation logic using DBT.

• Develop DBT models for data transformation.

• Schedule and automate the ELT pipeline using DBT and Snowflake.

Sr. Data Engineer (PySpark & Python + AI Tools Exp.) - (Only W2 or 1099)

Charlotte, NC (Hybrid)

12+ Months Contract

Job Description:

We are currently seeking a Senior Data Engineer with hands-on coding experience and a strong background in Python, PySpark, and Object-oriented programming.

The ideal candidate will be responsible for designing, developing, and implementing new features to our existing framework using PySpark and Python.

This position requires a deep understanding of data transformation and the ability to create standalone scripts based on given business logic. Also, exposure to AI Tools and building any AI applications will be advantage.

Key Responsibilities:

• Design, develop, and optimize large-scale data pipelines using PySpark and Python.
• Implement and adhere to best practices in object-oriented programming to build reusable, maintainable code.
• Write advanced SQL queries for data extraction, transformation, and loading (ETL).
• Collaborate closely with data scientists, analysts, and stakeholders to gather requirements and translate them into technical solutions.
• Troubleshoot data-related issues and resolve them in a timely and accurate manner.
• Leverage AWS cloud services (e.g., S3, EMR, Lambda, Glue) to build and manage cloud-native data workflows (preferred).
• Participate in code reviews, data quality checks, and performance tuning of data jobs.

Required Skills & Qualifications:

• 6+ years of relevant experience in a data engineering or backend development role.
• Strong hands-on experience with PySpark and Python, especially in designing and implementing scalable data transformations.
• Solid understanding of Object-Oriented Programming (OOP) principles and design patterns.
• Proficient in SQL, with the ability to write complex queries and optimize performance.
• Strong problem-solving skills and the ability to troubleshoot complex data issues independently.
• Excellent communication and collaboration skills.
• Hands-on experience with AI Tools.

Preferred Qualifications (Nice to Have):

• Experience working with AWS cloud ecosystem (S3, Glue, EMR, Redshift, Lambda, etc.).
• Exposure to data warehousing concepts, distributed computing, and performance tuning.
• Familiarity with version control systems (e.g., Git), CI/CD pipelines, and Agile methodologies.
• Exposure to AI Tools and hands-on experience of building any AI applications.

Position Title: Manual Tester [API / SQL]

Location: Mountain View, CA (Hybrid 3 days)

Duration: 6 Months contract to hire

Interview - 2 rounds [1st Video and 2nd In-Person]

Please find complete job description below:

• 8+ hands-on years of manual testing and test automation experience (nice to have).
• Need Manual and Automation exp, candidates should be willing to start with manual testing and gradually move to automation.
• Good experience in API Testing.
• Need selenium or web driver exp.
• Solid exp is SQL queries (Advance to expert level).
• Good expertise in complex SQL queries.
• Oracle and Postgres databases.
• Nice to have experience in AWS/Azure/GCP.
• Demonstrated experience with WebDriverIO or any Selenium test frameworks or similar open-source automation framework.
• Solid understanding and experience of writing locators in selenium.
• Cucumber, Mocha, or similar BDD test scripts development experience.

Additional Preferred Skills:

• Experience with Mobile testing tools in Appium, XCUI Test, Espresso
• Experience with Docker, Kubernetes, Tomcat, Weblogic

Job Title: Store Manager

Reporting to: Head of Retail

Location: Buckhead Avenue, Atlanta, Georgia, 30305

Contract Type: Full time, 40 hours per week

About the Company:

ME+EM London is one of the UK's fastest-growing modern luxury fashion labels. As well as a successful global digital business, we have stores in London and Edinburgh, concessions in Harrods and Selfridges, and recently opened US stores in Manhattan, SoHo, East Hampton, Dallas, Greenwich & LA

At ME+EM we are an entrepreneurial, creative, and passionate group of people. We work hard, are enthusiastic to learn and are not afraid to take risks. Everyone contributes to our success at all levels, and that precisely what makes being a member of the team so rewarding.

Our office and stores are always busy and fast paced, but we work just as hard to make sure it's fun, with social activities and biannual parties. We pride ourselves on being approachable, supportive, and welcoming and ensure that everyone's hard work is rewarded. It takes all these things to build a strong, successful business and our door is always open to new talent ready to contribute to our growth and evolution.

About the Role:

The ME+EM Store Manager is an entrepreneurial lover of clothes, who is dedicated to customer service, team morale and driving results. Responsible for overseeing the overall operations of the store, managing team performance and leading by example. Your focus is that all store aspects, from inventory management to visual merchandising, from store reporting to finance management, are running smoothly. You have a keen understanding of the brand vision and stay up to date on industry trends. You understand the role of retail in our omnichannel business while representing the brand ethos.

Responsibilities:

Leadership

• Understand the store target and relay this to the team. Explain how company bonus works.
• Work toward set objectives and feedback regularly to the Head of Retail and MT to ensure their store always has the best chance to achieve optimum results.
• Manage staff uniform and dress code policy.
• Encourage dress code compliance following the policy.
• Display and ensure high level of telephone etiquette when using the store phone and able to train others to the same standard.
• Ensure a professional tone is used when using company email addresses.
• Coordinate and monitor the activities of the team.
• Lead by example, creating a professional, fair and inclusive working environment.
• Ensure the protection of confidential information to build trust.
• Create a culture of coaching and feedback.

People Management

• Be the first point of call for all people related issues within your store and loop in the Senior People Advisor and Head of Retail for regular support.
• Carry out the first stage interviews with the support of the Talent Acquisition Specialist, and ensure the candidate meet with the Head of Retail for the final stage of the recruitment process.
• Carryout instore onboarding sessions, setting expectations for the first 3 months and welcoming your new starter to the store.
• Ensure the new starter attends the HR onboarding session.
• Carryout regular feedback meetings: 3-month probation reviews, annual appraisals and performance meetings, seeking support from the Senior People Advisor if there is performance issues.
• Create monthly rota effectively to cover both logistics, VM and trading hours.
• Manage staff admin including hours worked against what is recorded in Humanity, ensure regular breaks are taken and casual contractor invoices are correct and submitted in time for payroll.
• Manage staff admin in regard to sickness monitoring, return to work interviews and providing additional and individual support and guidance.
• Keep up to date with company policies and ensure the team are trained in all areas of compliance with the support of the Compliance and Training Coordinator.
• Identify training needs and arrange store training sessions to fill the gaps with the Compliance and Training Coordinator, Senior People Advisor and Head of Retail or any external resources.
• Delegate tasks in an appropriate manner and follow up their execution.
• Follow company procedures to report any maintenance issues in store promptly.

Customer

• Be confident in building organic and long-lasting relationships with customers.
• Carryout personal styling sessions with confidence.
• Be aware of the importance of CRM and explain this to the team.
• Promote where possible the omni channel experience.
• Confidently offer solutions to customer queries and complaints following the standards set by the Company. Escalate serious complaints and queries to the Head of Retail and the Customer Care Team.

Product

• Ensure high level of product knowledge which can inform merchandising actions, stock movement and replenishment for their location.
• Ensure the store display represents the design intent for each garment with the support of the VM Manager.
• Daily stock accuracy and stock room management. Ensure the protection and use of stock is in the best interests of the business.
• Some locations will have the additional support of a stockroom controller.
• Lead the store recall process and monitor, question and be accountable for the accuracy of stock.

System

• Adapts easily to system changes and leads these in a positive manner to the store teams.
• Work alongside the Customer Care team and other operational functions to ensure policies and procedures are aligned to ensure the best customer experience is achieved.
• Understand Elucid and continually strive to develop the system and suggest improvements to IT and operations.

Benefits:

• 401(k)
• Dental insurance
• Employee discount
• Flexible schedule
• Health insurance
• Paid time off
• Vision insurance

ME+EM is an equal opportunities employer committed to fostering and preserving a culture of diversity, equality, and inclusion in our workforce. As an equal opportunities' employer, we do not discriminate against applicants based on race, colour, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. We believe that diversity enriches our workforce and strengthens our organisation. Therefore, we encourage minorities, LGBTQ+ candidates, and individuals with disabilities to apply for opportunities within our company.

Please note, due to the large number of applications we receive, we can only reply to those that are successful to the next stage.

Job title: QAD Techno functional Consultant

Pre-Screening Questionnaire:

QAD EE Implementation experience?

Experience in PROGRESS 4GL/Open Edge?

Experience in QAD EE with distribution, shipping, manufacturing, costing and finance

Experience in integration with multiple ERP

Must Have Technical/Functional Skills:

Should have strong domain knowledge in distribution, manufacturing, shipping and finance area with QAD EE

Required have strong experience in manufacturing and shipping.

Shall have strong knowledge on discrete orders, schedule orders, EDI, MRP, RSS, MSW/PSW and Costing, including Requirement gathering, Solution Design and Configurations, integration, end to end functional testing.

Should have hands on experience in Qxtend and QAD cloud, 3PL

Proven experience conducting analysis sessions to understand the functional and technical needs of project requirements and document.

Interact with remote/offshore developer to pass on the requirement, make them understand the functional flow, assist with any queries and ensure development is done within time and quality

Understanding of how QAD customization works

Must have strong knowledge on PROGRESS 4GL/Open Edge

Shall be able to write queries to resolve issues

Experience in integration through Mulesoft would be added advantage

Experience in integration with multiple ERP

• Gather, analyze, and translate business requirements into detailed technical specifications
  
  
• Conduct stakeholder interviews to define scope, timelines, and deliverables
  
  
• Ensure solutions align with budgets, project deadlines, and business objectives
  
  

• Assist with system design, development, deployment, and ongoing support
  
  
• Collaborate with programmers and developers throughout the SDLC
  
  
• Support infrastructure improvements to enhance scalability and integration
  
  

• Manage projects from concept through implementation
  
  
• Interface with internal clients to define scope and deliver results
  
  
• Mentor and review work of other Business Systems Analysts
  
  

• Develop and execute detailed test plans
  
  
• Create and maintain process documentation and workflows
  
  
• Review and edit technical documentation across IT teams
  
  
• Track product updates to ensure documentation stays current
  
  

• Establish standards for IT documentation, forms, and workflows
  
  
• Create scalable processes that ensure operational consistency
  
  

• High school diploma or GED
  
  
• 10+ years of related experience OR equivalent combination of education and experience
  
  
• Strong analytical and problem-solving skills
  
  
• Ability to communicate complex technical concepts to non-technical audiences
  
  
• Experience supporting application development and system implementation
  
  

• Bachelor’s degree in Computer Science, Business Information Systems, or related field
  
  
• Experience with billing, collections, or revenue cycle systems
  
  
• Healthcare industry experience
  
  
• Working knowledge of SQL and ability to write basic queries
  
  
• Experience with legacy systems or Query tools
  
  

• Microsoft Office (Outlook, Word, Excel)
  
  
• Email and internet-based research tools
  
  
• General office and remote work technology
  
  

• Strong written and verbal communication
  
  
• High attention to detail
  
  
• Ability to manage multiple priorities
  
  
• Self-starter with excellent organizational skills
  
  
• Ability to work independently and collaboratively
  
  
• Discretion when handling confidential information
  
  

• Remote flexibility
  
  
• Competitive salary + bonus potential
  
  
• Growth-oriented IT environment
  
  
• Collaborative, supportive culture
  
  
• Meaningful work supporting essential services nationwide