AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Engaged Employer
i
This company page is being actively managed by
Zensar Technologies Team. If you also belong to the team, you
can get access from
here
Zensar Technologies
Compare
All Filters
272 Zensar Technologies Jobs
Sr Tech Operations Analyst DB Platforms
5-7 years
Warangal, Hyderabad / Secunderabad, Nizamabad
1 vacancy
Sr Tech Operations Analyst DB Platforms
Zensar Technologies
posted 6d ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
SQL DBA responsibilities will be to manage cloud engineering activities for SQL Server databases 24/7/365 and would also drive automation activities along with providing SME support to SQL performance team.
Key Responsibilities
- Responsible for all functions associated with the design, implementation and maintenance of SQL Server databases including security, back-up, logging, reporting and recovery procedures
- Manage all technical aspects of the databases and processes
- Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
- Transform data via standardization, cleaning, data repair, matching, and de-duping
- Manage data from multiple sources including internal, external, and 3rd party data
- Assist in maintaining and improving database operational efficiency.
- Perform daily, weekly, and monthly data maintenance tasks
- Assist in developing feeds to Data Warehouse, Marts and data management processes
- Tuning SQL queries to improve performance
- Ensure all database servers are backed up in a way that meets the business s Recovery Point Objectives (RPO)
- Test backups to ensure we can meet the business Recovery Time Objectives (RTO)
- Configure SQL Server monitoring utilities to minimize false alarms
- When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
- Configure SQL Server instances, high availability (Mirroring, Always ON) and patching of these instances.
- Troubleshoot issues related to SQL Server infrastructure (Patching, High availability etc.)
- Proven understanding of SQL coding required to understand performance implications and translate requirements to application developers.
- Experience in writing SQL Stored Procedures / Functions / Views etc.
- Experience in keeping the SQL database up and running and perform the health checks for the databases on periodic basis.
- Experience in helping the Application Team in tuning the SQL queries / batches.
Experience in overall monitoring of SQL Server Databases.
Preferred Skills:
- Design, test, implement and maintain complex databases with the required organization, access methods, access time, validation checks and security to meet or exceed requirements. Develop, edit and maintain required documentation.
- Proactively evaluate, recommend and perform database upgrades and changes. Perform system optimization and improvement planning including, but not limited to, database performance analysis, capacity planning and system sizing. Stay abreast of and recommend improvements in technology and methodology to meet changing business needs and market demands, as well as provide for overall optimization of database administration function.
- Pro-actively monitor the performance of development and production databases to detect existing or potential incidents and/or performance issues.
- Perform tuning and maintenance to correct and prevent unplanned downtime or performance degradation. Ensure operation of database environments meet or exceed agreed upon service levels (e.g. availability and performance).
- Plan, schedule and manage the implementation of new databases and modifications to existing databases in a manner that avoids disruption to production and development systems. Set-up and manage database security, manage data purging/archiving activity and other day-to-day database administration activities.
- Provide ongoing support to operations and support teams as needed. Escalate and manage escalated issues as appropriate.
- Thorough knowledge of SQL Server configuration, High availability configuration, setting up the environment
Required Qualifications
- 5+ years of technology experience of increasing scope and responsibility (e.g. software development, database) expertise in SQL Server 2005, 2008, 2012,2014,2016,2019
- Experience with database design , administration and maintenance in distributed environments.
- Experience in troubleshooting and resolving database issues, including performance tuning and capacity planning .
- Proven expertise in database design, to include solid understanding of related programming languages, clustering , back-up/restore technologies, replication and security.
- Proven understanding of SQL coding required to understand performance implications and translate requirements to application developers.
- Expertise in writing scripts such as Shell, batch, or PowerShell scripts, writing SQL queries to automate DB related jobs.
- Familiar with the automation tools like Ansible.
- Expertise in SQL Server installations and High availability configuration
- Expertise in SQL Server patching and troubleshooting
- Expertise in SQL Server Upgradation
Preferred Qualifications
- Strong working knowledge of industry-standards database management tools.
- Demonstrated, successful experience working in a matrixed, multi-vendor technology environment.
- Demonstrated ability to work effectively in urgent situations with high pressure and visibility.
- Strong written and verbal communication skills.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Operations Analyst roles with real interview advice
Top Zensar Technologies Operations Analyst Interview Questions
Q1. What are the different types of severity that can be assigned to a bug?
asked in
Senior Software Engineer interview
Q2. Feature of oop, difference between function overloading and overriding, constructor, how to delete constructor, explain your projects, link ... read more
asked in
Software Engineer interview
Q3. What are the Testing challenges and how to overcome them ?
asked in
Senior Software Engineer interview
What people at Zensar Technologies are saying
Operations Analyst salary at Zensar Technologies
reported by
2
employees
with 2-3
years exp.
₹4.4
L/yr - ₹5.6
L/yr
At
par with the average Operations Analyst Salary in India
View more details
What Zensar Technologies employees are saying about work life
based on 2.5k employees
Flexible timing
Monday to Friday
No travel
Day Shift
Zensar Technologies Benefits
Submitted by Company
Work From Home Team Outings Health Insurance Vacation & Paid Time Off Sabbatical
Submitted by Employees
View more benefits 
Compare Zensar Technologies with
TCS
Compare
Infosys
Compare
Wipro
Compare
HCLTech
Compare
Tech Mahindra
Compare
LTIMindtree
Compare
Mphasis
Compare
Hexaware Technologies
Compare
Persistent Systems
Compare
DXC Technology
Compare
Sutherland Global Services
Compare
Optum Global Solutions
Compare
FIS
Compare
Virtusa Consulting Services
Compare
CGI Group
Compare
GlobalLogic
Compare
Bosch Global Software Technologies
Compare
UST
Compare
Atos
Compare
Nagarro
Compare
Similar Jobs for you
Zensar Technologies Hyderabad / Secunderabad Office Location
Hyderabad/Secunderabad, Telangana Office
Hyderabad DLF Office Part of 8th Floor, Block 3, DLF Assets Pvt Ltd, DLF Cyber City, Gachibowli Village, Serilingampalli Mandal, Hyderabad 500019, Telangana, India.
Hyderabad/Secunderabad, Telangana
500019
500019
Sr Tech Operations Analyst DB Platforms
5-7 Yrs
Warangal, Hyderabad / Secunderabad, Nizamabad
Senior Salesforce Developer
4-7 Yrs
Warangal, Hyderabad / Secunderabad, Nizamabad
Netgear Architect/Analyst - SaaS Partner Portal Platform
8-11 Yrs
Kolkata, Mumbai, New Delhi +4 more
Share an Interview