Note: The job is a remote job and is open to candidates in USA. PayNearMe provides a payment experience platform that helps businesses and their customers make and receive payments simply, quickly, and securely. The DataOps Engineer will implement, monitor, and maintain SQL databases, assist with infrastructure-as-code deployments, support database design best practices, and contribute to the development of the company’s next-generation data architecture.
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 on-going 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
- At least 3 years of cloud database design & implementation experience including:
- Proficiency with SQL database solutions including Aurora PostgreSQL, Aurora MySQL, and Snowflake
- Proficiency with SQL and writing performant queries; we use MySQL, PostgreSQL, and SnowSQL
- Proficiency with database IAC 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 independently researching and resolving incidents; we use AWS services such as RDS Database Insights and CloudWatch as well as Datadog
- Highly collaborative team player
- Strong programming experience, preferably in Python, or other object oriented language
- Build highly reliable systems
- Strong diagnostic skills
- Strong organizational and communication skills
- AWS Certification preferred
Benefits
- Competitive salary and benefits with growth-company options grant
- Stock options with standard startup vesting - 1 year cliff; 4 years total
- $50 monthly communication expense stipend to go towards your phone/internet bill
- $250 stipend to enhance your WFH setup
- Reimbursement for peripheral equipment: monitor (up to $400), keyboard and mouse (up to $200)
- Premium medical benefits including vision and dental (100% coverage for employees)
- Company-sponsored life and disability insurance
- Paid parental bonding leave
- Paid sick leave, jury duty, bereavement
- 401k plan
- Flexible Time Off (our team members typically take off ~3-4 weeks per year)
- Volunteer Time Off
- 13 scheduled holidays
Company Overview
Company H1B Sponsorship