SUMMARY

• Total 7+ years of IT experience and extensive experience in MS - SQL Server Administration including Design and implementation of Distributed/ Replicated Databases, planning/ implementing backup/ recovery strategies, and Performance tuning
• Worked extensively on MS SQL Server 2000, 2005 & 2008 R2
• Extensive knowledge as SQL Server DBA and Developer experience in writing Stored Procedures, Triggers, Views, Indexes, Functions using T-SQL with Query Analyzer tool and ability to use SQL Profiler & Index Tuning Wizard for Performance Tuning and used DTS, BCP for import & Export the data.
• Experience working with Production 24/7 and Development Environments.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in high availability/contingency solutions - Replication, Log shipping & mirroring.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Hands on experience in Troubleshooting database issues.
• Implementation experience of Microsoft Clustering Services for High Availability of Servers.
• Proficient with SQL Management Studio, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
• High level of exposure to SQL performance tuning query optimization using Database Engine Tuning Advisor (DTA) and SQL Server Profiler7
• Experience in installation, configuration of SSIS and SSRS in 2005 and 2008.
• Exposure to SSIS Architecture and designing end to end DTS & ETL process.
• Good skills in client server architecture, design, system requirement study, and project management.
• Experience in using OLTP and OLAP Technology
• OLAP experience like Data Analysis Services, Business Intelligence tools.
• DB maintenance, creation of users, configuring permissions and assigning roles to users.
• Experience working on .Net Framework applications using C# and ASP.Net.
• Excellent analytical, problem solving, communication and interpersonal skills
• Strong MYSQL Skills and Good knowledge and experience working on Apache Server and IIS
• Experienced on BO 6.5, VB Script, ADO, ASP, XML, IIS and HTML
• Strong analytical and conceptual skills, rapid grasper of new technologies and business terminology.

TECHNICAL SKILLS

Databases & Services: SQL Server 2000/2005/2008 R2, ORACLE, MYSQL, MS-ACCESS, SSIS, Reporting Services, Business Intelligence, Database Tuning Advisor, T-SQL, MSDE, OLAP, SQL Plus 8.0, PL/SQL 8.0, Query Analyzer, SQL Profiler, Performance Monitor, Index Tuning, Replication, DTS, BCP, Agent, Jobs, MYSQL,ODBC, JDBC

Disaster Recover Tools: Log Shipping, and MSCS Fail over Clustering Services

Programming/Scripting: Script, XML, HTML,DHTML,T-SQL Programming, VB 6, C++, JAVA, .Net, C#, ASP.NET, Perl, Ruby, Crystal Reports, Business Objects.

Operating Systems: Windows XP/NT/2000/98,Visa, UNIX

Microsoft Office suite: Word, Excel, Power Point, Outlook, Access, Visio, MS-Project.

Protocols: TCP/IP, HTTP, FTP, SSH, TELNET

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr SQL Server DBA

Responsibilities:

• Installing, Configuring and Maintenance of MS SQL 2005 & 2008 R2 Server.
• Routine Hourly, daily, weekly and monthly database backups and rebuilding indexes and running of update statistics on PROD databases.
• As the lead database dba, involved in database design, implementation and performance tuning for development, QA, production, Disaster recovery environments.
• Implemented several SSIS (SQL Server Integration Services) packages for data feed from various servers and environments. Deployed the packages using deployment utilities.
• Implemented Disasters Recovery plans to reduce the downtime of the SQL Server using Log shipping and mirroring and Replication models.
• Created reports using SSRS in SQL server 2008 in various occasions and deployed for users access
• Working closely with application developers to participation on designing of tables, developing making the Data Dictionaries, and writing of views, complex Stored Procedures, UDFs, Trigger, and Indexes according to their requirements. Written Triggers to store the data for Audit maintenance
• Setup & Monitoring of Replication agents and troubleshooting
• Database performance monitoring using SQL Profiler and system monitor and Tuning Queries to improve performance and using Index tuning Wizard.
• Work closely with QA and application developer team for bug tracking.
• Writing queries to generate reports for data analysis using SQL Server Reporting Services (SSRS).
• Experience in designing and developing data analysis tools.
• Developed Reports by using Report Server Project Wizard Report Server Projects and Report Model Project.
• Developed Reports with different styles using Table Sub Reports and Matrix.
• Performing Database administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation at all database environments.
• Monitor the database systems to ensure secure services with minimum downtime and testing and load testing.
• MYSQL database maintenance for the corporate website and retail website. Database integrity and security for company web sites and managing and controlling the traffic over the sites.
• Creating and maintain users and roles, assign privileges, monitoring the online sales forecast and maintaining the security on retails websites
• WINDOWS Experience in active directory on windows 2008 server.
• Configured and Managed Fail Overclustermanagement on Microsoft Windows 2008.
• Managed the users, computer environment by using Group Policies

Environment: MS SQL Server 2005, 2008 R2, MS Access, Excel, SSMS, SSIS, SSRS, IIS.

Confidential, Topeka, KS

Sr SQL Server DBA

Responsibilities:

• Installed and maintained MS SQL Server 2005/2008 on Windows 2003/2008 Server Worked on SQL Server 2005 failover clustering which is built on top of a Windows 2003 server cluster.
• Involved in replication setup, configuration and maintenance in Transactional Replication.
• Created the Production database backup and restore strategy and implemented the Database recovery procedures.
• Experience working on .NET Framework and developed applications using C#.net for customers and sales data using the SQL Server 2005.
• Involved in tuning the database and server performance.
• Configured and maintain Log shipping,
• Creating and managing Partitioning and File Groups.
• Creating Logins, Users and Roles in context of SQL Server security and making data dictionaries.
• Involved in end to end Database and ETL Architecture.
• Migrated DTS to SSIS packages using the migration tool and re-writing the new package.
• Performed Extensive Research on SSIS, needed for pre-processing and parsing a fixed with file according to pre-defined specification and extraction of data from different FTP source systems.
• Worked intensively on UNIX utilities in windows to convert fixed width file into delimited file for bulk insert operations.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for Tuning of indexes.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested Backup strategies.
• Developed stored procedures using T-SQL and optimized queries for report generation and data modifications activities.
• Extensively worked on Pivot and UnPivot operations in SQL Server 2005
• Monitor SQL Server performance via SQL Profiler and the Windows System Monitor tool.
• Developed automated backup and DBCC scripts for databases and transaction logs, which can be scheduled using NT scheduler. These scripts produce log of the activities, which can then be reviewed for errors and fixed using various DBCC options.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate Data from various data sources, created packages for different data loading operations for application.
• Maintained the database consistency with DBCC at regular intervals
• Experience in active directory on windows 2008 server.
• Configured and Managed Fail Overclustermanagement on Microsoft Windows 2008.
• Managed the users, computer environment by using Group Policies

Environment: MS SQL Server 2005 & 2008, SSIS, SSRS, T-SQL, IIS 6.0, Windows server 2003, HTML, MS-Excel, ASP.Net, C#.Net, ADO.Net, COM, XML.

Confidential, Cranbury, NJ

MS- SQL Server Production Support DBA

Responsibilities:

• Providing 24 * 7 Production Support for SQL Server .
• Installation & configuration SQL 2000 & 2005 on Windows 2003, apply SP and security fix.
• Resolving of High CPU spikes by identify long running Queries, Blocking & Deadlocks
• Monitoring Server Performance and Activities. Tuning Queries, created necessary indexes.
• Auditing the Security checks on QA\PRD servers as per application security standards
• Involved in creating Backup & Restore strategies.
• Implemented Disasters Recovery (DR) plans to reduce the downtime of the SQL Server.
• Deployment of DTS packages to Extra, Transform, Load data from different heterogeneous data sources into SQL Server 2000.
• Developing experience on .Net framework using C# for developing applications and modules.
• Created Application Roles, assign required permissions to roles, assign to database Users
• Created Linked Server for retrieving data for distributed database
• Setup & Monitoring of Replication agents and troubleshooting
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Creation of Update statistics on the databases to improve performance
• Scheduling SQL Server Agent Tasks to periodically running of tasks.
• Running of DBCC command for checking database consistency as part of SQL Maintenance plans.
• Working closely with application developers to participation on designing of tables and writing of views, complex SPs, UDFs, Trigger, and Indexes according to their requirements.
• Involved in Stored Procedures Tuning and Performance and Query tuning Activities
• Using SQL Profiler and Tuning Queries to improve performance and used Index tuning Wizard.
• Used BCP Command line tools to Import/export the table data into Flat Files and Flat files to tables.
• Deploying DTS & SSIS packages & Setup the non-SA jobs.

Environment: SQL Server 2000, DTS, Client tools / SQL server 2005, SSIS, Surface area Configuration, Database Engine Tuning Advisor, BCP and Bulk Load, Windows 2003, Reporting Services, Windows 2000/XP/2003, Visa, Microsoft Outlook. Excel (Pivot Tables), Crystal Reports 9.0

Confidential, Coral Gables, FL

SQL Server DBA

Responsibilities:

• Installing and Configuring SQL 2005 Server.
• Conducted weekly session to aware developers about database schema and how database support the business requirements
• Creating Logins, Users and Roles in context of SQL Server security.
• Setting up Database Environments for Developers, QA Testers, Acceptance Testers and moving the changes to Production.
• Creating and managing Partitioned and its files.
• Wrote Job and SSIS Packages to transform data from SQL to Oracle, Oracle to SQL & SQL to PeopleSoft.
• Merge Replication architecture configuration for 3500 subscribers
• Trouble shooting merge replication problems
• Implemented partitioned publication
• Configured SQL Server 2005 CE subscribers
• Conflict resolution solutions
• Disconnected subscriber synchronization over HTTP
• Maintenance plan design
• Add new Articles and Filters to Replication as and when the schema changes.
• Configured Database Mail and SMTP for SSIS Packages.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Involved in Source Data Analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Monitor SQL Server performance via SQL Profiler and the Windows System Monitor tool.
• Daily import and export activates from Oracle to SQL Server 2005 and SQL Server to Oracle PeopleSoft database. .
• Created Maintenance jobs for Daily backups and Monthly backups.
• Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server2005, SSIS Packages, T-SQL, IIS 6.0, Windows server 2003, MS Access 97/2000, HTML, MS-Excel, Unix, Windows NT, Toad 7.2. ASP.Net, VB.Net, ADO.Net, COM, VB, XML

Confidential

SQL Server DBA

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
• Designed and facilitated the implementation of data warehouses required by application systems.
• Developed and maintained data methodologies, procedures, and standards. Performed data impact analysis. Properly maintained core or control application tables.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, Lotus, XML in order to create and maintain a centralized data warehouse.
• Creation of OLAP cubes and DTS scripts.
• Published the databases from old servers to new servers using snapshot replication.
• Updated the statistics info for both the old and new servers.
• Modelled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations.

Environment: Window 2000 Server, SQL Server 2000, IIS 5.0, Visual Basic 4.0, Crystal Reports.

Confidential

SQL Server DBA

Responsibilities:

• To ensure trouble free access to SQL Server databases 24 hours a day.
• Monitoring Log shipping/Replication and trouble shooting of errors.
• Security issues related to logins, database users, and application roles and linked Servers.
• Performance Tuning of SQL queries and stored procedures using SQL profiler
• Wrote scripts for generating Daily Backup Report, verifying completion of all routine backups, Log Space utilization monitoring etc.
• Created Linked Servers between SQL Server 2000 & Oracle 9i. Also created DTS package for data transfer between the two environments.
• Backups and Restoration of data/database using a Third Party Tool (SQL LiteSpeed).
• Involved in Design and Development of Disaster Recovery Plan.

Environment: Windows 2000 Advanced Server, MS SQL Server 2000/7.0, Excel Objects, Oracle, MS projects, DB2, UNIX, SQL Server 2000/2005, Windows 2000/NT, Excel, SQL Profiler, Replication, DTS, T-SQL.