SUMMARY

• A dynamic professional with 13 years of experience as DBA and data services.
• Experience with Agile/Scrum methodologies.
• Self - motivated, responsible, confident and can multi-task and prioritize under changing and challenging workloads.
• Providing 24x7 support for Confidential SQL server, Postgres and Mongo databases holding critical business data.
• Migrate databases from DB2/Oracle to SQL Server/SQL Azure by suing DMS/DMA/SSMA.
• Configure and manage Azure Monitor/ Azure App services / Azure Load Balancers / Azure Key vault and IAM policies.
• Converting the Possible applications to open source (Like DB2/Postgres/MySQL) to save Money on the License cost.
• Design and implement high availability strategies with replication, log shipping, database mirroring/Always On.
• Design and configure cloud network architecture using Azure virtual networks, VPN and express route to establish connectivity between on premise and cloud.
• Assist leadership with the ongoing development of policies and procedures for the purpose of consistent product delivery.
• Develop custom features in Visual Studio based on specifications and technical designs.
• Develop PowerShell and Python scripts and ARM templates to automate the provisioning and deployment process.
• Participate in internal and customer meetings assisting with the ongoing evolution of technology offerings.
• Provide technical guidance on building solutions using Azure PaaS and other services.
• Experience creating roles, database access, performing Vacuum operations in Postgres.
• Installation, Configuration, testing, upgrade and tuning of PostgreSQL databases.
• Expert level of Postgres SQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in large and very dynamic environments
• Advanced knowledge of PL/pgSQL, triggers and writing change scripts.
• Supporting multi node MS SQL Cluster (Active/Passive & Active/Active) instances.
• Design and implement Lifecycle in AWS with S3 Backup objects.
• Design and implement in AWS RDS, Postgres, AWS DMS services.
• Write, debug and optimize complex PostgreSQL queries.
• Providing support for AWS/Azure services like EC2/RDS/ SQL database
• Troubleshoot and identify performance, connectivity and other issues for the applications hosted in Azure platform.
• Experience on AWS Schema Migration tool and DMS tools
• Deploying, configuring, managing, patching, troubleshooting, and optimizing data services.
• Database migrations and upgrades from SQL Server 2008, 2005, 2000 to SQL 2012, 2016, 2017 upgrades
• Provide technical solutions to issues encountered by new and existing applications in the environment.
• Attend high priority service restoration calls and providing technical assistance to application development teams.
• Performance Tuning and Optimization, using native monitoring and with troubleshooting tools like Confio Ignite.
• Synchronizing and migrating data and database objects across non-production (development, QA, staging, UAT, etc) and production environments.
• Experienced in building internal tools to reduce manual effort using .NET technologies and scripting methodologies.
• Design and document database architecture (data modelling), including logical and physical layers.
• Experience on MongoDB collection and indexes & aggregation framework.
• Hands on operational experience like scaling, HA, Monitoring, Security and Backup.
• Mongo DB Installation, Configuring and Monitoring Replica sets.
• Working with other teams such as BA and Development in resolving the technical issues with respect to application
• Configuration and deploy SSIS packages and SSRS reports.

PROFESSIONAL EXPERIENCE

Reliability Engineer

Confidential

Responsibilities:

• Installing, configuring, administrating, and securing SQL Server 2000/2005/2008 , 2008 R2, 2012, 2014, 2016, 2017 and 2019
• Deploy the service builds across the services using Azure Ev2 pipelines and sequence manager.
• Define cloud network architecture using Azure virtual networks, VPN and express route to establish connectivity between on premise and cloud.
• Assist leadership with the ongoing development of policies and procedures for the purpose of consistent product delivery.
• Develop custom features in Visual Studio based on specifications and technical designs.
• Develop PowerShell and Python scripts and ARM templates to automate the provisioning and deployment process.
• Configure and maintain Azure Services like Load Balancers/AKV/Storage/VNet/Monitor/Az Functions.
• Support F5 devices to rotate the servers to do maintenance.
• Deploy and configure Virtual networks, VM’s and configure high availability by using scale set.
• Configure and support high availability solutions in SQL server management instances and Azure databases.
• Building Data archival strategy with application teams by writing T-SQL Scripts.
• Automating the Infra maintenance tasks, with PowerShell and Python.
• Building the database servers based on the FDA, HIPPA and SOX regulations
• Deploying the SQL servers in Azure and configuring the hybrid model.
• Installing/Troubleshooting Always on / SQL High Availability clusters.
• Optimizing, tuning and debugging code for improving batch efficiency with databases including re-indexing, updating statistics, recompiling stored procedures and functions.
• Setting up SSRS reports and PowerShell reports for easy administration of Databases.
• Implementing operational automation using PowerShell scripting.

Database Administrator

Confidential

Responsibilities:

• Installing, configuring, administrating and securing SQL Server 2000/2005/2008 , 2008 R2, 2012, 2014, 2016 and 2017
• Used Scrum Agile Methodology in my work (Daily Scrum Meeting, Sprint Backlog, 1on1 meeting)
• Building Data archival strategy with application teams by writing T-SQL Scripts.
• Integrating the on-premises environment to cloud.
• Create and maintain SSIS packages, SSRS reports and SSAS cubes for OLTP and Data Warehouse environments.
• Automating the DBA tasks, with PowerShell and Python.
• ETL processing using SSIS packages and its components such as script tasks, control flow tasks, look up transformations, data flow tasks and event handling.
• Building the database servers based on the FDA, HIPPA and SOX regulations
• Planning, implementing all types of Backups (Full, Differential, Transactional) and Restore Operations
• Design and document database architecture (data modelling), including logical and physical layers.
• Experience on MongoDB collection and indexes & aggregation framework.
• Hands on operational experience like scaling, HA, Monitoring, Security and Backup.
• Mongo DB Installation, Configuring and Monitoring Replica sets.
• Deploying the SQL servers in Azure and configuring the hybrid model.
• Installing/Troubleshooting Always on / SQL High Availability clusters.
• Optimizing, tuning and debugging code for improving batch efficiency with databases including re-indexing, updating statistics, recompiling stored procedures and functions
• Expertise in Performance Tuning and Query optimization using native and third-party tools such as Idera’s SQL diagnostic Manager
• Setting up SSRS reports and PowerShell reports for easy administration of Databases.
• Implementing operational automation using PowerShell scripting

Lead Database Administrator

Confidential

Responsibilities:

• Installing, configuring, administrating, and securing SQL Server 2008 R2, 2012, 2016 and 2017
• Used Scrum Agile Methodology in my work (Daily Scrum Meeting, Sprint Backlog, 1on1 meeting)
• Integrating the on-premises environment to cloud.
• Migrating the applications from other database services to SQL servers
• Building the database servers based on the FDA, HIPPA and SOX regulations
• Planning, implementing all types of Backups (Full, Differential, Transactional) and Restore Operations
• Providing day-to-day Support and Maintenance of SQL Server databases
• Upgrading the applications to cloud (EC2/RDS)
• Deploying the SQL servers in Azure/AWS and configuring the hybrid model.
• Working on Amazon web services to migrate systems by using DMS (Data migration services)
• Installing Always on / SQL HA clusters.
• Setting up monitoring by using cloud watch logs (AWS) and Activity log in (Azure)
• Building Data archival strategy with application teams.
• Optimizing, tuning and debugging code for improving batch efficiency with databases including re-indexing, updating statistics, recompiling stored procedures and functions
• Expertise in Performance Tuning and Query optimization using native and third-party tools such as Idera’s SQL diagnostic Manager.
• Analysing and developing Conceptual, Logical and Physical database models using CA’s Erwin data modeller tool and Confidential Visio
• SQL Server Business Intelligence Development Studio knowledge to create SSIS packages, SSRS reports and SSAS cubes for OLTP and Data Warehouse environments.
• Experienced with ETL processing using SSIS packages and its components such as script tasks, control flow tasks, look up transformations, data flow tasks and event handling.
• Setting up SSRS reports and PowerShell reports for easy administration of Databases.

Technical Specialist

Confidential

Responsibilities:

• Installing, configuring, administrating and securing SQL Server 2000/2005/2008 , 2008 R2, 2012 and 2014
• Deploy builds to services with Octopus sequence manager and PowerShell.
• Resolving data/Configuration issues in Replication.
• Planning, implementing all types of Backups (Full, Differential, Transactional) and Restore Operations
• Providing day-to-day Support and Maintenance of SQL Server databases
• Moving Database from one Server to another by using Backup & Recovery, Export & Import, and Attach & Detach
• Deploying the SQL servers in Azure and configuring the hybrid model.
• Setting up security polices and crating appropriate logins, roles and application roles.
• Writing COSMOS big data queries to analyse the business/system trends.
• Administrating high availability solutions like Log shipping, Mirroring, Clustering and Replication
• Performing Maintenance tasks like rebuilding, reorganizing indexes, update statistics and checking database integrity at regular intervals
• Identifying and monitoring Memory usage, CPU utilization, Cache hit, Physical reads counters using performance monitor
• Identifying and resolving Blocking and Deadlocking issues by using Activity Monitor, System stored procedures and profiler.
• Setting up SSRS reports and PowerShell reports for easy administration of Databases.
• Used Scrum Agile Methodology in my work (Daily Scrum Meeting, Sprint Backlog, 1on1 meeting)
• Configuring and maintaining Repl sets and shards for High availability.

Project Engineer

Confidential

Responsibilities:

• Installing, configuring, administrating and securing SQL Server 2000/2005/2008 , 2008 R2
• Worked for AIMS server build.
• Administrating databases in SQL Server 7.0/ 2000/2005/2008 and 2008R2
• Migrating databases from SQL Server 7.0 to SQL Server 2008 R2
• Scheduling daily maintenance tasks using jobs and maintenance plans
• Scheduling and monitoring all maintenance activities including database consistency check, update statistics, and index maintenance through maintenance plans.
• Managing Logins and Permissions
• Identifying and resolving Blocking and Deadlock issues by using Activity Monitor Profiler
• Troubleshooting TempDB and Log file issues
• Used SQL Profiler for troubleshooting, tuning of SQL Server performance
• Good TSQL Scripting
• Moving data base using Export, Import wizard, BCP and Bulk Insert operations
• Monitoring Log shipping and troubleshooting errors.
• Deploy and Configure in SSIS Packages and SSRS Reports.

Sr Process Executive

Confidential

Responsibilities:

• Performed regular Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully
• Install and Configure SQL database 2000, 2005, 2008 and 2008R2 for development and production environment for multiple customers
• Worked on Database Maintenance, Backups and Recovery Plans.
• Administer MS SQL server by creating user Logins with appropriate roles, granting and denying login privileges, monitor the user accounts, creation of groups, granting database and application roles to users and groups.
• Schedule and maintain routine Jobs, Tasks, and Alerts.
• Monitor SQL Error Logs/ Schedule tasks/data activity/ eliminate blocking and deadlocks/ user counts and connections/ locks.
• Installed, configured and administrated SQL server 2000 and SQL server 2005, 2008.
• Constantly checking functionality of the environment and taking necessary action when an alert is thrown from alerting mechanism by taking a prompt action based on its severity and considering the resolution of the issues as most primitive tasks.
• Carrying out Installations and up gradations of SQL server Database engine and client tools through all the versions and administrating the same.
• Knowledge on Administrating SQL server Mirroring, log shipping and other high availability methodologies.
• Dealing with security requirements of SQL Server i.e. Database Access Permissions