SUMMARY

• Over seven years of IT experience in Database Development and Support of MS SQL Server 2008, MS SQL Server 2005, MS SQL Server 2000 and MS SQL Server 7.0 in Production, Test, Development and Replication & Cluster Server Environments.
• Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
• Experience with high availability systems, 100+ GB databases, hundreds of databases in a highly transactional environment with proper data Archive and Purge processes
• Proficient in Designing and Documentation of SQL Server Strategies and plans.
• Experience in creating and maintaining Optimization, Backup, Restore, Recovery and Alert procedures.
• Strong working knowledge with 32 bit/64 bit Windows 2000/2003 servers, Itanium servers.
• Hands on experience with scripting in T - SQL in constructing Triggers, Tables, User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity, Optimized Indexes and Statistics in relation to reporting data model.
• Proficient in MS SQL Server 2005/2008 suite of products (SSAS, SSIS and SSRS).
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Experience in writing Stored Procedure/TSQL coding, Performance Tuning, Physical and logical Database Design, and Triggers in My-SQL.
• Working exposure with the ETL Architectural skills like job performance tuning and restart ability.
• Strong experience in defining Referenced relationships in SSAS.
• Hands on experience in Dimensional/Star Schema modeling.
• Good experience in Dimensional modeling using Star Schema/Snowflake modeling concepts and Kimball/Inman strategies. Experience with Physical & logical data modeling using All-Fusion Erwin Data Modeler4.1.2
• Implemented SSIS Load Processing.
• Hands on experience in creating ETL packages using DTS and SQL Server 2005/SQL Server 2008 Integration Services (SSIS).
• Used tools such as Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Experience in Developing and delivering dynamic reporting solutions using SQL Server 2005/SQL Server 2008 Reporting Services (SSRS)
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2005/SSRS 2008.
• Setup, Reconfigured, and Monitored Log Shipping for production databases and also carried out role changes, role reversals, and positioning the monitor server.
• Experience with Database Maintenance Plan and Maintenance Wizards for scheduling weekly and monthly maintenance jobs like rebuilding and reorganizing indexes and shrinking the databases for better performance and resolving space issues.
• Experience in resolving database performance issues, database capacity issues and distributed data issues.
• Experience in evaluating, installing and supporting 3rd party vendor software utilizing MS SQL Server.
• Used Oracle Spatial for managing geographic and location-data in a native type within an Oracle database.
• Clear concepts and experience in using Oracle Spatial functions, objects and indexing.
• Experienced in Security Issues such as creation and granting permissions on various Database Objects.
• Worked with providing the 24x7 on call dedicated support with 30-minute response time to all the Production, Development, Test and Clustered Servers in MS-SQL and MY-SQL Environments.
• Competitive in trouble-shooting (handling database corruption, transaction log problems, Query performance problems).
• Enabled NFS Connectivity for Inbound Receive folders and configured as cluster resource under Cluster Administrator MMC.
• Worked with Microsoft ISA Server to enable network connections through a strong firewall.
• Experience in developing XML files and analyzing the XML file by parsing it, and converting into desired format
• Strong in decision making, working through challenges.
• Excellent Interpersonal skills, an innate ability to provide motivation and open to new and innovative ideas for best possible solution.
• Ability to handle multiple tasks, initiative and adaptable. Proactive team player with capability of handling responsibilities independently as well.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Transact SQL, UNIX Shell scripting, C#, Java Script, HTML, CSS, XML, XPath, XSLT, C++, C.

Databases: MS SQL Server 2008/2005/2000/7.0, DB2 UDB, Oracle 11g/10g/9i/8iMS Access 2000/7.0, Sybase, and Teradata V2RX.

Database tools: SQL Server Management Studio, Enterprise Manager, Query AnalyzerSQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, DTS/SSIS/SSRS/SSAS/InformaticaCognos 8, Crystal Reports, Cognos EP Series 7

Testing tools: Win Runner, Load Runner, Test Director, Quick Test Pro

Reporting tools: Crystal Reports, SQL Server Reporting Services (SSRS).

Presentation tools: MS-Visio, MS Office Suite 2003/2007.

Operating Systems: Microsoft Windows XP/2003/2000/9i/NT, IBM AIX UNIX 4.2, Red Hat Linux 8, IBM OS/390 version 2.8, Novell Netware 4.1, Sun Solaris 8 and DOS

Version Control tools: MS Visual Source Safe, Team Foundation Server.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

SQL Server Production Support DBA/Developer

Responsibilities:

• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Team member in a 3 member DBA team, which provided 24x7 Support to 70 production servers. Instances of 3TB plus with 500 concurrent users.
• Performed all aspects of database administration, including data modeling, backups/restoration andrecovery.
• Performed Migration of the SQL servers from 2000 to SQL server 2005/2008 versions.
• Configured Transactional replication between Primary Server and Read - Only server, with separate Distributor server and experience in troubleshooting replication problems.
• Performed high level administration responsibilities using the A2R and X5C applications.
• Setting up and Automatic/Forced fail over for the production servers using Log Shipping, Mirroring, Replication and Clustering.
• Additionally, designed and implemented a disaster recovery system.
• Configured the Log shipping and created the Standby server.
• Configured Database Mirroring for multiple databases for providing high availability solution of the Production databases.
• Involved in supporting two node Clustering servers and databases and involved in QA refresh, user data preparation, data scrubbing activities.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Created Query prompts, Calculations, Conditions, Filters, Multilingual Reports Using Report Studio.
• Created Query Prompts, Developing Prompt pages and Conditional Variables.
• Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services 2005/2008 (SSIS).
• Built various packages in SSIS to load the data coming from various interfaces like OMS, Orders, Adjustments and Objectives.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using (SSRS).
• Used MDX to create named sets, named members and other calculations.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Extensively used SSIS to move data from heterogeneous data sources to SQL Server.
• Extensively used the ETL Design skills for aggregations, lookups, transformations and expressions.
• Writing stored procedures in MY-SQL.
• Created and developed Stored Procedures and Functions in PL/SQL for the front end.
• Creating Tables, Synonyms, Views. Wrote database triggers. Created Cursors using PL/SQL.
• Performed data transfers between various servers using BCP, DTS and SSIS.
• Developed the Unit test plans along with the specifications to ensure compliance.
• When we had 3000 user connections solved latching issues by creating Read - Only Server using replication.
• Automated the maintenance tasks for reorganizing and rebuilt the indexes on tables on a recurring basis for performance enhancements using Database maintenance Plan/Wizard.
• Automated the shrinking of the logs and the databases after a 95% critical space threshold has been reached.
• Data recovery was performed for corrupted data on a periodic basis. Also the fragmentation was performed to eliminate data redundancy.
• Implemented transaction log backups to clear the logs and resolve space issues.
• Involved in SQL security and planning; administrating and creating user accounts for proper access, SQL/Server system databases and tables, SQL Profiler and Enterprise Manager/Management Studio, and Server monitoring to ensure adequate CPU, disk space, and memory on all SQL servers.
• Built scripts for ARGSDE and ARGGIS Services for Oracle Spatial for managing geographic and location-data in a native type.
• Constantly held meetings periodically with HP for a live demonstration on the Polyserve concept.
• Involved in performance tuning and query optimization using indexing (Clustered, Non Clustered indexes) Tables.
• Developed communication modules between databases using Service Broker, which ensures secure and asynchronous exchange of data.
• Improved security and integrity of data using data dictionary packages.
• Worked with SQL server Profiler to generate traces.
• Used ETL Design skills for aggregations, lookups, transformations and expressions.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitor connections, locks and performance of SQL server.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
• Prepared Estimates for Database, table size growth.
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
• Analysis and Reporting was done using Cognos Suite 8.0.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Taking care of each process such as Standard build installations of SQL Server, Change Control Management, Escalation, proper intimation to the end users.
• Responsible for documentation including Technical Specification and Technical Architecture.
• Also involved various functional activities related to the Project Implementation.

Environment: Microsoft SQL Server 2000/2005/2008, Microsoft .NET Framework 2.0, Cognos Suite 8.0, Windows Server2000/2003, DTS/SSIS/BCP, Failover clustering, SQL Diagrams, Erwin, MY-SQL, Service Broker, MS Access, Microsoft Analysis/Integration/Reporting Services, Diagnostic Manager, Legato Backup Software, T-SQL, Query Analyzer, Outlook, SQL-Profiler

Confidential, Madison, WI

SQL Server DBA/Developer

Responsibilities:

• Involved in daily monitor & maintenance of MS SQL Servers in Production, QA and Development Environments
• Analysis and Understanding business requirements
• Involved in configuration of new SQL Server Instances on Windows servers with appropriate parameters
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2000/2005 and databases
• Provided 24 X 7 supports to all production, development, staging and clustered servers.
• Migration of various SQL Server components, Database, DTS Packages, Logins and Analysis Server etc., of existing server.
• Demonstrated expertise utilizing ETL tools, including SSIS, DTS.
• Designed and developed SSIS Packages, Stored Procedures, Configuration files, tables, views and functions.
• Created and Scheduled jobs, alerts, activity logs, error logs to capture any possible errors.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Involved in development and debugging of complex batch Transact SQL Procedures and functions.
• Communication between databases was done using Service Broker.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion. Procedure and worked with tuning SQL queries generated by SSRS.
• Data recovery was performed for corrupted data on a periodic basis. Also the fragmentation was performed to eliminate data redundancy
• Involved in setting up SQL Server Agent jobs for Periodic Backups with Backup Devices, Database Maintenance Plan and Recovery
• Worked closely with other teams in disk subsystem capacity planning, file system layouts, disk space and other database-related issues
• Involved database performance issues, database capacity issues, replication, and other production related distributed data issues.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2000 with high volume data using DTS.
• Maintaining Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Involved in managing system databases, database files, transaction log files and configuring the file in appropriate disks for achieving high performance database.
• Involved in Database Designing, Logical, Relational Database Diagrams, physical Data Modeling and Normalization process.
• Troubleshoot database and database-related errors; made database changes and/or worked with vendors, technical support staff, and users to resolved issues and problems.
• Migration of MS Access, Excel Objects, flat-files to SQL Server 2000/2005 and maintained existing third-party and in-house developed database applications.
• Setting up and managing automatic/manual fail over for the production servers using Log Shipping, Mirroring, Replication and Clustering.
• Configured product meta-data tables to support client data reporting needs.
• Generated database SQL scripts and deployed databases including installation and configuration
• Created reports in Query Studio and Report Studio.
• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Participated and contributed in discussions about database issues, performed applications tuning by analyzing trace files and explain plans.
• Supported front-end applications under .Net framework.
• To check the post installation configuration of the servers over the entire network to make sure that all the security settings are in place.
• Designing Documents for the policies and procedures, security standards, general DBA activities and standard followed.
• Participating in the On-Call 24X7 Schedule and maintenance support for all Databases related questions.

Environment: Microsoft SQL-Server 2000/2005/2008, Microsoft .NET Framework 2.0, Report Net 1.1(Framework Manager, Report Studio, Query Studio, Cognos Connection), Windows Server2000/2003, DTS/SSIS/BCP, Failover clustering, SQL Diagrams, Visio, MS Access, Microsoft Analysis/Integration/Reporting Services, Diagnostic Manager, T-SQL, Enterprise Manager/Query Analyzer/Management Studio, SQL-Profiler

Confidential, Atlanta, GA

SQL Server Consultant

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Installation of MS SQL enterprise servers on production, test and development boxes.
• Extensively used SQL executive, SQL profiler, DTS, and SQL mail services.
• Partitioned lot of tables, which have frequent inserts, deletes and updates to reduce the contention and to improve the performance.
• Dropped and recreated the indexes on tables for performance improvements.
• Drop and add users, logins, aliases, and groups to the databases and granting/revoking permissions on Database objects.
• Auditing stored procedures for optimization and improving performance.
• Data Transfers between various servers using BCP
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Maintained Cluster environment.
• Analyzed SECURITY on Cluster Environment.
• Created Database Security by giving proper permissions to users and Admins.
• Performance tuning on the Production, QA and development Servers.
• Created DTS packages for data migration.
• Database and log backups & restoration, backup strategies, scheduling backups.
• Backing up master & system databases and restoring them when necessary.
• Schedule the jobs for the Database Maintenance.

Environment: Microsoft SQL-Server 2000/2005, Microsoft .NET Framework 2.0, Windows Server2000/2003, DTS/SSIS, Failover clustering, SQL Diagrams, Visio, MS Access, Microsoft Analysis/Integration/Reporting Services, Diagnostic Manager, T-SQL, Enterprise Manager/Query Analyzer/Management Studio, SQL-Profiler

Confidential

SQL Server Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Responsible for upgrading and migrating of various applications in Access to SQL Server 7.0.
• SQL Server Administration involving planning and implementing Backup and Recovery Strategies
• Analysis of SQL queries and optimizing performance through modifying table design and application code
• Configuring the standby servers and setting guidelines to automate recovery scenarios
• Implementation of data transfer through DTS
• Setting up and configuring transaction and merge replication of databases
• Monitoring and fine tuning of SQL Server performance and ensuring integrity
• Releasing scripts on the production servers.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: MS SQL Server 2000, MS SQL Server 7.0, Windows 2000, Windows 2003, MS Access, TSQL

Confidential

Developer

Responsibilities:

• Implemented, managed and maintained data models, database designs, data access, and table maintenance
• Involved as operational DBA and development DBA
• Implemented and optimized new and existing stored procedures, functions and views
• Resolved database performance issues, database capacity issues, replication, and other production related distributed data issues
• Involved in T-SQL query optimization using SQL query execution plan and Index tuning wizard
• Involved as dev DBA and verified and ran T-SQL scripts written by programmers in Dev, QA and PROD
• Involved in Maintenance and Monitoring of all Instances of SQL 2000
• Converted MS Access, Excel databases to MS SQL Server database
• Maintained existing third-party and in-house developed database applications.
• Involved in supporting Log shipping and replication configured databases
• Established and maintained disaster recovery, backups, restore, attach, and detach migrations across servers
• Evaluated and recommended new procedures, software, and hardware
• Reviewed, developed, and designed data models using standard diagramming techniques, in conjunction with application development teams; creates logical data models and translates into physical database structures that integrate with existing or proposed database structures.
• Monitored relational databases to optimize database performance, resource use, and physical implementations of databases
• Addressed database integration issues including data migration, maintenance, capacity planning, and new application support.
• Involved QA refresh activities for multiple testing life cycles

Environment: MS SQL server 2000, MS SQL Server 7.0, Windows 2003, MS Access, MS Exchange