Praful

 Praful More Mumbai, India Contact No: - - Email- ­­­­­­­­­­­­­ Summary: 15 years of IT experience in administration and development of MS SQL Server 2005 involving analysis, design, development, implementation, testing and maintenance implementation, troubleshooting and performance tuning. Excellent backend skills in creating SQL objects like tables, stored procedures, views, indexes, triggers, rules, defaults, user defined data types and functions. Very good T-SQL programming skills. Experience in query optimization & performance tuning. Used SQL profiler, execution plan and DBCC commands. Running the weekly indexing and integrity checks. Performing monthly security audits on all logins and users to SQL Server. Implemented a well-planned database backup and disaster recovery procedures. Implementation and maintenance of security integrity controls (logins/roles) of applications. Hands on experience in replication, maintaining & tuning various database on SQL Server 2005. Good experience on SQL Server Administration skills including user authorizations, database creation. Good documentation skills, excellent communication, presentation and interpersonal skills, strong troubleshooting and organizational skill. Monitoring the SQL Error logs for any errors that may occurred overnight. Monitoring available physical Disk space (stored procedure). Monitoring the Event Viewer, the jobs for failed completion, backups and log sizes and checking for active or blocked transactions. Created database objects like tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions for this project. Scheduled the jobs to do these tasks periodically, provided supports for production, development & test servers of MSSQL servers. Worked with developers to tune the SQL queries using SQL profiler. Replication, database performance tuning. Platform: SQL Server 2008,T-SQL, Visual Source Safe 6.0,Windows-, Windows XP,SQL Server Business Intelligence Development Studio. Created database objects like tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions for this project. Scheduled the jobs to do these tasks periodically, provided supports for production, development & test servers of MSSQL servers. Worked with developers to tune the SQL queries using SQL profiler. Replication, database performance tuning. Platform: SQL Server 2005,T-SQL, Visual Source Safe 6.0,Windows-, Windows XP,SQL Server Business Intelligence Development Studio. Responsible for installation and configuration of SQL server 2005 database. Involved in data modeling for the application and created ER diagram using Microsoft office visio. Created database objects like tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions for this project. Scheduled the jobs to do these tasks periodically; provided supports for production, development & test servers of MSSQL servers. Worked with developers to tune the SQL queries using SQL profiler. Setup database maintenance plans for new databases. Replication, database performance tuning. Platform: SQL Server 2005,T-SQL, Visual Source Safe 6.0,Windows-, Windows XP,SQL Server Business Intelligence Development Studio. Involved in installation and configuration of SQL server 2005. Replication, database performance tuning. Optimize the SQL Queries for better performance. Identified complex issues which existed with the applications supported and resolved them. Run a SQL profiler for capturing the SQL Server activities. Setup database maintenance plans for new databases. Partly participated in system study and analysis of software applications. Troubleshoot the issues of end users and developers. Platform: SQL Server 2005, Windows 2000, Windows XP Replication, database performance tuning.Optimize the SQL queries for better performance. Using SQL profiler for capturing the SQL Server activities. Setup database maintenance plans for new databases. Platform: SQL Server 2005, Windows 2000, Windows XP Software Skills: Software/Languages : T-SQL, SSIS,SSRS Database Technology : Microsoft SQL Server GUI Tools : Crystal Report 10, SQL Server 2005 management studio, SQL Server Business Intelligence Development Studio