SQL DBA Expert - Azure

<p>Job Description :<br/><br/>- Perform secondary administration tasks on MongoDB, Azure PostgreSQL, and Azure MySQL.<br/><br/>- Design, implement, and maintain database systems to ensure high levels of performance, availability, and security.<br/><br/>- Develop and execute comprehensive database backup and recovery plans.<br/><br/>- Monitor database performance and optimize queries for efficient data retrieval.<br/><br/>- Ensure database systems meet business and performance requirements.<br/><br/>- Collaborate with development teams to design and implement robust database solutions.<br/><br/>- Troubleshoot and resolve database issues, providing timely and effective solutions.<br/><br/>- Document database procedures and policies, ensuring compliance with industry standards.<br/><br/>- Extensive knowledge and hands-on experience in database administration.<br/><br/>- In-depth understanding of Azure SQL PaaS database and Managed instance capabilities and features.<br/><br/>- Proficiency in writing and maintaining PowerShell scripts for database automation<br/><br/>- Design, implement, and maintain large-scale distributed databases that handle big data.<br/><br/>- Optimize database performance for efficiency and scalability.<br/><br/>- Ensure data integrity and security within the databases.<br/><br/>- Install and configure big data technologies, such as Hadoop, NoSQL databases, and other distributed computing systems.<br/><br/>- Monitor database performance, troubleshoot issues, and optimize query performance.<br/><br/>- Implement performance tuning and optimization strategies to ensure efficient data processing.<br/><br/>- Experience in large and complex databases in SQL Server 2019,2017,2014,2012, SQL Server 2008 R2<br/><br/>- Experience in Installation and configuration of SQL Server 2008 R2, 2012,2014,2016,2017,2019<br/><br/>- Technical proficiency in handling Microsoft SQL Database related issues both in production and non-production environments with expertise in doing rigorous troubleshooting on Database Backup, Restore, Log shipping, Database Mirroring and Always on etc.<br/><br/>- Experienced in scheduling Backups, Restore and Maintenance plans using Native tools.<br/><br/>- Experienced in using different Recovery models Simple, Full and Bulk-logged depending on <br/><br/>Application requirement :</p><p><br/></p><p>- Good experience configuring the index creation and maintenance activities on indexes.<br/><br/>- Slow running queries and helping in improving the performance.<br/><br/>- Restoring the Databases from Prod to Test.<br/><br/>- Troubleshooting blockings, deadlocks, disk space issues and fixing them by adding permanent fixes.<br/><br/>- Running the maintenance activities like update-statistics and DBCC CHECKDB at the time of performance issues<br/><br/>- Creating and managing the users and permissions and fixing the orphan users.<br/><br/>- Configured and maintained Transactional Replication and troubleshooting and adding articles to the existing replication.<br/><br/>- Good experience configuring and maintaining Log shipping and Mirroring.<br/><br/>- Hands on experience in Migration of SQL Server and databases from old version to new version.<br/><br/>- Configured and maintained Active/Passive clustering for failover.

And performing patching as well.<br/><br/>- Configuring Always-ON in SQL Server 2012/2014 and adding and removing Databases to existing HADR Availability Group.<br/><br/>- Troubleshooting slow running queries.<br/><br/>- Good to have Knowledge in SSIS and SSRS configuration and migration of packages and migration reports.<br/><br/>- Develop and implement backup and recovery strategies to safeguard data in case of failures or disasters.<br/><br/>- Test and document recovery procedures to minimize downtime.</p> (ref:hirist.tech)