SUMMARY

• 8 years of experience in Data Architecture, Database Development and Administration, Designing and Implementation of OLTP & DWBI systems.
• Currently working with Confidential on a project to migrate the entire system to SQL 2012. Responsible on designing, planning and implementing the migration along with implementing Always On high availability.
• Earlier engaged with Confidential team holds the mission for delivering millions of transactions with Terabytes of Data. Responsible for designing & developing the transactional & reporting systems.
• In a 8 years career with MindTree and UST Global serving multiple clients, I have participated in numerous engagements involving most aspects of the Microsoft SQL Server and its many components involving
• Design and Implementation of large - scale databases
• Database Performance Tuning and Issue Resolution
• Business Intelligence Data Architecture, Design and Implementation
• Scoping and leading Proof of Concepts
• Solution implementation Architect/Technical Lead
• Experience with multiple versions of SQL Server from
• ETL (Extract, Transform and Load) Applications Design and Implementation.
• Transact-SQL Programming and MDX Programming
• Design and implementation of large-scale Dimensional and OLAP databases.
• Reliable Integrated Failover Detection with SQL Server Always on.

TECHNICAL SKILLS

RDBMS: SQL Server 2014/2012/2008 R 2/2008/2005/2000

OS: Windows 95/ 98/NT/ 2000/2003/2008/2012// XP/Vista/7

Other Tools: Toad for SQL server, SCOM, MS-Office, SQL Developer, Eclipse 3.2, Dreamweaver, SQL Enterprise Manager, Query Analyzer, Microsoft Excel, Salesforce, Track studio, StarTeam, HP Service manager, MS Visio, MS-Access, Crystal Reports, RedGate

Data Warehousing: Informatica 7.1/8.1, Cognos 7/8

Release management tool: Stratavia, DB Launch

SQL Server Tools: SSIS, SSRS, Import Export Data, BIDS Studio, Report Builder, SQL Profiler, OLAP

OLAP and Migration Tools: MS SQL Server Analysis Services, TSQL, SSMA

Languages: T-SQL, PL and SQL, HTML, XML, ColdFusion, PowerShell

Version Control: SVN, MKS

PROFESSIONAL EXPERIENCE

Technical Lead

Confidential

Responsibilities:

• Responsible to Plan and implement the Migration project. Setting up all the Prod,Dev,UAT,QA environments.
• Setting up Always On in the dev environment and test out all the scenarios.
• Collecting information by interacting with most of the application team and the respective vendor.
• DR planning and setting up health check in all the SQL Servers.
• Implementing the SSL connection encryption and transparent data encryption for the most critical server and databases.
• Setting up Always On in the PROD environment as part of SQL migration

Associate DBA

Confidential

Responsibilities:

• Major works covered as a DBA in Confidential are Net backup - Database Backup/Restore, Initiating Net backup manually, Net Backup Failures, Working on SM7, Working on Email Alerts, Database Log files growth Issue, Running SQL Scripts, SQL Server Dashboard - Confidential, SQL Server Dashboard - PBC, Next Gen Health Check Report, Fixing Orphan Users, Working on Star Team, Handling Space Issues, Handling Space Issues (C Drive), Hold Email Alerts Monitoring temporarily, Database Build, Decommissioning, Uninstalling an instance, Repository Update, Manual Database Backup/Restore, Restore to a different Machine via Net backup, Skipping databases from Net Backup, Control-M Backup Failures, Control-M Monitoring job Failures, Add/Remove Control-M Backup jobs, Add/Remove Control-M Monitoring jobs, Fixing TempDB Growth, Patching, Uninstalling SSRS alone, Database Migration (DB Move), SQL Agent Jobs, Add/Remove an instance from SCOM, Locating the Alert in SCOM, Offshore Assigned Star Team Pending Report, Putting an instance in Maintenance mode from SCOM, High availability options - Log shipping, Mirroring, Replication, SQL clustering and Always On, fixing performance issue and Query optimization.
• Has got hands on experience in SQL DR activities.
• Has been working on SSRS for creating a number of reports for the client which helps to optimize the day to day work of DBAs.
• Designed and implemented tables, functions, stored procedures and triggers in SQL Server. Wrote the SQL queries, Stored Procedures, Functions, and Views. Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions, other T- SQL statements for various applications and triggers to keep track of changes to the fields of tables when changes are made. Experience in writing complex SQL queries involving multiple tables inner and outer joins. Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches. Has got experience in complex Query tuning.
• Attends calls with client on Tuesdays and Wednesdays to discuss the issues which has occurred on a weekly basis and to get new updates in the upcoming projects and scheduled activities
• Provided daily reports for the client on the space and backup failures of the DB’s in different servers

SENIOR SOFTWARE ENGINEER

Confidential

Responsibilities:

• Worked as the SQL developer and only support personal for the Confidential client from offshore.
• Daily track studio projects on SQL developments and has worked on Stored procedures, Views and other SQL queries
• Completed all the projects on time and delivered to the client
• Had to take care of all the SQL related issue which were occurring in the offshore team
• Had daily call with the client on different projects and improvements to add new features

SOFTWARE ENGINEER

Confidential

Responsibilities:

• Resolved SEV 2, SEV 3 & SEV 4 production tickets on a daily basis
• Always ensured strict adherence to SLA defined by the client for production ticket resolution.
• Resolution of tickets involved analyzing stored procedures, modifying them, developing medium and complex SQL queries.
• Provide details to application support manager to create bug projects in TS (Track Studio) for tickets requiring code fix
• Attend daily production status call with manager of application support
• Provided solutions & recommendations to fix recurring production issues.

SOFTWARE ENGINEER

Confidential

Responsibilities:

• Worked as Cold fusion developer for enhancement project
• Analyzed project spec provided by the client in TS (Track Studio)
• Had worked extensively on stored procedures (analyzing & modifying) and SQL queries to in corporate new features as part of enhancement project
• Perform unit testing on code changes done as part of enhancement project
• Attended daily status update calls with Team leads (Client).
• Ensured compliance on timely delivery of projects with quality.

SOFTWARE ENGINEER

Confidential

Responsibilities:

• Analyzing the application
• Documenting the application in terms of process flow, functionality, code analysis and even stored procedures

SOFTWARE ENGINEER

Confidential

Responsibilities:

• Got training in Informatica which rated as one of the most successful ETL tool product.
• The training had covered the creation of repositories, the major ETL transformations like Aggregator Transformation, Stored Procedure Transformation, Joiner Transformation etc and how to move data from OLTP to OLAP system using the different transformations.
• Had been trained in IBM Cognos 8 BI Reporting tool and created a number a reports as a part of the training