PROFESSIONAL EXPERIENCE

• Migrated to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN

Environment.

• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Extensively worked on SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS and SQL Server Analysis Services SSAS .
• Used DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuild / monitoring the indexes at regular intervals for better performance.
• Recovered the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Managed multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels 1 10.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor DTA .
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression CTE .
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters HP servers in enterprise Data Centers .

Environment : SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Erwin, Microsoft Visio, SFTP, SQL Server Integration Services, SSRS and Microsoft Reporting Services.

• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's Entity Relationship ER diagrams.
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferring the data ETL to Data warehouse Informatica by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Prepared the project management and technical documentation.
• Solving the Bugs Reflected by the Testing team.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment : SQL Server 2012/2008/2005, Oracle 11g, .Net Framework 3.5/4.0, C .Net, Asp.Net2.0, JavaScript, VSS, , Windows 2008 Server, MS TFS, MS-Access, SPSS, Erwin, Visio Professional, DB2

• Implemented of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Deployed new code base release to UAT and Production Environments.
• Performed SQL Server service pack and Windows Service pack upgrades.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Recovering the databases from backup in disasters.
• Analyzed long running slow queries and tune the same to optimize application and system performance.

Environment : SQL Server 2005, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio, Enterprise Manager, SQL Query Analyzer, SQL Profiler.

• Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services MSCS from Hardware inventory to test environment.
• Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005.
• Performed SQL Server service pack and Windows Service pack upgrades.
• Resolved and tweaked memory pressures caused during product release.
• Worked with customers on Application rollouts and server migrations.
• Troubleshoot performance problems and fine-tuning of databases.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Designed and created databases, tables, views, store procedures and triggers.

Environment : SQL Server 2005, Windows 2003 Server, MSE, VSS and MS Access VBA

• Monitoring the server for High availability of the servers.
• Participated in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Day-to-day administration of live SQL Servers.
• Designed and implemented Security policy for SQL Servers.
• Used Stored Procedures, DTS packages, BCP for updating Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.
• Execute procedures to accomplish short-term business goals.
• Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Using database level triggers code for database consistency, integrity and security.
• Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis.

Environment : SQL Server 2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility

• Involved in complete System Development Life Cycle SDLC stages as requirement gathering analysis, some part of estimation, technical Documentation, Modeling and design, Execution, integration and testing.
• Involved in the development of the projects based on Digital Signature, E-Commerce and activation tools.
• Developed Components for all business logic in C .NET. Designed the database and developed Stored Procedures and views
• Wrote SQL statements for querying database and integrating with components.
• DTS and data administration using SQL Server and Reporting using SSRS.

Environment : C .NET, ASP.NET, ADO.NET, SQL Server 2005, IIS, XML Web Services, Crystal Reports, Visual SourceSafe, JavaScript, CSS/XML, DTS, Ms Project 2007, Ms Visio Professional 2003

• Involved in the entire System study, analysis and design.
• Created Entity relationship diagrams, functional relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Created SQL tables with referential integrity and developed queries using SQL.
• Involved in writing Triggers which internally called procedures and functions.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.

Environment : Progress 4GL 11.0, JavaScript, Soniq MQ, Oracle 9i, MFG/PRO, CSS, XAML, .NET

• Involved in the entire System study, analysis and design.
• Created Entity relationship diagrams, functional relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Involved in the logical design of different projects, desktop based to client-server systems both online and offline.
• Guide and mentor for the graduate academic projects.

Environment : MS SQL 2000/2005, Windows 2000, T-SQL. VB/C .NET, JAVA, Oracle 9i