Sql Server Data
Resume:
HARI KODURI
******.******@*****.***
Professional Summary
More Than 15+ years of experience in the analysis, design development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server and data warehouse environments.
12+ years of experience as SQL Server DBA (2014,2012, 2008 R2,2005,2000,7.0& 6.5)
and 2 Years of Experience as Teradata DBA.
Experienced in OLTP & OLAP environments that includes Production (24x7), QA and development databases in SQL Server.
Experience working with Production 24/7 and Development Environments.
Experience Working in Microsoft Azure Environment.
Experience in Physical and logical data modeling using ERWIN.
Experience in assisting the Application Developers in creating conceptual database designs that meet the business and technical objectives of various projects.
Support multiple SQL Server Instances in a High Availability and Disaster Recovery Environment.
Experience working on AlwaysOn Availability Groups, Microsoft Clustering, Log Shipping, Database Mirroring and Replication.
Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
Experience in Disaster Recovery Planning and Security Management operations.
Experience in installation, configuration & maintenance of SQL Server.
Experience in Upgrading SQL Server 2000 to 2005 and 2005 to 2008 r2 and 2008r2 to 2012.
Experience with Visual Studio using Team Foundation Server
Design, document, and promote security "best practices", policies, standards and protocols.
Experience in using DMVs and Dynamic Management Functions for finding out long running queries.
Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
Experience in Database backup and disaster recovery procedures.
Expertise in T-SQL writing stored procedures, triggers and functions.
Experience in using PowerShell Scripts to automate various DBA tasks
Customized Data Extraction, Transformation and Loading ETL tools.
Working knowledge in SQL Server Analysis Services(SSAS), Reporting Services(SSRS)
Experience in Migrating DTS Packages to SSIS Packages
Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks
Experience in using various 3rd party tools to monitor SQL Server performance and backup/restore databases.
Experience in creating and working on OLAP Cubes.
Experience in data migration from MS Access to SQL Server 2005/2012.
Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
Experience in VMWare - Installed, Configured, and Managed SQL Server VMware physical and virtual Environment
Involved in providing training and support to both users and developers.
Excellent Interpersonal and Communication skills, Good documentation skills. Excellent analytical, interpersonal and communication skills & desire to excel, fast learner, hardworking and versatile team player.
Technical Skills
Databases: MS SQL Server 2014/2012/2008 R2/2005/2000/7.0/6.x, Teradata 13/12,
Oracle 11g/10g/9.0/8.0, MS Access, AES 12.5, DB2 9.7, PostgreSQL 9.2
Languages: Transact SQL, PL/SQL, C, PERL, PowerShell, XML and SQL
CASE Tools: ERWIN, ER/Studio
GUI: .Net, VB 5.0/6.0
Web Programming: ASP, HTML, Windows Scripting, Java Script and VB Script.
OS: Windows Server 2012R2/2008/2003/2000/NT, UNIX, LINUX and
MS-DOS.
Tools/Others: DB Artisan, SQL Trace, SCOM, Quest Litespeed, Spot Light, Red Gate SQL Compare, IBM Tivoli, Symantec Net Backup, Idera SQL Diagnostic Monitoring, Team Foundation Server (TFS), SSAS, SSRS, OLAP, SSIS, DTS, Visual Source Safe, HP Open View Service Desk, IIS, MTS and Crystal Reports
PROFESSIONAL EXPERIENCE:
United HealthCare Group, MN Sep’16 - Present
As DBA responsibilities include
Troubleshoot database performance issues and tune database objects.
Support developers in writing and optimizing SQL code.
Provide standardization and consistency across environments
Used ServiceNow and HP Service Manager for change control system and defect Tracking.
Uphold enterprise policy guidelines and recommend new guidelines.
Compare and sync schemas with Red Gate SQL Compare.
Perform Logical and Physical data modeling for OLAP and OLTP databases
Environment: SQL Server 2014/2012/2008R2, SSRS, SSIS, Windows Server 2012R2, ServiceNow, IBM Tivoli, Red Gate SQL Compare and Erwin.
Sapient Global Markets, Arlington, VA Mar’16 – Aug’16
As DBA/Modeler Responsibilities Include
Understand and translate business needs into data models supporting long-term solutions.
Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
Migrating application code and objects from development/test environments to production.
Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
Experience with Visual Studio using Team Foundation Server
Worked on Developing Ad-Hoc Reports.
Environment: SQL Server 2014/2012, SSRS, Windows Server 2012R2 and Team Foundation Server 2015
Delphi, Troy, MI May’15 – Feb’16
As DBA Responsibilities Include
Install and configure Windows and SQL servers for all stages of development life cycle. Includes planning, sizing estimation, etc.
Perform Logical and Physical data modeling.
Work directly with development teams to identify, test and make necessary modifications to databases and SQL to ensure success of projects. Accomplished by implementing and enforcing a review process for all scripts that modify production systems to ensure proper practices followed as well as maintaining the stability and integrity of the production systems.
Writing Stored Procedures and Triggers to support application functionality.
Worked on creating SSIS packages, Scripts to migrate data from MS Access 97 to SQL Server 2012.
Experience in Installation and configuring Alwayson availability groups.
Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers Capacity planning in estimating and sizing of tables
Administering the MS SQL Server 2012 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
Work on Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
Environment: SQL Server 2012, Microsoft Azure, SSIS, SSRS, Windows Server 2012R2, MS Access 97, JAVA
USITC, Washington DC Feb’13 – Mar’15
As DBA Responsibilities Include
Installation of MS SQL servers on production, Test and Development environments.
Reverse Engineering the existing databases and creating logical and physical database model.
Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server
Backing up master & system databases and restoring them when necessary.
Security Management by creating user logins with appropriate roles, dropping and locking the logins.
Worked on PowerShell Scripts for automation of various admin tasks.
Capacity planning in estimating and sizing of tables.
Development and implementation of full backup and disaster recovery strategy for all SQL servers using a variety of full, differential and transactional backups allowing for point in time recovery. Regularly perform restore of production SQL backups, both local and from offsite tapes, to test servers. This allows the process to be verified and establishes a timeline if a restore is required in the production environment.
Configuring the Tableau Reporting tool and helping the users to create reports with Tableau BI tool
Worked on creating various dashboards and Reports with Tableau.
Environment: SQL Server 2008 R2, PostgreSQL 9.1.2, Tableau 8.2, VMWare, Windows 2008/2012, Linux, .Net, SharePoint 2010,SQL Server Architect,
CSC, Hyattsville, MD Jun’11 – Jan’13
As Architect/DBA Responsibilities Include
Responsible for co-ordination of all SQL Server related tasks and 10 member DBA team
Perform Logical and Physical data modeling for OLAP and OLTP databases.
Closely work with Business Analysts to get proper functional specs and Requirements.
Convert complex EBCDIC legacy data files to ASCII format by using VEdit.
Installed and administered Microsoft Cluster (Active/Passive) on Microsoft Windows Server 2008 Enterprise Edition.
Migrating Databases from SQL Server 2008R2 to SQL Server 2012.
Performance tuning and optimization of Healthcare Claims Bill Processing databases (both OLTP and OLAP) and servers.
Involved in implementation of Alwayson Availability Group as a High Availability solution on SQL Server 2012.
Rebuilding / monitoring the indexes at regular intervals for better performance.
Closely work with development and testing team and implement changes to database objects in non-production environment
Writing Stored Procedures to support Adjudication of claims and check eligibility of claimants.
Worked with system engineer, Project manager and Application developers to identify and design the database (ER Diagrams, tables, indexes, partitioning etc.), database security, user management, capacity planning and consolidation of servers
Development of ETL processes in SSIS for SQL 2008 r2 Data Warehouse load using SQL 2008 CDC and other techniques.
Development and implementation of baseline ETL process to be used for complete legacy data migration to new SOR database.
Assist developers in streamlining processes using various methods including stored procedures and SQL Merge with XML feeds resulting in processing time of claims to < 1.00% of original processing time.
Experience configuring and working Microsoft SQL Server 2008 on VMware Environment.
Automation of SQL Server Administration Tasks with PowerShell
Document, apply and enforce guidelines for SQL database design, security, performance, version control and best practice compliance.
Worked with PowerShell for performance enhancement and security audits
As lead DBA reviewing code written by other DBAs and Developers.
Actively work with other discipline leads reviewing functional specs and developing design specs with a database and data team LOE perspective
Worked on loading data into Treatment Suites database (DB2)
Worked on creating Objects in DB2
Worked on database backups and restore in DB2.
Environment: SQL Server 2008 R2/2012, SSIS, VMWare, PowerShell, Linux, DB2 9.7, Windows 2008, VEdit, Erwin 8, JAVA, Actuate BIRT, ActiveVOS, .Net, TortoiseSVN.
Capital One, Richmond, VA Nov’08 – May’ 11
As DBA Responsibilities Include
Perform day to day Database Maintenance tasks -- Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between non production to Production database Servers
Manage user and data security to allow access to appropriate resources
Troubleshoot database performance issues and tune database objects.
Used HP Service Manager for change control system and used HP Quality Center for Defect Tracking
Development and implementation of full backup and disaster recovery strategy for all SQL servers using a variety of full, differential and transactional backups allowing for point in time recovery. Regularly perform restore of production SQL backups, both local and from offsite tapes, to test servers. This allows the process to be verified and establishes a timeline if a restore is required in the production environment.
Worked closely with Data Stewards and Business Analysts to produce all required documentation.
Involved in physical data modeling for the application and created ER diagram using Erwin.
Involved in Building Data Warehousing using ETL tools and OLAP Cubes using OLAP and Analysis services.
Implemented High Availability & Disaster Recovery techniques Clustering, Database Mirroring, Transactional Replication and Log Shipping.
Experience using PowerShell scripts(Windows and SQL server)
Install and configure Windows and SQL servers for all stages of development life cycle include planning, sizing estimation, etc.
Worked on Disaster Recovery Planning.
Supported various applications including Cots applications.
Establishes and maintains policies, standard operating procedures, and associated documentation for user interaction with the database environment.
Environment: SQL Server 2008 R2, SSIS, SSRS, SSAS, Windows 2003, VMWare, T-SQL, Teradata 12, XML, AbInitio, Linux, Business Objects, .Net
Scott & Stringfellow, Richmond, VA Jun’ 08 – Nov’08
As DBA responsibilities include
Migration of DTS packages to SSIS packages.
Upgrading the SQL Server 7.0/2000 to SQL Server 2005
Creating SQL Server Objects
Backup and recovery of databases
Performance Tuning
Security Management
Environment: SQL Server 2005/2000/7.0, SSIS, DTS, Windows 2003/2000, ActiveX and T-SQL
Capital One, Richmond, VA Jul’ 06 – Feb’ 08
As Lead DBA Responsibilities Include
Supporting Various Applications including COTS applications with SQL Server 2000 & 2005 Servers across organization.
Worked on Installation, Configuration and Performance tuning of Paragon BCM Application.
Security Maintenance by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
Forecasting system growth and planning resources to accommodate future needs as part of Space Management.
Developing and maintaining processes for development and deployment of all databases.
Maintenance planning for production as well as non-production (QA and Development) Environments.
Used Worked closely with Application Developers and Business Analysts to produce all required documentation.
Design and Creating DTS Packages to load and process data from flat files and Other RDBMS databases to SQL Server.
Configured and Maintained SQL Server Cluster as required by Client specifications
Used HP Openview Service Desk for Change Control System for Problem resolution
Worked on Performance tuning and Query Optimization
Assisting developers in tuning, debugging stored procedures and SQL Statements.
Worked to establish connectivity between VB applications and MS SQL Server by using ODBC.
24 X 7 support to production databases in data warehouse environment.
Design and Creating DTS Packages to load and process data from flat files and Other RDBMS databases to SQL Server
Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
Managed a team of 3 DBAs.
Environment: SQL Server 2005/2000/7.0, SSIS, DTS, IIS 6.0, XML, HP Openview Service Desk, Windows 2003 and T-SQL, VB
Fannie Mae, Washington DC Aug’05 – Jul’06
As Data Analyst Responsibilities Include
Performance Tuning and Optimization
Writing the Stored Procedures and Triggers
Analyzing the data and resolve the issues
Import/Export huge data files into tables.
Environment: ASE 12.5, SQL Server 2000, Ab-Initio, T-SQL, Win 2003 and UNIX
Capital One, Richmond, VA Jun’04 – Jul’05
As DBA Responsibilities Include
24 X 7 support to production databases in OLTP and data warehouse environment.
Design and Creating DTS Packages to load and process data from flat files and Other RDBMS databases to SQL Server
Configured Replication and Database mirroring.
Worked on Performance tuning and Query Optimization
Assisting developers in tuning, debugging stored procedures and SQL Statements.
Worked on Backup and Recovery of database
Security Management.
Coordinating with Micro Strategy users to improve Reporting performance.
Environment: SQL Server 7.0/2000, Oracle, Micro Strategy 7.2 and T-SQL
First Horizon Pharmaceuticals, Alpharetta, GA Mar’04 – May’04
As DBA Responsibilities Include
Query Optimization and performance tuning with Query Analyzer and SQL Profiler.
Writing the Stored Procedures and Triggers
Backup/Recovery of Databases
Import/Export flat file data using DTS, BULK Insert, and bcp.
Providing support to front-end development team in day to day activities and developments
Troubleshoot application issues affecting production and ensure database connectivity.
Maintain Production, development and testing database environments used by software programmers.
Environment: SQL Server 2000, Sales Force Automation Application, T-SQL, JavaScript
Educational Qualifications:
M.S, Industrial Management, P.S.G College of Technology, TN, India.
B.Tech Mechanical Engineering, Nagarjuna University, AP, India
Contact this candidate