Database Administrator (DBA) at CalAmp

Carlsbad, California, United States -

Full Time

Start Date

Immediate

Expiry Date

15 Apr, 26

Salary

156010.0

Posted On

15 Jan, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Administration, MS SQL Server, PostgreSQL, AWS, ETL, Performance Tuning, SQL, Linux, Windows, Database Clustering, Scripting, Software Development Lifecycle, MongoDB, Python, High-availability, Reporting Tools

Industry

Software Development

Description

Overview 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.

Responsibilities

The Database Administrator will be responsible for the administration and maintenance of primary databases, including performance tuning and troubleshooting existing database processes. They will also manage legacy databases and develop backup procedures and archiving scripts.