1 Sql 2017 Jobs

Job Title : SQL DBA Location State : Tamil Nadu Location City : Chennai Experience Required : 6 to 8 Year(s) CTC Range : 7 to 9 LPA Shift: Day Shift Work Mode: Onsite Position Type: C2H Openings: 1 Company Name: VARITE INDIA PRIVATE LIMITED About The Client: Client is an Indian multinational technology company specializing in information technology services and consulting. Headquartered in Mumbai, it is a part of the Tata Group and operates in 150 locations across 46 countries. About The Job: "•Candidate should have extensive knowledge in SQL Server Technologies with at least 4+ years of experience.•Strong experience with MS SQL Server 2008/2008 R2/2012/2014/2016/2017/2019, over 3+ yrs of experience with SQL 2016 & SQL 2017.•Designs, configures, implements, and administers all databases for the respective parties involved.•Possesses and applies broad knowledge of database principles and practices.•Identifies and resolves all issues related to database systems to ensure that systems are online and without service interruption.•Experience with automating DBA tasks, database tuning and capacity planning.•Resolved Database Access Requests, Incidents & remediated CIS Compliance db items.•Provide On Call DBA Support during weekday off peak business hours & weekends as needed.•Analyze and report the performance of database operations against the key database performance metrics.•Meets performance standards in accordance to service level agreements set by the company.•Experience in troubleshooting Databases using Database Diagnostic & Compliance Management tools.•Work on production issues in performance tuning, blocking/locking/deadlocks, Mirroring, Always on, memory pressure, CPU, I/O latency and capacity management.•Experience in High Availability and Disaster Recovery Solutions using SQL Server Always on Technology.•Managed databases Small/Medium dbs & VLDB ranging from 10GB to 5TB.•Implemented & Maintained Standard SQL Maintenance Jobs.•Should be a self-starter and handle Prod Issues & Projects without any guidance.•Collaborate with customers and SMEs to provide sustainable solutions for critical Database design and development across various applications.•Develop an overall database architecture that supports the information needs of the business in a scalable and secure environment.•Implement & Maintain HADR solutions such as Always on, Mirroring, Replication.•Maintain/Deploy custom SQL jobs & ssis packages.•Candidate should have experience in Azure Cloud Migration both PaaS & IaaS solutions.•Experience in Database Backup and Recovery & Monitoring solutions.•Solid Experience in troubleshooting Database issues in Prod & Non-Prod environments.•Extensive experience in Performance Tuning of queries and stored procedures & optimize execution plans for faster application response times.•Experienced in troubleshooting SSIS packages with heterogenous data sources & destinations.•Experienced in developing Reports using SSRS." Essential Job Functions: "•Candidate should have extensive knowledge in SQL Server Technologies with at least 4+ years of experience.•Strong experience with MS SQL Server 2008/2008 R2/2012/2014/2016/2017/2019, over 3+ yrs of experience with SQL 2016 & SQL 2017.•Designs, configures, implements, and administers all databases for the respective parties involved.•Possesses and applies broad knowledge of database principles and practices.•Identifies and resolves all issues related to database systems to ensure that systems are online and without service interruption.•Experience with automating DBA tasks, database tuning and capacity planning.•Resolved Database Access Requests, Incidents & remediated CIS Compliance db items.•Provide On Call DBA Support during weekday off peak business hours & weekends as needed.•Analyze and report the performance of database operations against the key database performance metrics.•Meets performance standards in accordance to service level agreements set by the company.•Experience in troubleshooting Databases using Database Diagnostic & Compliance Management tools.•Work on production issues in performance tuning, blocking/locking/deadlocks, Mirroring, Always on, memory pressure, CPU, I/O latency and capacity management.•Experience in High Availability and Disaster Recovery Solutions using SQL Server Always on Technology.•Managed databases Small/Medium dbs & VLDB ranging from 10GB to 5TB.•Implemented & Maintained Standard SQL Maintenance Jobs.•Should be a self-starter and handle Prod Issues & Projects without any guidance.•Collaborate with customers and SMEs to provide sustainable solutions for critical Database design and development across various applications.•Develop an overall database architecture that supports the information needs of the business in a scalable and secure environment.•Implement & Maintain HADR solutions such as Always on, Mirroring, Replication.•Maintain/Deploy custom SQL jobs & ssis packages.•Candidate should have experience in Azure Cloud Migration both PaaS & IaaS solutions.•Experience in Database Backup and Recovery & Monitoring solutions.•Solid Experience in troubleshooting Database issues in Prod & Non-Prod environments.•Extensive experience in Performance Tuning of queries and stored procedures & optimize execution plans for faster application response times.•Experienced in troubleshooting SSIS packages with heterogenous data sources & destinations.•Experienced in developing Reports using SSRS. •Candidate should have extensive knowledge in SQL Server Technologies with at least 4+ years of experience.•Strong experience with MS SQL Server 2008/2008 R2/2012/2014/2016/2017/2019, over 3+ yrs of experience with SQL 2016 & SQL 2017.•Designs, configures, implements, and administers all databases for the respective parties involved.•Possesses and applies broad knowledge of database principles and practices.•Identifies and resolves all issues related to database systems to ensure that systems are online and without service interruption.•Experience with automating DBA tasks, database tuning and capacity planning.•Resolved Database Access Requests, Incidents & remediated CIS Compliance db items.•Provide On Call DBA Support during weekday off peak business hours & weekends as needed.•Analyze and report the performance of database operations against the key database performance metrics.•Meets performance standards in accordance to service level agreements set by the company.• Qualifications: SQL Server Database Administration How to Apply: Interested candidates are invited to submit their resume using the apply online button on this job post. About VARITE: VARITE is a global staffing and IT consulting company providing technical consulting and team augmentation services to Fortune 500 Companies in USA, UK, CANADA and INDIA. VARITE is currently a primary and direct vendor to the leading corporations in the verticals of Networking, Cloud Infrastructure, Hardware and Software, Digital Marketing and Media Solutions, Clinical Diagnostics, Utilities, Gaming and Entertainment, and Financial Services. Equal Opportunity Employer: VARITE is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, marital status, veteran status, or disability status. Unlock Rewards: Refer Candidates and Earn. If you're not available or interested in this opportunity, please pass this along to anyone in your network who might be a good fit and interested in our open positions. VARITE offers a Candidate Referral program, where you'll receive a one-time referral bonus based on the following scale if the referred candidate completes a three-month assignment with VARITE. Exp Req - Referral Bonus 0 - 2 Yrs. - INR 5,000 2 - 6 Yrs. - INR 7,500 6 + Yrs. - INR 10,000