Data Ops Engineer
What we do:
Recognized as one the Top 100 Tech Companies by Builtin.com and over 4.4-star review on Glassdoor, SambaSafety® is the pioneer of driver risk management software in North America. Trusted by over 2 million subscribed drivers; thousands of businesses look to Sambasafety to provide the most powerful, advanced, intuitive, and impactful risk solution platform on the market. SambaSafety is growing at an incredible rate with high employee engagement. It’s an exciting time to be at Samba. Now is the right time to join our high performing culture. We hope to see you here!
What we're looking for:
We are looking for a passionate Data Engineer to join our DevOps team to design, develop and maintain database solutions. The successful candidate will be able to construct and improve systems with data reliability, quality and accessibility with in the compliance requirements.
Essential Functions
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Work with DevOps team to maintain and improve health of database systems supporting a number of applications and systems.
- Manage database servers and services in an AWS cloud environment including EC2, RDS, Aurora etc. When necessary, develop tools and reports to monitor server health effectively.
- Support software development teams by ensuring database interactions are tuned to meet production demand.
- Assist in software deployment and versioning using best practices.
- Evaluate new database technologies and facilitate adoption decisions. Manage version upgrades, shifts to new technologies.
- Provide technical consulting in identifying, implementing and supporting new database functionality. Research and disseminate information to appropriate audiences.
- Collaborate with cross-functional, often remote teams including BI / analytics, software engineers, data architects, data scientists, product management, and IT
- Build ETL and/or ELT solutions to and from a variety of data sources including SQL, NoSQL, AWS ‘big data’ technologies and others using tools such as Nifi, SSIS, etc.
- Perform SQL tuning including query plan analysis, index analysis, locking, storage in Microsoft SQL Server, Postgres, Aurora, and other environments.
- Advanced understanding of SQL including TSQL, stored procedures, functions.
- Perform problem resolution and root cause analysis along with recommending and implementing preventive techniques.
- Coach and mentor the development, implementation and support team members on best practices for database technologies.
- Ability to write clear and complete documentation regarding database design and processes
What you'll need
- BS degree in Computer Science or Engineering
- Five years’ experience
- Relational SQL and NoSQL databases: Microsoft SQL Server, Postgres, Cassandra, MongoDB, etc.
- AWS cloud services: EC2, RDS, S3, Redshift, Aurora, SQS, Lambda, Fargate, Athena
- Monitoring tools: Solarwinds, Dynatrace, Cloudwatch etc
- Big data tools: Hadoop, Spark, Kafka, etc.
- Knowledge of Message and Stream-processing systems: RabbitMQ, Kafka Streams, Storm, Spark-Streaming, etc.
- Data pipeline and workflow management tools: NiFi, Azkaban, Luigi, Airflow, etc.
- Kinesis, Step Functions, DynamoDB, CloudFormation, etc.
- Graph databases: Neo4J, Neptune, GQL, etc.
- Exposure to Object-oriented/object function scripting languages: Python, Java, C++, Scala, etc is a plus