Principal Database Administrator, Healthcare
Providence
MySQLOracleRDBMSSQL
Senior Database Architect
Jenzabar
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $91,000 - $108,000 per year
Job Level
Senior
Tech Stack
MS SQL ServerSQL
About the role
- Collaborate with design and development teams to create database designs that meet specified business and technical requirements
- Perform database modeling and effectively communicate schema structures to development teams, ensuring clarity in how schemas support application development
- Apply a thorough understanding of relational database concepts, implementing them using SQL DDL to support project goals
- Gather requirements from software product managers and architects, and design relational database objects tailored to software objectives
- Maintain and update databases used by the product development team across multiple versions of Jenzabar software
- Work closely with the Quality Assurance team to test and verify database changes for each release cycle
- Provide support in troubleshooting and resolving complex database issues within the customer base
- Collaborate with the Data Services team on technical challenges related to data conversions
- Stay informed about new releases of Microsoft SQL Server and evaluate their potential impacts on Jenzabar software
- Design enterprise-wide database solutions aligned with application design goals
Requirements
- Bachelor’s degree in Computer Science, Information Technology, or a related field
- Expertise in teaching and applying SQL DML, DDL, and DCL commands, along with skills in writing optimized code for triggers, views, functions, and stored procedures
- Proven ability to design and code complex database procedures, triggers, and views
- Experience teaching SQL database administration tasks and mentoring junior team members
- Deep understanding of database delivery concepts and structures, particularly in multi-server environments (deployment across hundreds of customer systems)
- Strong proficiency in SQL permissions creation and maintenance
- Extensive experience in installing, configuring, troubleshooting, and maintaining Microsoft SQL Server database systems
- Advanced understanding of relational database concepts and the ability to gather and implement design requirements in collaboration with software product managers and architects
- Skilled in designing relational database objects that support software design goals and meet enterprise-wide application requirements
Benefits
- Medical Insurance
- Life Insurance
- Dental Insurance
- Vision Insurance
- PTO
- Paid Parental Leave
- Paid Holidays
- Short Term Disability
- Long Term Disability
- 401K
- Educational Assistance
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQL DDLSQL DMLSQL DCLdatabase modelingdatabase designtriggersviewsfunctionsstored proceduresMicrosoft SQL Server
Soft skills
collaborationcommunicationtroubleshootingmentoringproblem-solvingclarity in communicationsupportteamworkadaptabilityattention to detail
Certifications
Bachelor’s degree in Computer ScienceBachelor’s degree in Information Technologyrelated field degree
