SME - Database
6d ago

Operating System Monitoring OS disk management, drives / mount points aligned to sever Maintain connectivity to the server with opened ports including FTP / SCP / SSH / MSTSC etc.

as well as diagnose the issue and present to respective team for resolution Implement database cluster on any OS cluster server Handle any OEM, RMAN, User managed backup, export import and expdp & impdp.

Database Management Configure authentication Work other support groups in isolating failures and performance degrade Fix performance related issues, identify and analyze root cause Suggest work around and permanent solutions in discussions with OEM Carry out changes, analyze statistics and take statistics report.

High Availability Construct cluster and document the same for Operations. Data replication, Clustering and Mirroring Enterprise Management Tools - Native Configure DB console on any OS Customize enterprise database console Manage the data layer and particular areas of potential challenge / risk in the data layer Enterprise database administration using a leading RDBMS ideally in both a front line support and a project support capacity Monitor, disaster recovery, backup, recovery, upgrade, migration, deployment.

Backup / Recovery Implement backup and recovery strategies on heterogeneous environment Recover data with minimal data loss Database Migration / Upgradation Handling database migrations for large enterprises with database sizes over 2 TB Fix the schema or data type mismatches which could crop up due to the migration Perform migrations to IaaS and Paas Translate functional requirements into technical solutions, exploiting innovation where appropriate.

Propose recommended and / or best practices regarding the movement, manipulation, and storage of data. Address governance and security challenges associated with data.

Performance Tuning Proactively Identify and resolve various performance bottlenecks at DB / Application level Work with various teams to resolve performance issues (development, DBA) " PL-SQL Scripting Manage logical Data Models e.

g. merging transactional data within a transaction table with relevant reference data residing in other databases Design, develop and deploy business rules and requirement into PL / SQL and ETL code for data analysis, transformation, and cleansing.

  • Write Complex SQL Queries, Dynamic SQL, Analytical function, various Oracle Objects, etc. Technical Skills Systems Administration, Network Administration (F)Data Management (P)High Availability (P)IT Enterprise Management Tools (P)Database backup and Recovery (P)Database Migration (P)Database Monitoring & Performance Tuning (P)PL / SQL (P) Behavioral Skills Email Communication, Presentation, Public Speaking (P)Strategic Thinking, Transactions Processing, Planning (P)Analytical Thinking, Scientific Temperament (A)Interpersonal Skills (P), Nurturing Relationships (A)Customer Service Orientation, Business Appreciation (A) Proficiency Legend : (A) - Aware;
  • F) - Familiar; (P) - Proficient; (E) - Expert.

    Report this job

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form