Administrator - Database

Pune
3 - 5 years of experience
Job Description
Roles & Responsibilities 
Operating System 
 a. OS disk management and connectivity to the server with opened ports 
b. Establishing a connection and creating a session/logins. 
c. Configure database Client tools. 
d. Perform simple connection troubleshooting. 
Database Management
a. Connect to DB console. 
b. Check error logs, resources for utilization status - in line with physical structure, provide SOP based isolation 
c. Database indexes, Database Backups, performance reports using tools, Database file management, User credentials management using SOP 
High 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 support 
Enterprise Management Tools - Native 
a. Login and monitor database using enterprise management tool 
b. Creating reports, analyzing application violations, alerts, action sets and system events and security policies on Impervo Secure Sphere. 
c. Managing Impervo gateways and agents settings and activation. 
d. Monitor oracle/MS SQL database user activities using Arcsight SIEM tool and imperva GUI
Backup/Recovery 
a. Monitor back up jobs / recovery jobs and report exceptions 
b. Perform closed/hot Database Backups.
c. Configure basic stats pack and know how to take stats pack report. 
d. Basic administration of OEM console 
e. Proactive monitoring and administration of RMAN utility and its various parameters. 
f. Administer and alter security and audit parameters under guidance. 
g. Manage different parameters used in Password file 
Database Migration/Upgradation 
a. Move the databases from older database version to new versions. 
b. Fix the login issues which could crop up due to the migration of database Performance Tuning 
a. Complete development of units with designs prepared by more senior developers. 
b. Participate in code reviews, prepares and executes unit tests. 
PL-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 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)
We are an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, gender identity, sexual orientation, disability status, protected veteran status, or any other characteristic protected by law.