SUMMARY

• MS SQL DBA with 4.9 years of experience in installation & configuration, upgrades, database migrations, backup & recovery and maintenance and 1 year on .Net technologies.
• Fast learner and easily adaptable to new technologies.
• A team player with strong leadership skills.
• Solid technical and analytical skills.
• Primary strength lies in: SQL Server 2000/2005/2008 &r2, Windows 2003 Server Enterprise.
• Experienced in Database administration of SQL Server 2005/2008/r2 production support, installation, configuration, upgrades, backup and recovery.
• Having good knowledge on High Availability SQL Server solutions like SQL Server Database mirroring, SQL Server Log shipping and SQL Server Clustering.
• Involved in optimizing code and improving in databases including re - indexing,updating statstics, recompiling stored procedures and performing other maintainance tasks.
• Knowledge in Designing, Implementing and administering database replication between SQL Server databases as well as dissimilar databases).
• Having Experience on creating, and troubleshooting Maintenance jobs like backups and rebuild indexes and dbcc consistency checks.
• Having Experience on creating, and troubleshooting Maintenance jobs like backups and rebuild indexes and dbcc consistency checks.
• Scheduled jobs, alerts, DTS, SSIS Packages in SQL server.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), Bulk Insert and BCP.
• Specialized in implementing different types of Replication Models like Snapshot and Transactional.
• Utilized Data Transformation Services (DTS), SSIS effectively for data conversion from external databases like Ms - Access to SQL Server.
• Knowledge of business intelligence/data warehousing practices and tools (including MS SQL Reporting Services).
• Energetic and self-motivated team player / builder. Facilitate a team approach to achieve organizational objectives, increase productivity and enhance employee morale. Proven ability to work in both independent and team environments.
• Work as part of a team and provide 7x24 support when required.

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server 2000/2005/2008 DBA

Languages: C#.net,Asp.net, Html &Visual Studio.net 2005

Operating Systems: Windows xp/ 2000 Professional, Windows Server 2000/2003/2008

Database Tools: Red-gate SQL Backup pro, Ideara SQL Job manager and Quest Spotlight

Web Servers: IIS 5.0 & IIS 6.0,SQL Clustering

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA

Environment: SQL Server 2005,MS SQL Server 2008,WindowsServer2003,SSMS,QuestSpotlight

Responsibilities:

• Involved in implementing high availabiltiy solution like log-shipping and mirroring
• Configuration and Installation of SQL server 2008 ( on 2 node cluster)
• Monitor SQL Server error logs for potential issues
• Monitor database corruption using DBCC logs
• Working with customer for documenting backup and restore procedures for disaster recovery
• Detect any failures and check for successful completion of daily backup
• Monitor the status of Production SQL Server jobs
• Report containing database size statistics, recent administration activity
• Investigating and Troubleshooting Database corruption/Recovery scenarios
• Managing and Monitoring SQL Data Growth and Fragmentation
• Monitoring, tuning and analyzing db performance and allocating server resources to achieve optimum db performance using profiler.
• Database scheme changes, data cleansing tasks, refreshing databases from one environment to another.
• Involved in configuring reporting services and generation of adhoc reports

Confidential

SQL DBA

Environment: SQL Server 2008 r2,SQL Selver 2008,windows server 2008,Sql profiler,RedGate SQL Backup pro.

Responsibilities:

• Implementing Replication Process to provide facility for transferring data between two different servers at different location.
• Developing successful backup strategies based on recovery model for accomplishing optimal data safety.
• Providing 24/7 On-Call support critical production databases
• Actively involve and participate in team meetings and author how-to documents and knowledge base articles for various database related tasks
• Report server configuration
• Reporting and resolving serious SQL Server alerts.
• Refreshes from Production backup to Stage and Development environments
• Verifying all alert log files for any new entries.
• Scheduling backups using scheduled jobs
• Verifying free space in Data file.

Confidential

SQL DBA

Environment: SQL Server 2008,SQL Server 2008 r2,Windows Server 2008,Quest spot Light

Responsibilities:

• Installation, Configuration, monitoring, backup & recovery and support of SQL Server 2000/05/08
• Developing successful backup strategies based on recovery model for accomplishing optimal data safety.
• Involved in Upgrading from SQL server 2005 to SQL server 2008.
• Defines, implements and manages tools for monitoring the databases.
• Manages database security and monitors user access .
• Maintaining latest patches and hot fixes.
• Monitors and maintains databases including replication processes to ensure high availability and consistency across different databases.

Confidential, Cincinnati

SQL DBA

Environment: SQL Server 2000,SQL Server 2005,WindowsServer 2003,Red-GateSQLBackuppro

Responsibilities:

• Installation of MS SQL2005 enterprise servers on production, test and development boxes.
• Database and log backups & restoration, backup strategies, scheduling backups.
• Backing up master & system databases and restoring them when necessary.
• Schedule the jobs for the Database Maintenance.
• Dropped and recreated the indexes on tables for performance improvements.
• Drop and add users, logins, aliases, and groups to the databases and granting/revoking permissions on Database objects.
• Database and log backups & restoration, backup strategies, scheduling backups.
• Implementing Replication Process to provide facility for transferring data between two different servers at different location.
• Developing successful backup strategies based on recovery model for accomplishing optimal data safety.

Confidential

Junior SQL DBA

Environment: SQL Server 2005, SQL Server 2000,Windows 2003 Server, SQL Profiler Index Tuning Wizard, MS SQL Enterprise Manager

Responsibilities:

• Looking after servers (SQL Server 2000/2005/) / databases to ensure nil loss of information/ data.
• Configuration and Installation of SQL server 2000/2005)
• Verifying all instances are up and Running.
• Verifying all alert log files for any new entries.
• Scheduling backups using scheduled jobs
• Creation of users and logins
• Created the necessary indexes to improve the query performance.
• Involved upgrading SQL server 2000 to SQL Server 2005
• Implementing Log shipping between Mumbai and London Datacenters.
• Reporting and resolving serious SQL server alerts

Confidential

Software Trainee

Environment: Asp.net 2.0, C#.net,sql server 2005

Responsibilities:

• Involved in web page designing and coding.
• Involved in developing required class libraries and also responsible for implementing 3-tier pattern in the project.
• Involved in unit testing
• Involved in designing web user controls.

Confidential

Software Trainee

Environment: ASP.NET 1.1, C#.net, SqlServer2000

Responsibilities:

• Involved in web page designing and coding
• Involved in creating tables and stored procedures
• Involved in unit testing
• Implemented Client-side Validations