Summary of essential job functions
HMS is seeking a Database Administrator (DBA) in the support of National Institutes of Health (NIH), Department of Health and Human Services (HHS), NIEHS Service Desk and Infrastructure Technology Services (NSITES) II program. The mission of the National Institute of Environmental Health Sciences is to discover how the environment affects people in order to promote healthier lives. DBA will prepare data stores and data for testing. DBA will then maintain data stores through sustainment of the deployed solution assisting with troubleshooting and resolving issues, and system upgrades and disaster recovery operations. Candidate must possess knowledge of MS-SQL, Oracle, and MySQL database products and structures, be proficient in performing database maintenance activities on integrated systems and be experienced with systems deployed on a FedRAMP cloud. Familiarity with Government contract work is beneficial involving multiple complex and inter-related project tasks that often require working with teams of contractor personnel at multiple locations within National Institutes of Health (NIH) in Durham, NC.
- Manage routine operations of various relational databases (mainly MS-SQL, Oracle and MySQL).
- Perform maintenance activities, including evaluating and implementing patches and upgrades, managing table spaces and redo logs, performing data migrations, monitoring performance, and performance tuning.
- Provide Monthly Database Report on unscheduled downtime for production and non-production databases; the allocated, used, and remaining capacity in NIEHS databases; and the database activities that have taken place during the month.
- Administer user accounts for NIEHS employees and authorized contractors by creating, granting, and revoking privileges and roles; resetting passwords; locking and unlocking accounts; setting quotas, and creating and setting default table spaces.
- Provide technical assistance to application developers and end users in order to connect client software to databases, develop Structured Query Language (SQL) and shell scripts; import and export schemas; answer database questions; kill processes and threads; and migrate data from one database or schema to another.
- Work with data owners and the ISSO to ensure that personally identifiable information (PII) is stored in an encrypted format in enterprise databases.
- Support data governance policies by ensuring data accuracy, accessibility, consistency, and completeness.
- Implement future database management system (DBMS) requirements including big data strategies, relational databases, dimensional databases, and unstructured databases.
- Support data warehousing and business intelligence initiatives (including data mining and data movement) as implemented by NIH.
Required Skills and Experience:
- Demonstrated success as a Database Administrator on multiple databases and systems deployed within a government enterprise.
- Experience using MS-SQL, Oracle and MySQL
- Experience performing maintenance activities, including evaluating and implementing patches and upgrades, managing table spaces and redo logs, performing data migrations, monitoring performance, and performance tuning.
- Experience with designing and executing data backup and recovery operations and other Disaster Recovery activities
- Experience in writing both simple and complex scripts to assist with help-ticket troubleshooting and resolution
- Strong oral and written communication skills
- Strong interpersonal and client-facing skills with experience interfacing senior government officials
- Experience developing project documentation such as data dictionaries, and data models
- Experience reviewing project documentation, such as test cases, test scripts, and system design documents
- Bachelors degree in computer science, engineering, engineering management, math, or similar technical discipline
- 5 years relevant experience as a database administrator on Enterprise systems
- Certifications in MS-SQL and Oracle or similar data stores [desired]
- Experience working in NIH or other Government agency [desired]
- Public Trust Clearance or the ability to obtain a clearance
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.
To apply for this job please visit topspotjobs.com.