Nosql database administrator

Job description

R1 is a leading provider of technology-driven solutions that help hospitals and health systems manage their financial systems and improve patients’ experience.

We are the one company that combines the deep expertise of a global workforce of revenue cycle professionals with the industry's most advanced technology platform, encompassing sophisticated analytics, AI, intelligent automation, and workflow orchestration.

R1 is a place where we think boldly to create opportunities for everyone to innovate and grow—a place where we partner with purpose through transparency and inclusion.

We are a global community of engineers, front-line associates, healthcare operators, and RCM experts who work together to go beyond for all those we serve.

Because we know that all this adds up to something more, a place where we're all together better.R1 India is proud to be recognized amongst the Top 25 Best Companies to Work For 2024, by the Great Place to Work Institute.

This is our second consecutive recognition on this prestigious Best Workplaces list, building on the Top 50 recognition we achieved in 2023.

Our focus on employee wellbeing and inclusion, and diversity is demonstrated through prestigious recognitions with R1 India being ranked amongst Best in Healthcare, Top 100 Best Companies for Women by Avtar & Seramount, and amongst Top 10 Best Workplaces in Health & Wellness.

We are committed to transforming the healthcare industry with our innovative revenue cycle management services.

Our goal is to ‘make healthcare work better for all’ by enabling efficiency for healthcare systems, hospitals, and physician practices.

With over 30,000 employees globally, we are about 16,000+ strong in India with presence 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.We are looking for a Senior Database Engineer to administer and maintain No SQL and relational SQL Server/My SQL Databases.

The candidate will be part of the team providing operations support on multiple No SQL clusters running on Azure and will be responsible for installing, configuring, monitoring, designing, implementing, and supporting our mission-critical Mongo DB, Cosmos, Couchbase, and SQL Server environments.

The ideal candidate should be a fast learner, eager, passionate about automating development and production environments, and enjoy the challenge of working in a highly distributed and dynamic Hybrid Cloud environment.

As part of a service-oriented team, the role will require the individual to collaborate effectively with other internal engineering teams to gather requirements to deliver on various database platforms.

There will be plenty of opportunities for developing your skills, as we look to improve constantly with the latest technologies.

Essential Responsibilities Create, administer, monitor, and maintain multiple Elasticsearch, Mongo DB, and Cosmos and Couchbase environments.

Work with development teams to design and implement optimized No SQL databases.

Implement relational databases, tables, and table changes.

Support application development for problem solving and performance tuning.

Assist in administering, monitoring, and maintaining SQL Server environments, including for disaster recovery.

Work on new and existing logical/physical database designs for applications and infrastructure.

Provides after-hours support for database emergencies, routine scheduled maintenance, and database server patching.

Works closely with the business and engineering teams to understand and plan for storage and database needs.

Implementation, configuration, maintenance, and performance of SQL Server RDBMS systems, to ensure the availability and operational readiness (security, health, and performance) of our corporate applications in the cloud (managing Cloud Infrastructure related to SQL Data Services in Azure).

Assist app dev teams with complex query tuning and schema refinement.

Utilize various tools to evaluate performance and implement remedies to improve performance, including tuning database parameters and SQL statements.

Required Qualifications 5+ years of experience working in Database, Data Management, or Engineering roles.

5+ years of progressive experience in high volume/high transaction data administration, with at least 3 years working with Microsoft Azure Cloud technologies.

5+ years of experience managing No SQL databases such as Couchbase, Mongo DB, and Cosmos DB.

2+ years of experience in Elastic Search.

5+ years of experience in performance tuning and database monitoring utilizing techniques with query analysis, indexes, statistics, and execution plans.

Prior experience working with large (2tb+) transactional databases and across a large environment with hundreds to thousands of databases in-scope.

DESIRED TECHNICAL SKILLS Ability to troubleshoot performance issues with No SQL databases (Elasticsearch, Mongo DB, Cosmos, and Couchbase) Accurately recommend configuration changes for optimal performance of No SQL databases (Elasticsearch, Mongo DB, and Cosmos and Couchbase) Experience in the design, testing, implementation, maintenance, and control of the organization's No SQL databases across multiple platforms, technologies (for example, physical, relational, and object-oriented), and computing environments.

Ability to develop queries to extract information based on compounded search criteria.

Strong expertise with relational databases (Microsoft SQL Server, My SQL is a plus) with enhanced troubleshooting and performance tuning skills.

Fundamental proficiency in data modeling in practical applications of a moderate nature.

Firm understanding of the most prominent Azure database technologies, such as Azure SQL Database and Azure SQL Managed Instance.

Backup, restore, secure, scale, monitor, and tune an Azure SQL Database Experience translating environments into Azure Managed Instances and other Azure technologies will be given a strong preference.

Nice to Haves Certifications in Azure/SQL Server/No SQL Experience with Postgres and My SQL is a big plus, but not mandatory.

Knowledge of SQL monitoring tools Solar Winds DPA, Red Gate, etc.

Service now and Azure Dev Ops experience

Required Skill Profession

Finance