SUMMARY

• 7 years of IT experience, more than Five years in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2008R2,2008,2005,2000, 7.0 databases in Production, Testing, Development, Replication & Cluster Server Environments.
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database design and Query optimization.
• Good knowledge of Relational Database Management Systems (RDBMS).
• Experience in providing 24x7 Production Support.
• Experience in Upgrading from MS SQL Server 7.0 to MS SQL Server 2000, MS SQL Server 2000 to MS SQL Server 2005, MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2005 to MS SQL Server 2008 R2 and also from SQL Server 2000 to SQL Server 2008R2
• Experience with SQL Server 2008R2/2008/2005 DDL/DML Triggers, Database Mirroring, Migration, Upgrading.
• Experience in implementing different types of Replication models like Transactional, Snapshot and Merge in SQL Server 2005/2008 R2.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005 databases and MS SQL Server 2008 R2 used as DR solution.
• Experience in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster in Windows 2008 R2 Datacenter, Windows 2008 R2 Enterprise, Windows Server 2008 Datacenter, Windows 2008 Enterprise, Window 2003 Enterprise Server and Windows 2000 Advanced Server.
• Experience in using data modeling tools like SQL Diagrams, Erwin 7.1 & Microsoft Visio 2003/2007/2010.
• Extensive experience in Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Experience in migration of Data from Excel, Flat file, Oracle to SQL using BCP, DTS and SSIS utilities.
• Experience in working with Reporting tools like Crystal Reports, SQL Server Reporting services.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Good experience in resolving blocking and Dead lock Issues by using SQL commands.
• Documented disaster recovery plans and participated in disaster recovery drills.
• Experienced in using Microsoft’s in built tools like SQL Profiler, SQL DTA, and Windows Perfmon for Monitoring, Developing and Tuning MS SQL Server applications.
• Experience in implementing Various RAID technologies.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Complex queries using T - SQL.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience working with Windows 2008 R2 Datacenter, Windows 2008 R2 Enterprise, Windows Server 2008 Datacenter, Windows 2008 Enterprise, Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Monitoring Dashboard Reports for Performance Tuning and finding bottlenecks in database.
• Worked with Third Party Backup solutions like SQL Lite Speed for MS SQL Server.
• Experience in upgrading SQL Server software to new versions and applying service packs, hot fixes and Unattended Installations.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks

TECHNICAL SKILLS

RDBMS: MS SQL Server 2008 R2, 2008, 2005, 2000, 7.0, MS-Access

Web Technologies: HTML, DHTML, ASP.Net, XML, Java Script and VB Script

Languages: C, C++, T-SQL, Java, VB.NET, ASP.NET, XML, PHP, UNIX Shell Scripts, T-SQL

Operating Systems: Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

OLAP Tools: MS OLAP Services Manager

Version Control Tools: Visual Source Safe, Rational Clear Case, Team Foundation Server 2010.

Web Server Technologies: IIS 5.1/6.0/7.0, Apache, Tomcat.

Reporting Tools: Crystal Reports 8,9,10, Microsoft Reporting services 2008/2005/2000

SharePoint: WSS 2003/MOSS 2007/O14

Modeling Tool: ERWIN 7.1, Microsoft Visio 2003

PROFESSIONAL EXPERIENCE

Confidential, GA

SQL Server DBA/Release Engineer

Responsibilities:

• Installed and configured SQL server 2008R2 and administered 100+ servers with zero downtime.
• Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server 2008R2.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Maintained SharePoint 2010 SQL Server 2008R2. Maintained Content Database, created number of partitions, file groups.
• Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production.
• Developed reports for DBA monitoring activities with SSRS.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis.
• Administered the SQL server 2000/2005/2008 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• User management by assigning appropriate permissions to the database users.
• Experience in upgrading SQL Server and applying service packs and hot fixes and unattended Installations.
• Involved in database administration tasks and assisting developers with problems and SQL optimization.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Worked on REDGATE to compare databases across the environments and compare the data and synchronize all database objects.
• Experienced working on SQL COMPARE tool to compare the structures between databases in order to synch them
• Took backups of the databases using Red gate, LiteSpeed and good experience using Foglight.
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers
• Knowledge in Active/Passive Clustering and implementing RAID technology on windows 2003 servers.
• Built SQL Server Active - Passive Clusters critical financial applications.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backups, reorganize and rebuild indexes and Update Statistics. .
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Refresh the database from production to development and staging environment on daily basis.
• Developed physical data models for database schema and objects.
• Involved in the Backup & Restore and point in time recovery of the databases.
• Responsible for developing, monitoring and deploying SSIS packages.
• Loaded data from various sources like flat files, to SQL Server database Using SSIS Package.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in the Query optimization and Performance tuning of Stored Procedures, Function and Views.
• Developed SSIS packages to extract, transform and load (ETL) the data using SQL Server 2008 Integration Services and upgraded DTS to SSIS.
• Capacity-planning, Maintaining run book documentation on all the servers in word and excel formats.
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2008 R2/2005/2000, Windows 2003\2008, Windows NT, lit speed, SQL backup5 Red Gate, SQL secure, ETL, SSIS, SSRS, C#., VB,ASP.NET, MS Excel and MS Access, SSAS, System Monitor / Performance Monitor.

Confidential

SQL Server Database Administrator

Responsibilities:

• Installation and Configuration of SQL Server 2005.
• Applied patches SP2 in production and development environments.
• Upgraded SQL Server 2000 to SQL Server 2005.
• Worked in 2- node Active/Passive Clustered Environment windows 2003 64bit Enterprise edition.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Implemented Log Shipping in SQL 2005 from Primary Server to Standby Server to support DR Solution.
• Worked in 24x7 production support on call rotation.
• Integrated SQL Server 2005 reporting services with Microsoft Share Point Portal Server to deliver automatically generated reports to a Share Point portal.
• Involved in Performance tuning, optimization of stored procedures and queries.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Monitored Performance with SQL Profiler, Perfmon and using a monitoring tool called DBArtisan.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented database Backup & Maintenance Plans.
• Acted as a liaison between the offshore team and onshore team.
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.

Environment: MS Windows 2003/2008 Enterprise Server, MS SQL Server 2000/2005, Visual Studio 2005,IIS 6.0, HP ProLiant DL380 G4 with 12 GB RAM, Dell PowerEdge Servers, ERWIN, DBArtisan, SharePoint

Confidential, San Diego

Database Administrator

Responsibilities:

• Installation of SQL Server 2005 for People Soft Applications.
• Upgraded SQL Server 2000 to SQL Server 2005
• As a DBA, contributed for the successful design, development, implementation
• Implemented DR solutions and High Availability.
• Managing Disk Storage - Configuring RAID disks - Creating File Groups for Tables and indexes and placing them across RAID 0+1, 5 disks.
• Provided 24x7 production support for mission critical applications in the organization.
• Setup log shipping on SQL Server to setup warm standby servers, which were also used as reporting databases
• Assist the Application development teams with best practices for SQL Server including but not limited to code optimization techniques & Change management using VSS.
• Estimating Database size, Creating & altering user databases and granting ownership to them, setting database options.
• Transferring data in and out of SQL Server databases using DTS packages.
• Written stored procedures to monitor the SQL server by using DBCC functions, Update statistics, etc.
• Setup Alerts by using SQL Performance monitor to monitor the database log size and to take backup.
• Scheduled unattended operations/tasks like Backup, stored procedure for monitoring SQL server.
• Diagnosing and fine tuning SQL Server by changing the configurable system parameters to achieve the best performance.
• Setup Log shipping and Replication on SQL Server to setup Warm stand by servers for Reporting and offline data distributing.

Environment: SQL Server 2005/2000, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS, VB, Oracle 8i, MS-ACCESS.

Confidential, Dover DE

SQL Server DBA/Developer

Responsibilities:

• Installed and configured SQL server 2008 and administered 100+ servers with zero downtime
• Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server 2008.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas
• Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis.
• Administered the SQL server 2000/2005/2008 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• User management by assigning appropriate permissions to the database users.
• Experience in upgrading SQL Server and applying service packs and hot fixes and unattended Installations.
• Involved in database administration tasks and assisting developers with problems and SQL optimization.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Experienced working on SQL COMPARE tool to compare the structures between databases in order to synch them
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers
• Knowledge in Active/Passive Clustering and implementing RAID technology on windows 2003 servers.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Refresh the database from production to development and staging environment on daily basis.
• Developed physical data models for database schema and objects.
• Involved in the Backup & Restore and point in time recovery of the databases.
• Responsible for developing, monitoring and deploying SSIS packages.
• Loaded data from various sources like flat files, to SQL Server database Using SSIS Package.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed
• Used Lookups Transformation to get the data from reference data sets.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
• Created permanent tables, temporary tables and table variables.
• Conducted design reviews with users/team for development and production strategies.
• Translating business requirements into technical design specifications and actively supported business users for change requests.
• Developed DTS and SSIS packages to extract, transform and load (ETL) the data using SQL Server 2008 Integration Services and successfully completed DTS to SSIS conversion
• Capacity-planning, Maintaining run book documentation on all the servers in word, pdf and excel formats.
• Good experience in handling onsite-offshore model.
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2008 R2/2005/2000, Windows 2000, Windows NT, lit speed, Sql backup5, SQL secure, ETL, SSIS, SSRS, C#., VB,ASP.NET, MS Excel and MS Access, Oracle, UNIX, SSAS, System Monitor / Performance Monitor.

Confidential

Database Administrator

Responsibilities:

• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Provided 24 X 7 dedicated supports for the claims records database.
• Provided 24 X 7 supports for Production environment.
• Planned and modified the permission issues in the production servers.
• Server & Application fine-tuning & trouble shooting, Monitoring MS SQL Server performance and windows server issues.
• Created the backup and restore strategy for production environment.
• Worked with SQL server Profiler generated traces to optimize the performance of the database.
• Installed and configured active/passive clustered environment.
• Rebuilding indexes on various tables.
• Resolving locking and blocking issues.
• Installed and configured SQL Server 2005 32-bit in a Test Environment and migrated & tested databases to production server.
• Implemented log shipping in standby mode to support DR servers.
• Documented and tested Merge replication in test environment for generating reports.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the performance of the server on daily basis in email format.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and physical database.
• Assisted other teams in stress-testing applications, locating bottlenecks, and recommending possible solutions.
• Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data. Worked with management to develop database strategies to support company needs.
• Responsible for creating and maintaining technical documentation for the database environment to follow HIPPA rules.

Environment: SQL Server 2000/2005 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, Idera Diagnostic Manager, IBM eServer pSeries platform, IBM Storage systems DS8300, DS6800s and DS 4800s.

Confidential

Database Developer

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Designing and creation of tables and stored procedures with E-R diagrams.
• Writing the stored procedures, checking the code for efficiency using T-SQL.
• Creation of user Databases and installation of MS SQL Server 2000.
• Created and maintained various databases for development and testing environment.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures and triggers through query analyzer.
• Data Transfers between various servers using BCP.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler and NT monitoring tools.
• Using Data Transformation Services (DTS) and SSIS to populate data from various data sources using the concept of OLE DB.
• Involved in Data warehouse support.
• SQL Server Reporting Service to create enterprise, ad-hock, embedded and web-based reports.
• Testing the stored procedures performance and its path of execution by using SQL Profiler.
• Recovering the Backups of production databases as a part of regular maintenance activities.
• Crystal Report is used to create more flexible, tailored, and responsive report.

Environment: Windows 2000 server, T-SQL, SQL, SQL Server 2000 / 2005 (Enterprise Manager, Query Analyzer), SSIS, SSRS, UML and Visual Basic 6.0, Crystal Report.