Health Plan of San Joaquin/Mountain Valley Health Plan · 11 hours ago
Senior Database Administrator
California, United States
Full-time
Remote
Senior Level
$125K/yr - $185K/yr
5+ years exp
Maximize your interview chancesHealth CareHealth Insurance
Hiring Manager
Lori Loop
Insider Connection @Health Plan of San Joaquin/Mountain Valley Health Plan
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Under general supervision, responsible for managing database environment and infrastructure in a manner that ensures data availability, confidentiality, integrity, manageability, security and recovery.
Designs, builds, implements, tests and maintains databases. environment and infrastructure.
Plans and conducts structured testing of database designs to confirm functionality and performance.
Monitors and tunes database environment and infrastructure to meet business needs.
Evaluates, selects and implements technology and techniques to enhance database environment and infrastructure.
Manages database code deployments and upgrades.
Develops, implements and maintains documentation, policies, standards, procedures and guidelines necessary to effectively administer and ensure the security of the database environment.
Develops, tests, implements and maintains backup strategy and recovery plans.
Collaborates with other IT teams in support of workload automation.
Creates, analyzes and reports on database metrics and key performance indicators (KPIs).
Maintains and configures user system access levels based on established Role Based Access Controls.
Collaborates with support vendor as needed to ensure database environment reliability.
Provides tier 3 and above support to the Help Desk.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
In-depth skills and knowledge in SQL services, included but not limited to the ability to run SQL server complete, differential, and transaction log backups.
In-depth knowledge in SQL services to include but not limited to indexing and performance tuning.
In-depth knowledge of and ability to install, test, and implement database software servers and database management systems and upgrades.
In-depth knowledge of and ability to perform database capacity planning.
Strong knowledge of Microsoft products (Windows and domain architecture), and network and domain architecture.
In-depth knowledge of database servers and engines – layout, design, performance factors, data management.
Bachelor’s Degree in Computer Science, Business Administration, or closely related field;
At least five years of T-SQL experience in design and support of Microsoft SQL Server;
At least five years’ experience in stored procedures, triggers, query and performance tuning;
At least five years’ experience in administering high transactional, high availability large database systems;
Equivalent combination of education and experience.
In-depth knowledge of and ability to write stored procedures, complex queries, correlated/nested sub-queries, derived tables, and Common Table Expressions (CTE).
In-depth knowledge of and ability to implement database security elements to support minimal necessary access requirements.
In-depth knowledge of and ability to link database servers to support complete SQL query scripts.
In-depth knowledge of referential database integrity and normalization.
Strong knowledge of the principles and methods of all phases of systems development lifecycle methodology.
Produces work that is accurate and complete.
Produces the appropriate amount of work.
Actively learns through experimentation when tackling new problems, using both successes and failures to learn.
Rebounds from setbacks and adversity when facing difficult situations.
Knows the most effective and efficient process to get things done, with a focus on continuous improvement.
Strong analytical and problem-solving skills.
Interpersonal skills - interacts effectively with individuals both inside and outside of HPSJ; relates openly and comfortably with diverse groups of people.
Strong oral and written communication skills, with the ability to effectively communicate with business and technical users and make presentations.
Time management and organizational skills. Uses time effectively and efficiently. Values time. Concentrates his/her efforts on the more important priorities. Can attend to a broader range of activities. Meets deadlines.
Strong customer service skills.
Ability to work independently and as part of a team.
Basic mathematics skills.
Ability to speak and be understood in English.
Ability to handle confidential information with appropriate discretion.
Preferred
Strong knowledge with XML and interpreted languages, C# is preferred.
Strong knowledge in SQL Server Integration Services (SSIS) with the ability to design complex ETL packages for extracting and loading data to the acquisition, conforming, integration, and dimension layers.
Strong knowledge of Bill Inmon data warehouse architecture with ability to create ETL packages to populate acquisition, conforming, integration, and dimension layers.
Strong knowledge of the principles and methods of project management appropriate to medium sized projects of moderate complexity.
Benefits
Robust and affordable health/dental/vision with choices in providers
Generous paid time off (starting at 3 weeks of PTO, 4 paid floating holidays including employee’s birthday, and 9 paid holidays)
CalPERS retirement pension program, automatic employer-paid retirements contributions, in addition to voluntary defined contribution plan
Two flexible spending accounts (FSAs)
Employer-Paid Term Life and AD&D Insurance
Employer-Paid Disability Insurance
Employer-Paid Life Assistance Program
Health Advocacy
Supplemental medical, legal, identity theft protection
Access to exclusive discount mall
Education and training reimbursement in addition to employer-paid elective learning courses.
Company
Health Plan of San Joaquin/Mountain Valley Health Plan
Health Plan of San Joaquin/Mountain Valley Health Plan (not-for-profit health plan) is the leading Medi-Cal managed care provider in San Joaquin in Stanislaus Counties, now serving Medi-Cal members in Alpine in El Dorado Counties.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Michael Schrader
CEO
Company data provided by crunchbase
