Summary:

• Extensive Experience in Installation, Configuration and Maintenance of SQL Server Databases.
• Seven plus years of IT experience in Database Administration, SSIS ,SSRS Design, Development, Security and Support of MS SQL Server 2008, 2005, 2000 in Production, Test, Development, Replication & Cluster Server Environments.
• Migrated SQL Server 2005 databases into SQL Server 2008 and SQL Server 2008 R2.
• Have Experience working with Data Compression techniques like Row Level and Page Level Compression and Database backup Compression in SQL 2005 and 2008.
• Rich Experience in automating database monitoring and administration tasks using scripts, implementing changes and capacity planning.
• Good Knowledge of all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation and testing.
• Good knowledge of Relational Database Management Systems (RDBMS).
• Experience in N-tier, DNA and Client Server Architecture.
• Extensive Knowledge of RAID, SAN (EMC) technologies.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.
• Worked on 32 bit and 64 bit SQL Server and MSCS Configurations.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Specific handson experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full–text indexing, and Database Application Development using varied development tools. Extensive use of SSIS in SQL Server, Performance Tuning & Application Design, Hot and Cold Backups, Disaster Recovery Planning, Security Management, Managing server and clients
• Expert in extracting and transforming data between homogenous and heterogeneous systems using SSIS packages, IMPORT/EXPORT, BULK Insert, BCP and XML Technologies.
• Extensive working experience with T-SQL, Stored Procedures, Functions, Cursors, Table variable, temp tables, CTE and Triggers.
• Creating XML Indexes, modifying XML data, Retrieving XML data using SQL Server.
• Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities.
• Experience in Database Backup and Recovery strategies.
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Experience of installing, configuring, deploying, Integrating SQL Server Reporting services, Analysis Services on SQL Server 2008.
• Experience and Implemented New Features of SQL Server 2008 like Policy management, Resource governor, Data collection, backup compression.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Experience of Datasets, Data View, Data Reader and SQL Data Adapter.
• Experienceof XSLTfor All data transfers (requests/ retrievals) comply with XML Schemas and transformation.
• Experience of XML for changing config files.
• Used Data Partitioning, Database Snapshot, Database mirroring in SQL Server 2005/2008.
• Worked with Offshore teams and Developers and developed Proper Infrastructure Support model
• Experience in providing Production Support for 24x7.

RDBMS/DBMS:

MS SQL Server 2008 R2/2008,2005,2000, 7.0, MS-Access, Oracle10.i/9.i/8.i

Database Technologies/Tools:

SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, T-SQL, PL/SQL, DTS, SSIS, OLTP, ADO, SQL OLEDB, DBCC, , SSRS,SSAS, VERITAS Netback up 6.0, Light Speed, ERWIN 3.5/4.0,ER Studio 7.0, Visio 2002, Visual Source safe, TFS, Red Gate, SQL Sentry, SQL IDERA, RSScripter, Active Batch.

Operating System:

Windows 2008/2003/2000/NT/Vista Datacenter and Advanced Server 32bit/64bit. Windows 2000/2003 Advanced Server, Windows Exchange Server 2003/2008,Windows NT 4.0/3.5, Windows9.x, Windows XP

Programming Languages:

C/C++, Java, HTML, JavaScript, C#, .NET, T-SQL, PL/SQL, Visual Basic .NET, VB.net, VBA, VB Script

Others:

MS Office 2000/2003/2007,OutLook etc.

Professional Experience:

SQL Server Production Support DBA
Responsibilities:

• Administration and Maintenance of SQL Server 2008R2/2008/2005/2000 databases in Production, Staging, QA and development environments.
• In-Place upgrade from SQL server 2008 Enterprise to SQL Server 2008 R2 Enterprise edition.
• Implemented the TDE (Transparent Data Encryption) in all the Production servers to secure the customer credit card or payment details and also in order to follow the PCI standards.
• Resolved the space issue on production server by implementing the TSQL Backup script to purge the corresponding older backups and implemented the SQL server backup compression.
• Resolved the Tempdb space issue on production server by finding the root cause of the issue which caused by version stores and internal objects.
• Implemented the group policy in AD and changed the logon accounts for SQL Server service accounts depending on environments.
• Changed the SPN’s on the Servers in order to effect the changes made to SQL service accounts.
• Configured the transactional replication between SQL 2008/2008 R2 servers.
• 24/7 on-call production support.
• Deployed many SSIS packages and configured as SQL agent job to run daily.
• Granting the permission to the developers in order to deploy and run the SSIS packages on Development /Test servers.
• Implemented High availability feature Database Mirroring on Production DMZ server
• Deployed the SSRS reports into Production server and configured the subscriptions/schedules for the reports.
• Have thorough knowledge of SQL server security features, policies, principals and securables.
• Extensive knowledge on using SQL IDERA tools like Diagnostic Manager Tool, SQL Compliance Manager etc
• Working experience on SQL Sentry Event Manager, SQL Sentry Performance Advisor Tools.
• Synchronized the Production environment with Dev and QA databases using the Red Gate Tool.
• Working Experience with SQL Hyperback for database compression and AES encryption.
• Resolved the Deadlocks and Locking issues.
• Schedule the SQL Agent jobs using the Active Batch Tool.
• Migrated the Reports from QA and Dev server into Production using the RSScripter tool.
• Performed the Side-by-Side Migration of SQL Production server from SQL Server 2005 to SQL Server 2008R2.
• Implemented the database decryption and performed the restore of the decrypted database.

Environment: TSQL, MS SQL SERVER 2008R2/2008/2005, SSIS,SSRS,VISUAL STUDIO 2005,2008,MS WINDOWS SERVER Enterprise Server 2008/2003/2000,IIS 7.0, Microsoft TFS, Visual Source Safe, Idera Tools, Red Gate, SQL Sentry and Active Batch.

SQL Server DBA/ Operational Specialist

Responsibilities:

• Administration and Maintenance of SQL Server 2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Installing, Configuring and Maintaining SQL Server 2008R2/2008/2005 (64 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Provide and Monitor database "health" - availability, reliability, performance and capacity planning using SQL Profiler, Database Tuning Wizards.
• Provide Reliability using Transactional Replication.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Performance Tuned Stored procedures using Index Tuning Wizard, Estimated Execution plan, Profiler and PerfMon.
• Used the DMV’s to find the missing indexes on the tables for most appropriate used and missing indexes.
• DTS, SQL Server Integration Services Package (SSIS) and Transact SQL Scripts.
• Database Design; Creation of tables ( > 150), views, triggers, stored procedures and functions using SQL (Structured Query Language) and T-SQL (Transact-SQL).
• Designed application database model using MS Visio for Enterprise Architecture.
• Setup, Installation and Configuration of SQL Server RDBMS. Evaluating and installing patches/Service Packs.
• Optimization, performance tuning of SQL Server Systems and databases.
• Setup Database Security and maintain accounts and access levels by creating suitable Logins, Roles and assigning object level permissions.
• Monitoring database access users and roles.
• Analysis, development and maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Created Auditing procedure related Data using DDL/DMLTriggers to keep track all the changes to database and data in tables.
• 24x7 Production support on rotation bases and experience of MTM incident ticket management, for resolving CMR.
• Configure Database Mail for sending failure job notification email messages from Jobs and Procedures.
• Used CDC (Change data capture), Table valued parameters and other new features in new applications.
• Adhoc data query and analysis for different SQL Server based Business applications for information and audit purpose as required by Business Users.
• Working with testing team for testing of applications, Reports and other batch job processes as required. Generating test data as well as confirmation of testing operations from backend.
• Documentation of SQL Server system and database operations, technical specifications, functional specifications, best practices, policies and procedures.
• Installed and configured SQL Server Analysis services for OLAP, Data Mart.
• Worked with BI Team for installing, applying service packs, patching the SAP Business Objects X1 enterprise, building Cubes using Analysis Services, created cubes using MDX and stored them with OLAP storage standards,maintaining analysis databases related changes, deploying changes, roll outs.
• Created and maintained SQL Server connectivity with heterogeneous environment like Oracle Mainframe, MySQL, MS access, DB2 using Linked Servers, OLEDB/ODBC drivers, Open query.
• Implemented the Reporting Services in SQL Server 2008 and integrate the Microsoft Share Point portal with Reporting services.
• Design, Development, Configuration and deployment of custom build business reports using MS Reporting Services - SSRS.
• Perform after hours and weekend on-site or on-call support as needed.

Environment: MS SQL Server 2008/ 2005/ 2000, Windows server 2008/ 2003 Datacenter and Enterprise edition 32 bit/64 bit, Transact-SQL, SQL LiteSpeed, MS Visio for Enterprise Architect, ADO.net, VB.net, SSAS,SSIS,SSRS, TFS(Team Foundation server).

SQL Server DBA

Responsibilities:

• Administering and maintaining large SQL Server 2008, 2005 and 2000 databases with more than 100 million records in individual tables.
• Table Partitioning for existing and new application databases.
• Developing Reports using SQL Reporting Services.
• Data Analysis and BI Reports against OLAP/MDX Data cubes using SSRS.
• Created the structures of the model and cube in MS Analysis services
• Disaster Recovery planning and implementation – Database mirroring, Log shipping, Active Passive clustering
• Involved in installations, releases, change control systems.
• Creating SQL agent maintenance jobs for purging data, maintaining indexes, archival operations
• Creating SSIS package based jobs for bulk data loading, updating and exporting.
• Upgraded and Enhanced the SSIS packages from SQL Server 2005 to SQL Server 2008 R2/2008 and included the custom logging to tracking and troubleshooting the packages.
• Supporting production issues during work and after hours as required.
• Monitoring SQL Services using MOM, SQL Sentry.
• Backups and Restore using Lit speed for SQL Server
• Using new features of SQL Server 2008 like Log compression, transparent data encryption TDE, Policies, Performance data collector, Auditing.
• Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Dynamic Management views (DMV)
• Database Design and maintenance for trading data services and collaboration services for users of financial community (traders, bankers, hedge fund managers)
• Creation of tables, views, triggers, stored procedures and functions using SQL (Structured Query Language) and T-SQL (Transact-SQL).
• Using SQL Server Service Broker to create async. message based database update services.
• Maintaining database security and application security framework using security matrix, windows based group memberships and database roles.
• Extensively using XML for input and export operations.
• Using TFS for version control of Database code.
• Implemented Database Replication (Merge and Transactional) for Call Center Database on SQL Server 2005.
• Upgraded DTS to SSIS Packages, deployed SSIS packages from Dev to Prod, Created Deployment utilities ,created Configuration files(XML),Created Completed Complex SSIS packages for Data extraction and transformation using various new features like fuzzy lookup, fuzzy grouping, Sequence container, for loop container ,Merge troubleshooting package related issues and errors.
• Created and Implemented SSIS Packages for importing and exporting data to other data storage like PostgreSQL, FoxPro, and DB2.

Environment: SQL Server 2008, SQL Server 2005, Windows server 2008, Windows server 2003, Transact-SQL, SQL Server Reporting Services, SSIS, SSAS, SQL Sentry, VMWare

SQL Server DBA operation Specialist
Responsibilities:

• Complete administration and Maintenance of MS SQL 2000/2005/2008 servers.
• Capacity planning, design and implementation of database solutions.
• Migration from SQL 2000 and SQL 2005 databases and to SQL Server 2008 64bit Enterprise Ed.
• Experience working on Active/Passive Failover Clustering solution into HP EVA 3000 SAN environment for SQL Server Consolidation.
• Installation, Configuration and Tuning of SQL Server 2005 and applying SQL Server Service Packs and cumulative hotfixes.
• Apply hot fixes, Patches and Service Packs and create script for Unattended Installation.
• Database Tuning and Performance Optimization using SQL Profiler, SHOWPLAN, Index Tuning wizard.
• Development of Stored procedure, Trigger, Index, Jobs, Alerts, SQL Mail Notification using Enterprise Manager and Query Analyzer.
• Used FOR XML clause of SELECT statement of SQL Server for sourcing database results directly into the .NET Web Controls at run time and web based reports.
• Utilization of Excel Pivot table, database queries for Excel based data analysis
• Debugging various access and performance related SQL server issues. Analyzing the profiler data from production for blocking/deadlocking happening on the server , to find out long running, I/O expensive ,CPU expensive and read/write expensive queries
• Installing, configuring, and maintaining BMC Patrol on Database Servers for extensive monitoring, alerting and auditing the application, OS related errors.
• Worked with SA on SAN issues, DNS aliasing.
• Worked withSA on Disk failures, RAID problems.
• Setting up and handling troubleshooting issuesin high availability and disaster recovery solutions like log shipping, clustering, mirroring, replication etc.
• Configured and supported log shipping from Amsterdam to Singapore
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Transferred data (ETL) to Data ware house Environment using SSIS
• Used Connection managers like Flat File, File. OLEDB, ODBC, SMTP, HTTP and many others in SSIS.
• Experienced with the Objects in SSIS like Task, Maintenance plan tasks, Data Flow Tasks and Containers.
• UsedContainers like For Loop, Sequence and For Each Containers in SSIS.
• Designed packages in Package Designer using Dataflow Sources, Transformations and Destinations.
• Implemented and maintained database security, policies and procedures.
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
• Implemented and maintained database backup policies using third party tool Quest LiteSpeed 4.7.
• Extensively documented all the databases, database objects, jobs and the changes made to the database using Visual source safe (VSS) tool.
• Extensively involved in change control documentation, issue tracking documentation.

Environment: MS Windows 2008/2003 MS SQL Server 7 /2000/2005/2008, SQL, T-SQL, SQL Query Analyzer, Profiler,.NET. Litespeed, VSS , SSIS

SQL Server Development Database Administrator

UniFocus, a performance-management firm in the hospitality industry, acquired Telman Software to enhance UniFocus real-time, dynamic information systems. UniFocus integrated Telman\'s financial expertise and Focused Scorecard database into its own systems.

Responsibilities:

• Worked with Sql Server 2000/2005 with 2 TB of Data and SAN infrastructure of 60 Server 2 NODE cluster Active / Active and Active/ passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment
• Migrated DTS packages from Sql Server 2000 to SSIS SQL server 2005.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Performed BCP extracting the zip file and used the xp_cmdshell for the bulk operation.
• Utilized foglight, profiler, Perfmon for monitoring the deadlocks, blockings and windows level performance also.
• Conducted Consistency Checks on the database and analyzed the fragmentation on the indexes.
• Worked with Transactional Replication to achieve Load balancing.
• Created several stored procedures, triggers, views.
• Created ADHOC reports using SSRS in BIDS.
• Reviewed Store Procedures and Queries fine tuned the Slow Running Queries.
• Implemented Maintenance Plan tasks like History Clean Up and Rebuilding the Indexes in SSIS.
• Detected and Resolved locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Creating Logins and Mapping the User to Roles by Assigning Permissions.
• Development and Atomized Administration and Maintenance Plan for SQL Server 2005.
• Troubleshooted SSIS packages which failed to execute in the Scheduled Jobs.
• Developed CLR Functions to replace earlier application modules and integrate assembly using Service Broker Feature Available in SQL Server 2005.
• Using CLR assemblies and CLR Types in SQL Server
• Creating Stored Procedures to convert database tables into XML format and display via web.
• Collected business requirements, designed data maps and data models. Created Internal and External Design Documents and Transaction Definition Documents.
• Used DTS Xchange tool for Migrating DTS packages to SSIS.
• High Level Design of ETL SSIS Package in SQL server 2005 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Used Notification Services Available in SQL Server 2005 to create alerts and email notification.
• Worked on Veritas Netbackup 6.0 for Database backup and recovery solution.
• Involved in change management process like releasing the report into the production Report server by deploying the code using the TFS.
• Configured the Protection levels for the SSIS packages while moving from Staging to Production
• Involved in 24/7 production support.

Environment: TSQL, MS SQL SERVER 2000/2005,SSRS, VISUAL STUDIO 2005, VB.NET,C#, ADO.Net, VB.net, XML,MS WINDOWS SERVER Enterprise Server 2008/2003/2000,IIS 6.0,SSIS