Sr. Database Specialist

Rain Stella Tech; Islamabad; On-site; PKR 300,000 - 540,000; Full time

Job summary

Rain Stella Technologies is seeking a Senior Database Specialist to design, maintain, and optimize enterprise databases and analytical environments. You will collaborate with engineering, product, and analytics teams to ensure accurate, secure, and scalable data operations using Postgres, MongoDB, Tableau, and Power BI, with preferred healthcare data standards exposure.

Experience with HL7/FHIR, data warehousing, and data modeling is valued; the role offers a fast-paced environment in a

Qualifications

• Bachelor's degree in CS or related field required.
• 5-7 years of database engineering or data management experience.
• Advanced proficiency in SQL and Postgres administration.
• Strong experience with MongoDB and dashboard visualization using Tableau/Power BI.

Responsibilities

• Design, implement, and optimize relational database structures in Postgres.
• Develop advanced SQL queries, stored procedures, and performance tuning.
• Manage MongoDB collections, indexing, and schema strategy.
• Build and maintain dashboards using Tableau and Power BI.
• Collaborate on ETL/ELT processes and data pipeline optimization.
• Monitor data security, reliability, and capacity.

Skills

SQL & Postgres administration

MongoDB schema design

Tableau / Power BI dashboards

Education

Bachelor's degree in Computer Science or related field

Tools

Tableau

Power BI

ETL/ELT tools

Job description

Company Introduction: Rain Stella Technologies (RST) (rainstellatech.com) is a next-generation healthcare technology company born from the merger of Rain Technology and Stella Technology. With deep expertise in digital health infrastructure, AI, and voice-powered automation, RST empowers providers across the continuum of care - from outpatient clinics to surgical suites to national HIEs. RST currently works with 17 healthcare systems across five countries, with strong regional momentum and operational scale.

Overview: The Senior Database Specialist is responsible for designing, maintaining, and optimizing enterprise-level databases and analytical environments. This role requires extensive experience with SQL (Postgres), MongoDB, and analytical tools such as Tableau and Power BI. Knowledge of healthcare data standards is preferred. The specialist will collaborate across engineering, product, and analytics teams to ensure accurate, secure, and scalable data operations.

Key Responsibilities

Database Management & Engineering

• Design, implement, and optimize relational database structures in Postgres.

• Develop advanced SQL queries, stored procedures, and performance tuning solutions.

• Manage MongoDB collections, indexing, performance, and document schema strategy.

Analytics & Reporting

• Build and maintain dashboards using Tableau and Power BI.

• Translate business and product requirements into meaningful data visualizations.

• Ensure data reliability, accuracy, and accessibility for reporting needs.

Data Architecture & Integration

• Support database modeling, data warehousing, and architectural decisions.

• Collaborate with engineering teams on ETL/ELT processes and data pipeline optimization.

• Monitor database performance, security, and capacity.

Healthcare Data (Preferred)

• Work with healthcare data formats: HL7 v2, FHIR, CCD/C-CDA.

• Experience with medical coding systems such as ICD-10, SNOMED CT, LOINC, CPT/HCPCS.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field (Master's preferred but not required).

• 5-7 years of experience in database engineering or data management roles.

• Advanced proficiency in SQL and Postgres administration.

• Strong experience with MongoDB (schema design, indexing, optimization).

• Proven experience with Tableau and/or Power BI dashboard development.

• Solid understanding of data modeling, normalization, and database best practices.

Preferred Qualifications

• Experience in healthcare IT or interoperability environments.

• Knowledge of clinical standards and terminologies.

• Experience with cloud platforms (AWS, GCP) and associated data services.

• Exposure to integration engines (e.g., Mirth Connect).

Key Competencies

• Strong analytical and problem-solving skills.

• Detail-oriented with a focus on data quality and performance.

• Effective communication and documentation abilities.

• Ability to work independently and collaboratively in fast-paced environments.

• Strong ownership mindset with proactive issue resolution.