ResMed has always applied the best of technology to improve people's lives. Now our SaaS technology is fueling a new era in the healthcare industry, with dynamic systems that change the way people receive care in settings outside of the hospital-and tools that work every day to help people stay well, longer. We have one of the largest actionable datasets in the industry, creating a complete view of people as they move between care settings. This is how we empower providers-with vital insight to deliver the care people need, right when they need it.
We're also ensuring that our health solutions connect to other companies' networks. Because when objectives align, everyone wins. And as we work today to drive better care and lower costs, we're developing more personalized solutions for tomorrow, utilizing machine learning, intelligent care paths, and predictive protocols. If you are an innovator who wants to make an impact we want to talk to you! We have exciting opportunities supporting Brightree by ResMed and MatrixCare by ResMed!
The primary role of the Database Management function is to design, implement, and maintain SQL Server technologies. Key deliverables include providing support for application DBA tasks, such as application cloning, patching, and database migration, as well as monitoring all production database backups globally and troubleshooting technical issues with applications and databases.
Let's talk about Responsibilities
* Microsoft SQL Server administration and maintenance functions of production and QA databases in a 24/7 mission-critical environment
* Participate in database server architecture and design, as well as server environment recommendations for the overall infrastructure solution, including storage capacity planning.
* Responsible for database alerts, maintenance plans, and scripts
* Manage database security and control access permissions and privileges
* Maintain the health, performance, and integrity of the database systems
* Responsible for the availability, reliability, and integrity of business data stored in production databases
* Communicate regularly with the development team, business, and operations team to ensure the security and confidentiality of data
* Resolve production database issues with team members and implement improvements to prevent a recurrence of the issue
* Backup and restore databases as necessary
* Design and develop architecture for data warehouse, including source data ETL strategy, data movement,t and aggregation, as well as data quality strategy
Let's talk about Qualifications and Experience
Required:
* 2 years of experience working as a hands-on MS SQL Server Database Administrator
* Experience with Triggers, Stored Procedures, and SQL Server Queries
* Experience in a 24/7 high-availability production database environment
* Ability to think logically and analyze business process requirements and convert them toan accurate database structure and logic
* Strong interpersonal and communication skills
* Experience with scripting languages (e.g. SQL, PowerShell, Python) for automation
Preferred:
* Experience in replication, data warehouse, and scalability - Disaster Recovery
* Strong skills and experience in performance tuning - Index, Table, Query, and Stored procedures
* Data modeling skills for enterprise data warehouses and data marts
* Experience with MySQL
* Knowledge of SSIS, SSAS, and SSRS
* Familiaritywith Agile development framework
We are shaping the future at ResMed, and we recognize the need to build on and expand our existing skills while continuing to attract and retain the world's best talent. We work hard to offer comprehensive benefits packages, provide flexible work arrangements, foster a culture that encourages employees to grow both personally and professionally, and provide competitive salaries to our team members. Employees scheduled to work 30 or more hours per week are eligible for benefits. This position qualifies for the following benefits package: comprehensive medical, vision, dental, and life, AD&D, short-term and long-term disability insurance, sleep care management, Health Savings Account (HSA), Flexible Spending Account (FSA), commuter benefits, 401(k), Employee Stock Purchase Plan (ESPP), Employee Assistance Program (EAP), and tuition assistance. Employees receive fifteen days of Paid Time Off (PTO) in their first year of employment, receive 11 paid holidays plus 3 floating days, and are eligible for 14 weeks of primary caregiver or two weeks of secondary caregiver leave when welcoming new family members.
Individual pay decisions are based on a variety of factors, such as the candidate's geographic work location, relevant qualifications, work experience, and skills.
At ResMed, it is not typical for an individual to be hired at or near the top of the salary range for their role, and compensation decisions are based on the specific facts and circumstances of each case.
Joining us is more than saying "yes" to making the world a healthier place. It's discovering a career that's challenging, supportive, and inspiring. Where a culture driven by excellence helps you not only meet your goals, but also create new ones. We focus on creating a diverse and inclusive culture, encouraging individual expression in the workplace, and thrive on the innovative ideas this generates. If this sounds like the workplace for you, apply now! We commit to responding to every applicant.
Joining us is more than saying "yes" to making the world a healthier place. It's discovering a career that's challenging, supportive and inspiring. Where a culture driven by excellence helps you not only meet your goals, but also create new ones. We focus on creating a diverse and inclusive culture, encouraging individual expression in the workplace and thrive on the innovative ideas this generates. If this sounds like the workplace for you, apply now! We commit to respond to every applicant.