Sql Server Cloud Services
Resume:
Rohit J
Nationality: US Citizen
Address: Flower Mound 75022, USA
Phone number: +1-240-***-****
Email address: *********.*****@*****.***
Web: www.linkedin.com/in/RohitJami
* Over 13+ years of experience 24/7 support
on SQL Server Database design, development,
and administration.
* Experience in developing logical and physical
data models, preparing technical design
documentation, capacity planning, designing high
availability and disaster recovery solutions,
installation of SQL Server in clustered
environments.
* Followed best practices like change
management and raising tickets for any changes
in production environment.
* Well versed in Azure and AWS cloud services
from migrating SQL to both cloud services and
standalone instances.
* Expertise with using third party tools like BDA
Tools, Red Gate SQL compare, Foglight, Idera,
SCOM, Data compare, SQL monitor, CIS tools for
scanning, Service Now, Skybot, Vsphere and New
Relic etc.
* Expertise with developing complex stored
procedures, different types of functions, triggers.
* Optimized queries on poorly designed
databases troubleshoot complex deadlocks using
several tools like SQL profiler, DMV's, performance counters, SQL Server execution plan etc.
* Setting up maintenance jobs on productions
servers like checking health of databases using
DBCC 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 disaster
recovery solutions like clustering, database
mirroring, Transaction log shipping, peer to peer
replication depending on the requirements.
* Solved complex problems in production
systems by using various third-party tools, using
DAC etc.
* Experience in implementing replication
models like Snapshot, different types of
transaction replications like Peer-to-Peer,
transaction replication with updating subscribers
etc.
* Expertise in developing and deploying SSIS
packages and enhancing them by applying
features like logging, error handling,
checkpoints,assigning permissions to users and
configurations.
* Setting up alerts for critical jobs on
production and development databases by
configuring database mail.
* Generating different kinds of reports like
parameterized reports, sub reports, Tablix reports, drill down and drill through reports etc.
* Deployment and configuring permissions on
reports using SSRS, providing ad hoc reports to
the functional team by running queries on
production server upon request.
* Scheduling jobs and SSIS packages using
SQL Server agent, windows scheduler etc.
* Good knowledge of SQL Server Analysis
services including dimensional and snow flake
schemas, SCDs.
* Experience in Azure SQL databases, worked
on Devops integration and projects.
* Experience in using DBAtools PowerShell
module 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 and
communication skills combined with self-
motivation, initiative, and the ability to think
outside the box.
Profile Profile
SQL Server 2022, 2019,
2018, 2017, 2016, 2014,
2012, 2008 r2, 2008
and 2005, and MS-
Access Cloud Services:
Azure and AWS
Operating Systems:
Windows 2000
Enterprise Advanced
Server, Windows 2003
Enterprise/Datacenter
Server, Window 3.x, XP
Professional and
Windows 2000,
Windows Server 2012
r2, Window 10,
Windows Server 2016,
2018, 2022
Development Tools
Microsoft Visual studio
2012, 2015, 2017, 2018,
2022
DATABASES, CLOUD AND OPERATING
SYSTEMS
BDA Tool for SQL
Installation, SQL
Profiler, Idera, Red
Gate, SCOM, Sky Bot,
Query Analyzer, SQL
Server Management
Studio (SSMS),
Solarwinds ETL
Tools\Connectivity:
ODBC, JDBC, linked
Server, OLEDB, Oracle
Driver, SQL Driver,
Sybase Drivers, BCP,
RDP(remote desktop
Connectivity),
Powershell, Microsoft
terminal Services,
Windows Scheduler,
control-M job
scheduler, SQL Agent
Scheduler, Data Stage,
and SSIS 2019, 2017,
2016, 2012, 2008R2, All
SSRS 2019, 2017, 2016,
2012, 2008R2, 2008 &
2005, Power BI,
Microsoft Dynamics
TOOLS
LEAD CLOUD ADMIN
ESB TECHNOLOGIES
* Have experience in Administering SQL Server
databases in production environments, ranging
from 2012 to 2019 versions.
* Install and configure SQL Server 2016
database in standalone/cluster environment with
availability groups.
* T-SQL scripts, RedGate
* Azure Cloud professional with strong
experience in migrating resources to Azure, Azure
Administration, Azure Infrastructure Operations,
and end to end Project Management.
* Produced high-standard database solutions
to meet stability, reliability.
* Bash and PowerShell
* Create and deploy ETL packages to achieve
various task using Microsoft Integrations Services
(SSIS), and Azure Data factor (ADF).
* Automate Backups, refreshes, maintenance
Jobs, Bulk inserts data migration, data extraction, transformation and loading from multiple data
sources
* Effectively managed and reduced cost by
effectively monitoring databases elastic pool.
* Configuring Azure Site Recovery for DR and
Azure back-up on-premises/Azure Environment.
* Lead design, architecture, and deploy of
solutions in Azure platform.
* Transact-SQL (T-SQL)
* Migrate SQL Server Databases to Microsoft
Azure hosted DBs, Managed instances.
* Configured High Availability Solution; Always-
On, Log Shipping, migration, patching,
troubleshooting, optimization, maintenance
(modelling, High-Availability (HA) and Disaster
Recovery (DR)).
* Created Dashboar for Power BI team and also
supported various BI environment for analytics
teams.
* Performed Database Migration from On-
Premises SQL environment to Azure Database in
cloud
* Manage database security and users in
Active Directory, ensure Database Integrity and
setup 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/2024
DALLAS, UNITED STATES OF AMERICA
Skills Work experience
Network, 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). SSRS
Lead\ Cloud Admin\ SQL Server DBA
BANK OF AMERICA
* Installed, configured, monitored,
administered, and troubleshooting of SQL Server
2019, 2016, 2014, 2012, 2008R2
* Migrated and upgraded SQL Server Database
Software from 2005 and 2008R2 to 2012, 2014,
2016, 2019
* Implemented Backup strategy and Point-in-
time recovery for production and development
environments Based on RPO and RTO in SLA
* Worked on multiple data models and
database mapping as well.
* Configured Always-On for High availability
and Disaster Recovery Solution
* Implemented and managed Replication and
Mirroring for data distribution and disaster
recovery
* I have done performance tuning activities by
using different tools like; Execution plan, SQL
profiler, Performance monitor
* Created and managed Maintenance plans
(automation) for Index rebuild and update
Statistics, History clean up tasks
* Resolved Dead locks/long running Queries by
using different tools like; Profiler, DMV and Stored procedures
* Managed 100+ Azure Instances and
migrations
* Supported Azure Data factory and Data
Bricks with migration from on prem.
* Performed Client/Server connectivity.
* Performed Query optimization, indexing, and
troubleshooting SQL Server related issues
* Managed Disk I/O, CPU and Memory bottle
neck for better performance
* Monitored server performance and integrity
using DMV, DBCC, DMF and Profiler,
* Responsible for securing SQL Server
environment, involved in creating and granting
permissions, logins, groups, roles on various
objects
* Monitored Event viewer, SQL error logs and
Log file viewer for software and hardware related
errors
* Used Business Intelligence tools to create
08/2021 – 08/2023
DALLAS, UNITED STATES OF AMERICA
and deploy SSRS Reports and SSIS Packages
* Defined SQL Server standar for HA based on
Applications requirements
* Capacity planning for Databases considering
the Database growth, Backups, SP, Hotfix and HA
Solutions
* Applied SP (Service Pack)/ Hot Fixes on SQL
Server Instances to address security and
upgraded related issues
* Worked on Azure Migration from on Prem to
Cloud IAAS, PAAS and various other services.
* Worked on building various development
tools for developer teams.
* Worked on Azure devops and
implementations.
* Worked with NoSQL, Cassandra and
MongoDB for various in house projects.
* Performance & Tuning: Provided the best
Query plan, Tuned query for high I/O applications, disk Wait, high latency, high CPU usage.
Performed Index Optimization and did
performance Tuning -DBCC, Update statistics,
Fragmentation/index creation/data row or page
level locking.
* Lead the DR strategy for multiple clients in
cloud and at various Colo's.
* Administrated Power BI and developed
multiple reports for various organizations.
Lead Cloud Admin\ Lead SQL Server
DBA Consultant
3CLOUD\PRAGMATIC WORKS
* Worked with over 20+ clients as a consultant
with 3 Cloud.
* Responsible for administration of Azure SQL
environments, On Prem SQL Environments, and
AWS SQL environments.
* Security, Index tuning and approve changes
to SQL for various clients.
* Working knowledge of creating Azure
Databricks clusters and managing users, manage
table access, creating jobs, backups, and
optimization of tables.
* Responsible for working with the Data
Engineers and Data Warehouse architects to
implement physical data model.
* Responsible for monitoring the ADF pipelines
and Azure Functions for failures and to work with
developers to triage and resolve.
* Working knowledge of azure CICD. Cutting
release branches for deployments for the
appropriate teams.
03/2019 – 06/2021
DOWNERS GROVE,
UNITED STATES OF AMERICA
Work experience Work experience
* Responsible for running the monthly
ingestion files received from clients.
* Fixed/organized SQL security and used CIS
tools for scanning the environment.
* Implemented data masking on PHI columns in
SQL.
* Work on Incidents raised by the
internal\external customers.
* Create Jobs in Automation Accounts for SQL
stored procedure executions.
* Worked on over 25+ various client migrations
from SQL Server\DB2 to Azure cloud technologies.
* Was the lead on multiple SQL upgrades from
SQL 2005 to 2019.
* Adhoc installations of SQL server using BDA
tool.
* Used Foglight for monitoring servers for any
issues.
* Implemented different types of High
Availability & Disaster Recovery models like SQL
Always On, Clustering, Database Mirroring,
Transactional Replication and Log Shipping.
* Implemented & managed Active-Active and
Active-Passive Clustering, Failover and Load
Balance technologies.
* Expertise in Side-by-Side Migrations of MS
SQL SERVER 2008/2012/2014/2016/2019.
* Maintenance, Support, Backups & Recovery:
Monitored daily and weekly maintenance
jobs(Backups Jobs,run DBCC run Rebuild
Indexes, run update statics, run audit jobs), sent backups to tape(daily, weekly and monthly),
Checked Server Error logs and validated space
usage history(Log Files/data Files). Monitored
replications and mirroring for servers. Monitored
always-On failover and AG groups, Synchronized
database between DR site and replicas. Monitored
redo queue for any alerts, resumed replications to remove latency and synchronize data, Checked
Server health and database health for any issues.
Killed blocking process and monitored batch
processes for any issue or slowness. Monitored
failed jobs. Monitored TEMPDB space. Validated
daily backups and log backups to meet business
requirements for specified RTO and RPO.
* Performance & Tuning: Provided the best
Query plan, Tuned query for high I/O applications, disk Wait, high latency, high CPU usage.
Performed Index Optimization and did
performance Tuning -DBCC, Update statistics,
Fragmentation/index creation/data row or page
level locking.
* Supported various clients with Power BI nee
and implementations.
* Lead the DR strategy for multiple clients in
cloud and at various Colo's.
Sr. SQL Server DBA
INSPIRE BRAND GROUP OF RESTAURANTS
* Migrated Databases from SQL Server 2005 to
SQL 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 both
Azure and AWS environments.
* Stood up 500+ servers in Azure cloud and
AWS with application teams and migrated 100+
server\data from SQL to Cloud.
* Used SIOS for storage in AWS setting up the
shares for the failovers.
* Worked with VMWARE software to deploy
servers and storage allocation.
* Upgraded SQL server 2005 to 2018 in
Production, Stage, Development and Test
environments.
* Involved in Data modeling, designing, and
building relational databases.
* Worked on high availability SQL Server
solutions, including Log shipping, Mirroring and
SQL Server clustering, Replication.
* Monitored Performance Monitor and SQL
Profiler to optimize queries and enhance the
performance of database servers.
* Worked with various database modeling
tools.
* Managed Great Plains Application and
Databases along with Management Reporter
DataMart.
* Managed Master Data Service's application
and backend databases with AD authentication.
* Backup and recovery of production
databases and tuning them for better
performance.
* Creating and managing schema objects such
as Tables, Views, Indexes and referential integrity depending on user requirements and converting
them into technical specifications.
* Creating databases and logins and users with
permissions in SQL server
2005/2008/2008r2/2012/2014/2016/2017/2018.
* Created Linked Servers between SQL server
2005/2008/2008r2/2012/2014/2016/2017/2018
and Oracle servers in the environment.
* Used DBCC comman to check physical and
logical consistency of the databases and rebuild
indexes
* Improved the database server performance
06/2015 – 03/2019
MINNEAPOLIS, UNITED STATES OF AMERICA
Work experience Work experience
using Performance monitor after analyzing CPU,
I/O and Memory usage.
* Monitored server level and DB level log
events using SQL Server Audit
* Worked with several teams and lead
database team in the process of development of a
Disaster Recovery and high availability solutions.
* Design and tune the databases, high
availability and disaster recovery metho by
gathering SLA's, acceptable downtime etc.
* Minimized the backup-time, restore-time,
disk I/O and storage required for backups with
Backup Compression. Performed database and
data file backups on all the databases as required.
* Used SSIS to populate data from various data
sources, creating packages for different data
loading operations for application, and to export
data from Oracle to SQL databases.
* Configured Snapshot and Transaction
Replication.
Sr. SQL Server DBA
COGNOSANTE
* Installation, configuration and Administration
of MS SQL Server on Windows2003 Servers.
* Logical and Physical design of database for
projects on basis of user requirement.
* Provided 24/7 Support for Production,
Development & Test Servers of MS SQL Servers.
* Implemented and maintained database
security, logins, roles and schemas.
* Transformed data from various data sources
using OLE DB connection by creating various SSIS
packages.
* Performed Database backups (operating
system, flat file backups & export/import).
* Extensively used Enterprise Manager, Query
Analyzer, and SQL Server Profiler.
* Performed application program
enhancements, troubleshooting and bug fixes as
required.
* Implement Replication for Reference Data
across different Instances of the application.
* Worked on Active/Active and Active/Passive
Clustering.
* Migrated DTS packages to SSIS (SQL Server
Integration Services) using DTS migration wizard.
* Performed query tuning & optimization using
Query Plans & SQL Profiler.
* Managed databases on multiple disks using
Disk Mirroring and RAID technology.
* Developed standar and guidelines to maintain
and develop and administer the SQL Server
12/2014 – 06/2015
FAIRFAX, UNITED STATES OF AMERICA
database.
* Handled Database recovery (disaster
recovery), diagnosed, repaired and was involved
to transfer the OLTP data to Data Warehouse
ENVIRONMENT: SQL Server 2012/2008 r2, T-SQL,
MS Reporting Services (SSRS), SSIS, Windows
2012 r2 Server
Sr. SQL Server DBA and Application
Developer
ROLLS ROYCE, CA
* Managed a team of 6, DBA's and Developers.
* Supporting and developing .net based
internal applications, using asp.net, c# etc.
* Supporting and developing SQL queries for
various databases.
* Experience in building adhoc reports,
parameterized reports, toggle reports, reports
with sub reports using Crystal reports for weekly
and monthly reporting.
* Maintaining applications on IIS and DB
servers
* Migrating data from Mainframe to SQL server
and verifying data authenticity.
* Design and tune the databases, high
availability and disaster recovery metho by
gathering SLA's, acceptable downtime etc.
* Created SQL Server Jobs and Schedules for
automated and timely execution of Daily, Weekly
and Monthly processes.
* Setup the database backups, optimization
and integrity check database maintenance plans.
* Improved the database server performance
using Performance monitor after analyzing CPU,
I/O and Memory usage.
* Monitored server level and DB level log
events using SQL Server Audit
* Worked with several teams and lead
database team in the process of development of a
Disaster Recovery and high availability solutions.
* Design and tune the databases, high
availability and disaster recovery metho by
gathering SLA's, acceptable downtime etc.
* Minimized the backup-time, restore-time,
disk I/O and storage required for backups with
Backup Compression. Performed database and
data file backups on all the databases as required. 04/2013 – 10/2014
SQL Server DBA
ONE NECK
* Technical Architecture review of new and
existing customer database work requests and
01/2012 – 04/2013
PHOENIX, UNITED STATES OF AMERICA
Work experience Work experience
what is technically possible in any given scenario.
* Design and tune the databases, high
availability and disaster recovery metho by
gathering SLA's, acceptable downtime etc.
* Created SQL Server Jobs and Schedules for
automated and timely execution of Daily, Weekly
and Monthly processes
* Configured Database mirroring as the
disaster recovery solution, clustering as the high availability solution. Also configured replication to achieve scalability of databases and improve read
performance.
* Monitored server level and DB level log
events using SQL Server Audit
* Minimized the backup-time, restore-time,
disk I/O and storage required for backups with
Backup Compression. Performed database and
data file backups on all the databases as required.
* Created SSIS Packages to migrate the data
from database to Text files.
* Deployed builds in Production servers for
schema changes and worked in CMR(Change
Management Request) department
* Worked with several teams and lead
database team in the process of development of a
Disaster Recovery and high availability solutions.
* Currently tested Database Mirroring as our
solution for high availability and disaster recovery. Suggested data obfuscation methodologies for
development environment adhering to the
company's security standards.
SQL Server DBA
EBAY
* Handled Database recovery (disaster
recovery), diagnosed, repaired and was involved
to transfer the OLTP data to Data Warehouse
* Created Logical & Physical Database Design
and maintain Data model using Erwin.
Installed Active/passive Microsoft SQL Clustering
using 2 nodes in production environment.
* Created Indexes for the tables which are
lacks of indexes.
* Setup the database backups, optimization
and integrity check database maintenance plans.
* Improved the database server performance
using Performance monitor after analyzing CPU,
I/O and Memory usage.
* Worked with the development team to
improve the Query performance.
* Administered the SQL Server security and
assigned permission to developers.
* Used SQL Server Profiler to monitor and
05/2010 – 04/2012
RYE BROOK, UNITED STATES OF AMERICA
record database activities of particular users,
applications.
* Installed multiple instance of SQL Server for
development purpose.
* Maintained the production server with
maximum availability.
* Troubleshoot the SQL Server for database
corruptions.
* Configured and maintained Snapshot and
merge replication.
* Created the DTS Package designs for
Import/Export from various Data Sources like
oracle, access and text files.
* Responsible for audit of all servers and
databases and creation of uniform disaster-
recovery policies that included all database
maintenance, backups and restoration
procedures.
* Responsible for the tuning and configuration
of all current databases and database servers and
advisement on all new databases and servers.
* Development of DTS extracts and data load
tasks, movement of databases from development
servers to production servers.
* Monitoring databases and servers for
capacity planning and advising database design
and modeling teams of SQL Server capabilities.
Business Management Bachelors of
Science
University of Maryland
10/2007 – 01/2010 BALTIMORE, USA
Work experience Work experience
Education
Contact this candidate