Walk-in || Tcs Hiring MSSQL For Chennai

Job description

**Job Title: -Database Administrator (Oracle & MSSQL DBA)** **Experience:-** 6 10 Years **Location:-** Chennai (Flexible / 24x7 On-call Support) **Department:-**Information Technology (IT) Database Administration (DBA) **Job Summary** TCS is seeking a skilled **Database Administrator (DBA)** with strong expertise in **Oracle and Microsoft SQL Server**. The candidate will be responsible for managing database environments, ensuring performance, availability, security, and reliability. The role includes database administration, performance tuning, backup and recovery, and HA/DR implementations in a mission-critical environment. **Key Responsibilities** 1. Database Installation & Configuration - Perform **database installation, configuration, upgrades, and migrations** - Ensure proper environment setup for Oracle and MSSQL databases 2. Database Security & Patch Management - Implement and maintain **database security standards** - Apply **Service Packs, Hotfixes, and Security Patches** 3. Performance Tuning & Optimization - Identify performance bottlenecks and perform **query optimization and tuning** - Monitor database performance and improve system efficiency 4. Backup, Recovery & Disaster Management - Design and implement **backup and restore strategies** - Perform **point-in-time recovery** during critical failures - Ensure database recoverability and data integrity 5. High Availability & Disaster Recovery (HA/DR) - Manage HA/DR solutions such as: - **AlwaysOn Availability Groups** - **Database Clustering** - **Database Mirroring** - **Log Shipping** - Ensure minimal downtime and high system availability 6. Capacity Planning & Monitoring - Perform **capacity planning** for database systems - Enable proactive monitoring using tools, scripts, and alerts 7. Automation & Job Scheduling - Design and maintain **automated jobs and scripts** for routine database tasks 8. Documentation & Knowledge Management - Create and maintain **database documentation, SOPs, and runbooks** - Ensure proper knowledge transfer and documentation updates 9. Incident & Problem Management - Identify recurring issues and provide **permanent solutions (RCA)** - Handle critical incidents and ensure resolution within SLAs 10. Stakeholder & Client Coordination - Participate in **weekly client connects and status discussions** - Provide **global on-call support** for critical production environments **Mandatory Skills** - Strong experience in **Oracle and Microsoft SQL Server (MSSQL)** - Database Administration (DBA) expertise - Backup & Recovery, Performance Tuning - HA/DR configurations (AlwaysOn, Clustering, Mirroring, Log Shipping) **Good-to-Have Skills** - Experience as a **SQL Server DBA** in enterprise environments - Strong knowledge of **Performance Tuning & Optimization (PTO)** - Hands-on with **backup models and recovery strategies** - Experience in large-scale **production database environments** - Strong troubleshooting and analytical skills **Soft Skills** - Strong **problem-solving and critical thinking** ability - Sense of ownership and accountability - Good communication and client interaction skills **Working Conditions** - Willingness to provide **24x7 on-call support** - Ability to handle **mission-critical production systems** **Hiring Note (TCS Style)** The candidate should have hands-on experience managing **enterprise database environments**, with strong expertise in **performance optimization, HA/DR setups, and database security**, along with the ability to support critical production workloads. **Primary Skills (For Portal Entry)** - MSSQL - Oracle Database - Database Administration (DBA) - Performance Tuning - Backup & Recovery - High Availability / Disaster Recovery