Overview
Hybrid
Depends on Experience
Full Time
Skills
Database Administration
SQL
Microsoft Azure
Administrative Support
DML
DDL
Cloud Computing
Oracle RMAN
MySQL
Job Details
Location: Bethesda, MD
Hybrid position & Onsite interview
Position Description:
Key Responsibilities:
- Maintain the Production, Test, and Development databases that support the Institute s various applications deployed in both on-prem and cloud environments.
- Provide administrative support for SQL Server databases, MySQL databases, and SQL Server Reporting environment.
- Ensure that the Client user base can access the data residing in the IT systems.
- Is responsible for nightly and monthly maintenance on the database servers including evaluating current patches and follow-on patching of database software and security updates, maintaining standby databases, and performing routine maintenance tasks.
- Work with other teams for database related support such as refresh data in test, recover data from a table, production release support, set up the communication between COTS & databases, SQL Server & Oracle, resolve system vulnerabilities, etc.
- Provide performance tuning.
- Conduct database backup and recovery including Oracle export/import, RMAN backup, Cohesity backup, etc.
- Maintain accounts, roles, and privileges.
- Install, configure, and upgrade database servers.
- Check the health of all databases and servers daily including SQL server and MySQL
- Execute DDL and DML when needed.
- Perform troubleshooting.
- Provide database administration and data mart support on prem and in Azure cloud.
- Author and maintain Standard Operating Procedures that provide a framework for planning and performing the maintenance on client database and report servers.
- Add fields/tables to the Datamart as required by applications or report users, to both active and archive, then update new field(s) in archive as necessary.
- Keep documentation current for all changes.
- Create views of Datamart data to simplify data access by end users and/or developers building Power BI and Qlik Sense reports.
- Monitor downloads (and address issues if needed) daily to ensure the data is always up to date.
- Evaluate and implement new databases based on business needs.
- Write stored procedures, SQL, T SQL for Oracle, SQL Server, and/or MySQL.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.