Database Administrator

General Summary/Purpose:

The Database Administrator will take a leading role in the design, development and overall management of academic and administrative databases for the Carey Business School, including, but not limited to, the Johns Hopkins University Student Information System. This position is responsible for having/gaining a thorough understanding of the complex interdependencies of the different software and systems, and will be required to identify risks related to these interdependencies and recommend adequate changes to the business requirements. This position will also focus heavily on data collection, storage and reporting. This position will participate in the management of projects on data collection may serve as backup on other projects such as tuition calculation, PowerFAIDS or Dashboard and Dataset development.

This position supports systems and work on processes that can have a direct impact on the financial and strategic goals of the schools.

Specific Duties & Responsibilities:

Applications Software Development and Support (40%)

• Lead the planning, development, implementation and support of centrally-managed and local systems which support the mission of the Carey Business School and the university.
• Analyze requirements, design, code, test, debug and put into production the most complex SQL programs within the student information system.
• Work at the highest programming/analytical level, demonstrating proficiency in database management systems and database administration, including application development, database structure and design, quality assurance, security, risk management and disaster recovery.
• Identify and resolve problems independently, including hardware configuration problems, software configuration problems, and problems with internally developed applications.
• Design, develop and support system interfaces.
• Provide guidance and training to less-experienced IT staff on a regular basis. Will need to guide technical team members assigned to their project and monitor the team to make sure the milestones are reached in accordance to the plan. Often this position will serve as a technical mentor for other members of the technical team. This position is expected to perform code review to assure the quality of the project and will provide feedback on how to improve their technical skills and recommendations on how to further develop them.
• Interact with functional users within the school – understanding business processes and helping to ensure our systems meet their needs, communicating new enhancement/what to expect with system upgrades in non-technical terms, documenting and training end-users on proper data entry procedures.
• Evaluate existing applications; recommend actions, code and implement modifications/upgrade as needed.
• Clearly document requirements, development plans and outcomes (training documentation for end users as well as support documentation for internal Carey IT staff).
• Implement industry standards and appropriate methodology for programming/application development and IT project management, including information technology problem definition and resolution and the formulation of procedures and accountability controls as they relate to the functional areas under study.

Data Collection, Storage and Reporting (40%)

• Analyze requirements, design, code, test and put into production SQL Reporting Services reports and corresponding SQL queries.
• Design and create user reports using a variety of tools, including Tableau, Power BI and MS Excel.
• Work in conjunction with functional representatives to develop back-end data queries to satisfy ad-hoc requests for information regarding the school.
• Assure quality and integrity of data collected and reports generated.
• Design and create standardized datasets for use in ad hoc queries, institutional reporting and other reporting needs.
• Create and maintain policies and procedures for consistent methods for querying data and ensuring the highest performance on all databases.
• Ensure data security.

Project Administration (20%)

• Lead software development projects (defining and managing system scope, objectives, risks, tasks, responsibilities, timelines, status reports, training needs and documentation) and indirectly manage cross-functional staff and deliverables to meet project goals, school objectives and re-engineer and/or streamline processes and procedures.
• Analyze, propose and manage upgrades and/or replacements of existing database technologies; identifying costs, organizational impacts and training needs.
• Work with software vendors – identifying software enhancements, testing vendor-supplied solutions, understanding new enhancements/what to expect with system upgrades.
• Create and/or oversee complete technical documentation for all databases to ensure that newly hired staff can follow any project with little or no previous knowledge.
• Provide consulting services within Carey regarding development of unit-specific databases. Conduct needs assessments when appropriate. Oversee, coordinate and assist staff with the development and management of such databases.

Minimum Qualifications (Mandatory):

• Bachelor’s degree from a regionally accredited college or university required. Additional experience may be substituted for education to the extent permitted by the JHU equivalency formula.
• Five years of related experience in application development, database support and leading and/or managing projects; preferably within higher education. Additional education may substitute for experience to the extent permitted by the JHU equivalency formula.

Preferred Qualifications:

• Experience with the JHU Student Information System or other student information systems and/or university administrative systems.
• Experience with PowerFAIDS or other similar financial aid systems.
• Experience with SQL Server Reporting Services, Visual Studio, SQL queries, views and stored procedure.
• Experience with reporting software or tools such Tableau, Power BI, SAP BusinessObjects or similar.
• Experience with project management software and task management tools.
• Experience with web technologies.
  

Special Knowledge, Skills, and Abilities:

• N/A
  

Technical Qualifications or Specialized Certifications:

• N/A

Any Specific Physical Requirements for the Job:

• N/A

Supervisory Responsibility:

• N/A

Budget Authority:

• N/A

Classified Title:Software Engineer
Working Title: Database Administrator
Role/Level/Range: ATP/04/PE
Starting Salary Range:$69,140 to $95,005 per year
Employee group: Full Time
Schedule: Monday-Friday 8:30am-5:00pm
Exempt Status: Exempt
Location: 46-MD:JH at Harbor East
Department name: 60004457-Software and Reporting Services Group
Personnel area: Carey Business School

The successful candidate(s) for this position will be subject to a pre-employment background check.

If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the HR Business Services Office atjhurecruitment@jhu.edu. For TTY users, call via Maryland Relay or dial 711.

The following additional provisions may apply depending on which campus you will work. Your recruiter will advise accordingly.

During the Influenza ("the flu") season, as a condition of employment, The Johns Hopkins Institutions require all employees who provide ongoing services to patients or work in patient care or clinical care areas to have an annual influenza vaccination or possess an approved medical or religious exception. Failure to meet this requirement may result in termination of employment.

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.

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

EEO is the Law
Learn more:
https://www.eeoc.gov/sites/default/files/migrated_files/employers/poster_screen_reader_optimized.pdf