DBA SQL

· Install, configure, and maintain SQL Server instances.

· Configure and administer high availability and disaster recovery solutions, such as Always on Availability Groups to ensure business continuity and data availability.

· Monitor database performance, identify bottlenecks and areas for improvement, and proactively tune queries and configurations to ensure optimal performance.

· Apply patches and updates to SQL Server instances and other related software, ensuring minimal disruption to business operations.

· Deploy SQL scripts to multiple databases using 3rd party or custom tools.

· Debug and troubleshoot database issues and collaborate with development teams to resolve them.

· Automate routine database administration tasks using scripts.

· Regularly refresh lower environments with production database backups.

· Implement and maintain database security policies and procedures, ensuring compliance with industry standards and regulations.

· Develop and implement backup and restore strategies to protect data against loss or corruption and perform regular backups.

· Plan and execute database migrations to new hardware, software versions, or cloud platforms, and ensure data consistency and integrity during the migration process.

· Develop and maintain database documentation, including procedures, diagrams, and technical specifications, to facilitate knowledge sharing and ensure compliance with regulatory requirements.