Oracle Database Administrator 2 or 3

JOB SUMMARY

Are you an Oracle database administrator looking for an exciting opportunity to make a difference in higher education? The centralized Information Technology Services (ITS) Department at the University of Connecticut in Storrs, CT. is seeking a talented individual to join our team. In this role, you will be vital in the monitoring, troubleshooting, patching, performance tuning, and problem-solving of our university's Oracle and SQL Server database environments. Under the supervision of the team leader, and with input from other team members, you will not only contribute technically but will work closely with other distributed IT teams and business stakeholders from across the university. If you're passionate about leveraging your expertise to support a dynamic academic community, we want to hear from you! Apply today and be part of a team committed to innovation and excellence in technology services at the University of Connecticut.

DUTIES AND RESPONSIBILITIES – Both Levels

• Identifies and resolves system errors. Consults with application owners and functional users to resolve problems with platform and system performance problems.
• Assists technical staff in the installation, upgrade, and maintenance of database solutions and tools.
• Research and document procedures, techniques, or programs to analyze or improve the performance of software systems.
• Documents and performs software installations, patches, and upgrades. 
• Works with Oracle support to identify and resolve issues.
• Writes scripts and/or programs to assist with database administration.
• Works with team and management to enhance and implement enterprise solutions.
• Works with technical and functional staff to design and develop systems integrations.
• Other duties as assigned.

ADDITIONAL DUTIES AND RESPONSIBILITIES FOR Database Administrator 3 Only

• Creates procedures, and performs and trains technical staff in the installation, upgrade, and maintenance of database solutions and tools.
• Create, document, perform, and cross-train teammates on software installations, patches, and upgrade procedures. 
• Collaborate and guide teammates and management on enterprise solution implementation.
• Designs, plans, develops, configures, and implements solutions to ensure the high availability of services if a major disruption is caused by system issues or large-scale disasters.

MINIMUM QUALIFICATIONS – Both Levels

• Eight years of related experience; or an associate degree and six years of related experience; or a bachelor's degree and four years of related experience.
• Experience managing Oracle databases, including Oracle RAC, Data Guard, RMAN, and OEM installation, configuration, optimization, use, and best practices.
• Experience with security, performance, and capacity of databases.
• Experience with the design and implementation of database backup, recovery, and failover tools.
• Knowledge of managing SQL Server databases.

ADDITIONAL MINIMUM QUALIFICATIONS FOR Database Administrator 3 Only

• Ten years of related experience; or an associate degree and eight years of related experience; or a bachelor's degree and six years of related experience.
• Experience with database theory and design.
• Experience with data encryption used in database technologies.
• Knowledge of Microsoft SQL Server, including the use of High Availability, failover, and witness servers.

PREFERRED QUALIFICATIONS – Both Levels

• Experience with Windows and Linux OS operating systems, specifically RedHat Linux.
• Experience with Exadata.
• Knowledge of Microsoft SQL Server, including the use of High Availability, failover, and witness servers.
• Knowledge of T-SQL and PL/SQL.
• Knowledge of other database systems such as PostgreSQL, MariaDB.
• Knowledge of data encryption used in database technologies.
• Knowledge of data analytics technologies and systems.
• Knowledge of database theory and design.
• Knowledge of ETL principles and best practices.
• Knowledge of network infrastructure.

ADDITIONAL PREFERRED QUALIFICATIONS FOR Database Administrator 3 Only

• Experience with encryption at all levels of the technology stack.

APPOINTMENT TERMS

This is a full-time, permanent position.  Applicants must be legally authorized to work for any employer in the United States. Please note that we are unable to sponsor or take over sponsorship of an employment Visa at this time.   The Un