Database Administrator Job

Database Administrator is needed to perform the following duties:
• Architecting and documenting database structure.
• Design and maintain secure, HIPAA-compliant databases for patient records, prescriptions, inventory, and billing in SQL Server/Oracle.
• Implement audit trails, encryption, and access controls to meet DEA/FDA requirements for controlled substances.
• Optimize SQL queries and indexing to ensure real-time processing of e-prescriptions, insurance claims, and inventory tracking.
• Troubleshoot bottlenecks affecting pharmacy workflow (e.g., slow prescription processing).
• Enforce strict data security protocols to protect PHI (Protected Health Information) per HIPAA Security Rule.
• Conduct vulnerability assessments and patch management to prevent breaches.
• Integrate databases with e-prescribing software (Surescripts, EPIC), POS systems, and EHRs (Electronic Health Records).
• Develop APIs for third-party vendors (e.g., insurance providers, drug wholesalers).
• Generate compliance reports for audits (e.g., controlled substance logs, prescription trends).
• uild dashboards for management using Power BI, Tableau, or SSRS.
• Evaluates and recommends new database technologies.
• Implements and maintains database security and encryption.
• Develops, manages and tests database and information system backup and recovery plans.
• Develops standards and policies for data entry and ensures compliance.
• Maintain 24/7 uptime for critical pharmacy systems with failover clustering and automated backups.
• Prepares and distributes reports, including but not limited to weekly and monthly status reports to the IT Operations Director.
• Attends seminars, conferences, in-service training and staff meetings as required
• Train pharmacy staff on proper data entry and system use.
• Document database schemas, compliance policies, and SOPs.

Bachelor's degree is required in Computer Science or Computer Engineering or Information Technology or Information Systems