Corporate Development Database Administrator

The Corporate Development Database Administrator (DBA) is responsible for the development, implementation, configuration, monitoring, maintenance, and performance of critical database systems in SQL Server, MySQL, Azure SQLMI and Azure databases. This includes Application databases and Data Warehouses. They ensure that applications have high availability and consistency by reducing down time and that the data warehouses are highly performant in data ingestion, transformation and query support.

MUST be able to work in the US without sponsorship restrictions (H1b, J-1, F-1, etc)

Salary Range: $125,000-$135,000

Primary Responsibilities:

• Primarily responsible for safeguarding the development, availability, and performance of all databases - those that support applications and also data warehouses.

• Work with application and data warehouses development teams to optimize the use of database systems and ensure all development is as performant, consistent and timely as possible

• Assist with database migrations - to new cloud services, new cloud accounts, new database services, new data structures (fabric, etc.)

• Build on our systems to help teams quickly pinpoint, isolate and resolve issues related to infrastructure, platform services and applications.

• Continually maintain and improve software build methodology, procedures, and environment.

• Data architecture(Modelling), Design, develop, and maintain product packaging, installation, upgrades, management and administration scripts and utilities.

• Deploy, manage, and upgrade systems, services and servers using automated configuration management and service orchestration tools.

• Monitor and alert based on system metrics, analysis of logfiles and custom alert rules.

• Ensure uptime SLA for the SaaS infrastructure, services, and applications as part of the global team.

• Provide mentorship and be knowledgeable of data modeling best practices Preferred skills and experience.

• Perform other related duties as assigned.

Required Qualifications:

• BS or MS in Computer Science, Engineering, or a related technical discipline or equivalent experience

• 5+ years of experience as a DBA with SQL Server 20XX,2019, Azure SQL Server, MySQL

• Experience with deployment and upgrade of engine & clients

• Experience with SSIS Packages, T-SQL, stored procedures, triggers, views, constraints and functions and the impact on consistency, reliability, and performance

• Experience supporting and working with cross-functional teams in a dynamic environment

• Experience building processes supporting data transformation, data structures, metadata, dependency and workload management

• Experience with data gathering, data profiling, cleansing and transforming techniques

• Data-driven, results-oriented with the ability to quickly analyze data and make decisions that drive performance

Benefits:All employees enjoy a competitive salary, eligibility to participate in the 401(k) savings plan with a match. Full Time employees are also eligible for a comprehensive benefits package, including Medical, Dental and Vision Insurance, Time Off Plan, Company Paid Short- and Long-Term Disability, Basic and Supplemental Life Insurance, Medical Flex and Dependent Care Accounts and more.

About CPS: Founded nearly 50 years ago and employing over 2,500 clinical, regulatory, and operational pharmacy professionals, CPS Solutions, LLC is one of the nation's largest providers of pharmacy services to more than 800 hospitals and healthcare facilities nationwide. CPS helps clients tackle a variety of complex issues, such as operational efficiency, rising drug costs, regulatory & compliance, 340B, and specialty pharmacy strategy. CPS helps healthcare leaders drive best in class pharmacy operations through skill, expertise and proprietary technologies. For more information, visit https://www.cpspharm.com

We are an Equal Opportunity Employer and do not discriminate against any qualified employee or applicant for employment because of race, color, sex, age, national origin, ancestry, religious creed, sexual orientation, gender identity and/or expression, status as a veteran, mental or physical disability or any other federal, state or local protected class.