Sushil Kumar Rout Email & Phone Number

Noida, Uttar Pradesh, In

Noida, Uttar Pradesh, In

Noida, Uttar Pradesh, In

Attending Microsoft SQL Server Performance Monitoring Master Class From December 14 to December 18. All credit goes to RateGain Travel Technologies Private Limited for giving me an opportunity to learn some of advanced tips and tricks about SQL Server Performance Monitoring

RateGain is a software products company offering innovative and value-driven SaaS based solutions to the hospitality and online travel industry. The company provides on-demand solutions in the area of Revenue Management, Distribution and Sales and Marketing within the hospitality and travel verticals. Customers include Fortune 500 Travel companies and leading Online Travel Agents, Accommodation Wholesalers, Hotel Brands and independent hotels. The company has CMMi and ISO certifications. Responsibilities:-- Responsible for more than 50+ SQL Server Instances (250 + Mission Critical & Highly Transactional Databases) for different segments of Travel (CAR, RAIL, AIR, CRUISE) & HOSPITALITY (Hotels)-- Performance Tuning & Query Optimization-- Capacity Management & Planning-- High Availability-- Responsible for implementing best practices and Security configuration for SQL DB Servers-- Responsible to prepare Standard operation procedures for all SQL DB activities-- Rapid response to address high severity incidents.-- Identification and driving of database related service quality improvements and engineering deliverables.-- Automation and process improvement of database activities.

Gurgaon, Harayana, In

-- Worked on SQL Server Performance Tuning & Query Optimization Process-- Worked on Capacity Management-- Successfully ConfiguredWindows Server Failover Clustering / SQL Server Failover Clustering -- Worked on Transactional Replication With Updatable Subscription-- Worked on Backup / Restoration -- Worked on SQL Server Maintenance Activities-- Worked on SSRS Server Configuration & Deployment Process-- Worked on SSIS Deployment Process

Weston, Florida, Us

-- Microsoft SQL Server 2008, 2008-R2, 2012 (Installation, Configuration and Administration) -- Understand client requirements for projects like (NexusEHR), (NexusPM), NexusBilling etc. -- Design & Develop for modules like Nexus EHR, NexusPM & NexusBilling. -- Managing SQL Server logins, Users, Roles & enforce security on DEV. & PROD. Server. -- Successfully Set up Snapshot Replication on Production Server. -- Successfully Set up Transactional Replication (Peer to Peer) on Production Server -- Successfully Set up Merge Replication (Web Sync) with dynamic filter on HOST_NAME () -- To perform database backup and recovery operations. -- Designed and implemented complex database architecture. -- Created automated jobs for Database Integrity checks, Database Backups,-- Re-organize index, Update Statistics, Rebuild Index Operation.-- History clean up task, Notify operator task, Database Mail etc. -- Troubleshooting performance related issues using tools like Profiler & Performance monitor. -- Detect and troubleshoot SQL Server related CPU, Memory, I/O, disk space & other resource Contention.-- Energize slow running queries with the help of Database Engine Tuning Advisor.

Birmingham, West Midlands, Gb

About The Company -Sepal Technologies is a UK based company which provides end to end IT solutions to its clients globally. Founded in 2004 its Head Office is at Birmingham, UK and branch office is based in New Delhi. It is specialized in developing web applications, customized software development, Mobile Application Development, Streaming Solutions, Online video management solutions and internet TV worldwide. It is engaged in providing services to media & entertainment and IT industry.Worked for Sunlight HQ™ is a state of the art retail platform enabling music, media and entertainment companies and individuals to maximise profit from selling digital and physical products through their own website,• Architect of different major OLTP databases (Design Databases Logically & Physically)• Handling first level Customer Escalations.• Tracing and Troubleshooting Performance Issues.• Installation and configuration of SQL 2000, 2005 & 2008• Involved in Query Tuning.• Monitoring / Troubleshooting Replication & Log Shipping Issues• Involved with Identifying issues with Existing Processes and better Resolution to it.• Implementing database change requests received from developers.• Resolving Database Locking and blocking issues on daily basis.• Hanlding Day-to-Day Activities.• Preparing Database Monitoring Reports.• Database files and file group management.• Providing Performance Tunning Recommendations.• Database Space Management.• Invloved in MIS Review with Customer on Monthly Basis.• Performing Disaster Recovery.• Involved in Migration of Sql Server from 2005 to 2008.• Resolved Database Corruption issue.• Automating SQL Server Routine Monitoring Activities.• Involved with Handling Storage Related issues with IT Team.• Reviewing Sql Server Error Logs, Windows Event Logs and Cluster Logs on daily basis.

New Delhi, Delhi, In

- Installing, Upgrading & Configuring SQL Server 2000 / 2005 / 2008.- Creates and maintains all databases required for development, testing, education, research and Production usage. - Responsibilities include daily maintenance review, SQL optimization, DR Management and testing and - Custom software database installation support- Responsible for Backup & Recovery for all servers with DR management. - Writing SQL Statement to generate MIS reports.- Performs Index Rebuild / Re-organize tasks. - Actively participate in SQL Server Performance Tuning & Query Optimization- Configured Mirroring.- Configured Replication.- Configured Log Shipping.- Controls migrations of programs, database changes, reference data changes - Creating jobs to automate repetitive tasks.- Troubleshoots with problems regarding the databases, applications and development tools. - Conducted a thorough system study for the Software to be customized as per Hospital’s requirement.- Providing extensive supports (35 modules) used by various departments of the Hospital.- Actively participate in Hospital Information System (HIS) implementation and provide adequate support to users.

Delhi, Delhi, In

Master Of Science In Information Technology (M.Sc It), Computer Science

Adca (Advance Diploma In Computer Application ), Computer Science

Pgdca (Post Graduate Diploma In Computer Application ), Computer Science

B.A, Economics

Education record