General Position Summary: The Developer DBA will principally be responsible to create database objects that are used for custom applications that conform to properly normalized data models. Document the data model with database diagrams that properly identify all entity relationships. Support database efficiency and availability through database maintenance and monitoring. Responsible for creating and maintaining custom SSRS reports integrated into applications, and Power BI reports online. Additional SQL Server responsibilities will be to support, install, maintain and, troubleshoot enterprise databases and the applications that utilize SQL Server.
Job Scope/Complexity: Responsible for full life-cycle of medium to large sized complex projects; strong technical skills; strong ability to understand complex business processes. Develops solutions based on extensive technical knowledge, skills and experience; influences client towards innovative/integrated solutions.
Job Responsibilities: Evaluate, recommend and implement new architectural and user interface elements in the .Net development environment; document, train and assist developers in supporting existing code base; evaluate new code version and deployment strategies.
ANALYSIS AND REQUIREMENTS GATHERING
Define complex business/clinical/education problems by meeting with clients to observe and understand current processes and the issues related to those processes. Provide written documentation of findings to share with the client and other IT colleagues.
Gather complex system requirements by meeting with clients and researching existing technology to understand the business requirements and possible solutions for new applications.
DESIGN AND DEVELOPMENT
Develop detailed tasks/schedule estimates for complex projects in order to ensure product is delivered in a timely fashion according to software lifecycle standards.
Write functional/technical specifications from the complex system requirements, putting them into functional and technical descriptions for use by programmers and business analysts to develop technical solutions.
Develop/change data input, files/database structures, data transformation, algorithms, and data output by using appropriate computer language/tools to provide technical solutions for complex application development tasks.
Create database objects for custom applications including tables, stored procedures, views, functions, triggers, T-SQL queries and RDLs.
Provide thought leadership in designing and developing innovative integrated solutions.
TESTING AND DOCUMENTATION
Create and document complex test scenarios using the appropriate testing tools to validate and verify application functionality.
Test all changes by using the appropriate complex test scenarios to ensure all delivered solutions work as expected and errors are handling in a meaningful way.
Author and maintain documentation by writing audience-appropriate materials to serve as technical references.
Effectively communicate the complexities of various technologies to other members of a development team using database diagrams that provide complete database entity relationships.
IMPLEMENTATION AND MAINTENANCE
Implement changes by adhering to the change management policies and procedures for any given project to communicate to all parties the nature, significance, and risk factors of the solution.
Monitor changes and resolve complex problems by responding as they occur, by reviewing all processing and output of the newly implemented solution, and by proactively ensuring the solution works successfully in order to satisfy the customer requirements and to provide a smooth transition to the new solution.
Provide support by investigating and resolving issues, including complex issues to ensure prompt, effective service.
Specific systems, applications, projects on which the position will be responsible to develop or maintain:
Faculty Information System, Course System, Trend Analysis and Budgeting System, Patient Viewpoint
Impact of application to organization:
The Faculty Information system serves the purpose of collecting and sharing information about faculty and their Curriculum Vitae. This directly impacts the Schools faculty and administrators by allowing them to review faculty participation and contributions to teaching and research.
The Course system is used by faculty and students to provide course details and assist with the student enrollment and course evaluation processes. This system has a significant impact to the schools business model.
The Trend Analysis and Budgeting System is used by the Schools administrators to plan and forecast future year budgets and expenditure levels. This system is critical for financial planning.
The Patient Viewpoint system is used to help assess the quality of life as patients undergo treatment. This is a collaborative work with another JHU division to assist with patient care.
Examples of clients supported and degree of client interaction:
Clients supported include faculty, students and staff. Although interaction with most clients is through a liaison, either a project manager or team leader, some interaction with clients regarding clarification of business logic or application requirements is necessary.
Scale/size of area (# of users, # of servers, # of machines, # of systems supported, transaction volume, # of schools/areas that use system, multiple environments, geography, # of interfaces/integration with other systems): There are 35 monitored production servers and 10 non production servers with approximately 400 supported databases. Collectively these databases serve the needs of virtually all faculty, students and staff at the School. The custom applications impact a very large percentage of the faculty, student and staff populations.
Degree of supervision – how work is assigned, carried out, and reviewed:
Low degree of supervision but work is team-based and tasks are initiated/managed by the Business Analyst and Project Manager.
Work location: 615 N. Wolfe Street and work from home 1-2 days a week.
Minimum qualifications (mandatory):
Bachelor’s degree (or foreign equivalent) preferably in Computer Science, Computer Information Systems, Information Technology, Electronic Engineering or related field.
Five years of related work 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.
Preferred Qualifications: Knowledge in the assigned application as well as the platform on which it runs.
Special Knowledge, Skills, and Abilities:
Experience with computer systems and Web applications: Microsoft SQL Server database development, T SQL scripting, SSRS report writing, Power BI, ASP.Net applications using C# and VB.Net, .Net Frameworks. All development supports a Web application environment.
Must possess all requisite knowledge, skills, and abilities as posted in the supplemental section.
SQL Server 2012 to SQL Server 2019 development and administration
Power BI Report create and publish online reports
SQL Reporting services, create and publish RDL into production systems
T-SQL Programming of both DDL and DML objects
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.
Must demonstrate exemplary customer service skills.
Classified Title: Software Engineer Role/Level/Range: ATP/04/PE Starting Salary Range: $69,140 - $95,005 per year Employee group: Full Time Schedule: M-F, 8:30 am - 5:00 pm Exempt Status: Exempt Location: 05-MD:School of Public Health Department name: 10003508-JHSPH IT Advanced Technology Services Personnel area: School of Public Health
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 [email protected]. 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.
Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130 years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Bal...timore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.