Remote Position
[Remote] Senior Database Administrator
๐ Remote ยท United States
๐ผ Full-time
Note: The job is a remote job and is open to candidates in USA. The University of Virginia is a public university dedicated to education, research, and service. The Senior Database Administrator supports the Student Information System by sustaining database and PeopleSoft infrastructure, managing security, backups, recovery, performance, and data services. The role also troubleshoots systems, collaborates with technical teams and vendors, leads projects, and mentors team members.
Responsibilities
- Install and sustain database infrastructure components supporting PeopleSoft student applications, including database servers, listeners, web and application servers, and database connectivity
- Acquire, administer, and apply database infrastructure patches and PeopleTools patches for PeopleSoft environments
- Configure, monitor, and tune database infrastructure for optimal PeopleSoft application performance
- Develop, test, and execute database backup, recovery, and refresh procedures
- Anticipate cyclical events and forecast system resource requirements
- Maintain security certificates and shared encryption keys for SIS applications
- Partner with system and network administrators to maintain a secure and stable environment for student system applications
- Develop data models, database designs, and database specifications
- Create and maintain schemas and related database objects, including views, constraints, triggers, and roles
- Assess and anticipate the effects of cyclical events, business decisions, and changes in business operations, data requirements, or application systems
- Assist developers and users with database access and navigation, including SQL analysis, traces, and commit strategies
- Migrate data through data extracts and data loads
- Implement database security measures aligned with industry best practices, including CIS Benchmarks
- Implement and maintain Oracle Advanced Security Options, Transparent Data Encryption, and encryption key management according to industry best practices
- Monitor and analyze database audit tables and logs
- Follow change management processes to ensure compliance with University regulations
- Acquire, administer, and apply patches to the PeopleSoft application environment
- Configure, monitor, and tune web, application, and database servers
- Implement application security measures
- Develop and maintain the technology, hardware, and software skills needed to uphold high standards of professional excellence
- Research and promote new technologies and methods
- Stay informed about trends and developments in higher education student systems
- Work independently with minimal guidance
- Prepare or assist in developing database project plans that support the overall SIS environment
- Provide progress reports and updates on project activities
- Lead projects or individual steps within larger projects
- Collaborate with SIS technical and functional team members on assessment, analysis, testing, and tuning
- Cross-train with team members to ensure backup coverage for key processes
- Mentor peers, clients, and junior team members to support continuous improvement
- Coordinate hardware infrastructure maintenance and configuration with system and network administrators
- Manage relationships with external vendors and service providers, partnering on implementations, issue resolution, and enhancement requests
Skills
- Bachelor's degree. An equivalent combination of experience, education, and/or certifications may be substituted in lieu of a degree
- At least five years of experience working as an Oracle Database Administrator
- Excellent analytical and problem-solving abilities
- Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders
- Ability to manage multiple projects and priorities in a fast-paced environment
- Strong foundation in SQL
- In-depth knowledge of Oracle Database and PeopleSoft concepts, technologies, and best practices
- Master's degree or foreign equivalent in computer science, computer engineering, engineering instrumentation and control, or a related field
- At least five years of experience working with a student enterprise resource planning (ERP) system
- Knowledge of PeopleSoft Campus Solutions, HighPoint Campus Experience, PHIRE, Cohesity, Unix, Pathlock, Red Hat Enterprise Linux, Ansible scripting, Splunk, Oracle Advanced Security Options with Transparent Data Encryption, and Informatica PowerCenter
- Experience in a higher education environment
Benefits
- This is a fully remote position
Company Overview
Company H1B Sponsorship