Share this Job
Job Req ID:  19225

Sr. Programmer Analyst

 

General Summary/Purpose: 

The role of the Database Administrator (DBA) is to design, install, monitor, maintain, and performance-tune production and research databases containing the largest scientific datasets while ensuring high levels of data availability.


Specific Duties & Responsibilities:

A. Database Administration, 90% 

  • Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
  • Install and configure relevant network components to ensure database access as well as database security, consistency and integrity. 
  • Respond to and resolve database access, security and performance issues. 
  • Monitor database system details, including stored procedures and query execution time, and implement index tuning and efficiency improvements. 
  • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. 
  • Monitor, optimize and allocate physical data storage for databases. 
  • Plan and coordinate data migrations between systems. 
  • Help scientists deploy their data services in the cloud, as necessary.
  • Help troubleshoot container data volumes.
  • Help scientists translate file-based data models into effective relational database schemas.
  • Help scientists design and implement efficient software applications for database access.
  • Establish appropriate end-user database access control levels. 
  • Develop routines for end-users to facilitate best practices database use.

 

B. Training and User Support, 10%

  • Train and provide guidance to members of the team in proper database access and use.
  • Attend department and University-sponsored training to increase knowledge, improve and learn new skills.  May substitute University training for supervisor approved commercial job-related course offerings.

 
Minimum Qualifications (mandatory):

  • Bachelor's Degree in Computer Science, Information Technology or related field.
  • 3 years related experience as a database administrator (DBA) in research computing, ideally in science or engineering required.

 
Special Knowledge, Skills, and Abilities:  

  •  Familiarity with relational database management systems (RDBMS) and strong understanding of relational database structures, theories, principles, and practices, especially for Microsoft SQL Server platform but knowledge of other platforms like PostgreSQL and MySQL also very desirable. 
  • Working technical experience with designing, building, installing, configuring and supporting database servers. 
  • Hands-on database tuning and troubleshooting experience. 
  • Experience in and in-depth knowledge of programming in SQL, especially writing stored procedures and functions. 
  • Experience or knowledge in database applications programming, in Java or C# esp., preferred. 
  • Good written and oral communication skills, strong technical documentation skills and the ability to present ideas in a user-friendly language. 
  • Familiarity with container (Docker/VM) architecture and Kubernetes desirable.
  • Familiarity with major commercial cloud platforms (AWS, Azure, GCP) desirable.
  • Ability to conduct research into database issues, standards and products as required. 
  • Highly self-motivated and directed with keen attention to detail. 
  • Proven analytical and problem-solving abilities. 
  • Ability to effectively prioritize and execute tasks and meet schedules in a high-pressure environment. 
  • Strong customer service orientation with good interpersonal skills.
  • Experience working in a team-oriented, collaborative environment. 
  • Ability to work productively on several high-profile projects at once.

 

Classified Title: Sr. Programmer Analyst   ​​​​​
Role/Level/Range: ATP/04/PD 
Starting Salary Range: $59,280 to $81,435 annually
Employee group: Full Time 
Schedule: M-F, 8:30 am - 5:00 pm 
Exempt Status: Exempt  
Location: 01-MD:Homewood Campus 
Department name: 10001373-Physics and Astronomy 
Personnel area: School of Arts & Sciences

 

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 at jhurecruitment@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://www1.eeoc.gov/employers/upload/eeoc_self_print_poster.pdf
Important legal information
http://hrnt.jhu.edu/legal.cfm

 

Homewood Campus