beBee background
Professionals
>
Coimbatore
Gopal N

Gopal N

SQL Server - DB Design, Develop and Optimization

Technology / Internet

Coimbatore, Coimbatore district

Social


Services offered

  • 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
Approximate rate: ₹ 150 per hour

Experience

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

2. Jan 2023 – Apr 2023 with Solrayo Tech Solutions Pvt Ltd, Mumbai as MS SQL DB Project Management, Development and Design 

3.  Feb 2019 – Dec 2022 with Aezion Technologies, Bangalore as MS SQL DB Development, Design and Team Lead

4.  Jan 2011 – Jan 2019 with Rinira Technologies Pvt. Ltd., Mumbai as MS SQL DB Development, Design and Team Lead

5.  Sep 2007 – Dec 2010 with Lauren Information Technologies Pvt. Ltd., Mumbai as Software Engineer

6. Jun 2003 – Aug 2007 with Array Software Systems Pvt. Ltd., Mumbai as Software Engineer

Education

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

Professionals in the same Technology / Internet sector as Gopal N

Professionals from different sectors near Coimbatore, Coimbatore district

Other users who are called Gopal

Jobs near Coimbatore, Coimbatore district

  • Work in company

    SAP Engineer

    Joyfull Engineering Components

    We are seeking an experienced ERP & SQL Report Developer with strong hands-on expertise in SAP Business One to manage ERP operations, develop SQL-based reports and provide IT coordination support. · Oversee and optimize daily ERP operations within SAP Business One. · Manage and m ...

    Coimbatore, Tamil Nadu

    1 month ago

  • Work in company

    Software Developer –

    ANGLER Technologies India Pvt Ltd

    We are looking for a passionate and skilled Software Developer (C#.NET) to join immediately to our dynamic and fast-growing team. · We need someone with strong fundamentals in .NET development, · hands-on experience with SQL, · a keen interest to learn & work on DevExpress contro ...

    Coimbatore, Tamil Nadu

    1 month ago

  • Work in company

    Net Developer

    PradeepIT Consulting Services

    Mandatory / Preferred Skills: · Application, Database & SSIS Package Development: Design, develop, deploy and maintain web applications using ASP.NET MVC and · ASP.NET Core Microservices. · Data Visualization: Utilize Power BI Desktop to create interactive dashboards and reports ...

    Coimbatore, Tamil Nadu, India

    4 days ago