American Specialty Health Incorporated is seeking a Senior Database Admin II to join our Information Technology Operations department. This position will provide expert-level production support duties for all of the mission-critical databases in the organization.

Remote Worker Considerations

Candidates who are selected for this position will be trained remotely and must be able to work from home in a designated work area with company-provided technology equipment.This remote/WFH position requires you have a stable connection to your Internet Service Provider with the ability to participate by video in online meetings over a reliable and consistent network (minimum internet download of 50 Mbps and 10 Mbps upload speed).

Responsibilities

• Implement and manage Azure database services, ensuring high availability, disaster recovery, and performance optimization in line with best practices.
• Utilize Azure DevOps for continuous integration and delivery pipelines, infrastructure as code, and proactive monitoring and alerting of database environments.
• Serve as a Site Reliability Engineer (SRE) focusing on the reliability and maintainability of database services, applying engineering solutions to operations problems.
• Oversee database server installations, patching, and upgrades, including clustered server environments, ensuring compliance with the latest security standards.
• Conduct database maintenance following best practices; including index rebuilds, updating distribution statistics and performing database consistency checks.
• Manage backups, recovery procedures, and conduct regular recovery testing and verification to guarantee data integrity and availability.
• Perform database performance tuning activities; such as analyzing MS SQL query plans, index tuning, troubleshooting database blocking, and resolving deadlocks.
• Develop high availability strategies including clustering and availability groups.
• Participates in 24x7x365 on-call support rotation, addressing critical issues promptly and efficiently.
• Execute routine performance and availability testing on database servers to ensure scalability, resiliency, and capacity of all applications.
• Assists in the architecture of database systems for high-volume database applications with high availability applications, optimizing for Azure environments.
• Travels to company sites as needed.

Qualifications

• Bachelor's degree in an IT-related field preferred.
• Minimum of 7 years of experience as a production MS-SQL DBA.
• Experience in a high-growth, fast-paced environment.
• Expert knowledge of database security best practices.
• Strong knowledge and experience with monitoring, designing database objects, and optimizing objects to improve overall database performance.
• Working knowledge of modern data network technologies, enterprise storage technologies, (SAN, NAS, etc.), server consolidation technologies, server virtualization technologies, and disaster recovery technologies.
• Familiarity with Azure databases, Azure Cosmos DB, and other Azure services.
• Experience with SQL Server version 2016 and above.
• Ability to design, deploy, and manage databases in the Azure cloud.
• Experience with Azure DevOps for CI/CD pipelines, IaaS, PaaS, and automated deployments.
• Proficiency in creating and managing release pipelines.
• Understanding of SRE (Site Reliability Engineering) principles and practices.
• Proven ability to design efficient and scalable database schemas.
• Ability to improve system availability, reliability, and operational efficiency.
• Experience with monitoring, incident response, and learning from failures.
• Ability to display excellent customer service to meet the needs and expectations of both internal and external customers.
• Excellent listening and interpersonal communication skills to identify critical core competencies based on success factors and organizational environment.
• Demonstrated accuracy and productivity in a changing environment with constant interruptions.
• Demonstrated ability to analyze information, problems, issues, situations, and procedures to develop effective solutions.

Core Competencies

• Demonstrated ability to interact in a positive, respectful manner and establish and maintain cooperative working relationships.
• Ability to display excellent customer service to meet the needs and expectations of both internal and external customers.
• Excellent listening and interpersonal communication skills to identify critical core competencies based on success factors and organizational environment.
• Ability to effectively organize, prioritize, multi-task and manage time.
• Demonstrated accuracy and productivity in a changing environment with constant interruptions.
• Demonstrated ability to analyze information, problems, issues, situations and procedures to develop effective solutions.
• Ability to exercise strict confidentiality in all matters.

Mobility

Primarily sedentary, able to sit for long periods of time with the ability to travel within and outsidethe facility.

Physical Requirements

Ability to speak, see and hear other personnel and/or objects. Ability to communicate both in verbal and written form. Ability to travel within the facility. Capable of using a telephone and computer keyboard. Ability to lift up to 10 lbs.

Environmental Conditions

Work-from-home (WFH) environment.

American Specialty Health is an Equal Opportunity/Affirmative Action Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex including sexual orientation and gender identity, national origin, disability, protected Veteran Status, or any other characteristic protected by applicable federal, state, or local law.

Please view Equal Employment Opportunity Posters provided by OFCCP here.

If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact our Human Resources Department at (800) 848-3555 x6702.

ASH will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the Company's legal duty to furnish information.

#LI-Remote #BDA #Database #SQL #MS