Database Administrator (DBA)

CalAmp • Carlsbad, CA

82d • $91,006 - $156,010

About The Position

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.

Requirements

• 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)

Nice To Haves

• 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)

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Computer and Electronic Product Manufacturing
• Education Level: Bachelor's degree
• Number of Employees: 501-1,000 employees