OnBenchMark Logo

Ankur

Consultant
placeholder
Location Ghaziabad
view-icon
Total Views56
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 14 Year
  • Cost
    Hourly Rate$15
  • availability
    AvailabilityMore 1 Month
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnApril 19, 2024
Key Skills
Azure SQL DBAAWS SQL DBA
Summary

Dec’12-Sep’16TechMahindraLimited,NOIDA,worked asSQLDatabaseAdministrator

Workexposure:


Installed and configured SQL Server 2005, 2008, 2012 and 2014 on Stand-Alone and as well as on 2-NodeCluster.

MigratedthedatabasesfromSQLServer 2000to2005and2005to2008.

Madethemaintenancejobsofrebuild/reorganizingindexforprovidingthebetterperformancetotheapplications andthequeriesas pertherequirement.

Creationofapplicationusersaspertheirrequirementtoaccessthedatabasesfromapplicationandthroughlinkedserverswithin thesecuritypolicy.

Implemented various high availability options for SQL server 2005/2008/2012 i.e. (Clustering, Replication,logshipping).

Deploydatabasechangescripts providedbythirdpartyvendors

Createdandmanagedthebackupjobsthrough maintenanceplan andSQLAgents.

Designedsmall SSIS packagesasperthebusinessrequirementtoperformETLoperations.

Scheduledbackups/logbackupasperthebusinessrequirementandprovidingthemrestoresontotheUAT’s

for performingsomebusinesstests.

Whenperformanceissuesarise,determinesthemosteffectivewaytoincreaseperformancein termsofhardware,serverconfigurationchanges,orindex/querychanges

InstalledSQLServer servicepacksbasedon theerrorsandflawsthatarefoundintheapplication.

Createdthelinkedserverforcommunicatingwithdifferentdatabasesacross(i.e.,inoracleandSQL).

Asperthebusinessrequirementweusedtosyncthedataoftablesofrespectivedatabasesonto the otherenvironmentdatabasewiththehelpof SSISpackage.


April’12-Nov’12- Tech Mahindra Limited, NOIDA, worked as Senior Support EngineerHandson:

SupportingthetradingapplicationODINwhichtheproductofFinancialTechnologiesinProductionandUATboth.

Co-ordinationwithvendor(FinancialTechnologies)fornewtechnicalfunctionalitiesasperthecomplianceandmandatoryguidelinesbytheSEBI.

Handledtheprojectofbankintegration(PaymentGateway)forFundtransferandwithdrawalinODINApplication.

Managetheapplicationand DBbackupautomationwiththehelpofSQLMaintenancePlan.


April’08-March’12- RELIGARE Technologies IT Services Limited, NOIDA as Senior SupportEngineer.


KeyResponsibilities


BuildandmanagedtheSQL FCIandWindows failover clusteronWindows2003enterpriseandSQLServer2005 Standard.

Build and managed Transactional Replication onSQLServer2005.

Installing, Managing & Configuring Third party software. Trading Applications (Trading Server, Feed Server,Interactive,Utility,Broadcast)

Managing and configuringtheWebServers (IIS),PaymentGatewaysinProductionandUATboth.

DesigningandimplementingbackupandsecuritypoliciesfortheOrganization,resultinginsecuredandsmoothoperations.

Managingtheexchangeconnectivityon TAP andIMLServers of(NSE,BSE,FONSE,CDNSE,MCX,NCDEX)

ACADEMICQUALIFICATIONS



B.COM: ChaudharyCharanSingh Universityin2001


CERTIFICATIONS


Diploma in Computer Application (DCA) from NIIT.

Advance Diploma in Hardware and Networking (ADCHN) from JETKING in 2003.

Cisco Certified Network Associate (CCNA) in March 2006.

AZ-103 Azure Microsoft Administrator. (Certification number H355-5758)

DP-300 Administering Relational Databases on Microsoft Azure


My Project History & Feedbacks
Similar Freelancers
not foundNot Found
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon