Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

Home
>
Jobs in Hyderabad
>
Zensar
>
DATABASES-Engineering-Oracle

DATABASES-Engineering-Oracle

Zensar

5 - 10 years

8 - 12 Lacs

Hyderabad

Posted:6 days ago| Platform:

Apply

Skills Required

Performance tuning Data management Database design Powershell Database administration Stored procedures Oracle Monitoring SQL Capacity planning

Work Mode

Work from Office

Job Type

Full Time

Job Description

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 Qualification:

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.

More Jobs at Zensar

Urgent Opening For GenAI with Python

Pune, Bengaluru, Hyderabad

6 - 10 yrs

INR 16 - 31 Lacs

PERL PL/SQL Developer

Pune

3 - 5 yrs

INR 8 - 9 Lacs

BUSINESS FINANCE MANAGER

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

5 - 15 yrs

INR 22 - 27 Lacs

Senior Data Architect

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

7 - 9 yrs

INR 9 - 11 Lacs

Martech resources - Internal

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

4 - 7 yrs

INR 9 - 13 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.