Job Type :
Full-time
Essential Duties and Responsibilities :
1. MAINTAINS database ownership and access privileges.
2. PERFORMS and tests daily backups of critical data on the domain, and addresses requests for data restoration of lost or corrupted data.
3. DESIGNS, tests, and documents disaster recovery plans and backup strategies for implemented database systems; designs, develops, maintains, and executes disaster recovery systems and services.
4. MONITORS databases to optimize database performance and resource use.
5. ADDRESSES a variety of database integration issues, including integration with 3rd party data sources, including the extraction, transformation, and loading of structured and unstructured data for analytical processing.
6. MAINTAINS and tests development and production database management systems environments.
7. COLLABORATES with system and network administrators to monitor, maintain, and enhance database security and database software.
8. PROVIDES expert guidance on troubleshooting, exception handling, and resolving complex database management issues.
9. CONDUCTS research and makes recommendations on database products, services, and protocols in support of data and information management standards.
10. MONITORS and manages database logs, and journals; installs, maintains, and upgrades database management software.
11. CREATES and maintains database reports, queries, and scripts, and other analytic tools as required to support end users with data retrieval and analysis, to ensure performance optimization, data integrity, and security.
12. LIAISES with application developers and system administrators to ensure the successful design, implementation, operation, and maintenance of databases.
13. MONITORS for security threats to protect databases from unauthorized access, data breaches, and other security risks, ensuring the confidentiality, integrity, and availability of organizational data assets.
14. RECOMMEND and implement targeted enhancements to database operations, related security protocols, database system integration and interoperability with the Data Warehouse environment.
15. REVIEW, maintain, and optimize the configuration and performance of the Data Warehouse, including the tools involved in the implementation, such as SSRS, SSIS, SSAS and Power BI, among others.
16. COLLABORATE in the definition and adoption of standards for metadata, tagging, naming and indexing databases and Data Warehouse.
17. IMPLEMENT ETL processes to extract, transform, and load data from multiple government systems into the Data Warehouse.
18. OPTIMIZE ETL workflows to ensure efficiency, reliability, and data integrity.
19. COLLABORATE in implementing OLAP cubes for multi-dimensional analysis to support decision-making.
20. IMPLEMENT role-based access controls, encryption, and other security measures for the Data Warehouse and data marts.