*Immediately available for any location. 8 years of experience and located Seattle, WA. Below is the Summary. *
Please email requirement to *ravi_soman...@tecnics.com <ravi_soman...@tecnics.com> *only *Sri* *SUMMARY:* · *8 years* of experience with the *32bit, 64-bit* Microsoft SQL SERVER in *Production, Development and Testing* in *Clustered and Stand-alone Server Environment*. · Experience installing *MS SQL SERVER 2000, 2005, 2008, 2008 R2, 2012* updating with hot fix and service packs. · Worked on the latest features in *SQL Server 2012 *like the *Always On* for *Database Mirroring* and *Fail over Clustering*. · Strong understanding of *RDBMS (Relational Database Management Systems) *concepts as well as *Data Modeling Concepts.* · Experienced Extensive experience in implementing *High availability *solutions like different *Replication models (Snapshot and Transactional), Log shipping, clustering *and* Mirroring *on physical and virtual machines*.* · Implemented *Side-by-Side Migration* of *MS SQL SERVER 2000/2005 to 2008*. · Experienced in using the *DMVS, DMFS, SP_PROCS, INFORMATION_SCHEMA, SYSTEM VIEWS *and* in-built GLOBAL VARIABLES* for instant analysis. · Expert in *Data Integrity*, *Performance Tuning, Query Optimization.* · Expert-level skills in Objects creation such as Tables, *Normalization*, *Indexes*, *Stored Procedures*, *Cursors*, *Triggers* and other SQL joins and query writing. · Worked on Installation and Upgrade of *IBM Optim* on both *Windows* and *Linux* environments. And also worked on UNIX environments. · Extensively worked on various versions of *IBM Optim* like *Optim 7.3.1, Optim 8.1, Optim 9.1*. · Performed *BCP, BULK INSERT,* imported and exported data from different data sources. · Experience in *Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases* . · Configured the *AWE* and *3 GB* switch for the *32 bit 2005 server* · Handled *Memory configurations* for SQL Server 2000 and 2005 on Windows 2003 server. · Experienced in SQL *Upgrades SQL 2000 to 2005 and 2005 to 2008 and 2008 to 2008R2* and building *SQL Clustering*. · Experience in analyzing *Locks, Dead Locks* and handling the *Isolation Level *and* Concurrency Effects.* · Extensively used the native tools such *index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor and Event viewer *for* performance* analysis. · Experienced in comprising *Performance Tuning, Query Optimization, Client/Server Connectivity, *and* Database health Check, Indexing, Updating Statistics.* · Experienced in *Backing up, restoring* the database manually and also by *scheduling the jobs *and* Maintenance Plans.* · Expert in analyzing the *execution plan* and *index management *for better *Query Optimization*. · Extensively worked on *Hot, Warm* and* Cold Backups;* *Security Management*, *Managing server and client Connections* · Configured *SMTP Server* for *Database Mail setup* and received *Alerts* for the *Threshold values*. · Skilled in auditing of database for *users transaction, login and database action and removing orphan users* · Experience with *Microsoft SQL Server Integration Services* or any comparable *ETL tool and Reporting tool with SQL Server Reporting Services* using *Business Intelligence Development Studio (BIDS).* · Experienced in *Migrating DTS 2000 packages to* *SSIS* packages in *2005* using *Migration Wizard.* · Skilled in use of SQL Server 2008 new features such as *Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).* · Experienced in using *SSIS* tools like *Import and Export Wizard*, *Package* *Installation*, *and SSIS Package Designer.* · Experienced in creating *deployment** utility *to deploy SSIS packages over Production, QA and Local systems. · *Knowledge of *Integration Services (*SSIS*)*, *Analysis Services (*SSAS*) and Reporting Services (*SSRS*) · Developing *SSIS* packages to automate SQL Server day to day monitoring tasks. · Experienced in using tools like *Bulk* *Copy* (BCP) and Data Transformation Services (*DTS*) and *SSIS Packages According *to the Specifications with MS SQL Server 2000/2005. · Experience in creating SQL Server Analysis projects (*SSAS*). · Expert in creating SQL Server Reports using *SSRS 2005 and 2008*. · Extensive experience in the development of Reports using *SQL* *Server* *2000*/*2005/2008* Reporting Services (*SSRS*) and Microsoft Access; developed *Custom Report* and different types of *Tabular Reports, Matrix Reports*, *and drilldown reports *in multiple formats using multi - dimensional objects. · Strong ability in *Scheduling *and* deploying* reports on Report manger. Thanks & Regards, *Ravi Somanchi* 713 429 5461 Tecnics Consulting, inc -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.
