| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateRohit JNationality: US CitizenAddress: Flower Mound Street Address , USAPhone number: PHONE NUMBER AVAILABLEEmail address: EMAIL AVAILABLEWeb: LINKEDIN LINK AVAILABLE* Over 13+ years of experience 24/7 supporton SQL Server Database design, development,and administration.* Experience in developing logical and physicaldata models, preparing technical designdocumentation, capacity planning, designing highavailability and disaster recovery solutions,installation of SQL Server in clusteredenvironments.* Followed best practices like changemanagement and raising tickets for any changesin production environment.* Well versed in Azure and AWS cloud servicesfrom migrating SQL to both cloud services andstandalone instances.* Expertise with using third party tools like BDATools, Red Gate SQL compare, Foglight, Idera,SCOM, Data compare, SQL monitor, CIS tools forscanning, Service Now, Skybot, Vsphere and NewRelic etc.* Expertise with developing complex storedprocedures, different types of functions, triggers.* Optimized queries on poorly designeddatabases troubleshoot complex deadlocks usingseveral tools like SQL profiler, DMV's, performance counters, SQL Server execution plan etc.* Setting up maintenance jobs on productionsservers like checking health of databases usingDBCC check commands, T-SQL, rebuild indexes,updating statistics, transaction, and full back up jobs, clearing backup history, clearing error logs etc.* Configuring high availability and disasterrecovery solutions like clustering, databasemirroring, Transaction log shipping, peer to peerreplication depending on the requirements.* Solved complex problems in productionsystems by using various third-party tools, usingDAC etc.* Experience in implementing replicationmodels like Snapshot, different types oftransaction replications like Peer-to-Peer,transaction replication with updating subscribersetc.* Expertise in developing and deploying SSISpackages and enhancing them by applyingfeatures like logging, error handling,checkpoints,assigning permissions to users andconfigurations.* Setting up alerts for critical jobs onproduction and development databases byconfiguring database mail.* Generating different kinds of reports likeparameterized reports, sub reports, Tablix reports, drill down and drill through reports etc.* Deployment and configuring permissions onreports using SSRS, providing ad hoc reports tothe functional team by running queries onproduction server upon request.* Scheduling jobs and SSIS packages usingSQL Server agent, windows scheduler etc.* Good knowledge of SQL Server Analysisservices including dimensional and snow flakeschemas, SCDs.* Experience in Azure SQL databases, workedon Devops integration and projects.* Experience in using DBAtools PowerShellmodule to automate tasks, proficient in installing Master Data Services.* Knowledge of Azure technologies:Databricks, ADF, Azure Storage, Azure functions,AAD* Knowledge and worked with Azure DevOps* Good team player, strong interpersonal andcommunication skills combined with self-motivation, initiative, and the ability to thinkoutside the box.Profile ProfileSQL Server 2022, 2019,2018, 2017, 2016, 2014,2012, 2008 r2, 2008and 2005, and MS-Access Cloud Services:Azure and AWSOperating Systems:Windows 2000Enterprise AdvancedServer, Windows 2003Enterprise/DatacenterServer, Window 3.x, XPProfessional andWindows 2000,Windows Server 2012r2, Window 10,Windows Server 2016,2018, 2022Development ToolsMicrosoft Visual studio2012, 2015, 2017, 2018,2022DATABASES, CLOUD AND OPERATINGSYSTEMSBDA Tool for SQLInstallation, SQLProfiler, Idera, RedGate, SCOM, Sky Bot,Query Analyzer, SQLServer ManagementStudio (SSMS),Solarwinds ETLTools\Connectivity:ODBC, JDBC, linkedServer, OLEDB, OracleDriver, SQL Driver,Sybase Drivers, BCP,RDP(remote desktopConnectivity),Powershell, Microsoftterminal Services,Windows Scheduler,control-M jobscheduler, SQL AgentScheduler, Data Stage,and SSIS 2019, 2017,2016, 2012, 2008R2, AllSSRS 2019, 2017, 2016,2012, 2008R2, 2008 &2005, Power BI,Microsoft DynamicsTOOLSLEAD CLOUD ADMINESB TECHNOLOGIES* Have experience in Administering SQL Serverdatabases in production environments, rangingfrom 2012 to 2019 versions.* Install and configure SQL Server 2016database in standalone/cluster environment withavailability groups.* T-SQL scripts, RedGate* Azure Cloud professional with strongexperience in migrating resources to Azure, AzureAdministration, Azure Infrastructure Operations,and end to end Project Management.* Produced high-standard database solutionsto meet stability, reliability.* Bash and PowerShell* Create and deploy ETL packages to achievevarious task using Microsoft Integrations Services(SSIS), and Azure Data factor (ADF).* Automate Backups, refreshes, maintenanceJobs, Bulk inserts data migration, data extraction, transformation and loading from multiple datasources* Effectively managed and reduced cost byeffectively monitoring databases elastic pool.* Configuring Azure Site Recovery for DR andAzure back-up on-premises/Azure Environment.* Lead design, architecture, and deploy ofsolutions in Azure platform.* Transact-SQL (T-SQL)* Migrate SQL Server Databases to MicrosoftAzure hosted DBs, Managed instances.* Configured High Availability Solution; Always-On, Log Shipping, migration, patching,troubleshooting, optimization, maintenance(modelling, High-Availability (HA) and DisasterRecovery (DR)).* Created Dashboar for Power BI team and alsosupported various BI environment for analyticsteams.* Performed Database Migration from On-Premises SQL environment to Azure Database incloud* Manage database security and users inActive Directory, ensure Database Integrity andsetup maintenance plans via SQL Agent.* Installed SQL in standalone/Clustered* Azure AD connect & Federation services* Database Migration to Microsoft Azure* Log Shipping, Always-On High Availability* Performance Monitoring & Tuning* Azure Site/Recovery (ASR), Service Vault* Performance Monitoring & Tuning Azure,08/2023 02/2024DALLAS, UNITED STATES OF AMERICASkills Work experienceNetwork, Storage* Disaster Recovery Managed Instances,Elastic Pools, Azure VM* Configured (TDE) to Encrypt All databases* Managed Azure compute and services* ETL: SSIS, Azure Data Factory (ADF). SSRSLead\ Cloud Admin\ SQL Server DBABANK OF AMERICA* Installed, configured, monitored,administered, and troubleshooting of SQL Server2019, 2016, 2014, 2012, 2008R2* Migrated and upgraded SQL Server DatabaseSoftware from 2005 and 2008R2 to 2012, 2014,2016, 2019* Implemented Backup strategy and Point-in-time recovery for production and developmentenvironments Based on RPO and RTO in SLA* Worked on multiple data models anddatabase mapping as well.* Configured Always-On for High availabilityand Disaster Recovery Solution* Implemented and managed Replication andMirroring for data distribution and disasterrecovery* I have done performance tuning activities byusing different tools like; Execution plan, SQLprofiler, Performance monitor* Created and managed Maintenance plans(automation) for Index rebuild and updateStatistics, History clean up tasks* Resolved Dead locks/long running Queries byusing different tools like; Profiler, DMV and Stored procedures* Managed 100+ Azure Instances andmigrations* Supported Azure Data factory and DataBricks with migration from on prem.* Performed Client/Server connectivity.* Performed Query optimization, indexing, andtroubleshooting SQL Server related issues* Managed Disk I/O, CPU and Memory bottleneck for better performance* Monitored server performance and integrityusing DMV, DBCC, DMF and Profiler,* Responsible for securing SQL Serverenvironment, involved in creating and grantingpermissions, logins, groups, roles on variousobjects* Monitored Event viewer, SQL error logs andLog file viewer for software and hardware relatederrors* Used Business Intelligence tools to create08/2021 08/2023DALLAS, UNITED STATES OF AMERICAand deploy SSRS Reports and SSIS Packages* Defined SQL Server standar for HA based onApplications requirements* Capacity planning for Databases consideringthe Database growth, Backups, SP, Hotfix and HASolutions* Applied SP (Service Pack)/ Hot Fixes on SQLServer Instances to address security andupgraded related issues* Worked on Azure Migration from on Prem toCloud IAAS, PAAS and various other services.* Worked on building various developmenttools for developer teams.* Worked on Azure devops andimplementations.* Worked with NoSQL, Cassandra andMongoDB for various in house projects.* Performance & Tuning: Provided the bestQuery plan, Tuned query for high I/O applications, disk Wait, high latency, high CPU usage.Performed Index Optimization and didperformance Tuning -DBCC, Update statistics,Fragmentation/index creation/data row or pagelevel locking.* Lead the DR strategy for multiple clients incloud and at various Colo's.* Administrated Power BI and developedmultiple reports for various organizations.Lead Cloud Admin\ Lead SQL ServerDBA Consultant3CLOUD\PRAGMATIC WORKS* Worked with over 20+ clients as a consultantwith 3 Cloud.* Responsible for administration of Azure SQLenvironments, On Prem SQL Environments, andAWS SQL environments.* Security, Index tuning and approve changesto SQL for various clients.* Working knowledge of creating AzureDatabricks clusters and managing users, managetable access, creating jobs, backups, andoptimization of tables.* Responsible for working with the DataEngineers and Data Warehouse architects toimplement physical data model.* Responsible for monitoring the ADF pipelinesand Azure Functions for failures and to work withdevelopers to triage and resolve.* Working knowledge of azure CICD. Cuttingrelease branches for deployments for theappropriate teams.03/2019 06/2021DOWNERS GROVE,UNITED STATES OF AMERICAWork experience Work experience* Responsible for running the monthlyingestion files received from clients.* Fixed/organized SQL security and used CIStools for scanning the environment.* Implemented data masking on PHI columns inSQL.* Work on Incidents raised by theinternal\external customers.* Create Jobs in Automation Accounts for SQLstored procedure executions.* Worked on over 25+ various client migrationsfrom SQL Server\DB2 to Azure cloud technologies.* Was the lead on multiple SQL upgrades fromSQL 2005 to 2019.* Adhoc installations of SQL server using BDAtool.* Used Foglight for monitoring servers for anyissues.* Implemented different types of HighAvailability & Disaster Recovery models like SQLAlways On, Clustering, Database Mirroring,Transactional Replication and Log Shipping.* Implemented & managed Active-Active andActive-Passive Clustering, Failover and LoadBalance technologies.* Expertise in Side-by-Side Migrations of MSSQL SERVER 2008/2012/2014/2016/2019.* Maintenance, Support, Backups & Recovery:Monitored daily and weekly maintenancejobs(Backups Jobs,run DBCC run RebuildIndexes, run update statics, run audit jobs), sent backups to tape(daily, weekly and monthly),Checked Server Error logs and validated spaceusage history(Log Files/data Files). Monitoredreplications and mirroring for servers. Monitoredalways-On failover and AG groups, Synchronizeddatabase between DR site and replicas. Monitoredredo queue for any alerts, resumed replications to remove latency and synchronize data, CheckedServer health and database health for any issues.Killed blocking process and monitored batchprocesses for any issue or slowness. Monitoredfailed jobs. Monitored TEMPDB space. Validateddaily backups and log backups to meet businessrequirements for specified RTO and RPO.* Performance & Tuning: Provided the bestQuery plan, Tuned query for high I/O applications, disk Wait, high latency, high CPU usage.Performed Index Optimization and didperformance Tuning -DBCC, Update statistics,Fragmentation/index creation/data row or pagelevel locking.* Supported various clients with Power BI neeand implementations.* Lead the DR strategy for multiple clients incloud and at various Colo's.Sr. SQL Server DBAINSPIRE BRAND GROUP OF RESTAURANTS* Migrated Databases from SQL Server 2005 toSQL Server 2018 in Production, Stage,Development, and test Environments.* Supported Parallel Data Warehouse (PDW)servers for reporting for the whole environment.* Setup and maintained databases in bothAzure and AWS environments.* Stood up 500+ servers in Azure cloud andAWS with application teams and migrated 100+server\data from SQL to Cloud.* Used SIOS for storage in AWS setting up theshares for the failovers.* Worked with VMWARE software to deployservers and storage allocation.* Upgraded SQL server 2005 to 2018 inProduction, Stage, Development and Testenvironments.* Involved in Data modeling, designing, andbuilding relational databases.* Worked on high availability SQL Serversolutions, including Log shipping, Mirroring andSQL Server clustering, Replication.* Monitored Performance Monitor and SQLProfiler to optimize queries and enhance theperformance of database servers.* Worked with various database modelingtools.* Managed Great Plains Application andDatabases along with Management ReporterDataMart.* Managed Master Data Service's applicationand backend databases with AD authentication.* Backup and recovery of productiondatabases and tuning them for betterperformance.* Creating and managing schema objects suchas Tables, Views, Indexes and referential integrity depending on user requirements and convertingthem into technical specifications.* Creating databases and logins and users withpermissions in SQL server2005/2008/2008r2/2012/2014/2016/2017/2018.* Created Linked Servers between SQL server2005/2008/2008r2/2012/2014/2016/2017/2018and Oracle servers in the environment.* Used DBCC comman to check physical andlogical consistency of the databases and rebuildindexes* Improved the database server performance06/2015 03/2019MINNEAPOLIS, UNITED STATES OF AMERICAWork experience Work experienceusing Performance monitor after analyzing CPU,I/O and Memory usage.* Monitored server level and DB level logevents using SQL Server Audit* Worked with several teams and leaddatabase team in the process of development of aDisaster Recovery and high availability solutions.* Design and tune the databases, highavailability and disaster recovery metho bygathering SLA's, acceptable downtime etc.* Minimized the backup-time, restore-time,disk I/O and storage required for backups withBackup Compression. Performed database anddata file backups on all the databases as required.* Used SSIS to populate data from various datasources, creating packages for different dataloading operations for application, and to exportdata from Oracle to SQL databases.* Configured Snapshot and TransactionReplication.Sr. SQL Server DBACOGNOSANTE* Installation, configuration and Administrationof MS SQL Server on Windows2003 Servers.* Logical and Physical design of database forprojects on basis of user requirement.* Provided 24/7 Support for Production,Development & Test Servers of MS SQL Servers.* Implemented and maintained databasesecurity, logins, roles and schemas.* Transformed data from various data sourcesusing OLE DB connection by creating various SSISpackages.* Performed Database backups (operatingsystem, flat file backups & export/import).* Extensively used Enterprise Manager, QueryAnalyzer, and SQL Server Profiler.* Performed application programenhancements, troubleshooting and bug fixes asrequired.* Implement Replication for Reference Dataacross different Instances of the application.* Worked on Active/Active and Active/PassiveClustering.* Migrated DTS packages to SSIS (SQL ServerIntegration Services) using DTS migration wizard.* Performed query tuning & optimization usingQuery Plans & SQL Profiler.* Managed databases on multiple disks usingDisk Mirroring and RAID technology.* Developed standar and guidelines to maintainand develop and administer the SQL Server12/2014 06/2015FAIRFAX, UNITED STATES OF AMERICAdatabase.* Handled Database recovery (disasterrecovery), diagnosed, repaired and was involvedto transfer the OLTP data to Data WarehouseENVIRONMENT: SQL Server 2012/2008 r2, T-SQL,MS Reporting Services (SSRS), SSIS, Windows2012 r2 ServerSr. SQL Server DBA and ApplicationDeveloperROLLS ROYCE, CA* Managed a team of 6, DBA's and Developers.* Supporting and developing .net basedinternal applications, using asp.net, c# etc.* Supporting and developing SQL queries forvarious databases.* Experience in building adhoc reports,parameterized reports, toggle reports, reportswith sub reports using Crystal reports for weeklyand monthly reporting.* Maintaining applications on IIS and DBservers* Migrating data from Mainframe to SQL serverand verifying data authenticity.* Design and tune the databases, highavailability and disaster recovery metho bygathering SLA's, acceptable downtime etc.* Created SQL Server Jobs and Schedules forautomated and timely execution of Daily, Weeklyand Monthly processes.* Setup the database backups, optimizationand integrity check database maintenance plans.* Improved the database server performanceusing Performance monitor after analyzing CPU,I/O and Memory usage.* Monitored server level and DB level logevents using SQL Server Audit* Worked with several teams and leaddatabase team in the process of development of aDisaster Recovery and high availability solutions.* Design and tune the databases, highavailability and disaster recovery metho bygathering SLA's, acceptable downtime etc.* Minimized the backup-time, restore-time,disk I/O and storage required for backups withBackup Compression. Performed database anddata file backups on all the databases as required. 04/2013 10/2014SQL Server DBAONE NECK* Technical Architecture review of new andexisting customer database work requests and01/2012 04/2013PHOENIX, UNITED STATES OF AMERICAWork experience Work experiencewhat is technically possible in any given scenario.* Design and tune the databases, highavailability and disaster recovery metho bygathering SLA's, acceptable downtime etc.* Created SQL Server Jobs and Schedules forautomated and timely execution of Daily, Weeklyand Monthly processes* Configured Database mirroring as thedisaster recovery solution, clustering as the high availability solution. Also configured replication to achieve scalability of databases and improve readperformance.* Monitored server level and DB level logevents using SQL Server Audit* Minimized the backup-time, restore-time,disk I/O and storage required for backups withBackup Compression. Performed database anddata file backups on all the databases as required.* Created SSIS Packages to migrate the datafrom database to Text files.* Deployed builds in Production servers forschema changes and worked in CMR(ChangeManagement Request) department* Worked with several teams and leaddatabase team in the process of development of aDisaster Recovery and high availability solutions.* Currently tested Database Mirroring as oursolution for high availability and disaster recovery. Suggested data obfuscation methodologies fordevelopment environment adhering to thecompany's security standards.SQL Server DBAEBAY* Handled Database recovery (disasterrecovery), diagnosed, repaired and was involvedto transfer the OLTP data to Data Warehouse* Created Logical & Physical Database Designand maintain Data model using Erwin.Installed Active/passive Microsoft SQL Clusteringusing 2 nodes in production environment.* Created Indexes for the tables which arelacks of indexes.* Setup the database backups, optimizationand integrity check database maintenance plans.* Improved the database server performanceusing Performance monitor after analyzing CPU,I/O and Memory usage.* Worked with the development team toimprove the Query performance.* Administered the SQL Server security andassigned permission to developers.* Used SQL Server Profiler to monitor and05/2010 04/2012RYE BROOK, UNITED STATES OF AMERICArecord database activities of particular users,applications.* Installed multiple instance of SQL Server fordevelopment purpose.* Maintained the production server withmaximum availability.* Troubleshoot the SQL Server for databasecorruptions.* Configured and maintained Snapshot andmerge replication.* Created the DTS Package designs forImport/Export from various Data Sources likeoracle, access and text files.* Responsible for audit of all servers anddatabases and creation of uniform disaster-recovery policies that included all databasemaintenance, backups and restorationprocedures.* Responsible for the tuning and configurationof all current databases and database servers andadvisement on all new databases and servers.* Development of DTS extracts and data loadtasks, movement of databases from developmentservers to production servers.* Monitoring databases and servers forcapacity planning and advising database designand modeling teams of SQL Server capabilities.Business Management Bachelors ofScienceUniversity of Maryland10/2007 01/2010 BALTIMORE, USAWork experience Work experienceEducation |
