Database Analyst

Are you looking for a team at a rapidly growing company where your perspective is valued? Hooray Health is looking for an individual with strong technical skills that can work with limited oversight. We will look to you to provide your expertise in building and maintaining scalable technical processes that comprise the backbone for current and future business objectives. You will be provided the opportunity to use your knowledge in new and challenging ways; working with architecture, application development and operations to help achieve a state-of-the-art environment.

You will be responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing leadership with a long-term perspective on the relationship of database technology to the business opportunities facing the company.

Role and Responsibilities

• Monitor and maintain system health and security
• Design backup processes for server and associated data and schedule/perform regular server maintenance
• Develop and manage file feeds and reporting requirements such as eligibility, premium, sales, provider files
• Monitor data quality and integrity and take corrective action as necessary
• Determines database structural requirements by analyzing operations, applications, and programming. Creates database management procedures and develops and documents standards and best practices. Creates required technical documentation.
• Develops database solutions, including functional capabilities; security; backup; and recovery specifications, in collaboration with the development and operations teams.
• Proactively maintains database performance by finding and resolving production and application development problems.
• Identifies, evaluates, and recommends technologies to achieve desired database performance.
• Works proactively with the operations team to administer the database infrastructure and resolve challenging performance issues.
• Create and maintain accounts for all system users and assign security levels
• Provide end-to-end technical support and problem resolution
• Research and analyze system performance issues, new technology and technical, tactical and strategic solutions
• Design, develop, document and implement complex automated development infrastructures for our customers (build automation, deployment automation, test environments, development environments)
• Perform incident response analysis and root cause analysis through research, and peer/vendor support
• Build and maintain system and application snapshots for use with continuous delivery.
• Develop software in appropriate scripting languages using agile design-build-test methodologies.
• Develop unit tests alongside production code in a continuously integrated environment.
• Actively participate in all phases of the software development life cycle, including research, prototyping, detailed design, development, technical documentation, and defect fixing.
• Collaborate with the wider team on design and code reviews.

Other Responsibilities

• Handles special projects as assigned, including participating in company committees/teams
• Flexible to work additional hours as required
• Continually builds product knowledge
• Complies with all corporate policies and business practices

Qualifications and Educational Requirements

• Bachelor’s Degree in Computer Science or Computer Engineering
• 2+ years’ professional experience or internship
• Advanced knowledge of Microsoft SQL Server administration, backup and disaster recovery scenarios, a strong understanding and experience using T-SQL to automate tasks
• Advanced knowledge of database structure and theory
• Experience with databases, MySQL, and MSSQL
• Experience with managing database security, SRS and performance tuning and optimization of database systems
• Basic understanding of disaster recovery and database backup procedures
• Understanding of securing/hardening of operating systems, applications and communication channels with outside third parties
• Familiarity with reporting tools
• Ability to work independently with minimal supervision and assistance
• Experienced with system and application integration

Preferred Skills and Technical Proficiencies

• Strong problem resolution skills
• Strong interpersonal, communication, organization and follow-up skills along with a strong numerical aptitude required
• Effectively manages multiple tasks and handles all responsibilities with a strong sense of urgency
• Able to manage time effectively, takes initiative, manages and adjusts priorities
• Excellent communication skills including an excellent command of English (speaking, reading, writing)
• Qualitative abilities including analytical and effective problem-solving skills
• Willing and able to learn new products, concepts and techniques and computer software programs
• Team player able to work independently in a results-driven, fast-paced environment
• Experience with storage and networking devices, virtual environment.
• Experience with continuous development tools, i.e., GitHub, Terraform, Jenkins, ELK Stack, Packer, Trello.
• Experience using appropriate tooling associated with DevOps engineering and system configuration management.
• Experience using and creating APIs