Provide ongoing support and administration of all (predominantly SQL Server) database servers, including installation, configuration, upgrades, data migrations, maintenance plans, deployments, performance tuning, backups, and recovery.
Provide off-hour on-call availability as needed (rotational schedule).
Participate in database design decisions and provide expertise to development teams and junior-to-mid level DBAs.
Review and deploy approved database code releases to QC and production environments, following company standard processes and effectively communicating constraints, issues, and timelines to stakeholders.
Ensure database environment is secure, highly available, reliably backed up, and prepared for disaster recovery according to the business’s RTO and RPO.
Manage user and group access to various database resources.
Provide data capacity and node forecasting and planning based on baselines and trends of data growth, resource usage, and performance metrics.
Maintain supported versions and patch levels of database systems.
Implement, monitor, and support ETL processes.
Administer system-wide monitoring and alerts.
Evaluate and propose new tools and technologies to meet the needs of the organization.
Follow best practices in regards to security, meeting compliance levels, and documenting configuration and standard procedures.
Work closely with operational and development teams to troubleshoot functional or performance issues and proactively implement solutions.
Actively plan and manage projects involving new database systems and enhancements.