SUMMARY

• Over 7 years of SQL Server database administration, development & performance tuning experience
• Extensive experience in installation, configuration and migrating of Data in MS SQL Server 2000, 2005 and 2008 versions
• Experience in Design and Creation of Logical and Physical Database.
• Extensive experience and knowledge in T - SQL - DML, DDL, DCL, Transactions, Stored Procedures, Triggers and Functions
• Hands on experience in troubleshooting database issues, debugging SQL Server stored procedure/triggers and documenting issues/resolutions of SQL Server Applications.
• Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checksusing DBCC Utilities
• Experienced in Configuring SQL Server as per the company standards and create the maintenance plan for new installed servers
• Experienced in creating backup strategy for production, test and development servers
• Involved in database restore requests and refresh the database between productions, test servers
• Experienced in trouble shooting database issues and maintains the SQL Server to provide maximum availability
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005, 2008 with Experience on working other RDBMS such as Oracle 10g, MySQL and DB2
• Hands on experience in backup and restoration of databases, automating Administration, Security maintenance, and troubleshooting client-server applications
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency
• Hands-on working experience with analyzing query plans, Code Reviews, managing indexes and locks, troubleshooting deadlocks
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries
• Experience in Migration from SQLServer 2000 to SQL Server 2005/2008
• Extensive knowledge in Tuning SQL queries, T/SQL queries & improving the performance of the Database
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional
• Successfully tested and implemented disaster recovery techniques like Log Shipping (manual and with wizard), database mirroring for MS SQL Server 2008, 2005, 2000 servers
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data
• Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures
• Experience in creating Clustered and Non Clustered indexes on tables
• Good knowledge of System Development Life Cycle (SDLC)
• Hands on Experience in using Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance
• Experience in upgrading from MS SQL Server 7.0 to MS SQL Server 2000 and MS SQLServer 2000 to MS SQL Server 2008, 2005
• Experience in creating Jobs, Sending Alerts using SQL Mail
• Supported the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours
• Strong inclination for finishing job within project deadline and good time management skills
• Extremely attentive, strong team player with ability to take new roles and work in high pressure environments
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2005/2000, Oracle 10g/9i

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Integration Services (SSIS),Analysis Services (SSAS),Reporting Services(SSRS),Enterprise Manager, Query Analyzer,SQL Profiler, Database Tuning Adviser etc.

BI and Other Tools: Erwin,Crystal Reports,BO,Informatica,Visual Studio 2005,Visual Source Safe 2005

Languages: T-SQL, Oracle SQL and PL/SQL,VB 6.0,VB Script,HTML

Web Servers: IIS 5.0/6.0

Operating Systems: Windows 2008/2003/2000/ NT 4.0,Windows XP,Unix,Linux

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. SQL Server DBA / Developer

Responsibilities:

• Set up and monitor allSQLexecuted within websites to identify poor performingSQL. PrimaryDBAresponsible for monitoring and isolatingSQLperformance issues within OLTP systems
• Provide operational support and maintenance for daily backup and recovery jobs. Provide logical and physical database design, administrative programming, disaster recovery, and DA/DBAstandards (internal and external)
• Migrate database object changes through multiple development and production environments
• Develop and implement plan to move current production databases from remote Canada host location to centralized Colorado office. Recently upgraded fromSQLServer cloud environment
• DBAactivities like analysis ofSpace Availability,Backup and Restoring
• Scanned thedata pages, Indexes and checked the storage space used by each table
• Scheduling and scripting Jobs
• Tracking healthof the Server
• Configuring andmonitoring Replication /Log shipping
• MonitoringSQLServerPerformance and Activity

Environment: MS SQL Server 2000/2005/2008, Windows Enterprises 2003 servers, LiteSpeed, SSIS, BCP, SQL-Profiler, Diagnostic Manager

Confidential, Schaumburg, IL

SQL Server DBA

Responsibilities:

• Involved in Maintenance of Database, Performance Tuning, Backup, Recovery and other database related activities
• Took Backups on scheduled time and monitored the status using custom scripts and email notifications
• Performed user management by creating/dropping users, granting and revoking privileges as per the process
• Checked the Alert logs for any database errors
• Conducted daily Performance Monitoring of all the databases
• Diagnosed and resolved Database issues
• Involved in the Design (Logical & Physical) of Databases
• Documented the Backup and Recovery procedures
• Handled other daily management activities
• Defined backup procedures using daily hot backups and weekly cold backup

Environment: Windows 20008/2003 Advanced Server, SQL Server 2005/ 2000, T-SQL, Microsoft Visual SourceSafe-2005/Visual Studio 2005

Confidential, Pasadena, CA

SQL Server DBA

Responsibilities:

• Installation of Microsoft SQL Server 2005/2008, Service packs, Hot fixes in Cluster and standalone environment
• Configuration of the server using server tools and server stored procedures
• Create jobs/maintenance plans for Databases health-check, distributing the workload for optimum performance
• Provide 24/7 support for the SQL servers on QA, Production servers
• Develop SQL scripts for maintaining administration tasks using system stored procedures
• Monitoring database growth for maintaining server performance, storage, capacity planning etc
• Write stored procedures, functions and triggers based on the requirement
• Plan, implement and support database Backup\Restore and Disaster Recovery
• Import data from Flat Files, XML files, Oracle to SQL Server databases using DTS/SSIS, BCP, BULK INSERT utilities
• Maintain database response times, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats
• Plan, configure and monitor Log shipping and Replication
• Identify and tune the slow running queries in a poorly performing application
• Design and create DTS/SSIS packages for large volume data and migrate between Development and QA Servers
• Actively took part in creating shared disk, adding dependencies to the servers, moving the servers between different nodes of the cluster from cluster admin
• Participate in disk storage management on RAID 10 for the Windows OS, SQL Server
• Implement MS SQL Server security policies and granted object level permissions
• Troubleshoot and monitor of MS SQL Server issues
• Execute DBCC commands for integrity check, fragmentation, statistics, re-indexing, shrinking files and databases, etc.
• Reorganize data files on different disks for optimal performance of the databases
• Install and configure of Quest LiteSpeed 2005

Environment: MS SQL Server 2000/2005, Windows 2003 Server, SSIS, SSRS, MS Visio, T-SQL, Business Intelligence studio, Management Studio, Quest LiteSpeed

Confidential, New York, NY

Oracle DBA

Responsibilities:

• Involved in 24x7 support forboth production and development databases with on-call pager
• Installation and creation of 9i and 10g databases for Testing, Development, Production including configuration, backup & performance tuning
• Refresh/Cloning of Database and applications for development, testing
• Installation and Maintenance of Stand by databases
• Conducting sizing& capacity planning for Oracle databases
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required
• Designing the logical and physical database structure
• Designing the security and database access strategies
• Logical and Physical data modeling
• Taking Backups on scheduled time and monitoring scheduled Backups
• Performing backups and recoveries using RMAN conventional hot backups
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options includingRMAN
• Partitioning Strategies for very large tables
• Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views
• Performing SQL*Loader jobs for data loading
• Data refresh from production to test and development, maintain Database Security
• Performed block recovery using RMAN. Performed backup validations using RMAN
• Database monitoring, troubleshoot and resolve the issues
• Management of schemas, objects partitioning the tables & indexes
• Automation of data load using shell scripting and SQL*Loader
• Responsible for setting and managinguser accounts, Granting required privileges to users
• Defining and Implementation of backup and recovery strategies
• Optimization and tuning SQL queries using TRACEFILE, TKPROF, EXPLAINPLAN
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service when required
• Writing scripts for the system and database for effective functionality and report generation

Environment: OracleServer 10g/9i, SQL, Windows XP, Sun Solaris

Confidential, Reston,VA

Database Administrator

Responsibilities:

• Installed, upgradeand ConfigureSQLServer 2000 & 2005 in development, test, and production environment
• Extensively worked onData partitioningandSnapshot isolationinSQLServer 2005
• Performed daily tasks including backup, and restore by usingSQLServer 2005/2008 tools likeSQLManagement Studio,SQLServer Profiler,SQLServer Agent, and Database Engine Tuning Advisor
• MonitoringSQLServer performanceusing profilerto find performance and dead locks
• Monitored and modified performance using execution plans andindex tuning
• Rebuild the indexesat regular intervals for better performance
• Implementation ofSQLLogins,RolesandAuthentication Modesas a part of Security Polices for various categories of users
• Imported data from Oracle and Excel toSQLServer DatabasesusingDTSInvolved indisaster recovery
• Rebuild Servers(Restore & Recovered from tape/CD backup) from backup
• ConfiguredLog Shippingfrom Production to Standby Server (Running as Reporting Server)
• Designed and created databases, tables, views,stored proceduresandtriggers
• Configured and MaintainReplications(Transactional)
• Designed and implemented monitoring tool for capturing Log Events for Production Servers performance monitoring and alert messages for blockings
• Performance tuning & index tuningDeveloped DatabaseMaintenance Plan
• Export & Import data from other data sources like flat files using Import/Export throughDTSandSSIS
• Worked onSQLServer tools like Enterprise Manager andSQLQuery Analyzer
• DBAactivities like analysis ofSpace Availability,Backup and Restoring
• Scanned thedata pages, Indexes and checked the storage space used by each table
• Configuring andmonitoring Replication /Log shipping
• MonitoringSQLServerPerformance and Activity
• Create andre-evaluate Indexesand made needed modifications for better performance
• Query Optimization,troubleshooting, Tuning databases for performance
• Scheduling ofDTS/ SSIS Packages and Deployment

Environment: SQLServer 2000/2005,Visual Basic 5.0, and Win NT

Confidential, Salt Lake City, UT

Database Administration

Responsibilities:

• Installed andConfigureSQL Server 2000, 2005 in development, test, and production environment
• Installed, Configured and MaintainedSQLServer 2000 and 2005
• InstalledandMaintenance PlanConfigured Operating System, Windows Server (2000 & 2003 )
• Migrated databases fromSQLServer in test and production environment
• Configured andMaintained Replications(Transactional)
• WritingT-SQL,Stored-Procedures,andtriggers
• Performance tuning &index tuning
• AssistSQLdevelopers tooptimizeSQLqueriesand Stored Procedures
• CreatedBackup strategyfor production and development environment
• DatabaseBackup & Restore
• Scheduling jobs through SQL Server Agent
• Monitor Servers activity, solving problem
• SQLServerError Log, space usage
• RunDBCCstatements to check physical and logical consistency of the database and Rebuild indexes
• Extensively experience in usingDTS,BCPto import & export data from flat files, excel andMS Accessto MSSQLServer databases
• MigratedMS Access 2000/97databases into MSSQLServer
• Imported data fromOracle,Excel, Flat file,CSVfile toSQLServer Database
• Work experience and strong knowledge indisaster recovery
• Rebuild Servers(Restore & Recoveredfrom tape/CD backup) from backup
• ConfiguredLog Shippingfrom Production to Standby Server

Environment: SQL Server 2000/2005, DTS, Oracle 9i, Windows 2003

Confidential

SQL DBA / Developer

Responsibilities:

• Created logins and maintained permissions appropriately
• Managed disk space, memory and user connections
• Involved in installing and maintaining MS SQL Server 2000
• Involved in requirement gathering, analysis, design, development and deployment.
• Created Databases
• Updated and maintained customer information onto client machines
• Creation of Database Objects using T-SQL - Tables, Indexes, Views, Roles
• Creation of Customized Stored Procedures, Triggers, Cursors
• Involved in job scheduling using MS SQL server Agent
• Responsibilities also included transferring of customer, personal financial history information from various ODBC driver files to SQL server database files using DTS
• Frequently ran DBCC checks to maintain consistency
• Performed Data transfer (Import & Export) using BCP
• Performed Full Back up, Recovery and Restoration
• Created Linked Servers to connect OLE DB data sources and providers
• Wrote distributed queries for Linked Servers
• Monitored the performance of Database Server & Tuning for Better Performance
• Optimization of SQL statements for customer summary reports
• Designed ER Diagram and mapped that data into database objects
• Wrote Triggers (After and Instead of) and stored procedures to capture updated and deleted data from OLTP systems
• Created Views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected
• Created Indexes on columns having high selectivity and low density to speed the execution of data retrieval queries and stored procedures
• Provided necessary data validation checks against the data entry
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Configures SQL mail agent for sending automatic emails when DTS process fails or succeeds
• Used Crystal Reports and MS Access to write complex formulas and query database to generate different types of Ad-hoc reports

Environment: SQL Server 2000, Oracle 9i, Crystal Reports 8.5, MS Access, XML, Web Services and Analysis Services