Venkata Kishore Ammi

Sr SQL Server DBA

acrh33@r.postjobfree.com

240-***-****

Visa Status : Green card

PROFESSIONAL SUMMARY:

Over 12+ years of IT Professional experience in, Database Administration, Design, Testing and Support using SQL Server 2000/2005/2008/2012/2014.

Experienced in setting up the SQL Server 2012 on VMware platform by using VMware HA/SQL server HA options and configuring HA/DR setup using Always ON.

Expertise in Database Administration on Production Servers with Server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Experienced working on Datacenter Migration projects (Server/Database Consolidation/Database migration/Upgrades)

Extensive working experience in various industries including banking, finance, marketing services, Government and healthcare industry.

Extensive experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008, 2012 on both Cluster and Stand-alone Environment.

Database Design in Full, Bulk Logged, Simple Recovery Modes, Restoring Databases with Point in Time Recovery.

Extensive experience in designing, implementation and administration SQL Server Relational Database / Data Modeling, Data Warehouse in small, medium and large organizations.

Worked with SQL Server 2012 migration from SQL Server 2008

Experience with configuring high availability and Disaster recovery scenarios like clustered environments, Setting up different topologies in replication (Transactional Replication, Snapshot Replication and Merge Replication)

Experience in Log Shipping (Configuration of source, Target and Monitor) Servers in SQL Server 2005

Experience in Power Shell automating the Maintained tasks

Worked on various SSIS/DTS packages for data import/export/transformations from different OLEDB/Flat source to SQL 2005/SQL 2008

Good understanding of High availability techniques Database Mirroring,Clustering, Always ON

Experience in working with Linked Servers, Distributed Transactions.

Hands-on working experience with analyzing query plans, query optimization, performance tuning, managing indexes and locks, troubleshooting deadlocks.

Running of Traces using the SQL Profiler tool, Performance Monitoring & Tuning using the Performance Monitoring Tool, Query Optimization, Extended Events

Excellent skills in implementing ETL Packages using DTS and SSIS 2005/ 2008.

Experienced in configuring SQL Mail & troubleshooting issues related to mail configuration.

Creating and Maintaining Databases, Adding Users, Roles and Groups and assigning privileges according to the project needs.

Expertise in T-SQL, Stored Procedures, Functions, Cursors and Triggers etc.

Used Indexes for improving query performance, lower storage and maintenance cost.

Excellent communication skills. Proactive, independent and easy-going.

Experienced in SQL Server Integration Services 2005/2008 and SQL Server Reporting Services 2005/2008.

Worked on Enterprise applications SAP, Oracle JDE having backend Very large SQL databases in Virtual platform.

Expertise in T-SQL writes stored procedures, triggers and functions.

Expertise in SSIS, SSRS& SSAS with Complete BI Suite.

Technical Skills:

Languages

Java, C#, ASP.NET, VB.NET,JSP, JDBC, JDOM, XML,

C++, Java Script-SQL, PL/SQL, T-SQL.

Databases

MS SQL Server 2012/2008r2/ 2008/2005/2000, MYSQL 5.0, Oracle, MS Access.

ETL tools

DTS, MS SQL Server 2005/2008 Integration Services (SSIS).

Operating System

Windows 2000, 2003, XP, Vista.

Reporting Tools

MS SQL Server 2005/2008 Reporting Services (SSRS).

SQL Server Tools

SQL Server Management Studio, BIDS (SSIS, SSAS, SSRS), SQL Server Query Analyzer, SQL Server mail service, DBCC, SQL Server profiler

Shire / InVentiv Health,PA Jun 2011 –Till Date

Lead SQL Server DBA

Responsibilities:

Installed and Configured SQL 2012 Failover Clustered Instance.

Configured Always –ON for HA/DR of SQL 2012 in different Data Center Sites.

Worked on VMWare 5.0 for virtulaizing SQL Database servers.

Worked on troubleshooting the performance issues on Very Large Databases on Virtual Platform.

Worked on migrating the SQL Server databases to SQL Azure .

Worked on Different Storage appliances VPLex &VSP for architecting SQL Database servers on Cloud.

Worked on Design of the SharePoint App- DB servers and layout for better performance on V-Block.

Worked on V-Block Stack and Virtualized SQL Server 2012 for SAP environment on Windows 2012.

Configured availability Database groups using VIP on SQL 2012 for SAP Enterprise application.

Migrated Oracle 10 g to SQL 2012 for SAP Environment.

Supported SAP Environment after the Migration and worked on trouble shooting the issues.

Supported SQL Servers forMicrosoft CRM Dynamics application.

Partitioned Very large audit tables in SAP in to different partitions.

Implemented Storage based replication DR solution for SQL servers.

Implemented Automatic Statistics Update for SAP-SQL Databases using trace flags.

Worked on Designing the VM layout of DB servers and VMware HA.

Upgrading SQL Server 2008 R2 to SQL Server 2012.

Worked with Enterprise Monitoring Tool NimSoft.

Worked with SQL Server Business Intelligence Technology stack SQL Server Integration Services, SQL Server Reporting Services

Configuration of backups using Power shell scripts for SQL 2008 R2 servers

Configuration of Network protocols using Power shell scripts

Worked in SSRS 2008 R2 Configuration setup and deployments /Development

Setup for SQL Server replication(Merge/Transactional) for SQL 2008R2 and managing replication in test and Production environment

Worked on Backup Recovery Solutions.

Extensively Used DMVS for identifying bottlenecks in resolving the Issues

Worked on architecture solutions for high availability and monitoring the databases

Worked on Red-Gate Performance Monitoring Tool/Spot Light.

Worked with CommVault /Symantec backup exec/SyncSort Backup Tools.

Worked with Idera Diagnostics Manager for SharePoint-SQL Farm.

Monitoring of SQL statements and stored procedures with SQL Tools.

Worked on ASP.net with C#.net in establishing the connections to Database Server.

Performing DR activities and Database Mirroring.

Migrated DTS packages to SSIS.

Worked on SSAS Configuration and Deployment.

Deployed SSIS packages and Reports to Production Servers.

Set up log shipping between production server and standby servers; synchronized the production server and standby server; implemented log shipping break-up between production and standby servers.

Configured and managed clusters; set up SQL Server 2000/2005/2008R2/2012 on active/active, active/passive clusters; configured resource dependencies; Implemented cluster fail- over.

Involved with Infrastructure Teams for Design and architecture.

Optimized SQL queries for efficiency and assisted the front end developers with their queries and procedures.

Created non-clustered indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.

Performed performance tuning by analyzing indexes, queries, table sizes, etc and heavy utilization of SQL Profiler, DMVs, Database Engine tuning advisor and query execution plan tools.

Setting up Proxy accounts, configuring Database mail and linked servers

Worked on Data Transformation Activities using SSIS Import/ Export of transferring data between different databases like DB2 to SQL Server. Moved Data from flat files and Excel sheets using SSIS.

Installed Service packs and hot fixes for the SQL Server 2000/2005/2008R2/2012.

Configured Linked Server in a heterogeneous environment.

Involved in Migration of the Data Center for SQL servers and Defined the approach for migration methodologies

Intensively used DBCC commands, SQL Profiler, trace Analysis and execution plans as part of troubleshooting and performance tuning.

UBS, Connecticut Dec2009 –May 2011 Lead SQL Server DBA

Responsibilities:

Migrated and validated users and logins into the new environment for SQL 2008.

Installation, Administration, Configuration of SQL Server 2005, SQL Server 2008

Providing 24x7 support to Production, QA and Development servers.

Involved in installations, upgrades, patches and fixes.

Worked on Side by Side migration of multiple SQL 2005 instances to SQL 2008

Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2005, 2008 and databases.

Successfully implemented Database Mirroring for ensuring High Availability of database servers.

Closely worked with developers for query optimizations, performance tunings, and migration of SSIS packages.

Troubleshooting jobs and permission issues, analyzing stored procedures for performance issues.

Transferred and created maintenance plans, scheduled jobs and SSIS packages.

Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications

Implemented events service with best service monitor or trigger like Event Viewer, System Monitor, SQL Agent, and SQL Server Profiler.

Production Support for the Shared points as per the requirement

Implemented Log Shipping in SQL 2005 from Primary Server to Standby Server.

Created tables, views, indexes, functions and advanced queries for databases by using SQL Server Management Studio.

Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)

Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check, and index defragmentation.

Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server Utilities

Performed Performance Testing in SQL Server using SQL Profiler and Execution Plan for query performance analysis. Modified, and optimized complex queries for data retrieval and modification

Identified, Tested, and resolved database performance issues using performance monitor and SQL profiler and queries and procedures to boost database performance.

Deployed the SSIS package on various servers using package configuration from test server to production servers. .

Setting up Backup plans for the database.

Modified existing database by adding tables and relationships to existing data model.

I was involved in writing T-SQL Stored Procedures.

Environment: Microsoft Windows Server 2003 Enterprise Edition, Microsoft Windows 2000 Server, Microsoft SQL Server 2008, Microsoft SQL Server Data Transformation Services, Microsoft SQL Server Reporting Services.

MERCK, NJ Oct 2008 –Nov 2009 Sr.SQL Server DBA

Responsibilities:

Built and configured more than 200 database servers for production and development environments.

Conceptualized and Designed Logical and Physical Data Models using ERWIN.

Created reports using Microsoft SQL Server Reporting Services 2005/2008.

Improved the server Availability time with optimum levels of Database Recoverability by incorporating the SQL server Differential backup and LOG Backup..

Responsible for MS SQL Server 2000/2005, configuration, tuning and provide 24 X 7 dedicated support to all Production/staging/development servers.

Experience in working with agile development.

Involved in upgrading the instance of the development environment of SQL Server 2000 to SQL Server 2005 with appropriate hot fixes and service packs.

Configured and monitored Transactional replication.

Worked with development team in implementing business logic using Stored Procedures, Triggers, Views and User-defined functions.

Created, scheduled and managed all the database maintenance plans using SSIS packages in all the SQL servers across the environment

Identified, tested, and resolve database performance issues (monitoring and tuning) using Perfmon and Profiler to ensure database optimization.

Performed the import and export of data across the various Database servers.

Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder

Deployed SSIS packages on to the Production Database servers and scheduled them using SQL Agent.

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.

Maintained high availability of databases using Database Mirroring and Log Shipping.

Worked in Clustered environment (Active/Passive) for high availability of servers.

Created database, tables and procedures to update and clean the old data.

Worked with the front-end application developers with their queries.

Managed security, logins, roles and permissions on different database objects..

Worked on creating and configuring SQL Server Log Shipping and Mirroring with Monitor and Witness Servers for high availability of server.

Created Packages for testing and Cleansing data by using various Data Flow Transformations such as Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, Fuzzy grouping and Fuzzy lookup.

Developed Stored Procedure and pre-staging table for data push.

Designed scheduled data synchronization approach, utilizing Microsoft DTS for Extract, Transform, and Load

Environment: MS SQL Server 2005, MS SQL Server 2000, SSMS, DTS, SQL Server Integration Services, SQL Server Reporting Services, Crystal report 9.0,IIS server 6.0

University of Texas at El Paso, El Paso, TX Jan2006 – Jul 2008 Sr . SQL Server DBA

Responsibilities:

Installed and administered SQL Server 2005 with Windows Server 2000.

Designed and developed logical and physical layers of the various databases.

Optimized database performance and use of resources, including selecting optimal physical implementations of databases.

Assisted management with database and resource capacity planning.

Expertise in data cleansing for various Data Source and loading them in to Destination Database as per the Business Requirement using SSIS various Components.

Lookup for some columns data from source and changing/updated related columns with SSIS and also Access Web services using SSIS.

Installed SQL Server on Windows 2000 Advanced Server with latest service pack.

Monitored user accounts, user permissions, database extents, table partitions and backup

Used DTS to transfer data between SQL Server and operation system files.

Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and problems related to the privileges.

Involved in creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Experience in Database administration activities for DB Security (creating users, roles and assigning permission to them).

Successfully Designed and Implemented Microsoft Windows Server 2003/2000 Cluster, Microsoft SQL Server 2005/2000 Active/Passive Clusters.

Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

Automated the DTS/ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice verse using SSIS..

Creating and Maintaining Databases, Adding Users, Roles and Groups and assigning privileges according to the project needs.

Analyzed, fine- tuned and optimized MS SQL Server Applications by using Performance Monitor, setting up traces using SQL Profiler

Experienced in creating cubes and dimensions, handling multi dimensional reports.

Modified existing database by adding tables and relationships to existing data model.

Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality

Environment: Windows NT/2000/XP, MS SQL Server 2000, DTS, MS Access, MS Excel, SQL Query Analyzer, Oracle 9i,UNIX, Data Ware housing, Erwin.

Hindustan Lever Limited, Hyderabad, INDIA Oct2003 – Nov 2005 SQL Server DBA

Responsibilities:

Developed and implemented change control procedures to manage system modifications/upgrades.

Backing and Restoring of Databases on Scheduled basis.

Worked with DBA to set-up the security roles for developers and end-users.

I Used SQL profiler to view indexes performance to mostly eliminate table scan.

Worked with development teams in the design of physical databases and in modification.

Created and scheduled SSIS packages for running AM and PM feed from multiple servers for various departments using SQL Server Agent.

Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).

Populated data after verification and mapping from Staging database to Data Mart.

Created SQL server configurations for SSIS packages and XML & Windows event logs.

Implemented event handlers in SSIS package for event handling and used custom and system logging, precedence constraints, various transaction types for error handling.

Implemented checkpoints at various stages ion SSIS package for better performance.

Created calculated members for customized calculated measures.

Identified and created dimensions and facts in conformance to business requirements.

Analyzed the Performance of a Cube by partitioning it and creating Perspective Cubes.

Created the storage modes for partitions in MOLAP and ROLAP.

Environment: SQL Server 2000/2005, SSIS, Query Analyzer, Index Tuning Wizard, MS Access, MS Excel, Windows Server 2003 Enterprise Edition, T-SQL.

Ranbaxy Laboratories Ltd., Pune, India Aug2002 – Sep2003 SQL Server DBA

Responsibilities:

Involved in various stages like development, system Analysis, and design for new application.

Designing and development of Interfaces and connected to Database using ADO technology for SQL Server.

Performance Tuning, Analyze, tuning and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.

Created updatable partitioned views.

Created Stored Procedures and triggers to perform automated rules, updating to related tables.

Created backups for databases

Setting up Replication using Dynamic scripts and solving problems

Involved in Performance tuning.

Created Stored procedures

Designed and validated the forms according to client requirement by using VB.

Implementing the database objects like stored procedures and Triggers.

Debugging and fixing the bugs.

Worked to create Software Requirement Specification (SRS) document.

Developed and coded applications in T-SQL.

Designing the Logical and Physical databases and development of SQL Server Database.

Database testing, maintaining the data and writing the procedures. Discussions with Product team for new features

Environment: SQL Server 7.0, T-SQL, Windows NT 4.0, HTML 4.0, VB 6.0, ADO 2.0

EDUCATION: Bachelor’s in Computer Science from JNTU 2002, INDIA.

Contact this candidate