Delhi, Gurgaon
15 hours ago
38 Applied
JOB ID:163396
Job Type
Full Time
Functional Area
IT/Software Development - DBA/Datawarehousing
Industry
Banking/Financial Services/Insurance
Education
Other-Any
Experience Required
2 - 4 Yrs
Salary
8 - 10 Lakhs
Key Skills Required
sql, sql server, performance tuning
Other Skills Required
Languages
English
Job Description
- Minimum 2 to 4 years of SQL Server database administration experience handling medium to large databases.
- Basic knowledge of SSAS, CMD Shell Scripting/ FTP shares, Powershell,VB script and .net/C# would be preferred.
- Hands on experience in SQL tools like power designer, DB artisan, Redgate.
- SQL Server
- Minimum 2 to 4 years of SQL Server database administration experience handling medium to large databases.
- Basic knowledge of SSAS, CMD Shell Scripting/ FTP shares, Powershell,VB script and .net/C# would be preferred.
- Hands on experience in SQL tools like power designer, DB artisan, Redgate.
- SQL Server Replication, Backup/ Restore, maintenance plans and DR recovery strategies.
- Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices, automate)
- Understanding of system tables, stored procedures, functions, triggers & SQL tuning.
- Knowledge of Performance Tuning by analyzing, optimizing and rewriting/re-designing SQL codes.
- Knowledge of SQL Server database tuning using Profiler, Index Tuning Wizard, Dynamic Management Views and Functions (DMVs), and other third-party tools.
- Hands-on experience with SQL Server installations and patching.
- PowerShell scripting to automate DBA related tasks. Ability to understand existing automated tasks and tweak/troubleshoot them
Cab Facility Provided
Flexibility Provided
Shift TimingsWith 32 years of operations in the Philippines and 17 years in India, Sun Life Global Solutions, (formerly Asia Service Centres), a microcosm of Sun Life, is poised to harness the regions’ potential in a significant way - from India and the Philippines to the world. We are architecting and executing a BOLDER vision: being a Digital and Innovation Hub, shaping the Business, driving Transformation and superior Client experience by providing expert Technology, Business and Knowledge Services and advanced Solutions. We help our clients achieve lifetime financial security and live healthier lives – our core purpose and mission. Drawing on our collaborative and inclusive culture, we are reckoned as a ‘Great Place to Work’, ‘Top 100 Best Places to Work for Women’, and stand among the ‘Top 11 Global Business Services Companies’ across India and the Philippines.
