Database Administrator II

JOB SUMMARY

The Database Administrator II is responsible for Microsoft SQL Server database administration and business intelligence support, including data modeling, reporting, ad hoc data requests, and project team support. The role involves intermediate to advanced work in providing effective and efficient storage, retrieval, customization, and archiving of data by managing diverse data sets to ensure an integrated database system for all users. Key responsibilities include assisting in the development and implementation of database policies and procedures, ensuring data integrity throughout the maintenance and modification of existing applications, and contributing to organizational continuity through institutional knowledge preservation for critical database systems. The incumbent works under the direction of senior staff with increasing independence as proficiency is developed. This role is intended to develop expertise in UMPH’s database environment through structured knowledge transfer and mentorship from senior IT staff. This is a fully remote position requiring self-direction, intellectual curiosity, and the ability to work effectively in a distributed team environment.



ORGANIZATIONAL CONTEXT & AREAS OF IMPACT



Reporting Relationship & Peers

Reports to the Executive Director, Digital Commerce Systems, as do:


Technical Services Director
Business Systems Manager
IT Operations Manager
Database Administrator IV
Business Systems Analyst III




Reporting Directly to This Job


N/A



Areas of Impact (as applicable)

DEPARTMENT OPERATING BUDGET


$1.6M







RESPONSIBILITIES & SCOPE

Essential Job Functions

PRIMARY


Assists in the design and maintenance of existing database structures, with primary focus on Microsoft SQL Server environments. Assists senior IT staff in monitoring database performance and implementing efficiency improvements. Ensures that appropriate database management and business intelligence software is available and effectively used. Performs database performance monitoring and implements efficiency improvements. Performs data migrations for implementation of new systems. Supports the business with knowledge of how data interacts with the applications used by business units.
Assists in implementing and enhancing standards on database and business intelligence (BI) security. Assists in designing procedures to save and recover databases from hardware and software failures. Supports data warehouse operations and reporting infrastructure, including maintenance of reporting tools and data feeds that serve business units.
Participates in knowledge transfer and succession planning activities to build organizational depth in critical database administration competencies. Documents existing database architectures, processes, and institutional knowledge. Develops proficiency across UMPH’s interconnected database systems to ensure business continuity.


SECONDARY


Supports cross-functional IT project teams by providing database expertise for system integrations, upgrades, and new implementations. Assists applications programmers with database concepts, efficient access techniques, and problem resolution.
Researches emerging database tools, platforms, and best practices to inform technology decisions led by senior staff. Assists in evaluating software packages and planning migrations to new data management system software levels when directed.
Stays current on developments in database management and BI through self-directed learning, professional development, and engagement with technical communities. Performs related work as assigned.


These essential job functions are not intended to cover all work details or the occasional performance of other tasks as assigned by the supervisor. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions of this job.



Common or Complex Problem-Solving Challenges


Contributing to long-range database planning within an environment of multiple interconnected systems where changes to one platform can have cascading effects across the technology stack
Being highly flexible and adaptive to support the business when subject matter experts are not available in the business units
Navigating a diverse technology environment that includes both legacy and modern platforms with varying levels of documentation, where the DBA must develop working knowledge across systems such as ERP, ecommerce, and content management
Absorbing institutional knowledge of complex, interdependent database systems in a multi-platform environment while working effectively as a self-directed remote team member




Authority & Accountability


Authority to operate within the guidelines of UMPH and IT policies and procedures
Authority to perform necessary steps to ensure the integrity of UMPH databases under the direction of senior database staff
Authority to coordinate with outside vendors for data integrations in support of senior staff and management




Regular Contacts & Stakeholders

INTERNAL


Information Technology management and staff as well as management of other UMPH divisions


EXTERNAL


IT vendors – to ensure that UMPH database and business intelligence needs and requirements are met
Peers in professional organizations (e.g., Microsoft Developer Network, SQL Server community groups, online technical forums)
Subscriptions to relevant technology publications, newsletters, and online learning resources




JOB REQUIREMENTS

Education, Experience, & Certifications

REQUIRED


An Associate’s degree in computer science or related information technology field
Two (2) to four (4) years of experience working with Microsoft SQL Server
Additional experience may substitute for the required degree on a year-for-year basis


PREFERRED


Experience with Oracle databases is preferred but not required




Development Tools


Microsoft SQL Server Management Studio
Microsoft SQL Server Reporting Services
Microsoft SQL Server Integration Services
Microsoft SQL Server Analysis Services
Microsoft Visual Studio
Azure Data Studio




Knowledge, Skills, & Abilities

REQUIRED


Good understanding of various database architectures, with depth in Microsoft SQL Server
Good understanding of data security management and issues
Working knowledge of various backup and recovery methodologies
Working knowledge of database resource management, performance management, storage structures, and performance tuning
Proficiency in usage of T-SQL, SSRS, SSIS, and SSAS
Proficiency in writing and maintaining Linux shell scripts and Windows command scripts
Demonstrated ability to work independently and effectively in a fully remote environment with minimal supervision
Intellectual curiosity and a self-starter mentality with a desire to learn complex business systems and processes
Strong communication skills with the ability to collaborate effectively across distributed teams and business units
Willingness to explore emerging technologies including AI-assisted tools and data integration methods


PREFERRED


Familiarity with PL/SQL and Oracle database tools is preferred but not required
Experience using Microsoft Visual Studio and Azure Data Studio is preferred




Remote Work Requirements

This is a fully remote position. The following are required as conditions of employment:


Reliable access to high-speed internet service sufficient to support video conferencing, remote desktop sessions, and large data transfers
A personal mobile device (smartphone or tablet) capable of running multi-factor authentication (MFA) applications for secure access to UMPH systems
A dedicated, distraction-free workspace suitable for handling confidential business data




AI-Enabled Workplace

The United Methodist Publishing House is committed to maximizing the impact of artificial intelligence by adopting and integrating AI tools across our work. These technologies are vital to enhancing productivity, fostering creativity, and strengthening decision-making. All staff members are expected to engage thoughtfully and responsibly with AI as part of their professional responsibilities. Core expectations include:


Responsible AI Integration – Leverage AI tools strategically to streamline workflows, generate actionable insights, and deliver exceptional outcomes that advance our mission.
Critical Evaluation & Oversight – Apply professional judgment and critical thinking when reviewing, refining, and validating all AI-generated content and recommendations to ensure accuracy and alignment with our standards.
Continuous Learning & Innovation – Maintain curiosity and adaptability toward emerging AI technologies, actively contributing to innovative practices within your area of expertise while supporting organizational growth.
Ethical & Secure Practice – Uphold UMPH’s commitment to ethical, transparent, and secure AI usage, ensuring all applications align with our mission, values, and community standards.




Equal Employment Opportunity

UMPH is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.





Apply Now