Who We Are
DisclosedRx, a fast-growing Pharmacy Benefit Management company, is looking for a motivated and experienced Development Database Administrator.
Position Summary
The Development Database Administrator II role 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.
Responsibilities:
- Primarily responsible for safeguarding the development, availability, and performance of all databases that support applications and 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.
Minimum Required Qualifications and Skills
- 4+ 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, purposeful with the ability to quickly analyze data and make decisions that drive performance.
Join us in this exciting opportunity to leverage your expertise in database management while contributing to the success of our organization!
Job Type: Full-time
Pay: From $125,000.00 per year
Benefits:
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Schedule:
- 8 hour shift
- Monday to Friday
- Weekends as needed
Application Question(s):
- 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 building processes supporting data transformation, data structures, metadata, dependency, and workload management?
- Experience with data gathering, data profiling, cleansing, and transforming techniques?
Experience:
- DBA with SQL Server 20XX,2019, Azure SQL Server, MySQL ?: 4 years (Preferred)
Work Location: Remote
