Sql Server Database Administrator

Vikas Behl

Database Administrator cum Database Developer

Email: ad5ved@r.postjobfree.com

Phone: 425-***-****

Location: Portland (Willing to Relocate anywhere within the USA)

SUMMARY:

Experienced Database Administrator with over 14 years of expertise in database administration and development, specializing in SQL Server and cloud technologies along with Site Reliability Engineer. Proven track record in Agile methodologies, DevOps practices, and managing large-scale Azure and AWS cloud environments.

5 + years of experience in Microsoft handling 4500 servers and Azure infrastructure. performance tuning & optimizing SQL queries.

12 + years’ experience in various cloud environments Azure & Aws (PAAS & IAAS)

Build and manage RDS PostgreSQL, Azure Databases, Build VMs, Azure Data Factory, MySQL, and MSSQL, Sybase.

Excellent Experience in MS SQL Server installation, building Cluster & Geo Cluster Servers along with configuring, performance Tuning, Query Optimization, Upgrade, Backup/Recovery, and Managing Security. Excellent knowledge of SQL Server Replication, Log Shipping, Mirroring (HADR), and SQL Server 2012/2014/2016/2017/2019/2022.

Experienced in Migration/Managing/administrating PostgreSQL, MYSQL, MongoDB, upgrade, Migration, Replication, performance tuning, Optimization, and administrating RDS instances on AWS, and Windows Azure.

Designed, maintained, and documented a highly transactional OLTP system scaling up to 10 million transactions.

Experienced in handling End to End end-project management Activities which include Planning, Design, Scope Management, Estimation, Resource Administration, and completion of projects within specified Timeframes and Parameters

TECHNICAL SKILLS:

Databases: SQL Server (2000-2022), PostgreSQL, RDS on Amazon Web Services, MySQL, Oracle

Cloud Technologies: Azure (Azure Data Factory, Azure Data Lake, Azure SQL), AWS

Programming Languages: T-SQL, PowerShell, VBScript, Python

Tools & Utilities: SSIS, SSRS, SSAS, SCOM, PowerShell, ER Studio, Visio

Operating Systems: Windows Server, UNIX, Linux

Other: Agile Methodologies, DevOps Practices, Site Reliability Engineering

Professional Experience:

Quiktrak Inc. (March 2020 – Present) Portland, OR

Lead Database Administrator & SQL Developer (MSSQL, MYSQL, PostgreSQL, MongoDB)

Led a Team of 4 Database Administrators and mentoring junior team members, conducting performance evaluations, and collaborating with cross-functional teams to ensure seamless integration of database solutions with business processes.

Architecture and migrated database to a complex and critical Microsoft SQL Server environment from 2016/2017/2019 to SQL SERER 2022 on Azure and AWS and implemented disaster recovery solutions by building Active/Active & Active /Passive Clusters and using Always on for SQL Server databases.

Setup and administrating Always ON Geo Cluster and Standalone Server.

Having a complex environment for Replication (Transactional & Peer to Peer Replication) data to fulfill the need of Reporting purposes.

Spearheaded the administration of Microsoft SQL Server databases, ensuring optimal performance, high availability, and disaster recovery solutions.

Migrated SQL Server instances to Managed instances on Azure and to Azure SQL Databases.

Design, develop, and maintain database schemas, tables, views, and stored procedures to meet business requirements. Ensure data normalization, integrity, and performance optimization.

Write and optimize SQL queries to improve performance and efficiency. Identify and resolve performance bottlenecks through query tuning, indexing strategies, and database optimizations.

Develop data models and ER diagrams to represent the organization's data architecture. Translate business requirements into logical and physical data models for effective database design.

Automation of SQL Deployment and other maintenance tasks using python scripting.

Writing store proc, function, views, and queries in PL/SQL.

Migrated on-premises SQL databases to Azure SQL Database using tools like Azure Database Migration Service.

Migrated ETL packages from on-premises to Azure data factory.

Working closely with business users to understand the client’s requirements and develop (SSIS) ETL packages and SSRS reports per their requirements (for clients like BOFA, US bank, Huntington, and many more).

Writing complex SQL queries, writing stored procedures, Views, Triggers, and User-defined functions.

Performed automating and standardizing of the production environment using PowerShell, TSQL, SSRS, etc.

Identifying slow Running Queries T-SQL & analyzing and optimizing them and automating the processes.

Install, configure, and maintain SSAS instances.

Experience in Designing and building the dimensions and cubes with star schema using SSAS.

Experience in modifying MDX cubes and Dimensions in SSAS.

Created sophisticated calculated members using MDX queries, designed and created aggregations to speed up queries and improve performance in SSAS.

Monitor SSAS performance and troubleshooting issues.

Involved in Planning, researching, Architect the environment for Servers and Databases with different stakeholders and teams.

Implemented projects for Migration, Performance tuning, DR setup (Windows clustering/SQL Clustering & Always On), Backup Policies, and Implementation, of Security and High Availability Solutions to the database and Servers.

Implemented Backup strategies and optimized SQL queries.

Extensively used Nonstop SQL MX is object-relational database management software for writing complex query environments for business intelligence, and online analytical processing (OLAP).

Installed Mongo dB, configured, and set up on AWS with Light Sail Servers.

Configured backup, recovery, upgrade, and tuning and data integrity of MongoDB.

Implemented MongoDB Replication

Implemented MongoDB Sharding to handle very large data sets and involved in code writing, and performance tuning.

I have set up sharding as data grows, a single server was not able to handle the load efficiently. I have implemented horizontal sharding across multiple servers, this enables the system to handle large amounts of data and higher throughput.

It also distributes data across multiple shards database queries can be parallelized leading to performance. Sharding increases fault tolerance by distributing data across multiple servers if one server fails, the data on other shards remains accessible reducing the risk of downtime.

Migrated Mongodb to Documentdb using Mongodump & mongo restore tools.

Responsible for managing the MongoDB environment with high availability, performance, and scalability perspectives.

Creation, configuration, and monitoring of Shards sets. Analysis of the data to be shared, choosing a shard key to distribute data evenly.

Automate various tasks using bash scripting.

Upgraded & executed MYSQL migration from 5.7 to 8 version.

Configuring Master/Slave replication and implementing a backup strategy for production servers.

Administrating and Installing MYSQL databases, on-premises/AWS configuring replication, and optimizing SQL queries, using Workbench.

Manage and build configuration of PostgreSQL Server on AWS RDS instances and on-premises.

Using monitoring tool Grafana Prometheus and knowledge of containers

Configuring pgadmin-4 to access the database servers.

Responsible for monitoring RDS instances using a monitoring tool like Nagios, and Check postgres.pl, pgon, custom scripts, and other supporting tools like pgBadger

Develop and enhance scripts to automate and execute various DBA tasks.

Implemented security policies and user authentication.

Set up replication on PostgreSQL RDS instances.

Generating Snapshot backups of RDS instances.

Generating Security groups for RDS instances for new logins associated with AD.

Migrated on-premises PostgreSQL environment to AWS RDS instance.

Performance tuning of Databases and support developers for efficient SQL query and identifying long-running queries and optimizing.

Upgraded database versions using pg_dump/pg_restore and pg_upgrade tools and I made sure the latest security patches to the database were updated, the PostgreSQL open-source community provides this.

Performed Backups (pg_basebackup, pg_backrest, pg_dump) and restored operations, compressed backups, and database/schema refreshes.

Experienced on restore operations (pg_restore) and Point in Time Recovery

Used pg_Bouncer for connection pooling, pg_Badge for generating statistic reports.

Writing and modifying PostgreSQL stored procedures, functions, views, and queries.

Optimizing PostgreSQL queries, and Servers to enhance performance.

Tools Used: SSMA, The Data Migration Assistant (DMA) Azure Services.

Senior MSSQL Database Administrator/Developer

Orion Systems Integrators LLC (October 2019 - March 2020) – Redmond, WA

Project: Universal Store (Microsoft Corp.)

Orchestrated the migration of databases from SQL Server 2008 to SQL Server 2012/2014/2016/20172019, including cloud-based deployments on Windows Azure. Built and managed SQL Server infrastructure on Azure, including clusters and Always On configurations.

Responsible for building new infrastructure for EOL and Migration database of 2008 to SQL 2012/ SQL 2014/ SQL 2016/SQL2017 Servers and Cloud databases (Windows Azure).

Writing store proc, function, views, and queries in PL/SQL

Developed several database structures, complex SQL queries, writing stored procedures, Views, Triggers, and User-defined functions.

Identifying Slow Running Queries T-SQL & analyzing and optimizing them.

Developed and rendered monthly, weekly, and daily reports as per the requirement and gave roles, and user access to security in Report Manager.

Configure Transactional Replication for the reporting purposes.

Development, implementation, and maintenance of OLAP cubes and ETL packages.

Development of SSRS reports and SSIS package.

• Development of Key Performance Indicators (KPIs), Dashboards, Scorecards, drill-down

reports and linked reports for senior executives and marketplace managers required for

business performance and forecasting and used BI reporting.

Create and maintain Power BI reports and dashboard.

• Building and managing geo-cluster, Active-Active, Active Passive Clusters

Developed SSRS reports and Power BI dashboards for business intelligence and analytics.

Implemented OLAP cubes and ETL packages for data integration and reporting.

Enom Inc. (Formerly RightSide) (December 2015 - October 2019) - Bellevue, WA

MSSQL/MYSQL/PostgreSQL Database Administrator/Developer

Managed highly complex cross-datacenter SQL clusters, including migrations and high-availability solutions.

Technical support services consisting of Tier 3 level System Administration across multiple areas of subject matter expertise for Microsoft Corp.

Managed 100+ Production/QA+Dev servers with multiple databases, with couples of them over 10-12 terabytes both in a Cluster environment with Mirroring and Replication and Implemented Always On.

Responsible for building new infrastructure for EOL and Migration database of 2008 to SQL 2012 & SQL 2014 Servers and Cloud databases (Windows Azure).

Managed Query Optimization and Performance Tuning of Stored Procedures, Functions, etc.

Writing store proc, function, views, and queries in PL/SQL

Developed Power BI reports and SSIS packages for data visualization and ETL processes.

Implemented SOX/PCI-compliant databases and automated production environment using PowerShell and T-SQL.

Implementing Service Pack upgrades on SQL Servers for QA/Dev and Production Database.

Green Infosystems LLC -- Redmond, Washington, US August 2013 to December 2015 – Redmond WA

Sr. MSSQL Database Administrator

Project Name: Learning-MSCom (Microsoft Corp.) –Microsoft vendor

Technical support services consisting of Tier 3 level System Administration across multiple areas of subject matter expertise for Microsoft Corp.

Managed 100+ Production/QA+Dev servers with multiple databases, with couples of them over 10-12 terabytes both in a Cluster environment with Mirroring and Replication and Implemented Always On.

Responsible for building new infrastructure for EOL and Migration database of 2008 to SQL 2012 & SQL 2014 Servers and Cloud databases (Windows Azure).

Working knowledge of Azure VMs, Azure Virtual Network, Service Bus, Azure Storage, X.509 certificate in Microsoft Azure.

Developed ETL Solutions for various teams.

Recommendation/Configuring of availability strategies database mirroring, clustering, and setting up a database for replication, log shipping, and Database mirroring and monitoring the setup & Creating SSRS reports.

Scheduled Backups of databases and recovered them periodically to verify the integrity of Backups. Experience working with Lite Speed.

Developed several database structures, and complex SQL queries, writing stored procedures, views, triggers, and user-defined functions.

Identifying Slow Running queries by the profiler, T-SQL & analyzing and optimizing them.

Managed Query Optimization and Performance Tuning of Stored Procedures, Functions, etc.

Performed Code Reviews and developed Coding Standards considering SQL Server Best practices.

HCL America Inc. -- Redmond, Washington, US Feb 2010 – August 2013 - Redmond, OR

Sr. MSSQL Database Administrator

Project Name: Bing-AdCenter (Microsoft Corp.) –Microsoft vendor

Managed a geographically distributed Application Support Team providing services for Deployment, Incident, and Infrastructure Mgt. for a portfolio of Microsoft business applications and services.

Onsite-offshore coordination designed processes for effective communication with offshore teams.

Responsible for handling the Production environment of the BING ADDS, Microsoft Corp having Databases in 8-10 TBs. and 45000 Severs.

Maintaining Site and Database performance, uptime of 99.99.

Migrated SQL Server 2008 Clusters to Always on Failover Cluster Instances in SQL Server 2012.

Developed ETL Packages and provided data to the various teams based on their business model.

Responsible for query optimization using SQL tools such as SSMS, SQL Profiler, and Index tuning wizard. Worked on incident management issues as per IMR/Tickets raised by the UTS monitoring system.

Working closely with various teams at client locations to gather and understand the database requirement setting up of new MSSQL Server 2008 and 2012 databases in both development and production environments and coordinating with the clients for enhancements.

Attend weekly production support status meetings with Clients and address the gaps, if any.

Performing the root cause analysis of production issues and ensuring monitoring automation of the MS-SQL Server.

Implemented and Maintained Disaster Recovery for Production Database Environment Recommendation/Configuring availability strategies Database Mirroring (Always on), Clustering and Setting Up database for Replication, Log Shipping, and monitoring the setup.

Education & Certifications:

Masters in computer applications (MCA) from IGNOU, 2005

Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions

Administering Microsoft SQL Server 2012, 2016/2019/2022 Databases

Bachelor’s in arts from Delhi University, 1997

Contact this candidate