Database Administrator (DBA)

We are CalAmp, a connected intelligence company that gives people the ability to track, monitor and recover their vital assets with real-time visibility and insights.

Currently, we are seeking a Database Administrator or Database Engineer with at least 6 years of experience, based in Carlsbad CA. This is an exciting opportunity for those who align with our core values (Inclusion, Innovation, Execution, Customer Success) and for those who desire to build, sell, and/or support connected solutions and services

Responsibilities

Database administration and maintenance of our primary databases (MS SQL Server, PostgreSQL)

Management of our legacy databases (MySQL)

Manage both AWS RDS DBs or databases running on AWS EC2s

Performance tuning of MS SQL database and best practice implementation on all databases

Develop backup procedures for daily execution by IT/DevOps

Conduct "Health check" of the database regularly

Troubleshoot and support existing database processes; deliver fixes and optimizations where appropriate

Analyze, tune and document schema and queries

Monitor for database exceptions

Manage any database schema evolutions required

Develop archiving scripts to prune live data

Develop ETL environment for data mining

Architect, design, configure and deploy next generation of the database system

Review and manage AWS RDS spend

Qualifications

Must Haves

6 years of Database Administration and/or Engineering experience

Proficiency with MS SQL Server, PostgreSQL

Experience with cloud-based environments/databases (AWS, Azure, etc.)

Experience with database performance tuning (including SQL and query tuning)

Excellent SQL skills

Proficient in managing and creating ETL jobs

Proficiency in both Linux and Windows environments

Database server, storage & network systems lifecycle administration

Database clustering architecture & administration

Scripting alerts and controls for DB system monitoring agents

Solid understanding of the Software Development Lifecycle (SDLC)

Ability to provide high confidence estimate for design change or solution implementation

Excellent written and oral communication skills

Technical Bachelor's degree (Information Systems, Computer Science, or similar)

Strong Pluses

MongoDB

Experience with Amazon RDS implementation and support

Scripting using Python, Perl, etc.

Linux systems implementation (RedHat, CentOS, Ubuntu, SUSE)

Experience with Distributed and High-availability (HA) DB systems, networking concepts & protocols

Experience in a business operation requiring high-volume, high-availability information processing

Technical Certifications (AWS, Mongo, PostgreSQL)

Experience with 3rd party reporting tools

Experience with 3rd or Cloud based monitoring and APM tools (Datadog, Dynatrace)

If you are a talented Database Administrator with expertise in MS SQL Server, PostgreSQL, Cloud Based Computing and an interest in the Internet of Things (IoT) domain, we want to speak with you. Interviews are occurring this week and next so apply now if interested.

Please note: Applicants must be legally authorized to work in the U.S. on a permanent basis. We are unable to provide sponsorship at this time.

Market Minimum

USD $91,006.00/Yr.

Market Maximum

USD $156,010.00/Yr.

Regular Full-Time