Summary

Over 12 years of IT Experience in IT infrastructure Projects with ITIL and Agile expertise including 7 Years of Experience as SQL DBA. Expertise in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2014,2012, 2008 R2, 2008, 2005, 2000 in Production, Staging and Development Environments.

TECHNICAL SUMMARY:

• Extensive experience in Installation and configuration of SQL Server 2014, 2012, 2008 R2, 2008, 2005 and 2000.
• Experience in Replication Snapshot, Merge and Transactional.
• Performed Capacity Planning, data modeling and Logical/Physical database Design.
• Expert in Database Backup, Recovery and High Availability Clustering, Log Shipping, Replication and Mirroring .
• Hands on experience in Migration of SQL Server 2005, 2008R2/2008 to SQL Server 2012 side by side and in place which includes production and non-production environment.
• Experience with Change data Capture in SQL Server 2008.
• Involved in migration of DTS Packages 2000 to SSIS 2005 and troubleshoot migration issues
• Extensively worked on Integration SSIS and Reporting Services SSRS , Analysis Services SSAS , Business Intelligence and good experience in data migration from Oracle/MS-Access/MS-Excel Sheets/MYSQL to SQL Server 2008/2005.
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Experienced in writing T-SQL DDL, DML, and DCL . Expert in implementing business logic in backend. Reviewing T-SQL code, maintaining coding standards in all SQL Server environments.
• Experienced in programming tasks Stored Procedures, Triggers and Cursors using SQL Server 2012/2008/2005/2000 with T-SQL.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, I3 Precise, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Expertise in Scheduling Database tasks Jobs, Alerts, Emails, Notification.
• Worked with Popular monitoring solutions like Quest Enterprise edition, Spot lights.
• Working knowledge of .Net Framework VB.Net, ASP.Net, and ADO.Net and IIS.
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication Management skills and Excellent Team player.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL SERVER DBA

• Took knowledge during vendor transition and delivered services successfully single handedly.
• Responsible for taking care of Banking Financial Domain as Application DBA which includes AML anti money laundering ,RF Risk Frontier ,Crawiz , Erwin, Bridger, D3 etc., as major Applications.
• Worked with clients on their business requirement, understanding their system and application, identifying their business plans, technical concerns and issues, devising possible cost- effective solution.
• Coordinate with various clients on day to day basis.
• Creating monthly metrics reports for resource utilization in Projects and forecasting future requirements from clients.
• Worked on migrating SQL server 2005/2008/2008r2 to SQL server 2012.
• Experience in managing very large databases more than 3 TB .
• Applied patching provided by Third party vendor for different applications.
• Participated in Storage, Capacity Planning, Forecasting and Configurations for various applications.
• Created Database and DB maintenance plans according to banking compliance and monitored it.
• Recovering the database from backup in disasters. Implementing point-in-time recovery solutions.
• Responsible for Remediating Nezumi security violations and maintaining as per standards.
• Created Database Snapshot in Pre-prod before making changes in the database.
• Experience in database upgrades and applying service packs.
• Performance tuning of application and Analyzing long running queries and tune the same to optimize application and system performance.
• Created and scheduled jobs for update stats, rebuild index, database backups to automate day to day/maintenance activities.
• Involved in creating Table partitions for large tables for performance improvement.
• Created SQL/Windows logins and assigned necessary permissions as required.
• Migrated data from SQL to Oracle using SSIS as per application team request.
• Coordinate with various Application teams for major Database changes and help with creation of Scripts as required and validate it.
• Responsible for deploying scripts, only when CO change order is accepted and approved by DBA manager.
• Monitoring the server and database to detect any problems in the performance or connections, especially if an error was notified by the application team in all environments.
• Using query execution plan and profiler to diagnose SQL SERVER databases performance issues.
• Replication Configured and maintained Transactional replication.
• Involved in various DBA activities like taking backups and restore as per application need, creation of logins with necessary permissions, creating disk space reports, memory and connection issues, blocking and file growth issues etc.

Environment: SQL Server, 2008, 2008 R2, 2005, SSIS and SSRS..NET Framework, ASP .NET, Idera , Windows server 2003, 2008.

CONFIDENTIAL

Sr. SQL SERVER DBA

Responsibilities:

• Implemented data models, database structure design, backup and recovery processes.
• Configured Change Data Capture in SQL Server 2008 to maintain the history of the changes in the tables.
• Extensively worked on migrating SQL server 2005 to SQL server 2008 R2.
• Involved in installation of SQL Server 2008 R2 on Consolidated and Standalone environments and maintains development and production databases e.g., SQL Server databases .
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Audits and maintains small-scale to large-scale databases.
• Worked on SQL Server 2008 failover clustering which is built on top of a Windows 2003 server cluster.
• Worked on Active/Active and Active/Passive Clustering.
• Applied hot patches on MSCS Microsoft Clusters and Fixed few bugs in Microsoft Cluster and SQL Virtual Servers.
• Involved in creating SQL Login accounts and Users with appropriate permissions on Production and development servers.
• Responsible for verifying all data to be entered into database meets set standards and requirements.
• Involved in creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application based on standard process.
• Worked on Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Worked on DTS Packages, DTS Import/Export for transferring data from Database Oracle and Text format data to SQL Server.
• Involved in migration of SSIS 2005 packages to SSIS 2008R2 packages.
• In Depth knowledge in analyzing Query Plans, Extended Stored Procedures and improving efficiency by re-indexing, update statistics, Recompiling stored procedures, Troubleshooting Dead Locks and capture data using SQL Profiler, Performance Monitor and DBCC Commands.
• Identifies tests and resolves complex database issues e.g., monitoring and tuning .
• Managed SAP backend SQL Server databases which are in Terra bytes of size.
• Involved in database system management functions e.g., software installs, version upgrades and configuration management .
• Defined and provided recommendations database standards, procedures and architecture.
• Designs data models and Data Warehouse database designs.
• Participated in a 24x7 production support on-call rotation.
• Performed SQL Code Index Reviews.
• Worked with Database tools IDERA, SQL Diagnostic manager, Sites cope for Multi Queries, Space analyzer, SQL alerts Disk space alerts, SQL Service alerts, CPU utilization alerts .
• Involved in Ensuring optimal performance and availability of databases.
• Involved in creating SQL jobs and troubleshoot failed jobs.

Environment: SQL Server 2008 R2, 2005, SSIS and SSRS, Sites Scope monitoring tool,SCOM, IDERA tool, VMware machines, .NET Framework, ASP .NET, ADO.NET,AJAX, Visual Studio .NET, HTML, XML, XSLT, Windows server 2003, 2008.

CONFIDENTIAL

Sr. Support Analyst

Responsibilities:

• Scope of work included network related issues, Internet Connectivity issues, Configuring email clients and printer configuration.
• Managed Team of Six L1 Engineers.
• Handle L2 Escalation from support engineers.
• Point of contact for handling Customer Escalations.
• Co-coordinating with Various Vendors.
• Experience in Understanding structured data analysis, data models and data normalization.
• Solid experience with SQL backup and recovery procedures.
• Creating and Maintaining Trace Audits for Security events and generating Reports to analyze the Events.
• Developed SQL data migration scripts for application conversion or integration.

• Created various Jobs, scheduled ran jobs and troubleshooted the failed jobs.
• Had good experience in 24/7 production support.

Environment:, Windows server 2000/2003, SQL Server 2005

CONFIDENTIAL

Analyst and Lead

Responsibilities:

• Providing both Voice and Email L1 Desktop Support.
• Troubleshoot Desktop network Components like Network Interface card, browser support like Internet Explorer, Netscape.
• Take Remote access of the Desktop by using VNC to troubleshoot issues.
• Responsible for assigning the calls to the engineers based on the individuals technical expertise.
• Building long term relationship with existing customers.
• Mentoring the new hires.

• Involved in Capacity Planning.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Working with ITSM Tickets Any changes on Production, staging and development environment need to Create ITSM Tickets .
• Maintained the Tax System databases.

Environment: Windows 2003/2000