The Catholic University of America

Assist in developing, implementing, administering, and maintaining procedures for ensuring the security and integrity of databases supporting university enterprise applications. Apply academic concepts, master's coursework, and university project experience to support data models, database designs, basic tuning, backup and recovery, and troubleshooting tasks under the guidance of senior staff.

The projected salary or hourly pay range for this position which represents the full range of anticipated compensation is: $63,000 - $70,000.

Administer Databases

• Support senior administrators in installing, configuring, and maintaining database software, leveraging foundational knowledge acquired through university master's studies.
• Assist with the creation and management of databases as needed to support university enterprise applications and other Technology Services initiatives.
• Help execute database backup strategies and perform routine maintenance operations aligned with institutional standards.
• Assist in investigating database performance or application issues, utilizing rootcause analysis techniques.
• Monitor, analyze and report on utilization and performance trends of the databases and related infrastructure, identify potential performance or capacity problems, design and implement changes to avert problems.
• Keep technical documentation, database inventories, and configuration logs updated under the direction of senior team members. Maintain up-to-date technical knowledge of the database software in use at the university.
• Coordinate with external vendors to resolve technical problems. 

Administer ERP Systems

• Assist with the installation, configuration and maintenance of ERP and business system software.
• Monitor, analyze and report on utilization and performance trends of the ERP systems, identify potential performance or capacity problems, design and implement changes to avert problems. Conduct regular performance tuning.
• Take appropriate, timely action to resolve hardware, software and system problems when they occur; perform root cause analysis and follow up to ensure the issues are addressed at the root level.
• Learn and assist with day-to-day security requests, account provisioning, and adherence to information security policies.
• Maintain inventory and documentation of installed ERP and business systems and related infrastru
• cture, including versions and instance lifecycle; keep documentation updated and accurate.
• Maintain up-to-date technical knowledge of the ERP software in use at the university.

Design and implement enhancements to the databases and related enterprise application infrastructure.

• Participate in projects to implement, test and design ERP and business systems.
• Assist with the design and development of plans to enhance or update the database and enterprise application infrastructure.
• Work on assigned activities for projects and making sure that the work accomplished meets specifications.
• Ensure appropriate documentation, including configuration settings, is written and maintained.
• Perform migration to the production environment of new or enhanced systems and services, ensuring minimal disruption to current operations and adhering to established change control practices and procedures.
• Follow information security/information assurance policies, principles, and practices in the delivery computing services. 

Provide Expert Technical Support, in a pleasant, professional and courteous manner. 

• Acts as support for escalated issues related to ERP and business systems security that are assigned.
• Provide technical support for other Technology Services departments and groups, including the Service Desk, as required. Serve as technical liaison to non-university vendors or technical organizations as required.
• Serve as security administrator for applications as assigned.
• Process assigned service request tickets according to established procedures and SLAs.
• Participates in project meetings, security design conversations and integration with third party applications and hosted services.

Perform day-to-day security related activities and process requests for ERP environment.

• Ensures all security request are complete and have met the audit requirements for approval – manager and data steward.
• Provisions and de-provisions ERP accounts.
• Ensures that appropriate roles, permission lists, and row level security exists for all functional areas.
• Appropriately manages ERP Security based on the request received - row level, query level, roles and permission lists and user profiles.
• Analyzes and resolves security and access problems.
• Maintains security structures for delivered and customized ERP applications.
• Maintains and migrates security across multiple databases in support of database refresh activities.
• Participates in project and major release efforts, to include participation in project meetings and User Acceptance Testing.
• Routinely audit security in all environments, ensuring that all users are appropriately provisioned for their work function.
• Work closely with IT security auditors (internal and external) to support their requests during an audit.
• Work closely with support teams to better understand complex security requests and modularize the provisioning process.
• Develop automation for routine or complex security-related activities and processes.
• Anticipates the implications and consequences of situations and takes appropriate action to be prepared for possible contingencies.
• Provides metrics to support the numbers of requests received, processed and serviced.

Other administrative duties:

• Work independently or in teams to carry out assignments within the framework established by the supervisor and in conformance with established practices and procedures; bring unexpected or controversial findings to the supervisor’s attention.
• Provide regular progress and status reports to the supervisor.
• Create and present written or oral briefings.
• Cross train staff in infrastructure technologies as required.
• Participate in Enterprise Applications group meetings and activities.
• Participate in interdepartmental Technology Services meetings and project teams as directed, including representing the Enterprise Applications group in Change Control and Operations Quality Review meetings as directed. Follow University and Technology Services staff guidelines and requirements.
• Perform other job-related duties as assigned by supervisors. 

Formal Education:

• Bachelor’s Degree in Information Technology, Computer Science or a related field.
• Master’s Degree preferred

Practical Experience: (Years needed and type required)

• At least 2 years’ experience administering databases (Oracle and/or MS SQL Server) in support of a multitiered ERP environment.
• At least 2 years’ experience as ERP and business applications administrator.
• Experience writing SQL queries, generating reports and writing scripts to automate processes.
• Two years’ experience can be substituted by a Master’s degree in Information Technology, Computer Science or a related field.

Technical Qualifications or Specialized Certification:

• Knowledge of, and materially demonstrable skill in applying, the following:
  • IT concepts, principles, methods, and practices.
  • Information security principles and methods.
  • Performance monitoring principles and methods
  • Relational database principles, methods, and practices.
  • Database backup, recovery and high availability principles, methods, and practices.
  • ERP principles, methods, and practices.
  • Software development lifecycle (SDLC) principles, methods, and practices.
  • Operational task automation through programming and scripting principles and methods.
  • Principles, methods, and tools for developing, scheduling, coordinating, and managing projects and resources.
• Knowledge of, and materially demonstrable experience implementing and configuring, the following technologies:
  • Oracle Database, 12c and later.
  • Microsoft SQL Server, 2016 and later.
  • PeopleSoft Internet Architecture and People Tools preferred
  • Database and ERP monitoring/management tools, especially SolarWinds preferred

Experience implementing and configuring the following technologies is a plus:

• Windows Server 2016 or later in an Active Directory environment.
• Linux server, especially Red Hat Enterprise.
• Infrastructure as a Service (IaaS) services, especially Amazon Web Services or Microsoft Azure.
• NoSQL databases.

Current, professional-level certification in database administration is highly desirable, e.g.,

• Oracle Database Administrator Certified Professional
• Microsoft Solutions Expert (MCSE): Data Platform [SQL Server]

One or more of the following certifications is desirable:

• Information security certification, e.g., CompTIA Security+, CompTIA CASP, CISSP.
• Project management certification, e.g., PMP

Other Knowledge, Skills and Abilities Needed:

• Analytical skills: ability to integrate differing bodies of knowledge in troubleshooting and solving technical problems, including performing root cause analysis and follow up to ensure the issues are addressed at the root level.
• Learning skills: ability to learn and adopt new ideas and technologies.
• Organizational skills: ability to organize work, coordinate with other team members to accomplish goals, and ensure progress is made on assigned tasks.
• Good oral and written communication skills: ability to express information to individuals or groups effectively, and to make clear, comprehensible oral and written reports.
• Technology awareness: knowledge of developments and new applications of computing infrastructure technologies to the university’s technical infrastructure.
• Teamwork skills: ability to work effectively in teams, both as a member and leader.