Consultant - Database

  • Bangalore
  • Confidential
  • 2-5 years
  • Views
  • 03 Oct 2018

  • IT/ Information Technology

  • Consumer Durables/ Semi Durables
Job Description

Role Competencies Technology 1. Proactive monitoring and administration: Has designed and implemented database cluster on any OS cluster server. Efficient in determining the root cause of the issue and find a permanent fix for the same. 2. OS and Networking: Has hands- on experience in identifying issues in OS/ Network with help of basic commands sar, du, Sysinfo, top, fdisk, ping, netlookup etc. and communicate with respective team to fix the issue. Then document the Cluster in knowledge repository 3. Oracle/ SQL/ DB2/ Sybase Database Management: Has Excellent knowledge on all 'Administration Tools of database Server and its features, administration tools like 'OEM'/ 'SSMS'. Will be able to design and deploy new database servers under minimal guidance according to the client requirements. 4. Database Architecture, Basic Administration, Security and Auditing: Has extensive know- how of database Net architecture and has been actively involved in implementing database advanced concepts like Clusters. Will be able to identify performance bottlenecks arising out of network issue. Understands networking add- on solutions. Has Excellent command on all OS flavors and releases. Has good understanding of various patch level compatibilities with database releases. Has good scripting knowledge to implement DB related scripts/ jobs. Has designed and implemented security and auditing standards for large databases. Aware of the different roles and privileges available to be granted to the users. Aware of how DB access can be controlled through database parameters 5. High availability: Has excellent experience of handling cluster, failsafe, load balancer and High Availability solutions. Should be able to construct cluster and document the same for Operations. Should have excellent troubleshooting skills and resolve the issues and document them. 6. Enterprise management tools Native: Has comprehensive know- how of the DB console and can customize / integrate the tool with other tools to requirement. Should be able to perform backup and recovery and performance tuning using DB console. Should be able to independently configure DB console on any OS platform. 7. Backup / Recovery and Performance Tuning: Has designed and implemented various backup and recovery strategies on heterogeneous environments. Can recover the database with no or minimal data loss. Can independently tune databases to extract best performance including memory, OS and SQL tuning. Can also groom peers. Will be able to analyze the statistics report and rectify the bottlenecks efficiently with a minimum downtime. MAIN RESPONSIBILITIES AND ACTIVITIES 1. Troubleshooting: Analyze and resolve technical queries of customer - High Sev Incidents, Major Changes, Change Scripting, Problem Management Tickets, RCA preparation, Understand product technology and prepare technical documentation, SOPs, Transitions of new tech, Deployment of servers , Attend conference calls with technical escalation points onsite./ Customer/ RCA reviews/ High critical incidents conference calls Total Experience In Years I hereby declare and confirm that all the information provided by me as a part of this application is true and correct to the best of my knowledge.

Job Posted By

Divya Lakshman
Lead - Corporate Talent Acquisition

About Organisation