Job Description

Additional details
Level
P2
Requirement location
India - Bengaluru
Number of Position
1
Employment type
ML
Cluster/Group
Microland Delivery
Business Unit
EMEA
Department
Data Center - Tech Ops




Required Skill
Technology - Database|Experience of database upgrade/migrations
Technology - Database|Quarterly patch applications
Technology - Database Administration, General|Database Support
Technology - Database Administration, General|Implementing Database Builds/Deployments

Details
Roles & Responsibilities
1. Operating System

• OS disk management and connectivity to the server with opened ports
• Establish a connection and creating a session/logins.
• Configure database Client tools.
• Perform simple connection troubleshooting.

2. Database Management

• Connect to DB console.

- Check error logs, resources for utilization status - in line with physical structure, provide SOP based isolation

• Handle Database indexes, Database Backups, performance reports using tools, Database file management, User credentials management using SOP

3. High Availability

• Check the status of high availability services (such as clusters, replication, mirroring and data guard etc.)
• Identify issue and alert L2/L3 support

4. Enterprise Management Tools - Native

• Login and monitor database using enterprise management tool
• Creating reports, analyzing application violations, alerts, action sets and system events and security policies on Impervo Secure Sphere.
• Manage Impervo gateways and agents settings and activation.
• Monitor oracle/MS SQL database user activities using Arcsight SIEM tool and imperva GUI

5. Backup/Recovery

• Monitor back up jobs / recovery jobs and report exceptions
• Perform closed/hot Database Backups.
• Configure basic stats pack and know how to take stats pack report.
• Carry out the Basic administration of OEM console
• Proactively monitor and carry out the administration of RMAN utility and its various parameters.
• Administer and alter security and audit parameters under guidance.
• Manage different parameters used in Password file

6. Database Migration/Upgradation

• Move the databases from older database version to new versions.
• Fix the login issues which could crop up due to the migration of database

7. Performance Tuning

• Carry out the complete development of units with designs prepared by more senior developers.
• Participate in code reviews, prepares and executes unit tests.

8. PL-SQL Scripting

• Handle Application and Database Server monitoring and support of critical applications as part of the OE.
• Code and Test Jobs, Scripts [Oracle and UNIX shell scripts] as applicable for different business applications.

Technical Skills
a. Systems Administration, Network Administration (A)
b. Data Management (A)
c. High Availability (A)
d. IT Enterprise Management Tools (F)
e. Database backup and Recovery (F)
f. Database Migration (A)
g. Database Monitoring & Performance Tuning (A)
h. PL/SQL (F)
Behavioral Skills
a. Email Communication, Presentation, Public Speaking(F)
b. Interpersonal Skills, Nurturing Relationships (A)
c. Customer Service Orientation, Business Appreciation (A)