Job Id : 4277
Jobtitle : Database Administrator
Location : Denver , CO
Company Name : Welltok
Industry : Information Technology
Salary : $75,000 - $120,000 YEAR
Job type : Fulltime
Posted on: 2019-08-20
Required Skills : Excellent Communication And Documentation Skills
Benefits : No benefits are available
Manage and maintain Welltok data management systems to encompass design, installation, deployment, replication, backup, restoration, optimization, security, and data exchange. Systems include ETL, operational data stores (relational and non-relational), data warehouse, and reporting.
Manage administration and database performance by tuning file structures and managing indexes.
Partner with software architects and engineers on data access methods and decisions on optimal data structures for persistence.
Safeguard data integrity and maintain security controls in all existing databases and data exchange technology through process, training, quality control, and monitoring.
Write simple to complex SQL queries, troubleshoot queries, and tune queries for best performance.
Design and implement processes to automate transactional information functions to optimize operational efficiency throughout the organization.
Develop logical and physical architecture models.
Manage data operations for data at rest, data exchange, batch processing, and data reporting.
Support development and production activities.
Generate and maintain documentation of data store architectures, configurations, operations, and maintenance.
Required Knowledge & Skills :
3+ years of database server administration experience in Microsoft SQL Server 2014 or later and intermediate knowledge of at least one of the following: MySQL/MariaDB, PostgreSQL, Cassandra
Thorough understanding of relational database technology and concepts, T-SQL/PLSQL scripting, database normalization best practices
SQL Server Management Studio (SSMS) and PowerShell
Strong experience in monitoring, backup/restore, performance tuning, query optimization, Performance Monitor, SQL Profiler, and other monitoring and troubleshooting tools
Exposure to "NoSQL" data stores, data warehouse, and web service data exchange
Practical experience in monitoring and configuring database servers for high availability using solutions like MSSQL clustering, Always On, database mirroring, and replication technologies
Experience with SQL, stored procedures, data batch processing, and data as a service
Practical experience in managing internal and external database security
Critical thinking skills to resolve problems and present solutions
In-depth expertise in automation for data operations
Excellent communication and documentation skills
Ability to triage issues, react well to changes, work with teams, and self-manage time and effort across multiple projects
Experience with cloud-based data services (especially AWS) preferred
Previous experience in healthcare or other highly-regulated industry is desirable.
Experience with SSIS/SSRS/SSAS is helpful
Welltok is looking for an experienced Database Administrator who will be responsible for the day to day operation of Welltok's data stores. The Database Administrator performs system check, replication, backup, recovery, and load analysis. They will troubleshoot systems with other operations functions and application developers when required.
Welltok is a data-driven, enterprise SaaS company that delivers the healthcare industry's leading consumer activation platform. Welltok's solutions empower leading health plans, employers, providers and public entities to connect consumers with personalized health improvement resources, making it easy and rewarding for consumers to complete actions that optimize their health and wellbeing.
Welltok was named one of five healthcare companies on the Forbes 2018 Cloud 100 list, ranked #1 on the 2019 Tech Tribune's Best Technology Startups in Colorado and #2 in Colorado on Deloitte's 2017 Technology Fast 500. At Welltok, we're proud of what we're accomplishing and are committed to building a company where smart, passionate people can thrive and succeed. Join us as we make healthcare more personal and rewarding!
NIMBL Denver, CO
Jacobs Englewood, CO
The Public Interest Network Denver, CO
KPA Services LLC Lafayette, CO
City of Arvada Arvada, CO