Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: SQL DBA Expert Azure.
India Jobs Expertini

Urgent! SQL DBA Expert - Azure Job Opening In goa – Now Hiring Xpert Conexions

SQL DBA Expert Azure



Job description

<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)


Required Skill Profession

Computer Occupations



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your SQL DBA Potential: Insight & Career Growth Guide