SUMMARY

• Over 8+ years of IT experience on Database Administration and development with MS SQL Server technology.
• Experience in System Analysis, Design, and Administration & Development of MS SQL Server 2008, 2005, 2000, 7.0 in Production, QA, and Development environments.
• Hands on experience in Installation and Configuration of SQL Server 2000/2005/2008 technology, service packs and hot fixes.
• Best Performance winner in Confidential .
• Expert in using different recovery models simple, full and bulk - logged depending on availability of database.
• Experienced and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping, and Database Mirroring.
• Expert in Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Hands on experience with IBM TWS for alert creations and monitoring Performance and make use for recovery purposes and scheduling the jobs accordingly.
• Experience with SQL Server 2000, SQL Server 2005, SQL Server 2008 installation, administration and management of multiple instances/servers in highly transactional environments.
• Solid experience in performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Good understanding in implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.
• Design Data Warehouse, Data Mart, and On-Line Transaction Processing oriented architectures
• Expert in automating the system by using Notification service and creating alerts, jobs and Maintenance plans.
• Expert in working in Data Center.
• Performed Database operations using Silver Light.
• Experience working with Production (7 x 24) and Development environment remotely.
• Extensively worked and had good knowledge on Integration and Reporting Services and good experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2008/2005/2000 /7.0
• Collaborated on numerous management initiatives, including Data Security, Data Management & Data Retention & Resource Tracking, Change Control, and Disaster Recovery Planning, High Availability.
• Worked on administration tasks such as Data loading, batch jobs, Data unloading, backup and recovery, user and application table management, upgrades, creating Databases, file groups, files, transaction logs.
• Experienced in creating and optimizing tables, indexes, schemas, views.
• Extensive experience in managing the Database Security at granular level.
• Hand full of experience in using third party tools like Redgate, idera, Spotlight, Sql tuner, Sqlexpert, Litespeed etc.
• Administered SQL Server 2005 Instances using Windows Power Shell Scripting.
• Used SiteMinder to create a query scheme which defines the SQL queries to authenticate users against the DB, get attribute information, etc.
• Expert in constructing triggers, stored procedures, user functions, views, indexes, user profiles, data dictionaries, and data integrity using T- SQL.
• Well Experienced in implementing and monitoring disaster recovery solutions like Database Mirroring and Log Shipping.
• Extensive knowledge in developing and deploying ETL packages using, DTS, Informatica, SSIS for accessing heterogeneous data, data cleansing and auditing.
• Expert in using MS SQL Server tools SSIS, SSRS, and SSAS.
• Expertise in Data Modeling tools such as Erwin, MS Visio, and ER/ Studio Design Tool.
• Expert in logical and physical modeling for OLTP and OLAP applications.
• Ample of experience in data warehousing using star schema and snow flex schema.
• Ample of knowledge in Relational Database Management Systems (RDBMS) & Entity Relationship Diagram (ERD).
• Conversant with all phases of Software Development Life Cycle involving System Analysis, Design, Development and Implementation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS

RDBMS: MS SQL SERVER 7.0/ 2000/2005/2008 , Analysis Server 2000/2005, Ms Access 2000/2005.

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor(DTA), Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Jobs and task creating and scheduling, MS Visio, Crystal Reports 10.0, SQL reporting, SSIS, SSAS

Programming Languages: SQL, TSQL, XML, PL/SQL, C, C++, VB 6.0, Perl, HTML, XML.

Web Tools: MS-Front Page, Internet Information Server(IIS),FTP,TCP/IP,LAN,MS-Outlook Express

Operating Systems: Windows 95/98/2000/2003/ XP/NT 4.0, Linux, Novell Netware, MS-DOS.

Utility Tools: MS Office, MS Project, Clear Quest, Visual Source Safe 6.0, Rational Clear Case.

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

Sr SQL Server DBA

Responsibilities:

• Ensure regular Database backups and implementing tests on backups and generating reports.
• Creating databases and logins with permissions in SQL server 2008 as per the developer’s request.
• Taking Database fullBackup, Transaction log backup & differential backup in daily Routine.
• Solving Tickets on Daily Basis for Production Issues.
• Worked on database activities not limited to resolving performance issues, utilizing high availability options, create/drop/offline database, solving job failures, start stop sql services.
• Monitored database status, instance status, blocks, errorlog.
• Created and monitored backup and space reports.
• Provided 24 x 7 Production support for the database and application issues.
• Created logins, users, roles and granted access.
• ManagedDatabase backupand restorein all environments.
• Ensure all databases are backed up.
• Worked on database maintenance activities.
• InstalledSQL Server 2008 R2on windows 2008 R2 and 2003 servers, applied service packs and security fix for production servers.
• Managed Multiple SQL Servers in Production, Development and QA Environments.
• Develop, modify and maintain Database support procedures.
• Fine tuned Stored Proceduresto improve performanceandcaptured SQL Traces usingSQL Profiler.
• Resolved performance related issues like long running queries, Blocking and Deadlocks.
• Worked on DatabaseupgradeandMigration.
• Worked oninstallation, configuration,andupgradeofMS SQL Server R2 servers.
• Worked on building queries, stored procedures that meet business needs.
• Experiencein trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Worked on relocating of Databases from one server to another server.
• Set up ports for different environments.
• Performed maintenance activities like analyzing/rebuilding indexes, update statistics based on business needs.
• Gathered workload and collected Profiler traces and analyze them using database engine tuning advisor.
• Implemented high availability options like Log shipping, Database mirroring, Clustering and Replication.

Environment: MS SQL Server 2008/2005/2000 Enterprise Edition, Business Intelligence Development Studio(BIDS) - SQLServerIntegrated Services (SSIS), DTS,SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, Notification Services, T- SQL,Windows server

Confidential, Sacramento, CA

Sr SQL Server DBA

Responsibilities:

• Microsoft SQL Database Administration including 2005, and 2008 R2 DBA technologies;
• Manipulating data using Microsoft SQL Server Integration Services (SSIS);
• Modeling Relational and dimensional database including both logical and physical; and
• Developing database reports using Microsoft SQL Server Reporting Services (SSRS).
• Support database functionality for CCHCS' reporting demands;
• Optimize SQL instances;
• Monitor database health and stability for all CCHCS applications at all times;
• Change Management oversight and tracking;
• Act as a Database Administrator (DBA) security Subject Matter Expert (SME);
• Monitor transaction rates;
• Resolve production issues through technical problem solving;
• Work closely with end users to develop test plans;
• Develop migration strategies in consultation with CCHCS staff and management; and
• Provide ad-hoc database administration support on a daily basis.
• Identify the application owner for all SQL databases and develop Service Level Agreement (SLA) Levels;
• Identify the Patient Health Information (PHI) security requirements associated with CCHCS databases;
• Provide HIPPA security protection for all data elements as required;
• Provide administrative controls through change management;
• Monitor databases for uninterrupted business support;
• Install database patches; and
• Provide SME report(s) to CCHCS management and related-stakeholders.
• Develop proposals for system enhancements;
• Develop proposals for system and database security improvement(s);
• Develop proposals for system and database standards; and
• Develop plans and proposals for database consolidation.

Environment: SQL Server 2000/2005/2008 , SQL ServerIntegrated Services (SSIS) and SQL Server Reporting Services (SSRS),Database Engine Tuning Advisor, SQL Agent, SQL Profiler, Database Mail, Windows2003/2008 server.

Confidential, Redmond, WA

Sr SQL Server DBA

Responsibilities:

• Installed, upgraded and configured SQL Server 2008 that resembles the production configuration.
• Handled up to 3 TB Size databases with clustered and replication environment.
• Detached database from Sql server 2005 and attached to Sql Server 2008 using SSMS.
• Provided 24 x 7 Production support for the database and application issues.
• Defined report layouts including report parameters, Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005/2008.
• Backup and restore the databases from old environment to new environment.
• Identified and categorized the problems in existing database in SQL server 2005 using Upgrade Advisor.
• Responsible for developing, monitoring and deploying SSIS packages.
• Experience in Migration from SQL Server 2000 to SQL Server 2005 and SQL server 2008 as well as DTS Exchange tool for migrating DTS packages to SSIS packages.
• Loaded data from various sources like flat files, to SQL Server database Using SSIS Package.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed
• Defined report layouts including report parameters, Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005/2008.
• Daily periodically monitored performance using both System Monitor and Profiler.
• Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.
• Reconfigured Log Shipping and Database Mail after migration.
• Ensured security logins and database access permissions.
• Involved in setting up, managing and maintaining High availability technologies: Log shipping, Mirroring and Replication
• Extensive experience with data modeling, Dimensional modeling, logical and physical database design.
• Created Notification and alerts for replication jobs failure.
• Involved in supporting client Data Center from locations.
• Wrote and edited stored procedures, functions and triggers required for sql agent jobs.
• Implemented and maintained Transaction replication for high availability.
• Use replication stored procedures to create scripts to automate the transaction replication once databases are refreshed.
• Ran DBCC CHECKDB on all the databases to verify database integrity.
• Planned the backup and recovery for Publisher and Distribution servers.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping

Environment: MS SQL Server 2000/2005/2008 , Business Intelligence - MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS),SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, T- SQL,Windows2003/2008 server.

Confidential, Cincinnati, OH

Responsibilities:

• Regular Database backing up and implementing tests on that backup and generating reports.
• Creating databases and logins with permissions in SQL server 2008 as per the developer’s request.
• Relocation of Databases from one server to another server using attach and detach database.
• Extensively worked on Dynamic Management Views (DMV’s) to get the information about executed T- SQL statements.
• Used Idera SQL safe backup which provides a high-performance backup and recovery solution.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2008/2005.
• Involved in Data modeling, designing and building relational databases using Erwin tool.
• Rebuild the indexes at regular intervals for better performance.
• Implemented log shipping between two instances of server using Database.
• Experience in SQL Server Reporting Services (SSRS) Installation and Configuration for Scale-Up and Scale-Out topology.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Developed and deployed ETL packages using SSIS and Converted DTS packages into SQL Server 2005 Integration Services.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Developed, monitored and deployed SSIS packages.
• Setting up, Configuring and troubleshooting Log Shipping for databases on Disaster Recovery (DR) servers
• Monitored the server usingidera tools.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Maintained the database consistency with DBCC at regular intervals.
• Used ETL packages to move logins and jobs from one server to another server.
• Monitored SQL server performance using profiler to find performance and dead locks.
• Done general technical trouble shooting and give consultation to development teams.

Environment: MS SQL Server 2008/2005 Enterprise Edition, Business Intelligence Development Studio(BIDS) - SQLServerIntegrated Services (SSIS), DTS, SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, Notification Services, T- SQL, Windows 2003 server, Idera Sql safe backup.

Confidential, New York, NY

MS SQL Server DBA

Responsibilities:

• Problem identification, troubleshooting, resolution, and index tuning databases.
• Responsible for MS SQL Server 2005, configuration, tuning and provide 24 X 7 dedicated support to all Production, development and clustered servers.
• Involved in Data Migration from SQL 2005 to SQL 2008.
• Managing the VERITAS clustering environment.
• Generated various monthly reports with the help of SSRS 2008.
• Installation of 32 bit and 64 Oracle 10g client and applied DST Patches for Oracle Linked servers.
• Worked on the server and keep it running. Concerned with backups, security, patches, and replication.
• Implementation of Immediate Transactional Replication to reduce the workload on servers.
• Worked on building queries, stored procedures that meet business needs.
• Tested and implemented Database Replication solution for Production critical application.
• Use replication stored procedures to create scripts to automate the transaction replication once databases are refreshed.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Developed and implemented Disaster Recovery Plan and Procedures.
• Created the logical and physical data modeling using Erwin tool.
• Managed the use of disk space, memory, processor and connection.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosed and tuned the server optimal performance using SQL Server 2005’s Dynamic Management Views (DMV), Profiler and Index Tuning Wizards.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.

Environment: MS SQL Server 2008/2005/2000 , T- SQL, SQL Query Analyzer, SQL server Agent, DTS, Windows server 2003 Replications, Log Shipping, Data Modeling

Confidential, Reston, VA

SQL Server DBA

Responsibilities:

• Configured and Installed SQL Server 2005.
• Developed, modified and optimized complex stored procedures, triggers and user defined functions.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Resolved the SQL Server 2005 upgrade hurdles and successfully Migrated SQL 2000 DTS packages to SSIS using Upgrade advisor and Package Migration wizard.
• For complex packages like password protected packages, packages created using SQL Native client used DTS Xchange tool.
• Additionally, designed and implemented a disaster recovery system.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Maintained the use of disk space, memory, processor and connection.
• Implemented regular database backup and recovery tests.

Environment: MS SQL Server 2000/2005, Windows Server 2000/2003, SQL Agent, SQL Profiler, DTS, T-SQL.

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Installed and Configured SQL server 2000.
• Created and managed objects such as tables, views, stored procedures, and triggers and User defined functions using T-SQL commands.
• Checked slow running queries and tuned.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins.
• Used DBCC commands to check the database consistency.
• Used SQL profiler to check the database performance.
• Implemented regular database backup and created logins.

Environment: Windows Server 2000, SQL Server 2000, T-SQL, SQL profiler, T-SQL.