Systems Database Administrator

Santa Clara Family Health Plan; San Jose (CA); On-site; USD 114,000 - 176,000; Full time

Job summary

Santa Clara Family Health Plan seeks a Systems Database Administrator to ensure security, integrity, performance and recoverability of databases and related systems. You will install, configure, and maintain databases, manage security, back-ups, and audits, and collaborate with developers.

You will monitor resources, test upgrades, and contribute to data governance and documentation while supporting production, development, and test environments.

Qualifications

• 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.
• 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 MS SQL BI 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.
• Excellent communication skills including the ability to express oneself clearly and concisely when providing service to SCFHP internal departments, providers and outside entities over the telephone, in person or in writing.
• Ability to think and work effectively under pressure and accurately prioritize and complete tasks within established timeframes.
• Ability to assume responsibility and exercise good judgment when making decisions within the scope of the position.
• Ability to maintain confidentiality.
• Ability to comply with SCFHP's policies and procedures.
• Ability to perform the job safely with respect to others, to property, and to individual safety.

Responsibilities

• 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.
• Perform other related duties as required or assigned.

Skills

Communication

Attention to detail

Prioritization under pressure

Confidentiality

Team collaboration

Problem solving

Education

Bachelor's degree in Computer Science or related field

MCSE certification

Tools

Microsoft SQL Server

SQL Scripting

PowerShell / Command Shell

SSRS / SSIS / SSAS

C++, Java, .NET

Job description

Systems Database Administrator

Salary Range: $113,836 - $176,446
The expected pay range is based on many factors, such as experience, education, and the market. The range is subject to change.

FLSA Status: Exempt
Department: Information Technology
Reports To: Director, Infrastructure and Systems Support

Employee Unit: Employees in this classification are represented by Service Employees International Union (SEIU) Local No. 521

GENERAL DESCRIPTION OF POSITION

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.

ESSENTIAL DUTIES AND RESPONSIBILITIES

To perform this job successfully, an individual must be able to perform each essential duty listed below satisfactorily.

1. 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.
2. 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.
3. Ensure database security by controlling access to databases through authentication and authorization and performing auditing of database usage and active users.
4. Audit database security and user access to ensure HIPPA regulatory law reporting requirements are met.
5. Monitor database server resources to ensure production environments meet performance and availability requirements.
6. Install, test, secure and maintain new versions of database software, patches and other associated software application changes or upgrades.
7. Provide storage and capacity planning, long and short term, to ensure adequate space is available for all database environments.
8. Document database architecture, including developing and maintaining database installation and configuration procedures, data governance program, change control deployment procedures, and SQL coding guidelines.
9. Work with the application development team to ensure that appropriate and efficient SQL is coded and tested prior to production deployment.
10. Perform other related duties as required or assigned.

REQUIREMENTS - Required (R) Desired (D)

The requirements listed below are representative of the knowledge, skill, and/or ability required or desired.

1. Bachelor's Degree in Computer Science, or related field, or equivalent experience, training or coursework. (R)
2. Minimum three years of experience serving as a systems database administrator in a Microsoft SQL Server environment with versions currently supported by Microsoft. (R)
3. Microsoft Certified Solutions Expert (MCSE). (D)
4. 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. (R)
5. Minimum three years of experience SQL Scripting and Command Shell scripting. (R)
6. 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. (R)
7. Minimum three years of experience with MS SQL Business Intelligence tools (SSRS, SSIS, SSAS) or other enterprise business intelligence software. (R)
8. Experience maintaining a data warehouse database environment, including managing and enforcing data governance and coding best practice. (R)
9. Ability to create and maintain documentation of source code, application installation processes, technical specifications, and data governance program. (R)
10. Working knowledge of and the ability to efficiently operate all applicable computer software including computer applications such as Outlook, Word and Excel. (R)
11. Ability to use a keyboard with moderate speed and a high level of accuracy. (R)
12. Excellent communication skills including the ability to express oneself clearly and concisely when providing service to SCFHP internal departments, providers and outside entities over the telephone, in person or in writing. (R)
13. Ability to think and work effectively under pressure and accurately prioritize and complete tasks within established timeframes. (R)
14. Ability to assume responsibility and exercise good judgment when making decisions within the scope of the position. (R)
15. Ability to maintain confidentiality. (R)
16. Ability to comply with SCFHP's policies and procedures. (R)
17. Ability to perform the job safely with respect to others, to property, and to individual safety. (R)

WORKING CONDITIONS

Generally, duties are primarily performed in an office environment while sitting or standing at a desk. Incumbents are subject to frequent contact with and interruptions by co-workers, supervisors, and plan members or providers in person, by telephone, and by work-related electronic communications.

PHYSICAL REQUIREMENTS

Incumbents must be able to perform the essential functions of this job, with or without reasonable accommodation:

1. Mobility Requirements: regular bending at the waist, and reaching overhead, above the shoulders and horizontally, to retrieve and store files and supplies and sit or stand for extended periods of time; (R)
2. Lifting Requirements: regularly lift and carry files, notebooks, and office supplies that may weigh up to 5 pounds; (R)
3. Visual Requirements: ability to read information in printed materials and on a computer screen; perform close-up work; clarity of vision is required at 20 inches or less; (R)
4. Dexterity Requirements: regular use of hands, wrists, and finger movements; ability to perform repetitive motion (keyboard); writing (note-taking); ability to operate a computer keyboard and other office equipment (R)
5. Hearing/Talking Requirements: ability to hear normal speech, hear and talk to exchange information in person and on telephone; (R)
6. Reasoning Requirements: ability to think and work effectively under pressure; ability to effectively serve customers; decision making, maintain a concentrated level of attention to information communicated in person and by telephone throughout a typical workday; attention to detail. (R)

ENVIRONMENTAL CONDITIONS

General office conditions. May be exposed to moderate noise levels.

EOE