• Save Job
  • 5 - 8 Years
  • Posted : above 1 month

Job Description:

Oracle DBA

Industry IT

Location Gurgaon

Open

Functional IT Software-Other



About Us

Spectrum Talent Management is a comprehensive HR services company offering solutions spanning the entire talent life cycle including Recruitment, Onboarding, Payroll and Flexible Staffing Founded in 2008, we are a continuously growing, yet mature service firm specializing in recruitment and staffing requirements of global organizations Our leadership and high acceptance in the market is evident by the phenomenal growth that we have demonstrated in just few years of our inception From Permanent recruitment to Flexi staffing, Payroll management to RPO, the orbit of the value add that we provide our customers with has always evolved, and diversified from time to time This has enabled us to become a preferred vendor with most of our clients

About Company

Our Client is a specialized global technologyservices provider, led by Business and Technology ConsultingOur clientsDigitaligence workinfuses technology with domain, data, design, and differentiated delivery to significantly enhance experience and efficiency, enabling our clients to differentiate and disrupt their business

Roles and Responsibility

JOB TITLEJOB CODE

Database Administrator Oracle

BAND LEVELFUNCTION CODE

51

EMPLOYEMENT TYPE

Full time Part time Trainee Contractual Others (mention name)

PURPOSE OF THE FUNCTION

DBAs use specialized software to store and organize data The role includes Database support, capacity planning, installation, configuration, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery and general support of the databases

POSITION DESCRIPTION (JOB SUMMARY)

The candidate will be a member of a team within Data Management Services (DMS) called Database Services Client The primary role on the team will be as Oracle Database Administrator supporting various applications, but the individual may be asked to take on additional duties including infrastructure support and cross-training on other DBMS platforms

PRIMARY OBJECTIVES

Resolution of reported service requests, pro-active and reactive performance analysis related to databases

Carry out Database migrations, upgrades, patching and evaluation/roll out of new database related tools

Minimize database downtime and manage parameters to provide fast query responses

Troubleshooting, monitoring and diagnose issues with Oracle Server Database and highly customized jobs

Adherence to documented standards and procedures while doing database related activities like change management

RELATIONSHIPS

REPORTS TO Delivery Manager,DMSSUPERVISES

EXTERNAL RELATIONSHIPS Servicing customers, partners INTERNAL RELATIONSHIPS Working with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services

TASKS, DUTIES & RESPONSIBILITIES

Support Areas

Database Administrative support of Oracle Database Server (12c) Monitoring, maintenance and housekeeping of Server and Databases, Jobs, User Access management and regular client requests Writing and tuning codes and highly customized jobs

Support of application and upgrade database (Database Migration/ upgrade) from existing versions to latest Server versions

Incident Management Knowledge of Incident management process and participation in a rotational on-call schedule to support off hours production incidents

Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises

Maintaining up-to-date documentation and procedures for all supported applications and environments

Maintaining 9999 PERCENT availability for all production environments

Evaluation of functionality and features with newer versions of the Oracle Server DBMS/ database related tools

Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues

Monitoring and support of nightly production batch cycles

Regular review of database maintenance/ support tasks and performance improvement procedures

Work Planning/Escalation Organizing and monitoring personal workload and escalating to manager when issues arise

Continuous Improvement Sharing ideas for process improvement and innovative solutions to known problems

KNOWLEDGE, SKILLS & ATTITUDES

Intermediate Knowledge

Database Maintenance/ Support tasks and lower level monitoring using tools like profiler, DMV, Perfmon
Oracle Server Replication, Backup/ Restore, maintenance plans and DR recovery strategies
Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices, automate)
Understanding of system tables, stored procedures, functions, triggers & tuning
General troubleshooting like assisting clients with various issues related to connectivity, permissions, access, distributed queries issues, suggesting solutions, best practices etc
Server Security, adept in creating and maintain complex User and permission management environment using AD groups, DB roles, ids and Proxy accounts

Desirable to have

Knowledge of Performance Tuning by analyzing, optimizing and rewriting/re-designing codes
Knowledge of Oracle Server database tuning using Profiler, Index Tuning Wizard, Dynamic Management Views and Functions (DMVs), and other third-party tools
Hands-on experience with Oracle Server installations and patching
PowerShell scripting to automate DBA related tasks Ability to understand existing automated tasks and tweak/troubleshoot them
Some knowledge of data-mapping and logical and physical data modeling
Knowledge of clustering, Always on / multi node clusters at the time of DR process
Knowledge of AWS, Specifically, migration to AWS from in premise data center

CORE COMPETENCIES

Strong analytical abilities and willingness to handle medium to complex scenarios

Excellent communication skills (both verbal and written)

Very high commitment levels and willing to work in any shift timings

Strong organizational skills with the ability to do multi-tasking

Detailed oriented, focused approach on handling issues

Taking accountability and ownership

Sharing information and best practices with team members

Drive Knowledge management sessions in expertise skill with team

MINIMUM QUALIFICATIONS & EXPERIENCE REQUIRED

DEGREE/ DEPLOMA IN BE/ B Tech /MCA / M Tech / in Computer Science or related technology PRIOR EXPERIENCE Minimum 5 years of Oracle Server database administration experience handling medium to large databases

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Recruitment/Placement Agencies, Consulting Services
Functional Area : IT Software : Software Products & Services
Role : Database Administration (DBA)
Salary : As per Industry Standards
Deadline : 02nd Jun 2020

Key Skills:

These are some of our most popular tutorials

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status