OS disk management and connectivity to the server with opened ports Establishing a connection and creating a session/logins. Configure database Client tools. Perform simple connection troubleshooting. Database Management Connect to DB console. Check error logs, resources for utilization status - in line with physical structure, provide SOP based isolation Database indexes, Database Backups, performance reports using tools, Database file management, User credentials management using SOP High Availability Check the status of high availability services (such as clusters, replication, mirroring and dataguard etc.) Identify issue and alert L2/L3 support 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 Imperva SecureSphere. Managing imperva gateways and agents settings and activation. Monitor oracle/MS SQL database user activities using Arcsight SIEM tool and imperva GUI Backup/Recovery Monitor back up jobs / recovery jobs and report exceptions Perform closed/hot Database Backups. Configure basic statspack and know how to take statspack report. Basic administration of OEM console Proactive monitoring and administration of RMAN utility and its various parameters. Administer and alter security and audit parameters under guidance. Manage different parameters used in Password file 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 Performance Tuning Complete development of units with designs prepared by more senior developers. Participate in code reviews, prepares and executes unit tests. PL-SQL Scripting Application and Database Server monitoring and support of critical applications as part of the OE. Coding and Testing of Jobs, Scripts [Oracle and Unix shell scripts] as applicable for different business applications. KPIs Customer: 1 client appreciation per quarter Zero escalations in a year 1 Customer facing SIP per year Process: 100% achievement of response & resolution SLAs 100% compliance to service management processes Contribution to AIDR reduction as per program goals & objective Technology: At least one emerging technology training/ year At least one technology certification/year At least 1 structured automation initiative participation/quarter Technical Skills Systems Administration, Network Administration (A) Data Management (A) High Availability (A) IT Enterprise Management Tools (F) Database backup and Recovery (F) Database Migration (A) Database Monitoring & Performance Tuning (A) PL/SQL (F) Behavioral Skills Email Communication, Presentation, Public Speaking(F) Interpersonal Skills, Nurturing Relationships (A) Customer Service Orientation, Business Appreciation (A) Proficiency Legend: (A) Aware (F) - Familiar (P) - Proficient (E) - Expert.