Gopal N

• Strategic IT Leader with 22 years of IT Experience and 12+ Yearsof rich and extensive experience in managing IT Projects and Database team management with Project Lead Experience and individual contribution on DB design and Development
• Pioneer at large engagements including complex IT Project Management, Delivery Management and People Management
• Skilled in overall software development life-cycle involving requirement analysis, system study, designing, architecture, testing, programming, coding, de-bugging, defect management, status reporting & documentation
• Currently working on a project for the client ‘Yellow Blue’ and utilizing technologies such as C#, ASP.Net, AngularJS, SQL Server 2017, WebAPI
• Domain expertise: HealthCare, Corporate and Travel i.e. Air, Hotel and Car (search to book, profile management on sabre & offline booking handling the booking information to system. Reporting pages for all corporate booking, Healthcare and Data Modelling
• Expertise in Database Design and Development on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities
• Worked on configuring SQL Server with minimum privileged access (Project level SQL Logins and rights & Database object level access permission)
• Strong problem-solving & technical skills coupled with decision-making for enabling effective solutions for customer satisfaction & low operational costs
• Hands on experience in DR processes including Log Shipping, Database Mirroring and Replication
• Responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files
• Experience in using DMV and DMF for finding out long running queries
• Performed an exhaustive SQL Server audit on Production SQL Instance
• Worked on Amazon AWS Cloud based platform (RDS), AmazonElastic Compute Cloud EC2 running Windows and also used Amazon S3 bucket
• Expertise in Automate backup plan, Data Migratingand AES Encryption techniques
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
  • Configuring scheduled SQL Jobs to automate regular process, monitor and find & resolve Job error
• Frequently checking SQL logs and resolve issues
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability
• Prepare pre-live integration server in development environment to ensure the web build and database scripts are stable to deploy
• Acts as an expert technical resource to client and dev team in all phases of the development and implementation process
• Provide 24x7 support for critical production systems
• Maintaining more than 7+ Production servers in different domains and 10+ Dev and Test Servers
• Significant experience of working with customers, and technical teams for securing & executing concurrent projects; envisioning usage of new technology and tailoring its usage for achieving desired results

Current: Since Sep 2023 with Comgen India Software Solutions Pvt Ltd, Coimbatore as Senior Technical Consultant

• Jan 2023 – Apr 2023 with Solrayo Tech Solutions Pvt Ltd, Mumbai as MS SQL DB Project Management, Development and Design
• Feb 2019 – Dec 2022 with Aezion Technologies, Bangalore as MS SQL DB Development, Design and Team Lead
• Jan 2011 – Jan 2019 with Rinira Technologies Pvt. Ltd., Mumbai as MS SQL DB Development, Design and Team Lead
• Sep 2007 – Dec 2010 with Lauren Information Technologies Pvt. Ltd., Mumbai as Software Engineer
• Jun 2003 – Aug 2007 with Array Software Systems Pvt. Ltd., Mumbai as Software Engineer

Diploma In Computer Technology, Rajaji Institute of Technology, Salem, Tamil Nadu