Job Description

We are seeking a Software Engineer 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 Software Engineer 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. Software Engineer 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.