Sql Server Data

Areas of Expertise:

*+ years of IT experience in Database System Analysis, Design, Implementation and Administration of MS SQL Server 2012,2008R2,2008, 2005, 2000 in Production, Test, Development and Replication & Cluster Server Environments.

Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008 & R2/2005/2000 on Clustered and Standby Environments.

Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

Extensively used various transformations in Control Flow tasks, Data Flow tasks using Visual Studio

Excellent Experience in SQL Server administration, replication, creating and maintaining Log Shipping and Disaster recovery.

Experience in creating and maintaining SQL Clustering, Optimization, Backup, restore, Security and disaster recovery.

Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS)

Comprehensively involved in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS)

Developed Drill through and Drill down reports using SQL Server Reporting Services (SSRS). Experience in developing User reports and management reports using MS SQL Server Reporting Services (SSRS).

SQL database design, architecture.

Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Views, Cursors and Triggers.

Hands on experience with T-SQL (DDL, DML, DCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.

Implemented CDC(Change Data Capture) and Change Tracking in SQL Server 2008 for capturing changes for data warehouse environment.

Worked as both Production DBA and Development DBA with 24 x7 support.

Understanding in installing, upgrade, troubleshooting and configuration of MS SQL Server 2000/2005/2008 Database.

Excellent oral and written communication skills.

Fast learner and adapts quickly to new technology with ability to take new roles in minimum time and little training.

Ability to work individually as well as in a team with excellent problem solving and trouble- shooting capabilities.

Education:

Bachelor’s in Computer Science from JNTU, India

Master’s In Computer Science, California .

Technical Skills:

Databases

SQL Server 2005, 2008 R2,2012, Oracle 11g, 10g, 9i

Querying/Reporting

T-SQL,PL/SQL, SQL * Plus, SQL*Loader, TOAD.

Reporting Tools

SSRS,Cognos 8, Microsoft Clustering Services (MSCS), Crystal Reports.

ModellingTools

SQL Server Analysis Server 2005(SSAS),ER-win.

ETLTools

Microsoft Integration Services (SSIS), Cognos Decision Stream.

PROFESSIONAL EXPERIENCE

Client: United Airlines, Houston, TX APR 15- Present

Role: SQL Server DBA

Upgraded the Existing SQL Server Data base 2005/2008/2008 R2 to SQL Server 2012

Designed and implemented the Clustered Server environment for high availability both in Physical Environments.

Tested successfully in implementing Fail over SQL Server Clustering in Virtual Environment

Configured Alwayson in SQL Server 2012

Implemented and maintained Database Replication and Developed the Stand alone Database for Reporting Servers.

Worked in Analyzing the Project Scope at an Architect level with Business and Implemented the Project in time in Budget and Involved in Complete SDLC.

Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.

Used various transforms in SSIS to load data from flat files to the SQL databases.

Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.

Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.

Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.

Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.

Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.

Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery

Worked on multidimensional Datamodeling.

Participated in Databases Architecture and data modeling design.

Reviewed and developed data models and database designs with development teams

Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.

Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.

Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.

Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Configured Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.

Worked on different kinds of transformations in SSIS as per the client’s Requirement.

Used Index tuning wizard to redesign and created the indexes for better performance

Environment: SQL Server 2005/2008 R2 /2012, Windows Enterprise Server 2003, ORACLE 10g, IIS 6.0, .NET,UNIX, Erwin, Microsoft Visio 2003,SSRS, SFTP, Oracle RAC,DB2,Microsoft Silver light, Microsoft Reporting Services(SSRS), DB2, Share Point Server, SSIS, DTS, Erwin, Cluster Environments, Red Gate, Spot light, Solaris, SSIS, Oracle Clustered Environments, Oracle Replication environments,ADABAS. TCP/IP, Named pipes, LAN Sockets

Client: NRT, Minneapolis, MN July 14 – April 15

Role: SQL Developer

Responsibilities:

Excellent experience configuring and maintaining all three types of replication like transactional snapshot and merge replication.

Involved in upgrading from SQL Server 2000 to SQL Servers 2005 and test the application after the upgrade, make sure everything is working fine.

Involved in writing T-SQL programming for implanting stored procedures and functions for different tasks.

Query Optimization handled by using extensive use of Index implementation and Index Tuning Wizard SQL Server 2005.

Created Database, creating tables, views, indexes, stored procedures, triggers and constraints.

Analyze the requirements and fine-tune the stored procedures to improve performance.

Experienced with improving SQL Server using windows performance monitor to improve the server performance.

Experienced with SSIS packages, SSRS and SSAS features in SQL Server 2005 servers.

Involved in creating SSIS packages for loading data from data source (oracle or sql database) to Staging database.

Worked on Client/Server tools like SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server 2005.

Created Database Maintenance Planner for the performance of SQL Server 2005, which covers Database Integrity checks, Database Statistics update.

Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.

Created the DTS packages to import the data from MS Access and Oracle server to SQL Servers.

Created the standard documents for Disaster recovery testing and implemented them.

Experienced with creating logical and physical database design for development projects.

Experienced with SQL Server 2005 profiler, SQL Server management studio and Business intelligent development studio.

Worked with developers to do the database schema changes and database restore requests.

Involved in restore operations to refresh the data from production to test servers.

Involved in creating backup strategy production, test and development servers.

Experience in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.

Experience in setting up security features for MS SQL Servers and maintain the user access.

Document server and database policies and procedures.

Generated ad-hoc reports using MS-Access and Crystal Reports.

Coordinated post-implementation events such as testing.

Created documentation to install SQL Server, apply service pack and hot fixes.

Environment: SQL 2000, SQL Server 2005, WINDOWS 2000, 2003, SSRS, SSIS, SSAS, ASP.NET, Crystal Reports 10.0, MS Access, RedGate SQL toolbelt, Coldfusion

Client: Verizon, Irving, TX Feb 12-Jun 14

Role: SQL Server DBA

Worked and maintained production and development databases in SQL 2000/2005/2008/2008 R2,2012 and Upgraded the Existing SQL Server Data base 2000/2005/2008/2008 R2 to SQL Server 2012

Worked with DBCC Commands for Consistence Database Integrity.

Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.

Worked with SQL Server Performance Monitoring Tools like Microsoft Performance Monitor, SQL Server Profiler and Helped in Database Consistency.

Experience in Raid technologies and best practices in installing SQL server

Configured Database Mirroring as a part of High Availability Solutions.

Worked in Generating Trace Logs and Counter logs in monitoring the Server traffic and Run the DB Usage reports in Hourly bases.

Worked in Developing and Tuning Tones of Stored Procedures at different levels of database security and maintenance

Created database objects like tables and stored procedures through development and testing environments.

Set up database backup and recovery strategies Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.

Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery

Extensively Used third party tools in SQL Server Administration like Red Gate’s SQL Backup Pro 7.3

Fine-tuned Stored Procedures using Execution Plan in T-SQL for best performance.

Used Erwin to Design and Develop Data model for Migration Projects.

24/7 Production support in multiple environments.

Worked on Off Shore/ON Shore model.

Taking a Snap shot of production database in regular bases and developing a Data warehouse

Worked as a lead for different Ad hock projects in the On Shore and Off Shore models.

Worked in Reporting Services (SSRS) to generate various Reports with Graphical representation of data showing the trends in the business in regular bases.

Used Index tuning wizard to redesign and created the indexes for better performance

Worked on Different Operational system like Windows 2008/Solaris and UNIX

Successfully Integrated the SQL SERVER Replication services with the Share Point Servers.

Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity used Third party tool Red gate-SQL Monitor 3.2

Running Index tuning wizard and rebuilding indexes for faster query response

Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications both on SQL server and Oracle.

Created multiple Read only servers using the Replication to handle tons of connections.

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Environment: SQL Server 2000/2005/2008/2008 R2 /2012,.NET,SSRS,SSIS,SSAS, DB2, DTS, Erwin, Cluster Environments, Red Gate,TFS, Spotlight

Client:Williams, Tulsa,OK Nov 10 – Jan 12

Role: SQL Server DBA

Worked and maintained production and development databases in SQL 2000/2005/2008/2008 R2,2012 in a non-stop heavy transactional and reporting environments

Implemented DR site and high availability servers for production data warehouse systems.

Implemented Transaction Replication with multiple subscriptions from multiple sources.

Provided 24x7 support for OLTP and Datawarehouse environments for both production and non-production.

Involved in migration of database from MS SQL 2000 to MS SQL 2008.

Upgraded SQL Server from 2000, 2005, 2008, 2008R2 to SQL Server 2012 in Production, stage and Test Environments.

Implemented Active/Passive and Active/Active clustering based on the project needs with tight timelines.

Actively involved as part of team for gathering and analyzing the needs of end user requirement and system specification.

Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).

Created database maintenance plans, regular scheduled DBA tasks for enhancing the performance of SQL Server, some of these tasks included Database integrity checks and re-indexing.

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 as a developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.

Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.

Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.

Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.

Extensively used various transformations in Control Flow tasks, Data Flow tasks in SSIS packages using BIDS.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard

Designed cubes with star schema using SQL Server Analysis Services (SSAS).

Modified existing database by adding tables and relationship to existing data model.

Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity and provide additional application functionality.

Maintained the data, database backups and restoration, backup strategies, scheduled backups.

Involved in complete backing up of Database and restored the database from Disaster Recovery.

Involved in testing, bug fixing and documentation for the project.

Environment: Microsoft SQL Server 2000/2005/2008/2008R2/2012, Sharepoint, SSIS, CDC, SSRS, SSAS, Erwin, TFS, Visual Studio.

Client: Elantecs, Hyderabad, India Jun 09 – Oct 10

Role: 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, data dictionaries and attributes).

Deploying new Database objects in production environment.

Designed new SSIS packages and deployed them.

Migrated data from Oracle to SQL 2005 using Visual studio 2005 package.

Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.

Modified Data Flow tasks using Visual Studio 2005

Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.

Writing Stored Procedures, Triggers, cursors and creating indexes.

Created DTS Package designs for Import/Export from different servers like oracle to SQL Server.

Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.

Managing the use of disk space, memory and connections.

Running DBCC consistency checks, and fixing data corruption in application databases

Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.

Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.

Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.

Created user defined data types and added them to model database for future purpose.

Worked on Authoring Reports and managing reporting services.

Logical and physical database design using Erwin Tool.

Performing query plans and making sure each query is using appropriate indexes.

Provided on - call 24/7 provide support.

Provided support for in-house and offshore Development Team.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL, Enterprise Manager, T-SQL,CT, XML, MS PowerPoint, MS Project & Windows 2003 server, Visual Studio 2005, Redgate SQL toolbelt

Contact this candidate