Sr Database Administrator

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.

Salary Range

American Specialty Health complies with state and federal wage and hour laws and compensation depends upon candidate’s qualifications education skill set years of experience and internal equity. $112500 to $155000 Full-Time Annual Salary Range

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 outside the 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