Objective

Having **+yrs of experience with detail oriented, analytical, and troubleshooting experience with includes as MSSQL Server Database Administration and Azure Data Factory, managing databases and azure services to excel myself in the field of Database systems, where I can put my knowledge and multiple skills to the best of use.

Career Summary

Having a total of 12 years of experience as a MSSQL /PostgreSQL DBA and SQL AZURE Engineer to the Highly transactional production server Environments with 24/7 on Call Support for the Production Database Environment.

Having a total of 4 years of total experience in software development this includes System Study (System Analysis/ Design and development), project study, feasibility study, project scoping and scheduling, team handling and work allocation.

Certified for Microsoft certified Azure Fundamentals.

Experience in SQL Server 2022/2019/2016 Aways On, MS Cloud Azure and SQL Server on-premises

Proficiency in geospatial database design, development, and administration on enterprise DBMS such as SQL Server and PostgreSQL.

Experience in creating the new GIS web and mobile specifications

Experience in setting up PostgreSQL clusters and Sybase and supporting HA/DR solutions

Experience in managing PostgreSQL on multiple operating systems including Microsoft Windows, Linux (RHEL) and Kubernetes in OpenShift platform.

Experience in setting up PostgreSQL clusters and supporting databases cluster in on-prem and hybrid cloud environment, and specifically in AWS RDS instance

Experience working on creating the frameworks towards building the data pipelines,

Azure Data Factory and other Azure data solutions

Deep understanding of PostgreSQL and MSSQL Server database internals.

Perform code migrations from MS SQL Server to SYBASE to PostgreSQL

Having a total of 4 years of total experience in software development this includes System Study (System Analysis/ Design and development), project study, feasibility study, project scoping and scheduling, team handling and work allocation.

Experience with data warehouse integration and data engineering using real-time messaging and batch ETL/ELT in the data management discipline Using Microsoft Azure Data factory and Databrick

Building, deploying, sharing, and maintaining enterprise-grade data, analytics, and AI solutions at scale.

Experience in Change Management, Incident Management with simultaneously managing multiple modules and Project implementations.

Standardize the process within the data department including creating documentations for installations, migrations, upgradations, backups, restores and index maintenance.

Data Transformation activities using BCP and SSIS import /Export for transferring data between different data sources and using adapters in cloud.

Key involvement in interaction with clients both from onsite and offshore for scoping, effort estimates, status reporting, design, and production support

Experience of high availability SQL Server solutions, including Log shipping, Transactional replication and Always ON

Expertise in performance tuning and query optimization have good experience working on large databases (7TB –15TB)

Experience on Installation, configuring, upgradation, Failover Cluster Installation, and testing on Mssqlserver 2022,2019, 2016,2012 and 2008R2

Recognized for being proactive, providing effective problem resolution and ensuring continuous improvement of database operational process.

Maintain awareness of developments in emerging technologies and disciplines relating to present and future products and solutions through personal research, continuing education, seminars, and related activities.

Provides support in capacity planning, forecasting, and tuning. Develops performance/tuning evaluation reports.

Education

B. Tech Computer Science and Information Technology from JNT University

Technical Skills

Programming Languages

T-SQL, No SQL,C#

Databases

MSSQL Server2022,2019,2016,2012,2008R2 and 2008, PostgreSQL,

SSIS,Azure Data Factory, Sybase, Data Bricks,GIS Database

Tools

SQL Server Management studio, ServiceNow Lite Speed, Avamar, PowerShell

MS-Windows Server and SCOM2012/2016, SSRS,

ETL, SharePoint, Azure ADLS Gen 2, Azure Arc,

Synapse, Power Biand PowerShell

Operating System

Windows 2008/2012/2016

Employment History

Name of the company

Designation

From

To

FIS Global

Sr SQL/ PostgreSQL DBA

Sep 2019

Till Date

IBM Pvt Ltd

Database Administrator

Mar 2016

April 18

Tech Mahindra

Database Administrator

Oct 2012

Jul 2015

HCL Technologies

Lead Engineer

May 2008

Sep 2012

Professional Experience

FIS Global Mar 2021 to Till Date

Role: Sr SQL/ PostgreSQL/Sybase DBA and SQL AZURE

Project: Merchant solutions -Integrated payments

Fis global works with financial institutions to develop programs and tools to simplify payment strategies. The company's financial products include credit cards, set up and collect payments from your policyholders – known as the premium collection process. Payments are changing all the time, so the solution you get today needs to be right for what you are going to be facing and based on our most up-to-date knowledge and experience.

implementing, automating, and monitoring a variety of data ingest pipelines using a variety of tools such as Azure Data factory.

Expertise database administration for SQL Server and Sybase.

Expertise in Installation, Upgrade & Patching of different components in MSSQL, Postgres, Sybase and experience with the other platforms we manage listed in the Duties and Responsibilities.

Experience with installing, configuring, and upgrading Microsoft SQL software.

Worked with On-Premises SQL Server with Azure Data Factory via a Self-Hosted

Worked with the agent runs on dedicated monitoring virtual machines to remotely collect data for SQL PaaS and SQL IaaS deployments.

SQL Insights stores its data in Azure Monitor Logs (Workspace), allowing users to do aggregations, filtering, and data analysis.

Monitoring On-Premises SQL Servers using Azure SQL Insights

Solid SQL skills using Azure Blob/Data Lake, Azure Data Factory to transform data, Azure Functions, Azure SQLDB

Maintain backups and perform disaster recovery in case a disaster recovery for Postgres and Sybase database instances and MSSQL databases

Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Configured and maintained failover cluster using Sql server 2012.

Design, develop, and maintain data pipelines using Azure Data Factory to ingest, transform, and load large-scale data from various sources into data lakes or data warehouses.

Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and management about the table structures that are to be defined and the data structure that is to be collected from the clients.

Involved in creation/review of functional requirement Configuring SQL Server distributed availability groups between clusters on Both Prod and DR environment.

Deploying Pass transfers for the merchants in standard procedures

Diligently work with change management process with snow central process

Configuring SQL Servers and certifying as per client requirement

Applying latest SQL Server Patches on SQL Server 2016sp3 and SQL Server 2012

Monitored and scheduled new and existing jobs.

Monitored the use of disk space usage, memory, and connections.

Performed troubleshooting of client’s database related issues during implementation, maintenance, and upgrading process

Environment: MSSQLSERVER2016/2019/2022, PostgreSQL, SYBASE, SSIS, SSRS, PASS, SSAS, Clustering, Always ON ServiceNow, Avamar, SCOM2012, DTS, Query Analyzer, SQL Profiler, Import/Export tools, SQL Server Agent, T-SQL, and Azure SQL Managed Instance.

FIS Global Sep 2019 to Mar 2022

Role: Sr SQL DBA and SQL AZURE

Project: Core and Paymetric

Merchant Solutions has Managed Services Team became a trusted advisor to a global digital marketing agency by helping them optimize their legacy database for greater operational effectiveness.

Good knowledge of ETL tools, SSIS and Azure Data Factory, experience with building pipelines in Azure Data Factory and Synapse pipelines

Build and maintain data ingestion and validation pipelines for both structure and non-structured data sources.

Deployment of Production environment on SQL Server 2016 and SQL Server2012 both in Standalone and clustering Environment.

Configuring SQL Servers and certifying as per client requirement.

Perform database deployments and provide support for application releases.

Applying latest SQL Server Patches on SQL Server 2008R2 and SQL Server 2012

Monitored and scheduled existing/new jobs.

Performed troubleshooting of client’s database related issues during implementation, maintenance, and upgrading process

Setup SQL server configuration settings to resolve various resource allocation and memory issues for databases and setup ideal memory, Min/Max server options.

Monitoring SQL server logs ensures whether back operations, batch commands scripts have completed successfully.

Setup backup and recovery plans also had proper documentation platform making sure data is secured at all levels.

Promote and enforce adoption of standards, process and SLA’s.

Environment: MSSQLSERVER2012/2016/2019, SSIS, SSRS, PASS, SSAS, ServiceNow, Avamar, SCOM2012, DTS, Query Analyzer, SQL Profiler, Import/Export tools, SQL Server Agent, Power BI, Data Bricks, T-SQL and Azure SQL Managed Instance.

IBM May 2016 to apr2018

Role: SQL DBA and PostgreSQL Admin

Project: GIS (Global Investment Services) State Street Corporation, USA

The global Services business is a custodian bank under custody and administration. The Global advisor’s business provides investment management services for assets under management. The Global Markets business offers investment research and trading services to institutional investors. Installing SQL Server 2008R2 and SQL Server2012 both in Standalone and clustering Environment.

MSSQLSERVER2012, PostgreSQL, SSIS, IIS, XML, ITSM, Vertex o series and SCOM2012

Tech Mahindra Mar 2014 to July 2015

Role: Sr SQL DBA and GIS Admin

Project: Shared Vertex –Corporate Tax–Microsoft R&D PVT Ltd

The Vertex O Series platform provides an advanced architecture for integrating a broad range of tax compliance features into a single, seamless application suite. Vertex® Indirect Tax O Series® (Vertex O Series) integrates with your enterprise financial, accounting, ERP, or CRM host system to calculate tax automatically on individual business transactions.

MSSQLSERVER2012, Postgresql, SSIS, IIS, XML, ITSM, Vertex o series and SCOM2012, Replication

Tech Mahindra Oct 2012 to Mar 2014

Role: SQL DBA

Project: Global Change Operations-Microsoft R&D Pvt Ltd

SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.

MSSQLSERVER2012/2008, SSAS, SSRS, SSIS,IIS,SCOM2007

Hcl Technologies Apr 2011 to Sep 2012

Role: SQL DBA

Project: TR-WEBQA Thomson Reuters (US)

TR-Web Quantitative Analytics, also known as Thomson Reuters Quantitative Analytics, or TRWEBQA for short, is a Microsoft .NET 3.5 web service application which provides historical finance analytics tools through Simple Object Access Protocol (SOAP) calls, and real time data feeds through Data works Enterprise1.TRWebQA is a customizable scripting language for accessing financial data over the Internet. Within TRWebQA, users can define screens, reports, and formulas for use in any TRWebQA-based application.

MSSQLSERVER2005/2008, ASP.NET, C#.NET, TRSL, TortoiseSVN, SSIS

Hcl Technologies July 2008 to Mar 2011

Role: Programmer

Project: Private Company Development Thomson Reuters (US)

The Private Company Development is a user friendly, integration application developed to maintain historical data of customer’s worldwide from different systems. It Import /Export lists of the data from different QAI databases or Different Technologies along with the Cleansing Activities of the customer’s database to the users based on their roles.

MS.NET2005, MSSQLSERVER2005, TRSL, TortoiseSVN and TAF Tool, HTML

Contact this candidate