Profile Summary:

• 9years of experience in SQL Server Database Administration/ Development using MS SQL Server Management Studio2012, 2008 R2, Management Studio 2005, Enterprise Manager 2000.
• Expert with Database Administration backup/recovery methodologies and procedures on a Windows/SQL Server platform.
• As well as expert in Implementing Database Mirroring and Log shipping with SQL server 2012, 2008 R2, 2005
• Strong knowledge in implementing different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server 2012, SQL Server 2008R2, 2005in OLTP environments.
• Experience with Database Backup- full, differential, log, etc Recovery and Disaster recovery procedures.
• Immense experience in the manual fail over fail back process to make the DRserver as the active server.
• Very strong implementation of Microsoft Business Intelligence BI platforms including SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS and Microsoft office SharePoint Server 8 in SQL Server 2005/2008.
• Significant experience in ETL tool Informatica Power Center/ Power Mart in analyzing, designing and developing ETL processes for Data Warehousing and Data Migration projects.
• Using SQL server reporting services SSRS delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources Proficiency in SSRS for reporting services, SSAS data cube and data ware house. Extracting, Transforming and Loading ETL data using SSIS, DTS Import/Export utility, BCP and DTS Packages.
• Experience in monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Expert Knowledge of Integration Services SSIS , Analysis Services SSAS , Reporting Services SSRS .
• Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment.
• ETL implementation using SQL Server Integration Services SSIS .
• Expert in using tools like Bulk Copy BCP , Data Transformation Services DTS in SSIS.
• Experiencing in creating reports using cubes.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Experience in data Integrity in order to ensure the quality of the data in database.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Created dimensions using SQL Server Analysis Services SSAS .
• Experience in Supporting Large Databases, Troubleshooting and documenting root cause analysis.
• Experience in MS SQL Server performance tuning along with SQL Profiler, client/server connectivity, query optimization, Database Maintenance plans, Database Consistency Checker using DBCC.
• Developing reports on SQL Server 2000/2005 . Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server Manager.
• Experience in creating the MDX cubes and dimensions and understanding of SSAS, OLAP cube and Architecture.
• Experience in installing Service Packs, patches and hotfix for SQL Server and OS.
• Experience in installing and configuration of MS SQL Server and databases in clustered and un-clustered environments.
• Ensure the data validity, integrity etc during the migration to production.
• Keep update with new feature, service pack, version, technology etc for SQL Database and Management.
• Ensure the Security of SQL Server, backup and its restoration regularly in order to keep the database free from any kind of missing, loss, inaccessibility.
• Experience in implementing AlwaysOn Availability Groups with SQL Server 2012.
• Experience in writing Windows DOS scripts and Windows PowerShell scripts
• Excellent Communication and inter personal skills when working with developers, project managers and application end-users.
• Self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working.

Software/Hardware:

Microsoft SQL Server 2012/2008 R2/2008/2005/2000,SQL Server Reporting Services, Oracle11g/10g/9i, Microsoft Access 2010, EmbercaderoDBArtisanXE4, Idera SQL Diagnostic Manager, Quest Spot Lite, Query Optimization Tools, VisualStudio.NET/2010, Visio, ERwin, SQL Server 2008R2 Analysis Services, Visual web developer, MS FrontPage, IIS 8.0/7.5/7, Windows 2008 Advanced Server/Professional, Windows NT 4.0 Server/Workstation, UNIX, SQL, T-SQL, XML, XHTML, Cisco My VPN, Rapid SQL XE4/7.2, Unified backup and recovery Legato Net Worker, CA archive, Quest capacity management, PowerShell, DOS, SQL Builder, OEA Source Safe

WORK EXPERIENCE

Confidential

Senior SQL Server DBA/System Analyst

Achievement Responsibilities:

• Backing up/restoring databases and implement backup and retention strategies based on business policies. Use CA archive for secured backup in order to keep database highly available.
• Besides CA archive, implement High Availability Disaster Recover Technology like Clustering, Database Mirroring, Log Shipping, and Replication such as Transaction, Snapshot and Merge in SQL Server 2008 R2, 2008, 2005 now a day implementing Always OnHigh Availability Groups with SQL Server 2012.
• Maintain, develop and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements of the business.
• Plan, co-ordinate and implement security measures to safeguard the database.
• Tuning/monitoring SQL Server/application performance due to slow SQL queries via profiler, query execution plan, index, and hardware resources. Tuning T-SQL queries to improve performance
• Designed and developed packages for data warehouse using Integration services SSIS SQL Server 2005/2008.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Created dimensions using SQL Server Analysis Services SSAS .
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Work on DBCC utilities and update database statistics weekly for fixed data corruption in application databases.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in using C .Net in script Task while creating SSIS Packages.
• Worked with the Version control Systems like Team Foundation Server TFS , Visual Source Safe VSS .
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Troubleshooting SQL Server service outages as they occur anytime
• Providing the permissions needed by the SQL Server and SQL Server Agent startup accounts.
• Starting and stopping SQL Server and SQL Server Agent services.
• Workon Active Directory for user permission/access/creations etc.
• By using 3rd party SQL Management Toolslike Quest Spot Lite, Quest Change Auditor for monitoring the process, maximum optimization, diagnosis resource utilization like disk space used in percentage, IO/CPU bottlenecks
• Use the 3rd party Cisco my VPN, Idera SQL Management Tool and other 3rd party software for Database space management, alert management, performance monitor database services on travel or on leave from anywhere.
• Upgrade and consolidation for application and database and DR environment implementation etc.
• Closed liaison with server engineers, network engineers, application support team, business unit, application user and lead to provide different type of support etc for project related solution and production support needslike pw reset, user logins creation, provide different object permission to make sure application is running well.
• Used Microsoft Team Foundation Server for the purpose of version Control and source code maintenance needs.
• Meeting up the Usage DTS, bcp utilities, SSIS an Extract Transform Loading ETL tool to integrate data from data sources, created packages for different data loading operations for application.
• Use SSRS for reporting services and SSAS for data Analysis and data warehouse.
• Implement the database maintenance plans for database optimization.
• Update and generate script files of the databases whenever changes were made to sp/views/tables.
• Administer the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Install, upgrade, configuration of MS SQL Server 2005/2008 R2/2012 in clustered and stand-alone environments.
• Refreshing databases from production server to production support and other servers for testing and upgrading data in databases.
• Working in Dev and prod server with SQL 2012/ 2008 R2/2005 for research/testing data before migrate to prod.
• Work for enabling/disabling the script, trigger etc.
• Write Windows DOS scripts and Windows PowerShell scripts in order to boost up the desired results.
• Document the company's database environment

Environment:

Windows 2003/Windows 7/Windows 8, Windows Server 2003/2008 R2, SSIS, SSRS, SSAS, MS SQL Server 2005/2008 R2/2012,Oracle 11g/10g/9i, Microsoft Access 2010/2003, Quest Spot Lite, quest change auditor, Embercadero DBArtisan XE4/8.7.0, Idera SQL Management Tool, C .NET, VB.NET, Share point MOSS , VB Script, XML, VisualStudio.NET, Visio Enterprise, MS Reporting Services, MS Replication Server, CISCO my VPN, trigetto facet, footprint ticketing system

Confidential

MS SQL Server DBA

Achievement Responsibilities:

• Installed, upgrade, configuration etc of MS SQL Server 2005/2008/2008 R2 and MS SQL Client clustered and stand-alone environments.
• Worked on Client/Server tools SQL Server Management Studio, Query Analyzer to Administer SQL Server.
• Estimation and Monitoring Space requirements for databases and log files.
• Planned the Complete Back up Database and restored the Database from Backups.
• Managed security of SQL logins, roles and user accounts Grant/revoke permissions for table, view, sp, etc.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Used Microsoft Visual Source Safe VSS and Team Foundation Server TFS for integration, maintenance and Security of code.
• Performance monitoring of daily used SQL resources including processor, memory, disk I/O, paging, cache etc.
• Creating Stored Procedures, Triggers, Functions, and Jobs for all databases.
• Responsible for Design, Implementation and Performance Tuning of the databases.
• Worked with Database migration Testing experience in different versions of Informatica
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using Business Object and Crystal reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Develop Database Backup, scripts and automated this process.
• Implementation and Administration of Data Replication and Disaster Recovery management Process.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes and update database statistics weekly for fixed data corruption in application databases.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy exact lookups using SSIS tasks.
• Scheduled Jobs, batch, alert and E-mail notification settings.
• Work for diagnosis server reliability, performance issues enabling/disabling the script, trigger etc.
• Responsible for SQL Server Database administration and production support.
• UseIdera SQL Management Tool etc for Database space management, alert management, and performance monitor database services on travel or on leave from anywhere.
• DBAtrisan tool for performing administrative task for both MS SQL and Oracle servers.
• Worked with the closed liaison with Business unit, application user and lead to provide different type of support like password reset, user logins create, provide different object permission to make sure application is operating well.
• Used bcp utilities, DTS, SSIS an Extract Transform Loading ETL to collect data from various sources, created packages for different data loading operations for application.
• Use SSRS for reporting services and SSAS for data Analysis and data warehouse
• Implemented backup and retention strategies based on business policies and database maintenance plans for database optimization.
• Update and generate script files of the databases whenever changes were made to sp/views/tables.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Environment:

Windows 2003/Windows 7, MS SQL Server 2005/2008/2008 R2,Oracle 11g/10g/9i, Microsoft Access 2010/2003, EmbercaderoDBArtisan XE4/8.7.0, Idera SQL Management Tool, NetIQ AppManager Suite v6.0,Share point MOSS ,a C .NET, SSRS, SSAS, VB.NET, VB Script, XML, VisualStudio.NET, Visio Enterprise, MS Reporting Services, MS Replication Server, CISCO VPN.

Confidential

MS SQL Server DBA

Achievement Responsibilities:

• Monitoring/tuning the SQL Server using Performance Monitor.
• Ensure database servers are backed up in a way that meets the business's Recovery Point Objectives RPO and business' Recovery Time Objectives RTO
• Troubleshooting SQL Server service outages as they occur, including after-hours and weekends
• As new systems are brought in-house use clustering, log shipping, mirroring, other technologies
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Design SSRS and excel reports on assets, expense analysis, and balance sheet
• Deployed reports onto the production report server through various ways
• Skilled in SQL SERVER Business Intelligence tools SSIS, SSAS, SSRS, and Power Pivot .
• Created Ad hoc Reports using report builder in SSRS
• Used Microsoft Team Foundation Server for the purpose of version Control and source code maintenance needs.
• Worked with the Version control Systems like Team Foundation Server TFS , Visual Source Safe VSS .
• Expert level skills in testing the Enterprise Data Warehouses using Informatica Power Center, Data Stage, Ab Initio, and SSIS ETL tools.
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• On-call troubleshooting on production SQL Server. Worked on the company's SQL Server when service stopped working.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Tuning T-SQL queries to improve performance and Work for enabling/disabling the script, trigger etc.
• Involve with many mission critical projects like servers upgrade and consolidation.
• Working with Business unit, application user and lead to provide different type of support like password reset, user logins create, provide different object permission for application operation.
• Attend meeting with business unit and other support team like server engineers, network engineers, application support team, developer etc for project related solution and production support needs.
• Used bcp utilities, Data Transformation Services DTS , SSIS an Extract Transform Loading ETL tool to populate data from various data sources, created packages for different data loading operations for application.
• Use SSRS for different reporting and SSAS for data Analysis for warehouse.
• Implementing the database maintenance plans for database optimization.
• Update and generate script files of the databases whenever changes were made to stored procedures, views or tables.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Install, upgrade and configuration of MS SQL Server 2005/2008 R2in clustered and stand-alone environments.

Environment:

Windows 2003/Windows 7, MS SQL Server 2005/2008,Oracle10g/9i Microsoft Access 2010/2003, EmbercaderoDBArtisan XE4/8.7.0, Share point MOSS , Idera SQL Management Tool, C .NET, VB.NET, VB Script, XML, VisualStudio.NET, Visio Enterprise, MS Reporting Services, MS Replication Server, SQL Builder, OEA Source Safe

Confidential

MS SQL Server DBA

Achievement Responsibilities:

• Involve in Wire servers upgrade and consolidation. Sheshunoff Deposit score card application and database upgrade. Compass Money room application upgrade and DR environment implementation etc.
• Working with Business unit, application user and branch manager to provide different type of support like pw reset, user logins create, provide different object permission to make sure application is operating well.
• Using Idera diagnostic manager for resource utilization like disk space used in percentage, IO bottlenecks, CPU Bottleneck, Blockings etc.
• Excellent in creating reports with SQL Server Reporting Services SSRS
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS
• Follow the standard procedure HPSM ticket System before making any change in prod environment.
• Experience in creating ETL mappings in Informatica to load data from different sources to different target databases.
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Attend meeting with business unit and other support team like server engineers, network engineers, application support team etc for project related solution and production support needs.
• Used SSIS an Extract Transform Loading ETL tool to gather data from various data sources, created packages for different data loading operations for application and bcp utilities.
• Use IderaSQLSafe tool for backup and restore database for extensive Database space/alert management.
• Implementing the database maintenance plans for database optimization.
• Update and generate database script files whenever changes were made to stored procedures or views.
• Using DBCC utilities and update database statistics weekly for fixed data corruption in application databases.
• Using DBAtrisan tool for performing administrative task for both Oracle and MS SQL servers.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Install, upgrade and configuration of MS SQL Server 2005/2008 in clustered and stand-alone environments.

Environment:

Windows 2000/2003/Windows 7 SP1, MS SQL Server 2000/2005,Oracle 10g/9i/8i,Share point MOSS , SSAS, Microsoft Access 2010/2003/2000/8.0, EmbercaderoDBArtisan 8.7.0, Idera SQL Management Tool 6.0.1907.2,C , VB.NET, VB Script, XML, VisualStudio.NET, Visio Enterprise, MS Reporting Services, MS Replication Server.

Confidential

MS SQL Server Administrator

Achievement Responsibilities:

• Maintain databases both on clustered and stand-alone servers for designing and testing various Disaster Recovery mechanisms to ensure 100 data recovery in the event of failures.
• Using performance dashboard and Idera diagnostic manager for Index recommendations generated by the query optimizer.
• Identified and worked with parameters for parameterized reports in SSRS 2005/2008.
• Created and scheduled a SSIS package to run our stored procedures to create the output report tables and regenerate reports automatically on weekly or monthly bases using SSRS 2005 and SSRS 2008.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Created user defined function and added them to model database for future purpose by using T-SQL.
• various data sources, created packages for different data loading operations for application. Create sp, trigger, database, table, view and indexes on tables for perform improvements by using T-SQL.
• Designed various MDX queries and multi dimensional OLAP cubes using SQL Server Analysis services SSAS .
• Used bcp utilities, Data Transformation Services DTS , SSIS an Extract Transform Loading ETL to populate data from
• Job scheduled for full, Differential and Transaction log backups and suggested backup strategies.
• Use Quest Spot Litefor SQL Server for backup and restore database for extensive Database space management and alert management.
• Update and generate script files of the databases whenever changes were made to spor views.
• Using DBCC utilities and update database statistics weekly for fixed data corruption in application databases.
• Install, upgrade and configuration of MS SQL Server 2000/2005/2008 in clustered and standalone environments and migrating databases from MS SQL server 2000 to MS SQL server 2005/2008.

Environment:

Windows 2000/2003 SP1/XP, MS SQL Server 2000/2005/2008,Oracle 10g/9i/8i, Microsoft Access 2000/8.0, EmbercaderoDBArtisan 8.7.0, Idera SQL Management Tool 6.0.1907.2,NetIQ AppManager Suite v6.0, C , VB.NET, VB Script, XML, VisualStudio.NET, Visio Enterprise, MS Reporting Services, MS Replication Server.

Confidential

MS SQL Server Administrator

Achievement Responsibilities:

• Designed implemented databases, tables, views, clustered and non-clustered indexes in prodenvironment.
• Dropped and recreated the indexes on tables for performance improvements
• Created user defined function and added them to model database for future purpose.
• Configured and implemented Transactional Replication between OLTP and DSS databases
• Used Data Transformation Services, an Extract Transform Loading ETL tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Implemented backup and retention strategies based on business policies
• Worked extensively on Database space management, performance monitoring and Alert management
• Created logical and physical data modeling for development database using ERwin Tool
• Used DBCC utilities and fixed data corruption in application databases.
• Createduser logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Involved in migrating databases from MS SQL server 2000 to MS SQL server 2005.
• Installation, upgrade and configuration of cluster MS SQL Server 2005 and MS SQL Server 2000 / servers.

Environment:

Windows 2000/2003 SP1/XP, MS SQL Server 2000/2005, Oracle 9i/8i, Quest LiteSpeed for SQL Server v4.8.1,SQL Server Analysis Services, C , VB.NET, VB Script, XML, VisualStudio.NET, Visio Enterprise, MS Replication Server.

Confidential

MS SQL Server Administrator

Achievement Responsibilities:

• Installed SQL Server 2000/2005 on server and clients.
• Performance tuning, query-inventory, analysis and optimization.
• Created Database Objects - tables, indexes, views, roles.
• Worked with different methods of logging in SSIS.
• Migrated DTS Packages from SQL Server 2000 to 2005 as SSIS Packages.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Worked with the Version control Systems like Team Foundation Server TFS , Visual Source Safe VSS .
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Involved in scheduling, creating snapshots and subscriptions for the reports. SSRS 2005/2008 .
• Designed and developed packages for data warehouse using Integration services SSIS SQL Server 2005/2008.
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Created and managed database users, login Ids and security.
• Performed Data transfer Import Export using DTS packages.
• Setting up the replication system using snapshot replication.
• Service pack updates on server and client.
• Created triggers stored procedures, databases, tables and queries.
• Backup, restore, and database maintenance, database monitoring using system tools.

Environment:

Windows 2003, MS SQL Server 2005, SQL Server Analysis Services, SSAS, SSRS, Oracle 8i, Quest spot litefor SQL Server v4.8.1, C , VB.NET, VB Script, XML, VisualStudio.NET, Visio Enterprise, MS Replication Server.