SUMMARY

• Over 17 years compound experience in IT, 15+ years solid SQL Server Database Architect/DBA with a proventrack record of team leadership and technical skills with 8 and half years’ experience in USA, who has the ability to work on multiple highly visible projects, is a creative problem solver Exceptional background in analysis, design, development, customization, and implementation and testing of software applications products
• Expertise in MS - SQL Server Development and Administration including Design and implementation Of Distributed/ Replicated Databases, implementing backup/ recovery strategies, and Performance tuning. Expert in data migration from SQL Server of different versions includes Replication and clustered SQL Servers.
• Designing, testing and implementation of high availability solutions like Clustering, Database Mirroring, Log Shipping, and Replication of databases for large, medium and small customers to furtherincrease scalability and stability of business critical systems.
• Experience in data migration from existing databases to remote data centers. Intensive experience in monitoring/tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Managed databases on multiple disks using Disk Mirroring and RAID.
• Experience in implementing Fast Track Data Warehouse in SQL Server 2008 R2/2012.
• Expertise in developing drill-through, drilldown reportsusing SQL Server 2005 Reporting Services (SSRS), Experience in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA).
• Expert in using different Transformation tools like SSIS, DTS packages, BCP, DTEXEC and BULKINSERT.Involved in design and development of DTS and SSIS packages to load and process the data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa.
• Experience in implementing different types of Replication Models.Has good knowledge in implementing Log Shipping Technique as a part of disaster recovery plan.
• Experience in performance tuning of very complex SQL statements and procedures using show plan. Expert in performing database consistency checks and planning and scheduling, Backup & Recovery.
• Maintained database consistency with DBCC, DMV and DMF’s at regular intervals.
• Worked with Third party tools IDERA, REDGATE, TOAD, Lite Speed, CommVault, Quest Tools and Foglight.
• Good Team Player, Strong Interpersonal, Analytical and Communication Skills combined with self-motivation.
• Self-motivated, creative team player with effective communication and Leadership qualities.

TECHNICAL SKILLS

Databases/RDBMS: MS SQL Server 6.5/7.0/2000/2005/2008 R2/2012, Oracle 9i/10g,Oracle11i, MS Access 95/97/2000/2010.

Operating Systems: Windows Enterprise 2005/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional/NT 4.0 Server

ETL: SQL Server Integration Services, SQL Server DTS, Informatica 8.0

Design Tools: Erwin /ERX, v. 7.1, Confidential Visio 2007

Programming: VB.Net, VBScript, ASP, Perl, C#, HTML/XML,MDX

Quest Tools: Quest Lite Speed, Quest Toad for SQL Server,FogLight, Performance Tool

Reporting Tools: SSRS 2005/2008/2012 , Cognos Tools, Crystal Reports 9.0, Confidential Excel 2007BI Tools Cognos Tools, MS SQL Server Analysis Server

Web Technologies: Confidential .NET Framework, IIS 5.0, HTML, DHTML, ASP, XML, VB script.

PROFESSIONAL EXPERIENCE

Confidential

Sr SQL Server DBA/Architect

Responsibilities:

• Designed SSIS packages to migrate the data from DB2 to the ETL tier.
• Participated in designing Logical data models for the Data Warehouse.
• Participated in implementing the logical design to the physical design by creating tables.
• Transferred flat files from different sources to the ETL tier by using BCP.
• Created/reallocated database objects on appropriate file group to ease maintenance and improve data access performance.
• Enforced the Business Rules by creating constraints.
• Optimized the performance of various SQL scripts.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.

  Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost

Confidential

Sr. SQL Server DBA

Responsibilities:

• Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.
• Responsible for planning, implementing and documenting Audit controls for SOX, SAS70.
• Routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports of Compliance Check.
• Perform Manual reviews of servers for manual checks and raise necessary ‘Assertion’ and take follow-up of the same.
• Maintain Server Patching on all SQL Servers.
• For failed checks, send ‘Remediation Request Form’ containing remediation procedures to SME for approval
• Server BuildAnd Hardware Supportin Data Center.
• Increased success factor as a result of performance gains through choosing the right scale model, configuring the system correctly, and taking advantage of the tuning guidance.
• Reduced future support costs by limiting solution re-architect efforts because of scalability challenges.

Catamaran - Rockville, Maryland

Team Lead/Sr.SQL Server DBA

Responsibilities:

• Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.
• Developed database applications Programming Using T-SQL in MS SQL (stored procedures, triggers, data integrity constraints, etc.), Design and develop logical and physical database models for new/re-factoredapplications and processes.
• Housekeeping Sybase, dump directories.
• Data migration using BCP utility.
• Reviews and analyzes current technology infrastructure and its ability to support strategic objectives ofthe customer.
• Design and Implement complex Confidential SQL Data Warehouse environments monitoring and optimizing database performance.
• Design and Implement SQL Server 2008/2012 Fast Track Data Warehouse environment
• Automated the process of monitoring entire inventory of SQL Servers to ensure good backups of all servers using Powershell Scripting. Also, provide 24x7 on-call support for Production Databases.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Accelerated data warehouse projects with pre-tested hardware configurations Fast Track Data Warehouse environment.
• Evaluated the specific configurations for the storage array, including how the storage is carved up for user and system databases in SQL Server 2008/2012 Fast Track Data Warehouse environment.
• Increased success factor as a result of performance gains through choosing the right scale model, configuring the system correctly, and taking advantage of the tuning guidance.
• Reduced future support costs by limiting solution re-architect efforts because of scalability challenges.
• Install, configure and support SharePoint 2007/2010 Farms. Perform Farm and Site Collection administration, and coordinate various groups in IS, to implement changes, updates, and Site Collection creation. Manage the association between SharePoint and SQL Server.
• Participated in planning, testing and performing major migrate/upgrade of SQL Server, new service packs/hot fixes. Maintained database consistency with DBCC, DMV and DMF’s at regular intervals.
• Worked on troubleshooting related to tuning of database objects, resolving data integrity and performance issues using SQL Profiler, Query Analyzer, and trace flags.
• Routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Managed 35+ SQL Servers, from 20 GB servers to a 35 TB data warehouse.
• Migration from SQL server 2000 to SQL 2005 and from SQL 2005 to SQL 2008.
• Managing and creating fail over through mirroring, Replication, and Clustering in disaster recovery.
• Reviewing SharePoint Databases and performing database optimization.
• Responsible for planning, implementing and documenting Audit controls for SOX, SAS70
• Quest Capacity Planning, Fog light deployment, administration and monitoring. Clearing the alerts once the issue has been resolved

Confidential - Sacramento,CA

Sr.SQL Server DBA

Responsibilities:

• Installed SQL server 2008 R2 on windows 2008 R2 advanced servers, applied service packs and security fixes. Setup Cluster environment in SQL Server 2005/2008.
• Automated the process of monitoring using PowerShell Scripts.
• Configured transactional replication between primary Server and Read-Only servers with separate distributed servers. Created backup strategies and scheduled them for execution.
• As a part of Capacity planning made performance baseline for 2008 R2 servers using perfmon Worked with the Application team to ensure upgrade doesn't affect any application.
• Migrated SQL server 2000/2005 to SQL Server 2008 R2
• Worked on writing complex queries using T-SQL, stored procedures, triggers and views
• Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2008 R2.
• Developed SSIS packages to extract, transform and load into the database from OLTP database into datawarehouse
• Configured the database maintenance plans for database optimization.
• Provided with a wide variety of options in managing the environment, created Policies and checked for compliance. Administering Servers by Using Policy-Based Management
• Participated in planning, testing and performing major migrate/upgrade of SQL Server, new service packs/hot fixes. Maintained database consistency with DBCC, DMV and DMF’s at regular intervals.
• Worked on troubleshooting related to tuning of database objects, resolving data integrity and performance issues using SQL Profiler, Query Analyzer, and trace flags.
• Routine Developer/DBA tasks like handling user’s permissions and space issues on Production andhandling maintenance Jobs including backups and restores.
• Respond to trouble tickets assigned to me and fix any database issues promptly. Update and work Created Jobs and Maintenance Plans and scheduled them for Backup of Databases. Dailyon projects that I have been assigned to as a resource from the Database Management team.
• Worked on DTS packages and SSIS packages for transferring data from various data sources like DB2,Oracle, MS Access, Excel, *.Txt file, *.CSV files.
• Housekeeping Sybase, dump directories.
• Script writing and editing for Sybase related batch jobs
• Setting up database backup and recovery procedures for production, quality and development servers using Database Mirroring and Log Shipping
• Developing triggers, stored procedures and enforcing business rules via checks and constraints
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Confidential - Redmond, WA

Sr. SQL Server Support Lead

Responsibilities:

• The support includes administration and maintenance of the databases which include multi-tasking activities such as checking the server health, job schedules, blockers, alerts, replication, log-shipping, deadlocks, and disk space managements, archival and purging.
• Support and manage a VLDB SQL server farm of 10 plus servers
• Developed SSIS packages to extract, transform and load into the database from OLTP database into data warehouse
• Resolved Issues which are identified by the SCOM Alerts which will be generated messages in our email. Implementing and administering database replication between SQL Server databases as well as dissimilar databases.
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks & diagnose issues on the server
• Participated in planning, testing and performing major migrate/upgrade of SQL Server, new service packs/hot fixes. Maintained database consistency with DBCC, DMV and DMF’s at regular intervals.
• Automated the process of monitoring using powershell scripts
• Worked on troubleshooting related to tuning of database objects, resolving data integrity and performance issues using SQL Profiler, Query Analyzer, and trace flags. routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Respond to trouble tickets assigned to me and fix any database issues promptly. Update and work Created Jobs and Maintenance Plans and scheduled them for Backup of Databases. Daily n projects that I have been assigned to as a resource from the Database Management team
• Writing code and creating jobs to automate repetitive tasks. Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitor log files to proactively resolve issues.
• Implemented redundancy with other server farms through log shipping and replication
• Installed, configured and managed MS SQL 2005 and 2008 fail over Clustering for production servers on 64 bit platforms to provide high availability.
• Regular SQL Server Maintenance Activities
• Index rebuild and update statistics, Database Backup, Data Imports and Exports

Confidential - San Francisco, CA

SQL Server Database Architect/DBA

Responsibilities:

• Support production business applications by assisting in ad-hoc database analysis and troubleshooting.
• Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.
• Working at an escalation level (Secondary Response Group, SRG) and working with issues which are very time consuming and complex.
• Developed database applications Programming Using T-SQL in MS SQL (stored procedures, triggers, data integrity constraints, etc.)Design and develop logical and physical database models for new/re-factoredapplications and processes.
• Handling backup process, writing the automated jobs for taking the weekly full backup, daily differential backups and hourly transactional backups.
• Installed and Configured SQL Server 2008 and 2008 R2 Servers.
• Design, plan and implementation of VMware infrastructure and specific network for virtualization.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Work with DBA in performance testing and tuning custom applications.Participate in the design and development of data marts to support analytical reporting requirements.
• Implemented redundancy with other server farms through log shipping and replication
• Create and maintain technical and operations documentation and assist in the creation of work estimates and project plans.
• Work closely with DBA and IS management to develop and implement policies and procedures for software development and maintenance.
• Evaluate and implement new tools and technologies for database development
• Meet service level agreements for all client escalated issues.
• Provide reports that measure the quality and quantity of work performed.
• Worked with data management and data processing flowcharting techniques
• Provide input to manager that will help streamline and improve consistency in service levels.

Confidential - Olympia, WA

SQL Server Database Architect/DBA

Responsibilities:

• Installed & configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs. Experience in managing security at database and server level.
• Status report of all the jobs, Database consistency checks
• Experience in creating Roles and managing user permissions.
• Working knowledge of patching the servers with Latest security patches and service packs of SQL Server

Confidential - Redmond, WA

Sr. SQL Server Database Architect/DBA

Responsibilities:

• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Implemented redundancy with other server farms through log shipping and replication
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Worked with Star Schema, Cubes and Analytical services.
• Provided 7 x 24 Production support for the database and application issues.
• SSIS Jobs, Reporting Jobs through SQLCMD, Archiving, Gather Database counters
• Status report of all the jobs, Database consistency checks, Data Refresh, Data Masking.
• On call support.
• Created and maintained the knowledge base system for all the application databases
• Provided guidance to the development team on writing stored procedures and implemented the standards, guidelines and best practices for database development

Confidential - Washington

Team Lead & Sr.SQL Server Database Architect/DBA

Responsibilities:

• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity
• Supported all production operation activities, with focus on integration and development of new and existing products and services this includes managing indexes, performance monitoring, backup recovery procedures and designing, testing and publishing a disaster recovery plan.
• Usage of derived tables, table variables, complex queries and joins, sub queries, transactions, user defined functions, views, exporting using SSIS, automating jobs to import data from and to flat files.
• Up gradation of Database from SQL Server and 2008.
• Installed & configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Provided optimal database file layout for utilization of storage and performance acceptable to client.
• Participated in meetings impacting databases physical design.
• Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will won the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).
• Implemented redundancy with other server farms through log shipping and replication

Confidential, Washington

Sr. Database Architect/DB

Responsibilities:

• Responsible for database security and performance, coordinates physical changes to SQL Server databases
• Supported all production operation activities, with focus on integration and development of new and existing products and services
• Familiar common database monitoring and analysis tools(SCOM,MOM,Safemon)
• Provides database system administration, including: backup, disaster recovery, tuning, security planning, etc. Monitors database performance and modifies database programs to increase processing performance, referred to as performance tuning .Responsible for activities involved in the analysis, design, development, troubleshooting, debugging and maintenance of enterprise transactional systems.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Perform quality assurance and testing of SQL server environment.

Confidential

Team Lead - Database Architect/DBA

Responsibilities:

• Created logical and physical database design modeled to support the displaying of realty based information through use of online tools such as customized search engines for retailers, property pages, and virtual agent support.
• Monitoring all the 40 production databases and fixing the production issues.
• Managed 40+ SQL Servers, from 20 gb servers to a 2 terabyte
• Tuning the database servers, when the user reports that a particular region is running slow.
• Creating and refreshing Databases on development environment, making it sync with production when new development activity starts.
• Creating new schemas and modifying the existing schemas based on the changes for the new development activity.
• Performance tuning on stored procedures, queries to support the application to run faster.
• Created and monitored the jobs to perform tasks such as database cleaning, backups, data loading.
• Performed Migration of Databases from one physical server to another when the size of the database increased and business needs changed.
• Responsible of capacity management with a strong ability to anticipate future demands and growth by working closely with key stakeholders.
• Strong documentation skills in documenting processes, procedures and tools descriptions.
• Responsible for maintaining strong partnerships and working relationships with dependent internal IT groups geographically and vendors
• Participate in and contribute to Release activities including Spec reviews

Confidential

SQL Server Database Architect/DBA

Responsibilities:

• Involved in performance tuning, code optimization, development using VB 6.0, ASP and COM+
• Conducted System Analysis, Design, Development and Implementation of various Applications and the subsequent transition to ERP and Web Enabled Application.
• Experience of Application Code Review.
• Performed all the Database related activities such as Database Backup, Restore Operations Troubleshooting Issues as and when occurs, Performance Tuning, monitor error logs, jobs .etc.
• Designed, implemented & maintained DTS Packages
• Handled data Migration from legacy systems as well other RDBMS such as Sybase and FoxPro.
• Involved in Fine Tuning the Procedures After studying the Processing time through SQL Trace.
• Modified & created Indexes, Optimizing Indexes.
• Migrated data from various sources such as MS Access, flat files etc.

Confidential

Senior Database Administrator

Responsibilities:

• Developed & executed scripted changes requests in accordance with change control procedures.
• Provided overall configuration and change control management for data base components.
• Escalated database issues to appropriate approvers (if applicable).
• Set up security and access profiles and procedures for database system administrators.
• Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate Client Security Policy based on mutual agreement..
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008.
• Provided & managed support to Environment of more than 500 Database Servers.
• Proven ability to handle Database of more than 1 TB in Size.
• Expertise in MSSQL SERVER Database Administration. Set up Log Shipping, MSSQL Mail, SMTP
• Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc. and ensured the Availability of the Database Server in a 24X7 Environment.
• Scanned the data pages, Indexes and checked the storage space used by each table.
• Suggested, developed & implemented Scaling out solution with Data partitioning.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.

Confidential

Database Architect/DBA & Team Lead

Responsibilities:

• Up gradation of Database from SQL Server and 2008.
• Installed & configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Provided optimal database file layout for utilization of storage and performance acceptable to client.Participated in meetings impacting databases physical design.
• Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Requested refreshes pre or post restore activities (e.g. data loads).
• Database recoveries as per requirements.
• Conducted root cause and analysis for database incidents and problems.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).

Confidential

Responsibilities:

• Meeting the customer to analyze the requirements.
• Provide inputs to the documentation team
• Designing the database Designing the user interface for Master and transaction entry screens
• Developing Master and transaction entry screens with business logic
• Developed database applications Programming Using T-SQl in MS SQL (stored procedures, triggers, data integrity constraints, etc.) and ActiveX controls (ocx files)
• Implement the product in the client’s site and the users to use the product.

Environment: Visual Basic 5.0 / MS SQL Server / RDO / Crystal Reports/Oracle

Confidential

Software Analyst

Responsibilities:

• Designing the database
• Designing the user interface for Master and transaction entry screens
• Developing Master and transaction entry screens with business logic
• Implement the product the users to use the product.

Environment: Oracle 7.0 and Forms 2.5