SQL Database Administrator

Location: Los Angeles, CA
Date Posted: 12-21-2017
Must be able to work for any U.S. employer without restrictions or need for sponsorship

About the Company


Our client leads the health care industry in improving health and reducing claims costs for health plan members with heath care needs that cause or exacerbate co-existing medical conditions. They have an intensive outpatient program that treats an overlooked population. These members cost health plans millions of medical dollars primarily due to preventable health care usage and assistance and medical inpatient admissions.  They use a proprietary analytics platform and predictive modeling to identify the users of medical healthcare services with costs that can be significantly reduced by addressing the underlying issues. Through proactive outreach, they engage and treat these individuals in a patient-centric program that integrates evidence-based medical interventions and care by medical staff.

 
Why Work Here
 
  • Ability to work remote
  • Great pay and excellent benefits (healthcare, 401K, holidays, vacation, sick days, etc.)
  • Company culture encourages growth and promotions
  • Employees routinely recognized for their efforts and supported educational opportunities
  • Supportive and knowledgeable co-workers
  • Positive work environment
  • Company that provides help to people who otherwise might not receive proper treatment
  • A company that is rapidly growing, innovative and dedicated to creating a world-class culture
  • Close-knit team and work atmosphere
  • Cutting-edge use of data analytics for innovative care models that achieve program success
  • Leadership shares vision, achievements and goals and welcomes your ideas and feedback
  • Meaningful work environment where your efforts are helping improve other people’s lives
  • Paid travel expenses and paid training
 
About your Role

As a SQL Database Administrator, you will support production data and databases and will be responsible for the health of the data infrastructure within the organization, including responsibilities around the MDM/ETL operations, backup and recovery, capacity planning and operational efficiencies.  You will work with the application development team and the data science team to support production and research development objectives.  You will be responsible for configuration, uptime, capacity planning, account creation and maintenance, backups/restores, high availability planning and testing. You will work with the DevOps team for creation of new automation and builds and you’ll work with the data operations team for data quality and availability.
 
 Qualifications
 
  • Excellent administrative understanding of Hadoop clusters in a production environment
  • Significant experience with SQL Server and Hadoop
  • Experience with data transfers between SQL and Salesforce is highly desired
  • Experience with database replication and scaling.
  • Experience with automation tooling (chef/puppet)
  • Experience with Hive
  • Knowledge of and experience with database tuning, access controls (Authentication, Authorization, Audit Logging) and monitoring
  • Experience with Cloudera tools
  • Experience doing high-availability data replication and disaster recovery
  • Ability to work collaboratively in a fast-paced, entrepreneurial environment
  • Experience working with Agile methodologies
  • Passionate about Big Data technologies and interested in integrating statistics and analytics to make systems perform optimally
  • Experience working with cloud technologies


Responsibilities 
 
  • Configuration and maintenance of all data stores in production, staging and QA environments
  • Maintenance and support of the Hadoop Data Pipeline
  • Installs, upgrades and testing complex data deployments
  • Support for Big Data infrastructures, including access methods, device allocations, validation checks and security
  • Proactively monitor events, investigate issues, analyze solutions, and drive problems through to resolution using a wide variety of Ops tools and monitoring platforms to gain knowledge, understanding, and enable persistent monitoring of database availability, performance, and capacity
  • Establish and maintain accounts and access controls to all production databases
  • Perform data grooming and implement retention policies
  • Maintain database monitoring systems and develop new metrics/monitoring dashboards as additional coverage events become necessary
  • On-call for potential downtime problem solving and root cause diagnosis
                   CHALLENGING AND STIMULATING TECHNOLOGY OPPORTUNITIES START HERE
or
this job portal is powered by CATS