Sanjivkumar Naykodi

About Sanjivkumar Naykodi

Experienced Senior Database Administrator with a demonstrated history of working in the…

Experience

1. Sr Database Administrator

   Wipro

   Mar 2010 — Present · Irving, TX, US

   Installation, Administration and Maintenance of SQL Server Instances SQL server 2005/2008/R2/2012/2014/2016. Coordinating with the Systems Administration team, install and maintain application software and systems that integrate with database systems. Updating database systems by reviewing, planning, testing and installing database security patches and service packs. Worked in Active Active, Active Passive Cluster environment as a High availability solution. Configuring, Monitoring and Troubleshooting LOG SHIPPING and DB MIRRORING, Always ON. Supporting around Servers including PROD and Non-PROD servers, maximum database size is of 9 TB. Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc. Working with development and systems teams to perform application and database tuning. Conducting every six months/yearly Cob tests to make sure the DR is running in sync with PROD. Migrating Databases from SQL Server 2005 to SQL Server 2008. Setup Test, Dev, Staging and Production Environments. Setup, test and maintain business continuity/disaster recovery infrastructure database and applications. Design, document, and promote security \"best practices\", policies, standards and protocols. Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used. Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle. Migrating application code and objects from development/test environments to production.

Education

• Savitribai Phule Pune University

  Master of Computer Applications - MCA, Computer Science

  2002 — 2005

Skills

• Disaster Recovery
• Unix
• Data Warehousing
• Windows Server
• Microsoft Sql Server
• Databases
• Pl/Sql
• Performance Tuning
• Data Migration
• Shell Scripting
• Sql
• Software Development Life Cycle (Sdlc)
• Database Design
• Requirements Analysis
• Database Administration