Perform database performance tuning activities such as analyzing query plans index tuning, troubleshooting database blocking and resolving deadlocks
Design database solutions for high volume database applications using high-availability strategies including clustering, replication, and Always On Availability Groups
Proactively monitor and respond to all database alerts
Perform daily monitoring of database servers to include error logs, database file sizes, successful backups, volume space, etc
Perform database server installations, configurations as well as patches and upgrades
Implement database maintenance best practices including index rebuilds, statistics, and database consistency checks.
Responsible for database backup, recovery, recovery testing and verification
Maintain and administer database security and access
Troubleshoot and resolve database connectivity issues
Create and maintain database documentation as required
Provide database administration support to 3rd party vendors, developers and others as needed
Participates in 24x7 on call support rotation, maintenance and deployment cycles as needed
Participate in database deployment and testing
Perform routine performance and availability testing on database servers to ensure scalability, resiliency, and capacity of all applications