Database Architecture- Develop and maintain the overall database architecture strategy aligned with business goals. Design scalable and high-performance database solutions using Microsoft SQL and Azure SQL technologies. Ensure database architecture supports data growth, security, and healthcare compliance requirements Database Engineering- Lead the implementation of database solutions, including schema design, indexing strategies, and optimization. Oversee the performance tuning and monitoring of databases to ensure optimal efficiency. Implement and manage data replication, clustering, and other high availability and disaster recovery solutions Data Security- Establish and enforce data security policies and procedures. Implement encryption, access controls, and auditing to ensure data confidentiality and integrity. Regularly review and update security measures to address emerging threats Standardization of SQL Artifacts- Develop and enforce coding standards for SQL queries, stored procedures, functions, etc. Conduct regular code reviews to ensure compliance with coding standards and best practices. Provide training and guidance to the development team on SQL best practices Research Database Development- Design and implement a de-normalized, de-identified research database in Azure. Define and document the data synchronization process from various sources to the research database. Ensure compliance with privacy and healthcare regulations and implement de-identification techniques External Access and Collaboration- Architect and implement secure external access to the research database for authorized users. Collaborate with external partners and vendors to establish data exchange protocols securely. Develop and maintain documentation for external data access policies and procedures Database Analytics- Collaborate with data scientists and analysts to design and optimize database structures for analytics. Implement data warehousing and Big Data solutions and analytics tools compatible with Microsoft SQL and Azure SQL. Create and maintain reports and dashboards for business intelligence purposes Continuous Improvement- Stay updated on industry trends and advancements in database technologies. Continuously evaluate and recommend improvements to existing database systems and processes. Actively participate in disaster recovery planning and testing
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Job Type
Full-time
Career Level
Mid Level