SUMMARY:

• IT Professional With 8+ Years in Database Administration, Architectures, Virtualization, Design, Development & Support in Production and Development With a Primary Focus on MS SQL Server 2000/2005/2008.
• Worked on MS SQL Server 2000/2005/2008 installation, configuration, performance tuning, Production trouble shooting, and client/server installation.
• Strong Knowledge in implementing high availability solutions using Replication models, Log shipping, clustering and knowledge of DB mirroring in SQL Server.
• Implemented different types of Replication Models like Snapshot, Merge and Transactional.
• Configuring Distributor, Publisher, Subscriber and familiar in setting up all types of Replication.
• Managed High availability of databases using primary- standby database setup using log shipping to the other servers. Also scheduled jobs for automation of database tasks.
• Configured database DB Mirroring with Synchronous and Asynchronous mode to maintain, prevent from the disaster recovery.
• Successfully Implemented SQL Server Fail over Clusters in Virtual Environment
• Detection and resolving of blocking and deadlocks using Profiler, DBCC utilities and DMV’s and improved query performance by adding covered indexes, adding file groups.
• Performed DBA activities like administering and maintaining the database, Partitioning, Indexing Large databases, space management, Security, database tuning, database backup & recovery
• Designed backup and recovery strategies, Designed and implemented pre and post processing programs for the data warehouse transformation process.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Created, altered, maintained system roles and permissions to users on various database objects. Designed role based security to managed users activities.
• Managed object level permissions and security issues on the server
• Responsible for Query less execution time, performance tuning and Optimization and fragmentation of data file and segments.
• Expertise in Resolving database performance issues, database capacity issues, replication, and other distributed data issues
• Extensive experience in Server Installation, Configuration, Upgrade and Maintenance Patch management using SQL Server Tools like Database Maintenance Plan Wizard, DTS Import/Export Wizard, Index Tuning Wizard, Replication Sync Manager (Replication Wizard), SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer
• Experience in MS SQL Server Configuration, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands
• Extensive experience in Performing Server Monitoring using Microsoft Performance Monitor, SQL Server Profiler, Database Engine Tuning Adviser, Trace Log, counter logs and Create Database Usage Reports.
• Hands on Experience in System and Database Virtualization VMware ESX 3.x, VMware Server 1.4, Virtual Center 2.5, MS Virtual Server 2005 R2
• Excellent skills in migration ,database Backup, Restore, Recovery, Replication, Linked servers, Database Maintenance Plans and scheduling jobs, alerts and email notifications.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Extensive experience in Database Upgrade, SQL Server 2000 to SQL Server 2005
• Experience with T-SQL in constructing Triggers, Tables, User Defined Functions, Views, Indexes and Stored Procedures.
• Excellent Communication Skills and Presentation Skills, Comprehensive problem solving abilities.

SKILLS:

Relational Databases: SQL Server (7.0, 2000, 2005, 2008), MS Access, Oracle 11g, 10g, 9i
Querying/Reporting: T-SQL,PL/SQL, SQL * Plus, SQL*Loader, TOAD,ORACLE.
Reporting Tools: SSRS,Tableau,Cognos 8,Microsoft Clustering Services (MSCS),Crystal Report.
ModellingTools: SQL Server Analysis Server 2005(SSAS),ER-win.ER-Studios
ETLTools: Microsoft Integration Services (SSIS).
DataMiningTools: Microsoft Analysis Services(SSAS).
Server Scripting: ASP, PHP, JSP.
DataMiningModels: Classification, Association Rule Mining, Clustering.
ProgrammingLanguages: C, C++,JAVA,PL/SQL,.Net.
Documentation Tools: Latex, MS Office (Including MS Project, VISIO).
Web Portal Technologies: HTML, Photoshop, SharePoint, Visual Studio, Ms Front Page, PHP.
Operating Systems: Windows (98, 2000, NT, XP), Windows Server 2000/2003, UNIX.

EDUCATION:
Bachelor of Engineering

CERTIFICATION:
Microsoft SQL Server 2005 Implementation & Maintenance (MCTS)

Confidential, Westlake Village- CA
SQL Server DBA. (Aug’09 – Present).

Confidential, is a global marketing information services company operating in key business sectors across a variety of industries, including market research, automotive forecasting, performance improvement, Web intelligence, and customer satisfaction. The project that I worked is a Power Information Network (PIN) and Jaguar & Land Rover (JLR), which uses Microsoft SQL Server 2008 R2 and Microsoft 2008 advanced datacenter Servers, including 4 sets of cluster servers.

Responsibilities:

• Upgraded the Existing SQL Server Data base version 2005 to the SQL server 2008.
• Designed and implemented the Clustered Server environment for high availability both in Physical and Virtual Environments.
• Implemented and maintained Database Replication and Developed the Stand alone Database for Reporting Servers.
• Worked with DBCC Commands for Consistence Database Integrity.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Worked with SQL Server Performance Monitoring Tools like Microsoft Performance Monitor, SQL Server Profiler and Helped in Database Consistency.
• Worked in Generating Trace Logs and Counter logs in monitoring the Server traffic and Run the DB Usage reports in Hourly bases.
• Worked in Developing and Tuning Tones of Stored Procedures at different levels of database security and maintenance.
• Set up database backup and recovery strategies Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery.
• Used Integrated Services (SSIS) to load data into SQL Server from Different RDBMS like Oracle and DB2.
• Maintaining and Trouble Shoot Oracle RAC and worked on Oracle Environment at different administration tasks like Database Back up, Parallel Query Options, RMAN.
• Worked on Off Shore/ON Shore model.
• Worked as a lead for different Ad hock projects in the On Shore and Off Shore models.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Worked on Different Operational system like Windows 2008/Solaris and UNIX.
• Successfully Integrated the SQL SERVER Replication services with the Share Point Servers.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index defragmentation.
• Worked on Production Migrations according to the Business Logics.
• Worked on Database security by creating the Roles and granting the Permissions.
• Developed maintenance plans for index maintenance and database backups.
• Generated database SQL scripts and deployed databases including installation and configuration
• Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery.
• Used Batch files to import data from other databases
• Developed logical data model using ER Studio.
• Derived physical database design from logical data model.
• Developed Silver light interface that integrates with the SSRS.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications both on SQL server and Oracle.
• Created multiple Read only servers using the Replication to handle tons of connections.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Created the logical and physical data modeling using Erwin tool.

Environment: SQL Server 2000/2008 Enterprise, Windows Enterprise Server 2003, ORACLE 11g, IIS 6.0, .NET,UNIX, ER-Studios, Microsoft Visio 2003,SSRS, SFTP, Oracle RAC,DB2,Microsoft Silver light, Microsoft Reporting Services, DB2, Share Point Server, Cluster Environments, Solaris, SSIS, Oracle Clustered Environments, Oracle Replication environments .

Confidential,Irving TX
SQL Server DBA (Nov’08 –Aug’2009).

Confidential, one of the biggest telecommunication companies in the Unites States, provides not only wireless and wire communication but also broadband internet access service as well, serving 53 million customers nationwide; The project that I worked is a National Sale Tracking (NST) system.

Responsibilities:

• Responsible for Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application and web app teams. Project involved guidance and adherence to standardized procedures for planned data center consolidation for worldwide centers using in-house corporate and third party applications based on SQL 2005 in upgrade project to SQL 2008.
• Monitoring of database size and disk space in Production, Staging & Development environments
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
• Worked in team for Project and Database Architecture in Production/QA/Test/Development Environment.
• Worked in Team in Developing Database from Scratch using SQL Server 2008
• Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered in enterprise Data Centers Patch applications.
• Worked and Documented in Disaster Recovery and System Security.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Maintained cluster servers to provide high availability
• Set up database backup and recovery strategies Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Worked on Network Protocols like TCP/IP, Named Pipes.
• Configured Database mail, linked servers in SQL server 2008.
• Worked with Erwin tool in Data modeling.
• Worked on Biztalk Server and other Business Process management Tools.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.
• Good Knowledge of using SSRS (SQL Server Reporting Services).
• Installed and configured SQL Server Cluster server in SQL Server 2005.
• Performed 24/7 Production support and on Call duties.
• Executed Change management scripts on weekly basis.
• Worked on VMware for transforming the SSIS Packages.
• Documented up gradation procedures from MySQL to SQL Server and Oracle to SQL Server.
• Created monitoring scripts to alert for production issues.
• Migrated Databases from MySQL, Oracle, IBM Informix, to SQL Server 2005.

Environment: SQL Server 2000/2008 Enterprise, Windows Enterprise Server 2003, BizTalk Server 2004, IIS 6.0, .NET,UNIX, Erwin, Microsoft Visio 2003,SSRS, SFTP, DB2,Microsoft Reporting Services, MySQL , Cluster Environments, Oracle 11g.

Confidential,Wilmington DE
SQL Server DBA (Jan 2007 – Oct 2008)

Confidential, an non-profit organization, is one of the biggest companies in Education Loan industry. The company is No. 1 originator in one of the Federal Education Loans, Graduate PLUS Loan, for 2007. The projects participate are CompaignManagement, MarketMeasure, and Student Loan Service System (SLSS) etc.

Responsibilities:

• Hands on Experience in Installing, Configuring, Managing, monitoring andtroubleshootingSQL Server 2005/2000/7/6.5.
• MS SQL/Oracle DBA infrastructure support Provide support on remote production and development servers in US, clustered/non clustered environment DBMS Maintenance, backup and recovery Implement, configure,administer replication and log shipping Installation/upgrade, patch application, db migration.
• Strong in database development including designing and developing databases, writing stored procedures, Queries, functions, triggers, DTS/SSIS packages for SQL Server databases.
• Troubleshooting the VM machines using Virtual center and VMware Infrastructure client.
• Provided support to active/passive cluster and Experienced in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Use of Native tools like Performance Monitor, Profiler and External Tools like Quest Spotlight for Performance Monitoring and Tuning of MS SQL Server 2000/7.0 residing databases onSAN storage.
• Administer patches, updates, and upgrades. Develop and implement plans for data migration.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Log shipping and SQL Server ECC 6.0 High Availability clustering.
• Configuration and Importing Data from Oracle 8i/9i/10g Server (or other data sources) to MS SQL Server 2000 using Linked Servers on OLE DB Provider and Data Transformation Services (DTS).
• Validated the configuration and performance of the existing databases including data file allocation, index, fragmentation and the impact on system performance. Analyzed potential to avoid and optimize problems like delayed response, locking, server down time, etc.
• Maintain & improve high availability and disaster recovery strategies for the database and fail-over Dr Site and Back methods.
• Good Knowledge on monitoring Tools like BMC , Tivoli , SQL guard.
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery
• Experience in tuning of Stored Procedures and query optimization to improve the performance and eliminate the deadlock situations and hang-ups on server.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database.
• Administration including Planning, Installation, Deployment/Implementation, Advanced Configuration of MS SQL Server 2005 in a clustered/non-clustered environment, Log shipping, Database Mirroring, Database snapshots.
• Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication.
• Detection and resolving of blocking and deadlocks using Profiler, DBCC utilities and DMV’s and improved query performance by adding covered indexes, adding file groups.
• Expert in Extracting and Transforming data using DTS in SQL Server 2000, SSIS in SQL Server 2005, SQL Server Import Export, Bulk Insert and BCP.
• Wrote ActiveX and power shell scripts to create custom DTS transformations, in addition to using built-in DTS transformations. Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
• Experienced in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

Environment:SQL Server 2000/2005/2008,MS Access, EXCEL, VBScript, Vmware, HTML, XML, Visio, , Windows Server 2000/2003, ASP.NET, C#, VB.NET,BIDS.

Confidential,Chicago, IL
SQL Server DBA ( Jan 2005 – Dec 2006)

Confidential,is a leading pharmacy chain, mail service, and pharmacy benefit manager, with specialty pharmacy operations in 49 states. The company also operates worksite health centers, home care facilities and specialty, institutional and mail service pharmacies. Walgreens is one of the three largest drug store chains in the United States. The system utilized multiple databases hosted on Oracle and SQL Server.

Responsibilities:

• Installation of SQL Server (2000 and 2005). Upgrade and migration of SQL 2000 MSDE to SQL 2000 full versions. Upgrade and migration of SQL 2000 to SQL 2005. Identifying inefficient server settings and database options of existing servers/databases change as necessary.
• MSSQL/Oracle DBA offshore support Provide support on remote production and development servers in Canada and US, clustered/non clustered environment DBMS Maintenance, backup and recovery Installation/upgrade, patch application, db migration. Resolve problem tickets thru Remedy system Monitor database production utility jobs for errors, correct problems and upgrade as required.
• Health reporting and root cause analysis Provide documentations for all changes, setup and development contributions Provide on call support and ensure all production database servers are available depending on SLA agreement .Database Performance & Capacity Monitoring, Tuning Planning and Reporting Monitor critical database performance components and space utilization and their respective thresholds.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and constraints.
• Experienced in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Good working knowledge with designer tools such as Microsoft Visio, Rational Rose.
• Handled database server tuning, application tuning, maintaining documentation, space planning, capacity planning and database security
• Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, and flat file, XML in order to create and maintain a centralized data warehouse.
• Configured Replication methods like Snapshot replication, Transactional replication and Merge replication.
• Performed DBA activities like administering and maintaining the database, Partitioning, Indexing Large databases, space management, database tuning, database backup & recovery.
• Performance Monitoring using SQL Profiler, Performance Monitor, planning for CPU and Disk space requirements and db maintenance and optimization using DBCC commands.
• Planning, administration, and implementation of Snapshot, Merge, and Transactional Replication of MS SQL Server Databases, successfully configured/administered transactional replication using MS SQL Server 2000.

Confidential
SQL Server DBA (Feb 2003-Sep 2004)

Provident, Confidentail,provides a full range of commercial & individual banking products and services. The bank primarily engages in generating deposits and originating loans. Its deposit products include savings accounts, money market, and time deposits. My responsibilities in this bank were to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which include the administration of various bank databases in both development and production environment.

Responsibilities:

• Installed and configured MS-SQL Server 2000
• Design, Develop and Maintain database architecture
• Design and implementation of database maintenance plan
• Database Optimization and normalization of database and tables
• Installing and configuration of SQL Server 2000
• Two-node cluster using an Active/Passive configuration.
• Installation, tuning and testing of Cluster Servers.
• Backup and restoring databases from Production Environment.
• Design and Implementation of user log in and security
• Data ware house design and implementation for Key Management Report
• DTS for Import from Oracle & Excel for Analysis server
• Implementation of Web & Application Report writing using Crystal Reports 8.5
• Implements, documents policies and procedures for ensuring the security and integrity
• Job, Scheduling, batch, alert and Email notification setting.
• Knowledge of Database Performance monitoring tools.
• Maintain & improve high availability and disaster recovery strategies for the database and fail-over methods
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Set up Replication environment (Transactional & Snapshot method used) to replicate data.
• Maintaining & Monitoring Alert/Schedule to make smooth replication process

Environment: SQL Server 2000 & 7.0, Windows 2003 and Windows NT, .Net Frame Work, ADO.Net, VB.Net, ASP.Net, Crystal reports 10, IIS ,Crystal Enterprise. SQL Diagnostic Manager, Quest SQL Spotlight EE.

Confidential,Mumbai, India
SQL Server DBA (May’2002 to Jan’2003)

Designed and developed Management Information and Advisory System for an Administrative Office of the Bank controlling and monitoring under its jurisdiction 45-bank branches. Responsibilities included studying the existing system and propose changes for the new system.

Responsibilities:

• Looked at the reports and fixed bugs in stored procedures, tables and ETL process.
• Data, mostly scientific, being highly confidential even within the organization, required high levels of security being applied throughout the processing in the SQL Server.
• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Used DTS, T-SQL, scripts, stored procedures and views to run routine reports.
• Maintained a good client relationship by communicating daily status and weekly status of the project.
• Managed requests that came from the client as well as the development teams.
• Designed and developed the logical and physical model of the database using ERWIN.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, and Indexes.
• Created and automated regular jobs.
• Managed and monitored system utilization.
• Managed backup and disaster recovery of the team.
• Managed the security of the servers (Logins and users).
• Developed complex T-SQL code for the application.
• Designed stored procedures and triggers for automating tasks.
• Worked on complex data loading (implemented the batch data cleansing and data loading).

Environment: MS SQL Server 2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data,