SUMMARY:

• Over 9+ years of IT experience in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2008,2005,2000 in Production, Test, Development, Replication.
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization.
• Experience in Up gradation from MS SQL Server 2005 to MS SQL Server 2008
• Experience working with Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
• Good experience in handling in very large databases .
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and Unattended Installations
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation
• Experienced in creating Jobs, SQL Mail Agent, Alerts with T - SQL store Procedures
• Implemented the new SQL Server 2008 mechanisms like data compressions, online indexing, Contained Databases, security principals
• Knowledge of document management to manage documents. SharePoint Server 2007 forms the basis of an intermediate-level DMS
• Experienced in setting up Transactional replication.
• Experienced in generating reports using SQL Server Reporting Services integrated and deploying them using web application like Java in Production Server.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Exceptionally good and experienced in handling the problem and troubleshooting
• 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.
• Experience in working with Reporting tools like Microsoft Reporting services.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL.
• Involved in creating the access for Oracle database to new users by using Toad.
• Knowledge in oracle database for creating new users and performance tuning for high end Quries
• Performed Back-End testing of SQL queries to fetch the data from the database for validating the output and also executed the stored procedures.
• Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Experience in providing Production Support for 24x7
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Languages: C, C++, T-SQL, PL/SQ Java,, MY SQL

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

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

Front End: MS Visual Basic 6.0

OLAP Tools: MS OLAP Services Manager

Web Server Technologies: IIS 5.1/6.0,, Tomcat

Reporting Tools: Microsoft Reporting services 2005/2008,Crystal Reports

Modeling Tool: ERWIN

Operating Systems: Windows 2000/2003 Advanced Server, Windows Exchange Server 2003, Windows NT 4.0/3.5, Windows9.x, Windows XP, VMware.

Hardware: EMC DMX & IBM Fast T 700 Storage Area Network (SAN), HP, ProLiant DL380 G4, IBM Pseries, Compaq Proliant 8000, 6500, 6000, Dell Poweredge Servers.

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

SQL SERVER DBA

Responsibilities:

• Installed and configured SQL server 2008
• Installed SQL Server 2008 R2 on standalone and cluster environments.
• Worked on setting up transactional replication on dev region
• Installation of SSRS in development and production environment for deployment of Reports.
• 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 DEV and Testing Environment.
• Accept and Resolve the service center tickets for Production environment.
• Involved in Design and Development of the Data Migration project.
• Installing SQL server two node clusters on windows 2008 r2 with SQL server enterprise edition 2008 assuring architectural integrity and production support issues
• Applied hot patches on MSCS (Microsoft Clusters) and Fixed few bugs in Microsoft Cluster and SQL Virtual Servers.
• Created jobs, alerts, activity logs, error logs to capture any possible errors
• Configured MS SQL Server 2008 and Creating databases and configured replication between two database
• Configured and maintained Transactional and Snapshot replication.
• Configured Various Replication Types between Primary Server and Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2008 Environment to Test the Software.
• Installing applications and establish the connectivity with the database.
• Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Involved in creating the access for Oracle database to new users by using Toad.
• Performance tuning, and optimization of procedures and queries.
• Worked with SQL Server Profiler to generate traces.
• Used Notification Services Available in SQL Server 2008 to create alerts and email notification.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Helped Development Team in deploying and testing the application, which uses SQL Server 2008 backend.
• Installed and administered Four-Node cluster Active/Passive on Microsoft Windows Server 2008 Enterprise Edition on DR environment
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Environment: SQL Server 2005/2008(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Reporting Services, Oracle, Toad, Idera

Confidential, Portland, OR

SQL SERVER DBA

Responsibilities:

• Installed and configured SQL server 2008
• Installed SQL Server 2008 R2 on standalone and cluster environments.
• Installation of SSRS in development and production environment for deployment of Reports.
• 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 DEV and Testing Environment.
• Accept and Resolve the service center tickets for Production environment.
• Involved in Design and Development of the Data Migration project.
• Created jobs, alerts, activity logs, error logs to capture any possible errors
• Configured MS SQL Server 2008 and Creating databases and configured replication between two database
• Configured and maintained Transactional and Snapshot replication.
• Configured Various Replication Types between Primary Server and Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2008 Environment to Test the Software.
• Installing applications and establish the connectivity with the database.
• Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Performance tuning, and optimization of procedures and queries.
• Worked with SQL Server Profiler to generate traces.
• Used Notification Services Available in SQL Server 2008 to create alerts and email notification.
• Had good experience in 24/7 production support.
• Helped Development Team in deploying and testing the application, which uses SQL Server 2008 backend.

Environment: SQL Server 2005/2008(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Reporting Services, Oracle, Toad, Idera

Confidential, Palo Alto, CA

SQL Server DBA

Responsibilities:

• Installed and configured the Windows NT/2008, SQL Server 2008.
• Providing 24/7 on call support for all the Production servers.
• Used upgrade advisor tool to check any prerequisites steps to be taken before migrating the Databases.
• Involved in Migration of SQL Server 2005 to SQL server 2008.
• Restored the database on production server or development servers as per requirement.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Involved in Capacity Planning, data modeling and Logical/Physical database Design.
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Configured and maintained Transactional and Snapshot replication.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Designed and implemented comprehensive Backup and Recovery plan and disaster recovery strategies Implemented..
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions
• Helped Development Team in deploying and testing the application, which uses SQL Server 2005 backend.
• Extracted data from different Data sources and transformed the data using Lookup, Data conversion, Derived columns etc. and loaded this data to the destination SQL Server using SSIS.
• Providing support for the Production, Development and QA Servers for SQL Server 2005/20008.

Environment: MS SQL Server 2005,2008 Business Intelligence - SQL Server Integration Services, SQL Server Reporting Services, Visual studio 2005, Erwin, SQL Profiler, Database Tuning Advisor, Database Mail, T/SQL.

Confidential, Plano, TX

SQL Server DBA

Responsibilities:

• Installed and maintained MS SQL Server 2000 on Windows 2003 Server. Worked on SQL Server 2000 failover clustering which is built on top of a Windows 2003 server cluster.
• Upgraded SQL Server 2000 to SQL 2005 server for high volume processing databases.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning and optimizing SQL Server 2008.
• Administrator tasks like managing users, roles and permissions.
• Performance testing on stored procedures, indexes, and triggers.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database
• Used third party tool, Idera Sql defrag tool for performing index defragmentation level
• Performed low-level scripting, fixing of codes and software enhancement process.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Worked on different environments and a key resource for deployment of modified objects to production environments.
• Worked with linked servers and distributed transactions.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Environment: Windows 2003, MS SQL Server 2000, MS SQL Server 2005, T-SQL, Visual Studio.Net 2003, SSRS, Idera, MS Access, DTS, BCP,, SQL Profiler

Confidential, Seattle, WA

SQL Server DBA

Responsibilities:

• Installed and maintained MS SQL Server 2005 on Windows 2003 Server.
• Worked on SQL Server 2005 failover clustering which is built on top of a Windows 2003 server cluster.
• Responsible for integrating data into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation.
• Modeled and designed the architecture of the SQL Server 2005 database.
• Successfully Installed the Service Pack 1 and Hot-fix for SQL Server 2005 in all the Development and Production Environments.
• Responsible for MS SQL Server 2000/2005, configuration, tuning and provide 24 X 7 dedicated support to all Production/staging/development servers.
• Tuned Complex SQL Queries as a part of Query optimization.
• Configured Log shipping from one production server to the staging server.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Job Monitoring and making sure all jobs run successfully every night.
• Used third party tool, LITESPEED to speed up backup operations.
• Monitor SQL Error Logs, Schedule tasks, database activity.

Environment: T-SQL, SQL Server 2000/2005, Windows 2003/NT, Log shipping, Clustering, DTS, LITESPEED.