Database Administrator Greatcall
San Diego, CA

Job Description

POSITION: Database Administrator

DEPARTMENT: IT Operations

REPORTING SUPERVISOR: Senior Manager, Systems Engineering

DIRECT REPORTS: No

FLSA: Exempt

EMPLOYMENT STATUS: Direct Hire

TRAVEL REQUIREMENTS: 10% Overnight Travel Required within the U.S.

SCHEDULE: Must be willing to work in-an on-call rotation and be flexible to work various shifts

ABOUT THE TEAM:

We are a dedicated and enthusiastic IT team, responsible for supporting the business by providing any infrastructure required to meet company wide goals. IT works closely with all departments at GreatCall to help deliver new products and services, both for our existing customers, as well as potential new markets. The Applications Operations team is responsible for deployment and support for all public facing and internal web applications and services.

ABOUT THE JOB:

The Database Administrator is responsible for all aspects of the operations, management, and maintenance of the Company's databases including, but not limited to: design, installation, security administration, proactive monitoring, support, troubleshooting, recoverability, and failover. The Database Administrator will partner with Software Developers & Architects to review new database implementation requests, provide feedback, and ultimately deploy and maintain these requests. In addition to supporting SQL Server databases, the Database Administration team is responsible for supporting other technologies including MongoDB, RavenDB, MySQL & PostgreSQL. This position will also create and own the database upgrade process within the SDLC. The ideal candidate will possess some experience working with Healthcare IT software platforms as well as possess knowledge/experience with HIPAA and HITRUST. Additionally, the Company continuously evaluates new database tools and technologies and the Database Administrator will participate in these evaluations and proof of concept projects.

RESPONSIBILITIES:

* Manage the overall performance, tuning, and backup/recovery of primarily MSSQL, MongoDB, RavenDB & PostgreSQL databases (on premise and cloud-based)
* Proactive maintenance of all database instances (upgrades, patches, DB growth, etc.)
* Establish and implement performance monitoring metrics for databases to monitor availability and capacity thresholds and trends
* Optimize database performance by writing custom scripts to automate various daily DBA operations
* Collaborate with software developers to generate code into the test/staging/production system and monitor code deployed for performance and reliability issues
* Implement data retention policies for operational data stores
* Design and implement redundant systems (HA), policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets to be tested on quarterly basis
* Other duties as assigned

QUALIFICATIONS:

Education: Bachelor's degree preferred or equivalent experience

Experience:

* Minimum 5 years' extensive experience in Microsoft SQL Server and demonstrated proficiency in stored procedures, triggers, functions, views and replication required
* Minimum 3 years' experience with MySQL and PostgreSQL required
* Minimum 3 years' experience in data warehousing or other data reporting tool experience with Windows Server 2008-2016, MS SQL Server 2012-2017 Administration, T-SQL Development required
* Minimum 3 years' experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools required
* Minimum 3 years' experience with backups, restores and recovery models to support High Availability (HA) and Disaster Recovery (DR) options for datastores required
* Minimum 3 years' experience in implementing operational automation using scripts required
* Prior experience with HIPAA compliance rules and operational knowledge of PHI and PII data required
* Prior experience in technical, database related roles with administrator experience in distributed systems and NoSQL databases, including and not limited to MongoDB, RavenDB, and Cassandra preferred
* Proficiency streaming technologies such as Kafka, Snowflake, and Spark preferred
* Prior experience with AWS tools and access preferred
* Prior experience configuring, supporting, and maintaining high-volume large database systems preferred

Knowledge/Skills/Abilities:

* SQL and relational DBMS knowledge, including data modeling and ERD
* Ability to work collaboratively to research, define, interpret, and analyze complex, unstructured technical database problems and recommend solutions, and implement them
* Ability to work with a team to provide written responses to technical proposals and /or reports/documentation for delivery.
* Ability to maintain composure
* Ability to learn quickly on the fly

Ability to manage conflicts

Personal Attributes:

* Time Management skills
* Coachable
* Problem solving skills
* Written & verbal communication skills
* Excellent professionalism and interpersonal skills