SUMMARY

• Over 7 years of experience in SQL Administration, Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2000/2005/2008/ R2/Denali for both OLTP & Data warehousing(SSIS,SSAS,SSRS) applications in various business domains.
• Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
• Involved in relational data modeling and multi-dimensional modeling using Denormalization, Fact tables, Dimension tables, Star schema for OLAP systems.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Performed daily tasks including backup and restore usingtools likeSQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience working in Waterfall and Agile development methodologies.
• Self-Motivated with Excellent communication skills with a strong focus on Client oriented service and ability to work excellently as an individual and also as part of a team with minimum amount of supervision.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 20005
• Experience in creating maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics

TECHNICAL SKILLS

Databases: MS SQL Server Denali/2008R 2/2005/2000/7.0, ORACLE, Cassandra

Database Tools: MS SQL Server 2008R2/2005/2000, MS-Access, SSIS, DTS, SSAS, BIDS And Erwin

Development skills: SQL, PL/SQL, SSIS/SSRS/SSAS, C#, HTML, Angular JS, CQL

Languages: VB Script, T-SQL, HTML, XML, ASP, Java Script, Vulcan, C and C++

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

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, Visual studio, GIT, REDGATE.

PROFESSIONAL EXPERIENCE

Confidential, Austin, Texas

MS SQL Developer/DBA

Responsibilities:

• Involved in gathering Requirements form the Business and worked as a part of Data Modeling Process.
• Continues Interaction with the business for the Data delivery and Data quality.
• Performed ETL (SSIS) from various data sources like Data warehouse, Oracle, Excel, CSV, Text files and various client servers.
• Monitored space usage, and adjust database as needed.
• Monitored/created backup operations, and schedules manual backups as needed.
• Developed various Stored Procedures and implemented different business logics, Filters to pull required data from sources.
• Maintain SQL Server Login administration, Backups and recovery plans.
• Develop/Deploy SSIS packages in SQL Server 2008/R2.
• Maintained Database performance/tuning by using various optimizing tools such as Performance Monitor, SQL Profiler and Other Red Gate Tools.
• Performed various deployments and releases using REDGATE tools.
• Immensely worked on Stored Procedures, Functions, Index’s and monitoring the Performance of all the Databases.
• Established and enforced all database standards
• Work with OPS to resolve production issues.
• Every third to fourth week, be on-call and support any database related issue (24x7).

Environment: MS SQL Server 2008/R2,BI,REDGATE, Visual studio, .net, BMC Workflow, GIT Repo, C#, Cassandra, XML, SQL Profiler, Nagios, ARIC, ERWIN, Version One, Agile Methodology.

Confidential, Columbia, MD

MS SQL Developer/DBA

Responsibilities:

• Developed various T-SQL queries, Stored Procedures for data retrieval, maintenance and testing.
• Developed various SSIS packages for managing current and historical data using various transformations.
• Design and implement Mater Data Services (MDS).
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• Automated the Batch Processing and Version Validation.
• Created and published various Business rules to validate master data to ensure Data Accuracy and completeness.
• Involved in updating the servers from 2008R2 to DENALI (CTP3) version.
• Coordinated with platform hosting vendor(s) DBAs to ensure proper support maintenance, and tuning of various databases
• Monitored space usage, and adjust database as needed.
• Monitored backup operations, and schedules manual backups as needed.
• Integral part of the Warehouse team for the Design, Development and functioning of cube.
• Worked in Production environment and resolved the tickets in time to deliver the requirements.
• Directed resource/capacity planning for systems/databases by monitoring databases, checkpoints, and back-ups.

Environment: MS SQL Server 2008R2/DENALI, SSIS, SSAS, MDS, VULCAN, EXCEL, Visual Studio, TFS.

Confidential, Findlay, Ohio.

MS SQL Server Application DBA.

Responsibilities:

• Involved in SDLC and dynamically supported business users for given requirements.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Created database maintenance plan for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Developed various database objects such as Tables, Indexes and Constraints based on the requirement.
• Expertise in creating SSIS packages to clean and load data to data warehouse.
• Created packages to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to load underlying data into the tables from various sources.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Created Dimensions with the cube wizard and also individually and Deployed Cubes to the production server.
• Rebuilding / Monitoring the indexes at regular intervals for better performance
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases

Environment: MS SQL Server 2005/2008, SSIS, SSAS, SSRS, EXCEL, Flat File Source, SQL Profiler.

Confidential, Santa Clara, California

MS SQL Server Developer/DBA.

Responsibilities:

• Created T- SQL queries for Data retrieval, Monitored performance and Optimized SQL queries for maximum efficiency.
• Created and modified Stored Procedures as per the business logic.
• Created Views and other database objects like tables and indexes as per design needs and for security reasons.
• Gathered Requirements from the end user and involved in developing logical model and implementing requirements in SQL Server 2005.
• Designed SSIS packages to pull data from different data sources to database.
• Good experience in working with control flow and work flow tasks like Containers, Precedence Constraints, Execute SQL task in SSIS.
• Transformed the data using different transformations like Aggregate, split, join, merge, Fuzzy lookup of SSIS.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005 that maintained data.
• Involved in the complete data warehouse development life cycle.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Defined report layouts for formatting the report design as per the need and even defined Datasets for report generation.
• Wrote queries for drill down reports to get the dataset required to build the report.
• Formatted the reports using Global variables and expressions.
• Maintained data integrity by performing validation checks. Optimized queries tuned and monitored server performance.

Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, T-SQL, Windows XP.