Animesh D.

Animesh D.

Experience of 13.0 years in oracle/sql Database and Oracle Forms,Reports and Microsoft Sql Server

Noida , India

Experience: 13 Years

Animesh

Noida , India

Experience of 13.0 years in oracle/sql Database and Oracle Forms,Reports and Microsoft Sql Server

37200 USD / Year

  • Notice Period: 30 Days

13 Years

Now you can Instantly Chat with Animesh!

About Me

RAC Server,DBA,Monitoring database through OEM,Oracle ASM,Oracle8i/10g,Forms6i/10g,Reports9i/10g,Toad,Sql Server 2012,2014,2016,Always-on...

Show More

Portfolio Projects

ERP-HMIS

Company

ERP-HMIS

Description

  • Installation, configuration and Administration of Oracle 8i/9i/10g database.
  • Proficient knowledge of Oracle Database 10g technologies including RAC and    CRS, ASM, RMAN.
  • RAC Instance Monitoring, SQL Statement Monitoring, RAC Instance  Startup/Shutdown, RAC Node to ASM
  • Database monitoring and tuning, application and queries using AWR, ASH, OEM     and custom scripts.
  • Perform Oracle database administration tasks include configuration management, backup/recovery, Performance Tuning & Capacity Monitoring, query optimization,      Data Security, RMAN Managed Backup,  EXPDP  and  IMPDP  and                              space management.
  • Experience in taking logical backups of data using oracle data pump utilities Expdp        and Impdp to move Oracle data from a database or schema to another
  • Managing table spaces and removing the logs of RAC database and Application Servers for space management.
  • Expert in database administration (undo, redo, space, memory management).

Show More Show Less

Lab Information System

Company

Lab Information System

Role

Project Manager (Team Lead)

Description

Installing SQL server 2012, 2014 and document actions.
• Perform database monitoring, maintenance, reorganizations, resource management, schema management, capacity planning, backup/restore and performance tuning for the company's databases, Fragmentation, DBCC Commands.

• Good Command over Shrinking DB & files, Index Monitoring & Maintenance

• Check SQL Server Instance Up-time, Last Full, Differential and Log Backup Times, Check Failed SQL Agent Jobs in the Last 24 Hours, Current Log for Failed Logins, Blocked Processes, Top N Queries Based on Average CPU Time, Drive Volumes Space, Index Fragmentation

• Install, configure and deploy MS SQL Server. Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases.

• Maintenance and support of SQL server Mirroring, Log shipping, Clustering, and other methods of disaster recovery

Show More Show Less

up100

Company

up100

Role

Analysts (Non programmer role)

Description

Install database systems, applying optimum access techniques; coordinating installation actions and document actions.

• Maintenance and support of SQL server Mirroring, Log shipping, Clustering, and other methods of disaster recovery
• Perform database monitoring, maintenance, reorganizations, resource management, schema management, capacity planning, backup/restore and performance tuning for the company's databases, Fragmentation, DBCC Commands.

• Good Command over Shrinking DB & files, Index Monitoring & Maintenance

• Working Exposure of SSRS, SSIS & SSAS.

• Implement HA/DR solutions like Database Mirroring, Always-ON, Clustering, Database Replication and Log Shipping for critical production databases as requested.

• Provide after-hours support critical cases as required and be part of on-call

•Experience in Created maintenance plans to perform index defragmentation,

   Re- indexing and update the index statistics with Database backup tasks.

 • Strong Understanding of Database Recovery Models with Different types of Backups    and Restore including Tail Log backup and Point in Time Recovery.

 •Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities

Show More Show Less

UPHMIS

Company

UPHMIS

Role

Analysts (Non programmer role)

Description

Overall in-charge of the division in management, implementation, analysis and performance of Database.

•To conduct facility-based analysis of HMIS Implementation

•Participate in technical architecture and design discussions as required.

•Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

•Experience in Configuration, Maintenance, Administration and Upgrading of SQL Server 2012, 2014, 2016 and having good knowledge of Database architecture.

•Perform database monitoring, maintenance, reorganizations, resource management, schema management, capacity planning, backup/restore and performance tuning for the company's databases etc.

• To analyze and use supportive supervision checklists Data for identifying gaps and corrective action

•100?ta Completeness of facilities of Division

•Support Divisional review meeting by ensuring proper use of data for evidence based decision making.

•Analyze various reports with primary focus on RMNCH+A related activities

•To organize training and hand holding sessions at Division

Show More Show Less

Skills

SQL