PROFESSIONAL SUMMARY

• Experienced in designing and implementing complete Software Development Life Cycle (SDLC) for client servers and database applications.
• Designed and documented Logical and Physical Data Models.
• Experience in relational database modeling using tools like CA Erwin and Microsoft Visio.
• Expert in installation and configuration of MS SQL Server 2008, 2005 & 2000 in different 32/64 bit environments.
• Expertise in Installing and configuring SQL Server 2008/2005 Active/Active and Active/Passive clusters on 32/64 bit Window Server 2003 and Window Server 2008 .
• Expertise in migration of SQL Server 2000 to SQL Server 2005/2008,SQL Server 2005 to SQL Server 2008 , 32/64 bit in cluster and non-cluster environments.
• Implemented Database Mirroring as High Availability in SQL server 2005 & 2008.
• Expertise in implementing Log Shipping as backup solution for MS SQL Server 2000/2005/2008 databases.
• Highly experienced in implementing Replication Models such as Transactional, Snapshot and Merge in SQL Server 2000, 2005 and 2008 in OLTP environments.
• Excellent skills in developing Backup & Recovery procedures and Database Security procedures to maintain Data Integrity.
• Expert in developing and documenting the backup and disaster recovery plan.
• Expertise in Promoting the SSIS/DTS Packages from Dev
• Highly experienced in Developing DTS/SSIS Packages for data extraction, transformation, and loading from various heterogeneous sources.
• Experienced in developing and deploying complex reports using SSRS (Reporting Services)
• Experienced with Data Warehousing (OLAP) methodologies such as star schema, snowflake schema and Dimensional Modeling
• Hands on experience in building SSAS data cubes and populating data marts
• Highly Experienced in SQL Server performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC and DMV’S
• Expertise in monitoring the production server with native tools like SQL Profiler, Window System monitor.
• Expertise in identifying, troubleshooting issues and documenting root cause analysis.
• Experienced in configuring and managing Linked Server, Data transfer between SQL Server and other Databases
• Experience in providing 24X7 support.
• Experience in working with quality assurance and version controlling tools
• Superior communication, presentation, documentation, analytical and problem solving skills.

Certificate of Excellence from Microsoft:

• Microsoft MCTS: 070-431: Microsoft SQL Server 2005 – Implementation and Maintenance
• Microsoft MCTS: 070-443: Microsoft SQL Server 2005 -Designing a Database Server Infrastructure
• Microsoft MCITP: 070-444: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

Technical Skills:

MS SQL Server 2008, 2005, 2000, MS Access 2000, 2003, Oracle

Operating Systems

Windows 2008, 2003, Windows 2000, Windows NT 4.0, Windows 95/98/ XP

Languages

T-SQL, C++, XML , Java Script

Data Modeling Tools

Erwin, MS VISIO 2003

Other Tools

SQL Diagnostic Manager (by Idera), SQL LiteSpeed, Spotlight, Crystal Reports, MS VSS 6.0, BMC Remedy

Professional Experience:

Confidential, San Antonio, TX Nov 09 to Till Date SQL Server DBA

Description:

Confidential, is one of the world’s largest investment management organizations with assets of around one trillion USD under management. It comprises a group of investment management companies, including Capital Research and Management, American Funds, Capital Bank and Trust, Capital Guardian, and Capital International.
Responsibilities:

• Install and configure SQL server 2008/2005.
• Migrating and upgrading SQL instances from SQL 2000 to SQL 2008/2005 in dev/test/production environments.
• Planned, installed, configured and maintained the SQL Server 2008 in Environment of Active/Active Cluster.
• Project DBA for one of the Tier 1 applications. Activities - Installing/configuring SQL server, patching, troubleshooting, performance tuning.
• Primary DBA for various assigned servers of the Tier 1& 2 applications in development/test/staging/production environments.
• Migrated and modified the DTS Packages to SSIS Packages and did the Optimization of the Packages.
• Promoted the SSIS Packages in different Environments like QA, Staging and Production.
• Populated the Database tables from heterogeneous source of the business clients using the SSIS Packages.
• Worked with Development team in recoding the complex DTS packages to SSIS packages.
• As a Proactive DBA wrote the SSIS packages to monitor the Performance of SQL Server, Log Space.
• Optimization and Performance tuning using Idera’s SQL Diagnostic Manager, SQL Profiler, Performance Monitor and SQL Nexus.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks.
• Optimization of Stored procedures, Slow running Queries and indexes.
• Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging
• Set up and supported environment with transactional replication for the in-house reporting.
• Set up and supported Database mirroring as High Availability solution for critical operational databases.
• Promoting new databases in different using Red gate SQL compare and SQL Server Management Studio.
• Actively involved in capacity planning/requirement analysis and I/O capacity using SQLIOSIM.
• Experience in load Testing and implementing the changes to Staging servers and Production servers.
• Preparation in Weekly, Monthly system maintenance report for Database backups.
• Providing 24 X 7 supports for production environment.

Environment: Windows server 2000/2003/2008, MS SQL Server 2008/2005/2000, Idera’s SQL Diagnostic Manager, SQL Litespeed, SQL Nexus 3.0, SQLIOSIM, Red-gate SQL Compare.

Confidential,San Diego, CA Jul 08 to Oct 09
SQL Server DBA

Description:
Confidential,is a leading manufacturer of audio, video, communications, and information technology products for the consumer and professional markets. Sony one of the most comprehensive entertainment and technology companies in the world. Sony\'s principal U.S. businesses include Sony Electronics Inc., Sony Computer Entertainment America LLC, Sony Pictures Entertainment Inc., and Sony Music Entertainment.

Responsibilities:

• Involved in Migration of Databases from SQL Server 2000 to SQL Server 2005/2008
• Installed , Configured and maintained the SQL Server Cluster 2005 on Windows Server 2003
• Configured and Monitored Database Mirroring for Application Development environment
• Involved in Installation, configuration and maintenance of the Reporting Services on Web Farm.
• Configured and maintained Database mirroring for transferring the Archived Data to the Report Server.
• Involved in Deployment of Reports using SSRS with Scale-Out topology
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Migration of DTS packages to SSIS packages.
• Involved in the tuning of the DTS and SSIS packages.
• Worked with Development team to create the SSIS packages for the business requirements.
• Used the ETL functionality of SSIS to retrieve/send the Data from/to the heterogeneous sources.
• Configured Transaction Replication on the Production server.
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.
• Used Idera’s Diagnostic Manager and Performance monitor for monitoring SQL Server Activities and keep a real time check on health, availability and performance of SQL Server.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine tuning.
• Handled Scheduled backups and restore operations with Litespeed 5.0 and monitored the tasks and Maintenance plan.
• Involved in writing Stored Procedures and Functions, Cursors to handle different tasks.
• Preparation in Weekly, Monthly system maintenance report for Database backups.
• Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity etc.
• Provided 24x7 supports to SQL application developers in implementing the applications on production server.

Environment
Windows Server 2003, MS SQL Server 2000/2005, Quest‘s Spotlight, LiteSpeed5.0, CA Erwin 4.0

Confidential,King of Prussia, PA Mar 07 – Jun 08
SQL Server DBA/Developer

Description:
Quest Diagnostics Incorporated is the world\'s leading provider of diagnostic testing, information and services. A United States based corporation that provides clinical laboratory services, the company has operations in the United States, United Kingdom, Mexico and India. Quest Diagnostics also has collaborative agreements internationally with various hospitals and clinics. Quest Diagnostics is a member of the Fortune 500 and the S&P 500.
Responsibilities:

• Involved with maintenance of ACTIVE/PASSIVE Cluster Environments.
• Worked on SQL Server 2005 with latest Service Packs.
• Involved in moving SSIS packages between various environments including Dev, QA, Staging and Production
• Maintaining Dev, QA, Staging and Production servers in sync.
• Connecting SQL servers remotely using Terminal services.
• Wrote and tuned the SSIS packages according to the business requirements.
• Migrated and modified the DTS pack to SSIS packages.
• Deployed the DTS/SSIS packages.
• Set up jobs to schedule SSIS packages using SQL Agent.
• Developed Ad-hoc and customized reports using SQL server reporting services (SSRS)
• Created complex SSRS reports using complex expressionsto calculate, group, filter, parameterize and format the contents of a report
• Configured reporting services and managed reporting security by creating groups and granting access to report folders and Ad-hoc reports as required
• Involved in a team for implementing Data Warehousing (OLAP) methodologies such as star schema, snowflake schema and Dimensional Modeling using Analysis services SSAS.
• Involved in building SSAS data cubes and populating data marts.
• Created Database Maintenance Planner for the Performance of SQL Server which covered Database Integrity Checks, Update Database Statistics and Re-indexing.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
• Used BCP and Bulk Insert utilities.

Environment: Windows Server 2003, MS SQL-Server 2005/2000, SSIS, SSRS, Idera’s SQL Diagnostic Manager, Quest’s Litespeed, Erwin

Confidential,India June 04 – Dec 06 SQL Server DBA/Developer
Description:
Confidential, is a world-leading provider of telecommunications equipment and related services to mobile and fixed network operators globally. Over 1,000 networks in more than 175 countries utilize our network equipment and 40 percent of all mobile calls are made through our systems. We are one of the few companies worldwide that can offer end-to-end solutions for all major mobile communication standards. Ericsson is a leading provider of telecommunication and data communication systems, and related services covering a range of technologies, including handset technology platforms.
Responsibilities:

• Installed, Configured and maintained the SQL Server 2005
• Review / test / apply all database changes to all environments including QA, Development and Production Servers. Monitor SQL Error Logs, Schedule Tasks, database activity, eliminate Blocking & deadlocks, user counts and connections/locks etc.
• Worked with SQL server Profiler to generate traces.
• Actively participated in Logical design phase of new database.
• Solved issues related to server performance and disk space.
• Resolved issues related to query optimization, database optimization and index tuning.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity.
• Wrote and tuned the DTS/SSIS packages to cover the business needs.
• Deployed the DTS/SSIS packages.
• Server & Application fine-tuning & trouble shooting.
• Monitoring MS SQL Server performance, identifying the issues and resolving the issues.
• Monitored the SQL Server using the Microsoft Operation Manager.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Configured Log shipping from one production server to the reporting server.
• Configured the Database mirroring and log shipping in the SQL Server instances as High Availability.
• Involved in configuring and maintaining the merge replication for the business users.
• Designed, implemented and documented the Disaster Recovery Solution.
• Created and maintained the SQL Agents jobs and configured them to send the alerts and email on failure to DBA group.
• Creating the jobs for running the packages automatically.
• Good in Implementing SQL Server security.
• Implemented and documented proactive monitoring scripts for production databases.
• Reviewed the SQL Server Error Logs and Application Logs to resolve the issues.
• Develop the reports for business users using Crystal Reports.

Environment:Windows 2000 server IIS 5.0 , Window Server 2003 IIS 6.0, MS SQL Server 2000/2005, Crystal Report , Microsoft Operation Manager ( MOM), Visual Source Safe.