Senior Information Systems Administrator/Developer – PGA Fellowships Office

The National Academies of Sciences, Engineering, and Medicine value diversity in our members, volunteers, and staff and strive for a culture of inclusion in our workplace and activities. Convening a diverse community to exchange ideas and perspectives enhances the quality of our work and increases our relevance as advisers to the nation about the most complex issues facing the nation and the world.

Keck Center

National Academy of Sciences Engineering Medicine

The National Academies of Sciences, Engineering, and Medicine provide independent, objective advice to inform policy with evidence, spark progress and innovation, and confront challenging issues for the benefit of society. We marshal knowledge and expertise across disciplines to study complex and sometimes contentious issues, reach consensus based on the evidence, and identify the best path forward. https://www.nationalacademies.org/

keywords: the division,the board,the opportunity,database,training,program,technology,security,quality assurance,reporting,process,code,technical,operating system,microsoft,experience,knowledge,education,solutions,develop,microsoft,establish,proficiency,teamwork

Full time

Overview: The Policy and Global Affairs Division (PGA) mobilizes experts and networks in the United States and around the world to increase the use of evidence to advance local, national and global policy and capacity. Within PGA, the Fellowships Office administers predoctoral, postdoctoral, and senior fellowship awards on behalf of government and private/foundation sponsors. These fellowship awards play an important role in the career development of doctoral and postdoctoral researchers and scholars for the academic, federal, industrial, and international workforce.<br /><br />The incumbent provides advanced-level <span class="WLL2">applications/programming</span> and project management expertise for large, complex internal development projects. Works with users to identify current operating procedures and clarify functional objectives. Outlines steps required for program development, including diagrams and charts. Performs programming and analysis tasks. Prepares program specifications. Encodes, tests, debugs, and installs programs in coordination with user departments. Creates applications and software tools. Designs, implements, and maintains complex databases with respect to access methods, access time, validation checks, organization, security, and documentation. Provides strategic recommendations regarding future infrastructural requirements, system frameworks, technology solutions, and needed applications.<br /><br />Performs work requiring advanced technical knowledge, often involving multiple phases and significant collaboration. Applies in-depth technical knowledge to independently and innovatively solve a full range of complex and sometimes unusual problems that impact organizational success. Brings industry-level expertise to function, and recommends changes to remain up-to-date or competitive. Establishes processes and procedures to ensure the effective and efficient operation of a complex function. Has authority to take whatever action deemed advisable or necessary, subject only to organizational and departmental policies and processes. Acts as a technical project leader and provides work direction for senior employees.
Responsibilities: <ul> <li>Maintains and develops software. Applies updates and fixes or modifies source code as needed. Reports software problems to vendor and works with vendor to resolve problems or to open source maintainer community. Performs system software upgrades including planning and scheduling, testing, and coordination.</li> <li>Develops and reviews user functional requirements and provides computer software assessments based on existing and planned system configurations. Based on functional specifications, prioritizes, develops, installs, and tests user applications that interface with relational databases. Applications may include planned user interfaces such as CGI, Visual Basic, HTML, ASP, and Java-based applications. Works with users to ensure satisfaction with applications. Provides training in the use of software to peers and end users. Assists users with issues relating to applications.</li> <li>Develops adhoc report queries, typically SQL-based, prepares ad hoc reports for sponsor and other stakeholders.</li> <li>Develops web-based applications. Knowledge of Windows servers, SQL Server, .NET framework, and standard Microsoft development tools, including Visual Studio, Git, and Azure Repos.</li> <li>Maintains and continually updates cyber security posture. Knowledge of web security concepts, practices, and NIST 800-171 standards.</li> <li>Ensures successful integration with other systems, technologies, and strategies across NASEM.</li> <li>Sets up new databases. Writes and maintains scripts to give user access. Designs and implements complex database environments. Provides support for systems or customized databases.</li> <li>Works with hosting provider to maintain Web, Database, and Application servers. Develops manual and automated testing, packaging, and deployment scripts.</li> <li>Researches and resolves data errors, problems, and inconsistencies and generates fixes where applicable. Performs ongoing validation of data in databases and generates extracts.</li> <li>Prepares program specifications. Writes program documentation and user operations guidelines. Maintains database dictionaries, ensures standard procedures are followed, and integrates systems.</li> <li>Keeps current with information technology services procedures and standards. Keeps abreast of new software and information technology trends. Tests new versions of the operating system, databases, and applications. Investigates new development technologies. Identifies and recommends potential future enhancements to the system as identified in the overall process redesign.</li> <li>Mentors and guides senior analysts/developers. May instruct, direct, and review the work of other applications systems analysis and programming personnel. Serves as a technical expert and resource across multiple disciplines.</li> </ul> <p dir="LTR"><strong>NONESSENTIAL JOB DUTIES</strong></p> <ul> <li> <p dir="LTR">Related duties and special projects as assigned.</p> </li> </ul>
Requirements: <p dir="LTR"><strong>Required Knowledge, Skills, and Abilities:</strong>&nbsp;</p> <p dir="LTR">Experience with change management concepts, protocols and systems. Ability to establish and work within a well-documented process of project and change management. Expertise in development and production <span class="WLL2">environments&nbsp;including</span> in full, secure software development life cycle, data management, and controls, and server configuration (compliant with NIST 800-171). Proficiency in the use of Windows servers, SQL Server, .NET framework, and standard Microsoft development tools, including Visual Studio, Git, and Azure Repos. Expertise in full, secure software development life cycle, data management, and controls, and server configuration (compliant with NIST 800-171). Ability to establish and work within a well-documented process of project and change management. Ability to solve intellectual problems of substantial variety and complexity. Ability to show appreciable latitude for independent judgment and action. Experience working in complex environments with a high degree of organizational effectiveness. Ability to work successfully in a team environment and to form and maintain effective teams. Ability to develop relationships with co-workers and employees in other National Academies' departments. Excellent communication skills with a proven ability to effectively interact with all levels of employees.</p> <p dir="LTR"><strong>Minimum Education/Training Requirements:</strong>&nbsp;Bachelor's degree in Computer Science or related field, or equivalent knowledge.</p> <p dir="LTR"><strong>Minimum Experience:</strong>&nbsp;Seven years of related professional experience.</p> <p dir="LTR"><strong>Physical Capabilities:&nbsp;</strong>Ability to work at a computer for extended periods of time.</p> <p dir="LTR"><strong>Required Licenses, Certification or Registration:</strong>&nbsp;None.</p> <p dir="LTR"><strong>Supervisory <span class="WLL2">Responsibilities/Controls:</span></strong>&nbsp;Reports to Director. General direction is provided. May supervise staff.</p> <p dir="LTR"><strong>Work Environment:&nbsp;</strong>Office environment with occasional travel between National Academies' facilities and to off-site locations.</p>