skillindiajobs
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Associate SME - Database

3.00 to 5.00 Years   Bangalore   23 Feb, 2021
Job LocationBangalore
EducationNot Mentioned
SalaryNot Disclosed
IndustryIT - Software
Functional AreaGeneral / Other Software
EmploymentTypeFull-time

Job Description

Operating System a. Check drive / file system availabilityb. Check resource utilizationc. Maintain connectivity to the server with opened ports including Telnet/FTP/SCP/SSH/MSTSC etc. using available toolsd. Review risk assessment of the supplier and contracts on a regular basise. 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 optimizedg. Analysis of usage and performance data, and reporting on performance against targets contained in SLADatabase Management a. Create indexes, take back upb. Generate performance reports using toolsc. Create, manage database files with guidanced. Troubleshoot connectivity issuese. Administer and alter security and audit parameters under guidance.f. Troubleshoot authentication issues with guidanceg. Carry out patching under guidance / using SOPh. 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 shippingc. Communicate with L3 support for any issue.Enterprise Management Tools - Native a. Perform administrative jobs of database using enterprise management toolb. Independently configure OEM on any OS platform.c. Independently troubleshoot any issues with the Listeners, connect strings and sqlnet.ora fileBackup/Recovery a. Perform back up / recovery under minimal guidance / using SOPb. 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 fileDatabase 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 onesb. Identify performance bottlenecks arising out of network issue & troubleshoot using networking add-on 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.PL-SQL Scripting a. Release management for critical applicationsb. Monitoring and support of critical applications - 2nd level support - Oracle Scripts for data ware house applicationTechnical 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),

Keyskills :
enterprise management toolscustomer service orientationfile systemlog shippingit managementdata managementrisk assessmentcustomer service

Associate SME - Database Related Jobs

© 2020 Skillindia All Rights Reserved