• Experience with installing various version of Microsoft SQL server including SQL server 2019/2016/2014/2012 on Windows or on cloud infrastructure.• Managing and maintaining SQL instances around 150+ production and around 450+ non- production environments. Strong expertise in AWS networking concepts, • Implementing various high availability solutions like Always ON availability groups and SQL Clustering, Log Shipping, Mirroring .• Bring in Continuous deployment practices to enhance… Show more • Experience with installing various version of Microsoft SQL server including SQL server 2019/2016/2014/2012 on Windows or on cloud infrastructure.• Managing and maintaining SQL instances around 150+ production and around 450+ non- production environments. Strong expertise in AWS networking concepts, • Implementing various high availability solutions like Always ON availability groups and SQL Clustering, Log Shipping, Mirroring .• Bring in Continuous deployment practices to enhance our Agile posture.• Exposure on Transparent Data Encryption (TDE), Always Encrypted and Dynamic Data Masking (DDM) features.• Installation and configuration of various version of SQLDB Engine servicesss |SSRS|SSIS|SSAS.• Ability to apply SQL server patches and hotfixes on both standalone and cluster servers. • Successfully migrated SQL instance from lower version to higher versions and editions upgrades.• Expertise as a Sql Developer in creating and managing stored procedures, Triggers, functions, Backup strategies, Indexing, statistics update. Prepared SOP, Standard procedure guidelines all process followed. • Successfully implement and Automate various DBA task and scripts to reduce overall workload using PowerShell Scripting. Show less

Working for Capgemini India on Payroll with Scalene Works People LLP as a Sr Database Administrator.Primary role to Manage MSSQL On Prim , Azure PaaS , IaaS Instances , Log Shipping , Mirroring, Clustering configuration and Management. Working on Enhancement using PowerShell .

Database handling of all four sites (Jaipur, Ajmer, Kota, Udaipur), Successfully Implemented Database scheduling, Always On, Data transfer tool with event logging.Dial 100 Application CAD integration, SOS application integration, Dial 100 Implementation as per RFP.Documentation generation, Standard procedure guidelines

Project Management | Database management| Software Development | Client Relationship Management Role and Responsibilities:Social Justice Empowerment Directorate [ Schemes ( Scholarship Scheme , Residential School Scheme , Hostel Scheme , Anuprati Scheme ) ]Special Abled Person Directorate [ Schemes ( Special Abled Scholarship Scheme ) ]

Liaison| Cost Optimization | Client Relationship Management| Business Development| Software Development | ATM Audit & ReconciliationRole and Responsibilities:Imparting awareness related to CAM, INTRECT KIOSK, and INSTA BANKING to the walk-ins.Handling technical faults related to alternate banking machines.Ensure achievement of targets assigned in a timely manner.Effective leadership skills in motivating sales accomplishment through Business development teamEnsure prompt,… Show more Liaison| Cost Optimization | Client Relationship Management| Business Development| Software Development | ATM Audit & ReconciliationRole and Responsibilities:Imparting awareness related to CAM, INTRECT KIOSK, and INSTA BANKING to the walk-ins.Handling technical faults related to alternate banking machines.Ensure achievement of targets assigned in a timely manner.Effective leadership skills in motivating sales accomplishment through Business development teamEnsure prompt, courteous and accurate service to all the customers to maximize customer satisfaction.Eliciting, collecting guest feedback and initiate process of corrective action, effective handling of customer complaints.Continually innovating and improvising services to keep abreast with the competition.Ensuring availability of proper infrastructure required for smooth operation.Interacting directly with customers to analyze requirements and customize products to suit needs.Liaising with vendors and internal personal for the smooth operation related to alternate channel. Effectively liaised with local Government authorities like Custom officer @ Mahindra SEZ , Income Tax Department.Design and Develop workflows, Ad-hoc reports in crystal report, web applications and Database for Call center for handling phone banking Databases Backups, Restoration, Creating SP’s Functions, and Packages to fulfill the organizational requirement.System Study for Charge back claims for ATM reconciliation cell, Created the database structure for the same.Adept at handling end to end banking operations including new account opening and card managementAdept at assisting in implementing policies related to branch operations; Taking adequate measures for maintaining balance between the available funds and requirement; meeting pre-set revenue & profitability norms. Show less

E-Governance Project: (https://zoomonline.in ) Roles and Responsibilities:Working as team member in Design, Development, Testing and Maintenance.Responsible for Requirement analysis, Design, Development, Testing and Maintenance.Responsible for code optimization and deployment of the project.Designing the workflows for the change.Organize and take Faith Builder and Training programs to VLE's. Description:E-Governance is an initiative of… Show more E-Governance Project: (https://zoomonline.in ) Roles and Responsibilities:Working as team member in Design, Development, Testing and Maintenance.Responsible for Requirement analysis, Design, Development, Testing and Maintenance.Responsible for code optimization and deployment of the project.Designing the workflows for the change.Organize and take Faith Builder and Training programs to VLE's. Description:E-Governance is an initiative of Government of India, Provides G2G, G2C, B2C, B2B services to rural people.Functioning across eight states (Assam, HP, Chhattisgarh, Rajasthan, Orissa, Manipur, Jharkhand, and Bihar) in 13000+ centers.Web Service Integration with Oxigen to facilitate various bill payments services. Environment: ASP.net 2.0, C#, SQL Server 05/08, Crystal Reports, XML, Web servicesMatrimonial Roles and; Working as team member in Design, Development Testing and Maintenance.Responsible for Requirement analysis, Design, Development, Testing and Maintenance.Responsible for code optimization and deployment of the project.Designing the workflows for the change. Description:Complete solution to all matrimonial needs. Classifies the users as paid and free. Paid members get exclusive access to various match making facilities. The portal also has its own messaging and mailing system through which users can interact. Environment: ASP.net 2.0, C#, XML, SQL Server 2005 etc. IE Automation Roles; Responsible for establish connection between client and server through Socket's.Automate Internet Explorer with client and send response to the server. Description:Client Server application to detect Internet Explorer events at client's machine & transmit result to the server. Environment: C#, System32 DLLs, Socket Programming, Shell Document Library Show less

Zoom Enterprises is 17 years-old and is one of the fastest growing Business Groups in India, with a well established foothold in diverse business areas. As Project developers, Zoom undertakes Business and Project Development work, involving Process Plants, Industrial & Engineering Projects and Energy, Environment and Infrastructure Projects. Zoom has similar presence in IT, ITES, Telecom, Embedded-Cards, ERP and BPO Service Sectors.

Roles and Responsibilities: - Worked as team member in Design, Development Testing and Maintenance.Responsible for Requirement analysis, Design, Development, Testing and Maintenance.Responsible for code optimization and deployment of the project.Designing the workflows for the change.Take Faith Builder and Training programs of OIC's. Description: - It is a state level project. Justice department identified 201 units under 44 Administrative departments of the… Show more Roles and Responsibilities: - Worked as team member in Design, Development Testing and Maintenance.Responsible for Requirement analysis, Design, Development, Testing and Maintenance.Responsible for code optimization and deployment of the project.Designing the workflows for the change.Take Faith Builder and Training programs of OIC's. Description: - It is a state level project. Justice department identified 201 units under 44 Administrative departments of the Government, to create a comprehensive database and to provide information to the State government on litigation matters.Aim of this project is to provide information to the Administrative Departments in the State to effectively and economically handle litigation progressEnvironment : ASP.net 1.1/2.0, C#, ASP, SQL Server 2000, Crystal reports 7.0 etc. Show less