Database Administrator

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.

Remote 14

National Academies of Sciences Engineering Medicine

<br /><br />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: position overview,postion details,manage,sql,support,install,backup/restore,connections,technologies,mentor,maintain,required abilities,required knowledge,communications,education/training requirement,minimum experience,compensation,work environment

Full time

$85,040 - $116,930

Overview: Requisition Number: R0002297<br /> <br /> Manages and maintains production and non-production databases. Sets and monitors standards and design of physical data storage, maintenance, access, and security administration. Performs backup and recovery on database management systems, configures database parameters, and assists in prototype designs against logical data models. Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. Performs performance-tuning investigations and provides suggestions and designs for performance improvements. Maintains database dictionaries and ensures standard procedures are followed. Researches database technologies and recommends deployment strategies for their implementation across the organization. Advises management on database concepts and functional capabilities. Participates in the implementation of strategic and tactical database initiatives.<br /><br />Applies in-depth technical knowledge to complete assignments that are broadly defined, require judgment and creativity to complete, and require the identification and analysis of multiple and complex variables. Independently acts to solve a full range of complex problems/issues that arise in areas of assigned responsibility, but may receive guidance or expertise from higher-level staff on more complex problems. May establish processes/procedures to ensure the effective and efficient operation of complex functions.<br /><br />
Responsibilities: <ol> <li>Manages and maintains production and non-production databases in a Windows and UNIX-based networked environment. Participates in the database development process including the design, implementation, testing, and rollout phases. Participates on technology design and implementation teams as required to facilitate decision-making as it pertains to database environment.</li> <li>Administers and supports Microsoft Structured Query Language (MS SQL) and other databases including Oracle in the test and development environments.</li> <li>Provides database support for systems to units with customized databases or overarching database infrastructures.</li> <li>Installs, upgrades, and configures relational database management system (RDBMS) and performs the migration of databases, data, and objects.</li> <li>Performs backup/archive, restores, and recovery of systems and databases. Troubleshoots problems with hardware, software, and performance tuning. Provides rapid resolutions to database performance issues in the programmatic, query access, and physical hardware environments.</li> <li>Applies or produces connections to/from applications for database interactions.</li> <li>Recommends new database technologies and methods for implementing them. Works with technology management in the development and enhancement of database management methodologies and development guidelines.</li> <li>Mentors staff involved in database development to ensure their continued knowledge growth and ongoing awareness of established guidelines and methodologies.</li> <li>Maintains database dictionaries, ensures standard procedures are followed, and integrates systems through database design. Creates and maintains all documentation pertaining to the various database development architectures developed and projects undertaken.</li> </ol> NONESSENTIAL JOB DUTIES<br />&bull; Special projects and related duties as assigned.
Requirements: <p><strong>Required Knowledge, Skills, and Abilities:</strong> Knowledge of Rational Database Management Systems (RDBMS), i.e. Oracle, SQL 2014 (and above), similar databases and database middleware (WSFC and FCI cluster). Knowledge of administration and development environments under multi-platforms. Ability to solve intellectual problems of substantial variety and complexity using originality and ingenuity. Ability to serve as a resource to others in the resolution of problems. Ability to use appreciable latitude for independent judgment and action. Ability to work successfully in a team environment. Ability to develop relationships with co-workers and employees in other National Academies&rsquo; departments. Excellent communication skills with a proven ability to effectively interact with all levels of employees.</p> <p><strong>Minimum Education/Training Requirements:</strong> &nbsp;Bachelor&rsquo;s Degree in Computer Science or related field, or equivalent knowledge.</p> <p><strong>Minimum Experience: </strong>&nbsp;Four years of related professional experience.</p> <p><strong>Physical Capabilities: </strong>&nbsp;Ability to work at a computer for extended periods of time.</p> <p><strong>Required Licenses, Certification or Registration: </strong>&nbsp;None.</p> <p><strong>Supervisory Responsibilities/Controls: </strong>&nbsp;Reports to Manager. &nbsp;Sets objectives with supervisor.&nbsp;&nbsp;</p> <p><strong>Compensation Range: </strong>The National Academies of Sciences, Engineering, and Medicine support equity, fairness, and transparency in our compensation programs. An estimated compensation range for this position is $85,040 - $116,930. Compensation offered to the selected candidate will be based on the candidate&rsquo;s relevant knowledge, skills, and work experience, commensurate with compensation of current employees in comparable positions with similar knowledge, skills, and work experience, and subject to budget parameters. Note it is not typical for a candidate to be hired at the higher end of the range.&nbsp;</p> <p><strong>Work Environment:</strong> &nbsp;This position has been approved for 100% remote work from a previously approved location, with occasional travel between National Academies&rsquo; facilities and to off-site locations.&nbsp;<br /><br /></p> <p><strong>The National Academies&rsquo; Statement on Diversity and Inclusion:<br /></strong>We, the National Academies of Sciences, Engineering, and Medicine (the National Academies), value diversity among our staff, members, volunteers, partners, vendors, and audiences. We recognize that talent is broadly distributed in society and that many perspectives enhance the quality of our work and drive innovation and impact.</p> <p>We pledge to cultivate a workplace culture and climate that promotes inclusion, belonging, accessibility, and anti-racism; upholds equity; and values the participation of all who are engaged in advancing our mission. By embracing the values of diversity, equity, and inclusion in our programs, institutional policies and practices, and products, we will be able to better advise the nation on the most complex issues facing society and the world.&nbsp;&nbsp;</p> <p><strong>Equal Opportunity Employer:<br /></strong>It is the policy of the National Academies to recruit, hire, transfer, compensate, and promote people in all job categories and to administer all other personnel actions, terms and conditions of employment in a manner that is consistent with equal employment, and does not discriminate on the basis of&nbsp; race, creed, ethnicity, color, national origin, sex, sexual orientation, gender identity, age, religion, disability, medical condition for which a person has been rehabilitated or cured, marital status, family responsibilities, genetic information, political affiliation, personal appearance, matriculation, unemployment status, veteran status, or any other characteristic protected by applicable laws.&nbsp; It is also the institution's policy to recruit, hire, promote, and provide reasonable accommodation to qualified individuals with disabilities and covered veterans who are otherwise qualified.</p> <p><br /><br /><br /></p>