SUMMARY:

• Over 10 years of IT experience, which includes Database Administration, Development of MS SQL Servers in Production and Development environments.
• Experience on Extraction Transformation and Loading (ETL) process using SSIS
• Experience in Designing and Developing SSIS packages in BIDS.
• Experience in managing SSIS packages and DTS packages within SQL Server Management Studio(SSMS)
• Proficient in Report Design and Report Server Administration using SSRS
• Experience in creating cubes for OLAP databases using SSAS
• Extensive experience in developing fail - over strategy plans (Mirroring and log shipping) of SQL Server Databases.
• Involved in maintenance of SQL server Database in Clustered Environment.
• Expertise in Replication methodologies (Snapshot, Transactional and Merge Replication).
• Expertise in backup and disaster recovery using native SQL Server tools and third party tools like LiteSpeed, IBM TSM and Red Gate SQL backup.
• Experience in Database Mirroring, Database Snapshots and Log Shipping
• Experience in implementing MS SQL Server security and providing permissions to the users based on liability.
• Experience in troubleshooting using Dedicated Administrator Connection (DAC).
• Strong in database Performance Tuning, using Tuning methodology, including query plans, performance views, trace files and tools like Index tuning wizard, SQL profiler, windows performance monitor and DBCC database consistency checks
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks
• Installed new Instances, created databases, tables, triggers, and views for the developers. Provided support to the developers during analysis, design, coding, and implementation of new applications.
• Good Working knowledge of SQL Server Management Studio, SQL Server Agent, SQL Server Surface Area Configuration, Database Engine Tuning Advisor and Integration Services(MSSQL Tools)
• Knowledge of RDBMS. Database design issues like Normalization and De-normalization and excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Excellent analytical, interpersonal and communication skills and a very proactive team player.

TECHNICAL SKILLS:

Databases: SQL Server, MS-Access Oracle

Operating Systems: Windows, MS DOS, UNIX, Linux

Database Tools: Enterprise Manager, BIDS, Query Analyzer, SQL Server Profiler, SSIS, SSAS, SSRS, DTS and BCP

Languages: C, C++, VB, HTML, Shell, UNIX, T-SQL

Web Servers: Apache HTTP Server, Apache Tomcat, BEA WEBLOGIC server

Other Tools: Erwin, Confidential Visual Studio, Confidential Visio, Confidential Visual Source Safe, SQL LiteSpeed, Red Gate, TSM

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

SQL Server DBA

Responsibilities:

• Involved in upgrading the instance of development environment of SQL Server 2000 to SQL Server 2005.
• Used SQL server 2005 tools like SQL Server Management Studio, including SSIS, SSRS & SSAS
• Created Cubes, Dimensions and Fact tables for OLAP databases using SSAS.
• Created different types reports like graphs, pie charts etc. based on user requirement by using SSRS
• Published various Reports created by SSRS on web by using IIS
• Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.
• Developed SSIS Packages and SQL scripts to extract the data from OLTP system to flat files and for pre-calculated aggregates, summaries, and user specific calculations.
• Migration of DTS to SQL Server Integration Service (SSIS).
• Involved in Capacity Planning and analyzed the Database Growth and plan for the data storage and servers
• Worked with development teams on all aspects of database design including tables, views, stored procedures, permissions, etc.
• Worked with Application Developers to design databases and tables to support development activities and achieve optimal efficiency.
• Created Database Diagrams, Defined relationship between tables and enforced the referential integrity constraints.
• Created Clustered and Non-Clustered Indexes.
• Created various Stored Procedures to enforce the business logic.
• Responsible for Query Performance tuning and Optimization.
• Evaluated Server Performance Bottlenecks by analyzing the memory usage, CPU Processor utilization, Disk reads/writes, user connections and locks.
• Monitor database growth activities & Troubleshoot Transaction Log & Space Issues
• Designing, testing and managing disk\tape Back ups and Recovery strategies.
• Managing Log Shipping for hot stand by computers
• Troubleshooting replication errors and handling logs.
• Set up SQL Profiler to trace various Database activities, application Responses and Performance tune them.
• Performance tune Stored Procedures & long running queries by looking at query plans, IO Statistics, Joining Techniques, Outdated Statistics & Indexes
• Responsible for 24 X 7 critical servers including production, test and development servers.

Environment: MS SQL Server, SSIS, SSRS, SSAS, System monitor/Performance monitor, Windows server, Action Remedy System, Outlook Express, Window clients, Windows. MS Access.

Confidential, Seattle, WA

SQL Server DBA

Responsibilities:

• Upgraded data base servers from SQL Server 2008 to SQL Server 2012.
• Participate in the database design and normalization process.
• Created Functions, Triggers, Stored Procedures, Databases, and views
• Extensive use of stored procedures. Written new stored procedures and modified the existing ones and tuned them to increase the performance
• Proper use of Indexes to enhance the performance of individual queries
• Extensive use of triggers to implement business logic and for auditing changes to critical tables in the database
• Login and User Management: Adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures
• Responsible for maintaining production database, supporting development and testing environment.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Evaluated SQL Server including installation, configuration, management, migrating existing applications/servers and transferring DTS packages to SSIS programs.
• Clustered and non-clustered index creation/optimization using SQL Profiler and Index Tuning Wizard.
• Configured Server for sending automatic mails to the respective personal when a job failed or succeeded.
• Full, Differential and Transaction Log Backup strategies.
• Configured log shipping as part of disaster recovery strategy.
• Install, configure SSRS and troubleshoot reporting services issues.
• Created Reports using Report Builder and Report Designer using Business Intelligence Studio
• Generated and maintained test data and databases for the testing environment.
• Created jobs, alerts, log to monitor the database errors.

Environment: SQL Server, SSIS, SSRS, IIS 5.0, JavaScript, HTML, DHTML, XML, Windows

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• Involved in development, quality assurance and production stages of SQL Server installation
• Responsible for Performance Monitoring and Trouble-Shooting of SQL Server Databases.
• Development and Implementation of Disaster Recovery Plan and Procedures
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups. Backing up system & user databases and restoring them when necessary
• Designing and building databases for applications across all company business functions.
• Monitor and tune SQL Scripts .Creating upgrades scripts for production database and supporting it.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Worked in capacity planning by shrinking databases and log files.
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Maintaining remote and central databases for Synchronization of data and preparing plans for Replication.
• Database Server Performance, tracking user activity, troubleshooting errors, tracking server resources and activities, tracing server events.
• Configuration of linked servers for user to be used for data exchange.
• Created and scheduled jobs and alerts.

Environment: T-SQL, SQL Server,DTS, BCP, BulkInsert, BulkLoad, Oracle, HTML, DHTML, FrontPage, Windows, XML

Confidential, Phoenix, AZ

SQL Server Administrator/ Developer

Responsibilities:

• Proper use of Indexes to enhance the performance of individual queries and the Stored Procedures
• Installing MS SQL Server, configuration and doing performance tuning, capacity planning, query optimization
• Responsible for Drops i.e. moving from development to QA and then to Production
• Writing migration scripts and taking care of efficiency
• Integrating the scripts and testing them
• Performing various DDL changes in order to improve performance of database
• Monitoring the database assigned for development work
• Expertise in handling system issues and fixing the same
• Extensive use of Profiler in detecting Production bugs

Environment: SQL Server, T-SQL, SQL Profiler, Analysis server, and Windows Server, DTS