Summary:

• Around 7 years of experience in Database Administration, Design, Development and Support for MS SQL Server 2008,2005, 2000, 7.0 in Production, Testing, Development and Clustered Environment
• Experience in upgrading MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2000 to MS SQL Server 2005
• Experience in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization.
• Experience in providing 24x7 Production support.
• Experience in working high transacted OLTP and OLAP systems.
• Experience in implementing different types of Replication like Snapshot and Transactional.
• Successfully tested and implemented Log Shipping Technique used for hot backup solution for MS SQL Server 7.0/2000/2005/2008 databases.
• Good Knowledge of Installation and Configuration of Clustered Servers in Active/Passive and Active/Active mode.
• Good in Implementing SQL Server security and process control.
• Experience in Performance Tuning and Query Optimization using SQL Server Profiler, Windows Performance Monitor
• Extensively worked on inventory databases.
• Experience in implementing databaseconsistency checksusing DBCC Utilities.
• Experience in Data Modelingusing ERWIN and VISIO.
• Creation and Maintenance of Databases, creating roles and managing user permissions.
• Good Knowledge in Implementing and suggesting RAID technologies.
• Experience in creating packages, jobs, sending alerts using SQL Mail and customized extended procedures.
• Having nice experience of monitoring client servers using SCOM (system center operation manager) tool.
• Connecting remote SQL Servers as Linked Servers and Adhoc SQL Functions like Openrowsets.
• Advanced understanding of SQL Server Disaster Recovery (DR) requirements, capacity planning, MS SQL Clustering, Performance tuning and maintenance plan set up.
• Experience in generatingDrill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals, Parameterized reports in SSRS 2005.
• Expert in creating the cubes and dimensions.
• Strong experience in defining Referenced relationships in SSAS.
• Experienced in defining Granularity with in a measure group and drill through actions.
• Expert in identifying KPIs in SSAS.
• Experience in migration of data by using BCP and DTS utilities.
• Extracting, Transformingand loading of data using SQL Server DTS and SSIS.
• Experience in working with Windows 2003 Server, Windows 2000 Advanced Server and Windows NT Server in Active directory environment.
• Having Knowledge on HP monitoring Tools.
• Experience in upgrading SQL Server to new versions and applying service packs and hot fixes.
• Experience in upgrading SQL Server 2000 DTS packages into SQL Server 2005 Integration Services (SSIS) packages. Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Data Stage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Experience in using SQL Server 2005/2008 Management Studio (SSMS).
• Experience in writing stored procedures, triggers and SQL Queries.
• Experience in using version control tools like Microsoft Visual SourceSafe 6.0.

Technical Skills:

Languages: C, C++, T-SQL, HTML, Java, VBScript, ASP, Oracla 9i, 10g
RDBMS: MS SQL Server 2008,2005, 2000, 7.0, MS-Access 2000, 2003
SQL Server Tools: SSMS, SQL Server Profiler, SSIS,SSRS,SSAS
Front End : MS Visual Basic Version Control Tools: Microsoft Visual source safe 6.0
Data Modeling Tools: Erwin, MS VISIO
Operating Systems: Windows Server 2003, Windows 2000 Advanced Server, Windows DataCenter Server, Windows NT 4.0, Windows XP Professional/Media Center/Standard, Windows 9.x, Unix, Linux.
Other Tools SCOM,Idera SQL Diagnostic Manager, Shareplex,RMAN,.
Hardware DELL PowerEdge 6300 Server, AIX,SOLARIS

• Replication
• DTS(Data transformation services)/SSIS ( Integration Services)
• SSRS ( Reporting Services), SSAS ( Analysis Services)
• Log Shipping
• Database Mirroring
• Clustering
• Performance Tuning
• Backups and Restore
• Database Security

Professional Experience:

SQL Server Sr.DBA Feb 2009 Till Date
Confidential,Kansascity,MO
Confidential, is equitably serving all farmers, ranchers, and agricultural partners through the delivery of effective, efficient agricultural programs for all Americans.FSA makes direct and guaranteed farm ownership (FO) and operating loans (OL) to family-size farmers and ranchers who cannot obtain commercial credit from a bank, Farm Credit System institution, or other lender. FSA loans can be used to purchase land, livestock, equipment, feed, seed, and supplies. Our loans can also be used to construct buildings or make farm improvements. I was working in FSA on Production Support and Migration Project, to do capacity planning, implemented clustering and Replication, created some database objects, DTS /SSIS packages, and Performance tuning.

Responsibilities:

• Created SQL Server Reports using SSRS.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Develop DTS/SSIS packages to extract and transform data.
• Design and created different ETL packages using SSIS from DB2 source to SQL Server as destination.
• Handled large table loads and reporting from different source (Flatfile, Excel..) files using SSIS and sql adhoc queries.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Service.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Created cubes and dimensions for the analysis of sales in specific areas.
• Defined the Referenced Relationships with the measure groups and fact tables.
• Create the necessary indexes to improve the query performance.
• Design, develop and schedule the various DTS package for data migration, bulk load data using BCP, import/export.
• Identify and analyze expensive T-SQL stored procedure by using the SQL Profiler, SQL analyzer and Index tuning wizard.
• Wrote database layer using stored procedures in SQL Server 2008.
• Configured MERGE Replication using Snapshot agent and Merge Agent. (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Responsible for Database backup and recovery such as build the master database; if crash, recover the master and user database in point in time.
• Perform regular reviews of database security and adjust accordingly to ensure access and modification only by authorized users and/or applications.
• Create alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Worked on SSIS packages to import the data from SQL Server, Oracle, Access and text files.
• Creating stored procedures, establishing of indexes on databases. Establishing of access to databases through the use of shell scripts under UNIX.
• Involved in the migration of existing DB environment to a highly available Active Passive Clustering SAN DB environment.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Developing Database Backup Scripts and automating this process.
• Running ad hoc queries, which require system administration security.
• Functioning both as an Application and Infrastructure DBA and performing the activities that accompany each of the responsibilities.
• Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Configured Active/Active and Active/passive SQL Server Clusters.
• Monitoring the event logs and server logs for troubleshooting.
• Designed DDL and DML statements for MS SQL Server 2000/2005
• Upgraded SQL Server 2000 to SQL Server 2005
• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.

Environment: SQL Server 2005/2008, SQL Server 2000,Oracle 10g, Windows Server 2003, Unix, DTS, SSIS,SSAS, SSRS, Erwin, ,SQL Profiler, SQL Server 2000 Enterprise Edition, SQL Server Migration Assistant.

SQL Server DBA Feb 2007 Dec 2008
Confidential,TX

Confidential,is Powering Integrated Healthcare Management™. With technology solutions touching nearly half the U.S. insured population today, Confidential,is uniquely positioned to drive the convergence of core benefit administration, care management and constituent engagement. Confidential,provides premier information technology solutions that enable payers and other constituents in the healthcare supply chain to improve the coordination of benefits and care for healthcare consumers.

Responsibilities:

• Installation and Configuration of SQL Server 2000/2005
• Installation of SP4 for SQL Server 2000 and SP2 for SQL Server 2005.
• Involved in installationof LAN over the entire work area.
• Created and Scheduled SSIS Packages for importing and exporting data to data warehouse
• Backup and Restore databases in SQL 2005 for newly acquired websites
• Used SQL Server Management Studio (SSMS) for monitoring, troubleshooting and deploying database related issues.
• Prepared documentation on Capacity planning of all servers and made recommendations.
• Consolidated various databases and tables in SQL Server 2005
• Design and Implement Clustering as Disaster Recovery plan.
• Test and implement backup strategies
• Created and Implemented SSIS Packages for importing and Exporting data to other data storage like PostgreSQL
• Migrated DTS packages to SSIS packages using ETL tool (Business Intelligence Development Studio)
• Design and created different ETL packages using SSIS from SQL Server source to Oracle as destination.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Service.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Created cubes and dimensions for the analysis of sales in specific areas.
• Defined the Referenced Relationships with the measure groups and fact tables.
• Developed and Tested Stored Procedures
• Used SQL Compare and SQL Data Compare for pushing changes from test servers to production servers
• Extensively documented all the databases, database objects, jobs and the changes made to the database.
• Documentation and Automation of various database related procedures
• Created Linked Servers to move data from one server to another
• Solved issues related to server performance and disk space
• Resolved issues related to query optimization, database optimization and index tuning
• Designed and Implemented DTS packages for reporting
• Generated Simple Reports, Parameterized Reports using SSRS ( Reporting Services)
• Deployed Idera Diagnostic Manager for monitoring SQL Server
• Used extended stored procedures for creating alerts for critical production jobs.

Environment:

Windows 2000 Advanced Server, Windows Server 2003 EE, MS SQL Server 2000, Microsoft SQL Server 2005, SSIS,SSAS, SSRS ,SQL Compare, PostgreSQL,Oracle9i,Idera’s SQL Diagnostic Manager

SQL Server DBA Mar 2006 Dec 2006
Confidential,TN
Confidential,Financial Solutions provides a full suite of technology-based products and services that help community financial institutions improve operational efficiency and customer service, gain a competitive edge in the marketplace, increase profitability and satisfy regulatory requirements.

Responsibilities:

• Upgraded SQL Server 2000 to SQL Server 2005
• Tested and installed SQL Server 2005 SP2
• Migrate DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS)
• Database optimization, performance monitoring and index tuning
• Creating jobs and alerts for monthly and weekly maintenance
• Used SQL Server 2005 Management Studio (SSMS) to develop, deploy and troubleshoot databases
• Data migration from other data storage like Oracle and DB2 using SSIS
• Used ETL tool (BIDS) for creating SSIS packages.
• Expert in Multi Dimensional Expression (MDX) and OLAP cubes.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Service.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions
• Provide 24x7 support
• Implement Log shipping between production and DR servers.
• Tested and implemented Database Mirroring solution for Production critical application.
• Ensure that SQL Server databases are updated accurately and regularly
• Implemented transactional replication for populating reporting database.
• Assist development staff with application design
• Review SQL code, including stored procedures and DTS packages, to ensure performance, integrity, and other project standards are met
• Identify and resolve user login and permission problems.
• Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM.
• Develop and document DR procedures and Change Control procedures.
• Create new databases, tables, and fields for data entry, performing database capacity planning.
• Plan and administer database integrity
• Use Version Control tools

Environment:

Windows 2000 Advanced Server, Windows Server 2003 EE, MS SQL Server 2003, Microsoft SQL Server 2005, SSIS,SSAS, SSRS , Oracle, Microsoft Visual SourceSafe 6.0

Confidential,NJ September 2005 to May 2006
SQL Server DBA

Description: A non-profit organization,Confidential, is the world\'s leading professional association for the advancement of technology. The Confidential, name was originally an acronym for the Institute of Electrical and Electronics Engineers, Inc. I was working in Confidential, on Production Support and Migration Project, to do capacity planning, implemented clustering and Replication, created some database objects, DTS packages, and Performance tuning.

Responsibilities:

• Create Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions
• Implement Capacity Planning
• Implement database standards and naming convention for the database objects
• Implement Transactional Replication for Sales Application
• Create Document for Transactional Replication and production change requests.
• Manage replication and database modifications for replicated objects
• Design, document and implement complex DTS packages and stored procedures.
• Test and implement SQL Server 2000 SP4 to the existing SQL Server infrastructure.
• Support and troubleshoot as required, optimize performance and resolve production problems.
• Create Linked Servers and migrate data from Oracle, DB2 to SQL Server 2000
• Implement process and/or manage transfers of data between external data structures (e.g. flat files, Excel files) and existing databases.
• Create, test, and conduct performance tuning on SQL Server databases using Windows Performance Monitor and SQL Server Profiler
• Develop and implement backup and recovery strategies involving complete database backup/restore, transaction log backup/restore
• Monitor daily SQL jobs, event logs, error logs and performance of the database.
• Investigate and resolve sql process issues using various SQL commands.
• Implemented Active / Passive Clustered Server using SQL Server 2000 and Windows 2003.

Environment:

Windows 2000 Advanced Server, Windows Server 2003, MS SQL Server 2000, Microsoft Office Excel 2003

Confidential,India June 2004 to August 2005
SQL Server DBA

Description: Confidential, is one of the largest banking and financial services organizations in the world. It is a fast growing banking institution across the United States and its current services are primarily based in New York State. Primary role was to implement log shipping, generating scripts to send alerts, performance tuning, creating DTS packages and Deploying 2005 in testing environment.

Responsibilities:

• Deployed 2005 in testing environment.
• Installation and configuration of SQL server 2000 on Dell Servers.
• Apply service pack to keep the database at current level.
• Suggest Disk Capacity, Processors and Memory based on the Capacity planning.
• Implement database standards and naming convention for the database objects.
• Convert the legacy systems data into MS SQL server using DTS packages.
• Develop SQL scripts for maintaining administration tasks.
• Trouble shooting problems, tune SQL queries, monitor the performance of SQL Server using SQL server profiler and documenting them.
• Based on the business need create replication models on different applications.
• Implement Log shipping for disaster recovery plan
• Develop stored procedures, triggers for the application.
• Maintain all the SQL documents including installation and data conversion procedures documents
• Solved critical production problems and performed point in time recovery plans
• Test and implement DTS and BCP for bulk loading of data
• Troubleshoot problems related to log shipping
• Created Indexes on table as per requirement
• Use index tuning wizard to tune the indexes or create new indexes