What are the responsibilities and job description for the Database Administrator (DBA) position at CalAmp?
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.Salary : $91,006 - $156,010