Post Job Free

Resume

Sign in

Sql Server Data

Location:
Columbus, OH
Posted:
May 19, 2017

Contact this candidate

Resume:

SUDHAMA PENDEM Email: ac0ecp@r.postjobfree.com SQL Server DBA Phone: 516-***-****.

SUMMARY:

** ***** ** ****** ************ experience in SQL Server 2016/2014/2012/2008R2/2005 as Database Administrator and Developer.

Highly experienced in installing, configuring and administering SQL Server 2016/2014/2012/2008R2/2005/2000 on Standalone and VM Ware Servers (Windows Server 2012/2008/2003/2000).

Upgraded and migrated several servers and databases from SQL Server 2008/2005/2000 to SQL Server 2016/2014/2012/2008R2.

Provided 24/7 On Call Support for Production servers.

Extensive experience in Installation, Configuration and Administration of SQL Server in a Clustered and Non-Clustered environments.

Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.

Highly experienced in Configuring, Implementing and Maintaining Database Mirroring and Always ON.

Good Knowledge in implementing in different Replication Models (Snapshot, Merge and Transactional) with different topologies.

Highly experienced in Configuration, Implementation and Maintenance of Log Shipping.

Extensive experience with backup and Restore methodologies using Native and third party tools (LITE SPEED, NetBackup, and Red Gate).

Highly experienced with Business Intelligence in MS SQL Server 2008R2/2012/2014 in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.

Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.

Expertise in migrating servers using in place and side by side upgrade.

Experience in capacity planning, performance tuning, and disaster recovery and troubleshooting performance issues.

Good knowledge and working exposure in Storage Concepts of RAID levels and SAN environment.

Highly experienced in migration of data using BCP Utility, Bulk Insert commands, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.

Extensive knowledge in design of logical and physical data modeling using Erwin data modeling tool.

Experienced in Extraction, Transformation and Loading (ETL) process using DTS, SSIS.

Created Linked Servers for OLEDB Data Source and Native Data Sources.

Experience in developing management reports using SSRS.

Documented Disaster Recovery Plans and Participated In Disaster Recovery Drills.

Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.

Very good knowledge of PCI/SOX regulations and documenting audit procedures.

Developed Dash Board Reports on COGNOS 8.4 report studio

Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.

Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2005/2008/2012/2014/2016.

Good knowledge with features of Sql server 2008 like Spatial, CDC, Resource Governor, Encryption and File stream Data functionality.

Strong in creating, monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views.

Strong in monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Have experience in Power Shell Scripting.

Good working knowledge in .Net Frameswork2.0/3.0/3.5/4.0,VB.Net,C#, ASP.Net, ADO.Net, XML and Web Services.

Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities. Extremely diligent strong team player with an ability to take new roles.

Microsoft Certified IT Professional: Database Administrator.

TECHNICAL SKILLS:

Platforms: Windows 95/98/Me/XP/NT/2000 server/XP/2003 server/2008 server /2012, PSI, VM Ware servers.

Databases: SQL SERVER 2000/2005/2008/2008R2/2012/2014/2016, MS-Access

Programming Languages: SQL, PL/SQL, VB 6.0, VB.Net, C, C#, VBScript, PowerShell

Web Technologies: Asp.Net, HTML, DHTML, XML, IIS 6.0, Java Script

Tools: SQL Server Management Studio / Enterprise Manager, SSRS, SSAS, SSIS, Enterprise Manager, SSMS, Visual Studio 2005/2008, SharePoint 2007/2010/2013, VERITAS, Quest LiteSpeed, Red Gate, Erwin, Tivoli, SCOM, ESM, RSAM, ITSM, Servicenow, Peregrine, Guardium, Vizio.

Education:

MS (Electrical Engineering) –University of Bridgeport

B. Tech (Electronics and Instrumentation Engineering)- J.N.T.U Hyderabad

Huntington National Bank- Columbus, OH Apr 15- Till Date

Role: SQL Server DBA

Responsibilities:

Actively participated in gathering of Requirement, Design and System Specifications.

Administrated and Managed SQL Server 2016/2014/2012/2008R2/2008/2005 databases in Production, Disaster recovery, UAT,PERF and Development environments.

Upgraded/Migrated SQL Server 2008 databases to SQL Server 2016/2014/2012 databases and mentored other technical staff.

Installed SQL 2016 on 4 node clustered windows server 2012.

Migrated and upgraded databases from SQL 2008 R2 to SQL Server 2016.

Moved the logins, jobs, linked servers, SSIS Packages to SQL Server 2016.

Managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.

Configured and maintained SQL Server Always on Production databases.

Worked on creating RBAC (Role Based Access Control) model for SQL server logins.

Created DBA jobs to collect and monitor DB Servers using powershell.

Created backup and DBAdmin reports using SSRS.

Worked on SSIS and SSRS to generate the backup reports, failed jobs.

Supported both OLTP and OLAP(SSAS) applications.

Created contained databases.

Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.

Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.

Implemented Data masking\obfuscating techniques while migrating sensitive data from PROD server to lower environments.

Used Policy Based Management. Created policies, facets and conditions.

Used Resource Governor for limiting the resources like CPU, Memory to applications on shared Farm environments.

Created contained databases on SQL server 2012.

Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing and Resource Governor

Performed data partitioning for efficient management of database tables and indexes.

Involved in Monitoring Performance of different production servers.

Resolving performance issues using DMVs (Dynamic Management Views).

Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.

Fixed SQL Spotlight warnings and errors.

Worked on user request, problem, Servicenow incidents and change Tickets.

Worked on-call (24/7) rotation.

Environment: Windows Server 2012, Windows Server2008, SQL Server 2016/2014/2012/2008 R2, SSRS, SSIS, Internet Information Server 6, JavaScript, CSS, HTML, SharePoint, Visual Studio 2015/2013/2010,.Net Framework 4.0/3.5, TFS, C#, RSAM,ESM, Tivoli, SCOM, Guardium, EPV, Quest LITE Speed, Spotlight,ServiceNow.

JPMChase- Columbus, OH Jun 12- Apr 15

Role: Sr SQL Server DBA

Responsibilities:

Installed and configured SQL Server 2005, SQL Server 2008, and SQL Server 2012 on WINDOWS 2003/2008 servers, applied service packs and security fixes in Clustered and Standalone environments.

Worked extensively on installation, upgrade and configuration of MS SQL Server 2012/2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005 on Cluster, Standalone\PSI and VM Ware Servers.

Supported and managed 1000+ MSSQL Server Instances running on Production, Disaster recovery, UAT,PERF and Development environments for client of their Business Units.

Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.

Configured Merge and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers.

Supported production servers in Fail over cluster environment.

Worked on mortgage banking, involved in the Database design, build Stand alone and 2 Node clustered SQL 2008 R2 servers, migrated databases.

Worked on SAN Layout, Designed and build cluster servers for Capital marketing.

Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.

Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.

Designed and populated reporting tables, views and stored procedures.

Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.

Worked on databases over 6 TB size.

Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.

Respond to trouble tickets assigned to me and fix any database issues promptly.

Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.

Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.

Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.

Evaluate the peak and no peak usage pattern of the application; effectively distribute database administration activities, such as full database backup and database defragmentation during no peak hours.

Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.

SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.

Developed SSIS packages to export data from OLTP database to OLAP database.

Created SSIS package to send a daily backup report of all the DB servers.

Responsible for Physical Storage Structures and Index Design and Tuning.

Worked on Tivoli\SCOM and Guardium alerts.

Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.

Used TFS for Version Control.

Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.

Environment: Windows Server 2003, Windows Server2008, SQL Server 2008/2005/2000, SSRS, SSIS, Internet Information Server 6, JavaScript, CSS, HTML, SharePoint, Visual Studio -2015/2013/2010,.Net Framework 4/3.5,TFS, VB.Net, C#, RSAM,ESM, Tivoli, SCOM, Guardium, EPV, Quest LITE Speed.

VENSIT Corp- Sayreville, New Jersey Apr 09 - May 12

Role: SQL Server DBA

Responsibilities:

Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non-clustered environment.

Migrated from SQL Server 2000/2005 to SQL Server 2005/2008.

Configured security and access per SOX and PCI standards.

Created Linked Servers for OLEDB Data Source and Native Sources.

Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.

Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, alerts, activity logs, error logs to capture any possible errors.

Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.

Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.

Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.

Running DBCC consistency checks, and fixing data corruption in user databases.

Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Implemented and Monitor the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.

Worked on fail over clustering and mirroring.

Documentation of daily tasks and scripting them.

Worked in 24X7 production support with a rotation basis.

Involved in loading the Warehouse databases and performing maintenance tasks on these databases.

Setup log shipping and troubleshooting log shipping errors when arises.

Experience in implementing Failover Support for SQL Server with active/Active Cluster configuration.

Used SQL Profiler to find badly performing queries and deadlocks.

Migrated schemas\tables from different database sources (Oracle) to SQL server.

Developed SSIS packages to export data from OLTP database to OLAP database.

Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.

Configured and worked on SSRS.

Created Indexes to speed up the queries and Performed Database Normalization.

Environment: MS SQL Server 2000/2005, Windows Enterprises 2003 servers, IIS Web server, Toad for SQL Server, LiteSpeed, JavaScript, CSS,HTML, Microsoft CRM, SSIS, SSRS,VERITAS NetBackup,ERWIN,C#,VB.Net, ASP.Net.

AZWEN Info Technologies, Hyderabad Jan 06- Dec 06

Role: SQL DBA/Developer

Responsibilities:

Upgraded the server from SQL 2000 TO SQL 2005.

Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages.

Created SSIS Packages to Extract, Transform and Load (ETL) consolidated data from different sources into Data Warehouse.

Suggested Disk Capacity, Processors and Memory based on the Capacity planning.

Performed Backup/Restore by using native and 3rd party tools like litespeed, VERITAS Net Backup.

Created and scheduled back up using Maintenance Plan wizard.

Extensively used Database Tuning Advisor to improve the performance of Query.

Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Monitored the application and database performance using SQL Profiler and Performance Monitor.

Used Index tuning wizard to get a better idea of implementing indexes on the existing databases

Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.

Performed database consistency check as regular Interval.

Assisted with development of Extract, Transform & Load (ETL) scripts to migrate from MS SQL Server DB schema.

Implemented Replication and Log Shipping to overcome Disaster Recovery plan.

Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.

Implementation of data transfer through DTS and setting guidelines to automate recovery scenarios.

Environment: SQL server 2005,SQL Server 2000 Enterprise Edition, MS Reporting Service 2000, Windows 2000/2003 Server, IIS 5.0, VERITAS NetBackup, SQL Profiler



Contact this candidate