Manoj K Dey
Morrisville,NC
Summary
To work in a challenging atmosphere by exhibiting my skills with utmost sincerity and dedicated smart work for the growth of your esteemed organization along with mine.
To endeavor for excellence in competence, delivery, communication & management
Be part of a reputed organization, which provides opportunities to enhance and utilize my knowledge and skills
To serve global customers in IT industries and to enrich my work experience through quality deliverables internationally
Growth in the value chain by creative idea/solutions, sharing knowledge & mentoring peers
Overview
14
14
years of professional experience
1
1
Certification
Work History
Microsoft SQL Server DBA
TATA Consultancy Services
10.2017 - Current
- Project: Global customer for Fraud Investigation & Mitigation
- Roles and Responsibilities: Database Administrator
- Activity Performed:
- Migrating SQL Server databases from on-premises to AWS Cloud
- Complex architecture to setup AlwaysON between on-premises & AWS EC2 instances
- HA for Reporting purpose with Replication on top of AlwaysON
- New SQL Server Build and Preparing SQL instances as per Microsoft Best Practice
- DB Upgradation
- DB patching
- Monitoring the databases
- Performing daily health check
- Capacity Planning
- Database Access Management
- Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
- Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
- Troubleshoot SQL Server service outages as they occur.
- Deploy database change scripts as per Application requirement.
- Technical Challenge:
- Provide customer required solution for SQL server Replication over Multi AZ AlwaysON architecture. This was not only new but very complex architecture.
- AWS doesn’t support shared disk, so as per customer requirement have provided AlwaysON with multi-subnet failover architecture in place of SQL cluster
- Provide HA solution for Legacy applications which don’t support multi-subnet failover
Microsoft SQL Server DBA
Capgemini India Pvt. Ltd.
02.2013 - 09.2017
- Roles and Responsibilities: Database Administrator
- Installation, configuration and monitoring of SQL Servers
- Implementation of SQL Logins, Roles and Authentication modes as a part of security
- Implementation of Database Maintenance Plans and backup automation
- Recovery of database at the time of database crash
- SQL Server migration (including data, logins, jobs etc.)
- Data Migration (from one location to another)
- Solving Orphan user issues
- Verifying backups and ensuring backups happen on a constant basis
- Experience in Up-gradation/Migration from MS SQL Server to a higher version
- Implementation of High Availability such as Mirroring in SQL Server 2008 and Log-Shipping in SQL Server 2012
- Maintaining and troubleshooting Log-Shipping
- Implementation of Replication
- Experience in investigating and applying necessary SQL Server Database Service packs and security updates
- Specificity of working as a part of 24x7 support team in a multi-client environment
- Incident & Change Management
- Strong knowledge of Incident, Problem Change & Management (IPC)
- Resolving incident with proper justification (like Symptom, Cause & Action)
- Creating changes for team
- Working on Tasks & Stages
- Reporting
- Preparing & verifying backup report regularly
- Monthly incident report along with analysis of top issues to find out and reduce redundant incident count
- Monthly change management & problem management report
- Documentation
- Preparing standard Work Instruction after solving new issues for future use
- Working together with technical writer to standardized all work instructions and updating them regular basis
DBA (Consultant)
Electronics Corporation of India Limited
12.2011 - 02.2013
- Project Title: National Population Register (NPR)
- Client: RGI (Register General Of India)
- Technology: MYSQL 5.2, MSSQL 2008
- Responsibilities:
- Generate reports from the database using SQL
- Effective database maintenance
- Performance tuning of solutions for SQL queries and Database
- Responsible for managing multiple aspects of database administration
- Backup and restore operation using EXPORT/IMPORT
- Backup and Recovery strategies for MySQL database
Education
B.Tech - C.S.E
Techno India
Slatlake, W.B.U.T01.2011
Diploma - C.S.T
Kingston Polytechnic College
Kolkata01.2008
Secondary - undefined
W.B.S.E
01.2004
Skills
- Monitoring Tools:
- IDERA
- SentryOne
- Nagios
- Tivoli
- Ticketing Tools:
- Different version of BMC Remedy (76, 810, 8103, 88)
- CA SDM
- Service Now (SNOW)
- EARS
Accomplishments
- Implementation of effective monitoring on production servers to avoid critical situation
- Critically analyzed massive volume of auto incident and implemented proper monitoring values and pooling time which resulted time saving of 32hours/month
Certification
- ITIL V 3.0 Foundation Certificate in IT Service Management
- Administering Microsoft SQL Server 2012 /2014 Databases (70-462)
- SIX Sigma Yellow Belt
LANGUAGES KNOWN
English
Hindi
Bengali
Timeline
Microsoft SQL Server DBA
TATA Consultancy Services
10.2017 - Current
Microsoft SQL Server DBA
Capgemini India Pvt. Ltd.
02.2013 - 09.2017
DBA (Consultant)
Electronics Corporation of India Limited
12.2011 - 02.2013
B.Tech - C.S.E
Techno India
Diploma - C.S.T
Kingston Polytechnic College
Secondary - undefined
W.B.S.E
Profile
- A competent professional with 7 years 7 months of extensive IT experience.
- An effective communicator with excellent relationship building skills and proven ability to support & sustain a positive work environment towards accomplishment of organizational goals.
- Efficient analyst with strong problem solving skills.
- Self-motivated, quick learner, willingness to adapt new challenges & new technologies
- Self-confident, positive attitude & determined to achieve
- Highly motivated & excellent team player
- Ability to deal with pressure & utilization of presence of mind
- Effective communicator with excellent interpersonal & relationship management skills
Personal Skills
- Accurate: Careful, precise, and free from error.
- Ambitious: Full of ambition, strong desire "to do" something.
- Analytical: Employing analytical methods; separating things into their parts of elements
- Consistent: Constant to same principles, not changing
- Organized: Place things in working order
- Confident: Believe in and feel good about yourself
Other Details
- Present Address : Sri Nagar Janata Road, Ranaghat, Nadia, PIN-741201
- D.O.B : 02/02/1989
- Passport No : J1031434
Disclaimer
I hereby accept all this information is given in my best knowledge and acknowledgement.
AWARDS & RECOGNITION
PROJECT STAR (Excellence in Customer Delivery) for outstanding performance and lasting contribution Infra Service for H2 – 2014 at Capgemini India Pvt. Ltd.