Systems Database Administrator

About Us:

Santa Clara Family Health Plan (SCFHP) is a local, community-based health plan dedicated to improving the health and well-being of the residents of Santa Clara County. Working in partnership with providers and community organizations, we serve our neighbors through our Medi-Cal and SCFHP DualConnect (HMO D-SNP) health care plans.

About the role:

The Systems Database Administrator is responsible for database security, integrity, performance, availability, and recoverability of databases, database servers, and related systems. In addition, the Systems Database Administrator is responsible for installing, configuring, and maintaining database servers, databases, related objects, and related software and for database security in support of SCFHP objectives and regulatory compliance. Day to

Day:

Provide technical management and support for the organization's database environments to ensure database security, integrity, performance, availability and recoverability of databases, database servers, and related systems. Develop, implement, and periodically test backup and recovery plan for the production of critical databases to ensure the business continuity plan is accurate and effective. Ensure database security by controlling access to databases through authentication and authorization and performing auditing of database usage and active users. Audit database security and user access to ensure HIPPA regulatory law reporting requirements are met. Monitor database server resources to ensure production environments meet performance and availability requirements. Install, test, secure and maintain new versions of database software, patches and other associated software application changes or upgrades. Provide storage and capacity planning, long and short term, to ensure adequate space is available for all database environments. Document database architecture, including developing and maintaining database installation and configuration procedures, data governance program, change control deployment procedures, and SQL coding guidelines. Work with the application development team to ensure that appropriate and efficient SQL is coded and tested prior to production deployment.

About You:

Bachelor's Degree in Computer Science, or related field, or equivalent experience, training or coursework. Minimum three years of experience serving as a systems database administrator in a Microsoft SQL Server environment with versions currently supported by Microsoft. Microsoft Certified Solutions Expert (MCSE). Minimum three years of experience maintaining multiple database environments and regions to support production, development and test areas of business systems; including managing database security, database tuning, query optimization, and application code deployment. Minimum three years of experience SQL Scripting and Command Shell scripting. Minimum three years of experience with any of the following applicable languages/platforms: .NET, PERL, Java, SAS, VB, C++, or other modern programming language or related software. Minimum three years of experience with MS SQL Business Intelligence tools (SSRS, SSIS, SSAS) or other enterprise business intelligence software. Experience maintaining a data warehouse database environment, including managing and enforcing data governance and coding best practice. Ability to create and maintain documentation of source code, application installation processes, technical specifications, and data governance program. Please review the full job description on our Career's page: https://phf.tbe.taleo.net/phf04/ats/careers/v2/viewRequisition?org=SANTCLAR2&cws=38&rid=3124

Pay:

$111,168.00 - $172,310.00 per year

Benefits:

Dental insurance Employee assistance program Flexible spending account Health insurance Life insurance Paid time off Referral program Retirement plan Tuition reimbursement Vision insurance

Education:

Bachelor's (Required)

Experience:

Systems Database Administrator:

3 years (Required)

SQL Scripting:

3 years (Required)

MS SQL:

3 years (Required)

Work Location:

Hybrid remote in San Jose, CA 95119