SUMMARY:

Experience Summary

• Around 7+ years of experience in SQL Server 7.0/ 2000, SQL Server 2005 and 2008 database Administration and Development.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Experience in implementing disaster recovery and High availability solutions using database mirroring, Clustering and log shipping.
• Extensively worked in OLTP & OLAP environment that includes Production (24x7), databases in SQL Server.
• Hands on experience in backup and restoration of databases, automating Administration, Security maintenance, and troubleshooting client-server applications.
• Knowledge in Database Analysis/Design/Normalization/Manipulation processes using SQL Server.
• Hands on experience in Troubleshooting database issues.
• Strong experience in performing database consistency checks and planning and scheduling Recovery procedures.
• Experience in designing logical and physical data models using ERWIN and ER/Studio tools.
• Expertise in developing reports using SQL Server 2005 Reporting Services (SSRS).
• Experience in Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Locking.
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, and Index Tuning Wizard to achieve better performance, accessibility and efficiency.
• Experience in installation and configuration of MS SQL Server 2000/2005/2008.
• Experience in Migration from SQL Server 2000 to SQL Server 2005.
• Experience with ETL and scheduling tools like UC4.
• Experience in resolving database performance issues, database capacity issues and distributed data issues.
• Experienced in developing Drill down reports, Drill through reports using SQL Server Reporting Services, Crystal Reports, and Excel spreadsheet
• Experience in database backups/restoration and recovery of NT server/SQL Servers.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
• Setup, Reconfigured and Monitored log shipping of production databases and also carried out role changes, role reversals and positioning the monitor server.
• Hands on experience of Database mail in SQL Server 2005.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by Using BCP, DTS and SSIS utilities.
• Strong troubleshooting and organizational skill
• Knowledge in Third party tools like TOAD, LiteSpeed, AutoSys, SharePoint, ERWIN, Crystal Reports, Visio 2007, Red-Gate, and Spotlight.

Education

• Bachelors in Technology.

Technical Expertise

• SQL Server 7.0/2000 Tools: Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, ISQLW, SQL, T-SQL, DDL, DML, Stored Procedures, UDF, Triggers, OSQL, DTS, SSIS, SSRS Log Shipping, MOM Server Network Utility, Index Tuning Wizard.,
• SQL Server 2005/2008 Tools: SQL Server Management Studio, BIDS, SQLCMD, Database Mirroring, Database Snapshots, XML, CLR Integration.
• Operating Systems: Windows 2000 Server, Windows 2000 Advanced Server, Windows Server 2003 and Exchange 2003.
• MS-Access , C, C++, HTML Scripts,Asp.Net,DB2, Sybase ASE 12.x Teradata, Crystal Report
• Modeling Tools: Microsoft Visio 2003/2007, ERWIN 4.x, Er Studio.
• SQL Server Diagnostic Tools: Idera Diagnostic Manager Version 4.0.
• Other Tools: Litespeed 4.8.3.0025, UC4 automation engine, Crystal Reports 10.

Application Area

Other Skills

• Replication
• Database Backups and Restore
• Log Shipping
• DTS/SSIS/SSRS/SSAS
• Performance Tuning and Database Maintenance
• Data Mirroring
• Capacity Planning
• Good analytical ability
• Always ready to adapt new technologies
• Good team player

CERTIFICATIONS

• Microsoft Certified Professional (MCP)
• Microsoft Certified in Administering and Managing SQL Server 2005 (MCTS 70-433)

Professional Experience:

Confidential,Topeka, KS Feb’12 –Till Date
Senior Software Project Analyst

Confidential,is a health plan or managed care organization for mental health benefits only. Serves people who have Medicaid (Kansas Medical Assistance) or Medikan.

Responsibilities:

• Support for implementation of 5010 Encounters from 4010. Includes interface development, process flow development (requisitions, Purchase Orders, notifications, development of triggers).
• Managed a team responsible for the support and maintenance of the Electronic Claims Processing System (ECURA), including daily, monthly and year-end claims processing.
• Consults with vendors and advises management database management issues and participates in various large-scale or highly complex data/database management activities.
• Maintained database response times in 24X7 Production environments, Perform day to day Database Maintenance tasks -- Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Manage user and data security to allow access to appropriate resources. Proven experience in maintenance of SQL Server in a VLDB environment and resolving database issues with tables.
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks & diagnose issues on the server.
• Configured and administered Database Mirroring on SQL Server 2008.
• Migrated and upgraded databases from SQL Server 2005 one server to Sql Server 2008 on other server
• Testing of new releases and features for application, O/S and Database upgrade & Troubleshoot application performance & Optimize query& index performance.
• Ran SQL Server 2005 Upgrade Advisor to help determine if and where DTS issues with custom ActiveX code would not migrate as easily.
• Supported various applications in .Net, assisted clients in reporting needs with report repository and Crystal Reports 10.

Environment: SQL Server 2005/2008 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSIS, ETL, databases in SQL Server, Microsoft, Windows 2003 Server, SSRS, Erwin, Crystal Reports 10, Report Repository, ECURA, MS Visio, T-SQL.

Confidential,Chicago, IL Jun’10 – Jan’12
SQL Server DBA

Confidential,multi-asset brokerage services on a range of listed and OTC derivatives and securities. Formed from a joint venture between Société Générale and Crédit Agricole CIB, we benefit from the support of our top-rated shareholders, and are independently managed and regulated.

Responsibilities:

• Installed SQL server 2008 on windows 2003 advanced servers, applied security fixes. Involved in Migrating SQL Server 2005 Servers to SQL server 2008
• Installed and Configured MS SQL Server 2008, and responsible for configuration, tuning and provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring on SQL Server 2008.
• Developing SQL scripts for maintaining administration tasks.
• Additionally, designed and implemented a disaster recovery system.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Writing Stored Procedures, Functions and triggers based on the requirement.
• Creating jobs/maintenance plans for Database.
• Developed ER Diagrams using Visio 2000. Designed Star and Snowflake data model.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Implemented MS SQL Server security policies and granted object level permissions.
• Created jobs for rebuilding of indexes and updating statistics.
• Developed Cubes using SQL Server Analysis Services (SSAS).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Worked with Postgre admin tool modules, such as connection pooling, full text searching, and replication.
• As an Admin Created & Managed PostgreSQL table spaces and databases, PostgreSQL Schemas & Postgre logging.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured Transactional replication between Primary Server and three Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Performance Monitoring of MS SQL Server 2005/2008.

Environment: SQL Server 2005/2008 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003 Server, SSIS, SSRS, Erwin, Postgre database, PostgreSQL 9.0 Hot Standby Oracle 10g, MS Visio, T-SQL, UC4

Confidential,Grand Rapids, MI Oct’09 – May’10
SQL Server DBA / Developer

Confidential,continued to look for innovative opportunities and ways provide higher levels of service to his customers. He renamed his store Meijer’s Grocery and began broadening his business through the use of newspaper ads and fancy metal shopping carts. As World War II raged, Hendrik pledged his company’s support to the war effort, and just like the Arsenal of Democracy, women became a key part of the Meijer workforce, numbering nearly half of all team members.

Responsibilities:

• Monitor and maintain over 6 SQL Servers in Production, QA, Test and Development Environments.
• Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs
• Imported Data from Text files and Excel Spread sheet into SQL Server 2000 database using DTS package.
• Setting up logical/physical backups for the databases.
• Managing Logins, Users, Roles and User permissions
• Create packages, procedures, functions, and triggers; handle database performance and tuning.
• Implemented replication model like Merge, Transactional and Snapshot.
• Backed up system and user databases related to Merge, Transactional and Snapshot Replication
• Creating DTS Packages migration of data across different servers and Other Databases such as Oracle and DB2.
• Transferred data from Oracle to SQL server using SSIS.
• Implemented Database Mirroring.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Involved in migrating the backup jobs from SQLserver to Lite Speed
• Involved in resolving dead lock issues and performance issues.
• Created and scheduled jobs to setup log shipping between production servers as well as standby servers.
• Documentation of daily tasks and scripting them using DBScribe.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Deployed and managed reports through SQL Server Reporting Services (SSRS).
• Assist Developers in writing and tuning new procedures.
• Troubleshooting Replication Errors and handling Logs.
• Creating new procedures using Dynamic SQL and Table Variables.
• Create and Modify procedures, Triggers and functions
• Assisted users in modifying store procedures over performance issues.
• Check consistency of databases.
• Check the fragmentation of tables and indexes and run DBDEFRAG and DBREINDEX at appropriate time.

Environment:: SQL Server2000/2005,SSIS, SSRS,SSAS, T-SQLMOM, IIS ,Oracle, MTS & Windows 2000,2003 MS-Access, MS-Excel,Teradata,VB-.net,VB,DB2,TOAD,LITESPEED, Oracle 9i, Erwin, Crystal Reports, Informatica, Sportlight.

Client: Confidential,Indianapolis, IN Aug’08 – Sep’09
SQL Server DBA

Confidential,is now the 10th largest pharmaceutical company in the world. Lilly\'s global employees number approximately 40,000, and its medicines are marketed in 143 countries. Lilly has major research and development facilities in eight countries and conducts clinical trials in more than 50 countries.

Responsibilities:

• Configuring, Installing, Managing, Monitoring and Troubleshooting SQL Server 2005 and 2008 Database Servers.
• Designed and implemented Backup plan and Disaster recovery strategies.
• Involved in Query Optimization and tuning the query, creating Indexes to improve query performance.
• Involved in Backup and Recovery of databases for applications.
• Designed, developing and deploying various ETL packages (SSIS).
• Created various multi-dimensional cubes (SSAS), processed facts, dimensions and populated data for front end users.
• Created and Executed DTS and BCP utilities in SQL Server 2000.
• Bulk Insert and Loading the data files which comes from various legacy systems.
• Extensively worked on migrating servers from SQL 2000 to SQL 2005 and SQL 2008.
• Created various Jobs scheduling and running jobs and troubleshooting failed jobs by creating email alerts.
• Developed conceptual, logical and physical design of data models along with the architect and normalized them.
• Modified SSIS ETL package for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
• Effectively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.
• T-SQL programming for writing stored procedures, user-defined functions, Triggers, Cursors, Views, Joins, set up and management of linked servers to Non-SQL server Databases.
• Set up test and production for new applications and deployed SQL server applications to production, backup and recovered them.
• Worked on SQL Server Clustering, Log Shipping, Mirroring and Replication and monitoring them.
• Deployed and managed reports through SQL Server Reporting Services (SSRS).
• Created and maintained data loading procedures and altered indexes maintaining user access.
• Coordinated with the Development team and testing team and provided support by resolving system problems.
• Provided 24/7 support to databases on weekly rotation.

Environment: Windows 2003, MS-SQL Server 2008/2005/2000, MS Access 2003, Sybase, SSIS,SSRS, System Monitor, DTS, OLAP, C#, Erwin 7.3, Data Modeling, Log Shipping, Replication, SQL Profiler, performance Tuning, .Net 2.0, SQL Loader, Query Analyzer.

Client: Confidential,Radnor, PA Jun’07 –Jul’08
SQL Server DBA

Confidential,sells a wide variety of financial products and solutions through Financial Advisors (LFA): Mutual Funds, Managed Accounts, Retirement Solutions, Life Insurance, 401(k) and 403(b) Plans, 529 College Saving Plans, Institutional Investments and Financial Planning and Advisory Services. The Account Aggregation Reporting Framework provides LFA planners and Advisors the ability to search for their clients based on a various parameters such as: First Name, Last Name and SSN and view select from a list of reports that are required to be generated or printed. The development required close interaction with the business users technical infrastructure team of LFA.

Responsibilities:

• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2000.
• Good experiencein working with Tax Systems
• Created and modified procedures, triggers and functions.
• Provided day-to-day administration tasks like space and log management.
• Worked on fine tuning of the database, troubleshooting, user administration, Memory Management and running DBCC.
• Performed data loading with DTS, BCP and Bulk Insert tools.
• Configured Log shipping for High Availability.
• Supported Replication setup for SQL Server 2000 and local Access database used merge Replication.
• Performed daily backups and developed recovery procedures.
• Created DTS Package for export and import data from SQL Server to Access, text files and Excel files.
• Resolved many SQL Server performance issues like slow performance, Dead Lock and Index defragmentation.
• Created DTS packages for migration of data from SQL Server to MS Access and Oracle databases.
• Developed and created many office applications on .Net framework.
• Worked with Application Developers to design databases and tables to support development activities and to achieve optimal efficiency.

Environment: Microsoft SQL Server 2000 Enterprise Edition, T-SQL, DTS, Windows Server 2000, IIS, ERWIN.
Confidential,India Jun’05 – Apr’07 SQL Database Administrator
Responsibilities:

• Involved in Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the legacy database.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Created complex scripts to do massaging of legacy data in staging area of DTS package.
• Scheduled Jobs to run DTS package in night feed to DSS system for fresh day data.
• Wrote standard & complex SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Created Documentation for the packages and scripts and job created to migrated data from legacy system to SQL Server 2000.
• Involved in creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Resolved Deadlock & Blocking Lock Issues by setting Trace Flags like T1204 and T1205
• Created Linked Servers between SQL Servers and other Heterogeneous environment

Environment: Microsoft SQL Server 2000 Enterprise Edition, Oracle 8i, T-SQL, DTS, Windows Server 2000, IIS, ERWIN
Confidential,India Mar‘04 – May‘05
SQL DBA/Developer

Responsibilities:

• Study the Client requirement for present and future database structure.
• Conversion/migration of the existing legacy database management system (DBMS) to development/ production MS SQL Server 2000 platform.
• Up gradation/Migration of MS SQL Server 7.0 to MS SQL Server 2000 in the development stage and production stage.
• Administration of multiple database systems based on MS SQL Server 2000.
• Designing various objects like Stored Procedures, triggers, views and implementing
• Data Integrity as per requirement fulfilling performance issues.
• Identified the necessary steps to enhance user response time by improving queries and their index selections to minimize IO and eliminate table scans and identified more efficient application access methods.
• Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore and Indexes.
• Design and implementing of security model and accordingly implemented permissions. Scheduling activities for Maintaining Database/Objects SQL Scripts of complete work done at different sites.
• Administering Backup and recovery.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Assigning the users to particular groups.
  Installation of SQL Server 2000. Creation of Databases and loading the same from database dumps. Performance and fine-tuning of databases and data server.

Environment: Windows 2000 server/ clients, SQL Server 2000, Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event, Viewer, SQL Profiler, Index Tuning Wizard, Database Maintenance Plan Wizard and Data Transformation Services, T-SQL.