Ankur

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