Postgresql Developer

Job Description

R1 RCM India is proud to be recognized amongst India's Top 50 Best Companies to Work For 2023 by Great Place To Work Institute. We are committed to transform the healthcare industry with our innovative revenue cycle management services. Our goal is to make healthcare simpler and enable efficiency for healthcare systems, hospitals, and physician practices. With over 30,000 employees globally, we are about 14,000 strong in India with offices in Delhi NCR, Hyderabad, Bangalore, and Chennai. Our inclusive culture ensures that every employee feels valued, respected, and appreciated with a robust set of employee benefits and engagement activities.

Were looking for a self-motivated Sr. DBA to join our Global DBA team. We have a relentless focus on driving results for our customers and enabling them to invest more into patient care; in turn, this allows us to continue to grow our company and your career.

By reporting to the Manager, DBA/Middleware Operations, the candidate will be responsible for managing the SQL Server, MySQL and Postgres database instances hosted on prem and in cloud from all the aspects. This role will require troubleshooting and a high sense of responsibility for the problems as requests. Communication and timeliness are a must in problem solving, initiating change, and escalation.

Your day-to-day role will include:
•Manage multiple RDBMS platforms (MSSQL, MySQL and Postgres etc.) through multiple product lifecycle environments, from development to mission-critical production systems.
•Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
•Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
•Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
•Refine and automate regular processes, track issues, and document changes.
•Assist developers with complex query tuning and schema refinement.
•Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
•Provide rotation-based 24/7 on call support for unplanned outages and planned maintenance/release events.
•Collect and report database performance KPI’s on regular basis.

You Have:
•Bachelor’s degree in information technology or related discipline.
•8+ years of database administration experience preferably in MSSQL, MySQL and Postgres.
•At least 2 years of cloud based database administration experience.
•Experience in troubleshooting and resolving database problems
•Experience in implementing operational automation using scripts.
•Hands on experience with SSIS,SSRS,SSAS and PowerShell.
•Extensive experience with Windows/SQL*Server Clustering (On Physical & Cloud based VM’s), Always ON, Replication, Mirroring.
•Experience with Performance Tuning and Optimization (PaaS & IaaS).
•Experience with backups, restores and recovery models
•Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
•Experience working with Windows server, including Active Directory
•Excellent written and verbal communication
•Flexible, team player, “get-it-done” personality
•Ability to organize and plan work independently
•Ability to work in a rapidly changing environment
•Ability to multi-task and context-switch effectively between different activities and teams

It would be great if you also have:
• Healthcare experience
• DBA certifications

We offer:
R1 is changing healthcare by infusing operational discipline and proprietary technology in HEALTCARE financial processes. We are an industry leader; we are the only independent organization with a comprehensive service and technology offering for HEALTCARE revenue cycle management, and we have achieved leading outcomes for our customers.
• A fast paced, growing organization that will keep you on your toes with new ideas, changes and opportunities to learn and grow in abundance.
• A customer base with domestic locations plus international operations, allowing for travel for certain roles.
• A culture of innovation, driving customer success so they can focus on improving patient care and on giving back to the community.
• A Total Rewards package including competitive compensation programs with base salary and bonus opportunity, the ability to choose from a variety of healthcare/dental/vision programs that are primarily funded by R1, work life balance with paid time off for vacations, illness and volunteering, 401k program with company match and much more!

Sound like you? Let’s talk!

About R1RCM:
R1 is a leading provider of revenue cycle services and Physician Advisory Services to healthcare providers. R1’s mission is to help healthcare providers strengthen their financial stability so they can deliver better care at a more affordable cost to the communities they serve, increasing healthcare access for all. R1’s distinctive operating model includes people, processes, and sophisticated integrated technology/analytics that help customers realize sustainable improvements in their operating margins and improve the satisfaction of their patients, physicians, and staff. R1’s customers typically are multi-HEALTCARE systems, including faith-based or community healthcare systems, academic medical centers and independent ambulatory clinics, and their affiliated physician practice groups.