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 University offers a competitive salary, and outstanding benefits, including employee and dependent tuition waivers at UConn, and a highly desirable work environment. For additional information regarding benefits visit: https://hr.uconn.edu/benefits-beyond-pay/. Other rights, terms, and conditions of employment are contained in the collective bargaining agreement between the University of Connecticut and the University of Connecticut Professional Employees Association (UCPEA). 

TERMS AND CONDITIONS OF EMPLOYMENT

Employment of the successful candidate is contingent upon the successful completion of a pre-employment criminal background check.

TO APPLY

Please apply online at https://hr.uconn.edu/jobs, Staff Positions, Search #498468 to upload a resume, cover letter, and contact information for three (3) professional references.

This job posting is scheduled to be removed at 11:55 p.m. Eastern time on October 15, 2024. 

All employees are subject to adherence to the State Code of Ethics which may be found at http://www.ct.gov/ethics/site/default.asp.

All members of the University of Connecticut are expected to exhibit appreciation of, and contribute to, an inclusive, respectful, and diverse environment for the University community.

The University of Connecticut aspires to create a community built on collaboration and belonging and has actively sought to create an inclusive culture within the workforce. The success of the University is dependent on the willingness of our diverse employee and student populations to share their rich perspectives and backgrounds in a respectful manner. This makes it essential for each member of our community to feel secure and welcomed and to thoroughly understand and believe that their ideas are respected by all. We strongly respect each individual employee?s unique experiences and perspectives and encourage all members of the community to do the same. All applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

The University of Connecticut is an AA/EEO Employer.