Tata Consultancy Services · 19 hours ago
MSSQL DBA
Tata Consultancy Services is seeking a Microsoft SQL Server Database Administrator with expertise in Oracle and PostgreSQL. The role involves managing SQL Server databases, optimizing performance, and ensuring high availability and disaster recovery strategies.
Enterprise SoftwareCloud ComputingConsultingInformation TechnologyBusiness Information SystemsIT Management
Responsibilities
Install, configure, and upgrade SQL Server instances (2016/2019/2022)
Deploy and manage SQL Server on Windows and Linux platforms
Configure SQL Server on Azure (Azure SQL Database, Managed Instance, SQL VM)
Set up and maintain development, testing, and production environments
Implement SQL Server clustering and Always On Availability Groups
Configure database mirroring and log shipping for disaster recovery
Monitor and tune SQL Server performance using DMVs, Extended Events, Query Store
Analyze and optimize query execution plans
Implement and maintain index strategies (clustered, non-clustered, columnstore)
Perform database defragmentation and statistics updates
Configure Resource Governor for workload management
Optimize tempdb configuration and usage
Conduct capacity planning and performance baseline analysis
Design and implement comprehensive backup strategies (full, differential, transaction log)
Perform database restores and point-in-time recovery
Test disaster recovery procedures regularly
Implement and maintain backup compression and encryption
Configure and manage backup retention policies
Document and maintain RTO/RPO requirements
Automate backup verification processes
Configure and maintain Always On Availability Groups
Implement and manage failover cluster instances (FCI)
Set up database mirroring and log shipping solutions
Design multi-datacenter DR strategies
Perform regular failover testing and documentation
Monitor synchronization health and latency
Develop T-SQL scripts for automation and maintenance
Create and manage SQL Server Agent jobs
Implement PowerShell scripts for administrative tasks
Automate database deployment and refresh processes
Build monitoring and alerting solutions
Develop self-service tools for development teams
Deploy and manage SSIS packages and projects
Configure and maintain SSRS report servers
Support SSAS tabular and multidimensional models
Troubleshoot ETL processes and data integration issues
Optimize package execution and resource usage
Manage Oracle Database instances (11g/12c/19c)
Perform basic Oracle administration tasks (user management, tablespaces, backups)
Monitor Oracle database performance and health
Execute Oracle patching and minor upgrades
Support application teams with Oracle-related issues
Assist with Oracle to SQL Server migrations
Maintain Oracle backup and recovery procedures
Troubleshoot Oracle connectivity and performance issues
Deploy and maintain PostgreSQL databases (versions 12+)
Configure PostgreSQL replication and high availability
Perform backup and recovery operations (pg_dump, pg_basebackup)
Monitor PostgreSQL performance and optimize queries
Manage user roles, permissions, and authentication
Support application development teams with PostgreSQL
Implement PostgreSQL security best practices
Assist with PostgreSQL to SQL Server migrations
Develop and maintain database standards and best practices
Create comprehensive technical documentation
Participate in 24/7 on-call rotation for production support
Collaborate with development teams on database design
Work with infrastructure teams on server provisioning
Plan and execute database migrations and consolidations
Conduct root cause analysis for database incidents
Provide training and mentoring to junior DBAs
Evaluate new database technologies and tools
Participate in change management and release processes
Qualification
Required
5+ years of hands-on MS SQL Server DBA experience in enterprise environments
2+ years of experience with Oracle or PostgreSQL databases
Experience with cloud database platforms (Azure SQL, AWS RDS)
BACHELOR OF COMPUTER SCIENCE
SQL Server 2016/2019/2022 administration and architecture
Advanced T-SQL programming and query optimization
Always On Availability Groups, Failover Clustering, Database Mirroring
SQL Server Integration Services (SSIS) administration
SQL Server Reporting Services (SSRS) configuration
SQL Server Analysis Services (SSAS) support
Performance Monitor, Extended Events, Query Store, DMVs
SQL Server Profiler and Database Engine Tuning Advisor
Backup and recovery strategies (native, third-party tools)
Security features: TDE, Always Encrypted, Row-Level Security, Dynamic Data Masking
Azure SQL Database, Azure SQL Managed Instance
SQL Server on Linux
Replication (transactional, merge, snapshot)
Change Data Capture (CDC) and Change Tracking
Oracle Database 11g/12c/19c administration
Oracle backup and recovery (RMAN)
Basic Oracle performance tuning
PL/SQL knowledge
Oracle user and privilege management
Oracle RAC and Data Guard awareness
Oracle Enterprise Manager familiarity
PostgreSQL 12+ installation and configuration
PostgreSQL backup strategies
Query optimization and indexing
Streaming replication setup
Basic PostgreSQL security and user management
psql command-line interface
pgAdmin or similar tools
Preferred
Microsoft Certified: Azure Database Administrator Associate
MCSA/MCSE: Data Management and Analytics (legacy)
Oracle Certified Associate/Professional (preferred)
PostgreSQL Certified Professional (preferred)
ITIL Foundation certification
Company
Tata Consultancy Services
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
H1B Sponsorship
Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
Recent News
2026-02-12
2026-02-12
Company data provided by crunchbase