Roles and Responsibilities:• Ensuring database availability to 99.9% around the year.• Monitoring database performance and identifying problems that arise and address them around the clock.• Co-ordinate with global team (US, India, Nepal) for change task, incident management & address them, support on day to day operational tasks.• Configuring jobs/scripts for alerts and address them.• Rapid provisioning of databases using Oracle ZFS, Delphix for development and testing… Show more Roles and Responsibilities:• Ensuring database availability to 99.9% around the year.• Monitoring database performance and identifying problems that arise and address them around the clock.• Co-ordinate with global team (US, India, Nepal) for change task, incident management & address them, support on day to day operational tasks.• Configuring jobs/scripts for alerts and address them.• Rapid provisioning of databases using Oracle ZFS, Delphix for development and testing purposes.• Co-ordinate with oracle global support for Platinum Patching of Exadata.• Help/guide junior team members, for troubleshooting, configuration, upgrade & installation. • Configuration/Installation of MAA environments.• Help developers for tuning of SQL queries and give suggestions for optimal performance.• Migration of databases from non-Exadata to machines to Exadata boxes• Development of shell scripts for automation, backups.• Designing and implementing data management processes: security, lifecycle management, and operational readiness.• Implementation of Partitioning, Advanced Security, Active Data Guard, Advanced Compression, Golden Gate (HA/Unidirectional/Bidirectional)• Inspection of SQL/PLSQL code for performance issues. Show less

Responsible for the technical and administration support regarding Oracle Database infrastructure for clients including major commercial banks (Nepal Investment Bank Limited, Bank Of Kathmandu, Global IME Bank, Himalayan Bank Limited), Payment Gateways ( Nepal Electronic Payment Systems, Smart Card Technology) and Telecom (Nepal Telecom, United Telecom, Ncell) on various platforms like IBM AIX, Sun Solaris, Redhat, Oracle Enterprise Linux.- Developing scripts/procedures/functions for… Show more Responsible for the technical and administration support regarding Oracle Database infrastructure for clients including major commercial banks (Nepal Investment Bank Limited, Bank Of Kathmandu, Global IME Bank, Himalayan Bank Limited), Payment Gateways ( Nepal Electronic Payment Systems, Smart Card Technology) and Telecom (Nepal Telecom, United Telecom, Ncell) on various platforms like IBM AIX, Sun Solaris, Redhat, Oracle Enterprise Linux.- Developing scripts/procedures/functions for implementation and configuration of Oracle database features.- Installing,platform migration, version upgrades, patching (CPU, PSU, SPU) and maintaining databases (RAC, Standalone, Standby).- Configuring and administration of ASM and ACFS.- Administration of the database including performance monitoring and tuning using database metrics, AWR , ADDM, ASH reports.- Oracle ASO installation and configuration.- Populating a database with new information or transfer existing data into it.- Plan, implement and maintain backup, restore and (disaster) recovery policies and procedures.- Responsible for database security and also preventing data loss.- Design of physical database schema, data modeling.- Configuring and Creating Development and Test databases from production databases.- Configuring and Installation of Database Vault, Enterprise manager cloud control, AVDF- Regular Database health checkups.- Contributing as a technical team member in consulting, designing, and implementing database support and implementation projects.- Identifying and addressing client needs: building solid relationships with clients; develop an awareness of firm services; communicate with the client in an organized and knowledgeable manner; delivering clear requests for information.- Contributing to a positive working environment by building solid relationships with team members.- Interface with Oracle Corporation for technical support.- Provide 24*7 supports to clients when required. Show less

Responsible for developing database schema, analyzing database queries and tuning, data modeling, web sites and web applications using PHP, HTML, CSS, JavaScript, JQuery.