Database Administrator
CurrentAs a Database Administrator at Rochester RHIO, I maintain and optimize the performance of secure health information exchange systems, serving 14 counties in the Finger Lakes Region with 1.5 million patients. My responsibilities include monitoring, administering, and optimizing database systems, and redesigning database structures.Key Responsibilities:🔧 Database Management: Oversee administration and optimization of database systems for high performance and security.📊 System Performance: Monitor and enhance database performance, implementing necessary updates.🔒 Data Integrity and Security: Ensure the integrity and security of patient data, adhering to compliance standards.🛠️ Technical Leadership: Provide technical guidance to cross-functional teams, ensuring effective database solutions.Select Highlights:📈 NYEC Deliverables: Met NYEC deliverables, state regulations, and public health initiatives, providing data analytics and ETL services.💾 Database Management: Managed a complex patient database system with over 1.5 million records across 150+ databases.📦 Data Migration: Successfully migrated data for 50+ databases using AWS services, optimizing efficiency and database management.🧠 Technical Expertise: Led initiatives to redesign and develop database structures, enhancing scalability and performance.🤝 Collaboration: Coordinated disaster recovery plans with CIO/CISO, reducing system downtime by 40%.Skills Developed:🔍 Data Analysis📅 Project Management📊 Reporting and Dashboards🔧 Technical Problem SolvingTechnical Proficiency:🗄️ Databases: MSSQL, PostgreSQL💻 Programming: Python☁️ Cloud: Amazon Web Services (AWS)📊 Analytics: Tableau, Snowflake🩺 EHR Systems: EPIC, VBMS📈 Software: Microsoft Office Suite