SUMMARY

• 7 Years of experience shipping highly available and scalable applications using Microsoft technologies
• Expert in the database modeling, design, development, maintenance and administration
• Primary database technologies: Microsoft SQL Server
• Experience includes System analysis and design, development, support on systems built on MS SQL Servers 2000/2005 and 2008 R2
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Excellent skills in database Backup, Restoration, Recovery, Replication, Mirroring, Linked Servers, Database Maintenance Planning.
• Excellent SQL Server administration skills including user authorizations, Database creation, Tables, indexes creation.
• Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries and Common Table Expressions.
• Experience migrating data from one server to another server by In-place upgrade process and as well as side-by-side upgrade process.
• Extensively Worked on Transactional Replication, Snapshot Replication, Merge Replication, and Log shipping for SQL Server High Availability
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries
• Implemented the SQL Server concepts like Data partitioning ,Snap shot Isolation, Database Mirroring, Database Snapshot, DDL triggers, try-cache blocks, Online indexing, DMV’s, DMF’s, SQLCMD and dedicated admin connection.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMVs and DMFs.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Proficiency in implementing different types of disaster recovery scenarios like Replication models like Snapshot, transactional, log shipping and Configure Database Mirroring in Cluster Environment.
• Proficient in high level design ofETL, DTSandSSISPackagesfor integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, etc.)
• CreatedLinked ServersbetweenSQL Server 2000 & Oracle 9i and 10g. Also createdDTS packagefordata transfer between the two environments.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Proven ability to work in teams as well as independently.

TECHNICAL SKILLS

Databases: MS SQL Server 7.0/2000/2005/2008/2008 R2, Access. Database tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Crystal Reports 9.0/10. Programming languages: SQL, TSQL, XML, C++, C, VB 6.0. Tools: SQL DB Access, Performance Monitor, Backup Utility Operating Systems : Windows 95/98/Me/XP/NT/2000, Unix, Windows Server 2003 /2008.

EDUCATION BACKGROUND Bachelors in Computer Science and Engineering

PROFESSIONAL EXPERIENCE

11/10 – Till date: Sr. Database Administrator Client: Confidential, San Francisco, CA
Description:
UCSF Medical center has licensed EPIC software developed by EPIC Systems, located in Verona, Wisconsin. The software will be customized to meet the needs of UCSF Medical Center. EPIC software is an end to end solution for Healthcare organizations, enabling them to seamlessly integrate all modules starting from patient registration, all the way to billing.

Environment: SQL Server 2000/2005/2008 with clustering, Replication, T-SQL, Windows 2003 64-bit, DTS, Profiler, XML, Web Services.

Responsibilities:

• SQL SERVER 2005/2000 Production Environment.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at the SQL SERVER LEVEL.
• Implemented SIDE BY SIDE Migration of databases from SQL Server 2000 to SQL Server 2005
• Involved in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Worked with SQL Server 2008 new MERGE statement.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005/2008 on Windows 2003
• Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection and Compressed Backups.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Configured more than 2 GB ram on 32 bit Environment
• Migrated DTS packages to SSIS packages and maintained the archival data
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning
• Recovered the System and User databases from suspect mode, Expert in sizing Temp database.
• Prepared Documentation for the Disaster Recovery plan ,Worked in Active passive cluster environment
• Implemented new topics like CLR integration on Development Server
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers , Functions as per client requirements
• Extensively worked on trouble shooting and fine-tuning of databases for its performance , Rebuilding indexes with different fill factors and update statistics manually
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Did Performance Tuning of the Stored Procedures.
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations
• Extensively used lite speed backup with MS SQL SERVER 2005/2008.
• Expertise in SQL server Reporting Services(SSRS) and SharePoint
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call 24/7 Support on weekly basis

2/09 – 11/10: SQL Server DBA Client: Confidential, Charlotte, NC
Description:
Bank of America is the largest financial services company in the North America. The Financial team will be providing financial services and financial tools. The objective of this project was to create a Consolidate Reporting Project. Build a data mart for the Retail Customer Service department. The data is from the call center coming from different modules.

Environment:Windows 2003 server, ASP, XML, MS SQL Server 2005/2005, T-SQL, MS Access, MS Excel, Oracle.

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• prepared maintained and modified SQL server installation and configuration documents
• Involved in the migration ofSQL Server 2000 databases to SQL Server 2005.
• Responsible for monitoring and makingrecommendationsforperformance improvementin hosted databases. This involvedindex creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• Evaluated data storage considerations to store databases andtransaction logs. Created databases usingTransact SQL Statements,SQL Server Management StudioandDatabase Wizard.
• Implemented newT-SQLfeatures added inSQL Server 2005that areData partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE) , Data Partitioning, Snapshot Isolation
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2005tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures,stored procedures, Dynamic Management views,DDL triggersanduser-defined functions.
• Identified, tested and resolveddatabase performance issues (monitoring and tuning)to ensuredata optimization.
• Involvedin trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Managed trouble shooting ofClient connections, viewing error log and applications.
• Developedautomated backup and DBCC scriptsfor databases and transaction logs.
• Maintaining the databaseconsistencywithDBCCutility at regular intervals.
• Worked on log shipping for synchronization of database.
• Worked inCluster Environment.
• Authenticated logins and validated permissions. Created SQL Server Databaseusers and Roles.
• Writingstored procedures, triggers, and functionsand maintained coding standards.
• Involved indatabase Normalization, logical and physicaldata modelingusingERWIN.
• Created and supportedcomplex database schemas.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Installed SQL Server 2005 and created Development Database for testing, upgrades and development.
• Monitored servers usingSpotlight third party software.
• Transferred data (ETL) toData warehouse Environment using SSIS.
• Involved in SourceData Analysis, analysis and designing mappings for data extractionalso responsible forDesign and Development of SSIS Packagesto load the Data from various Databases and Files.
• Worked onDTS, Import and Exportutility, for transferring data.
• Installed, authored, andmanaged reports using SQL Server 2005 Reporting Services
• ConfiguredIIS,Report manager, Report serverand implemented role based security to end users and developed report models for creating Ad-hoc reports using SSRS.
• Worked withApplication Developersto design databases and tables to supportDevelopment activitiesand achieveoptimal efficiency.
• ConfiguredSQL Server settingsusing configuration manager.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Involved with development team and developed functions, procedures and packages performed Logical Backups byExportandImportutilities.
• Handled numerous change management requests on production servers

04/08 – 01/09 SQL DBA Client: Confidential, Miami, FL
Description:
Bayview Financial firm provide a wide range of products and services, including residential and commercial special servicing, residential and commercial mortgage and securities investing and small balance commercial mortgage origination.

Environment: MS SQL Server 2000/2005 ETL, DTS, Windows 2003 Server, ERWIN, Windows NT 4.0, MS Access, Toad, Excel, Visio.

Responsibilities:

• Installing, configuring and maintaining SQL Server 2005.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, Functions, indexes rules and defaults on MS SQL server using T-SQL.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Provided day-to-day administration tasks like space and log management.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2000.
• Created DTS packages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and Maintained Snapshot Replication across multiple server environments.
• Setup and maintained Linked Servers.
• Managed user access. Created and managed new security accounts.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Designed and facilitated the implementation of data warehouses required by application systems
• Supported OLAP team to providing data from SQL Servers.
• Published the databases from old servers to new servers using snapshot replication.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

01/07 – 03/08 SQL DBA Client: Confidential
Description:
ICICIBank offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries in the areas of investment banking, life and non-life insurance, venture capital and asset management.

Environment: SQL Server 2000, Microsoft Visual Basic 6.0 and Windows 2000.

Responsibilities:

• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Developed database objects like Tables, views, stored procedures, indexes etc.
• Tuned SQL statements using views and Stored Procedures.
• Designed Database objects including tables, procedures, views and database triggers on SQL Server Database.
• Rebuilding the indexes at regular intervals for better performance.
• Wrote various stored procedures for the purpose of application development.
• Wrote SQL Scripts to select the data from the source.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Created many complex Stored Procedures and used them in Crystal Reports.
• Created multi-format reports using Crystal Reports.

02/05 – 12/06 SQL DBA Client: Confidential
Description:
This system handles the basic material management functions like Materials planning and programming of procurement and supplies, Purchasing, Inventory control, Storekeeping and warehousing, Materials handling and transportation, Codification and standardization, Value Analysis, identification, Disposal of supplies, obsolete and scrap materials, Printing of various Books & Forms, Periodicals, and Journals.

Environment:MS SQL Server 7.0/6.5, T-SQL, DTS, Microsoft Visual Source Safe 6.0, Visual Basic 6.0,Crystal Reports 8.0 and windows 2000.

Responsibilities:

• Installing, configuring, administering and securing production servers.
• Setup new MS SQL Server instances and databases.
• Capacity planning of MS SQL Servers.
• Implement and maintain database security.
• Going through the clients\' requirements and coming up with database design and application architecture.
• Plan capacity specification requirements for new database servers.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Maintaining User account administration for Different domains.