SUMMARY:

• Over 6 Years of experience in IT industry and 4.5 years of experience as a SQL Server Database administration including Installation configuration, troubleshooting, Database Backup, Performance Tuning and High availability in both Production and Development environment.
• Extensive work experience in Installing, Configuration Maintenance of MSSQL Server 2012, 2008R2, 2005, 2000 versions.
• Over 4 years of proven expertise in all the phases of Software development life cycle involving requirement gathering, design, development, documentation, testing and maintenance.
• Upgrading and Migrating SQL server 2000/2005 databases to SQL server 2008R2.
• Expert in Monitoring SQL Server Performance, Troubleshooting query performance bottlenecks by using SQL profiler, Index Tuning Wizard or DTA, Windows Performance Monitor and Maintenance plan.
• Experience in performing Database consistency checks using DBCC Utilities, Recompiling Stored Procedures and Index Maintenance.
• Experience in Database Backup, Recovery and Disaster Recovery procedures using both native, Red GateSQL Backup and litespeed tool.
• Experience in implementing many types of High availability such as Clustering, Database Mirroring, Log Shipping, and Replication.
• Monitoring Databases and Server, Estimating the growth of the Databases, and maintain Fill Factors. Performance Monitor/Profiler to resolve Dead Locks or long running queries.
• Installation and configuration of Microsoft reporting, analysis, and integration services SSRS, SSAS, SSIS . Managed day to day activities like creation of Users, Schemas, Configuring Permissions and assigning roles to users.
• Creating partition strategy and data compression of Very Large Data Bases up to 3 TB for improving the Data base performance and handled data warehouse databases.
• Creating the SSIS, DTS Packages for Data Migration and Modification using DTS Lookups and transformations.
• Extensively worked on Dynamic Management Views DMV's , and Dynamic Management Functions DMF's . Basic understanding of networking, firewalls, load balancers, protocols.
• Scheduling and monitoring SQL Server Agent jobs. Experience in providing 24 x 7 Production support and Windows administrations and network Security administrations, handled with different storage technologies like SAN, NAS.
• Excellent interpersonal and Communication skills, detail oriented, aggressively penetrating into the root cause, organized and highly motivated team player with the ability to work independently.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Position : SQL DBA/Developer

Description:

WorldNow is a digital media company based in New York City that develops content management systems, advertising, and streaming video platforms designed for use by local television news broadcasters. The company is the largest provider of these systems in the United States as of 2012, it serves 213 stations with its CMS platform.

Responsibilities:-

• Installation and configuration of new SQL servers as per industry and State of Wisconsin standards Database upgrades from SQL server 2000 to SQL server 2008 R2. Scaling SQL Server, Managing Messages, Setting Trace Flags / Jobs Notifications.
• Understand technical architecture of interfaces and underlying databases along with DB setup and logical design.
• Get details knowledge of various batch and scheduled jobs and the purpose of their existence.
• Get details understanding of the existing software, tools, utilities and setup configuration.
• Get a detailed understanding of various processes as currently being followed for incident, change and release management.
• Collaborate with business to define system roadmap and software process mapping.
• Development and maintenance of the database persistence layer stored procedures, views, functions .Plan and Implement database backup and recovery strategies.
• Monitoring High Availability plans and take corrective actions if any problem arises working with other support teams and solving performance issues with the development Team. Ensuring all database systems meet business and performance requirements.
• Monitoring and Tuning SQL Server and running User Scripts Query given by application team.
• Coordinating with respective application teams for modifying the database structure, on need basis Automating Administrative Tasks by creating alerts, jobs, scheduling jobs, notifications etc.
• Monitoring transaction volumes and Database size growth, Analyze and advice on capacity planning. Monitor and ensure resolution as per the agreed SLA with customer. Scheduling and monitoring SQL Server Agent jobs. Experience in providing 24 x 7 Production support and Windows administrations and network Security administrations, handled with different storage technologies like SAN, NAS.
• Solving, defining and analyzing problems. Identifying and recommends alternative solutions. A complete report management solution that enables IT professionals to securely share, schedule, and deliver interactive reports over the web by using Crystal Reports Server 2008.
• Report Generation and Preparation of weekly monthly dashboards. Stabilize critical situations working towards permanent self-sufficiency.

Environment: SQL Server 2008R2, SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS, Windows Server 2003/2008. Confidential Position : DBA Consultant.

Description:

The Wisconsin State Public Defender's Office SPD - The SPD has been providing justice for all since 1977, and is an independent, executive-branch state agency that ensures Wisconsin meets its constitutional requirement of providing legal representation to the indigent.

Responsibilities:-

• Scheduling backup of databases using IBM Tivoli Data Protection and creating database maintenance jobs. Backup/Restoration using TDP and manual.
• Database Mirroring setup which uses the High Availability mode which has automatic failover and full transaction safety.
• Server level tuning of the SQL Server environments and Query tuning using Profiler, Performance Monitor and performance Analysis tool.
• Get details knowledge of various batch and scheduled jobs and the purpose of their existence. Patching both standalone and clustered servers with service packs and hot fixes.
• Performing upgrade of SQL Server from 2000, 2005 and 2008R2 using In-Place and Side by Side techniques.
• Get a detailed understanding of various processes as currently being followed for incident, change and release management.
• Development and maintenance of the database persistence layer stored procedures, functions, Tables, Indexes, Views, Triggers and Constraints .
• Monitoring High Availability plans and take corrective actions if any problem arises. Setup and troubleshooting of transactional and Merge replication.
• Coordinating with respective application teams for modifying the database structure, on need basis Automating Administrative Tasks by creating alerts, jobs, scheduling jobs, notifications etc. TDP configuration and installation.
• Monitoring transaction volumes and Database size growth, Analyze and advice on capacity planning. Monitor and ensure resolution as per the agreed SLA with customer.
• Solving, defining and analyzing problems. Identifying and recommends alternative solutions.
• Stabilize critical situations working towards permanent self-sufficiency.

Environment: SQL Server 2008 R2, SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS, Windows Server 2003/2008, Idera SQL Safe, Quest, IBM Tivoli Data Protection TDP for Backup and Restore.

Confidential

Position : Senior Database Administrator

Description:

Confidential- Switzerland Based Retail Company DB support for Nestle Consumer Products. The Projects provides global support for more than 110 SQL Server instances on a 24/7 Customer support basis all over the world. It manages servers in 5 different environments, namely - DEV, QA, RTE, PRE-Production and Production. It involves interaction with the customers by providing IT solutions to their queries and requests raised as tickets through Peregrine tool.

Responsibilities:-

• Installation and configuration of new SQL servers as per industry and WIPRO standards Database upgrades from SQL server 2000 to SQL server 2005 and SQL server 2008,2008R2 Scaling SQL Server, Managing Messages, Setting Trace Flags / Jobs Notifications.
• Backup monitoring and recovery and Creating the database and database objects provided by Project DBAs, involved in resolving day-to-day production server issues.
• Development, maintenance and Creating of the database persistence layer stored procedures, views, functions and Tables provided by Project DBAs.
• Plan and Implement database backup and recovery strategies.
• Monitoring High Availability plans and take corrective actions if any problem arises and Daily monitoring of SQL Servers for connectivity and errors.
• Report Generation and Preparation of weekly monthly dashboards. Working with other support teams and solving performance issues with the development Team. Ensuring all database systems meet business and performance requirements.
• Monitoring and Tuning SQL Server and running User Scripts Query given by application team.
• Coordinating with respective application teams for modifying the database structure, on need basis Automating Administrative Tasks by creating alerts, jobs, scheduling jobs, notifications etc.
• Solving, defining and analyzing problems. Identifying and recommends alternative solutions.
• Report Generation and Preparation of weekly monthly dashboards. Identifying training needs of team members.
• Coordinating with On-site development team to resolve the Critical application issues and providing off hours support and maintenance.
• Closing all database security related gaps as per organization standards.

Environment: SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS, TOAD, Tivoli, Windows Server 2003/2008. Confidential Position : SQL Production support

Description:

Confidential a Finance Global Shared service center for Business Process captive center of Flextronics worldwide operations, aims to centralize the management of Knowledge/Transaction-based functions across five different shard services verticals - Finance, Information Technology, Global Procurement, Manufacturing and Human Resources. EPR is an online system tool, designed to work with Purchase orders of a company. We are providing 24 7 monitoring of over 70 SQL servers spread across Flextronics sites worldwide.

Responsibilities:

• Installation and configuration of new SQL servers as per industry and GSSC standards Database upgrades from SQL server 2000 to SQL server 2005.
• Involved in Scheduling Tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL Mail, Managing Alerts, Monitoring and Tuning SQL Server, SQL Suggested better Scheduling Strategy for jobs to overcome Blocking and Dead Locks.
• Implemented Log Shipping and Replication Snapshot/Transactional/Merge .
• Plan and Implement database backup and recovery strategies. Backup monitoring and recovery.
• Monitoring error logs, event viewers, SQL server jobs for errors.
• Running User Scripts Query given by application team and Monitoring and Tuning SQL Server, Creating and maintaining users assigning roles and privileges.
• Monitor and ensure resolution as per the agreed SLA with customer. Interfaces with the application development team to implement all database changes.
• Responsible for the creation of the following objects Databases, Tables, Indexes, Views, Triggers, Constraints, Infrastructure related Stored Procedures . Implemented the Security Permissions/Logins utilizing the SQL 2000.
• Created indexes, updated index statistics and rebuild indexes.
• Attend Weekly and Monthly both internal and external meetings. Responsible for providing SQL server training to the new joiners and trainees. Closing all database security related gaps as per FLEX Workflow standards.
• Creating and managing user accounts / logins for development purpose.

Environment: SQL Server 2000/2005, T-SQL, Query Analyzer, Outlook, DTS, BCP, SSMS, Windows 2000 /2003 Servers, SSRS

Confidential

Position : Jr. Software Engineer

Description:

Confidential is a wholly subsidiary of the Global Software service provider for Polaris Software Lab ltd. The role includes the 24x7 SQL server production support for ICICI Bank Services.

Responsibilities:

• SQL server DB Installation, configuration, administration and securing production servers. Involved in Up-gradation of databases from MS SQL Server 7.0 to 2000 version Backup/restore of Databases in Full Recovery Bulk-Logged modes.
• Monitoring error logs, event viewers, SQL server jobs for errors. Installed SQL server 2000 based on the Requirements. Configuring the network settings and firewalls.
• Documentation of Backup/Restore Disaster plan.
• Added the new data files for existing databases.
• Increased the space in existing data files. Project web design Support and trouble shooting.
• Resolved blocking issues in databases and database from multiple backup files.
• Installed the SQL server 2000 and applied service packs and hot fixes.
• Created maintenance plans for user and system databases.
• Assigned the privileges to newly created stored procedures.
• Monitored log shipping, replication jobs. Supported on call 24 7 on rotational basis
• Creating and managing user accounts / logins for development purpose
• Dialer management and Dialer server's management.

Environment: SQL Server 2000/7.0, Windows 2000 Server, T-SQL, SQL server Enterprise Manger.