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.
F) - Familiar; (P) - Proficient; (E) - Expert.