DataOps Engineer — Cloud DBs, Snowflake & AI-Driven Ops

Limelight Health; United States; Remote; USD 130,000 - 180,000; Full time

Benefits offered by this job

Stock options

Medical benefits (vision & dental)

401k plan

Flexible Time Off

Volunteer Time Off

Phone/internet stipend

Equipment reimbursement

Parental leave

Job summary

PayNearMe is seeking a DataOps Engineer to implement, monitor, and maintain SQL databases across AWS. You will help design data models, optimize queries, and apply infrastructure-as-code for deployments while supporting data governance and security standards.

You will collaborate with engineers to design scalable data architectures using Aurora MySQL/PostgreSQL and Snowflake, leveraging AI-powered automation for efficiency and cost awareness.

Qualifications

• At least 3 years of cloud database design and implementation experience including Aurora PostgreSQL, Aurora MySQL, and Snowflake.
• Proficiency with SQL and writing performant queries; we use MySQL, PostgreSQL, and SnowSQL.
• Proficiency with database infrastructure as code frameworks; we use Terraform/OpenTofu.
• Strong experience with relational database design and data modeling techniques.
• Familiarity with leveraging AI-powered tools and scripting for automation in areas like monitoring, alerting, or system maintenance.
• Experience with data security and data governance techniques.
• Experience monitoring database systems and incident resolution; AWS services such as RDS Database Insights and CloudWatch and Datadog.
• AWS Certification preferred.
• Highly collaborative team player.
• Strong programming experience, preferably in Python, or other object oriented language.

Responsibilities

• Assist senior engineers in the design of data models and schemas, and participate in code walk-throughs.
• Support performance tuning efforts on SQL queries regarding applications, storage, and network.
• Explore and utilize AI-powered tools and automation solutions to increase efficiency in DataOps workflows and reduce manual toil.
• Follow established processes for data quality, data governance, testing, and ongoing monitoring.
• Assist in the analysis of current systems and support the implementation of database designs to support our business applications.
• Adhere to established data models, modeling naming standards, abbreviations, guidelines, and best practices.
• Assist in translating logical data models and implementing physical database structures.
• Monitor data service costs and flag potential cost inefficiencies to senior team members.
• Maintain and update documentation for database architectures.

Skills

SQL

Python

AWS

Data modeling

Query performance

Automation

Data governance

Incident resolution

Communication

Tools

Terraform/OpenTofu

Datadog

RDS/CloudWatch

Snowflake

Aurora MySQL

Aurora PostgreSQL

Job description

PayNearMe is seeking a DataOps Engineer to implement, monitor, and maintain SQL databases across AWS. You will help design data models, optimize queries, and apply infrastructure-as-code for deployments while supporting data governance and security standards.

You will collaborate with engineers to design scalable data architectures using Aurora MySQL/PostgreSQL and Snowflake, leveraging AI-powered automation for efficiency and cost awareness.