Oracle DBA Consultant

Soft tech Career Info system Pvt. Ltd
  • Pune
  • 6-10 lakh
  • 3-8 years
  • Views
  • 15 Dec 2017

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

- Requires 2-5 years of related experience in the design, maintenance, and administration of relational databases

- Minimum of 5 years experience with developing software at the data layer in a Oracle Databases.

- Minimum of 2 to 5 years of Oracle Engineered systems (Super cluster/Exadata).

- Provides expert-level technical support for all of the wireless data systems applications

- Lead Oracle scaling efforts with transactions that doubles every 12 months

- Performing capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects

- Identifying potential service level problems before they occur and notifying appropriate parties

- Create written reports of findings and recommendations on performance analysis, feasibility studies, and proof of concept evaluations

- Complex Query tuning for n-tier, mission critical, customer facing Web applications

- Support Data migrations efforts with the Merger projects

- Ensure control, integrity and accessibility of the data

- Consult with project sponsors regarding information flow and content including the facilitation of information gathering sessions

- Ensure compliance in related tasks with company and regulatory policies and procedures and deliver on-call support for critical database applications as needed

- Assist in the development of project plans and deliverable lists for proposed projects

- Develop and maintain database standards, conventions, data dictionaries, data element naming standards

- Managing the storage capacity of the systems

- Staying abreast of the most current release of Oracle, including compatibility issues with operating systems, third party software and utilities

- Support of daily operations including job monitoring and troubleshooting of the 24x7 production

- Design, develop, and maintain back-up strategy

- Keeping the database up to date on patches and supporting the roll-out of new versions

- Creating and maintaining various database environments to support the system life cycle efforts

- Provide advice in Table Partitioning in alignment with logical/physical modeling, design and performance

- Evaluates 3rd party software and makes recommendations to Sr. Management

- Maintains knowledge in state-of-the-art technologies and methodologies

Logging support cases as necessary and effectively working with Oracle to resolve issues

Competencies/Skill sets for this job

Architects Query Table Partitioning Projects Consult Resolve Issues

Job Posted By

O.P. Chawla