Sme - Database Job in Microland Limited
Job Summary
Job Description 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 MirroringEnterprise 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.
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.
Similar Jobs for you
Your 4 Step Guide to Career Success
Apply for jobs
Create Profile
Schedule Interview
Get Hired
Help us improve JobGrin
Need Help? Contact us