Oracle Database Admin L3

Year    Bangalore, Karnataka, India

Job Description


Company Name: VARITE India Private LimitedAbout The Client:
A global information technology, consulting, and business process services company, headquartered in India, provides a broad spectrum of services, including IT consulting, application development, business process outsourcing, and digital solutions. Serving clients across diverse industries and in over 167 countries, the company offers technology-driven solutions to enhance efficiency and innovation. With a global presence, it has emerged as a key player in the IT services and consulting space, contributing to the digital transformation of businesses worldwide.Essential Job Functions:

  • Handled large database estates and managed TB size of databases
  • Installation and administration of multiple versions of databases on multiple Unix platforms and Windows servers
  • Design and implement the high availability solutions (RAC, Golden Gate and Dataguard)
  • Install, configure and manage ASM instances in oracle
  • Plan and execute major migrations and upgrades
  • Define and configure the disk and diskgroups in ASM and troubleshoot
  • Manage and administer the databases on Exadata machine
  • Plan the database upgrade, migration and patching
  • Plan and implement the backup/recovery on need basis
  • Hardware tech refresh (host to host database move)
  • Coordinate and work with database vendors for resolution on major incidents
  • Database refresh, re-org, backup using RMAN and 3rd party tools
  • Install and configure grid control database monitoring tools
  • Install, Administer, manage and troubleshoot Oracle grid control
  • Define performance benchmarks and metrics
  • Periodic database instance performance review and tuning recommendation
  • Proactive database analysis and suggestion to application team / business
  • Write and troubleshoot shell scripting, SQL and PL/SQL scripts
  • Primarily role is supporting the production and non-prod database environments
  • Ensure the reduction of repeated errors through implementation of necessary checkpoints
  • Contribute towards evaluation of tools, products and software selection
  • SLA tracking and reporting to Higher management
  • Prepare and Maintain Standard Operating Procedure for all activities
  • Proactive identification of risks and mitigation of the same
  • Technical presentation on emerging technologies.
  • Foresee the need for newer technology based trainings on customer needs and provide suggestions for such trainings to Project Manager.
  • Implement and Periodical check on Automation
  • Implement and Periodical check on DB Security
  • Identify, document and track Technology related risks and mitigation plan in the project
  • Technical and Process guidance to L2 and L1 DBA
  • Provide 24x7 and on call support for critical application databases
Qualifications:
  • Oracle Database Admin- Oracle Architectural understanding
  • Memory and space management
  • Knowledge on RAC/ASM/Data guard as part of High availability
  • Privilege management.
  • Transaction management and monitoring.
  • Basic on Oracle Multitenancy.
  • Backup/restoration management(RMAN ,export/import)
  • Analysis and troubleshoot skill for common oracle related issue/error.
  • Pre-verification and post-verification oracle skill.
  • Database Performance tuning
  • Very basic analytic skill to ensure the person can technically work independently without any support (except process)
  • Flexible to support any shift during weekday and weekend support.
  • Knowledge on Shell script or any alternative or any automation tool is an added advantage.
  • Knowledge on PostgreSQL, MongoDB will bring added advantages to the profile
Primary Skill (Technical Skill): Oracle DBASecondary Skill (Optional):
  • OS - Solaris/Linux/AIX/Client UNIX & Windows
  • Database - MySQL/MS SQL & Windows OS / Sybase / DB2 /
/MongoDB/SAP HANAEducational Qualifications: B.E. / B.Sc. / DiplomaExperience Level: 5 - 8 Years Technical Skill
  • Must Have:
  • Strong database administration
  • Database upgrades on multiple versions and releases
  • High availability (RAC) setup and administration
  • Disaster recovery design, planning, setup and administer the Dataguard (standby)
  • Install, configure, maintain and troubleshooting on Golden Gate
  • Knowledge on ExaData
  • OEM Configuration and management
  • Automation through scripting
  • Strong performance analysis on AWR, ADDM, SQL Profile, ASH and advisory views
  • Experience on OS, Storage, Network and Virtualization activities
  • Certification on Primary Technology
  • Handled database estate of various technologies
Process & Tools:
  • Must Have:
  • Service Request and Incident, Problem, Change managements
  • Configuration, Capacity planning and Knowledge management
  • Experience on ITIL Tools like Remedy, Service Now or any other ticketing tool
  • Identify the service improvement plan
  • Nice to have:
  • ITIL Foundation certified
Behavioral Skill:
  • Must Have:
  • Strong verbal and written communication skills
  • Team management and motivation
  • Flexibility, good attitude
  • Nice to have:
  • Manage the global infrastructure customer and projects
How to Apply: Interested candidates are encouraged to respond/submit their updated resumes, and for additional job opportunities, please visitUnlock Rewards: Refer Candidates and Earn.
If you're not available or interested in this opportunity, please pass this along to anyone in your network who might be a good fit and interested in our open positions. VARITE offers a Candidate Referral program, where you\'ll receive a one-time referral bonus based on the following scale if the referred candidate completes a three-month assignment with VARITE.Experience Level Bonus Referral: 0-2 years INR 5,000
2-6 years INR 7,500
6+ years INR 10,000About VARITE: VARITE is a global staffing and IT consulting company providing technical consulting and team augmentation services to Fortune 500 Companies in USA, UK, CANADA and INDIA. VARITE is currently a primary and direct vendor to the leading corporations in the verticals of Networking, Cloud Infrastructure, Hardware and Software, Digital Marketing and Media Solutions, Clinical Diagnostics, Utilities, Gaming and Entertainment, and Financial Services.Equal Opportunity Employer:
VARITE is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, marital status, veteran status, or disability status.

Varite

Beware of fraud agents! do not pay money to get a job

MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD3336574
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Bangalore, Karnataka, India
  • Education
    Not mentioned
  • Experience
    Year