TCS is seeking an experienced SQL Database Administrator to join their dynamic team. The role requires expertise in managing SQL databases, ensuring the highest levels of availability, performance, and security. You will be responsible for managing complex database infrastructures across multiple environments, implementing disaster recovery solutions, and optimizing the performance of SQL Server databases.
Key Responsibilities
- Manage and maintain SQL Server databases (2012 and above) to ensure high performance and availability.
- Install, patch, and upgrade SQL Server infrastructure, including handling disaster recovery (DR) and backup/restore tasks.
- Ensure databases are configured for optimal performance and that all backups are performed and recoverable as per business requirements.
- Implement and maintain database disaster recovery solutions.
- Manage backup strategies and ensure efficient backup and restore operations.
- Perform point-in-time recovery when necessary.
- Monitor database performance using tools such as SQL Trace, Execution Plans, Extended Events, and Dynamic Views.
- Optimize queries, indexes, and database structures to improve performance.
- Identify and resolve performance bottlenecks.
- Perform CIS hardening of SQL Server databases.
- Apply security patches and fixes to ensure compliance with internal and external security regulations (GDPR, SOX).
- Monitor and maintain database security policies, roles, and permissions.
- Ensure optimal performance of SQL Server instances on both Linux and Windows operating systems.
- Collaborate with the network and infrastructure teams to configure servers, storage, and virtualized environments to support database operations.
- Use Windows PowerShell to automate database management tasks, including job scheduling, backups, and monitoring.
- Develop scripts to handle routine maintenance tasks and improve operational efficiency.
- Troubleshoot and resolve database issues, including failed jobs and SSIS packages.
- Provide support for database migrations, upgrades, and server consolidations.
- Handle database provisioning, maintenance, and performance issues as part of day-to-day operations.
- Work closely with application development and infrastructure teams to ensure database-related requirements are met.
- Document database configurations, procedures, and recovery strategies.
- Collaborate on cloud migration projects and other IT initiatives.
Required Skills & Qualifications
- Strong SQL DB Administration skills on SQL Server 2012 or higher (e.g., 2016, 2019).
- Proficient in database disaster recovery, backup and restore strategies.
- Expertise in SQL Server performance tuning using Dynamic Views, SQL Trace, Execution Plans, and Extended Events.
- Hands-on experience with PowerShell scripting for automation and troubleshooting.
- Knowledge of CIS Hardening and security vulnerability fixes.
- Cross-platform expertise: Configuring Windows and Linux operating systems for optimal SQL Server performance.
- Strong background in logical and physical database design and database migrations.
- High availability configurations, including replication, clustering, and disaster recovery.
- Understanding of database security and auditing, including GDPR and SOX compliance.
Desirable
- Experience with MSSQL Always-On and Analysis Services.
- Knowledge of Oracle 11g/12c/18c/19c, Sybase ASE, and MongoDB.
- Familiarity with cloud platforms like AWS, Azure, or GCP.
- Experience in database migrations and upgrades, including Oracle RAC, DataGuard, and Sybase ASE.
- Working knowledge of Red Hat Linux, Oracle Solaris, VMware, and Nutanix HCI.
- Knowledge of CI/CD tools such as GitHub, JIRA, Confluence, ServiceNow, and TeamCity.
- Familiarity with SAP Sybase (ASE 12.5 / 15.7 / 16.0) and Snowflake.
- DevOps skills: Knowledge of tools like BMC Control-M, CyberArk, and cloud-native tools.
Desired Soft Skills
- Strong communication and collaboration skills to work with cross-functional teams.
- Ability to troubleshoot complex database issues and provide fast solutions.
- A proactive attitude toward database management and ensuring systems run smoothly and securely.
- A customer-first mindset, ensuring that database systems align with business needs and user requirements.
Why Join TCS?
- Global Opportunities. Work on large-scale, complex, and impactful projects with international clients.
- Growth & Learning. TCS offers continuous opportunities to learn and grow through various training programs and global exposure.
- Innovative Culture. Be part of a team that fosters innovation, creativity, and forward-thinking in the IT domain.
- Work-Life Balance. TCS emphasizes maintaining a healthy work-life balance, promoting employee well-being.
How to Apply. Click on the Easy Apply button to submit your application or reach out to the HR team for further inquiries.