Essential Duties and Responsibilities::
* Install, configure, and maintain database management systems (DBMS) and related software with an emphasis on automating routine deployment tasks.
* Monitor and optimize database performance using tools like New Relic or AWS Cloudwatch to transition from manual oversight to automated alerting and reporting.
* Develop and implement database backup and recovery plans, ensuring these processes are fully automated and tested for disaster recovery scenarios.
* Manage and monitor database security and access control, implementing automated security protocols to protect sensitive data.
* Troubleshoot and resolve database issues, focusing on building scripts to proactively identify and fix connectivity or data integrity issues.
* Develop and maintain comprehensive database documentation, including data models and schemas, to create the structured foundation required for future AI integration.
* Ensure compliance with regulatory requirements and data privacy policies through automated auditing and reporting.
* Participate in the design of database systems, collaborating with IT staff to replace legacy manual workflows with streamlined, automated solutions.
* Perform database tuning and optimization, utilizing automated scripts to ensure consistent, optimal performance.
* Develop and implement automated maintenance procedures, specifically transitioning manual data purging and defragmentation into scheduled, autonomous tasks.
* Plan and implement database upgrades and migrations, focusing on reducing manual downtime through automated migration scripts.
* Other duties as assigned.