Sql Server Maintenance

SUMMARY OF VIHARI (DW/BI/SQL Developer)

EXPERIENCE SUMMARY

• Has been working as a Business Intelligence Developer and SQL Support Engineer, with 2 years of Information Technology experience including Database Administration, Develop- ment, Configuration Management, Analysis, Design, testing, Integration and deployment with MS SQL Server 2005/2008/2008 R2

• Extensive experience in migrating and upgrading SQL Server from 7.0.to 2000, 2000 to 2005 and 2005 to 2008/R2.

• Experience in designing ELT (SSIS) process to extract data from other data sources like TERADATA, MSSQL, Oracle, XML, Flat Files, and EXCEL.

• Experience in usage of performance monitoring and troubleshooting, extensive use of pro- filer, Performance monitor, extended stored procedure, DBCC and DMVs for troubleshoot- ing the performance issues.

• Extensive experience in support and maintenance of real time production databases.

• Database Development (Database Design, T-SQL, Linked Server, DB Mail, SQL Mail, E-R diagram, CDC and new SQL Server 2008R2 features)

• Extensive experience in design, development and administration of SQL Server databases.

• Experience in SSRS design and deployment of Parameterized, Drilldown, Drill through, Sub, Linked, Snapshot, Cached, and Ad hoc Reports

• Performance and Tuning of the SQL Server, databases and Procedures

• Very good experience in SSIS, SSRS,SSAS development using BIDS(Business Intelligence Studio

• Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user de- fined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.

• A quick learner that strives for new technical knowledge ability to communicate with all levels of corporate personnel

• Has the motivation to take independent responsibility as well as ability to contribute and be a productive team member.

EDUCATION Masters in Computer Science (MS)

UNIVERSITY University of Illinois, Illinois

EDUCATION Bachelor of Technology (B Tech)

UNIVERSITY Jawaharlal Technological University, Hyderabad (India) TECHNICAL SKILLS:

*****.******@*****.*** 901-***-****

LANGUAGE JAVA

SOFTWARE TOOLS TERADATA SQL Assistant,VSS 6.0

RDBMS MS SQL Server 2005/2008R2, MS Access 2003/2007/2013, TERA- DATA 13.0

WORK EXPERIENCE

Tekriti Software Private Limited Aug’ 13 to July’ 14 Domain: Marketing Domain, Jr.SQL Server BI Developer Description:

PRISM is a worldwide content management application that serves to aggregate and syndicate HP’s product content across different business units and geographies. This project serves to reduce to- tal cost of publishing for various product data publishers in HP. It acts as a single source of reposi- tory for storing the content of all the HP Products worldwide. A critical aspect of content manage- ment is the ability to manage versions of content as it evolves. PRISM receives altered and edited contents or versions of products as input called feed. The feeds are received from many other applications. Various processes are scheduled to run on a timely basis which will process the required input feed. These processes are scheduled as Job/Process in TIDAL. Roles & Responsibilities:

• Developing MACROS to generate the reports using SSRS from TERADATA(EDW)

• Developing ETL MACROS to process the data from multiple sources

• Creating Stored Procedures with required parameters based on the report requirements

• Monitoring and Performing health check with all Reporting production Servers.

• Monitoring and Maintenance of SSIS/ETL critical jobs,

• Weekly/Monthly maintenance window patches installation/test support for all production servers

• Weekly maintenance window support with all production servers

• Setting up new properties and users for reports access setup

• Monitor and maintain SQL Servers in Production, QA, Test and Development Environments

• Create/modify; tune stored procedures, triggers, functions, indexes, views, and schemas.

• Identify, diagnose, and resolve database application deadlocks on production systems.

• Create/modify; tune TERADATA MACROS, stored procedures, triggers, functions, indexes, views, and schemas.

• Identify, diagnose, and resolve database application deadlocks on production systems.

• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open RT tickets for support team to remedy and troubleshoot hardware/SAN drive issues

• Supporting and Developing of MACROS,SSRS 2008 R2 reports and SSIS packages

• Working on SQL Server Reporting Services to provide the RAS(Risk Assessment) metrics to Microsoft using MBSA tool

• Responsible to releases from development to test to production environments

• Providing weekly and monthly status reports to higher management

• Onsite & Offshore co-ordination to lead the team & provide the quality deliverables on time REPORTING TOOLS BIDS/SSRS 2005/2008 R2

TOOLS QTP, Quality Center, Test Director, Load Runner, Win Runner, JU- NIT, NUNIT, Foglight, MOM 2005,DPM, STSADM, Ignite 8.0,Crypt- O,LiteSpeed, Quest Tools,MassTransit, TeleScope ROBOCOPY, COGNOS 8.0/8.1,Sales Force

OS UNIX, WINDOWS NT, WINDOWS 2003/2008 R2, WINDOWS XP, OS/ 2, LINUX,VISTA

Scripting VBScript, Perl, Windows

2

Environment: UNIX, Windows Server 2008 R2, Visual Studio 2008, MS SQL SERVER 2008 R2,TERADATA SQL Assistant,SSIS,SSRS,BIDS,.NET Framework 3.5, Visual Studio .NET, C#, AS- P.NET,ADO.NET

National Institute for Micro, Small and Medium Enterprises June 12 to Aug’ 13 Domain: Rating Domain, Jr.SQL Server BI Developer

Description:

The Entertainment Software Rating Board (ESRB) ratings are designed to provide consumers, especially parents, with concise, impartial guidance about the age-appropriateness and content of video games and mobile apps which would help in making informed decision about the ones they deem suitable for their children and family.

Roles & Responsibilities:

• Monitoring and Performing health check with all production Servers.

• Monitoring and Maintenance of SSIS/ETL critical jobs,

• Weekly maintenance window support with all production servers

• Setting up new properties and users for reports access setup

• Developed .NET service to handle legacy systems XML records

• Creating/Modifying cubes on SQL server 2008 using SSAS by adding new dimensions from new views to existing cubes

• Monitor and maintain SQL Servers in Production, QA, Test and Development Environments

• Create/modify; tune stored procedures, triggers, functions, indexes, views, and schemas.

• Identify, diagnose, and resolve database application deadlocks on production systems.

• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open incident tickets for IBM to remedy and troubleshoot hardware/SAN drive issues

• Data Center monitoring, backup, archiving, upgrades and Implementation of all servers.

• Supporting and Developing of SSRS 2008 reports and SSIS packages, as well upgrades of previous version of SSIS packages.

• Working on SQL Server Reporting Services to provide revenue management reports

• Responsible to releases from development to test to production environments

• Providing weekly and monthly status reports

Environment: UNIX, Windows Server 2008 R2, Visual Studio 2008, MS SQL SERVER 2008 R2,TERADATA SQL Assistant,SSIS,SSRS,BIDS,.NET Framework 3.5, Visual Studio .NET, C#, AS- P.NET,ADO.NET

3

Contact this candidate