SUMMARY

• Over 8 years of DBA experience on Data Design, Development and Administration on SQL Server 2012, SQL Server 2008 R2, 2008 and 2005 system in OLTP/OLAP environment.
• Expert in RDBMS concepts and constructs to design relational databases model and implementation as per business needs.
• Extensive experience in writing complex T - SQL.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP and DTS Packages. creating new databases, troubleshooting SQL issues and supporting customers.
• Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing/Client-Server/e-commerce applications.
• Knowledgeable in designing XML documents using DTD, XML Schemas, XSLT and XPath queries for its integration in database.
• Adequate noledge of SDLC and ITIL Methodologies in regards to IT Infrastructure Management. provide Microsoft SQL Systems DBA support for operational tasks including database/instance migrations.
• In-depth noledge of T-SQL (DDL, DML, and DSL).
• Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
• Migrate SQL Server 2000 to SQL Server 2005
• Involved in data migration SQL 2000 to SQL 2005 and SQL 2005 to SQl 2008 using Copy Database Wizard.
• Expert in implementing business logic in backend using dynamic stored procedures, effective triggers and useful functions.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Skilled at assessing client needs, working in a group, suggesting ideas dat enhance efficiency and maximize performance, implementing cutting-edge technology solutions, and supporting end users.
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
• Expertise and Interest include Administration, Development, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases., Replication, Log Shipping, Full-text indexing, and Database 24 X 7 Production Database on Call Support.
• Experience in Clustered Servers with sizes ranging from 2 Terabytes to achieve maximum performance and uptime in production environment.
• Experience in migrating Enterprise level high volume transactional web application website from IIS 6.0 to IIS 7.5 on Windows server 2008
• Maintaining multiple Internal/External websites on IIS … on multiple server environments using various techniques(Multiple IPs, Ports, Host headers)
• Configuring SSL certificates for IIS applications
• In-depth experience performing IIS log analysis to identify web server issues
• Extensive experience in debugging IIS issues using debugging tools such as log parser

Good Business and System Analysis skills to understand teh requirements and design application to satisfy customers.

TECHNICAL SKILLS

Languages: T-SQL, SQL, PL/SQL, DynamicSQL, .NET Framework, C#, AMO, ASP.NET, MS Sharepoint, XML, VB.Net, HTML, DHTML, HTTP, Shell Scripting.

RDBMS: SQL Server 2012/ 2008/2005/2000 , Oracle 11g/10g/9i/8i and MS Access 2003/2000/97 Oracle BI Publisher

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modelling, FACT & Dimensions tables, Physical & logical data modelling and De-normalization

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio.

Tools: and Utilities SQL Server Management Studio,SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Web Services, SOAP.

Operating Systems: Unix, Windows NT/2000 Server/XP/Server 2008 and MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

MS SQL Server Developer

Responsibilities:

• Create, upgrade and patch SQL 2005/2008 servers, instances, and databases
• Provide day to day support and administration of 40+ SQL Servers
• Install SQL Server 2005, 2008 and 2000, service pack and hot fix installations.
• Maintain SQL Servers at peak performance through proactive monitoring, capacity planning and maintenance planning
• Monitoring IIS application logs, System logs and security logs by using Event Viewer for troubleshooting application and windows server related issues. creating new databases, troubleshooting SQL issues and supporting customers.
• Good experience in debugging ASP.NET and IIS related issues
• Analyzed source system data and designed teh star schema for teh data warehouse to be developed.
• Provide disaster recovery for all databases which include full, differential, and transaction log backups and testing restores
• Develop, publish and troubleshoot SSRS reports dat includes creating UDF's, views, and stored procedures
• Contribute to teh ETL processes for loading and extracting data
• Maintain database changes from development to production instances
• Work with and develop ad hoc queries and scripts.
• Strong noledge of Relational Database Management Systems (RDBMS) concept in teh database like SQL Server 2008.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Warehouse for reporting.
• Design Physical Data Model for teh Logical Model provided from teh Analysts and building constraints on teh model to implement teh business rules
• Assisted in teh design of databases and data warehouse to ensure interoperability with BI solutions.
• Utilize maintenance plans and SQL jobs to automate tasks, including index maintenance and ensuring database integrity
• Develop and execute T - SQL scripts and stored procedures for business processes
• Implement and maintain high availability options including replication, mirroring, log shipping, and AlwaysOn
• Design, monitor, and administer two Sharepoint site collections dat includes DB maintenance, security, creation of sites, and implementing web parts
• Work closely with systems and network engineers to optimize infrastructure
• Maintain user profiles, email options, etc. using Active Directory
• Utilize Equallogic iSCSI SAN to monitor drive space and create volumes and snapshots when needed.
• Administer teh document management system (Imageright) dat has over 75 million documents and is larger TEMPthan 12TB in size
• Design complex workflow solutions for Imageright
• Provide security for Imageright, which includes managing file level, program level, and workflow level security groups

Environment: SQL Server 2000 Enterprise Edition, SQL Server 2008R2/2005/2000, SQL Analysis services, Enterprise manager, Query Analyzer, ERWIN, Sql server 2005, IIS, XML, MS Project, MS Access 97 / 2000 & Windows Server .

Confidential, Encinitas, CA

MS SQL DBA

Responsibilities:

• Created reports with teh different states as parameterized fields, grouped by Account types dat contained sub-groups as customer accounts dat further drilled down into details.
• Upgraded teh existing database to SQL Server 2008r2. creating new databases, troubleshooting SQL issues and supporting customers.
• Experience in designing Database Models using Erwin 7.0.
• Worked with SSIS to import, export and transform teh data between teh linked servers.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Created database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL and PL/SQL in Development and Production environment for SQL Server 2008r2.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Partitioned many tables, which has frequent inserts, updates and deletes to reduce teh contention and to improve teh performance.
• Resolved any deadlocks issues with teh Databases/Servers on a real-time basis.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Developed SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs)
• Generated complex custom Reports using SSRS 2008 as per teh customer requirement.
• Created parameterized reports using SSRS
• Migrated DTS objects to SQL Server Integration Services (SSIS) environment by using migrate
• DTS200 package wizard in BIDS
• Responsible for extracting and transforming data using DTS Import/Export, DTS Packages, MS SQL Server Integration Services (SSIS) Packages, Bulk Insert and Utilities like BCP.
• Extensively used Control & Data Flow Transformations like OleDB command, execute SQL task, sequence generator, send mail task, derived column, conditional split, lookup, multi cast and script component task in SSIS
• Created Cubes using SQL Server Analysis Services (SSAS) according to business requirements.
• Refreshing teh cubes to get teh latest information and deployment of cubes to teh production server.
• Fine tuned SQL queries using hints for maximum efficiency and performance.
• Experienced on ERP Modules Payables(AP), purchase orders (PO), Receivables(AR), Inventory(IN), General Lender(GL), order management(OM)
• Used Temp Tables to reduce teh number of rows for joins, to aggregate data from different sources for different reports.
• Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
• Used SQL Profiler for getting teh trace activity for teh Various Stored procedures and used Index Tuning wizard for performance betterment.
• Developed DTS packages to extract, transform and load into teh Campaign database from OLTP database using SQL Server Integration Services (SSIS).
• Used DTS to created jobs to populate some of teh tables with data from other servers
• Created standard, drill down and sub reports with teh various Confidential products in teh master report and their details in teh sub-reports using formula fields, parameter fields, Running Totals, Sorts, Group selection and Record selection in Crystal Reports XI.
• Created a number of complex formulas to find teh current balances of teh customers, teh product usage, credit card balances and other related stats in different reports.
• Scheduled teh reports on safe pass, bank/credit card transactions to run on daily/weekly/monthly basis and email teh results to teh business users in teh required format.
• Developed queries, stored procedures in MS SQL Server to reduce crystal report processing time and enhance teh efficiency of performance.
• Involved in teh customization, alteration and development of existing tables, views, indexes, stored procedures (in MS SQL Server) to better suit teh reporting requirements and needs.
• Designed ETL architecture to move data from various data sources like flat files, Excel, Access, Oracle 10g into Data Warehouse using SSIS 2005/2008.
• Published teh reports in crystal enterprise and scheduled teh reports in different formats (Email, Public folder etc).
• Managed all indexing, debugging, optimization using T-SQL, created/modified SQL Joins and other T-SQL code to implement business rules

Environment: MS SQL Server 2005/2008, Oracle 10g, Business Object XI R2, SSRS 2005, T-SQL, PL/SQL, SSIS, Access and Excel

Confidential

MS SQL DBA

Responsibilities:

• Involved in creating functional and technical specification documents after gathering requirements from business users.
• Responsible for creating teh complex SSRS reports like On demand, Summary Reports, Sub Reports, Drill-down, grouping, Cross-Tab, ad hoc, graphical reports dat include grouping, sorting, selection criteria, running totals, alerting, drill-down and parameter prompt.
• Created a stored procedure dat is scheduled to run exactly teh same time every evening to fetch data (prices) from teh base table dat has been changed and to update teh values in teh other relevant tables.
• Also created complex queries, functions, packages and stored procedures for Reports using PL/SQL and T-SQL.
• Managed Crystal Enterprise reports repository with automatic versioning and accordingly scheduled reports with data updates.
• Created a master report dat had teh entire product price download, showing all teh prices of products grouped by teh product family .
• Created a stored procedure dat would delete any records from teh history table dat is older TEMPthan a month.
• Worked with DBAs, Application developers and Business users to ensure dat requirements meet expected results.

Environment: MS SQL Server 2005, Oracle 9i, SSRS, Crystal Reports, T-SQL, PL/SQL, Access, Excel