Database Administrator Or Database Engineer
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 experienceProficiency with MS SQL Server, PostgreSQLExperience with cloud-based environments / databases (AWS, Azure, etc.)Experience with database performance tuning (including SQL and query tuning)Excellent SQL skillsProficient in managing and creating ETL jobsProficiency in both Linux and Windows environmentsDatabase server, storage & network systems lifecycle administrationDatabase clustering architecture & administrationScripting alerts and controls for DB system monitoring agentsSolid understanding of the Software Development Lifecycle (SDLC)Ability to provide high confidence estimate for design change or solution implementationExcellent written and oral communication skillsTechnical Bachelor's degree (Information Systems, Computer Science, or similar)Strong Pluses
MongoDBExperience with Amazon RDS implementation and supportScripting using Python, Perl, etc.Linux systems implementation (RedHat, CentOS, Ubuntu, SUSE)Experience with Distributed and High-availability (HA) DB systems, networking concepts & protocolsExperience in a business operation requiring high-volume, high-availability information processingTechnical Certifications (AWS, Mongo, PostgreSQL)Experience with 3rd party reporting toolsExperience 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.