TECHNICAL Expertise:

• DBA : Database Administration of MS SQL Server 2012, 2008, 2005
• ETL Tools : SSAS, SSIS using BIDS, Oracle Data Integrator Business Intelligence : MSBI Suite SSIS, SSRS, SSAS , Databases : SQL Server 2012/2008/2005, Oracle 11g/10g/9i , MySQL, MS Access Languages : SQL, PL/SQL, .NET C , C Web Technologies : HTML, DHTML, XML, XAML, XSL/XSLT Design : Erwin, Visio, Aqua Studio, Enterprise Architect, MySQL workbench, SQL Developer
• Data Modeler, SQL Server Diagram Editor, TOAD Data Modeler, Visual Paradigm
• Tools : MS Office Suite, TOAD, SQL Plus, SQL Developer, Autosys r11.x, SQL Developer Data Modeler
• Operating Systems : Windows 2008/2003 Advanced Server, NT Windows 9x, Linux
• Version Control : Team Foundation Server, Visual Source Safe, SVN
• Network Topologies : TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

• Migrated SQL server 2008 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 and SQL Server Reporting Services SSRS .
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering 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.
• 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 .
• Expert in implementing the snapshot isolation and DDL triggers.
• 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.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Prepared the project management and technical documentation.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• 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.
• To set up SQL Server configuration settings for better server management.
• Monitoring the servers using Idera third party software.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

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

• Database Administrator, Database Programming.
• Implementation 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.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Worked with different upstream team for downloading ETL MART data.
• 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.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment : SQL Server 2005, SQL Server 2000, 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.
• Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
• 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.
• Expertise in designing databases and capacity planning.
• Rebuilding the indexes at regular intervals for better performance.
• 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.
• Transferring the data ETL to Data ware house by SQL Server 2005 Integration Services.
• Rebuilding the indexes at regular intervals for better performance.
• 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 and SQL Server 2000, Windows 2003/2000 Server, LiteSpeed 4.5, MSE, VSS and Password Updater.

• Monitoring the server for High availability of the servers.
• Solving the request raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Meet the SLA Service Level Agreement established.
• 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.
• Deploying monitoring tools like Sitescope and spot light.
• Table partitioning to improve I/O access.
• 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, MOM, MSE and Sitescope.

• 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.
• Developing Components for all business logic in C .NET. Designed the database and developed Stored Procedures and views
• Creation of SQL statements for querying database and integrating with components.
• Documenting the work and testing the application online and offline
• For Version Controlling, Visual Source Safe VSS was used.
• Supporting end users on technology know-how.
• DTS and data administration using SQL Server and Reporting using SSRS.

Environment : C .NET, ASP.NET, ADO.NET, Oracle 9i/10g, 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. Client/Server and web application.
• Involved in the analysis of the systems for supply-chain management for MRP purposes.
• 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.
• Supported technical teams involved with SQL issues and operations.
• Involved in the maintenance of the database.

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