DO YOU WANT TO WORK WITH AN EXPANDING TEAM THAT HAS THE COMPLEXITY OF A LARGE COMPANY WITH THE VISIBILITY WITH A MID-SIZED ONE WHILE ALSO RECEIVING FANTASTIC PERKS AND BENEFITS? WE ARE SEEKING A SENIOR DATABASE ADMINISTRATOR WITH STRONG TECHNICAL ABILITIES, AND A PASSION FOR PROVIDING QUALITY SUPPORT TO OUR TEAMS.
WHAT YOU WILL BE DOING:
You will be 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.
Required Skills
WHAT YOU BRING:
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.
- In-depth knowledge of and ability to write stored procedures, complex queries, correlated/nested sub-queries, derived tables, and Common Table Expressions (CTE).
- 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.
- 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 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.
- 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
- Experience with Microsoft Visio, and the ability to create data/process flow diagrams from business requirements.
Required Experience
WHAT YOU HAVE:
Required
- Bachelor’s Degree in Computer Science, Business Administration, or closely related field; and
- At least five years of T-SQL experience in design and support of Microsoft SQL Server; and
- At least five years’ experience in stored procedures, triggers, query and performance tuning; and
- At least five years’ experience in administering high transactional, high availability large database systems; or
- Equivalent combination of education and
Preferred
- Experience in a managed care health plan environment.
- Experience with QNXT claims processing system
- Master’s Degree in Computer Science, Management Information Systems, or closely related field.
WHAT YOU WILL GET:
- HPSJ Perks:
- Competitive salary
- Robust and affordable health/dental/vision (90% paid medical for employees and 100% paid dental/vision for employees) 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.
- A chance to work for an organization that is mission-driven – our members and community are at the core of everything we do.
- A shorter commute – if you’re commuting from the Central Valley to the Bay Area.
- Visibility and variety – you have a chance to work with people at all levels of the organization, and work on diverse projects.
OUR VISION:
- Continuously improve the health of our community.
OUR MISSION:
- We provide healthcare value and advance wellness through community partnerships.