PROFESSIONAL SUMMARY

• Over 15 years of experience as SQL Server 2012R2/2008R2/2005/2000 DBA/Developer which includes 4 year as Database and DWH Architect
• Extensive knowledge of RDBMS concepts, Data Modeling and Database Design and Architecting for OLTP and OLAP.
• Expertise in Administration, Database Design, Development, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases and provided 24x7 Production DB On - Call Support.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities.
• Experience in Backup & Recovery Strategies and Disaster Recovery Procedures includes Replication, Mirroring and Log Shipping.
• Install, configure and monitor Database Replication using snapshot, transactional or merge replication to provide database redundancy across multiple geographical locations.
• Expertise in migration from SQL Server 2000 to SQL Server 2005/2008 and from SQL server 2008 to SQL Server 2012
• Experienced in Disaster Recovery Planning, Capacity Planning, Security Management, Managing server and clients, High Availability options.
• Specialized in Active/Passive, Active/Active and Slip stream version of SQL clustering and setting up Always on Availability Group
• In-depth knowledge of T-SQL. Expert in implementing business logic in backend using Stored Procedures, Triggers, Views, Scripts and Functions.
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, TYPEPERF and Windows Performance Monitor.
• Expert in automating the process by creating jobs and error reporting using Alerts, SQL Mail Agent.
• Experience in Clustered Servers with sizes ranging from 1 Terabyte to achieve maximum performance and uptime in production environment.
• Experience in Data Architect are to create logical and physical data models and database objects for OLTP and Data warehousing projects using ERStudio and ERwin.
• Experience in design and implementation of Data marts and Enterprise Data Warehouses and BI applications
• Experience in extracting and transforming data using SSIS Import/Export Data, Bulk Insert, BCP and SSIS Packages.
• Experienced in Integration Services (SSIS)/DTS for data migration tasks and automated data load processes
• Experience in using SSIS variables, Parameters, Expressions, Checkpoint file and SSIS Configuration files featured to migrate and to automate data loading process
• Experience in Industry leading ETL tools such as Informatica Power Center, DataStage and SAP data Services.
• Experienced in data warehousing, dimension modeling, designing OLAP Cubes on Analysis Service (SSAS) and Hyperion Essbase
• Created MOLAP Warehouse on SQL 2005 Server Analysis Services and created multiple cubes with dimensions and facts. Optimized MOLAP Cubes by partitioning them, Designing Aggregations, implementing Hierarchies and Calculated Members.
• Hands on experience in implementing Key Performance Indicator (KPI), Calculations and Aggregates Objects in SSAS 2005.
• Implemented Cube Perspectives for displaying different subsets of data to different users.
• Install, Configure, Author and deploy reports using SSRS (SQL Server Reporting Services)
• Experience in different team projects with good project implementation experience (SDLC/SLA), team skills, troubleshooting, presentation abilities and issue resolution capabilities.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts.
• Worked on on-site and off-shore model

EXPERIENCE DETAILS

Confidential

SQL Server Architect

Responsibilities:

• Working on request related to SQL server received in “APS Database SQL Server Level3” support group queue
• Installation of SQL server 2012 standalone instances and 2008R2 on active/active cluster installations.
• Setup and maintenance of “Always on Availability Group” for various applications and setup weekly maintenance tasks for databases.
• Created and managed databases as per the industry standard to support application development and support.
• Monitoring and maintenance of SQL server production databases on 24/7 schedule to support mission critical applications and SharePoint environment of the department.
• Apply patches to SQL Server Instances on clustered environment and failover the nodes as per the requirement using windows cluster manager.
• Created SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created and maintained File groups at database level for optimum performance of database based on disk drive availability.
• Worked on log file backup and database shrink to get free space on disk drives whenever required.
• Monitoring SQL server instance for Blocking Transactions, Transaction Locks and Latches and resolved the same
• Created/Managed databases using SSMS, Database Wizard and T-SQL Statements (Scripts).
• Automated SQL backup and maintenance plans using SQL Agent and setting up alerts and notification using Sql Scripts.
• Ran Windows Performance monitoring tool to collect new data set during performance testing to identify cpu and memory utilization of SQL server instance.
• Configured Database monitoring tools to monitor production SQL instances and configured notification to send appropriate mails and to DBAGroups and operators.
• Using SQL server profiler and performance monitor utilities to identify the current running sessions and SQL, connections and system resource information.
• Capturing CPU and memory consumption related metrics in performance log for analysis during stress testing of OLTP applications.
• Identified and resolved CPU and Memory intensive issues on production Database instances and optimized existing SQL procedures and T-SQL by identifying performance issues.
• Designed and scheduled database maintenance packages for Indexes rebuild and defragmentation at regular intervals for better performance
• Effectively using DMV’s in SQL Server 2005/2008/2012 for tuning and optimizing the servers and monitor server performance
• Created Merge and Transaction replication to synchronize data between oracle and SQL server database tables
• Implemented Mirroring and Log shipping features to support high availability option of mission critical database in SQL 2008R2.
• Monitoring SAN disk space in production cluster, scheduled SQL Server jobs meant for Backup and database maintenance tasks.
• Worked with Linked Servers and OPENQUERY to retrieve the Oracle data into SQL Server 2005.
• Maintaining the database consistency with DBCC at regular intervals
• Created, tuned, monitored, maintained & Scheduled SQL Server Agent Jobs for various database administration tasks.
• Applying SQL server related patches on clustered and standalone instances.
• Capturing SQL server related performance pointers during application performance testing,
• Creating Service request using “Service Now” and working with other DBA groups on SSIS and SSRS deployment process.
• Created Logical Model and Physical Models using ERStudio for OLTP and OLAP applications
• Created database objects from physical model by defining appropriate target database in ERStudio and generated data model reports using report templates.
• Developed ETL Packages using SSIS to load data from Oracle, Excel and flat files to SQL Server 2005/2008 database tables and vice versa.
• Worked on identifying performance bottleneck in SSIS jobs and resolved the same
• Created SQL loader control files to load data into Oracle database tables from SQL server data sources.
• Completely automated data loading process by scheduling SSIS package in SQL Server Agent using file system deployment option.
• Effectively used variables, Parameters and Configuration file and Checkpoint point option in SQL server to support migration of packages to different environment.
• Deployed ETL packages in File system and MSDB deployment options with appropriate parameter files.
• Worked on migrating SSIS packages from SQL server 2008 to SQL Server 2012 and extensively worked in project deployment model.
• Wrote T-SQL Stored procedures, Functions and Triggers as per the requirement.
• Installed, configured SQL Server 2008R2 Reporting Services
• Design, Development, Testing and deployment of SSRS report and Sub Reports
• Design, Development and Testing of SSAS cube for out of Stock Data Mart.
• Designed Data source, Data source views, Dimensions, Hierarchies and cubes using BIDS
• Defined Attribute Hierarchies and setup Attribute Relationship as per the requirement.
• Setup up Measure and measure group with appropriate aggregate functions to handle fully additive and semi additive measures.
• Designed Calculations, KPI and Aggregations and Partitions in multi-dimensional cubes using BIDS
• Automated data refresh from dimensional data source to SSAS multi-dimensional cubes using SSIS packages and automated SSAS partitions manipulation using AMO objects in Script task.
• Created SSAS Roles to enforce the security at dimension attribute level for various users as per the business requirement.
• Responsible for ETL data load, SSAS data processing operations for out of stock data mart and cube.
• Design and Debugging ETL jobs to Data Migration using SAP Data Services from various legacy systems as per mapping details document.

Environment: SQL Server 2008/2008R2/2012R2 with clustering, T-SQL, Windows 2003/2008(x86/x64), SSIS/SSRS/SSAS, MDX, Oracle 10G/11G and 12C, Visual Studio, C#, VB and TFS 2010, Windows 7 R2 Cluster

SQL Server Consultant

Confidential

Responsibilities:

• Installed 4 Node Active/Active SQL server 2008R2 cluster on Windows 2008R2 server
• Created and maintained SQL server and Oracle 11G databases and database objects.
• Responsible for Backup and Restore of databases based on user request using SSMS and RMAN
• Worked with Oracle professionals to setup and configuration of Exadata for the department.
• Installation of Oracle and SQL server client and shared components as per need.
• Worked on tablespace and filegroup management.
• Monitored database/instance using Oracle enterprise manager
• Automated Sql server database maintenance tasks as per industry best practices
• Wrote T-SQL and Pl-SQL Stored procedures, Functions and Triggers as per the requirement using industry best practices
• Created materialized views for reporting purpose and schedule it to refresh at regular interval.
• Worked on performance optimization of procedure, function and triggers in T-Sql and Pl-SQL
• Created Logical and Physical Models using ERStudio for OLTP and OLAP applications and created database objects from physical model by defining appropriate target database in ERStudio and generated data model reports using report templates.
• Developed ETL Packages using SSIS to load data from Oracle, Excel and flat files to SQL Server 2005/2008 database tables and vice versa.
• Worked on identifying performance bottleneck in SSIS jobs and resolved the same
• Completely automated data loading process by scheduling SSIS package in SQL Server Agent using file system deployment option.
• Effectively used variables, Parameters and Configuration file and Checkpoint point option in SQL server to support migration of packages to different environment.
• Deployed ETL packages in File system and MSDB deployment options with appropriate parameter files.
• Worked on migrating SSIS packages from SQL server 2008 to SQL Server 2012 and extensively worked in project deployment model.
• Wrote T-SQL Stored procedures, Functions and Triggers as per the requirement.
• Design and Debugging ETL jobs to Data Migration using SAP Data Services from various legacy systems as per mapping details document.
• Using appropriate lookup functions in the ETL jobs based on source and targets.
• Works extensively on various transforms such as query, SQL, table comparison, history preserve, case etc.
• Extensively used XML Transformations to read data from XML files
• Preparing test plans, master test plan document with appropriate test cases and ETL design document.
• Periodical back up of ETL jobs as .atl files.
• Identifying performance bottle neck and applying optimization techniques at the Sessions, database, and mapping level to increase the mapping performance.
• Automating data loading process using Active Batch Scheduler
• Monitored data loading process in Workflow Monitor and identify and resolve the data loading issues
• Migrated Data Integrator from AIX UNIX to Windows Server 7.
• Converted Shell scripts into PowerShell script to support ETL migration
• Developed ETL job using Business Objects Data Integrator to load data from Oracle, Excel and flat files to SQL Server 2005/2008 and Oracle database tables and vice versa.
• Worked on identifying performance bottleneck in ETL jobs and resolved the same
• Design and Debugging ETL jobs to Data Migration using SAP Data Services from various legacy systems as per mapping details document.
• Using appropriate lookup functions in the ETL jobs based on source and targets.
• Works extensively on various transforms such as query, SQL, table comparison, history preserve, case etc.
• Extensively used XML Transformations to read data from XML files
• Preparing test plans, master test plan document with appropriate test cases and ETL design document.

Environment: SQL Server 2005/2008/2012 R2 with clustering, T-SQL, Windows 2003/2008(x86/x64), SSIS/SSRS/SSAS, MDX, Business Objects Data integrator 11.x, SAP Data Services 14.03, Oracle 10G/11G and 12C, Visual Studio, C#, VB and ASP.Net, IIS, VSS, Erwin 7.1, SharePoint MOSS 2007, Windows 7 R2 Cluster, XML and XSLT, Toad 11.x

SQL Server Architect

Confidential

Responsibilities:

• Installed Active/Active SQL server 2008R2 cluster on Windows 2008R2 server
• Monitoring and maintenance of SQL server production databases on 24/7 schedule to support mission critical applications and SharePoint environment of the department.
• Apply patches to SQL Server Instances on clustered environment and failover the nodes as per the requirement using windows cluster manager.
• Created and managed databases as per the industry standard to support application development and support.
• Created and maintained File groups at database level for optimum performance of database based on disk drive availability.
• Designed database backup / restore plans and strategies for OLTP and OLAP applications and document the same at enterprise level.
• Monitoring SQL server instance for Blocking Transactions, Transaction Locks and Latches and resolved the same
• Automated SQL backup and maintenance plans using SQL Agent and setting up alerts and notification using Sql Scripts.
• Configured Database monitoring tools to monitor production SQL instances and configured notification to send appropriate mails and to DBA Groups and operators.
• Created SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Designed Database maintenance tasks as per requirement
• Fixed issues related to orphaned users on periodical basis.
• Worked on Transaction replication to synchronize data between oracle and SQL server database tables
• Upgrade SQL Servers from SQL Server 2005 to SQL Server 2008 and extensively used upgrade advisor utility
• Created Clustered, non-clustered, covering and Column stored indexes for OLTP and OLAP applications.
• Optimized the existing stored procedure by introducing table variables and temp tables.
• Performed Reverse Engineering to understand the database objects and relationship of various RDBMS databases and Forward Engineering in ER-Win / ERStudio/Visio to generate new schema objects.
• Created Logical Model and Physical Models using ER Win and effectively used comparison features available to compare sub models.
• Created database objects from physical model by defining appropriate target database in ERStudio and generated data model reports using report templates.
• Created Hierarchies at database table level as per the application requirement.
• Published data model Confidential and HTML reports of database into local intranet to assist the developers to have clear understanding of database objects and their relationship.
• Design, development, testing and deployment of T-SQL procedures, function and triggers
• Optimized existing T-SQL Procedures for better performance.
• Developed ETL Packages using SSIS to load data from Oracle, Excel and flat files to SQL Server 2005/2008 database tables and vice versa.
• Effectively used transformations such as Slowly Changing Dimension, For Each Loop, Execute SQL task, Aggregate, Lookup, Conditional Split, Derived Column, Script Component, and Row Count Etc.
• Completely automated data loading process by scheduling SSIS package in SQL Server Agent using file system deployment option.
• Effectively used variables, Parameters and Configuration file and Checkpoint point option in SQL server to support migration of packages to different environment.
• Deployed ETL packages in File system and MSDB deployment options with appropriate parameter files.
• Created ETL audit related tables to capture Data loading statistics on particular window with appropriate features.
• Supported Data loading processes on On-Call rotation and fixed the data loading issue on 24/7 window.
• Identified and resolved performance bottleneck in existing SSIS packages. Followed SSIS best practices in package development
• Worked on migrating SSIS packages from SQL server 2008 to SQL Server 2012 and extensively worked in project deployment model.
• Installed, configured, authored, and reports using SQL Server 2005 Reporting Services.
• Design, Development, Testing and deployment of SSRS report and Sub Reports
• Confidential SQL queries and Create Reports using SSRS 2005/2008 from the Data Warehouse, Data Mart and Cube
• Designed Data source, Data source views, Dimensions, Hierarchies and cubes using BIDS
• Used MDX to create Calculations, KPI and Aggregations and Partitions in multi dimension cubes
• Automated data refresh from dimension data source to SSAS multi dimension cubes
• Created SSAS Roles to enforce the security at dimension attribute level for various users as per the business requirement.

Environment: SQL Server 2005/2008/2012 R2 with clustering, T-SQL, Windows 2003/2008(x86/x64), SSIS/SSRS/SSAS, MDX, Oracle 10G, .Net, Visual Studio, C#, VB and ASP.Net, Er-Studio 8.1, SharePoint 2010, Windows 2008R2

Confidential

SQL Server Consultant

Responsibilities:

• Installed SQL server 2008/2008R2 on Windows7-R2 using server Stand-alone Installation option.
• Configured SQL Server for optimum performance and resource utilization using sp configure commands
• Created/Managed databases using SSMS, Database Wizard and T-SQL Statements (Scripts).
• Automated SQL backup and maintenance plans using SQL Agent and setting up alerts and notification using Sql Scripts.
• Configured Database monitoring tools to monitor production SQL instances and configured notification to send appropriate mails and to DB Groups and operators.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Identified and resolved CPU and Memory intensive issues on production Database instances and optimized existing SQL procedures and T-SQL by identifying performance issues.
• Used DBCC commands to get information about Index, performance related metrics and table level identity check and reseed.
• Created, tuned, monitored, maintained & Scheduled SQL Server Jobs for various database administration tasks.
• Used Export / Import utility to load/write database table data from heterogeneous tables and view
• Monitored and identified all active / blocking and locking transaction using SQL Server standard reports, sp who and SP Who2 commands.
• Design, Development and testing of SSIS package to load data into out of stock data mart
• Wrote dynamic T-SQL stored procedures to automate the audit information schema data population for ETL process
• Completely automated data loading process by scheduling SSIS package in SQL Server Agent using file system deployment option.
• Effectively used variables, Parameters and Configuration file and Checkpoint point option in SQL server to support migration of packages to different environment.
• Deployed SSIS packages using File System and MSDB deployment model to automate the data loading process after setting up proper proxies account at SQL server instances
• Worked on optimizing existing SSIS packages to reduce the data loading time drastically. Used Explain plan and ETL best practices as bench mark for optimization process.
• Installed, configured SQL Server 2008R2 Reporting Services
• Design, Development, Testing and deployment of SSRS report and Sub Reports
• Design, Development and Testing of SSAS cube for out of Stock Data Mart.
• Designed Data source, Data source views, Dimensions, Hierarchies and cubes using BIDS
• Defined Attribute Hierarchies and setup Attribute Relationship as per the requirement.
• Setup up Measure and measure group with appropriate aggregate functions to handle fully additive and semi additive measures.
• Designed Calculations, KPI and Aggregations and Partitions in multi-dimensional cubes using BIDS
• Automated data refresh from dimensional data source to SSAS multi-dimensional cubes using SSIS packages and automated SSAS partitions manipulation using AMO objects in Script task.
• Created SSAS Roles to enforce the security at dimension attribute level for various users as per the business requirement.
• Responsible for ETL data load, SSAS data processing operations for out of stock data mart and cube.

Environment: Windows Server 2003/2008R2, SQL Server 2005/2008R2, ER-Win 7.0, SSMS,BIDS, SSIS, SSRS, SQL Profiler, Performance Monitor, T-SQL, Oracle 8.0/9I/10G and IBM Cognos

Sr. SQL Server DBA

Confidential

Responsibilities:

• Installed SQL server 2008/2008R2 cluster on Windows 2008R2/Windows7 server using slip stream version on 2 node active/passive cluster environment for Georgia’s Race to the Top application.
• Supported Confidential of Education’s portal database.
• Worked with infrastructure team to use AWE (Address Windowing Extension) in sql server 2005 to use more than 4GB of RAM in database server
• Apply patches to SQL Server Instances. Monitoring SQL server instance for Blocking Transactions, Transaction Locks and Latches and resolved the same
• Created/Managed databases using SSMS, Database Wizard and T-SQL Statements (Scripts).
• Automated SQL backup and maintenance plans using SQL Agent and setting up alerts and notification using Sql Scripts.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Periodically checking database objects status using DBCC commands
• Identifying and resolving Database Blocks, locking transactions, schema changes related information from SQL server standard reports using SSMS
• Identified and resolved CPU and Memory intensive issues on production Database instances and optimized existing SQL procedures and T-SQL by identifying performance issues.
• Designed and scheduled database maintenance packages for Indexes rebuild and defragmentation at regular intervals for better performance
• Effectively using DMV’s in SQL Server 2005/2008 for tuning and optimizing the servers and monitor server performance
• Proactively monitor the Production Server and optimized stored procedures for better performance. Resolve locking conflicts and resource utilization issues
• Identified and resolved database performance issues using Standard reports and DMV and DMF in SQL 2005/2008/2008 R2
• Upgrade SQL Servers from SQL Server 2005 to SQL Server 2008 and extensively used upgrade advisor utility
• Migrated SQL Server 2005 to SQL Server 2008 in Side By Side and Parallel migration options
• Worked on Transaction replication to synchronize data between oracle and SQL server database tables
• Configured and tested Linked server to communicate with heterogeneous databases from SQL Server.
• Worked with Linked Servers and OPENQUERY to retrieve the Oracle data into SQL Server 2005.
• Maintaining the database consistency with DBCC at regular intervals
• Configured SQL-Sentry tool to interact with SQL Server instances.
• Defined and collected Data Collector Set to capture Performance monitor metrics for DB server to identify CPU and memory utilization by Sql server instances
• Created database Tables, Views, Schemas and Indexes as per the application requirement and followed industry best practices
• Identified and resolved most resource consuming queries and optimized them by executing estimated execution plan and placing appropriate indexes on the tables and views.
• Installed and configured SSRS 2008R2 on windows 2008R2 environment.
• Design, Development, Testing and deployment of SSRS reports using BIDS.
• Maintained SSRS security roles, created subscriptions to distribute the SSRS reports data as pdf documents to various county and districts users.

Environment: Windows Server 2003/2008/2008 R2, SQL Server 2005/2008/2008 R2,SSMS,BIDS, SSIS, SSRS, SQL Profiler, Performance Monitor, T-SQL, Oracle 8.0/9I/10G and IBM Cognos, ER-Win 6.1.3 and ER-Studio 7.1

SQL Server Architect

Confidential

Responsibilities:

• Installed 2 nodes Active / Passive SQL server 2008R2 on Windows 2008R2 for high availability option
• Closely worked with Network and Infrastructure to setup SAN disks, Windows clustering and RAID configuration.
• Created Databases for Data warehouse application and kept the recovery model as ‘Simple’.
• Created Secondary file groups and used the same to place data file and log file as per best practices
• Design and development and implementation of database backup plans of Data Mart databases and automated database backup operation using SQL-Agent.
• Created database logins to be used in SSIS packages, SSRS reports and SSAS cube processing and active directory users.
• Created database maintenance plan to back up the system and user databases, Index rebuild and automate the process using SQL server agent.
• Created Logical and Physical data models using ER-Studio
• Conducted JAD session to make sure that the data model meets the client’s requirements and industry standards.
• Published the data model Confidential in corporate intranet by generating reports from ER-Studio.
• Created database tables, views and indexes using SQL scripts generated by ER-Studio in appropriate file group with partitioned option.
• Installed Oracle 10G client components as part of Data Warehousing application implementation
• Created SSIS Packages to load data from heterogeneous data sources such as oracle9.I/10G, Flat files and ERP systems.
• Effectively used Dataflow, ftp and script components in SSIS packages to support data loading process.
• Used Merge, Merge join, lookup, union all, aggregate, data conversion, multicast, rowcount transformation in SSIS packages for data manipulation.
• Used SSIS expressions to automate the connection strings, variables to automate ETL requirements
• Automated data loading process by deploying SSIS packages in file system deployment options
• Installed, configured, authored, and reports using SQL Server 2005 Reporting Services.
• Design, Development, Testing and deployment of SSRS report and Sub Reports
• Confidential SQL queries and Create Reports using SSRS-2008 from the Data Warehouse, Data Mart and Cube
• Designed Data source, Data source views, Dimensions, Hierarchies and cubes using BIDS
• Defined Attribute Hierarchies and setup Attribute Relationship as per the requirement.
• Setup up Measure and measure group with appropriate aggregate functions to handle fully additive and semi additive measures.
• Used MDX to create Calculations, KPI and Aggregations and Partitions in multi-dimensional cubes
• Automated data refresh from dimension data source to SSAS multi-dimensional cubes
• Configured SSAS cubes for proactive caching to ensure the cube will have update data from the source.
• Created SSAS Roles to enforce the security at dimension attribute level for various users as per the business requirement.

Environment: Windows Server 2008R2, SQL Server 2008R2, SSIS, SSRS, SSAS, Data Marts, Profiler, T-SQL Oracle 10G, Visual Source Safe 2008, ER-Studio 7.1

Confidential

Responsibilities:

• Collaborated with software engineers, architects, and technology specialists to design database, clustering, and migrations.
• Provided an estimation of the migration plan in terms of feasibility, time duration and resources.
• Deployed and Administrated SQL 2005/2000 servers on production environment.
• Developed, implement and monitor a large-scale and time-sensitive production loading processes
• Develop and implement Replication, Archiving, Backup and Recovery strategies.
• Proactively monitor the Production Database and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• Manage and Create database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc.).
• Ensure all database environments (Development, Staging, QA and Production) are in sync. Define db scripts versioning system to keep track of database versions for all environments.
• Problem solving and issue resolution on production SQL stand alone and cluster databases.
• Design, review and implement production SQL Server database objects, models and database designs (schema)
• Migration of SQL Server 2000 to SQL server 2005 (includes re-writing the existing maintenance plans)
• Provide expertise in T-SQL for SQL Server
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Extensively worked on DBCC commands.
• Expertise in working with Very Large Databases (VLDB’S).
• Good experience in maintaining Log Shipping, Replication and Clustering.
• Implemented merge replication-based solution over a WAN to maintain warm backup servers in remote site, as well as for disaster recovery.
• Confidential replication of over 110 corporate centers using T-SQL scripts.
• Operational support for SQL Server Report services (SSRS) and Analysis Services (SSAS).
• Worked extensively on SSIS/DTS for Data Migration and Administration tasks.
• Extensively used Script task and Script component task in SSIS to perform custom tasks and data cleansing.
• Variables and expressions were used in the packages to generate custom SQL code to make SSIS package tasks dynamic.
• Created tables using SSIS to load error data, error descriptions and package execution diagnostics.
• Built & Deployed SSIS packages to SSIS Package Store & MSDB database.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Built the data mart using Star/Snowflake Schemas for various business Units.
• Identify and resolve database performance issues, database capacity issues and other distributed data issues.
• Apply patches to SQL Server 2000/2005. Upgrade Servers from SQL Server 2000 to SQL Server 2005.
• Managing multiple Production and Development Oracle Applications environments of different releases.
• Expertise on Microsoft Operations Management (MOM) to setup SQL Server Alerts.
• Worked on Informatica*Power Center to create robust and quality ETL jobs in stipulated time frame.
• Effectively used Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations in Informatica designer
• Extensively worked with the Lookup, Aggregator, Expression, Router, Filter, Update Strategy and transformations
• Effectively handled Workflow execution with control, restart junctions and email task.
• Identify and resolve ETL and Database performance issues
• Involved in performance optimization at mapping, session, and work flow and database level.
• Wrote optimized Pl-Sql stored Procedure, Function, and packages to improve performance in Oracle
• Prepared ETL design document, test plan document with appropriate test cases
• Mentored team members in Informatica Power center related tasks
• Worked with Offshore team
• Installed and configured Datastage 6.0 server edition on windows 2003 server
• Created DataStage jobs to migrate mainframe data into SAP tables .
• Confidential stored procedure using datastage manager modules

Environment: SQL Server 2000/2005, SQL Analysis services/SSAS, SSIS, SSRS, Informatica Power Center 6.0/7,x, Ascential Datastage 6.1/7.3, Oracle 9i, DB2 OS/390, Enterprise manager, Query Analyzer, ERWIN, SQL Server 2005, DTS, BIDS, MS Project, MS Access 97 / 2000 & Windows Server 2003 x86/x64, ADO.NET, OLE/DB, MOM, SCOM.

Confidential

SQL Server DBA / Developer

Responsibilities:

• Set up efficient monitoring of SQL Server jobs to ensure that failures are reported immediately.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Designed and created databases, tables, views, store procedures and triggers.
• Developed various views and functionalities for the Affinity Compensation system department according to their specification.
• Suggest index tuning and performance optimization techniques.
• Work with teams across the country in different time zones to meet their requirements. .
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Designed and developed file loading process by creating complex stored procedures, functions and bind them with DTS package for logical execution.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Designed new ETL jobs per the requirements and modified existing jobs to improve the performance in Ascential Datastage.
• Monitored data load process of mission critical applications and resolved the issues
• Worked with Data warehouse team to build the OLAP Cubes.
• Created Hyperion Essbase cubes, calculations and automated monthly data loading process using MaxL and Essbase commands.
• Monitoring SQL server performance using profiler to find performance and dead locks and blockings.
• Designed Business Objects Universe and Reports

Environment: Windows Server 2000/2003, Ascential Datastage 4.0/6.00, Business Objects 3.x, Hypersion Essbase 6.00, SQL Server 2000, DTS, Analysis Services, Data Marts, Profiler, T-SQL

Oracle 8.0, Data Stage 6.0 to 7.3, Hyperion Essbase 6.0, Business Objects 5.3

Confidential

SQL Server DBA/Data modeler

Responsibilities:

• Analyze the existing SQL Server in Production Environment.
• Maintain Reporting services on MSSQL 2000 platform.
• Backing up master & system databases and restoring them when necessary.
• Design the consolidation plan based on physical distribution of databases.
• Design backups for migration using LiteSpeed.
• Design stored procedures according to business requirements.
• Export or Import data from other data sources like flat files using Import/Export by DTS
• Export or Import data from other data sources like flat files using Import/Export from Bloomberg.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• To set up SQL Server configuration settings.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Migration of SQL Server 7.0 to SQL server 2000 (includes re-writing the existing maintenance plans)
• Rebuilding the indexes at regular intervals for better performance
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Worked on enhancing the application specific data sources and added new fields according to the requirement
• Maintain transactional replication on production SQL Servers.
• Install, configure and monitor database replication using snapshot, transactional or merge replication to provide database redundancy across multiple geographical locations.
• Maintaining the database consistency with DBCC at regular intervals
• Designed and created databases, tables, views, store procedures and triggers.
• Developed various views and functionalities for the Affinity Compensation system department according to their specification.
• Designed and developed file loading process by creating complex stored procedures, functions and bind them with DTS package for logical execution.

Environment: Windows server NT, DTS, SQL Server 7.0/2000, Oracle 8.0, VB Script, WMI, ERWIN, WinZip, FTP, ODBC, T-SQL