Shown Vithayathil Email & Phone Number

Kochi, Kl, In

Kochi, Kerala, In

Kochi, Kerala, In

• Conducting the database performance review of the SQL Server/PostgreSQL Databases for business-critical applications.• Migrating the databases across servers, from SQL Server 2012/2014 to 2016/2017.• Upgrading the SQL Server/PostgreSQL across stand-alone/cluster servers in Production/Testing/DEV environments.• Expertise in SQL Server 2016/2014/2012 with technologies like Fail-over clustering, replication, and log shipping.• Setting up the production database servers ready by implementing the production deployment checklist which hardens the security both at the Instance level and the database level.• Identifying all the Database Design issues by doing a full and thorough database review.• Diagnosing and Resolving Deadlocks, blocking, Latch contention and timeouts.• Identifying and resolving the performance issues using the SQL Server Execution Plan, SQL Server profiler, and Dynamic Management views (DMV).• Reviewing the physical and logical database design, thus promoting the reliability of database design by ensuring appropriate referential data integrity and with the usage of appropriate data types. • Checking the Database Health by using DBCC Commands and Dynamic Management views (DMV) • Creating custom scripts using DMVs and system tables for efficient database management.• Identifying unused indexes and dropping the same and create all the missing indexes.• Scheduling regular Index Rebuild/Reorganization for reducing Index fragmentation.• Setting up regular Update Statistics by scheduling them across all the databases. • Designing the database Backup and restoration strategy and monitor those backups on a regular basis to ensure that they are being performed on a regular basis. • Troubleshooting issues that arises daily and fix them by monitoring the event viewer, SQL Server Error Logs, and email alerts.• Setting proper Fill-factor for the indexes to avoid page splits which could leads to fragmentation.

• Leading the database control team who are responsible for the database design, performing tuning and database administration.• Conducting the Performance Review of the SQL Server Databases for business critical applications with the Senior Leadership team.• Identifying all the Database Design issues by doing a full and thorough database review.• Expertise in Diagnosing and Resolving Deadlocks, blocking, Latch contention and timeouts.• Proficient in identifying performance issues using the SQL Server Execution Plan, SQL Server profiler, Dynamic Management views (DMV) and SQL Server Statistics.• Reviewing the physical and logical database design, thus promoting the reliability of database design by ensuring appropriate referential data integrity and with the usage of appropriate data types. • Checking the Database Health by using DBCC Commands and Dynamic Management views (DMV) • Creating custom scripts using DMVs and system tables for efficient database management.• Implementing Table and Index Partitioning using function/scheme for scaling up / out.• Identify unused indexes and dropping the same and create all the missing indexes.• Scheduling regular Index Rebuild/Reorganization for reducing Index fragmentation.• Setting proper Fill-factor for the indexes to avoid page splits which could leads to fragmentation.• Evaluating data modeling, database backup and recovery strategies and thus making recommendations. • Establishing standards for SQL installations, maintenance, performance tuning, and coding.• Providing training, mentoring, and feedback to team members to enhance communication and performance.• Designing and implementing complex database architecture.• Leader in major activities which include advanced performance tuning, database design, and capacity planning.• Performing the Hardening of SQL Server Instances in a secured environment.

Pune, Maharashtra, In

• Installation, Administration and Maintenance of SQL Server Instances. • Performing the Hardening of SQL Server Instances in a secured environment.• Setting up of the Test, Development, Staging and Production Environments. • Creating users, roles, schemas and assign permissions based on the level of database access the user would need. • Designing the database Backup and restoration strategy, and monitor those backups on a regular basis to ensure that they are being performed on a regular basis. • Recovering the databases to a specific point of time, as per the requests.• Migrating databases from Pervasive to SQL Server 2012.• Troubleshooting issues that arises on a daily basis and fix them by monitoring the event viewer, SQL Server Error Logs, and email alerts.• Monitoring and performance tuning at the Server Level, Database level and also by query tuning.• Creating and maintaining Indexes, monitoring CPU usage and Disk I/O activity.• Leading the offshore team and co-ordinating with the client on a daily basis.

Pune, Maharashtra, In

* Installation, Configuration, Administration, Database Design,Development,Performance Tuning,Optimization, Capacity planning and maintenance of SQL Server 2008/2005/2000.* Configuration, administration, and maintenance of IIS 7.0/6.0/5.0* Database Migration from Oracle to SQL Server 2008/2005.* Continuity of Business (COB) testing.* Migrated Production servers.* Re-building of the Virtual Servers.* Opened ports for Off shoring the applications.* Installation of Single Sign On(Siteminder 6.0) on development, UAT and Production environments

Pune, Maharashtra, In

* Administered and Developed Procedures, Functions, Triggers, Queries, Tables, Reports, etc. in SQL Server 2005/2000.* Involved in the performance tuning and the optimization of complex SQL queries, procedures, migrated Data’s from Files to the Database.* Created and managed users, roles and groups and handled database security. * Involved in the System study, analysis and Design.* Understanding of the Requirements at the Database level.* Participated in code review sessions with development and management team members. * Assisted users in developing sophisticated reports; Implementation of unit and system tests; Drafting of the functional specification analysis and documentation.* Extensively used Database replication* Followed and established standard operating procedures like Document review, Test Plan and Integration of system

* Assisted in the design, coding, testing, and implementation of databases by applying the relational database management system concepts.* Designed and implemented Views, stored procedures and triggers.* Used SQL Profiler to tune the performance of long running queries and stored procedures.* Designed DTS to extract external data source. * Performed Database optimization and normalization.* Performed and scheduled various DBA administration tasks (Backup, Restore database, Automated the DTS Package, Schedule the various applications, Retrieve logs, create users, monitor performance and run database consistency checker, Design and implementation of database maintenance plan.)* Administered and Developed Procedures, Functions, Triggers, Queries, Tables, Reports, etc. in SQL Server 2000.* Worked Extensively on DTS Packages.* Created technical design documentation for alterations to current state systems and future project designs.

Mca, Computer Applications

Bsc, Computer Science

Education record