SUMMARY

• Over 8 years of experience in MS SQL SERVER 2008/2005/2000 Database Development and Administration (DBA) in Windows environment.
• Experience in Installation, Configuration & Maintenance of MS SQL Server 2008/2005/2000 Versions for standalone, windows cluster and HP Polyserve environments.
• Experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Extensive experience on Upgrading and Migrating SQL Server Software to new versions & applying service packs & patches.
• Experience in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 4 Terabytes.
• Experience in implementing and managing Merge, Transactional and Snapshot Replication models.
• Implementation experience on Log shipping with SQL Server 2000/2005 and Database Mirroring with SQL Server 2005 for high availability and disaster recovery procedures.
• Experience in configuring and managing Linked Server, Data transfer between SQL Server and other Databases such as Oracle.
• Good Knowledge on DB2 and Oracle. Worked efficiently on Data transfer from SQL Server to DB2 and Oracle servers.
• Good knowledge in creating and managing user permissions, logins and setting up security according to business standards.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
• Experienced in Creating Databases, Tables, Views, Stored Procedures, Triggers, Functions and Indexes based on Functional Requirements considering System and Logical database design.
• Experience in working with version controlling and database modeling tools for managing SQL scripts and database builds.
• Proficient in Performance Tuning/Query optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor (DTA), DMV’s, DBCC commands and reading Execution plans.
• Good knowledge on using different system monitor object counters and various reporting tools for monitoring and Tuning MS SQL Server Performance.
• Experience on Data Transfer from and to SQL Server Databases using utilities / tools like SSIS, DTS, BCP, BULK INSERT etc.
• Experience on Migrating DTS packages to SSIS packages; worked on building and deploying SSIS packages.
• Knowledge and worked on developing and deploying OLAP cubes through SSAS.
• Knowledge on installing and configuring SSRS on windows environment; also know the process of generating different types of reports.
• Expertise in tuning and generated several default and custom oriented reports from SQL 2005 Performance Dash Board.
• Knowledge about all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
• Excellent Analytical, Interpersonal and Communication Skills & Desire to Excel, Fast learner, Hardworking and Versatile Team Player.
• Knowledge on DB2, Oracle databases

TECHNICAL SKILLS

SQLServer Tools: Enterprise Manager, Management Studio, Profiler, Tuning Advisor, Query Analyzer, DTS, Replication, SSIS, SSRS (Administration), DB Artisan.

Databases: SQL Server 7.0/ 2000/2005/2008 , Knowledge on Oracle 9x/10x and MS - Access

Scripting Languages: T-SQL,PL/SQL,ASP, VBScript, Java Script, PHP, PERL

Web Technologies: HTML, CSS, XML, XSLT, IIS, Front Page

Operating Systems: Windows XP/ 2000/2003/2008/ NT/98/95,Linux,Unix, VMware Virtualization,HP Polyserve, Compaq

ETL and Reporting: DTS,SSIS(SQL 2005),SSRS (SQL2005),HP OVPI and OVPM,MOM

Other Tools: Power Designer, Erwin, IBM Rational Clear Case, Red Gate SQL Backup, Red Gate SQL Compare, Remedy Tool (Pac2000), HP Open view, HP Performance Manager, MS Word, MS Office.

Installation Tools: SQL Server /2008

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SQL Server DBA

Responsibilities:

• Provided support to 75 database Servers. Support included Production, QA and Development.
• InstalledandconfiguredSQL Server 2008/2005 on stand-alone and active/passive clusters on windows 2003 environment.
• Administrated and applied patching on stand-alone, active/passive and HP Polyserve clusters on windows 2003.
• Migrated several databases to SQL Server 2005/2008 from 2000/2005on stand-alone and cluster environments.
• Upgraded database servers from SQL 2000 to SQL 2005.
• Configured and Implemented Log shipping, DB Mirroring and Clustering for high availability of data.
• Created Snapshot and Transactional Replication for SQL Server 2000 and 2005.
• Worked on designing and implementing the SQL Server behind the Firewall which sits out of domain.
• Designed and Implemented regular backup, maintenance jobs and recovery procedures.
• Managed Security by creating login/groups and assigning appropriate permissions
• Configured linked servers to run distributed queries between SQL Server and other data sources using ODBC, OLE DB Drivers
• Involved in Capacity Planning and adding new storage space as needed
• Worked on deploying and migrating DTS Packages and SSIS packages.
• Developed SSIS packages to transform data between various data sources.
• Imported and exported data from heterogeneous sources using various techniques like BCP and DTS
• Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes.
• Developed and configured databases including objects, stored procedures, triggers and cursors.
• Designed and Extracted the DDL changes from the data modeling tools for databases.
• Implemented new T-SQL features added in SQL Server 2005.
• Used different monitoring tools like MOM, HP Openview, DB Artisan and Performance Manager Tools for monitoring server health.
• Provided Secondary Support to IIS Web Servers.
• Deployed database changes using IBM Rational Tool to all environments.
• Processed and Deployed cubes in SSAS.
• Built and extracted different reports using SSRS.
• Gained knowledge on installing the Sybase and Perl files for monitoring and audit purpose.
• Gathered user requirements from users and managers to better understand the business logic and developed required documentation..
• Worked as on-call DBA for 24x7 production support along with other team members.

Environment: SQL Server 2000/2005/2008 Enterprise Edition, Enterprise Manager, Management Studio, Windows 2000 & 2003 Server, DTS, SSIS, SSAS,SSRS,SQL Query Analyzer, Power Designer, DB Artisan, IBM Rational Tool, Secure CRT, Remedy Tool(Pac 2000),HP Openview, HP Performance Manager, SQL 2005 Performance Dashboard, Red Gate Backup and SQL Compare, HP Polyserve.

Confidential, Princeton, NJ

SQL Server DBA

Responsibilities:

• Provided support to 50 database Servers. Support included Production, QA and Development
• Worked on Migration from SQL Server
• Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Worked on Data transfer from SQL Server to DB2
• Restricted developer access to production database servers by creating different users and logins on different databases
• Involved in performance tuning issues by running Profiler Trace and analyzing the output
• Ensured Security by defining access control to data
• Re-architected numerous existing databases for increased performance and scalability
• Wrote complex T-SQL Scripts for generating reports
• Wrote stored procedures and designed triggers
• Generated reports using SSRS
• Configured Linked Servers
• Designed and developed OLAP Cubes using Analysis Services.
• Worked on OLAP and OLTP.
• Interacted with development and testing team
• Involved in Importing and exporting of Databases using various techniques like BCP, DTS
• Analyzed and Installed Security patches as required

Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, Management Studio, Windows 2000 & 2003 Server, DTS, SSIS, SSAS,SQL Query Analyzer.

Confidential, La fox, Illinois

SQL Server DBA/SQL Developer

Responsibilities:

• Built back-end database using programming and scripting language.
• Experience in improving SQL Server Database performance using Index Tuning Wizard, SQL Profiler and execution plans.
• Installed a New SQL server 2005 on windows server 2003.
• Create the disaster recovery plan for production server and development server.
• Support and develop multiple SQL Server Databases and ensure all the developed SQL Server components functions in the production environments.
• Monitor database environments, related jobs end procedures Database tuning & optimization Write and maintain stored procedures Work with database tools and utilities for administration and development
• Sending and Receiving the data and Images using XML technology.
• Running DBCC checks and fixing data corruption in application databases.
• Migration of DTS packages to the SSIS on SQL Server 2005.
• Developed complex stored procedures (T-SQL) for front-end application and reports.
• Maintain Fail-Over and Back-up system through use of transaction logs and Snapshot and Transactional Replication.
• Configured and maintained Log Shipping Environments for the projects.
• Capacity planning - properly sizes and organizes including archive logs; calculate optimum disk space, memory, etc.
• Assisted programmers on writing queries to enable application tuning.
• Manage hardware configurations and considerations for SQL Server environment Recommend security of databases; insure that policies are adhered to when they are approved and implemented
• Documented System and Unit test cases for the modules developed.
• Creating Database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.
• Remotely Manage SQL Server 2000.
• Triggers, jobs & created views and encryption of Stored Procedure on SQL Server 2000.

Environment: MS SQL Server 2000/2005, Windows NT Server, T-SQL, MS Excel, Enterprise Manager, Management Studio, SQL Query Analyzer, SQL Profiler, Replication, DTS packages.

Confidential

SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Server 2000 components
• Designing and testing of Backups and Recovery strategies.
• Designed Logical and Physical Data Models using ERWIN and successfully transformed them into Physical Database
• Managing SQL databases, Security, fine tuning of SQL queries.
• Troubleshooting, Monitoring and Tuning the MS SQL Server for optimum performance.
• Created transactional and snapshot replication on different servers.
• Designing and managing SQL Databases.
• Developing SQL stored procedures, views and triggers
• Worked on DTS Packages and SSIS.
• Designing, testing and implementing of DTS packages
• Responsible to releases from development to test to production environments

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server 2000/2005 Enterprise. Tools: ERWIN, SQL Profiler, SQL Query Analyzer, SQL Server DTS, SSIS, Windows Performance Monitor.