Skip to main content
Aditya Joshi

Aditya Joshi

SQL DBA

Talent
Bengaluru, Bengaluru UrbanMember since July 24, 2023
·

Hire this person

Send a job offer directly to this candidate

About

Highly skilled and dedicated SQL Server DBA with 2.3 years of experience managing and optimizing database systems.  Adept at designing and implementing robust database solutions, ensuring data integrity, and maximizing system performance.  Proficient in SQL Server administration, backup and recovery, replication and database security.  Strong problem-solving abilities with a proactive and detail-oriented approach to handle complex database issues.

 Experience in High Availability and disaster recovery in SQL Server.  Basic Knowledge of HTML5 and CSS3.  Excellent communication and collaboration skills, proven through successful cross-functional teamwork and client interactions.  A proactive team player committed to delivering high-quality service and exceeding customer expectations.

Experience

Administered and maintained multiple SQL Server databases, ensuring high availability, reliability, and optimal performance.

 Implemented effective backup and recovery strategies, including full and incremental backups, log shipping, and point-in-time recovery, to ensure data integrity and minimize downtime.

 Performed regular database monitoring and identifying and resolving bottlenecks to enhance overall system efficiency.

 Conducted database security audits, implemented access controls, and monitored user permissions to protect sensitive data and ensure compliance with security regulations.

 Managed database migration and upgrade projects, ensuring seamless transitions and minimal disruption to business operations.

 Provided technical support and troubleshooting for SQL Server environments, resolving customer issues via phone, email, or remote assistance.

 Diagnosed and resolved database-related problems, including performance issues, connectivity errors, database corruption, and data integrity concerns.

 Performed root cause analysis of recurring issues, identifying underlying causes and implementing preventive measures to minimize future incidents.

 Developed and maintained documentation, including standard operating procedures, system configurations, and troubleshooting guides, to facilitate knowledge sharing and support efficient operations.  Auditing Login Failures, Monitoring connectivity Issues, Audit Long Running Queries, Monitoring Jobs & Alerts, Monitoring Alerts, Database Backups Audits, Database Refresh Procedures

 Assisted in capacity planning and resource allocation to anticipate future growth and scalability requirements.  Blocking Issues and Resolution, Deadlock detection and Prevention, Database Maintenance (Check DB, Updating Statistics & Index), Patching Activities and Issues.  Configuring Replication, Always On Monitoring Performance Counters (Memory, CPU, Disks) and Creating KB Articles.

 Participated in on-call rotations to provide 24/7 support for critical database issues and emergencies.

 Conducted regular database performance analysis and generated reports, presenting findings and recommendations to stakeholders and management.

 Assisted senior DBAs in daily database administration tasks, including database monitoring, performance tuning support, and backup and recovery.

 Performed routine database maintenance tasks and database consistency checks.

 Experienced in maintaining and providing Access in SSAS, SSIS and SSRS database respectively.

 Assisted in troubleshooting and resolving database-related issues, working closely with cross- functional teams to minimize downtime and data loss.

 Contributed to the creation and maintenance of technical documentation and standard operating procedures.

 Experience in shrinking data files and logs in SQL Server and worked on weekly backup reports and trouble-shooting the failed jobs.

 Experience in High Availability and disaster recovery in SQL Server.

 Experience in restoring system databases when the files are corrupted.

 Ability to work well on a team and individually and ability to work well on ticketing tools- Service Now and Service Desk.

Education

 Head Placement Coordinator in various campus recruitment drives during graduation

 Participated actively in state level competitions for Volleyball and throw ball in 10th and 12th.

 Participated actively in state level competition for Drama.

 Class representative for two consecutive years during graduation

 Education minster in school.

Reviews

Related