SUMMARY

• Around 6+ years of IT experience in Database System Analysis, Design, Implementation and Administration of MS SQL Server 2008, 2005, 2000 in Production, Test, Development and Replication & Cluster Server Environments.
• Understanding in installing, upgrade, troubleshooting and configuration of MS SQL Server 2000/2005/2008 Database.
• Experience working with production and 24 x 7 on call environments and documenting all Database architecture according to established standards.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Extensive Experience and in - depth working knowledge in various SQL Server tools and IDE to work with database, reporting and business intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio, and Query Analyzer.
• Extensively used various transformations in Control Flow tasks, Data Flow tasks using Visual Studio
• Excellent Experience in SQL Server administration, replication and log shipping.
• Experience in creating and maintaining SQL Clustering, Optimization, Backup, restore, Security and disaster recovery.
• Proficient in creating Use Cases, Sequence Diagrams, Component Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) Packages.
• Comprehensively involved in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2005 with .NET, Import/Export data, Bulk insert and BCP
• 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).
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Experience in Creation and deployment of cubes on SSAS.
• Experienced with Star and Snow-flake schema dimensional data modeling.
• SQL database design, architecture and data modeling using Erwin.
• Expert in creating tables, views, user defined data types, indexes.
• Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, SPROC, Views, Cursors and Triggers.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, Backup and Recovery.
• Organized professional with excellent oral and written communication skills, fast learner and also adapt quickly 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.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2012/2008/ 2005/2000 , Oracle 11i, MS Access.

Operating Systems: Windows 2008/2003/2000 , NT, UNIX, Linux.

Programming: T-SQL, PL/SQL, Visual Basic.

Tools: SSMA, SQL Server BI suite (SSIS, SSRS and SSAS) and DTS

PROFESSIONAL EXPERIENCE

Confidential, Austin-TX

SQL Server DBA

Responsibilities:

• Mostly involved in DBCR process, any changes that needed to be made on the database let it be DEV, TEST Environment had to be done by DBCR process.
• Making sure DBCR were valid, followed the DBCR documentation and the reason why the change was required.
• Worked with off shore team during IDC time to help the deployment process.
• Installation and configuration of SQL server 2008 R2 in the client computers and Confidential servers.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Created all three replication models on different applications.
• Trouble shooting Problems by using SQL server profiler.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Tuning the Database.
• Developed Database Backup Scripts and automated this process.
• Created and maintained users and user groups.

Environment: SQL Server 2012, 2008/2005/2000 , T-SQL, XML, SSIS, SSRS, SSAS, MS Office 2010, Windows 2003 server, Visual Studio 2008.

Confidential, Irving, TX

SQL Server DBA

Responsibilities:

• Responsible in 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 2008 using Visual studio 2008 package.
• Converting SQL Server 2000 DTS packages to SQL Server 2008 SSIS packages.
• Modified Data Flow tasks using Visual Studio 2008
• 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.
• 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 2012, 2008/2005/2000 , T-SQL, XML, SSIS, SSRS, SSAS, MS Project & Windows 2003 server, Visual Studio 2008, Redgate SQL tool belt

Confidential, Charlotte, NC

SQL Server DBA

Responsibilities:

• Actively involved as part of team for gathering and analyzing the needs of end user requirement and system specification.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Worked heavily on coordinating the project between offshore and onshore teams in respect to data.
• 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).
• Performing query plans and making sure each query is using appropriate indexes.
• Provided on - call 24/7 provide support.
• Installed and maintained Active/Passive SQL clustering for production warehouse environment.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, Microsoft.NET, C#, ASP.Net

Confidential, Dallas, TX

SQL Server DBA

Responsibilities:

• Assisted in complete Life Cycle including Design, Development and Testing of Data migration project from several legacy databases to newly designed SQL 2008 centralized database repositary.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Used Reverse Engineering to create a buffer Database for Data Migration.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Sybase etc) and loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages to meet business needs.
• Worked on complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• 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.
• Created SSIS packages for importing data into staging environment for Cleansing, Parsing, and Scrubbing by using SSIS tools before getting loaded into destination.
• Applied various Data flow and Control flow transformations to meet the business needs.
• Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.
• Designed and deployed Reports with Drop Down menu option and Linked reports
• Developed drill down and drill through reports from multi dimensional objects like star schema and snowflake schema using SSRS and performance point server.
• Created subscriptions to provide a daily basis reports and managed and troubleshoot report server related issues.
• Implemented the Transactional Replication for off-loading the OLTP production environment from reporting.
• Involved in implementing high available solution by implementing Active/Active clustering and DR site by using mirroring technologies.
• Used Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhance the performance of Databases.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services (SSRS).

Environment: MS SQL Server 2005/2008, SSIS, SSRS, Microsoft.NET, MS Office Access2003, Excel, C#, ASP.Net, VBScript, Erwin.

Confidential, Phoenix, AZ

SQL Server DBA

Responsibilities:

• Involved in complete life cycle of SDLC and also responsible for designing of logical as well as physical database.
• Created indexes for better performance.
• Created packages to migrate data from different data sources to data warehouse.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Extracted required mapping fields from different sources (schema, CDW) to data Warehouse for Staging Table.
• Tested the data with complex queries, joins, sub queries and temp tables.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Rendered reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Scheduled report and exported in PDF format.
• Documented all database objects, procedures, views, functions & packages for future references.
• Performed all QA testing and match results for different environments.
• Documented all old and migrated Store Procedures and scripts for future references. Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Worked on linked servers to run distributed queries between SQL servers.

Environment: SQL Server, SSRS, SSIS, T-SQL, Visual studio 2008, Oracle 9i