Highlights

• Having 7.2+ Years of total IT Experience in SQL Server Database Administration.


• Excellent time management, Organizational skills, Confident and Determined.


• Problem solving, positive thinking, hardworking & adaptable to any environment easily.


• Provides database assistance and problem support to application developers, business analysts and business users.


• Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions.


• Used Imp/Exp. Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources.


• Checking the status of backup, troubleshooting the failed backups and restoration of databases.


• Involved in Up-gradation/Migration SQL Server 2008 databases into SQL Server 2012.


• Data base health checkup, Disk Management, Backup planning.


• Monitoring SQL Server using with SQL sentry Tool.


• Tested newly built servers for performance impact with DB load simulators.


• On-call troubleshooting for SQL servers service outages.


• Timely involved in SQL server Subsystem patching.


• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.


• Reviewing SQL Server and SQL Server Agent Error Logs and event viewer.


• Implementing Server level, database level, and Login level security.


• Handling incidents daily as per SLA and resolving/escalating them without breach.


• Timely completion of activities for database backup, restoration, and health check of databases.


• Fixing orphaned users through stored procedures.


• Moving system and user databases across drives as per requirement.


• Monitoring SQL server performance using profiler to find performance and deadlocks.


• Effective usage of DBCC Commands ensuring integrity of the databases.


• Daily activities include monitoring the database, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases.

Skills

Projects

Project 1 (16 months)

Role: Senior Software Engineer





Responsibilities






• Provides database assistance and problem support to application developers, business analysts and business users.


• Installation and migrating databases to higher SQL versions like 2022,2019.


• Basic work experience on Postgres and MYSQL Databases.


• Work experience On Druva and Cloud Ranger tools.


• Automate SQL subsystem Patching using PowerShell scripts

Project 2 (11 months)

Role: System Engineer





Responsibilities






• Deploying RDS/EC2 instance through Terraform or service catalogue.


• Experience on Database migration from on-prem to RDS/EC2 instance.


• Experience in migrating SQL Database to Aurora Postgres.


• Worked on CLI AWS commands.


• AWS RDS/EC2 instance health check, troubleshooting, creating parameters groups, enabling required features in parameter groups. Drive expansion.


• Monitoring SQL server and RDS/EC2 instance through Foglight, Ghaphana Chart.


• Working on JIRA tickets.


• Working On Jenkins automation jobs.


• Experience of creating repository on GITHUB.


• Experience of working on AWS RDS, backup uploads to S3 bucket, and Azure Blob Container, DMS task, EC2 etc.


• Migrating onprem databases, logins, and permissions to cloud smoothly.

Project 3 (13 months)

Role: SQL DBA





Responsibilities






• Provides database assistance and problem support to application developers, business analysts and business users.


• Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions. Used Imp/Exp.


• Checking the status of backup, troubleshooting the failed backups and restoration of databases.


• Involved in Up-gradation/Migration SQL Server 2008 databases into SQL Server 2012.


• Data base health check-up, Disk Management, Backup planning. Monitoring SQL Server using SQL sentry Tool. Tested newly built servers for performance impact with DB load simulators.


• Timely involved in SQL server Subsystem patching.


• Scheduled and maintained routine Jobs, Alerts and Maintenance Plans.


• Reviewing SQL Server and SQL Server Agent Error Logs and event viewer.


• Implementing Server level, database level, and Login level security.


• Experience of working in AWS and Azure Cloud Servers.


• Installed SQL instances, migrated databases, set up mirroring and log shipping in AWS & Azure clouds Server.


• Experience of SQL Subsystem patching and OS patching by IBM Big Fix tool or manually.

Project 4 (16 months)

Role: Service Delivery Specialist





Responsibilities






• Experience of SQL Subsystem patching and OS patching by IBM Big Fix tool or manually.


• Worked on Audit Reports for compliance work.


• Experience in SQL Server Migration from 2005/2008/2008R2 to 2008R2/2012/2014/2016/2017.


• Good knowledge on CyberArk tool for service account password reset.


• Checking the status of Backup, troubleshooting the failed backups and Restoration of databases.


• Experience in Scheduling, Monitoring, and maintaining SQL Server Jobs and Alerts.


• Experience in implementing database security, creating Logins/users and maintaining roles.


• Experience in monitoring of SQL Server by SQL Profiler,


• Execution Plan, Performance Monitor and DBCC Commands.


• Server Health Checkup, Security, Job Monitoring and Maintenance Plans.


• Monitoring SQL Server performance using Activity Monitor.


• Daily Log checking for errors on Production Server.


• Daily checkouts for various servers, which include all the databases, are online and backup failures, maintenance plans, disk space, errors, and warnings.


• Work as part of a team and provide 24x7 supports.


• Handling incidents daily as per SLA and resolving/escalating them without breach.


• Timely completion of activities for database backup, restoration, and health check of databases.


• Fixing orphaned users through stored procedures.


• Moving system and user databases across drives as per requirement


• Monitoring SQL server performance using profiler to find performance and deadlocks.


• Effective usage of DBCC Commands ensuring integrity of the databases

Project 5 (30 months)

Role: Associate Software Engineer





Responsibilities






• Working on assigned/unassigned incident /Ctask /Change and resolve them on priority.


• Performing Database refresh activity from Prod to QA environment


• Implementation of database maintenance plans and backup automation


• Resolving space related issues


• On-Call responsibilities for Production database systems


• Working on Database recovery /restoration


• Performing Disaster Recovery (DR) test on a Quarterly basis.


• Managing the p1/p2 Bridge call for fixing the high priority issues


• Daily checking health check for the prod servers.


• Worked on Database security, logins, permissions.


• Capacity planning for Database and Drives


• Troubleshooting performance related issues


• Working on Data file movement and space management


• Working to ensure Healthy Database, ensuring the database backup etc.


• Worked on lock, blocking, Deadlock etc.


• Technical troubleshooting and give consultation to development teams