Manoj Kumar Email & Phone Number

Noida, Uttar Pradesh, India

Fiserv Banking Solutions all projects have historically experienced ongoing performance and stability issues and root cause analysis challenges. These issues are directly impacting end users and potentially jeopardizing client relationships. To both stabilize the platform and improve client confidence, GalaxE is being engaged to provide an independent service to assist with a comprehensive review, assessment, and improvement of the end to end Notify software, infrastructure as well as operational support and quality assurance processes

Bengaluru Area, India

This Project covers all the business of Hertz. I am involved to support all SQL server databases, the responsibilities involved in the SQL server Production support and Projects implementation & SQL server architecture and team handling

Faridabad Area, India

Project: www.eliindia.com (ELIINDIA, ELIRESEARCH, ELIGLOBAL, AAPC, IOPW, BECKETT)This Project covers all the business of ELI. I am involved to support all SQL server databases, the responsibilities involved in the SQL server Production support and Projects implementation & SQL server architecture.Responsibilities:Technical Skills:• Installing and Configuring of SQL Server 2005, SQL Server 2008 & R2, 2012 and 2014.• Creation and maintenance of Fail over cluster (Active/Active, Active/passive) environments, depends on the application and business requirements Active- active and Active – passive clusters.• Manage SQL databases in cluster/standalone environments• Implementing warm stand by servers, implementing Log shipping in some of the databases.• Responsible for maintenance of DR solutions like Mirroring, log shipping and Replication• Data Migration and Upgrade from SQL Server 2000 Servers to SQL server 2012 and 2014.• Worked on Client/Server tools like SQL Server Management studio (2005/2008& R2, 2012 & 2014), SQL Server Enterprise Manager, SSMS and SQL Server Query Analyzer to Administer SQL Server• Worked extensively MS SQL 2005/2008 R2 Database Development like writing Store Procedures, Triggers, Views, User Defined Functions, code reviewing and improving the query performance• Developing SQL scripts for maintaining administration tasks.• Create Database and Database Objects Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.• Implementing SQL coding standards in writing Stored procedures, Triggers, Views, SQL functions and locking issues Environment: MS SQL Server 2005/2008,R2,2012,2014,Visual Studio 2005,2008,2012, Windows 2000/2003/2008/2012, R2 IIS 6.0,7.0, SQL Server Integration Services(SSIS), SSRS, ASP.NET, Excel, TSQL, Replication, Cluster, Redgate, OpManager, Idera tools.

Noida

SQL SERVER DBA” in MS SQL Server 2005, 2008, 2008 R2 which includes Database server support, high availability, Clustering, Replication models including, Optimization, Maintenance Plans, SSIS Packages, Reporting Services, T-SQL Programming; Project: www.chetu.com (CHETU INDIA) and SJRMC.MS SQL Server 2005/2008,R2,Visual Studio 2005,2008,2010 Windows 2000/2003/2008, IIS 6.0,7.0, SQL Server Integration Services(SSIS),SSRS,ASP.NET, Excel, TSQL, Replication, Cluster, NLB, SCOM, share point.Responsibilities:Installing and Configuring of SQL Server 2005 and SQL Server 2008 & R2.Manage SQL databases in cluster/standalone environments.Backup and Restore on SQL SERVER 2005/2008/R2.Migration from MS-SQL Server 2000 to MS-SQL Server 2005/2008/R2.Database Designing, creating Database, users and giving appropriate permissions.Performing and monitoring daily database operations and set-up backup schedules.Configure linked server.Configuring Replication in Test and Production environments. Check replication on each server by checking each publication to make sure the distributor is running for each subscription & Trouble Shooting the Replication Failures in the Test and Production Environments.When replication is stopped, or changes to replication are made, send an email to the DBA group. Maintaining Database Log and Managing the Log files.Check the SQL Server backups. If a backup failed, research the cause of the failure and ensure that it is scheduled to run tonight.Index tuning & rebuilding index defragmentation.SSIS Package Creation.Application support as well as the Database support Related to the Microsoft Products and also Debugging the Applications and the stored Procedures whenever the support is needed by the Testers and the DevelopersMonitor the status of Maintenance jobs – schedule to run daily and on weekends .If a job failed, resolve the issue by contacting the owner of the job if necessary.

Responsibilities:• Database designing, creating database, users and giving appropriate permissions.• Providing support development team for writing triggers, views, user defined functions and stored procedures.• Involved in performance tuning in SQL Server through Query, Server & Database Level & Query optimizations.• Using DTS (Import-Export).• Scheduling backups for MS SQL Server databases.• Security administration for MS SQL Server.• Producing reports to client (weekly & monthly).• Regular backup & restoring database on development, acceptance & production server, use of replication, clustering & security administration for MS SQL server.e customer...