Sr Administrator Database

Operating System a Check drive file system availability b Check resource utilization c Maintain connectivity to the server with opened ports including Telnet FTP SCP SSH MSTSC etc using available tools d Review risk assessment of the supplier and contracts on a regular basis e Ensure that there is adequate IT capacity to meet required levels of service f Ensure that senior IT management is correctly advised on how to match capacity is optimized g Analysis of usage and performance data and reporting on performance against targets contained in SLA Database Management a Create indexes take back up b Generate performance reports using tools c Create manage database files with guidance d Troubleshoot connectivity issues e Administer and alter security and audit parameters under guidance f Troubleshoot authentication issues with guidance g Carry out patching under guidance using SOP h Monitoring Alert and Trace files i Design and deploy new database servers under minimal guidance according to the client requirements High Availability a Troubleshooting of High availability issues under guidance SOP b Configure Database Mirroring and Log shipping c Communicate with L3 support for any issue Enterprise Management Tools Native a Perform administrative jobs of database using enterprise management tool b Independently configure OEM on any OS platform c Independently troubleshoot any issues with the Listeners connect strings and sqlnet ora file Backup Recovery a Perform back up recovery under minimal guidance using SOP b Proactive monitoring and administration of RMAN utility and its various parameters c Administer and alter security and audit parameters under guidance d Manage different parameters used in Password file Database Migration Upgradation a Move the logins or individual database objects to the newer versions of various database versions and fix the compatibility levels feasibility between older versions and the new ones b Identify performance bottlenecks arising out of network issue troubleshoot using networking addon solutions Performance Tuning a Populate data into database tables using PL SQL scripts according to business requirements b Checking CPU consumption IO Consumption and memory consumption of Database Servers PLSQL Scripting a Release management for critical applications b Monitoring and support of critical applications 2nd level support Oracle Scripts for data ware house application Technical Skills a Systems Administration Network Administration A b Data Management F c High Availability F d IT Enterprise Management Tools F e Database backup and Recovery F f Database Migration F g Database Monitoring Performance Tuning A h PL SQL F Behavioral Skills a Email Communication Presentation Public Speaking F b Interpersonal Skills F Nurturing Relationships A c Customer Service Orientation Business Appreciation F d Strategic Thinking Transactions Processing Planning A e Analytical Thinking Scientific Temperament A