PAVAN POSANI

SUPPLIER SUMMARY:

Candidate: PAVAN POSANI

Location: Oldsmar, Florida

Last 4 SSN: 9761

MM-DD: 06-08

Interview Availability:

• Phone interview with 24hr notice

• Face to Face interview with 48hr notice

• Available to 2 weeks from the point of offer.

Reason for Looking:

WellCare was recently acquired by Centene, wants to be proactive in search.

Summary:

10+ years of Microsoft DBA experience with SQL Server 2008/2012/2014/2016.

10+ years of experience working with Transact SQL write and tune complicated stored procedures and views utilizing inner and outer.

10+ years of experience diagnosing performance issues both at a database and code level resulting in driving technical solutions to development team.

10+ years of experience troubleshooting production issues in a timely, methodical manner that leads to accurate Root Cause Analysis.

10+ years of experience supporting SQL Server 2008/2012/2014/2016 replication.

10+ years of SQL programming experience.

9+ years of experience with performance tuning tools like SQL Profiler.

Extensive experience supporting and developing SSIS packages.

Has general knowledge of Windows 2012/2016 and hardware.

Has extensive experience supporting multiple production, QA and development servers in large environments.

Has experience in Financial Services industry.

Has experience with stored procedure code, with a strong understanding of triggers, indexing strategies, and effective database maintenance for optimal performance.

Education: Master’s in computer engineering from The UNIVERSITY OF SHEFFIELD - 2005

SUMMARY:

Over 12+ years of experience in Database Administration, Design, Architecture and development as an Operational/Infrastructure SQL Server DBA supporting SQL 7.0/2000/2005/2008/20082/2012/2014/2016.Extensive experience in supporting NOSQL Databases (Mark Logic/Mongo). Work Experience in Major Industrial Sectors such as Health Care, Financial Services, Manufacturing and Technology.

Hands on Experience in Architecting, Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008/2008R2/2012/2014/2016 standalones and Failover Clusters both on Physical and Virtual environments.

Hands on Experience in Architecting, Installing, Configuring, Managing, Monitoring and Troubleshooting No SQL Databases (MarkLogic 8.0/9.0, Mongo 2.4/2.6/3.2/3.4).

Planning and Designing DB Servers with thorough understanding of underlying Hardware to Architect database Servers including Sizing, Capacity planning. Bench marking and Implementation of DR/HA strategies within SQL Server/MarkLogic/Mongo in accordance with RPO/RTO meeting SLA's.

Served as a Primary DBA for HIPPA/FINRA/SOX Complaint Applications for several years working with Internal as well as external Auditors.

Thorough understating of Windows Clustering (Failover) concepts and VMWare.

Thorough understanding of Oracle/MySQL and provided backup Support as well as needed.

Experience in Code Optimization and Improving Efficiency in Databases.

Solid experience and outstanding knowledge of high availability and Disaster Recovery solutions for SQL server, including clustering services, Always ON Availability Groups, Log Shipping and Replication.

Solid experience of setting up Mark Logic DB replication for Disaster Recovery solution.

Solid understanding of SQL Server/Mark Logic/Mongo Internals and outstanding administration skills including Backups/Recovery, Database maintenance, Security maintenance, Troubleshooting, Performance tuning etc.

Extensive experience in managing and administering VLDB (25 TB+).

Extensive experience with SQL Server and T-SQL in constructing Triggers, Tables, Functions, Indexes, Stored Procedures.

Extensive experience of administering/maintaining MSBI solutions - SSIS, SSRS.

Extensive experience in Data Extraction, Transformation and Loading (ETL) Using SQL Server Integration Services (SSIS) in SQL Server 2014/2012/2008/2005 and DTS in SQL 2000.

Solid experience with third Party tools for supporting SQL Server Databases like Quest, Idera, EMC DDboost.

Solid teamwork and negotiation Skills with IT (DBA & Application teams) Management and Developers.

Very enthusiastic to explore new technologies/product enhancements and to mentor other team members as necessary.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2000/2005/2008/2008R2/2012/2014/2016, Oracle10g/11g/12.2 and MySQL 5.1/5.7/Percona.

NOSQL: MarkLogic 8.0/9.0, Mongo 2.4/2.6/3.2/3.4

Languages: T-SQL, Windows batch Scripting, PLSQL.

Web Technologies: HTML, XML, IIS (5.0/6.0/7.0)

Proficient Tools and Software/Services: SQL Server Management studio, SQL Server Enterprise Manager, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Data Tools, SSRS, SSIS, Visual Studio, SQL Server Migration Assistant(SSMA),TOAD for SQL Server, EMC DDboost, Embarcadero DBArtisan, VMware WorkStation, VMware vSphere, VMware VCenter, Oracle Enterprise Manager, PLSQL Developer,SCOM, MS-Office 2007/2010/365 Suite, Quest LiteSpeed, Idera Diagnostics Manager, Idera SQL Doctor, Idera SQL Secure, Red Gate SQL Compare, Red Gate SQL backup,SharePoint Server,Atlas for MongoDB.

Operating Systems: Windows 95-98/Me/XP, Vista/7/8/10 and Windows Server 2000/2003/2008/2008R2/2012/2012R2/2016 and RHEL6/RHEL7.

Data Design/Modeling/Ticketing Tools: ServiceNow, BMC Remedy, CAITSM, MS Visio.

EDUCATION:

UNIVERSITY OF SHEFFIELD, U.K.

Master’s in computer engineering - 2005

EXPERIENCE:

08/2016 to WELLCARE HEALTH PLANS INC, Tampa FL

Present DBA Technical Lead

WellCare Health Plans, Inc. provides managed care services targeted to government-sponsored health care programs, focusing on Medicaid and Medicare. It has a huge SQL Server infrastructure comprising of more than 200 SQL instances in production and up to 600 non-prod SQL instances.

Responsibilities include providing the technical leadership to database team / addressing the database and infrastructure needs working closely with other IT departments/ support and provide a vision to the team on various architectural issues.

Helped save millions of dollars to the company by actively engaging in Consolidating and decommissioning the legacy servers and closing the data centers as part of major acquisitions.

Foreseen the growing business needs of Wellcare and architected the infrastructure requirements with over 300TB of storage spanning across multiple environments / applications.

Helped implementing the SRDF solution for faster recovery of DR servers to meet the RTO and RPC objectives set by BIA ratings.

Set up Multiple Always on Replicas for DR/Read only operations.

Migrated hundreds of SQL Servers from lower versions to higher versions.

Worked closely with the EMC and Storage groups to find out the underlying Disk I/O sub system issues with SAN and come up with the resolutions and optimal SAN configuration for SQL Databases.

Worked Closely with VM Ware team to consolidate VM's across multiple DB clusters into one DB cluster (VM ware Cluster) and saving millions of Dollars on SQL Licensing (Unlimited Virtualization by licensing the nodes in VM Ware).

Responsible for Implementing the Security/backup strategy for each environment.

Responsible for implementing DDBoost for backing up the Databases directly into DataDomain.

Architected/Implemented/Supported/DR NOSQL (Mark Logic/Mongo) Solutions for new applications.

Work with developers and end users to identify business needs and deploy database objects, perform Performance Tuning Optimizations for SQL code as needed.

Participated in quarterly DR tests.

07/2015 to NEW YORK LIFE INSURANCE, Tampa FL

08/2016 Sr. SQL Server Data Base Specialist

New York Life Insurance Company (“New York Life”) is the largest mutual life insurance company in the United States*. Founded in 1845, New York Life is headquartered in New York City, and is one of the most financially strong and highly capitalized insurers in the business.

Member of DBA team responsible for all major SQL server initiatives at NYL.

Provided 24x7 support for the Production DataBases.

Performed complex up gradations and migrations of critical SQL servers from 2005 to 2008R2 and to 2012.

Tuned queries for major applications which improved the performance by 100%(Fair Fax).

Implemented intelligent Indexing strategy for rebuilding OLTP systems.

Created and Managed SQL Server Inventory at NYL.

Created SSRS reports for Management in order to report Data growth metrics and inventory details.

Analyzed space requirements in all environments and made necessary recommendations to add the space.

Installed and configured SQL Server 200R2/2012 Enterprise and standard edition in the production/Development and test environment and applied latest service packs and security fix servers.

Troubleshoot performance issues in ETL while loading the DM.

Captured Execution Plans for SP’s and Adhoc Queries by using Cashed plan DMV’s.

Deployed SSIS packages and Configuration files that are developed by developers into QA and Prod.

Developed and deployed simple SSRS Reports on the portal for user accessibility to display the server statistics.

Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.

Performance Tuning of the SQL Server (in OLTP, Web based, Production and Development environments) including the usage of Performance Monitor and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Context Switches/sec, Page Faults, growth of Tempdb, Cache-Hit ratio, disk reads and writes, Avg. Disk Wait Times, Transactions/sec, Growth and Shrinkage of databases and other counters, and use Index Tuning Wizard to create proper indexes. Identified the performance bottlenecks like CPU, Memory, and I/O and tuned and improved the overall performance of the server for many clients.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Restore Development and Staging databases from production backups as per the requirement.

Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.

Environment: MS SQL Server 2012/2008 R2/2008/2005, SSIS, SSRS, RedGate SQL monitoring.

03/2012 to WELLCARE HEALTH PLANS INC, Tampa FL

07/2015 Sr. SQL Server Engineer

WellCare Health Plans, Inc. provides managed care services targeted to government-sponsored health care programs, focusing on Medicaid and Medicare. It has a huge SQL Server infrastructure comprising of more than 200 SQL instances in production and up to 600 non-prod SQL instances.

Member of Infrastructure Engineering group responsible for all major SQL server initiatives at WellCare.

Active member of Disaster Recovery team and created numerous documents. Recovered Databases in real time disasters.

Provide support for the Production DBA team in resolving complex performance issues.

Performed complex up gradations and migrations of critical SQL servers from 2005 to 2008R2 and to 2012.

Tuned queries for major applications which improved the performance by 60%.

Created transactional replication for 6TB OLTP DB Source to three targets.

Created Materialized views on the Replication targets to speed up the reporting queries.

Created striped backups for large databases to speed up the backup performance.

Implemented page and row level compressions for large Databases.

Supported multiple TB Databases in SharePoint environment.

Developed intelligent Indexing strategy for rebuilding huge OLTP systems.

Created and Managed SQL Server Inventory at WellCare.

Created SSRS reports for Management in order to report Data growth metrics, Replication lags and inventory details.

Created massive 4 node SQL cluster (Active/Active/Active/Passive) and migrated critical Databases in to cluster.

Analyzed space requirements in all environments and made necessary recommendations for DBA team.

Tested many backup tools to speed up SQL server backup performance.

Implemented Symantec net backup for SQL servers and backed up the Data Bases to Data Domain.

Developed scripts for analyzing the indexes on the tables and their usage to gauge the performance of the Database.

Developed custom build scripts for DB monitoring based on application requirements.

Tested and implemented many third-party tools for replicating data to heterogeneous Databases.

Installed and configured SQL Server 200R2/2012 Enterprise and standard edition in the production/Development and test environment and applied latest service packs and security fix servers.

Automated daily, weekly and monthly maintenance tasks such as backups, refresh databases and verifying database integrity and rebuild indexing.

Implemented SQL Server 2012 Always for High Availability in Windows server 2012 64 bit environment.

Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.

Installed and Configured SQLServer 2005, 2008, 2008R2 and 2012 on Stand Alone, Cluster and Virtual environments on Windows 2003 and 2008r2.

Environment: MS SQL Server 2012/2008 R2/2008/2005, SSIS, SSRS, Replication, CA-ITSM Ticketing System, MS-Visual Source Safe, SQL Lite speed console, SQL sentry and Spotlight.

02/2011 to VEREDUS CORPORATION – CERIDIAN BENEFIT SERVICES, St Petersburg, FL

03/2012 SQL Server DBA

Ceridian Corporation is a leading business services company that uses reality-based Know-How to help Companies maximize the power of their people, lower costs and focus on what they do best. It provides a full portfolio of services from human resources, payroll and payment solutions to benefits and health and productivity services. Ceridian helps organizations maximize their human, financial and technical resources.

Patient Billing & Collection system is an end-to-end insurance payment solution for Provider (Dr), Payer (carrier) and Member. The new Payment Assurance model will guarantee full payment for services rendered. The member would, in turn be billed for their portion by Ceridian and provided various methods in which to pay (check, credit card, debit card etc). Ceridian would provide electronically a corresponding consolidated report and consolidated disbursements back to the Payer.

Florida Health Choices project is a different program from traditional health care coverage. It's designed to partnership with community organizations, insurance companies and others to create a new insurance marketplace. It allows small businesses to enroll into the program and offer their employees a wide variety of health coverage options provided by private companies.

Responsibilities:

Installed and Configured SQL Server 2005 and 2008 on Stand Alone and Virtual environments on Windows 2003 and 2008.

Involved in Physical and Logical design of databases for all Projects that uses SQL Server as backend.

Used Enterprise Architect to develop logical database models and to convert them in to physical model.

Active member of the Requirements engineering team to gather requirements from business to decide the project scope.

Documented and delivered Functional Specification Document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.

Database design, including optimizing the database schema and coding database procedures/queries.

Developed XML schemas and XML files by using X-queries from Database to Business rules engine for validating the rules.

Created Linked Servers between SQL server 2008 and Siebel Databases (Legacy system).

Configured Data Base Mail for sending automatic mails on the failure and success of the scheduled job.

Configured and worked on Lite Speed to generate Compressed DB backups.

Configured and worked on SpotLight to trouble shoot the Performance issues in Production Environment.

Developed and used DDL Triggers to capture the schema changes in Development environment to replace the version control tool.

Involved in both types of up gradations (In place and Side by Side) from SQL server 2000 to 2005 and 2008.

Involved in capacity planning of SQL Server for ongoing and new projects.

Designing and building data load procedures, using MS SQL Server.

Created packages using Integration Services for data extraction from Flat Files, Excel Files OLEDB etc to Access etc.

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Constant monitoring and performance tuning of SQL Server database, checking the most expensive queries.

Used DMV’s in 2005 and 2008 for tuning the long running and resource intensive queries.

Captured Execution Plans for SP’s and Adhoc Queries by using Cashed plan DMV’s.

Designed and developed ETL process for loading the Data Mart.

Troubleshoot performance issues in ETL while loading the DM.

Configured and worked on Transactional Replication between OLTP and Reporting Environments.

Deployed SSIS packages and Configuration files that are developed by developers in to QA and Prod.

Developed and deployed simple SSRS Reports on the portal for user accessibility to display the server statistics.

Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.

Performance Tuning of the SQL Server (in OLTP, Web based, Production and Development environments) including the usage of Performance Monitor and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Context Switches/sec, Page Faults, growth of Tempdb, Cache-Hit ratio, disk reads and writes, Avg. Disk Wait Times, Transactions/sec, Growth and Shrinkage of databases and other counters, and use Index Tuning Wizard to create proper indexes. Identified the performance bottlenecks like CPU, Memory, and I/O and tuned and improved the overall performance of the server for many clients.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Restore Development and Staging databases from production backups as per the requirement.

Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.

Environment: SQL Server 2000/2005/2008, Visual Studio 2005, ASP.NET, VB.NET, SharePoint 2003, EnterPrise Architect, BizTalk 2006, Windows 2000/2003, Oracle 9i/10g, IBM Tivoli 6.1, BMC Patrol, VERITAS Net backup 6.5, SQL Litespeed 5.0 and Crystal Reports 9.0, IIS 6.0

05/2008 to HUMANA INC., Louisville

02/2011 Sr. SQL Server DBA/Developer

Project: Clinical Care Application

Humana Health Insurance Company is the leading provider for Insurance policies online and has become the preeminent provider of cutting-edge service offering for its customers. The Clinical Care Application (CCA) Project mainly deals with the authorization of the claims and Re assigning the case if the claim is not approved. The Objective of CCA is to automate the tracking of the claims, it makes a lot easier to authorize the claims according to the Business requirement.

Installed and Configured SQL Server 2005 and 2008 on Stand Alone, clustered and non-clustered environments on Windows 2003 and 2008.

Design the architecture of the entire project flow and integration with third party tools. Interfaced with Business in understanding the present functionality and defining the phases in which the development would be done.

Involved in Physical and Logical design of databases for new application.

Interfaced with Business as part of the Requirements engineering team to finalize the project scope.

Implemented SSIS for data transformation logic process.

Database design, including optimizing the database schema and coding database procedures/queries.

Documented and delivered Functional Specification Document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Designing and building data load procedures, using MS SQL Server

Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files

Configured product meta-data tables to support client data reporting needs.

Created packages using Integration Services for data extraction from Flat Files, Excel Files OLEDB etc to Access etc.

Constant monitoring and performance tuning of SQL Server database, checking the most expensive queries.

Member of the team responsible for both types of up gradations (In place and Side by Side) from SQL server 2000 to 2005 and 2008.

Involved in capacity planning of SQL Server for ongoing new projects.

Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.

Used DMV’s in 2005 and 2008 for tuning the long running and resource intensive queries.

Captured Execution Plans for SP’s and Adhoc Queries by using Cashed plan DMV’s.

Implemented Disaster Recovery Solutions, Log shipping and Replication in SQL 2000, SQL 2005 and SQL 2008.

Implemented High Availability Solutions, Clustering and DB Mirroring in SQL server 2005 and 2008.

Designed and developed ETL process for loading the Data Mart.

Troubleshoot performance issues in ETL while loading the DM.

Responsible for delivery of Critical reports on a daily basis which are having SLA’s.

Developed reports from DW using Discoverer and OBIEE.

Deployed SSIS packages and Configuration files that are developed by developers in QA and Prod.

Created Policies for the DB’s by using PBM feature in SQL Server 2008.

Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.

Monitor and tune both server and databases using DBCC, Server configurations options (sp_configure) and Database options (sp_dboptions). Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis.

Performance Tuning of the SQL Server (in OLTP, Web based, Production and Development environments) including the usage of Performance Monitor and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Context Switches/sec, Page Faults, growth of Tempdb, Cache-Hit ratio, disk reads and writes, Avg. Disk Wait Times, Transactions/sec, Growth and Shrinkage of databases and other counters, and use Index Tuning Wizard to create proper indexes. Identified the performance bottlenecks like CPU, Memory, and I/O and tuned and improved the overall performance of the server for many clients.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Provide 24 X 7 supports to all production servers.

Restore Development and Staging databases from production backups as per the requirement.

Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.

Prepare daily report on the job failures, backup failures and disk space.

Automated the Production Deployment process by using the Extended Procedures (XP).

Environment: SQL Server 2000/2005/2008, Visual Studio 2005, ASP.NET, VB.NET, SharePoint 2003, BizTalk 2006, Windows 2000/2003, Oracle 9i/10g, IBM Tivoli 6.1, BMC Patrol, VERITAS Net backup 6.5, SQL Litespeed 5.0 and Crystal Reports 9.0, IIS 6.0

06/2007 to BANK OF AMERICA, Jacksonville, FL

05/2008 SQL Server DBA

Bank of America is one of the nation's leading financial institutions. It provides complete banking services, asset management and innovative products for customers. Bank of America provides 24 hours online web access to its customers to login into their account and perform various online activities like check balance, transfer available funds from different accounts, etc. Worked on both TSYS Ts2 (Third Party Credit Card Processor) application and Banking Online Application where customer can login and view current and past account information, account summary, view and edit personal profile, perform various secure online activities.

Developed System Standards, System Architecture, Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.

Involved in designing of Conceptual Logical Model and Physical Model

Design/Build Extract Transform Load procedures in SQL Server 2005 to import/export data feeds to/from data warehouse and claim systems

Worked Extensively with SSIS to import, export and transform the data between the linked servers

Migrated few objects from SQL Server 2000 to SQL Server 2005

Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.

Involved in Capturing Requirements, Preparing Business Blocks UML Use Cases, Collaboration Sequence, and Activity diagrams, defined and Managed as Part of CMM.

Created databases and specified automatic growth options.

Tuned the database to perform efficiently by managing databases using the option grow or shrink database files and monitor the size of transaction log.

Responsible for data transfer and replication over internet between the offshore development site and onsite implementation site.

Created named backup devices to back up the server regularly.

Wrote various T-SQL stored procedures and Triggers to carry out various tasks

Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.

Designing and building data load procedures, using MS SQL Server

Generated database SQL scripts and deployed databases including installation and configuration

Created Packages using Integration Services.

Written complex SQL statements using joins, sub queries and correlated sub queries.

Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA

Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.

Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.

Provide 24 X 7 supports to all production, development, staging and clustered servers.

Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.

Used Microsoft Source Safe for version control and configuration management.

Environment: SQL Server 2000/2005, Visual Studio 2005, ASP.NET, VB.NET, Windows 2000/2003, Oracle 9i/10g, SQL Litespeed 6.5 and Crystal Reports 8.0, IIS 6.0.

01/2007 to WHIRLPOOL CORPORATION, St Joseph, MI

06/2007 SQL Server DBA

Whirlpool Corporation is the world's leading manufacturer and marketer of major home appliances, with annual sales of more than $18 billion. I am a part of the DBA team which involved in Migration from SQL Server 2000/SQL Server 7.0 to SQL server 2005 and SQL Server Data Bases Production Support. Our group maintained Over 45 SQL servers this includes (production & QA servers). Production support is 24x7.

Installing and Configuring SQL Server 2005.

Applied Service Pack 2 for SQL Server 2005 and security patches.

Created Databases, created tables and provide constraints and user defined rules and defaults.

Implemented High Availability Technologies in SQL Server 2005, Data Base Mirroring

Configured Principal Server, Mirror Server and Witness Server for implementing Data Base Mirroring.

Tuned the report queries & stored procedures for performance.

Created Maintenance Plans for backups and Optimization tasks on both production servers and Development Servers.

Scheduled Maintenance Plans On a daily and weekly basis.

Configured Data Base Mail for sending automatic mails on the failure and success of the scheduled job

Created logins with permissions in SQL Server 2005 as per the developer’s request.

Created Linked Servers between SQL servers 2000/SQL Server 7.0 and 2005 servers.

Involved in Migration from SQL Server 2000 / SQL Server 7.0 to SQL Server 2005.

Generated scripts, procedures for Migrating Users, Logins and Jobs from SQL Server 2000/SQL server 7.0 to SQL Server 2005.

Restore Development and Staging databases from production backups as per the requirement.

Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.

Prepare daily report on the job failures, backup failures and disk space.

Converted DTS packages into SSIS packages from SQL Server 2000 to SQL Server 2005.

Monitoring disk space and system performance monitor daily for the best performance of the servers.

Used Quest tools for monitoring SQL Server (Quest Spotlight for SQL server).

Used BCP to import and export data from a flat file to SQL Server database.

Involved in resolving dead lock issues and performance issues.

Environment: MS SQL Server 7.0/2000/2005, Windows 2000/2003

Contact this candidate