Sr. Database Engineer

US-CA-Irvine
Job ID
2017-2103
# of Openings
1
Category
Engineering

Overview

Based in beautiful Irvine, we are CalAmp, the pure-play pioneering leader of the Connected Car, Connected Truck and broader Internet of Things (IoT) marketplace. Currently, we are seeking a Sr. DBA with at least 6 years of experience. This is an exciting opportunity for those who wish to work for a stable, well-established company that builds transformational technologies within the revolutionary domain of IoT.

 

We believe that people are our greatest asset and we are committed to being an employer of choice in our industry. CalAmp offers an engaging and diverse work environment that permits our people to take pride in their contributions and share in the company’s success. Our employees can expect the space to showcase their talent, sharpen their skills, develop new capabilities, and be a part of a global team that develops revolutionary technologies. We proudly offer the stability and security of a large publicly-traded tech company without the rigidity and red tape.

In particular, we offer:

  • Meaningful work with the potential to disrupt an entire industry
  • Visionary leadership
  • Excellent compensation packages
  • An extensive suite of medical and retirement benefits
  • Flexible time off policy and accommodating work schedules
  • Education Assistance Program (Tuition Reimbursement)
  • Access to cutting-edge tools and technologies
  • Innovative, intelligent, collaborative teammates

Responsibilities

  • Responsible for delivering highly available heterogeneous database servers on multiple technology platforms.
  • Lead all database maintenance and tuning activities, ensuring continued availability, performance and capacity of all database services across every business application and system.
  • Is expected to consider current practices to develop innovative and reliable solutions that will continuously improve the service quality to the business.
  • Create/Update/Maintain data warehouse for business/product reporting needs.
  • Refine physical database design to meet system performance requirements.
  • Identify inefficiencies in current databases and investigate solutions.
  • Diagnose and resolve database access and performance issues.
  • Develop, implement, and maintain change control and testing processes for modifications to databases.
  • Ensure all database systems meet business and performance requirements.
  • Coordinate and work with other technical staff to develop relational databases and data warehouses.
  • Advocates and implements standards, best practices, technical troubleshooting processes, and quality assurance
  • Develop and maintain database documentation, including data standards, procedures, and definitions for the data dictionary.
  • Produce ad-hoc queries and develop reports to support business needs.
  • Creation and maintenance of technical documentation.
  • Perform other management assigned tasks as required.

Qualifications

Must Haves

  • Bachelors or Masters degree in Computer Science, Mathematics or other STEM discipline
  • 6+ years of experience in working with relational databases. (Redshift, PostgreSQL, Oracle, MySQL).
  • 2+ years of experience with NoSQL database solutions (MongoDB, DynamoDB, Hadoop/HBase etc.)
  • 5+ years of experience with ETL/ELT tools (e.g. Talend/ Informatica, AWS Data Pipeline. Preferably on Talend.)
  • Strong Knowledge on Data warehousing Basics and relational database management Systems and Dimensional modelling (Star schema and Snowflake schema).
  • Configuration of ETL ecosystems and perform regular data maintenance activities such as data loads, data fixes, schema updates, database copies, etc.
  • Working experience with cloud computing technologies AWS EC2, RDS, Data Migration Service (DMS), Schema Conversion Tool (SCT), AWS Glue.
  • Experience in migrating, automating and supporting a variety of AWS hosted (Both RDBMS & NoSQL) databases in RDS, EC2 using CFT.
  • Well versed in advanced query development and design using SQL, PL/SQL, Query Optimization, performance and tuning of applications on various databases.
  • Supporting multiple DBMS platforms in Production/QA/UAT/DEV in both on premise and AWS cloud environments.
  • Experience with OLTP, data warehousing and operational data stores and concepts.
  • Experienced in data cleansing, enterprise data architecting, data quality and data governance is a must
  • Experience with Database partitioning Strategies on various databases (PostgreSQL, Oracle)
  • Good understanding of Redshift Database design using distribution style, sorting, encoding features.
  • Experience with Big Data Technology Stack:  Hadoop/Spark/Hive/MapR/Storm/Pig/Oozie/Kafka, etc.
  • Experience with shell scripting for process automation.
  • Experience with source code versioning with Git and Stash.
  • Ability to work across multiple projects simultaneously.

Strong Pluses

  • Strong experience in all aspects of the software lifecycle including design, testing, and delivery
  • Ability to understand and start projects quickly
  • Ability and willingness to work with teams located in multiple time zones

 

If you are a talented Sr. DBA with at least 6 years of experience and an interest in the Internet of Things domain, we want to speak with you. Interviews are occurring this week and next so apply now if interested.

 

#L1-RB1

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed