Experience
5 - 7 yrs
Job Location
Bengaluru, India
Vacancy
1
Designation
SQL Database Administrator
Job Type
ONSITE
Job Description
- 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:
- o Database design utilizing various objects development such as Packages, Procedures, Functions, Triggers for business logic implementation
- o T-SQL procedures development, compilation and debugging stored Procedures
- o DB Troubleshooting, performance and tuning
- o Experience in Logical and Physical Database modelling
- Experienced in Database Performance, Maintenance and Development to perform the following:
- o Database management including backups, recovery and maintenance
- o Database management for export, import and mass data loads
- o Analyzes and generation of all tables and index statistics
- o Monitoring and resolving data lock issues
- o Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes
- o 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.
- Education Required:
- B.E/B.Tech Computer Science , MCA or Equivalent
No Referrers Available
There are currently no referrers available for this job. You can still apply, will let you know once there is any referrer available.