Database Administrator

BANDSTAND, LLC
New York, NY, United States
3 months ago
Apply on indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Part-time (≤ 32 hours)
Compensation
$93,600.0 - $104,000.0
Working hours
Regular working hours
Job source

Tech stack

Query Performance Backup Devices Information Systems Databases Computer Engineering System Configuration Data Governance Data Recovery Database Design Distributed Data Store Interoperability Inventory Management Software
+7 more
Operational Data Store SQL Databases Database Optimization Database Performance Information Technology Build Tools Data Pipelines

Job description

Overseeing the structural integrity and day to day performance of pharmacy database systems is a key responsibility of this role. This includes writing and tuning SQL queries, defining indexing strategies, and monitoring database performance to identify and resolve issues before they impact operations. Position also involves planning for long term data growth and maintaining database stability as transaction volumes increase across pharmacy operations and prescription management systems.

Pharmacy management platforms increasingly rely on web connected database layers to deliver real time access to prescription records and inventory data. This position requires designing and maintaining the backend database architecture that keeps those systems accurate, fast, and synchronized across multiple access points.

Patient records, prescription logs, insurance claims, and inventory transactions generate data volumes that a traditional single server database cannot handle alone. Implementing the storage and retrieval strategies that keep that data accessible as volumes grow is a core responsibility of this position.

Developing database solutions for pharmacy operations means translating workflows prescription intake, inventory replenishment, billing cycles into well structured data models. The person in this role works across departments to gather requirements and build systems that reflect how the organization actually runs, not just how it’s assumed to run.

Pharmacy databases contain years of operational history fill rates, patient volumes, drug demand patterns, billing trends. Extracting meaningful signals from that data and using them to guide decisions about database structure and capacity is a growing part of this position.

Beyond the database itself, pharmacy environments carry strict data governance requirements access controls, retention policies, system interoperability, and regulatory compliance all have to be accounted for at the database design level. This position is responsible for ensuring the database layer operates within those boundaries from day one.

At its most fundamental level, this role requires ensuring that pharmacy databases remain available, accurate, and recoverable under any condition. Transaction integrity, failure handling, and data recovery procedures are baseline competencies the kind that have to be second nature before more complex optimization work is even possible.

Pharmacy database environments are not static new data sources, additional systems, and steadily increasing operational data volumes arrive continuously. Configuring distributed storage infrastructure and managing data ingestion pipelines to absorb that growth without disrupting active operations is an ongoing part of this position.

Prescription histories, patient cohort data, and inventory records contain patterns that can inform operational decisions provided someone knows how to look for them. This role includes applying structured analytical techniques to pharmacy data to surface those patterns in ways that complement and guide database administration decisions.

Query performance in a pharmacy database does not happen by accident. How records are indexed, how search structures are organized, and how lookup mechanisms are designed all determine whether a query resolves in milliseconds or grinds through minutes of processing. Applying those structural principles at the implementation level is a core technical requirement of this position.

Requirements

Do you have experience in SQL?, Do you have a Bachelor’s degree in information technology?, Bachelor’s Degree is required in Computer Science or Information Technology or Information Systems or Computer Engineering

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

48 sec

Exploring alternative build tools and experimental web components

Sasha Shynkevich · LIVE

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · World Congress 2024

7:52 min

Audience questions on database performance, deployments, and data migrations

Gregor Bauer Gregor Bauer · LIVE

1:52 min

Evolution of distributed SQL database management systems

Akmal Chaudhri Akmal Chaudhri · LIVE

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · World Congress 2022

Videos

See all

Related articles

See all