Samrat Das
Bangalore
Summary
I am a SQL Database Administrator with three years of hands-on experience in managing and optimizing SQL database systems.
In this role, I have honed my skills in installing, configuring, and maintaining SQL database software, ensuring seamless operation and optimal performance. Also with a keen eye for identifying and resolving performance bottlenecks, fine-tuning SQL queries, and optimizing database structures to enhance efficiency.
I am well-versed in implementing robust backup and recovery strategies to safeguard critical data, as well as implementing security measures to protect against unauthorized access and data breaches. I have thrives in troubleshooting complex database issues, leveraging my analytical mindset and attention to detail to swiftly resolve challenges and minimize downtime.
Beyond technical expertise, I am also excel in collaborating with cross-functional teams, including developers, system administrators, and business stakeholders, to understand and address database requirements effectively. My strong communication skills and proactive approach enables me to foster productive working relationships and drive continuous improvement in database operations.
With a passion for staying abreast of emerging technologies and best practices in database management, I am committed to deliver value-driven solutions and ensuring the reliability, scalability, and security of SQL database environments.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Sr. Software Analyst (SQL DBA)
Capgemini
Bangalore
04.2021 - Current
- Led a SQL DBA team , providing mentorship, guidance, and technical leadership to ensure the smooth operation of database systems and the development of team members.
- Managed the installation, configuration and maintenance of SQL Server instances in various environments including development, testing and production to ensure availability and performance.
- Designed and implemented database schemas, including tables, views, indexes, and stored procedures, in collaboration with development teams, to support various applications.
- Performed regular performance tuning and optimization activities, analyzed query execution patterns, optimized indexes, and tuned SQL queries to improve database performance.
- Developed and maintained backup and recovery processes, including full database backups, transaction log backups, and disaster recovery plans, to ensure data integrity and reduce downtime.
- Implemented robust security measures, managing user access permissions, roles, and auditing, and ensuring compliance with industry standards and regulatory requirements.
- Orchestrated High Availability and Disaster Recovery solutions such as AlwaysOn Availability Groups and database mirroring to achieve maximum uptime and reduce the impact from system failures.
- Provided proactive troubleshooting and problem-solving support to resolve database-related issues, coordinating with cross-functional teams to ensure timely resolution and minimal disruption.
- Maintained comprehensive documentation of database configurations, procedures, and best practices, ensuring knowledge continuity and facilitating onboarding of new team members.
Education
Bachelor of Technology - Information Technology
Durgapur Institute of Advanced Tech And Mgmt
Durgapur, West Bengal06-2020
Skills
- Database Administration
- Backup and Recovery
- Security Management
- High Availability and Disaster Recovery
- Troubleshooting and Problem-Solving
- Collaboration and Communication
- Documentation and Knowledge Sharing
- Client Relationship Management
- Change Management
- Continuous Learning and Adaptability
Certification
- SQL for Data Science
- Introduction to HTML
- Web Development(HTML & CSS)
Accomplishments
- Recognition as Best Employee (Twice in Half-Yearly Period)(Capgeminni)
- Worked as the Sole SQL DBA in a Team Environment
- Appreciation for Good Work (Disaster Recovery)(Capgemini)
- Recognition of outstanding performance and going above and beyond(Capgemini).
Affiliations
- Cricket
- PC Games
- Badminton
- Physical Fitness
Timeline
Sr. Software Analyst (SQL DBA)
Capgemini
04.2021 - Current
Bachelor of Technology - Information Technology
Durgapur Institute of Advanced Tech And Mgmt
Similar Profiles
Abdoul-rahim DombaAbdoul-rahim Domba
Ingénieur d'études et de recherche at CapgeminiIngénieur d'études et de recherche at Capgemini
Bélinda BONACINABélinda BONACINA
Document Management, quality and configuration at CAPGEMINIDocument Management, quality and configuration at CAPGEMINI
Namrata DwivediNamrata Dwivedi
Front End Developer at CapgeminiFront End Developer at Capgemini