Add office photos
Engaged Employer
i
This company page is being actively managed by
Hexaware Technologies Team. If you also belong to the team, you
can get access from
here
Hexaware Technologies
Compare
All Filters
190 Hexaware Technologies Jobs
Database Track Engineer
3-6 years
Kolkata, Mumbai, New Delhi + 4 more
1 vacancy
Database Track Engineer
Hexaware Technologies
posted 1mon ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Define database standards and architecture
Recommend database standards and architecture
Maintain database standards and architecture
Participate in database design and review
Define requirements for physical database consolidation
Define requirements for database backup and recovery
Define requirements for application database disaster recovery
Define requirements for specialized backup services such as backup to disk.
Define requirements for database backup data requiring long term retention and for data requiring archiving
Define requirements for specialized storage services related to databases
Define requirements for different storage tiers for new or additional database requests
Define initial network (LAN and/or WAN) bandwidth requirements for database
Define performance requirements for different databases
Develop and maintain technology standards
Document and publish technology standards per directions from CUSTOMER . Any new technology write-ups to be treated as a project.
Confirm technology standards are consistent with approved architectures
Develop and maintain implementation standards
Confirm implementation standards are consistent with approved technology standards
Ensure adherence to standards
Manage exceptions and/or changes to standards
Document, publish and maintain operational processes to support services
Capacity Planning
Define key business metrics or indicators that drive database utilization
Identify key system metrics or indicators that drive capacity planning process
Collect capacity and performance data
Regular proactive analysis of capacity and utilization data
Provide exception notification and reporting on an on-going basis
Prepare and lead quarterly capacity reviews, covering but not limited to current period growth, trends, next period forecast, concerns and replenishment recommendations
Define rapid or on-demand capacity provisioning strategy, including methodology for maintaining surplus capacity
Provide capacity replenishment recommendations in line with quarterly capacity reviews and on-demand provisioning strategy
Provide access to real-time capacity metrics and ad-hoc capacity planning reports
Capacity planning tool selection
Define process for adding additional capacity
Operations Management
Installation, Migration and Up gradation of databases based on CUSTOMER requirements.
Create & manage ASM file system.
Review Oracle Quarterly Patches and determine impact to CUSTOMER DB environment. Plan, schedule and coordinate database patching
Keep track/inventory of all the database instances in CUSTOMER environment monthly (including Oracle, SQL Server and MySQL) and produce a report.
Change Management
Create tables and indexes per application requirements - (after data architecture review by CUSTOMER )
Coordination with Business & IT
Monitor, diagnose and resolve database issues related to but not limited to installation, configuration and performance
Support data export and import requirements
Create copies of data/ databases as requested
Perform database refresh
Create and maintain database links
Plan table space maintenance
Execute table space maintenance
Monitor and manage database space
Maintain database inventory
Create and maintain indexes per CUSTOMER requirements
Maintain TNSNAMES as needed
Support database hot & cold backups
Create and manage database security and user permissions
Approval for database security and user permissions
Create and manage database user ids
Approval for creating user ids
Configure and manage database audit profiles
Perform database recovery as per procedures
Perform database tuning on an ongoing basis
Perform database maintenance per CUSTOMER requirements and schedule
Assist application debugging utilizing database logs and traces
Recommend database performance improvement measures on an ongoing basis as per OEM & SCOM
Oracle Enterprise Manager Management Server Administration
patch & upgrade OEM manager as needed.
OID Management (including replication server)
patch & upgrade OID as needed.
RMAN Catalog & Script Management
Configure & schedule RMAN backups
test/verify RMAN backups.
Monitoring & Administration of DBASS (PDB & CBD) databases
Support APEX on Autonomous Database
Create DB links from/to APEX application.
Configure APEX for AZURE SSO.
Listener Administration
Address critical and warning alerts displayed in OEM
Address metric collection errors in OEM
Review OEM Policy Violations and come up with recommendations to CUSTOMER team on how best to address them
Data Guard Implementation, Monitoring & Administration
OEM Agent Installation, Upgrade and Administration
Installation of Webserver related to DB technology (Oracle version of Apache etc.)
Create and maintain database partitioning
ASM - Administration (Limited to Support and utilization of tool for DB management after KT)
Oracle Data Mining - Administration: -Granting privileges to create/use data mining models. Export/import of data mining models.
Setting up example schema for data mining.
Oracle Server - Scripting and Automation
Validation Management using QDCS process
Follow Validation Protocol - ISQA requirements
Database Configuration Management
Define standard database configurations to meet customer s various computing environment requirements
Maintain documentation of servers and database configurations
Maintain documentation to reflect changes in requirements
Continually update and maintain the database for additions, changes
configurations and CUSTOMER approved configurations ( e.g. version control)
Maintain previous working state for database configurations for
Configure the database so that applications software can perform per service levels
Confirm standards are consistent with approved architectures
Manage exceptions to standards
Evaluate any required non-standard products per business requirements
Database Software License Management
Monitor Compliance of license agreements
Confirm all installed software is properly licensed
Optimize SW license purchasing agreements
Maintain system software licenses for environment
Cancel licenses
Remove and dispose of retired software with CUSTOMER approval
Database Monitoring
Job Monitoring
Alert Monitoring
Enabling OEM Support
Engaging OEM for escalations or support needs
Establishing new policies & processes
Highlight and propose upgrades for end-of-life database versions
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Track Engineer roles with real interview advice
People are getting interviews at Hexaware Technologies through
People are getting interviews through
(based on 451 Hexaware Technologies interviews)
Job Portal
Campus Placement
Walkin
Referral
Company Website
Recruitment Consultant
37%
24%
11%
8%
6%
2%
12% candidates got the interview through other sources.
High
Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.
What people at Hexaware Technologies are saying
What Hexaware Technologies employees are saying about work life
based on 5.5k employees
Flexible timing
Monday to Friday
No travel
Day Shift
Hexaware Technologies Benefits
Submitted by Company
Group Mediclaim Insurance Skill Upgradation Paid time off Rewards and Recognition
Submitted by Employees
View more benefits 
Compare Hexaware Technologies with
Cognizant
Compare
TCS
Compare
Infosys
Compare
Wipro
Compare
HCLTech
Compare
Tech Mahindra
Compare
LTIMindtree
Compare
Mphasis
Compare
KPIT Technologies
Compare
Persistent Systems
Compare
DXC Technology
Compare
NTT Data Information Processing Services
Compare
Sutherland Global Services
Compare
eClerx
Compare
Coforge
Compare
Virtusa Consulting Services
Compare
L&T Technology Services
Compare
CGI Group
Compare
Cyient
Compare
GlobalLogic
Compare
Similar Jobs for you
Hexaware Technologies Chennai Office Locations
Chennai Office
Hexaware Technologies, H5, Sipcot IT Park, Navallur Post, Kancheepuram District
Chennai
Tamil Nadu 603103
Tamil Nadu 603103
Chennai Office
Hexaware Solutions Pvt. Ltd, T Nagar
Chennai
Tamil Nadu 600006
Tamil Nadu 600006
Senior Technical Consultant - Insurance
4-8 Yrs
Kolkata, Mumbai, New Delhi +4 more
CLOUD AMAZE - Integration Architect (Practice)
2-8 Yrs
Kolkata, Mumbai, New Delhi +4 more
Share an Interview