About Me
Around 7.0 Years of experience in the IT industry including the experience in Administration in Microsoft SQL server 2012 and 2014, 2017, 2019.
Experience
Data analyst lead
I'm a data analyst lead working under Google waymo self driven ai car project would like to apply for the mentioned position
Data Analyst
Providing 24/7 support for over 150+ Production and pre-production instances SQL Server 2012, 2014, 2017, 2019 as standalone/clustered environment.
Installation and configuration in different versions of SQL Server.
Applying Service Packs, Cumulative Packs, related Hot-Fixes and troubleshooting.
Reviewing and enforcing SQL Server security by managing user privileges and efficient resource management by reconfiguring profiles and assigning roles to users.
Monitoring SQL Server performance using SQL Profiler, optimizing queries using Tuning Advisor and tracing long running queries.
Verifying and resolving SQL Server blocking and dead lock issues.
Creating database objects including tables, indexes, views and stored procedures.
Suggested and implemented backup and restoration strategy required for client environment.
Maintaining database backups, recovery models and recovery techniques appropriate for various recovery scenarios.
Configuring weekly maintenance plans such as integrity check, rebuilding indexes, update statistics and monthly plans such as clean up history.
Implementing and handling SQL Server disaster recovery activities of databases using Database Mirroring, Replication, Log shipping combination of HA-DR.
Cluster installation with Active/Passive, adding nodes in respective servers and performing failover and failback operations in cluster environment for adding new disks and troubleshooting.
Worked on data migration and integrated data through creating SSIS packages.
Good knowledge in SQL Server Reporting Services (SSRS).
Involved in high availability planning of clustering and Always-On features.
Upgrading and migrating servers from lower versions to higher versions.
Data Analyst
Providing 24/7 support for over 150+ Production, and pre-production instances SQL Server 2012, 2014, 2017, 2019 as standalone\Clustered environment.
Experience in Installation, Configuration in different versions of SQL Server.
Applying Service Packs, Cumulative Packs, related Hot-Fixes and Troubleshooting.
Expertise in Installation, Configuration of various versions of SQL Server.
Experience in Reviewing and Enforcing SQL Server Security by Managing User Privileges and Efficient Resource Management by Reconfiguring Profiles and Assigning Roles to Users.
Monitoring SQL Server Performance using SQL Profiler, Optimizing the Queries using Tuning Advisor and Tracing Long Running Queries.
Verifying and Resolving the SQL Server Blocking and Dead Lock Issues.
Hands on experience in creating Database Objects including Tables, Indexes, Views and Stored Procedures.
Suggested and Implemented Backup and Restoration Strategy required for Client environment.
Hands-on Experience in maintaining Database Backups, Recovery Models and Recovery Techniques appropriate for various Recovery Scenarios.
Configuring weekly Maintenance Plans such as Integrity Check, Rebuilding Indexes, Update statistics and monthly plans such as clean up history etc. to run the databases efficiently.
Proficient in Implementing and Handling SQL Server Disaster Recovery activities of Databases using Database Mirroring, Replication, Log shipping combination of HA-DR.
Good experience in Cluster Installation with Active\Passive. Adding the Nodes in respective servers & Performing Failover, Failback operations in Cluster Environment for adding the New Disks and troubleshooting.
Worked on Data Migration and Integrated Data through creating SSIS packages.
Good Knowledge in SQL Server Reporting Services (SSRS).
Involved in High Availability Planning of Clustering and Always-On Features.
Proficient in Upgrading and Migrating Servers from lower versions to higher versions.
Knowledge in data science and supply chain analytics, Deep learning and machine learning.
Real-time knowledge of project management application of CPM and PERT techniques.
JUNIOR VLSI ENGINEER
JUNIOR VLSI ENGINEER
Installation and configuration of SQL-PLX.
Administered the SQL Server by creating User Logins with appropriate roles and permissions. Monitored the issues like failed logins and resolved the issues by granting privileges to users.
Protected databases by taking different kinds of Backups such as Full, Differential and Transactional log backups.
Created Database Objects such as Tables, Indexes, Views and Stored Procedures.
Solved production problems and performed Point in Time recovery.
Scheduled Maintenance jobs for routine jobs and created Alert\Notification system.
Involved in database migration and upgradation from lower to higher versions.
Resolved Disk Space issues, growth issues and other issues related to databases.
Monitored and Resolved the TempDB full and Transactional Log full issues.
Changed the recovery models whenever necessary and accordingly.
Maintained Database Consistency check using DBCC commands.
Daily checking the assigned tickets and resolving the queries and tickets depending on the priority level.
Repetitive issue analysis and proposals for permanent resolutions.