Loaction :- Bangalore
EXP :- 5 + years relevant
JD : Lead SQL Server Operations DBA
• Install and configure new Microsoft SQL Server instances, including Alwayson availability groups and failover clustering. Preferably on Microsoft SQL Server 2022, 2019, 2016.
• Highly skilled at database design and T-SQL development.
• Responsible for database backup and recovery procedures, security and database integrity, physical data storage design and data storage management.
• Configure and manage SQL Security settings.
• Make system design recommendations according to Microsoft SQL Server best practices.
• Manage database backup, recovery & DR planning.
• Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
• Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.
• Troubleshoot application slowness and performance issues.
• Analyzes SQL query plans and refines complex queries for performance tuning.
• Responsible for database migrations and server upgrades.
• SQL Server Integration Services (SSIS) and Data Integration: Develop, maintain, and optimize SSIS packages for ETL (Extract, Transform, Load) processes of large data into and out of Microsoft SQL Server.
• Optimizes data for visualization and Business Intelligence data analysis.
• Perform SQL Server integration with enterprise applications.
Experience Required:
• Experienced in Database Design and Development to perform the following:
◦ Database design utilizing various objects development such as Packages, Procedures, Functions, Triggers for business logic implementation
◦ T-SQL procedures development, compilation and debugging stored Procedures
◦ DB Troubleshooting, performance and tuning
◦ Experience in Logical and Physical Database modelling
• Experienced in Database Performance, Maintenance and Development to perform the following:
◦ Database management including backups, recovery and maintenance
◦ Database management for export, import and mass data loads
◦ Analyzes and generation of all tables and index statistics
◦ Monitoring and resolving data lock issues
◦ Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes
◦ Create indexes to achieve critical dataset response time for time sensitive reports.
• Solid understanding of database security concepts and best practices for Microsoft SQL Server databases.
• Experience with source control tools (SVN/Git).
• Familiarity with programming and/or scripting languages such as: C#, PowerShell
• Familiarity with NoSQL databases such as MongoDB.
• Exposure to SCOM monitoring tool .
• Hands-On Experience in ITIL
• Good communication Skills interacting with global teams.
Activate JobCopilot
Your email job alert is now active!