SUMMARY:

• Over 7+ years of IT experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server also specialize in MS SQL Server /2005/2000 across various Client Server/mission critical Environments
• Experience in Installation,Configuration,Upgrades,migrations,HighAvailability,SecurityAdministration, Database Development and data modeling across various Clustered/Stand - Alone Database environments
• Hands-On Experience in writing & debugging Stored Procedures, Complex queries, Triggers, functions and Troubleshooting code Issues in Confidential -SQL.
• Migration experience using both In place & Side-by-side from SQL 2000à2005à2008à2012 using Upgrade Wizard and Upgrade Advisor in both Clustered and Non Clustered Environments.
• Implemented new SQL Server 2008 concepts like Policy-Based Management, Resource Governor, Data Compression, Performance Data Collection etc.
• Experience in migration of Databases from SQL Server 2000/2005 to SQL Server 2008/2012 and troubleshooting migration issues on both 32-bit and 64-bit Environments.
• Expert in Data Extraction, Transforming and Loading (ETL) from Heterogeneous sources like Excel, MS Access, XML, Oracle, DB2 to MS SQL Server using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Creating and maintaining DTS/SSIS Packages /Jobs for huge data transfers and various ETL activities.
• Installation, Configuration & Administration of SSRS 2000/2005, SSIS, SSAS, Legacy Components, and Feature packs.
• Generated Enterprise reports using linked reports, sub reports, charts and filters in SQL server reporting services.
• Experience in Working with Production 24/7, Disaster Recovery, Development and UAT Environments.
• Excellent skills in Database Backup & Restore methodologies using Maintenance Plans, SQL Lite-speed and various 3rd party tools.
• Experience in Performance& Query Tuning using SQL Profiler, Perf-Mon, and Index Tuning Wizard (2000), Database upgrade advisor (DTA 2005), PSSDIAG’s, SPOTLIGHT, Deadlock Analyzer and various DBCC utilities.
• Configuring Replication (Merge, Transactional & Snapshot) to replicate data to regional and remote servers and troubleshooting Replication issues.
• Experienced in implementing and supporting High Availability solutions like Database mirroring, Clustering, Log shipping and Replication.
• Experience in Working With Windows 2003 Advance and Enterprise Server 2003/2008. Co-ordination of Service Packs, Hot-fixes with Infrastructure Team.
• Experience in assisting Applications & teams across Remote and Local geographical locations as part of Support.
• Excellent Analytical, Interpersonal and Communication Skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008 R 2/2008/2005/2000 , ORACLE, MS Access, MySQL,, DB2UDB

Database Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Analysis Services, Business Intelligence & Development Studio and Erwin

Development skills: Confidential: SQL,PL/SQL,SSIS/SSRS/SSAS, Oracle 8i/9i/10g

Languages: Confidential: SQL, HTML, XML,VB.Net

ETL Tools: DTS, SSIS (SQL Server Integration Services), Informatica.

Reporting Packages: SQL Server Reporting Services (SSRS), Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel

Operating Systems: Windows 98/NT/2000/XP, 2003 Servers, UNIX.

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader, TOAD for SQL Server and Oracle

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL Server DBA

Responsibilities:

• Involved in Installation, Configuration &Supporting of enterprise servers across DEV/Test/PROD/DR environments both in Clustered /Stand-Alone environments
• Involved in Data modeling, designing, and building databases using ERWIN both Physical & Logical modelling.
• Migrated Databases from SQL Server 2005 to SQL Server 2008R2/2012 in Production and test Environments.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Scheduling Backup and Recovery Jobs, Implementation using Litespeed, and integrating them with enterprise environment .
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008.
• Created Linked Servers between SQL server 2005/2008 and Oracle/DB2 servers in the environment.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from Oracle to SQL databases.
• Configured Snapshot and Transaction Replication.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Creation, Testing, and Implementation of SSRS packages for Reporting Services that included paper-based and interactive web-based reports.
• Experience in building adhoc reports, parameterized reports, toggle reports, reports with sub reports using SSRS.
• Performed De fragmentations Techniques of most complex indexes.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Creating and Modifying Tables, Confidential -SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Created SSIS packages using ETL tools to migrate data from different source.
• 24*7 Production support and participated in Change Control migrations and adhering to SOX Compliance

Environment: MS SQL Server 2008 R2/2005/2012, Confidential -SQL, MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS),PSSDIAG, DTA, DBArstisan, SQLLitespeed,ERWin, SSDashboad,SQL Profiler, Windows 2008 server

Confidential, Houston, TX

SQL Server DBA/Developer

Responsibilities:

• Installation, configuration and Administration of MS SQL Server on Windows2003 Servers.
• Logical and Physical design of database for projects on basis of user requirement.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
• Implemented and maintained database security, logins, roles and schemas.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Performed Database backups (operating system, flat file backups & export/import).
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Implement Replication for Reference Data across different Instances of the application.
• Worked on Active/Active and Active/Passive Clustering.
• Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard.
• Performed query tuning & optimization using Query Plans & SQL Profiler.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Handled Database recovery (disaster recovery), diagnosed, repaired and was involved to transfer the OLTP data to Data Warehouse

Environment: SQL Server 2005/2008/2012 , Confidential -SQL, SQL Server Reporting services (SSRS), SQL Server Integration Services (SSIS), Windows 2003 Server.

Confidential, Louisville, KY

SQL Server DBA / Developer

Responsibilities:

• Management of SQL Servers, databases, storage management for databases.
• Management of database objects such as tables, views, indexes.
• Management of users including creation/alteration, grant of system/db roles and permissions on various database objects.
• Involved in writing Transact-SQL command line script for various needs.
• Evaluated data storage considerations to store databases and transaction logs.
• Involved in Migration of SQL Server and also on new hardware with the platform of Windows 2003.
• Used DTS/SSIS to perform the ETL tasks from source to target.
• Tuned the database to perform efficiently by managing databases.
• For transferring, used data import and Export utility and BCP command line utility.
• Monitoring the server for High availability of the servers solving the raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Tuned Stored Procedures, DTS packages for accuracy of Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.

Environment: SQL Server 2005 & 2008, Windows 2003 Server, DTS, SSIS, SSRS, Erwin.

Confidential, Pittsburgh, PA

SQL Server DBA / Developer

Responsibilities:

• Development of Confidential -SQL Stored Procedures for Export & Import of data from databases and Transaction Databases of different agencies.
• Administration of around 25+ SQL server 2005/2000servers. Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Developed DTS packages and schedule jobs for loading data between different sources.
• Creation and maintenance of databases, creating roles and managing user permissions.
• Created Views and Index Views to reduce database complexities for the end users.
• Code Review for different modules of SQL Technology Team.
• Implement Replication for Reference Data across different Instances of the application.
• Installation of SQL server Instances and Service Packs. Applying Hot Fixes. Testing and analyzing effects of Server Upgrades and Security Fixes on customized server instances with Mount Points etc. Implementation of new changes through Change Request.
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Documented disaster recovery plans and participated disaster recovery drills.
• Reviewed third party tool (Idera) so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Performed query tuning, assigned proper Indexes for better performance.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: MS SQL Server 2005/2000, Confidential -SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio 2005.

Confidential, Fort Worth, TX

SQL Server DBA

Responsibilities:

• Designed and implemented the database in MS SQL Server 2000 for an outsourced retail client.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Administered the SQL Servers and the databases.
• Migrated data of the products and customers from retail store’s database (SQL Server 2000) by DTS.
• Created Trigger for the application which would automatically run jobs so that synchronization between legacy and newly developed system is maintained.
• Designed and implemented the database in MS SQL Server 2000.
• Created maintenance plans in SQL Agent to backup the database.
• Implemented Log Shipping Successfully.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Administered the SQL Server 2K databases of Confidential including Open Office, Open DC, Open Net and Open Store.
• Analyzing transactional logs using Lumigent Log Explorer for potential data issues, DMLs and DDLs.
• Wrote ad-hoc stored procedures, Confidential -SQL scripts and created DTS packages to synchronize the data between Confidential & Confidential .

Environment: MS SQL Server 2005/2000, Confidential -SQL, DTS and Crystal reports 8.0, IIS 5.0, VB 6.0, Windows 2000 Server/Pro.

Confidential

SQL Server DBA/ Consultant

Responsibilities:

• Collaborated with software engineers, architects, and technology specialists to design database, clustering, and migrations.
• Deployed and Administrated SQL 2000 server on production environment.
• Develop and implement Replication, Archiving, Backup and Recovery strategies.
• Proactively monitor the Production Database and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• Manage and Create database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc.).
• Ensure all database environments (Development, Staging, QA and Production) are in sync. Define db scripts versioning system to keep track of database versions for all environments.
• Design, review and implement production SQL Server database objects, models and database designs (schema)
• Wrote optimized Confidential -SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Good experience in maintaining Log Shipping, Replication and Clustering.
• Identify and resolve database performance issues, database capacity issues and other distributed data issues.

Environment: SQL Server 2000, Confidential -SQL, SQL Enterprise manager, Query Analyzer, ERWIN, DTS, MS Access 97 / 2000 & Windows Server /x64.