Job Description

Requisition Number: 96989About Insight:Founded in 1998 is headquartered in Chandler, Arizona, USA and has more and has more than 13000+ Teammates worldwide with global presence in Canada, United Kingdom, Germany, Australia, India, Singapore and many more. With offices in the prime location -Gurgaon and Bangalore we have 1000+ teammates operating from India.As a Fortune 500-ranked global provider of Digital Innovation, Cloud Data Center Transformation and Supply Chain Optimization solutions and services, we help clients successfully manage their IT today while transforming for tomorrow, recognized for its excellence.About the teamThe IMCS DBA team operates within Managed Cloud Services and overseas managed database services on a global scale. As a shared model DBA team, we are providing support to 30+ MSP customers.Responsibilities -

• Database Deployment and Management, deploying and managing Azure SQL databases in a Platform as a Service (PaaS) environment.
• Configuring and optimizing databases for performance, scalability, and cost efficiency
• Provide day-to-day database management and support including overseeing and guiding team members.
• Monitor the system\xe2\x80\x99s health and performance.
• Ensure high levels of performance, availability, sustainability, and security of databases.
• Conducting regular testing of disaster recovery plans to ensure data integrity.
• Managing database scaling based on workload demands.
• Implementing auto-scaling and resource optimization strategies
• Analyze, solve, and correct issues in real-time.
• Provide suggestions for solutions.
• Proficient in Azure SQL Database administration and management.
• Strong experience in Geo-Replication, Active Geo-Replication, Failover Groups, Zone-redundant Databases.
• Automatic Tuning, Transparent Data Encryption (TDE) & Point-in-Time Restore
• Install, configure, troubleshoot, and maintain a database system.
• Implement, maintain, and test disaster recovery strategies.
• Implement, maintain, and test database backup and recovery strategies.
• Manage the database capacity to ensure that it can meet the needs of the organization.
• Lead the set-up, testing, and deployment of new databases, migrations, and upgrades.
• Refine and automate regular processes, track issues, and document changes.
• Mentor junior DBAs on the team.
• Continuously evaluate emerging SQL Server technologies and recommend best practices for database management.
• Provide 24x7 support for critical production systems.

Qualification:

• Bachelor\xe2\x80\x99s degree in computer science or a related field.
• 7+ years of experience in a SQL Server DBA or similar role.
• Strong command of SQL and SQL server tools.
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
• Strong analytical, problem-solving skills and attention to detail.
• Ability to work independently and as part of a team.
• Excellent oral and written communication skills.

Nice to Have

• Certifications such as MCSE: Data Management and Analytics or MCSA: SQL 2016 Database Administration.

• DP900 & DP300

• Experience with Linux and Windows Server environments.

• PowerShell and Unix shell scripting skills.

• Familiarity with SSAS, SSIS, SSRS.

• Knowledge on MySQL/PostgreSQL/CosmosDB

Insight is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation or any other characteristic protected by law.Today\'s talent leads tomorrow\'s success. Learn about careers at Insight:Insight is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation or any other characteristic protected by law.Insight India Location:Level 16, Tower B, Building No 14, Dlf Cyber City In It/Ites Sez, Sector 24 &25 A Gurugram Gurgaon Hr 122002 India

Insight Enterprises