We are seeking a Database Administrator whose role is to design, install, test, monitor, maintain, and performance tune production Oracle and SQL Server databases for both internally and externally developed applications while ensuring high levels of data availability.

This individual is also responsible for developing, implementing, and overseeing database policies and procedures including disaster recovery, performance tuning and security to ensure the integrity and availability of databases and their accompanying software.

The Database Administrator will work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.

The position requires excellent interpersonal skills in terms of customer service, training and promotion of new technologies, negotiation, and persuasion. Position will work independently, with a team of developers and with other technical staff. The Database Administrator will exercise a wide range of independent judgment and will be required to confer with the Controller's office managerial and administrative personnel to implement new database applications.

Job Scope/Complexity

Responsible for creating, and maintaining programs to interface with databases as needed, and will facilitate others doing the same including working with other technical staff to develop and maintain interfaces from SAP to production databases and externally developed applications.

To successfully perform these job responsibilities, the incumbent must be proficient in SQL Server, Oracle, SAS and Perl, and must possess a working knowledge of Unix, Linux and Windows servers.

Specific Duties & Responsibilities

• The responsibilities listed below are typical job functions both Project and Application specific performed by this position.
• Not all duties assigned to this position are included, nor is it expected that everyone in this position will be assigned every job responsibility.

Project Specific

• Plan short-term and long-term projects for application development as well as database and operating system maintenance and upgrades.
• These projects must be done with a knowledge of University Time and Leave policies, payroll schedules, JHU period reporting and compliance deadlines.

Application Specific

• E210 Time and Leave Reporting System
• The University's time and leave system was developed and is managed exclusively by information technology staff within the Controller's Office.
• The application runs on Linux servers with an Oracle database at the back end.
• The incumbent is responsible for the administration of the database as well as the administration of the system.
• This includes processing and tracking of vacation credits into SAP and end-user training.

Effort Reporting System

• An externally developed application used by faculty and staff to report effort on sponsored accounts.
• The application runs on Linux servers with an Oracle database at the back end.
• The incumbent is responsible for the administration of the database as well as the administration of the system.
• This includes processing of retroactive payroll data into the system and assisting the Financial Research Compliance department in quarterly semi-monthly and daily payroll loads.

Cost Model

• An externally developed application used to determine F&A reimbursement rates for use in negotiating indirect cost reimbursement rates from the Federal government.
• The application runs on Windows servers with a SQL Server database at the back end.
• The incumbent is responsible for gathering and managing multiple data loads into this system and for creating reports for the Cost Analysis department.

Oculus

• An externally developed application for Document Management.
• The application runs on Windows servers with a SQL Server database.
• The incumbent is responsible for gathering and managing data that is loaded into this system, as well as optimizing database configuration and queries.

Required Experience

• Experience in administration of relational databases.
  
• Understanding of information technology concepts and applications as required to implement and support database applications, including server deployment and administration, and various reporting and analysis software.
  
• Additional education may substitute for required experience and additional related experience may substitute for required education, to the extent permitted by the JHU equivalency formula.

Knowledge, Skills, & Abilities (KSA's)

• Must possess all requisite knowledge, skills, and abilities as posted in the supplemental section.
• Must demonstrate strong critical thinking and analytical reasoning skills.
• Ability to work on multiple priorities effectively.
• Ability to prioritize conflicting demands.
• Ability to execute assigned project tasks within established schedule.
• Ability to work collaboratively in a team environment.
• Ability to communicate effectively in the service of users and colleagues.
• Writes and communicates clearly and concisely.
• Possesses sound documentation skills.
• Ability to maintain confidentiality.

• Bachelor's Degree.
• Five years related experience.
• Additional education may substitute for required experience and additional related experience may substitute for required education, to the extent permitted by the JHU equivalency formula.

• Knowledge in the assigned application as well as the platform on which it runs.

Classified Title: Software Engineer
Role/Level/Range: ATP/04/PE
Starting Salary Range: Min $$72,600 - Mid $99,800 - Max $127,000 Annually (Commensurate with experience)
Employee group: Full Time
Schedule: Monday - Friday, 8:30am - 5:00pm
Exempt Status: Exempt
Location: Hybrid/JH at Keswick
Department name: Financial Systems
Personnel area: University Administration

Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines:
JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.

**Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.

The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate's conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.

The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion.

Johns Hopkins has mandated COVID-19 and influenza vaccines, as applicable. The COVID-19 vaccine does not apply to positions located in the State of Florida. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry. For additional information, applicants for SOM positions should visit https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/ and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/.

The following additional provisions may apply, depending on campus. Your recruiter will advise accordingly.

The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.

Note: Job Postings are updated daily and remain online until filled.