SUMMARY:

• To pursue a challenging role as a SQL Server DBA/Developer where I can effectively contribute my professional knowledge, skills and expertise in designing solutions that would help the organization achieve their desired goals.
• Expertise in relational database design using Microsoft SQL Server 2005/2008/2008 R 2/2012/2014.
• Expertise in SQL Server Analysis Services (SSAS) - OLAP, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), OLTP, .Net, C#.
• Involved in complete SSIS life cycle in designing, creating SSIS packages, deploying and executing SSIS packages for enterprise applications (Production).
• Expertise in creating Cubes using Star schema, building Facts and dimensions. Process, deploy across environments (Dev, QA, UAT, PROD)
• Expertise in handling more than 6-8 terabytes of data.
• Expertise in T-SQL skills - stored procedure, triggers, Indexes, functions, views, tables, constraints.
• Designing Reports with multiple data sources, data sets, using ad-hoc queries.
• Experience with database performance tuning, Query optimization and database consistency check.
• Experience in implementing Database Back-up plans (Full, TLog, and Diff) and disaster recovery strategies.
• Experienced with Replication (Transactional, Snapshot), Clustering (Active-Active/Active-Passive), AlwaysOn Availability group, Log Shipping.
• Expertise in Planning and recovering environments in the event of disasters.
• Experienced in all aspects of system development life cycle such as requirement analysis, design, development, testing, deployment & maintenance of projects. Expertise in TFS and Database project.
• Capacity planning and growth of applications and Infrastructure components.
• Ability to prioritize multiple tasks and flexible to adapt to the business dynamics.

TECHNICAL SKILLS:

• DBMS used: MS SQL Server 2005, 2008, 2008R2, 2012, 2014, MS Business Intelligence tool, Oracle 10g, Visual Studios 2013, 2012, 2010
• Development Tools SSDT, SSMS, SQL Profiler, SQL Diagnostic Manager, SQLSafe, Ignite, Toad, and Tortoise SVN client, TFS, Eclipse PDT, Power Pivot, Power View, Imperva SecureSphere 10.
• Other Programming Skills .Net, C#, T-SQL, MDX, PHP 5.3/5, HTML 4.01, CSS2, JavaScript, and XML.
• Operating System Linux, Windows XP, Windows 7
• Web Servers Apache Http Server, Apache Tomcat 4.0
• Good communication and interpersonal skills.
• Excellent team player with positive attitude.
• Attention to detail and ability to handle multiple tasks.
• Ability to explore, learn and apply software technologies to find better and cost efficient solutions.

PROFESSIONAL EXPERIENCE:

SQL Server Consultant

Confidential, Houston, TX

Responsibilities:

• Involved in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS).
• Development and Deployment of SSIS packages and Reports.
• Design, Develop and implement ETL processes to load data from different sources to target tables.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2012/2014).
• Developed SSIS package using Script Task/Script Component that involves extensive use of .Net and C#
• Created SQL views and stored procedures to join multiple tables.
• Extensively worked on SQL Server Reporting Services (SSRS), developed reports on agile methodologies.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into Data warehouse from different sources for the cube design.
• Expertise in creating SSAS Cubes using Star schema. Designed MDX queries to retrieve data.
• Troubleshooting the long running Queries and Stored procedures.
• Developing T-SQL scripts for maintaining administration tasks.
• Monitoring Database Log shipping.

SQL Server Database Administrator/BI developer

Confidential, Charlotte, NC

Responsibilities:

• Installing and maintaining SQL Server database systems that include successfully resolving system issues, and database recovery, etc.
• Monitor and maintain all SQL Server instances (Production, Staging, QA, & Development). All SQL Server subsystems (SQL Agent, SSIS, SSAS, SSRS) Backup and recovery processes.
• Implemented data mart, facts, dimensions, OLAP cubes using dimensional modeling.
• Involved in the complete data warehouse development life cycle, actively supported business users for change requests.
• Involved in creating measure groups, KPIs & deployed SSAS cubes.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test/staging environments to production.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Setting up and Monitored snapshot replication, Database mirroring on Production and QA servers and troubleshoot Log Shipping.
• Responsible for detailed technical design of schemas, stored procedures, functions, triggers, referential integrity, security.
• Created SSIS packages using various Tasks - transformations, Look up, Aggregate, Derived Column, Conditional Split, Data Conversion, Execute SQL task, containers.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Experience in providing Logging, Error handling and Custom Logging for SSIS Packages and Performance Tuning.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to DWH and Data Mart Databases.
• Responsible for the development of best practices for database development.
• Active participation in requirements analysis.
• Strong skills in database performance analysis and tuning.

SQL DBA/Developer

Confidential, Charlotte, NC

Responsibilities:

• Involved in design, development and deployment including testing and debugging of reports in SQL Server Reporting Services (SSRS) 2012, 2008R2, 2008 .
• Involved in creating SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs and using MDX query.
• Created table schema and stored procedures that were used in developing Reports.
• Experienced in writing stored procedures and functions for generating Tabular reports, Formatting report layout, Groupings (row and column level) Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2012 based on the financial data.
• Created Parameterized reports and Linked reports with thorough knowledge of report architecture. ( Table, chart and matrix report, Drilldown, drill through ).
• Involved in developing Complex SSRS Reports and linked reports using Sub-Reports, Matrix/Tabular Reports, Charts and Graphs, Drilldown, drill through
• Complete understanding of the Business Intelligence (BIDS) 2008 through 2012, including data connections, multi-select lists.
• Managing Shared Data sources and permissions, Configured Reports Snapshots, Report Caching for reporting performance.
• Involved in creating report models and applying row level security filters for report model.
• Responsible for creating datasets using T-SQL and stored procedures.

SQL Server Database Administrator/Developer

Confidential, San Antonio, TX

Responsibilities:

• Experience in Database Design, Development and maintenance of database applications on SQL Server 2000/ 2005/2008/2008 R2/2012 in OLTP/OLAP environment.
• Created T-SQL objects such as Indexes, Views, Triggers, Functions, and Stored Procedures to facilitate efficient data manipulation and data consistency.
• Planning, Creating and Optimizing (Reorganize, Rebuild) Indexes in SQL Server.
• Normalized the database which included approximately 60-80 tables.
• Co-ordinate with front end developer in designing the business rules.
• Involved in creating ER Diagrams and mapping the data into the database objects.
• Designed and developed SSIS Packages to import and export data from various sources.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in all environments (DEV, QA, UAT, and PROD).
• Used various Transformations/Tasks in SSIS Dataflow, Control Flow using forloop Containers and Fuzzy Lookups.
• Implemented Event Handlers and Error Handling, Custom error handling in SSIS packages.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Installing & Configuring SSAS, SSIS, SSRS.
• Memory Management for SQL Server Analysis Services
• Cube Deployment using BIDS, deployment wizard.
• Logging, Monitoring, and Optimizing an Analysis Services Solution
• Backing Up and Restoring an Analysis Services Database (OLAP)
• Troubleshooting and Optimizing SSIS package performance
• Deployed and Scheduled SSIS Packages
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS .
• Installing and Configuring Reporting Services
• Created Reports to meet business requirement
• Managing Shared Data sources and permissions
• Configured Reports Snapshots, Report Caching for reporting performance
• Created and managed subscriptions for Reports
• Assigning report level permissions to Secure business information
• Creating Subscription for Reports
• Configure Backups for Reporting Services
• SQL Server Setup, Installation, Version Upgrade & Architect Setup
• Worked in OLTP & OLAP environment that includes Production (24x7) support, Updating with latest service packs and security patches on Production Servers, Clustered Servers.
• Implementing and Maintaining Log Shipping | Database Clustering | Mirroring
• Design, Developed and Implemented Database Backup and Restore Scripts & Disaster Recovery Strategy and automated the process using SQL Server Agent.
• Database Archiving / Partitioning (Horizontal / Vertical) tables for better performance.
• Performance Tuning for Locking, blocking, I/O bottlenecks, CUP, Memory and Monitor log files, Space Management.
• Auditing SQL Server Security - enabling TDE, CDC, and Data Scrubbing.
• Plan, Design and Scheduled Database Maintenance Plan & Administrative Tasks
• Configuring Replication / Data Synchronization / Log Shipping / Windows Clustering
• SQL Server Database Monitoring with DDL Triggers | SQL Server Profiler | Event Notifications
• Schedule SQL Jobs | SQL Server across multiple Servers using SQL Server Agent.
• Performance Tuning - Execution plan, Profiler, Performance Monitor, Extended Events, and Resource Governor
• Planning and testing Disaster Recovery process.
• Troubleshoot Infrastructure issues related to SQL database server such as Memory, CPU, I/O, Disk, etc.
• Created Linked Servers between different instances of SQL Server.
• Having Experience on Data center servers and handling more than 1.5 TB databases.

SQL Engineer/Developer

Confidential, Nashville, TN

Responsibilities:

• Involved in the Front-end Designing and Database Creation.
• Designed SSIS Packages to transfer data from FTP files to SQL Server using Business Intelligence Development Studio.
• Scheduled and monitored SQL Server Jobs making sure job run successfully every week.
• Experience in supporting highly transactional databases and troubleshooting various performance on different environment (production, DEV, UAT, Test etc.)
• Expertise in designing of database in SQL Server 2008 and Reporting services. Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.
• Rebuilding the indexes at regular intervals for better performance
• Extensively worked on Enterprise Manager for managing the database
• Troubleshoot performance problems and fine-tuning of databases
• Provided ongoing support for external clients’ web application including ongoing technical support on web site application issues.
• Creating and maintaining documentation.
• Design and development of web-applications for external customer facing clients using PHP.
• Implemented website and layout enhancements using HTML, CSS and jQuery.

Programmer Data Analyst

Confidential, Alpharetta, GA

Responsibilities:

• Implemented schema design and database functions for storing and retrieving data on Locums practice physicians.
• Executed SQL queries in order to support information that are required by the client and this included SQL backup and high availability solutions.
• Implemented database functions for email marketing lists.
• Involved in trouble shooting and fine-tuning of databases for its performance, monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better Query performance
• Proficient in SQL Server Replication, Backup and Restore, and planning Disaster recovery.
• Created DTS package for data transfer between the two environments.
• Troubleshoot performance problems and fine-tuning of databases.
• Developed intranet web Application to keep track of Locums practice openings across the nation.

QA Software Analyst

Confidential, Boise, ID

Responsibilities:

• Designed and developed test cases based on business requirements.
• Developed and documented manual /automated test results, reviewed test cases.
• Troubleshooting of Printer network programming
• Coordinated Quality Assurance procedures including testing and debugging of code.