Lead Database Engineer
Our company is in an enviable spot. We’re profitable, and both our bottom line and our global reach are growing rapidly. We’re playing in an exploding market where technology evolves daily and new IoT / M2M solutions and platforms are being created at a fast-pace.
Our development teams collectively have over 100+ patents, offering our employees access to some of the most brilliant minds in the industry, providing continuous growth opportunities– in an environment that values innovation, autonomy and integrity. A few things to know about us:
A few things to know about us:
- We put our customers first. When making decisions, we always seek to do what is right for our customer first, our company second, our teams third, and individual selves last.
- We do things differently. As a pioneer in a highly-competitive industry that is poised to reshape every sector of the global economy, we cannot fall back on old models. Rather, we must chart our own path and strive to out-innovate, out-learn, out-maneuver and out-pace the competition on the way.
- We walk the walk on diversity. We’re a brilliant and eclectic mix of ethnicities, religions, industry experiences, sexual orientations, generations and more – and that’s by design. We see diverse perspectives as a core competitive advantage.
- Integrity is essential. We believe in doing things well – and doing them right. Integrity is a core value here: you’ll see it embodied in our staff, our management approach and growing social impact work (we have a VP devoted to it). You’ll also see it embodied in the way we manage people and our HR issues: we expect employees and managers to deal with issues directly, immediately and with the utmost respect for each other and for the Company.
- We are owners. Strong managers enable and empower their teams to figure out how to solve problems. You will be no exception, and will have the ownership, accountability and autonomy needed to be truly creative.
Be a part of a team of innovators in the IoT and M2M space and a company that is profitable and growing rapidly. We’re looking for strategic and visionary leaders. This is an ideal opportunity for an individual who is eager to roll up their sleeves and to make measurable contributions in shaping the future of IoT. So this is where you come in!
Aeris is looking for a Lead Database Engineer with strong SQL and Engineering background. You will be responsible for designing, building, managing and supporting highly available enterprise production databases, implementing feature driven database and stored procedure changes, and debugging production issues. You will work under minimal supervision to produce software, test plans, documentation and like engineering deliverables. You will also have an opportunity to learn about next-generation cutting edge technologies, including the opportunity to work on big data.
Roles and Responsibilities:
- Drive the design and implementation of new versions of Oracle and NoSQL databases and tools including; Oracle 9i and 11g RAC
- Keep current with related technologies like Cassandra, Mongo, and other NoSQL platforms, releases, and dot releases for potential use on Aeris’ platforms
- Develop and support features requirements especially as they impact large-scale production databases
- Support would include peer review of web services and portal code accessing, displaying and altering database contents
- Develop and maintain data modeling diagrams for Aeris enterprise database stack
- Diagnose and correct data integrity issues by authoring SQL scripts, triggers, and stored procedures
- Automate DBA and system operations, DB performance analysis, and application level performance monitoring/alerting of large size databases up to 5TB
- Ensure that all periodic data management tasks are completed, including automation, monitoring, and coordination with offshore engineers
- Recommend, develop, and execute modifications to database infrastructure and system performance in order to improve efficiency, reliability, and performance
- Serve as subject matter expert for review, design, and execution of database updates by engineering peers
- Train and mentor peer or junior engineers
- Collaborate with business to define business requirements for complex systems and infrastructure development
- Ensure adherence to corporate policies and standards to meet compliance, availability and disaster recovery, act as an escalation point for project team members to provide issue resolution
The Successful Applicant will have:
- Bachelors in Computer Science or Electrical Engineering
- Minimum of 3 years of hands-on experience in Oracle (9i and 11g) and MySQL
- Experience in MongoDB, Cassandra or Hadoop is a plus or strong desire to learn and work with these technologies
- Expertise in PL/SQL
- Strong experience with Unix/Linux, in scripting languages such as Shell/Perl/Python/Expect and SQL
- Proven analytical, evaluative, prioritization and problem-solving abilities with the ability to execute tasks in a high-pressure environment
- Excellent written, oral, and interpersonal skills required to engage offshore resources via conference calls and daily tasks hand-offs
- Highly self-motivated and self-directed, with keen attention to detail
- Understanding of AWS environment (or like cloud service) a plus
- Nice to have a basic understanding of Java and the desire to learn Java and gain some hands-on experience
Aeris walks the walk on diversity. We’re a brilliant mix of varying ethnicities, religions, cultures, sexual orientations, gender identities, ages and professional/personal/military experiences – and that’s by design. Diverse perspectives are essential to our culture, innovative process and competitive edge. Aeris is proud to be an equal opportunity employer.