SUMMARY

• An astute & result driven professional with total 11 years of experience in Database Administration, Database Design, Database Architecture, Modeling & Support of critical MS SQL server.
• Expertise in migrate an on - premises Microsoft SQL server database to Cloud computing (AWS RDS SQL, Aurora PostgreSQL, Azure IAAS, PAAS model) and support.
• Skilled in automating DBA activities and upgrading existing databases.
• Well versed in maintaining and optimizing database performance through tuning.
• Good Experience in Backup & Recovery scenarios.
• Good experience in implementing High Availability & Disaster Recovery solutions using Failover group, Geo Replication, Data sync, Always On, Clustering, Replication, Mirroring and Log Shipping.
• Develop, build & maintain mission critical centralized data platform using Snowflake.
• Good knowledge on design & provisioning cloud infrastructure through CI/CD pipeline.
• A Knowledge of best practices and IT operations in an always-up, always-available service.
• Proficient in IT operations including extensive Production Incident Management, Change Management, Release Management, Production Support and Problem Management.
• Vast experience in high-volume environments with strong analytical, communication, and organizational abilities.
• Complex problem solver able to thrive in fast-paced and challenging roles.

TECHNICAL SKILLS

• AWS
• Azure
• SQL
• Aurora PostgreSQL
• RDS SQL
• Snowflake
• Azure IAAS
• Azure PAAS
• High Availability
• Replication
• Performance Tuning
• Automation
• Cluster
• Disaster Recovery
• DB Migrations
• Cross Platform Migration
• SCT
• DMS
• DMA
• Database Administration
• Database Architect
• Production Support
• Patching
• Bitbucket
• Jenkins
• Azure PowerShell/CLI
• DevOps
• Git
• GitHub
• Visual Studio code
• Sourcetree
• Docker
• JIRA
• Confluence
• Windows
• Linux
• MS Visio
• MS Office
• Cloud Architect
• IIS
• CloudFormation
• ECS
• ECR
• Lambda
• S3
• API Gateway
• Cognito
• Cloud Engineering
• Cost estimation
• Cost optimization
• ServiceNow
• BMC Remedy
• Partitioning
• Encryption.

PROFESSIONAL EXPERIENCE

Confidential

Cloud Database Architect / Database Administrator

Responsibilities:

• Leading SQL Database Administrator in on-premise, AWS and Azure environments which involves SRT participation, RCA preparation, Problem management, Performance tuning, DBA tasks automation, Backup strategy, Patching and continuous improvement plans.
• Participate in 24X7 on call rotation schedule for various production support, database maintenance, housekeeping and installs.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Establish database standards for operations, upgrades, migrations and on boarding new applications.
• Played critical role as Cloud Database Architect on cloud migration projects which involves participating on Modernization and Transformation of databases.
• Experience in deploying SQL Databases in AZURE and AWS.
• Migrating database from On-premise (SQL, Oracle) to AWS Cloud (Aurora PostgreSQL, RDS, S3) and Azure Cloud (Azure SQL DB, MI, IAAS VM) using Schema/DB migration tools/methodologies (SCT, DMS, DMA, Bacpac, Dacpac, Replication).
• Configuration, maintenance and issue handling on Always On Availability Group, Log shipping, Mirroring, Replication and Linked Servers.
• Performance monitoring and analyze the high utilization queries to tune the queries.
• Participate in Disaster Recovery activities.
• Experienced on Side by side and in-place up gradation from and 2008R .
• Involved in provisioning infrastructure using cloudformation through Bitbucket, Jenkins tools.

Confidential

Lead Database Administrator

Responsibilities:

• Prime responsibility includes first line support of all MS SQL requests/incidents/tickets and escalations.
• Responsible for database support, troubleshooting, planning, and migration.
• Monitoring of database size and disk space in production environment.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
• Security and architectural planning issues met as well as testing and training.
• Cluster Servers Failover testing and troubleshooting and resolution as well as monitoring and backup reporting setup with Operations Manager.

Confidential

Senior Database Administrator

Responsibilities:

• Responsible for Transition of DBA support from another vendor and documentation.
• Manage SQL backup and restore.
• Refresh the data from PROD to QA.
• User creation and manage permission.
• Coordinate with patching team during security patching activity and perform SQL end activities.
• Resolving issues based on ticket, which is created in Service now ticketing tool.
• Perform password reset activity.
• Managing performance related issues.
• Managing standalone and clustering environments.
• Verify the jobs daily and troubleshoot if any issues.
• Monitoring alerts and troubleshoot based on alerts.
• Build a new SQL server from scratch.

Confidential

Senior Database Administrator

Responsibilities:

• Migrated 100+ SQL DB’s migration from SQL 2005 to SQL 2012.
• Implemented SQL high availability.
• Created Application Information Document.
• Implemented Build & Deployment operation process.
• Coordination with infrastructure team for any network/firewall changes and OS related issues.

Confidential

Senior Database Administrator

Responsibilities:

• Support for Microsoft Azure IaaS and SQL Azure DB Environments.
• Import and Export data within Azure cloud environment.
• Has involved in Migrations activities of SQL server from and also fix issues respectively.
• Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.
• Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
• Setting up SQL Azure firewall.
• Create, manage SQL server Azure databases.
• Setup maintenance plans for databases using Azure Elastic jobs and Azure automation Methods.
• Provide technical guidance on building solutions using Azure PaaS and other services.
• Experienced with deployments, Maintenance and troubleshooting applications on Microsoft cloud infrastructure Azure.
• Perform applications support staff in diagnosing and resolving database-related application problems.

Confidential

Software Development Senior Analyst

Responsibilities:

• Performed SQL server installation and administration of 2005, 2008 R2, 2012.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Performed Migration of data fromSQL Server 2005to SQL Server 2008 R2.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Executing DB evolution scripts based on the requirement by Development team, Data Architects and Business Analysts as a part of Enhancement projects.
• Coordinate with consultants and manage vendors for patches and upgrades.
• Integration of IIS web application with Middle-Tier and Database-Tier.
• Build deployment and administration of IIS 7 web server.
• Handling tickets raised in “BMC Remedy”.
• Involved in change management (Install, Modify, Add, and Change).
• Key Player of the Disaster Recovery Exercise.

Confidential

System Administrator

Responsibilities:

• Installation, configuration and administration of windows server.
• Perform SQL administrative tasks including installing and upgrading SQL server products, creating maintenance plans and creating database objects.
• Perform daily administration, monitoring, and documentation of Windows and SQL Servers.
• Installation and configuration of IIS 6, 7 web server.
• Involved in windows and SQL security patches updating activities.
• Handing user tickets being routed from Helpdesk.
• Provide 24x7 coverage.