Database Administrator

Orange Cut Rate Drugs Inc
Lubbock, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 78K

Job location

Lubbock, United States of America

Tech stack

Microsoft Windows
Data analysis
Databases
Computer Engineering
Data Integrity
ETL
Data Loss
Relational Databases
Human-Computer Interaction
Microsoft SQL Server
MySQL
Power BI
SQL Stored Procedures
SQL Databases
T-SQL
Computer Networking Systems
Database Optimization
Database Performance
Information Technology
Data Analytics
Real Time Data
User Administration
Custom Reports

Job description

· Design and optimize relational database schemas (SQL Server/MySQL), develop and fine-tune T-SQL queries, stored procedures, and indexing strategies to reduce latency, improve efficiency, and manage overall database performance settings.

· Administer and maintain pharmacy systems including BestRx, PrimeRx, Rx 30, and integrated DME platforms, customizing configurations to align with specific operational needs and ensuring real-time data availability, security, and HIPAA-compliant operations.

· Manage and improve the interface between network systems and both local and remote databases, overseeing ETL processes to ensure accurate and seamless integration of structured health data across cloud and local storage environments.

· Conduct regular data audits and generate custom reports and dashboards using SQL views and business intelligence tools such as Power BI to deliver actionable insights for executive decision-making.

· Develop and implement strategies for data integrity, backup, and recovery to prevent data loss, handle database maintenance including user access management, and conduct daily data extractions and trend analysis to monitor system health and fix bugs.

· Ensure all automated systems, data logic, and operational workflows conform with ICD-10 medical coding standards, insurance rules, healthcare billing requirements, and HIPAA regulations to maintain privacy and regulatory compliance.

· Oversee the full data lifecycle for durable medical equipment (DME), including inventory management, patient information, billing, and supply chain data analysis to improve efficiency, regulatory compliance, and customer service.

· Manage and update the pharmacy's website, integrating new features, optimizing the user interface, and developing components that support pharmacy services, functionality, security, and accessibility.

· Provide user training and technical support to enhance staff skills and overall database and system usability and lead ongoing improvement efforts by recommending and implementing system upgrades.

Requirements

Do you have experience in Windows?, Do you have a Bachelor's degree?, Bachelor's Degree is required in Computer Science or Information Technology or Computer Engineering or Data Analytics and Visualization

Apply for this position