Hi,
Kindly find detail summary of our Certified Sr. SQL DBA available for project all over US ….You can call @ 732 649 1563 Or catch me Live on : venuk1983(Ymail/ Gtalk)……. *Name : S K* *Location : NY* *Relocation : Open* *Available : Immediately* *Comm Skills: Excellent* *Face-2- Face : Yes* *SUMMARY:* ● 8+ years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server 2012/2008/2005. ● Experience with Multi- Servers and Multi-Terabyte Databases design for *Very Large Databases* ● Strong experience in Business Intelligence (BI) using Visual Studio 2008/2005. ● Experience in primary data analysis, mapping and migration from Oracle to SQL server ● Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and *SQL Server clustering, log shipping and Mirroring*. ● Created, Built and deployed successfully dynamic *SSIS packages* into SQL Server 2008/2005 databases and scheduled them according to requirements. ● Extracted, Transformed and Loaded data in Data warehousing using SSIS packages. ● Involved in migrating* DTS packages* from SQL Server 2000 to *SSIS packages* in SQL Server 2008/2005 database. ● Experience in *Migration* of Data from Excel, Flat file using* DTS, SSIS* and other *ETL Tools*. ● Experience in working with Reporting tools like *MS SQL Server Reporting service *(SSRS)*,* Report Builder and BIDS ● *Rendered* reports in CSV, PDF, XML and Delivered reports by file share and E-mail according to schedule. ● Created, designed and deployed *Tabular, Matrix, Chart*, *Drill-down *and *Ad-Hoc* reports on report server. ● Experience in Database Design activities including *Data Files *and* File group organization, Capacity Planning, Data Partitioning *and* Data Normalization.* ● Resolved issues with *Indexes, Blocking *and* locking issues* to remove the performance bottlenecks. ● Database design & administration experience on *SQL Azure*, MS-SQL Server 7/2000/2005, ● Proficiency and Expertise in SQL Server *Replication*, *Backup/Recovery*, *Disaster recovery* *and* *planning*. ● *Rebuild online index* and worked with Dynamic Management Views *(DMV*) for improving query performance. ● Created recursive queries using *Common Table Expression* (CTE). ● Performed *database consistency* checks at regular intervals. ● Experience in *Change Data Capture* (CDC)*, Change Tracking *(CT) in SQL server 2008. ● Experience in Creating complex *Views, Stores Procedures, DDL/DML Triggers *and* User-Defined Functions* to implement Business Logic and Data Protection. ● Good hands-on with creating *Partitioned Tables *and* Partitioned Views*. ● Creating and managing* schema objects* such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Technical Requirements. ● Experience in migration of data using *BCP* Utility*, Bulk Insert * command*, SSIS *and* DTS Packages, Import/Export Wizard *and* Copy Database Wizard.* ● Knowledge in SSAS in generating cubes. ● Expert in *Query Tuning *and activities including *Updating Statistics, Re-building *and* Re-organizing Indexes.* ● *Monitoring *and* optimizing the performance* of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views. ● Experience in business *Requirement Analysis* and conversion to database design and good knowledge on *System Development Life Cycle* (SDLC). *TECHNICAL SKILLS:* *Languages* T-SQL, PL/SQL, VB.Net, HTML, C *Services* Database Engine, SSIS, SSRS(Visual Studio 2008, 2005) *RDBMS* MS SQL Server 2012 2008, 2005, 2000, 7.0, MS Access databases,DB2,Oracle 10 g,11g *Reporting Tools* BIDS, Report Builder 2.0, Report Builder 3.0 *Modeling Tools* Microsoft Visio, SQL Diagrams, ERWIN 4.1, SQL Server Enterprise Manager *Operating Systems* Windows 2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5. *Other Tools* DTA, SQL Profiler, DTS XCHANGE, Citrix ,Diagnostic Manager, SQL Litespeed *CERTIFICATIONS:* *Microsoft SQL Server 2008, Implementation and Maintenance* *Microsoft SQL Server 2005, Implementation and Maintenance* *Kindly add **[email protected]* <[email protected]>* to your mailing list..* *Regards, Venu K Nixsol Inc* *Tel :(732)-649-1563* *Fax :(732)-909-2424 * *[email protected]* <[email protected]> (Y) : [email protected] *(Best way to reach me is via Email)* [image: Description: View my profile on LinkedIn] <http://www.linkedin.com/in/venukbdm> *Think Green:* *Please consider the environment before printing this e-mail.*
