SUMMARY

• Over 7 years of IT experience in SQL SERVER Database Administration, System Analysis, Design, and Development & Support in Production, QA, Replication and Cluster Server Environments.
• Experience in installation and configuration of MS SQL Server 2008 R2/2005/2000 versions.
• Experience in Migration from SQL Server 2000 to SQL Server 2005/2008 R2 as well as DTS Exchange tool for migrating DTS packages to SSIS packages.
• Installed and created SQL Server software and databases on UNIX/ NT servers.
• Strong noledge Database Design & Architecture principles.
• Exposure to Oracle programming and Architecture.
• Experience in up gradation/Migration of MS SQL Server 6.5/7.0 to MS SQL Server 2000 and now 2000 to 2005 and 2008 by in place upgrade process and Side by Side process
• Experience inmigration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and loading of data using SQL Server DTS.
• Installing SQL Server in a Cluster Environment.
• Expertise in planning and implementing MS SQL server security and database permissions
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Extensive experience with Storage Capacity planning, including system storage allocation, on - going capacity analysis and planning future storage requirements.
• Experience in IIS, MTS, and Windows NT administration.
• Experience with upgrades and service pack installations Tuning and normalization.
• High level proficiency with various types of Replication Models such as Snapshot, Transactional and Merge Replication (Planning, Replication Tools, Implementing Replication).
• Extensive experience in Capacity planning, Maintenance planning, Performance Tuning.
• Proficient in monitoring SQL Server Performance using SQL Profiler (Dead Locks/Long running queries), Query Analyzer, Index Tuning Wizard, Database Engine Tuning Wizard and Windows Performance Monitor.
• Extensive noledge of Relational Database Management Systems.
• Hands on experience and outstanding noledge in high availability solutions, including SQL Server clustering, replication, Log shipping, and Mirroring.
• Managed the multiple databases (DB) under clustered (active/active, active/passive) and implementing RAID technology.
• Experience in Extraction Transformations and Loading (ETL) tools like Data Transformation Services (DTS), Bulk Insert, and BCP for OLTP and DSS (Data Mart/Data Warehouse) environment.
• Good experience in monitoring Windows and SQL Server error logs.
• Experiences in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC, resolve Dead Locks/Long running queries.
• Strong SQL Server Administration skills using various backup strategies, Model (simple, bulk and full), database maintenance plan, user (NT/SQL) security authorizations, database creation.
• Very good hands on experience with DB Artisan admin tool and SQL Assistant tool.
• In depth noledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views using SSMS and SQLCMD.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures and triggers through query analyzer
• Design entity relationship diagrams and dimensional data models.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Managed day-to-day User activities like creating logins, granting permissions, applying security for new users and creating user Roles and Role Members to ensure Security.
• Supported the deployment of SQL Server 2005/2008, SSAS (Analysis Service), SSRS (Reporting Service) and SSIS (Integration Service for ETL activities).
• Designing and building the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
• Experience with ER-win data modeler for generating physical and logical schemas. Generating DDLs scripts and Forward and Reverse Engineering Databases.
• 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.
• Created DTS and SSIS Package designs for Import/Export from accesses, oracle and Sybase to SQL Server.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Knowledge of business intelligence/data warehousing practices and tools using MS SQL Server 2005 Reporting Services (SSRS).
• Experience in SQL Server Reporting Services (SSRS) Installation and Configuration for Scale-Up and Scale-Out topology
• Self-motivated and Flexible to adapt to any new environment and work on any project.
• Worked as a team member to provide 24x7 on-call production database support.

TECHNICAL SKILLS

Relational Databases: SQL Server 2008 R2/2005 / 2000 / 7.0, MS-Access 2000/2003/2007, Oracle 9i &10g, My SQL4/5.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, ODBC,SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.

Languages: C, C++, C#, JAVA, VB.NET, ASP.NET, XML, PHP, UNIX Shell Scripts, T-SQL.

Operating Systems: Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, Redgate, sqlcompare, lite speed.

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL Server DBA/Developer

Responsibilities

• Installed and configured SQL server 2008 and administered 100+ servers with zero downtime
• Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server 2008.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas
• Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis.
• Administered the SQL server 2000/2005/2008 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• User management by assigning appropriate permissions to the database users.
• Experience in upgrading SQL Server and applying service packs and hot fixes and unattended Installations.
• Involved in database administration tasks and assisting developers with problems and SQL optimization.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Experienced working on SQL COMPARE tool to compare the structures between databases in order to synch them
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers
• Knowledge in Active/Passive Clustering and implementing RAID technology on windows 2003 servers.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Refresh the database from production to development and staging environment on daily basis.
• Developed physical data models for database schema and objects.
• Involved in the Backup & Restore and point in time recovery of the databases.
• Responsible for developing, monitoring and deploying 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
• Used Lookups Transformation to get the data from reference data sets.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
• Created permanent tables, temporary tables and table variables.
• Conducted design reviews with users/team for development and production strategies.
• Translating business requirements into technical design specifications and actively supported business users for change requests.
• Developed DTS and SSIS packages to extract, transform and load (ETL) the data using SQL Server 2008 Integration Services and successfully completed DTS to SSIS conversion
• Capacity-planning, Maintaining run book documentation on all the servers in word, pdf and excel formats.
• Good experience in handling onsite-offshore model.
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2008 R2/2005/2000, Windows 2000, Windows NT, lit speed, Sql backup5, SQL secure, ETL, SSIS, SSRS, C#., VB,ASP.NET, MS Excel and MS Access, Oracle, UNIX, SSAS, System Monitor / Performance Monitor.

Confidential, Chicago, IL

SQL Server DBA/Developer

Responsibilities

• Installing and Configuring SQL Server 2008/2005/2000 and administration of nearly 120+ servers ensuring zero downtime.
• Upgraded the existing database to SQL Server 2008/2005 from SQL Server 2005/2000.
• Installed and managed MS SQL Server Cluster Server and configured SQL Server 2000 on Windows 2000 Advanced Server.
• Designed Logical and Physical database design using Diagram feature in SQL Server and Created the Physical Database design for production database.
• Developed objects by creating COM Components using VB and IIS technology.
• Moved the legacy inspection applications data from various heterogeneous sources like Oracle, MS Access, and MS Excel and text files to SQL Server 2000 database using BCP and dynamic DTS packages
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and loading of data using SQL Server DTS.
• Worked on Table Design, Index Design and Performance Tuning.
• Created and maintained entity relationship diagrams, Meta data repository and comprehensive system documentation.
• Employing indexing strategies and optimizing them using SQL Profiler and Index Tuning Wizard.
• Worked on indexing, fill-factors of data pages, Integrity Checks, Update Database Statistics and Re-indexing.
• Created packages using DTS for moving data from MS Access to SQL Server.
• Worked on UNIX shell scripts for automating scheduled DBA tasks.
• Worked on SQL Server Clusters Active - Active on mission critical financial applications
• Worked on advanced disaster recovery techniques like Standby databases which acts like a failover for our mission critical production databases in financial environment.
• Logical and Physical design of database for projects on basis of user requirements using Erwin.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005
• Created Database Snapshots and stored procedures to delta load data from the snapshot database to the report database.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures in T-SQL.
• migrating SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Improving the performance by designing SSIS packages for parallelism
• Generating Various Reports using SSRS 2008.
• Actively involved in data warehousing of the Sybase database onto SQL SERVER 2008.
• Worked on OLAP data Meta Data in MDX, Calculated members, Named sets ofDimensions and writing MDX queries.
• Experience with DB Artisan admin tool as well as VERITAS Netback up.
• Worked on Business rules implementation and Deployment using EJB and Web logic Server
• Created OLAP cubes using analysis services. Configured the security roles to the OLAP environment.
• Created (SSIS) packages to import data from Flat Files to SYBASE.
• Experience in Creating and Debugging Store procedures, Triggers and Functions in T-SQL.
• Used SQL Profiler for Trouble shooting monitoring optimization of SQL server and production database code as well as T-SQL code.
• Created SSIS packages from standalone systems to incremental files.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS).
• Experience in designing, building the dimensions, cubes with star schema using
• SQL SERVER ANALYSIS SERVICES (SSAS)
• Involved in developing the data models and analyzing data relationships, storage requirements
• Helping application teams in query analyzing and its optimization. Coordinating with users for downtime and maintain the system 24X7 running.

Environment: Microsoft SQL SERVER 2008/2005, Microsoft Windows 2003/2000/NT SERVER R2, SSIS, SSRS,SSAS System Monitor / Performance Monitor, Performance Tuning, DB Mirroring.

Confidential, New York, NY

SQL Server DBA/Developer

Responsibilities

• Installation of MS SQL 2005 & 2000 Enterprise servers on production, Development boxes.
• Supporting Applications with SQL Server 2000 & 2005 Databases all over United States.
• Involved in Migrating SQL Server 2000 to SQL Server 2005(Side by Side).
• Migrated old SQL Server 2005 database to SQL Server 2008 from Old database.
• Developed administrative tasks of SQL Server of performing daily Backups and recovery procedures and Created UNIX shell scripts for On-line/Off-line backups.
• Experience in Installing, Configuring and maintaining SQL Server Active/Active and Active/Passive clusters.
• Implemented different types of Replication Models such as Transaction, Snapshot and Merge replication in SQL Server 2000 and SQL Server 2005 in OLTP Environments.
• Extensively used SQL Server 2005/2000 Log Shipping to distribute the data to different locations and to maintain the databases in sync.
• Handling user requested issues through Service Tickets.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Created and managed schema objects such as Tables, Views, Clusters, Indexes, Procedures and Triggers through query analyzer.
• Migrated data from MS Access and Excel to SQL Server.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. dis involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, and Index Tuning Wizard to achieve better performance, accessibility.
• Designed and built the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
• Developed a Database Maintenance Planner for the Performance of SQL Server, which includes Re-indexing, Database Integrity Checks and Update Database Statistics
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Improved high performance by indexing, arrays, merging tables, summarized and aggregated data.
• Implemented disaster recovery techniques like logical and physical standby databases.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Strong Knowledge in the Performance monitoring tools like BMC patrol, Spot light, also used SQL Server profiler and windows performance monitor.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Created indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Worked with SQL Profiler for auditing and index tuning and analyzed the execution plans for database optimization.
• Exported data from different data sources like Excel, Flat File to SQL server 2005 using SSIS.
• Created DTS, SSIS packages to export and import data from SQL Server to Access, text and EXCEL files.
• Using Import/Export wizard to move data from flat files and Excel sheets to SQL Server using SSIS
• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Worked on DTS Package, DTS Import/Export for transferring data between Database (Oracle and Text format data) to SQL Server
• To analyze long running slow queries and tune the same to optimize application and system performance using Tuning advisor.
• Involved in setting up SQL Server configuration settings.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in development teams including project planning, estimating, programming and testing.
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2005 Enterprise Edition, SQL, Enterprise manager, Developer 2000, ERWINS, MS PowerPoint, MS Project, MS Access 2000 & Windows 2K platform.

Confidential, Boston, MA

SQL Server DBA

Responsibilities

• Managed the migration of SQL Server 7.0 databases to SQL Server 2000.
• Installation of SQL Server 2000 for People Soft Applications.
• As a DBA, contributed for the successful design, development, implementation
• Design, maintain and improve high availability and disaster recovery strategies for the database environments, including backup, restore, replication, and fail-over methods.
• Managing Disk Storage - Configuring RAID disks - Creating File Groups for Tables and indexes and placing them across RAID 0+1, 5 disks.
• Plan, install, configure, and upgrade installations of Microsoft SQL Server. Upgraded SQL Server 7.0 to SQL Server 2000.
• Provided 24x7 production support of mission critical applications in the organization.
• Setup log shipping on SQL Server to setup warm standby servers, which were also used as reporting databases
• Assist the Application development teams with best practices for SQL Server including but not limited to code optimization techniques & Change management using VSS.
• Estimating Database size, Creating & altering user databases and granting ownership to them, setting database options.
• Transferring data in and out of SQL Server databases using DTS packages.
• Written stored procedures to monitor the SQL server by using DBCC functions, Update statistics, etc.
• Setup Alerts by using SQL Performance monitor to monitor the database log size and to take backup.
• Scheduled unattended operations/tasks like Backup, stored procedure for monitoring SQL server.
• Diagnosing and fine tuning SQL Server by changing the configurable system parameters to achieve the best performance.
• Setup Log shipping and Replication on SQL Server to setup Warm stand by servers for Reporting and offline data distributing.

Environment: SQL Server 2000/7.0, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS, VB, Oracle 8i, MS-ACCESS.

Confidential

SQL Server Developer

Responsibilities

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Designing and creation of tables and stored procedures with E-R diagrams.
• Writing the stored procedures, checking the code for efficiency using T-SQL.
• Creation of user Databases and installation of MS SQL Server 2000.
• Created and maintained various databases for development and testing environment.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures and triggers through query analyzer.
• Data Transfers between various servers using BCP.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler and NT monitoring tools.
• Using Data Transformation Services (DTS) and SSIS to populate data from various data sources using the concept of OLE DB.
• Involved in Data warehouse support.
• SQL Server Reporting Service to create enterprise, ad-hock, embedded and web-based reports.
• Testing the stored procedures performance and its path of execution by using SQL Profiler.
• Recovering the Backups of production databases as a part of regular maintenance activities.
• Crystal Report is used to create more flexible, tailored, and responsive report.

Environment: Windows 2000 server, T-SQL, SQL, SQL Server 2000 / 2005 (Enterprise Manager, Query Analyzer), SSIS, SSRS, UML and Visual Basic 6.0, Crystal Report.

Confidential

SQL Server DBA

Responsibilities

• Created database objects through development, testing, and production environments.
• Wrote in-house data entry applications in Visual Basic and SQL Server.
• Created new data models for specific purposes.
• Installed programming restricting user actions.
• Provided assistance to full time computer operators with tape backups and problem resolution.
• Participated in system construction, analysis, testing, and implementation.
• Modified and upgraded database systems to suit company requirements.
• Responsible for the testing and debugging of programs.

Environment: SQL Server 2000/7.0, VB, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, DTS, BCP, Windows NT.