Experience

EIT SERVICES

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Senior Database Administrator- (MSSQL Server & ORACLE)

  • Oct 2015 - Present

  MSSQL Server, Oracle and PostgreSQL DBA, Team Management, Task Assignment, Critical Call, ORACLE Database Installation and configuration of 11g, 12c, 19c and 21c on various platform, Linux, HP Unix, and AIX. Oracle Database Migration, Upgradation, Performance Tuning, Monitoring. Providing 24*7 supports for oracle 11g, 12c and 19c databases handling the incident tickets which must be resolved within SLA and implementing the requests to change the requested changes to the databases. Monitoring 11g and 12c OMS/OEM continuously to make sure no database services to be down. Plan and co-ordinate with team members to have a smooth operational activity. Operational Support involves effectively monitor and resolve critical issues of customers oracle instances. Creation of Tablespaces, user maintenance, database security imposition by creating and granting of roles and privileges, performance tuning, backups using RMAN. Performance-tuning services for clients with ADDM, AWR, and troubleshooting databases using oracle utilities. Configure LISTENER & TNSNAMES files & troubleshooting. Review alert logs files to check for any problems related to databases. Working with Space Management Alerts (Data file, max extents, and database file system alerts. Example: Archive log file system alerts.). Performed RMAN Point in time Database recovery on oracle. Working with traditional and data pump utility for the selective data export and import on production/test/dev on client/online team request basis. Written the shell scripts to automate the jobs as per business requirement. Using STATSPACK/AWR to generate the report to check the performance and ADDM report recommendations. Maintaining the process related documents up to date for important database activities such as Server down time, DR Activities, timing of RMAN backups, errors in the alert log files and Known Issues etc. Dataguard Setups, and Fixing bugs, applying Patches, Managing ASM Databases, Show less



Tata Consultancy Services

• India
• IT Services and IT Consulting
• 700 & Above Employee

• IT Analyst

  • Dec 2010 - May 2021

  MSSQL Server Database Migration, Upgradation on Windows and Linux Team Management, Task Assignment, Critical Call Resolution, High Availability, Disaster Recovery Solution, Log Shipping, Database Mirroring, Clustering, Replication, Backups, Restore, Index Architecture, Database Maintenance Plan, Reporting Services, Integration Services, Security, Performance Tuning, Installations, configuration, Sore Procedure, functions, views, triggers, Database fragmentation & compression, SQL profiler, Database tuning adviser, Performance dashboard, Perfmon, Resource Monitor, Apply Patches & Hot fix. Database growth analysis, Disk space management, Future planning for disk according to database growth analysis. Schedule jobs monitoring, SQL server mail configurations, Resource Governor, Policy Based Management, Table Partition, Always On Availability, SQLCMD Utility, BCP Utility, MSSQL License etc Show less



Saggezza India Pvt. Ltd.

• India

• Database Administrator

  • Jun 2014 - Nov 2015

  MSSQL Server Database Migration, Upgradation on Windows and Linux Team Management, Task Assignment, Critical Call Resolution, High Availability, Disaster Recovery Solution, Log Shipping, Database Mirroring, Clustering, Replication, Backups, Restore, Index Architecture, Database Maintenance Plan, Reporting Services, Integration Services, Security, Performance Tuning, Installations, configuration, Sore Procedure, functions, views, triggers, Database fragmentation & compression, SQL profiler, Database tuning adviser, Performance dashboard, Perfmon, Resource Monitor, Apply Patches & Hot fix. Database growth analysis, Disk space management, Future planning for disk according to database growth analysis. Schedule jobs monitoring, SQL server mail configurations, Resource Governor, Policy Based Management, Table Partition, Always On Availability, SQLCMD Utility, BCP Utility, MSSQL License etc Show less



Thakral One Solution Pvt. Ltd.

• India

• Database Administrator

  • Aug 2011 - May 2014

  MSSQL Server Database Migration, Upgradation on Windows and Linux Team Management, Task Assignment, Critical Call Resolution, High Availability, Disaster Recovery Solution, Log Shipping, Database Mirroring, Clustering, Replication, Backups, Restore, Index Architecture, Database Maintenance Plan, Reporting Services, Integration Services, Security, Performance Tuning, Installations, configuration, Sore Procedure, functions, views, triggers, Database fragmentation & compression, SQL profiler, Database tuning adviser, Performance dashboard, Perfmon, Resource Monitor, Apply Patches & Hot fix. Database growth analysis, Disk space management, Future planning for disk according to database growth analysis. Schedule jobs monitoring, SQL server mail configurations, Resource Governor, Policy Based Management, Table Partition, Always On Availability, SQLCMD Utility, BCP Utility, MSSQL License etc Show less



Reffels Solution Pvt. Ltd

• India

• Database Administrator

  • Feb 2009 - Dec 2010

  MSSQL Server Database Migration, Upgradation on Windows and Linux Team Management, Task Assignment, Critical Call Resolution, High Availability, Disaster Recovery Solution, Log Shipping, Database Mirroring, Clustering, Replication, Backups, Restore, Index Architecture, Database Maintenance Plan, Reporting Services, Integration Services, Security, Performance Tuning, Installations, configuration, Sore Procedure, functions, views, triggers, Database fragmentation & compression, SQL profiler, Database tuning adviser, Performance dashboard, Perfmon, Resource Monitor, Apply Patches & Hot fix. Database growth analysis, Disk space management, Future planning for disk according to database growth analysis. Schedule jobs monitoring, SQL server mail configurations, Resource Governor, Policy Based Management, Table Partition, Always On Availability, SQLCMD Utility, BCP Utility, MSSQL License etc Show less



VGL Softech Pvt. Ltd., Jaipur

• India

• Software Engineer

  • Aug 2008 - Jan 2009

  Working On: High Availability, Disaster Recovery Solution, Log Shipping, Database Mirroring, Clustering, Replication, Backups, Restore, Index Architecture, Database Maintenance Plan, Reporting Services, Integration Services, Security, Performance Tuning, Installations, configuration, Sore Procedure, functions, views, triggers etc. C. Business Intelligence (BI) parts :- 1. Integration Services (SSIS):- Import and Export Wizard, Package Installation wizard, Controller Flow, Data Flow, Event Handlers, SSIS Tasks, Sequence containers, For loop containers, Foreach Loop Container, Sources like OLE DB Source, Excel Source, Flat File Source, Raw File Source, XML Source, Data Reader Source, Destinations like Excel destination, Flat File Destination, OLE DB Destination, Raw File destination, SQL Server destinations. Transformations like Aggregate, Audit, Data conversion, Derived column, Export column etc. 2. Reporting Services (SSRS):-Creating Reports with Reports Wizard. Modifying Reports and Creating report with repot designer. Publishing a report to Report Server, Creating a report model, creating a report Using report builder, report management, Managing Published reports, Report Manager, Report Designer, Report Builder, Model designer, Reporting Services Configuration tool, Report server command prompt utilities Show less



Aastha Enviro Systems Pvt Ltd.

• Machinery Manufacturing

• Database Administrator

  • Jul 2004 - Jul 2008

  Design And Development of Equipment, Backups, Planning Design And Development of Equipment, Backups, Planning