Sql Server Data
Resume:
Vineela Panguluri
******************@*****.***
SUMMARY:
8+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R2/2008/2005/2000 in OLTP and OLAP environments.
Experience installing MS SQL SERVER 2005,2008,2008 R2,2012,2014; updating with hot fix and service packs
Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
Extensive experience in implementing High availability and Disaster Recovery solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
Extensively worked on Active-Active and Active-Passive Clustering.
Implemented new features in MS SQL Server 2012 like Always on HADR in prod and non-prod environments.
Implemented In place and Side by Side Migration of MS SQL SERVER 2000/2005 to 2008 R2 and 2008R2 to 2012,2012 to 2014
Experience in developing T-SQL (DDL, DML, and DCL) statements.
Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
Microsoft Certified Database Administrator (MCDBA)
Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
Experience in using the DMVS, DMFS, SP_PROC’s, INFORMATION_SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
Expert in Data Integrity, Performance Tuning, Query Optimization
Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
Expert in creating Views, Indexes, Partitioning.
Worked on Datatel's Colleague ERP System
Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
Experience in logical and physical data modeling of the database in ERWIN and MS VISIO.
ITIL Process implementation (Incident/Problem/Change/Release Management).
Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
Configured the AWE and /3 GB switch for the SQL server 2005 on 32-bit boxes.
Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
Experience in SQL Upgrades SQL 2000 to 2005 and Building SQL Clustering.
Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, and Updating Statistics.
Expert in analyzing the execution plan and index management for better Query Optimization.
Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
Experience with Azure/AWS
Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
Experience in using DMV and DBCC commands for various performance issues.
Extensively used third party tools like Lite Speed, Fog light and Red gate.
Auditing of database for users transactions, login and database action and removing orphan users
Worked with a team of business analysts, data architects, application developers, ETL developers and testers
Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
Microsoft Certified Systems Engineer (MCSE)
Experience in creating SQL Server Reports using SSRS 2005 and 2008, 2012.
Experience working on Hyper-V and VMware environments
Experience working with Change control process/Change management
Strong experience in mentoring junior team members, documentation and 24/7 on call production support
24*7 Production support experience
Technical Skill:
Languages
C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script, Shell, Sybase,
Operating Systems
Windows 95/2000/2003/2008/2008r2/2012/2012r2/XP/VISTA/7, Sun Solaris 9,VMware ESX servers
Databases
MS SQL Server 2014/2012/2008R2/2008/2005/2000, Oracle 10g/11g, MS Access, MongoDB
ETL & Reporting Tools
DTS, SSIS, SSRS, SSAS, Crystal Reports, MOM
DB Utilities
SQL Server Management Utility, Query Analyzer, Toad 8.0 version
Application Software
Visual Studio 2005/2008/2012, Visual Source Safe, TFS, MS Office Suite
Data Modeling Tools
Erwin
Other Tools
Lite Speed, Red gate, Fog light, Spot light, Blade Logic, Altiris,
Bmc Remedy, Pro Task, Jira Board, PCI Compliance, AWS
Education:
Bachelor of computers, Vasireddy Venkatadhri Institute Of Technology, India.
PROFESSIONAL EXPERIENCE:
Park Medical Systems,NJ Sept 2014 – Sept 2015
Description: Perk Medical Systems delivers the solutions you need, streamlining the process of converting a paper-based office into a complete electronic system, by offering comprehensive web-based Electronic Medical Records software. The goal of paperless medical records is a realization. Succeed in improving customer’s medical practice by investing in our EMR product.
Role: Sr Sql Dba/Developer
Responsibilities:
●Gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
●Involved in database Schema design and development.
●Migrated Database from SQL Server 2005 to 2008.
●Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
●Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
●Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
●Enhancing and deploying the SSIS Packages from development server to production server.
●Wrote the ETL scripts to load the data into database from various source files.
●Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
●Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
●Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
●Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
●Expert in SSIS Deploying and Scheduling.
●Having good knowledge in Mongo Database design.
●Identified and Defined Key Performance Indicators in SSAS 2005/2008.
●Defined report layouts for formatting the report design as per the need.
●Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
●Generated Reports using Global Variables, Expressions and Functions for the reports.
●Created reports and Dashboards using Microsoft PerformancePoint service.
●Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
●In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
●Administrated the created Reports by assigning permission to the valid user for executing the reports.
INFOMERICA Inc, NC March 2013– Aug 2014
Description:
Infomerica Inc. is a professionally managed and fast growing software development company, and expertise in a full range of information systems including system design, planning, development and implementation. The Infomerica Inc. will have client base includes Automotive, Industrial, Banking and Financial corporation company.
Environment: SQL Server 2005, T-SQL, DTS, Lite speed, Double-Take software, SQL backup and BMC Remedy.
Role: Sql Dba/Developer
Responsibilities:
Installed and maintained MS SQL Server 2005/2000 on Windows 2003 Server.
●Monitoring database performance using SQL Profiler and the DB’s percent log space for all database servers using SCOM and Windows Performance Monitor counters.
●Maintained the Active-Passive Clustering as a disaster recovery solution
●Implemented different types of Replication Models like Snapshot and Transactional Managed the use of disk space, memory and connections.
●Performed DBCC utilities and fixed data corruption in application databases.
●Configured and maintained database mirroring for high availability.
●Using log shipping for synchronization of database.
●Monitored Databases for lock escalation, DeadLock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries using SQL Profiler.
●Traced long running queries and deadlocks using SQL Profiler
●Created and managed schema objects such as tables, views, indexes, procedures, and triggers maintained Referential Integrity.
●Analyzed designed, developed, implemented and maintained the instances of databases. Worked on monitoring and tuning the SQL scripts
●Worked with T-SQL development and performance tuning in T-SQL code. Participated in Performance Tuning of Code using execution plan and SQL profiler.
●Added Indexes to improve performance on tables. Used multiple join statements to retrieve data from multiple tables.
●Configuring and implementing SQL Server contained database.
●Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
●Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions. Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
●Global Customer interactions through mails/telephonic etc.
●Normalization and Denormalization of tables. Developed Backup and Restore scripts for SQL Server 2005. Installed and Configured SQL Server 2005 with latest service packs.
Texas Comptroller of Public Accounts, Austin, TX Aug 2011 – Jan 2013
Description: The Texas Comptroller of Public Accounts is an executive branch position created by the Texas Constitution. As with nearly every other executive branch head, the comptroller is popularly elected every four years concurrently with the governor
Environment: SQL Server 2005/2008/2008R2/2012 with clustering, Sybase, T-SQL, LiteSpeed, Windows 2000, Oracle, VB and ASP.
Role: Sql Dba/Developer
Responsibilities:
Installed and configured SQL Server 2005/2008/2008R2 on the server and client machines, provide connections and manage databases.
Created and maintained various databases for Production, Development Servers using MS SQL Server 2005/2008/2008R2.
Planning the location of data, indexes, and Transaction log files on the disk.
Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
Resolved locking and blocking issues.
Tuning the Production server to get the performance improvement.
Running Index tuning wizard for optimal query performance.
Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery.
Experience working with IDERA for Performance Monitoring, Dead Lock, and Blocking.
Monitoring SQL Server Logs, Application logs and analyzing the logs.
Provided 24/7 support to SQL application developers in implementing them production server.
Reorganizing or Rebuilding Indexes based on the Index fragmentation.
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Creating Backup strategies and scheduling them as a part of database maintenance plans.
Created the SSIS packages for executing the tasks, created the Jobs and scheduled for daily running.
Involved in Change Data Capture process.
To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, production support and Project review with client.
To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
To design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.
TD Bank, NY Oct 2009 – June 2011
SQL Server DBA
Description:
TD Bank, N.A., is a United States national bank chartered and supervised by the federal Office of the Comptroller of the Currency. TD Bank offers banking, insurance, brokerage, and investment banking services
Environment:
MS SQL Server 2000/2005/2008, Windows 2000/2003 servers, .NET, MS Access.
Role: Sql Dba/Developer
Responsibilities:
Installing and configuring and tuning and providing 24X7 support for SQL Server 2000/2005/2008 R2
Created and scheduled jobs to setup log shipping between production servers.
Implemented Database Mirroring on the SQL Server 2005 production databases.
Job Monitoring and making sure all jobs run successfully every night.
Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
Worked extensively on SQL Server Reporting Services to generate reports.
Created Linked Servers between 2005 and 2008 R2 servers.
Involved in Migration from SQL Server 2000 to 2005 and 2008
Created Database Diagrams using Erwin Data Modeler.
Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
Migrated and tested DTS packages to SQL Server 2005 Integration Services.
Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
Restore Development and Staging databases from production backups as per the requirement.
Extensively used SSIS to move data from text files to SQL Server.
Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
Prepare daily report on the job failures, backup failures and disk space.
Extensively used Database Performance Monitoring tools for performance tuning.
Designedandimplemented database maintenance plan.
Used Index tuning wizard and rebuilding indexes for faster Query Performance.
Involved in resolving dead lock issues and performance issues.
Navayuga InfoTech, Hyd, India Sept 2007 – Aug 2009
SQL Server Developer/DBA
NIT is a full-service IT global outsourcing company. It is our goal to ensure that our clients receive the multiple benefits of world-class infrastructure, deep domain knowledge and streamlined processes combined with speed of design and implementation at the best cost.
Environment
MS SQL Server 2000/2005, T-SQL, Windows NT/2000/ 2003
Role: Sql Dba/Developer
Responsibilities
Installation and configuration of MS SQL Server 2003/2000/7.0
Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
Created ER diagrams
Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.
Involved in Optimization and normalization of database and tables.
Involved in conceptual and physical modeling of data using Erwin tool.
Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
Part of team for analyzing and implementing the physical design for database.
Writing complex Stored Procedures to meet the business requirements.
Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
Designing and building data load procedures, using MS SQL Server.
Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
Responsible for transferring of database and database objects from Development to Production Server using DTS.
Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.
Contact this candidate