Database Developer / DBA Jobs in Liberty Lake, WA at Alarm.com
Title: Database Developer / DBA
Location: Liberty Lake, WA
Salary: $80K — $100K *
Category: Legal & Accounting
This position is responsible for the development and maintenance of the data backend infrastructure for the SaleGuard Loss Prevention application, OpenEye Web Services application and Apex Server application using a combination of technical proficiencies, organizational aptitude and interpersonal skills, as well as learning and progressing with the evolving technology. This position is also responsible for compiling data necessary to generate reports. Supports and adheres to the OpenEye Code of Ethics and Business Standards.
Job Duties and Responsibilities:
Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems.
Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
Maintains database performance by identifying and resolving production and application development problems by: calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
Provides database support by coding utilities, responding to user questions, and resolving problems.
Performs database maintenance activities such as backup/recovery, rebuilding and reorganizing indexes.
Provides technical expertise on the installation, setup, and configuration of database servers, clusters, replication infrastructure and SAN disk subsystems.
Administers and manages database, clustering and replication infrastructure (MS SQL Server, Crate.io) in development, QA, pre-production & production environments.
Assists in the development of software including feature additions, modifications, bug fixes and unit tests as needed. Works with Team Leader or Product Owner as issues arise.
Reviews development requests and makes educated decisions about the most efficient way to proceed.
Interfaces with various departments and customers to acquire information needed to successfully deliver software that meets customer needs.
Interfaces with various departments and customers to help solve support issues they are facing using the software.
Assists other developers as needed when they have questions about queries, database processes, database best practices, etc.
Effectively communicates tasks and ideas to fellow developers, management, various departments and customers.
Analyzes input requirements from various sources and determines the best way to meet each requirement.
Reviews software code written by others to determine if the code meets company, departmental and team standards.
a High School Diploma or a General Education Degree
3+ years of experience with MS SQL Server in a production environment
3+ years of experience with SSIS/SSRS/SSAS
3+ years of experience with database and ETL development
Experience in performance tuning, query optimization as well as using Performance Monitor, SQL Profiler and other monitoring and troubleshooting tools
Experience with Failover Cluster and Database Mirroring
Excellent understanding of query execution plans, Stored Procedures, query, index and DB I/O performance tuning
Ability to quickly learn new technologies and practices