Now you can Instantly Chat with ANIMESH!
About Me
Applications support and resolution of problems related to the RDBMS. Conducting performance-tuning monitoring/maintena nce of various databases. Performing backup/recovery, installation and upgrades of RDBMS. Troubleshooting problems. Providing prod...
Show MoreSkills
Positions
Portfolio Projects
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 LessDescription
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 LessDescription
- 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).
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