SUMMARY

• Over 8 Years of experience in IT industry and 5.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 MS SQL Server 2008R2, 2005, 2000 versions.
• Over 5 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 M onitoring 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 and litespeed tool.
• Experience in implementing many types of High availability such as Clustering, Database Mirroring, Log Shipping, Always ON 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 5TB) 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.
• 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

Operating Systems: Windows Server 2008, Windows Server 2003

RDBMS: MS - SQL Server 2012/2008 R2/2005/2000

Tools: /Utilities: Litespeed, Enterprise Manager, Management studio, Profiler, Query Analyzer, Export & Import, DTS, SSIS-Integration Services, Replication, SSRS-Reporting Services.

Front End Tools: MS FrontPage 98/2000, MS Office 97/2000/XP, MS Project 2000, MS Outlook 97/2000

Database Modeling: Erwin

Microsoft products: MS Office Suite- Excel, Word and Power Point

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator

Responsibilities:

• Installation and configuration of new SQL servers as per industry and Confidential standards Database upgrades from SQL server 2000 to SQL server 2005 and 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.
• Solving, defining and analyzing problems. Identifying and recommends alternative solutions.
• 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

Senior Database Administrator

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.
• Worked for different levels of SQL Servers in a 24/7 basis and escalating issues to Microsoft which has to be Patch up. Closing all database security related gaps.
• 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

SQL Server DBA

Responsibilities:

• Installation and configuration of new SQL servers as per industry and FLEX 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

SQL Server DBA

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