Application and Database Admin

Job Code: 13443 | Regular, full-time, exempt position reporting to the VP of IT Infrastructure.

About the role

Under general supervision, the Applications & Database Administrator I administers assigned applications and manages database systems to ensure availability, integrity, security, and consistent performance of the ISM Department’s applications. Provides basic applications support and performs related duties as assigned.

Responsibilities

• Administer and maintain enterprise database management systems (DBMS) to ensure availability, integrity, security, and performance across development, test, and production environments.
• Design, create, modify, and maintain database structures and objects (databases, tables, indexes, stored procedures, triggers, views) to support business applications and reporting needs.
• Analyze user, application, and business requirements; collaborate with developers, analysts, DevOps teams, and end-users to develop and maintain effective database solutions.
• Monitor, troubleshoot, and optimize database performance through tuning, execution plan analysis, capacity planning, and implementation of best practices.
• Manage database changes, deployments, and code migrations across environments, including testing, validation, implementation, and production support.
• Administer database security and access controls by provisioning user accounts, managing permissions, enforcing security policies, and participating in audits.
• Perform database backup, recovery, and disaster recovery operations, including planning, testing, validation, and execution of restoration procedures.
• Support database-related application services and integrations (transaction processing, ETL, data replication, reporting platforms, enterprise applications).
• Monitor database health and system operations using administrative tools, utilities, logs, and performance metrics to meet service-level objectives.
• Provide technical support and problem resolution for database and application-related issues, working with Help Desk, developers, administrators, and end-users.
• Document database configurations, procedures, standards, and technical findings; share knowledge with team members to support operational consistency.
• Support enterprise infrastructure operations and special assignments (software upgrades, patch management, high-availability environments, after-hours/on-call support, IT initiatives).

Requirements

• Bachelor’s Degree in Computer Science, Information Systems, or a closely related field.
• One (1) or more years of database management experience.
• Valid Commonwealth of Pennsylvania Driver's License.

Alternative Qualifications: An equivalent combination of education, training, and experience may be considered.

Skills

• Fundamentals of Oracle and SQL database server application systems.
• Transact-SQL (T-SQL) programming.
• Database management system architecture and design, including integration with internal/external systems.
• Enterprise-class database management and reporting systems (SSRS, Business Objects, Oracle BI, Power BI).
• General software programming concepts (proficiency in a programming language is an asset).
• System, application, and database log file analysis and interpretation.
• Creating and managing SQL Server database maintenance plans.
• Creating, modifying, and maintaining database objects (tables, stored procedures, triggers).
• Writing, executing, and troubleshooting scripts using PowerShell, CMD commands, and T-SQL.
• Implementing, administering, and supporting enterprise database management and reporting solutions.
• Reading, analyzing, and resolving issues identified in system, application, and database logs.
• Designing, implementing, and operating enterprise-class database management and reporting systems.
• Integrating database solutions with internal and external systems.
• Time management, organization, and attention to detail.
• Verbal and written communication, including presenting technical information to diverse audiences.
• Analytical thinking and structured problem-solving.
• Microsoft Office applications (Visio, PowerPoint, Excel, Word).

Work environment

• Primarily performed in a standard office environment with sedentary work involving sitting/standing.
• Communicating with others to exchange information.
• Occasional travel for meetings or training.

Preferred Qualifications

• Microsoft, Cisco, Oracle, or other professional IT certifications.