Classified Title: GIS Developer/Database Admin Role/Level/Range: ATP/04/PD Starting Salary Range: $57,544 - $79,047 Employee group: Full Time Schedule: M-F; 7.5 hrs Employee subgroup: Salaried Exmpt Location: 45-MD:JH at Keswick Department name: 10001609-Systems Support Personnel area: University Administration
The Geographic Information Systems (GIS) Developer / Database Administrator (DBA) reports to the Manager of Information Systems and is responsible for creating, maintaining, and administering GIS applications for Johns Hopkins Facilities and Real Estate (JHFRE). The position will adhere to industry standards, using both commercial off-the-shelf and custom solutions, implementing the latest GIS web and mobile programming technologies and frameworks to successfully deploy geospatial applications. The applications’ functionality could include, but is not limited to, allowing GIS and non-GIS users the ability to view, edit, and/or perform minor analyses of geospatial and tabular data on mobile and desktop devices. The ideal candidate will also understand the basic principles of administering an ESRI ArcSDE geodatabase and will therefore contribute to the team’s efforts to create and manage detailed geodatabases, spatial and tabular datasets, database views, and stored procedures inside the relational database. The position will collaborate with the Senior GIS Analyst, the Manager of Information Systems, and other enterprise IT staff to successfully understand the needs of the various applications and ensure the office has the sufficient hardware and software solutions needed to deploy GIS applications.
Primary Duties and Responsibilities:
Develop, implement, and refine commercial off-the-shelf and custom GIS applications, user interfaces, and web services using the latest GIS/web-programming technologies.
Collaborate with other GIS and IT staff in the design, development, and maintenance of geodatabases based the needs of the various geospatial applications.
Administer application and geodatabase security using Active Directory accounts and established ESRI security levels (e.g., users, groups, roles etc.).
Develop scripts and routines to automate workflow processes.
Collaborate with enterprise IT staff to implement robust backup and recovery procedures for applications and enterprise geodatabases.
Provide technical guidance and assistance integrating other JHFRE information systems (Maximo, Archibus, etc.) with the GIS and geospatial applications.
Perform quality control checks of spatial data, web maps, and geo-based applications.
Prepare written documentation of all GIS applications and participate in cross-training/knowledge sharing with IT/GIS staff.
Assist in the development, publishing, and maintenance ESRI web services as part of the ArcGIS Enterprise solution.
Provide support for real-time mapping applications.
Manage and support enterprise wide ArcGIS SDE databases and related datasets, feature classes, and layers in multiple instances of SQL Server (development, testing, and publishing).
Draft scripts (Python, SQL, etc.), perform analysis, and monitor/improve database performance and capacity. Identifies; tests; and resolves complex database issues.
Monitor the landscape of GIS data management plans and design support services to respond to these requirements.
Participate in geo-data repository data evaluations, metadata creation/updates, data loading, and troubleshooting as needed.
Mange versioned editing environments by maintained and executing procedures for reconciling and posting versions, as well as compressing the geodatabase, rebuilding database indexes, and using ArcGIS tools to update database statistics.
Develop and maintain awareness of application-centered strategies and technologies across Ivy-plus universities and attend relevant conferences and workshops for his/her continuing professional development.
Conduct informal and formal service- and resource- needs’ assessments of assigned departments in an interactive, ongoing fashion, and communicate these needs via committees and various channels.
Configure and maintain ArcGIS Enterprise components including ArcGIS Server and Portal for ArcGIS.
Bachelor's degree in computer science, geography, engineering, or related discipline with a background in geospatial data, with at least 3 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 of web and mobile architectures and technologies
Strong understanding of responsive design principles and approaches
Experience with full life-cycle software applications development (i.e., design, construction, testing, and implementation
Familiarity with ESRI’s ArcGIS desktop and web solutions including Web AppBuilder for ArcGIS.
Experience with AngularJS, React.js or similar frameworks (including data binding, forms validation, DOM manipulation, etc.)
Experience with building web services with ASP.NET
Familiarity with GIT or similar source control environments
Understanding of Web Standards, Accessibility, and Semantic markup
Experience with REST and SOAP web services
Knowledge of geospatial concepts and data types
Strong analytical thinking and problem solving skills, attention to detail and accuracy
Strong organizational, project/process management, and application development skills
Interest in learning, using, and demonstrating software systems/technologies
Ability to effectively collaborate and build consensus with a diverse group
Excellent technical communication and documentation skills
Ability to work well independently and as a team member
Experience with other mapping SaaS platforms, including the Geocortex application development solution
Knowledge of Maximo and/or Archibus applications as well as their database schemas
Experience administering ArcGIS Enterprise and ArcGIS SDE SQL Server databases
Experienced with geodatabase system tables and relationships, SDE stored procedures, triggers and user defined functions
Experience with building ETL routines with FME or other scripting environments
Experience working with 3D data, software, and applications that serve out this data
Must be able to remain in a stationary position for extended periods of time.
Ability to operate a computer and other equipment on a frequent basis.
Ability to frequently communicate with coworkers.
Ability to move about.
This description is a general statement of required major duties and responsibilities performed on a regular and continuous basis. It does not exclude other duties as assigned.
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@example.com. 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.