Reporting to the Manager of Database Administration and Platform Support, the Database Administrator (DBA) will be part of a team responsible for the administration of Yale’s centrally managed database platforms. The DBA will use their technical expertise and experience related to all aspects of database administration in Oracle, SQL Server, and MySQL. Work as part of a team of database administrators to ensure the security, health, efficiency, and reliability of our platforms in a dynamic 24-7-365 production data center and/or cloud hybrid environment. Work independently in the daily support of customer requests, incidents, problems and changes with Yale’s supported Database Platforms (Oracle, SQL Server, MySQL).
Collaborate with other departments in ITS on cross-team efforts and incident/problem resolution. Effectively prioritize and manage concurrent assignments, bringing them to successful completion with minimal supervision. Work closely with technical owners of applications to plan, standardize, and automate procedures. Provide performance tuning, capacity planning, disaster recovery planning, and automation guidance for systems and applications. Prepare and enhance documentation to support procedures in Database Administration. Participate in groups/committees related to processes, standards and best practices and ensure documentation is up to date. Participate in cross-functional technical projects that require foundational platform as a component of the solution. Work on scripting to automate some of our repeatable processes. Perform off-shift work and participate in rotating on-call coverage.
- Configure database servers
- Monitor and maintain system health and security
- Design backup processes for server and associated data
- Create accounts for all users and assign security levels
- Establish a disaster recovery protocol
- Provide end-to-end technical support and problem resolution
- Schedule and perform regular server maintenance
- Create database management procedures
- Evaluate data analysis models and procedures
- Participate in department’s cross-training program
Required Education and Experience
Bachelor’s Degree in a related field, or the equivalent combination of experience & education.2 years’ professional experience or internship
Required Skill/Ability 1:
Proven experience with Oracle or SQL Server.
Required Skill/Ability 2:
Basic understanding of database security, disaster recovery and database backup procedures.
Required Skill/Ability 3:
Ability to work collaboratively and independently. Proven self-starter with ability to set priorities and manage workload. Proven ability to work in an environment where change control procedures e.g. ITIL are in use.
Required Skill/Ability 4:
Excellent communication and organizational skills. Demonstrated analytical and creative problem-solving skills. Demonstrated ability to develop and document complex procedures.
Required Skill/Ability 5:
Command of SQL and SQL server tools. Understanding of relational and dimensional data modeling.
Preferred Education, Experience and Skills:
Linux/platform, Ellucian Banner, Talend, Broadcom. Oracle RDBMS 12.2 or higher administration on Linux. SQL Server 2016, & 2017 administration. Installation & configuration of Oracle Fusion Middleware. Unix platforms including automation through scripting. PowerShell scripting and T-SQL. Oracle OEM configuration & monitoring. API Gateway(Layer7)Axway, MFT,AWS, Microsoft Azure.
Weekend Hours Required? Occasional
Evening Hours Required? Occasional
Drug Screen: No
Health Screening: No
Background Check Requirements
All candidates for employment will be subject to pre-employment background screening for this position, which may include motor vehicle, DOT certification, drug testing and credit checks based on the position description and job requirements. All offers are contingent upon the successful completion of the background check. Please visit www.yale.edu/hronline/careers/screening/faqs.html for additional information on the background check requirements and process.
The intent of this job description is to provide a representative summary of the essential functions that will be required of the position and should not be construed as a declaration of specific duties and responsibilities of the particular position. Employees will be assigned specific job-related duties through their hiring departments.
Affirmative Action Statement:
Yale University considers applicants for employment without regard to, and does not discriminate on the basis of, an individual’s sex, race, color, religion, age, disability, status as a veteran, or national or ethnic origin; nor does Yale discriminate on the basis of sexual orientation or gender identity or expression. Title IX of the Education Amendments of 1972 protects people from sex discrimination in educational programs and activities at institutions that receive federal financial assistance. Questions regarding Title IX may be referred to the University’s Title IX Coordinator, at TitleIX@yale.edu, or to the U.S. Department of Education, Office for Civil Rights, 8th Floor, Five Post Office Square, Boston MA 02109-3921. Telephone: 617.289.0111, Fax: 617.289.0150, TDD: 800.877.8339, or Email: email@example.com.
Note: Yale University is a tobacco-free campus