Database Administrator - Richardson, United States - Agile People and Payroll LLC

Description

Job Description

ABOUT US

834 Labs develops enrollment platforms, patient engagement tools, and provider technology to enhance operational efficiency and elevate the quality of service in insurance markets. By analyzing and interpreting complex datasets, 834 Labs extracts valuable insights, identifies trends, and simplifies the decision-making processes for insurance companies, agencies, and healthcare providers. We are professional, fast-paced, and service-centric. Our goal is to ensure that your employment is meaningful, mutually beneficial, and enjoyable

POSITION SUMMARY

We are seeking an experienced Database Administrator that will architect, implement, monitor & back-up our hosting infrastructure. This exceptional individual will coordinate and collaborate with cross functional teams to assure the success & smooth operations of our databases, primarily focused on SQL & MongoDB. The role will participate in the development of novel software & digital assets, via SDLC & Agile/Scrum with the entire department of Product, Engineering, Architecture, Compliance, Quality & Configuration.

PREFERRED QUALIFICATIONS:

The ideal candidate will have expertise in the following concepts & technologies:

• DB architecture: designing new installations & legacy structures.
• Administrative & Data related work.
• Review, evaluate, design, install & implement cloud DB's.
• Proactive monitoring & improving performance of applications/subsets accessing DB's.
• AWS Environment with failover architecture in Azure & GCP.
• SQL/No SQL environments within Windows Hosting.
• Back-up, recovery & business continuity: Cloud/on-site.
• Data security.

KNOWLEDGE BASE:

A mastery of documentation skills is a primary requirement for every role in the Application Development Department:

• Escalation documents.
• Disaster recovery documents.
• PEM Keys, Ports & whitelisted IP Addresses.
• DB Schema & Config.
• Compliance Reports.
• UAR's.

RESPONSIBILITIES & SKILL SET

Architecture:

• Design & create databases to support development initiatives via SQL Specific Skills & MongoDB Specific Skills.
• Act as an application DB during the design process in order to work closely with the application team to understand what changes are coming in a build/patch/hotfix; perform an impact analysis, fine-tune the queries.
• Automate the process of deploying DB changes for a new build/patch/hotfix.
• Identify & setup alerts & logging in AWS & Fail-over: Azure/GCP.

Maintenance:

• Strong knowledge & understanding to optimize query performance.
• Database hardening (evaluate, plan & perform maintenance, e.g. patches, updates) – implement best practices.
• Implementing best practices for backups, replication, & health checks. Design & implement DR plans & HA solutions & recommendations. Disaster Recovery & Business Continuity experience.
• Proficient in management, availability, security, & performance monitoring & optimization of database solutions.
• Manages escalations, analyzes situations, & coordinates appropriate requirements to resolve issues by following delivery practices, considering cost implications, & engaging in conversations with internal & external stakeholders.
• Experience to detect & resolve database-related CPU, memory, I/O, disk space & other contention issues.
• Maintain databases – Statistics, Indexes, fragmentation. In addition, conduct performance tuning & optimization (stored procedures, views, functions, queries)
• Support release/code deployment activities & Coordinate removal and/or archiving of data that is no longer required to be available in the production databases.

Agile/Scrum:

• Working with software developers & software engineers for launches & ensuring that development & launches follows established processes & works as intended.
• Planning & being involved in project management decisions.

REQUIRED QUALIFICATIONS:

• Formal/OTJ training or certification on software engineering concepts & applied experience.
  • 2+ years of professional software development exposure to web applications, including team collaboration & code repository (GitHub).
  • 5+ years of full software development life cycle, including coding standards, code reviews, unit & integration testing, & operations experience.
  • 3+ years of active engagement in an Agile/Scrum team.
  • 4+ years of professional experience in AWS.
  • 4+ years of database administration with SQL.
  • 2+ years of database administration with MongoDB.
  • 4+ years of active engagement in design or architecture ( reliability, & scaling) of new & existing systems experience using AWS services.
• Experience as a mentor, tech lead or leading an engineering team.
• Proven work experience in building complex software systems that have been successfully delivered to customers.

WHAT WE OFFER

• Competitive Compensation and Incentive Structure
• Full Benefits (Medical, Dental, Vision, Disability, Life)
• Paid Time Off
• Referral Program
• 401k

NOTE

This job description in no way states or implies that these are the only duties to be performed by the employee(s) incumbent in this position. Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments. All duties and responsibilities are essential functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities. To perform this job successfully, the incumbents will possess the skills, aptitudes, and abilities to perform each duty proficiently. Some requirements may exclude individuals who pose a direct threat or significant risk to the health or safety of themselves or others. The requirements listed in this document are the minimum levels of knowledge, skills, or abilities. This document does not create an employment contract, implied or otherwise, other than an "at will" relationship.

Agility Insurance Services LLC provides equal employment opportunities to all applicants, without regard to unlawful considerations of or discrimination against race, religion, creed, color, nationality, sex, sexual orientation, gender identity, age, ancestry, physical or mental disability, medical condition or characteristics, marital status, or any other classification prohibited by applicable local, state, or federal laws. Agility Insurance Services LLC may obtain a 'consumer report' about you from a consumer reporting agency for employment purposes. A 'consumer report' is a background screening report that may contain information regarding your criminal history, driving history, and information about you.

Note: The annual base salary range provided for this position is a nationwide market range & represents a broad range of salaries for this role across the country. The actual salary for this position will be determined by a number of factors, including the scope, complexity & location of the role; the skills, education, training, credentials & experience of the candidate; & other conditions of employment.

Job Type: Full-time

Schedule: Monday - Friday

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Retirement plan
• Vision insurance

Experience level:

• 5+ years of relevant experience for the role within the last 7 years.

Work Location:

• In Office