PROFESSIONAL SUMMARY:

• Experienced Professional in Design, Development, Implementation Administration of Client - Server Applications Database systems in all Systems Development Life Cycle environments.
• Extensive Experience in installation, configuration of MS SQL Server 2000/2005/2008 / R2 2012. Development, Production, Test and Cluster Server Environments.
• Experience in Database Upgradation and Migration in place/side-by-side from SQL
• Experienced in implementing efficient Disaster prevention and Recovery Strategies and High availability like Database Backup, Restore, Database Snapshot, Partitioning, Replication, Log Shipping, Clustering Active / Passiave and Database Mirroring.
• Knowledge of the Oracle GoldenGate installation, configuration, troubleshooting GG issues.
• Experience in SQL 2008 Features like Datacollection, ActivityMonitor.
• Expert in Monitoring Disk space, Improving Efficiency in databases including Index Tuning Wizard, Query tuning, and performing other maintenance tasks as Data Partitioning, Snapshot isolation.
• Installed and configured Quest Spotlight for SQL Server Enterprise and customized alerting with Spotlight on SQL Server.
• Solid experience in performance monitoring with Activity monitor, SQL Profiler, client/server connectivity, DMVs and DMFs, SQL Diagnostic Manager.
• Expert in Database administration activities for DB Security creating logins, users, roles, and assigning permission to them .
• Experience in DACPAC operations of data-tier elements that support Application developer and Database Administrator.
• Experience in Deployment of Project and Packages with SSIS with ispac extensions.
• Experience in running Database Consistency Checks using DBCC Commands.
• Hands on Experience in implementing different types of Replication Models like Snapshot and Transactional and Merge Replication.
• Experience in taking Backups, managing Alerts, Operators and Jobs through SQL Server Agent.
• Experience in Installing and Configuring SQL Server 2000/2005/2008 R2 and 2012 on different envirnmonets Windows/ Amazon including VM Ware Machine.
• Created Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Experience in design and development of Business Intelligence tools like SQL Server 2005 Integration Services SSIS, Reporting Services SSRS and Analysis Services SSAS .
• Experience in Import Export of various data formats using DTS Data Transformation Services, BCP, Bulk Insert in SQL R2 / 2012 Integration Services.
• Experience in configuring linked servers and handling distributed queries across multiple datasources .
• Experience in installation, configuration, Development of MS SQL Server 2005/2000/2008 R2 Reporting Services .
• Monitoring Daily Jobs, DBMaintenance Plans, and Run DBCC jobs for Reindexing, CheckDB, and Fragmentation.
• Expertise in Database Backup, Recovery and Disaster Recovery procedures including DR/Standby servers, using 3rd party tools SQL Lite-speed
• Excellent analytical, problem solving, interpersonal and communication skills, self-motivated, hardworking, team player ability to handle multiple tasks, and a fast learner.
• Provided after hours and 24/7 Databases maintenance and production support On call Rotation.

TECHNICAL SKILLS

Database

SQL Server 2000/05/2008/ R2/2012, Oracle 11g

Languages

C,, Power Shell T-SQL

Databases Utilities

Query Analyzer, SQL Serer Configuration ManagerTOAD, Business Intelligence Development Studio, Database Engine Tuning

Advisor, SQL Profiler, Litespeed and Spotlight.

BI Tools

Analysis Services SSAS, Reporting Services SSRS .

Testing Tools

Load Runner, Win Runner, Quick Test Pro, TOAD

Operating Systems

UNIX, Windows XP,2003,Windows NT and Linux

Web / Application Servers

Apache, Tomcat, Web logic, Web Sphere

Methodologies

RUP, Agile, Waterfall

Project Management /Analysis

MS Project, MS Visio, Clear Quest, Rational Requisite Pro and UML

Other

ALM Performance Center 11 11.5, Sitescope, Team Quest, Wily, Quality Center

PROFESSIONAL EXPERIENCE:

Role: Database Administrator Engineer Sept 

Responsibilities:

• Experience in installation, configuration, and upgradation of MS SQL Server 2000/2005/2008 / R2 2012 servers.
• Experience in applying Service packs 3, feature packs and hot fixes in Clustered Windows environments.
• Experience in Handling 100 Production servers out of which 30 Databases are Mission Critical.
• Involved in installation, customer configuration Quest Spotlight for SQL Server Enterprise and In-house mointior server.
• Implemented GoldenGate 10.x replication solutions to facilitate data flow between MS SQL Server OracleDB to SQL server environments.
• Knowledge on setting up Availability groups Always On and Challenges.
• Setting up database Backup and Recovery procedures for Production, Stage and Development Servers.
• Worked on SQL Transaparent data Encryption TDE for the server hosted on Amazon Servers.
• Involved in cluster set up of two/three/four node A/A/A/P, A/A/P, A/P, A/A with Windows failover Cluster feature for SQL 2005 SQL 2008/R2 2012.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Setup system high availability with Microsoft SQL Server transactional replication from Oracle to SQL Server for OAS Application.
• Configured Database Mirroring for two environments to create a Disaster Recovery Stand by servers.
• Configured Log Shipping and support Logship failures across servers in different Datacenters as high availability
• Assisting development team on local support of production databases, running Profiler traces for the slow running queries,trouble shooting of high performance taking queries and high CPU usage taking queries using Execution Related Mangement views DMV's .
• Experience in Resolving the Memory contentions using SQL Min/Max Settings, SQL 2008 Resource governor and Lockpages In Memory settings, PageFile settings, Memory related DMV's .
• Identify deadlock, blocking scenarios and Perfarom Reindexing and Index defrag operations for the maintenance of Large tables to resove performance issues.
• Expertise in SQL Server Integration Services SSIS and SQL Server Reporting Services SSRS with good knowledge on SQL Server Analysis Services SSAS .
• Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP, Data Transformation Services DTS and SQL Server Integration Services SSIS .
• Good experience with Monitoring tools Quest Spotlight, SQL Sentry and Confio Ignite tool.
• Experience on Moving idexes to a specific file group for better performance.
• Optimize the tempDB performance by striping and move to dedicated SAN.
• Backup and recovery of production databases using 3rd party tool Litespeed on daily /weekly basis to ensure data integrity, striping the backups to ensure easy backup management .
• Perform VLF cleanups for the databases which are enabled for replication to reduce the replication latencies. Setup policy using policy based managemet to identify VLF's crossing threshold and perfrom cleanup.
• Creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Windows groups, granted privileges toWindows users and groups in both PROD and Pre-Prod Environments.
• Reviewing the deployment documents with the business before implemation in Producation.
• Create linked servers to grant the data access to the users depending on the needs.
• Preparing system architecture understanding documentations and Troubleshooting documents.
• Providing 24X7 on-call system supports.

Environment: Microsoft Windows Server 20 /64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008 and SQL Lite speed, spotlight, DELL power edge

Confidential

Role: Database Admininstrator

Responsibilities:

• Involved in Migration of Business data from Oracle 9i to SQL Server R2.
• ETL packages with different data sources Oracle 9i, SQL Server, Flat Files, Excel source files, XML files etc and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Build Verification and Reconciliation reports after the migration have been done.
• Experience in Server Installation, Configuration, Upgrade, Maintenance, patch management trouble shooting in SQL Server 2000/2005/2008 / R2.
• Involved in documentation and implemented a disaster recovery system.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Troubleshoot and resolve database issues including performance issues, data integrity issues, logging and storage issues, and problems with executing processes. Supported and resolved various production/test related tickets.
• Experience in Security Issues such as creation and granting permissions on various Objects. Assign permission to user s, role s, and object.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, and security breach.
• Automated and enhanced daily administrative tasks, including space management and backup recovery strategies.
• Diagnosed and tuned the server optimal performance using SQL Server 2005's Dynamic Management Views DMV, Profiler and Index Tuning Wizards.
• Hands on experience with Bulk Insert, BCP and Database consistency check using DBCC commands.
• Configured Transactional replication between Primary Server and three Read Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Monitoring and report generation for the database infrastructure using SSRS. These reports are presented to management on Daily basis.

Environment: MS SQL Server 2005/2008R2,SSIS,T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler, Database Tuning Advisor, Windows Server 2000, .Net, SQL Agent.

Confidential

Role: SQL Server Admininstrator

Responsibilities:

• Worked on SQL SERVER 2008 R2/2005 Production Environment.
• Worked on SQL server clustering to provide an active and passive node, SAN storage with RAID 10 implemented on Dell servers, VIP pool to manage the IP address of SQL servers.
• Migrated databases from SQL Server 2005 to SQL Server 2008 R2 which was planned during the maintenance window.
• Setting up database Backup and Recovery procedures for production, stage and development servers.
• Performed Backups using a third party tool REDGATE.
• Resolved Space issue on production servers by implementing effective methods.
• Create database maintenance plans and active directory for the performance of SQL Server including database integrity checks, update database statistics, reorganizing, re-indexing and data backups for Database optimization and Disaster recovery in production and non-production environment.
• Configured Replication methods like snapshot replication, transactional replication and Merge replication for Read write with all Read-only's.
• Creating the users, user groups and maintains the access permissions. Configured SQL Security features and maintained the user administration.
• Worked on SQL Database mail and configured it.
• Constantly monitoring SQL Server Logs to ensure whether the backup operations, batch commands, scripts and have completed successfully.
• Maintained and Created SQL server jobs.
• Monitored and modified Performance using execution plans and Index tuning, store procedures by getting information regarding the CPU, memory and Disk utilization.
• Created traces files using Profiler for all Read-only's and load them into databases using functions for analysis of long running queries and also monitored store procedures.
• Checking Database Health by using DBCC Commands, DMV's and DMF's.
• Created SSIS packages for loading the data to a particular database and also created SSIS package to manage the VIP pool IP addresses.
• Worked on creating reports using SQL server Reporting Services SSRS .
• Configured Reporting Services configuration manager and IIS manager to enable the Email setting so that reports can be subscribed to the customer for referral.
• Created Reports on SQL server 2008 and 2005 for managing the jobs failed on server's instances.
• Participated in project team activities prior to release and contributes to documentation requirements consistent with methodology.

Environment: MS SQL Server 2005/2008,SSIS,T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler, IIS, Database Tuning Advisor, Windows Server 2000, .Net, SQL Agent.

Confidential

Role: SQL DBA / Developer

• Created and maintained various databases for Development, Production, and Testing using SQL Server .
• Participated in storage measurement and capacity planning.
• Assign Permissions to user s, role s, and object. Support column level permission. Administrate Security for Server's Logins Windows and SQL Accounts .
• Monitor long running queries/ Error Logs /Schedule Tasks/database activity/eliminate Blocking and Deadlocks user counts and connections/locks etc.
• Performance Monitoring, system monitoring on Production Databases as and when required.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Worked on the server and keep it running. Concerned with backups, security, patches, and replication.
• Use replication stored procedures to create scripts to automate the transaction replication once databases are refreshed.
• Taking Database full Backup, Transaction log backup differential backup in daily Routine.
• Configured Database Mirroring for 2 environments to create a Disaster Recovery Stand by servers.
• Used DBCC Commands to check physical and logical consistency of the databases and to rebuild indexes.
• Responsible for monitoring and tuning MS SQL server performance and ensuring data integrity.
• Configured Database mail profiles for sending Automatic Mails to respective users upon the success or failure of a database task.
• Configured using Transactional replications. Creating Distribution Databases, updating Publishers, creating managing Publications, managing Replication monitors to reduce the workload on servers.
• Expertise at developing complex SSIS scenarios using different transformations using SQL Server 2008.
• Involved in SQL Server disaster recovery procedures. Responsible for Stored Procedures optimization, Performance tuning index tuning.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, Triggers, Cursors, tables, and views and other SQL Joins and statements for applications.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Documented all the processes involved in maintaining the database for future reference.
• On call 24/7 support to databases on weekly rotation.

Environment: MS SQL Server Management Studio 2000/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services SSIS, MS SQL Server Reporting Services SSRS, Microsoft Visual source Safe, Oracle9i, XML, ASP.Net, Windows 2003/2000.

Confidential

Role: SQL Developer / Admin

• Involved in Migration of Business data from Oracle 9i to SQL Server 2005.
• Build processes for moving Blobs between Oracle and Documentum.
• Build Verification and Reconciliation reports after the migration have been done.
• Experience in Server Installation, Configuration, Upgrade, Maintenance, patch management trouble shooting in SQL Server 2000/2005/2008 / R2.
• Involved in documentation and implemented a disaster recovery system.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Troubleshoot and resolve database issues including performance issues, data integrity issues, logging and storage issues, and problems with executing processes. Supported and resolved various production/test related tickets.
• Experience in Security Issues such as creation and granting permissions on various Objects. Assign permission to user s, role s, and object.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, and security breach.
• Automated and enhanced daily administrative tasks, including space management and backup recovery strategies.
• Diagnosed and tuned the server optimal performance using SQL Server 2005's Dynamic Management Views DMV, Profiler and Index Tuning Wizards.
• Hands on experience with Bulk Insert, BCP and Database consistency check using DBCC commands.
• Configured Transactional replication between Primary Server and three Read Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Monitoring and report generation for the database infrastructure using SSRS. These reports are presented to management on Daily basis.

Environment: s: MS SQL 2000, Windows NT/2000/XP, MS Access, MS Excel, SQL Query Analyzer, Enterprise Manager, DTS.