Oracle and MySQL Database Administrator
- Ensono
- 8 - 13 years
- Pune
- 4 years ago
- Email to a friend
- Report this job
Job Description
Shift- 5.30 pm to 2.30 am
Location- Pune/Chennai
Notice Period- 2 months or less
Interested candidates can send the profile on su***********e@en***o.com
Roles and Responsibilities
- Responsibility for client project initiatives and support for Oracle and MySQL platforms.
- Design and enhance, upgrade, or build new client Oracle and MySQL environments
- Work closely with clients daily on projects, troubleshooting, or consultations.
- Perform software installations, upgrades, and patches to Oracle/MySQL instances and servers
- Define and maintain Oracle/MySQL standards and governance while performing all database activities
- Utilize industry standard technologies & methods to ensure the integrity & recoverability of Oracle and MySQL databases and applications.
- Perform strategic analysis and design of Oracle and MySQL infrastructure and make recommendations on improvements and/or new systems required to meet business needs and future capacity.
- Serve as technical resource to business analysts, solutions development, and other groups responsible for Oracle and MySQL application development standards, system design and integration.
- Ensure Oracle and MySQL systems remain at operational excellence during infrastructure improvements (hardware/software upgrades server migrations/consolidations, application deployment, etc.).
- Assist in creating new or maintaining documentation, runbooks knowledge articles and diagrams.
Youll be part of a line 3 Oracle support team, supporting the migration and BAU activities of mission critical infrastructure of Ensonos clients, delivering a responsive and exceptional support service for client events and requests. Using a best-in-class client service management platform you will effectively be working on client projects, providing solution deliveries to clients on complex environments and infrastructure, and supporting at times our day to day business as usual support activities from our clients. The job entails:
- Working with clients on issues, requests and project tasks
- Working proactively and reviewing high level project requirements and deliverables.
- Working with internal infrastructure teams on database related activities.
You will achieve common goals with our Oracle team to create a positive learning environment where knowledge sharing will help all Oracle associates be able to support the environment in the migrated DC. The position will be challenging with opportunities to work on a broad range of Oracle and MySQL systems, software and products.
Desired Candidate Profile
- Excellent understanding of Oracle and MySQL Database technology and administration (builds, upgrades, patching, migrations, troubleshooting multiple versions of Oracle/MySQL)
- Experience with version 19c and migration/upgrade procedures
- Excellent understanding with networking terminology
- Expert understanding of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, using AWR reports etc.
- Extensive experience and knowledge of the Linux OS
- SQL and PL/SQL
- Setup and migration experience with Oracle RAC clusters
- UNIX Shell Scripting
- Project Management skills
- Detailed knowledge of RAC, Grid Infrastructure, ASM, ACFS/DBFS, Oracle GoldenGate, DataGuard, Oracle Exadata, ZDLRA, ZFS, RMAN, expdp/impdp
- Working knowledge of Materialized Views, SQL Performance Analyzer (SPA), Real Application Testing (RAT), Advanced Compression, Encryption
- Configuration of OEM and various plugins (OGG, Exadata, etc)
- Experience with Oracle Veridata (nice to have)
- Excellent technical awareness of IT server infrastructure
- Must have excellent communication skills since working directly with the client is a significant requirement of this position.
Skills
- A client centric approach
- Excellent demonstrable English written and verbal communication skills
- Able to communicate in groups with confidence and conviction
- Ability and experience to resolve complex problems independently of Oracle vendor support
- Ability to multi-task and work well under pressure
- Excellent team working skills are essential
- Ability to document processes and procedures in a clear, concise and logical manner
- Self-starter with the capability to work independently and produce positive results that will keep migration timelines on schedule
Experience
- At least 8-10 years experience in an IT Oracle support environment
Perks and Benefits
Job Classification
Industry: IT-Software, Software ServicesFunctional Area: IT Software - DBA, Datawarehousing,
Role Category: Programming & Design
Role: Programming & Design
Employement Type: Full time
Education
Under Graduation: Any Graduate in Any SpecializationPost Graduation: Any Postgraduate in Any Specialization
Doctorate: Any Doctorate in Any Specialization
Contact Details:
Company: Ensono TechnologiesAddress: QUBIX BUSINESS PARK PRIVATE LIMITED,OFFICE NO. 1, , 6TH FLOOR, IT8 BUILDING, SEZ, PLOT NO. 2,BLUE RIDG, E TOWNSHIP, NEAR COGNIZANT,NEAR RAJIV GANDHI INFOTECH PARK,HINJEWADI, PHASE-I, PUNE, Maharashtra, India
Location(s): Pune
Keyskills: Database Administration MySQL Oracle Data Center
Ensono
Your relentless ally for digital transformation, operating your IT for today and optimizing it for tomorrow.
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in