JOB SUMMARY
We are seeking a skilled and proactive Mid-Level Database Administrator to join our strong, dedicated, and experienced team. The ideal candidate will primarily focus on the reliable operation, maintenance, and performance of our on-prem SQL Server environments.
A foundational understanding of cloud database concepts, particularly Google Cloud SQL, is important, coupled with a strong willingness to learn and grow across diverse database platforms, including Postgres and MySQL on Linux.
They should possess strong communication skills and a keen understanding of automating database tasks and managing infrastructure as code to enhance efficiency. This role offers an excellent opportunity for professional growth within an experienced team, contributing to the support and evolution of critical database systems that underpin both our provider and payer side operations. Candidates should be capable of working independently on routine database administration tasks, troubleshooting issues, and collaborating effectively with application teams and vendors on customer projects with limited guidance.
Duties include
- Database Operations & Performance: Manage the day-to-day operation, maintenance, and performance tuning of on-prem SQL Server instances and databases. This includes monitoring, capacity planning, and optimizing queries.
- Installation & Configuration: Install, configure, and patch SQL Server environments, including managing SQL Server Agent jobs.
- Backup & Recovery: maintain backup and recovery strategies to ensure data integrity and availability.
- High Availability & Disaster Recovery (HA/DR): Monitor and maintain existing HA/DR solutions (e.g., Always On Availability Groups) and assist with their implementation.
- Security Management: Administer SQL Server security, managing logins, users, roles, permissions, and ensuring compliance with security policies.
- Troubleshooting & Support: Diagnose and resolve database-related issues, providing support to application teams, vendors, and participating in incident resolution.
- Documentation: Maintain clear and comprehensive documentation for database systems and processes.
ESSENTIAL RESPONSIBILITIES
- Create, develop, and review the physical model created from the logical model, ensuring that the detailed physical design of data structures and databases complies with standards, guidelines and procedures recommended for all aspects of data modeling, database design, and maintenance. Provide support for application staff and business areas regarding database implementations, which could include a customized in-house database and/or a third party application package. Establish automated monitor mechanism for space and database availability conditions. Establish best practices for database and application high availability through the use of third party technologies and through the exploitation of various database features.
- Provide applications support for staff, as well as, outside division to answer questions and resolve problems related to the DBMS technology and computing platform such as Z/OS, UNIX, Linux, and Windows. Conduct root cause analysis to identify and resolve problems impacting application and/or database availability and service levels. Contact vendor support when necessary to facilitate application development and client problem resolution with optimum speed and efficiency.
- Provide after hours and weekend support as required for on call responsibilities, database refreshes, testing, technology upgrades, and other off hour assignments.
- Participate in establishing and maintaining technical standards, departmental procedures, and other technical documentation as required. Assure compliance to required Corporate standards, procedures, guidelines and processes, including audits.
- Assist in identifying, developing, and providing technology training to the application developers of the organization (formal and informal). Participate in staff training opportunities (formal and informal) relative to rules, procedures, and standards for the access and maintenance of shared data resources.
- Participate as assigned to intra and inter-departmental project initiatives. Participate as assigned in the testing and recommendation of tools and utilities to improve the effectiveness of managing and supporting the database environments.
- Maintain contacts with other DBA professionals externally in other Health Insurance/Health Care industries and/or other industries to maintain a perspective of current trends and best practices.
- Other duties as assigned or requested.
QUALIFICATIONS
Minimum
- High school diploma GED
- 1-3 years of experience in Information Technology
Preferred
- Bachelor’s degree in information technology, Computer Science, or closely related field
- 3 to 5+ years of experience in Sql Server Database Administration
- Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) is a plus.
- Scripting proficiency with T-SQL, Python, and/or PowerShell is a plus
- Knowledge of SolarWinds DPA for performance tuning, monitoring, and SQL is a plus
- Familiar or some experience with the following is a plus
- CloudSql on Google Cloud Platform
- Postgres or AlloyDB databases
- familiarity with Infrastructure as Code (IaC) principles, Terraform
- Other DB platforms such as MySql database on Linux
- Linux OS
- AI tools such as Copilot and Sidekick
- Sql Server Certifications are a plus
Language (Other than English):
None
Travel Requirement:
0% - 25%
PHYSICAL, MENTAL DEMANDS and WORKING CONDITIONS
Position Type
Office-based
Teaches / trains others regularly
Occasionally
Travel regularly from the office to various work sites or from site-to-site
Rarely
Works primarily out-of-the office selling products/services (sales employees)
Never
Physical work site required
Yes
Lifting: up to 10 pounds
Constantly
Lifting: 10 to 25 pounds
Occasionally
Lifting: 25 to 50 pounds
Rarely
Disclaimer: The job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this job title. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job.
Compliance Requirement: This job adheres to the ethical and legal standards and behavioral expectations as set forth in the code of business conduct and company policies.
As a component of job responsibilities, employees may have access to covered information, cardholder data, or other confidential customer information that must be protected at all times. In connection with this, all employees must comply with both the Health Insurance Portability Accountability Act of 1996 (HIPAA) as described in the Notice of Privacy Practices and Privacy Policies and Procedures as well as all data security guidelines established within the Company’s Handbook of Privacy Policies and Practices and Information Security Policy.
Furthermore, it is every employee’s responsibility to comply with the company’s Code of Business Conduct. This includes but is not limited to adherence to applicable federal and state laws, rules, and regulations as well as company policies and training requirements.
Pay Range Minimum:
$57,700.00Pay Range Maximum:
$107,800.00Base pay is determined by a variety of factors including a candidate’s qualifications, experience, and expected contributions, as well as internal peer equity, market, and business considerations. The displayed salary range does not reflect any geographic differential Highmark may apply for certain locations based upon comparative markets.
Highmark Health and its affiliates prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on any category protected by applicable federal, state, or local law.
We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the email below.
For accommodation requests, please contact HR Services Online at [email protected]
California Consumer Privacy Act Employees, Contractors, and Applicants Notice
Top Skills
What We Do
Highmark Health, a Pittsburgh, PA based enterprise that employs more than 40,000 people who serve millions of Americans across the country, is the second largest integrated health care delivery and financing network in the nation based on revenue. Highmark Health is the parent company of Highmark Inc., Allegheny Health Network, and HM Health Solutions. Highmark Inc. and its subsidiaries and affiliates provide health insurance to nearly 5 million members in Pennsylvania, West Virginia and Delaware as well as dental insurance, vision care and related health products through a national network of diversified businesses that include United Concordia Companies, HM Insurance Group, and Visionworks. Allegheny Health Network is the parent company of an integrated delivery network that includes eight hospitals, more than 2,800 affiliated physicians, ambulatory surgery centers, an employed physician organization, home and community-based health services, a research institute, a group purchasing organization, and health and wellness pavilions in western Pennsylvania. HM Health Solutions focuses on meeting the information technology platform and other business needs of the Highmark Health enterprise as well as unaffiliated health insurance plans by providing proven business processes, expert knowledge and integrated cloud-based platforms.
A national blended health organization, Highmark Health and our leading businesses support millions of customers with products, services and solutions closely aligned to our mission of creating remarkable health experiences, freeing people to be their best.
Headquartered in Pittsburgh, we're regionally focused in Pennsylvania, Delaware, West Virginia and New York, with customers in all 50 states and the District of Columbia.
We passionately serve individual consumers and fellow businesses alike. Our companies cover a diversified spectrum of essential health-related needs, including health insurance, health care delivery, population health management, dental solutions, reinsurance solutions, and innovative technology solutions.
We’re also proud to carry forth an important legacy of compassionate care and philanthropy that began more than 170 years ago. This tradition of giving back, reinvesting and ensuring that our communities remain strong and healthy is deeply embedded in our culture, informing our decisions every day.
