MSSQL DBA Professional

About this opportunity:

Infra Cloud Team is looking for Technical Authority Expert (JS5) to Investigate, diagnose, and troubleshoot, Perform MSSQL Database Administration. Technical Proficiency in Oracle Database Administration as a Secondary skill is an added advantage. The candidate has to follow standard procedures for proper escalation of unresolved issues to the appropriate internal teams and talk to clients (internal) through a series of actions, either via phone, email, or chat, until the request is closed.

What you will do:

Proven experience as a Microsoft SQL Server DBA, managing enterprise-level database systems.
Strong knowledge of Microsoft SQL Server, including database design, administration, performance tuning, and troubleshooting.
Experience with database backup and recovery strategies, including disaster recovery planning and implementation.
Proficiency in SQL programming and scripting languages.
Familiarity with database security concepts and best practices.
Understanding of high availability (HA) and failover clustering technologies.
Excellent analytical and problem-solving skills, with the ability to diagnose and resolve complex database issues.
Strong organizational and time management skills, with the ability to handle multiple tasks and priorities simultaneously.
Microsoft SQL Server certification (eg, MCSA, MCSE) or equivalent industry certifications.
Experience with cloud-based database platforms, such as Microsoft Azure SQL Database.
Familiarity with data warehousing concepts and technologies.
Knowledge of PowerShell or other automation tools for database administration tasks.
Experience with performance monitoring and tuning tools, such as SQL Server Profiler or Extended Events.
Effective communication and interpersonal skills, with the ability to collaborate with cross-functional teams and communicate technical concepts to non-technical stakeholders.

The skills you bring:

Oracle 10g, 11g, 12c, 18C, 19C versions (18 & 19 Additional benefits)
Performance tuning (Optimizing Queries, Instance Tuning)
Upgrade knowledge on oracle database upgrade from 12c to 19c and 11g to 12c.
Installation, configuration and upgrading of Oracle server software and related products (clients, RAC 2 nodes, stand Along)
Good Understanding of RAC (2 nodes or 3 nodes) and its services
Understanding Active/Passive, Active-Active (ASM and Veritas Cluster)
A good knowledge of the physical database design
A good understanding of the underlying operating system (windows, unix, linux, solaris & AIX)
Different OS few important commands to check the server load (top, topas sar ,vmstat
Partitioning (Partition Tables and it s type understanding Range, Hash etc) and partition pruning.
Indexing (Local and Global Index, its benefits and drawbacks)
Worked on Heavy databases 100+ TB (Filesystem and ASM)
Adding Disk in ASM and Adding datafiles in RAC, tempfiles etc.