As a SQL Database Administrator at Infosys, you will play a critical role in managing and optimizing our SQL Server environments. You will be responsible for ensuring the reliability, performance, and security of databases, while also guiding teams through various phases of the consulting lifecycle.
Key Responsibilities
- Database Management. Oversee RDBMS software installation, database server builds, and configuration of SQL Server (2008R2/2012/2014/2016). Ensure proper patching and upgrading.
- Disaster Recovery. Implement disaster recovery strategies, including Always On, clustering, log shipping, mirroring, and replication (both snapshot and transactional).
- High Availability. Configure and maintain Always On Availability Groups for SQL Server to ensure high availability and resilience.
- Database Maintenance. Manage backup, restore, and recovery processes, along with updating statistics, rebuilding indexes, and optimizing database performance.
- Performance Tuning. Utilize tools like SQL Profiler, Execution Plans, and Performance Monitor to identify and resolve performance issues.
- Automation. Use PowerShell or SQL Server Integration Services (SSIS) to automate routine tasks and enhance existing scripts.
- Monitoring & Alerts. Configure monitoring tools and enable alerts for proactive database management.
- Knowledge Sharing. Prepare knowledge articles and conduct training sessions to share insights and best practices with the team.
Required Qualifications
- Experience. Proven expertise in SQL Server management, with hands-on experience in installations, configurations, and troubleshooting.
- Disaster Recovery Expertise. Strong background in disaster recovery plans and high availability configurations.
- Performance Optimization. Experience in query optimization and performance tuning methodologies.
- Technical Skills. Proficiency in using monitoring tools such as Quest Foglight or AppDynamics.
- Scripting Skills. Familiarity with PowerShell or SSIS for task automation.
Preferred Qualifications
- 24x7 Support. Experience providing support and maintenance for OLTP/OLAP database instances.
About Infosys
Infosys is a global leader in next-generation digital services and consulting, helping clients in 56 countries navigate their digital transformation. With over three decades of experience, we focus on enabling enterprises with AI-powered solutions and agile digital practices.
Work Environment
At Infosys, we foster a culture of innovation and continuous improvement, empowering our employees to excel and grow. We value diverse perspectives and are committed to creating an inclusive environment where everyone can thrive.