Description
SUMMARY * 8 + Years of experience in Database Administration, Design, Development and Support of MS SQL Server 2014/2012/2008R2/2008/2005 in Production, Test, Development, Clustered and Azure environments. * Extensive experience in 24 7 production support on rotation basis. * Hands on experience in installation and configuring 2014/2012/2008R2/2008/2005 MS SQL Server versions with service packs and hot fixes on standalone, clustered servers and private/on premise cloud environments. * Experience in Date center migration and relocation. * Experience in RDBMS database design, performance tuning, optimization, backup and recovery and Security in SQL Server 2014/2012/2008R2/2008/2005. * Experience in Side by Side upgrades and in place upgrades using upgrade advisor/migration wizard from 2000200520082008R22012. * Experience in High Availability, Always on, Clustering, Replication, DB Mirroring, Log Shipping, Disaster Recovery Planning, Execution and Testing at remote side. * Experience in Database Backup, Recovery and Disaster Recovery Procedures (including dr/standby servers). Also experience in using 3rd party products like Litespeed, Red Gate, Idera products heavily saving space and processing times. * Have experience in Performance Tuning, Query Optimization, client/server connectivity, database consistency checks using DBCC, DMV and DMF utilities. * Good experience with Optimizing Code, Re-Indexing, Updating Statistics, Recompiling StoredProcedures and performing other maintenance tasks on issues like long running queries, processes. * Hands on experience with SQL Server constructing triggers, tables, indexes, user functions, views, user profiles, relational database models, data dictionaries, and data integrity. * Involved in huge data migrations, transfers using utilities like Data Transformation Services (DTS), integration service (SSIS), Bulk Copy Program (BCP) and Bulk Insert. * Adhering to coding standards and best practices for Sox Regulations and other audit requirements. * Involved in managing messages, Creating Jobs, Alerts, SQL Mail Agents and SSIS Packages and maintaining Agent security. BI (SSIS/SSRS/SSAS) EXPERIENCE * Involved in installation and administration of Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS). * Involved in designing SSIS /DTS packages to import and transform Data between databases and external data sources. * Experience in Extraction & Migration of data from Heterogeneous Data sources like Excel, MS Access, Oracle, DB2 to MS SQL server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities. * Involved in migrating DTS packages to SSIS packages and troubleshooting migrating issues. * Performed Backup and restore of SSAS cubes. * Involved in Reporting Services Administration by creating roles, users and providing security to reports. * Experienced in enterprise reporting in generating reports using Linked Reports, Sub Reports, Adhoc Reports, drill down reports, Drill through reports and filters, charts in SQL server reporting services. * Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle). * Excellent communication and interpersonal skills with ability to co-ordinate activities and work in a team environment to meet the deliverables.
Accomplishments
Highlights:
Keywords
