Job Description : Roles & ResponsibilitiesOperating Systema OS disk management and connectivity to the server with opened ports b Establishing a connection and creating a session/loginsc Configure database Client tools.
d Perform simple connection troubleshootingDatabase Management a Connect to DB consoleb.
Check error logs, resources for utilization status - in line with physical structure, provide SOP based isolationc Database indexes, Database Backups, performance reports using tools, Database file management, User credentials management using SOPHigh Availability a Check the status of high availability services (such as clusters, replication, mirroring and data guard etc)b Identify issue and alert L2/L3 supportEnterprise Management Tools - Native a.
Login and monitor database using enterprise management toolb Creating reports, analyzing application violations, alerts, action sets and system events and security policies on Impervo Secure Spherec Managing Impervo gateways and agents settings and activationd.
Monitor oracle/MS SQL database user activities using Arcsight SIEM tool and imperva GUIBackup/Recoverya Monitor back up jobs / recovery jobs and report exceptionsb Perform closed/hot Database Backupsc Configure basic stats pack and know how to take stats pack report.
d Basic administration of OEM consolee Proactive monitoring and administration of RMAN utility and its various parametersf Administer and alter security and audit parameters under guidance.
g Manage different parameters used in Password fileDatabase Migration/Upgradation a Move the databases from older database version to new versionsb Fix the login issues which could crop up due to the migration of database Performance Tuninga.
Complete development of units with designs prepared by more senior developers b Participate in code reviews, prepares and executes unit testsPL-SQL Scripting a Application and Database Server monitoring and support of critical applications as part of the OE.
b Coding and Testing of Jobs, Scripts [Oracle and UNIX shell scripts] as applicable for different business applicationsTechnical 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)