About Us:- Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey.
We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.
Visit www.infosys.com to see how Infosys (NYSE: INFY) can help your enterprise navigate your next.
Location : Wellington, New Zealand Short Description: we are seeking a skilled and dedicated MS SQL Database Administrator to manage and maintain our critical database systems. The ideal candidate will be responsible for ensuring the performance, integrity, security, and availability of our MS SQL server environments. This role involves proactive monitoring, performance tuning, backup and recovery strategies, security implementation, and collaboration with development and infrastructure teams.
Roles and Responsibilities: Install, configure, and maintain MS SQL Server instances and databases across various environments (development, testing, production). Develop and implement robust backup and recovery strategies to ensure data integrity and business continuity. Monitor database performance, identify bottlenecks, and implement performance tuning measures, including query optimization and index management.
Implement and enforce database security measures, including user access control, permissions management, and data encryption. Troubleshoot database-related issues and provide timely resolutions. Plan and execute database upgrades, migrations, and patching.
Develop and maintain database documentation, including configuration, standards, and procedures. Collaborate with application development teams to optimize database design and query performance. Work closely with infrastructure teams to ensure the underlying server and storage infrastructure supports database requirements.
Implement and maintain database replication and high availability solutions (e.g., Always On Availability Groups, mirroring).
Automate routine database administration tasks using scripting languages (e.g., PowerShell, T-SQL).
Stay up-to-date with the latest MS SQL Server features, updates, and best practices. Participate in on-call rotation for critical database issues. Essential: Bachelor's degree in Computer Science, Information Technology, or a related field.
Proven experience (6 Years) as an MS SQL Database Administrator in a production environment. In-depth knowledge of MS SQL Server architecture, features, and administration tools. Strong understanding.
...