Ganesh Pittala

SQL Server DBA Email: ac7yb4@r.postjobfree.com

: 925-***-**** Work: 925-***-****

PROFESSIONAL SUMMARY

Over 12 Years of Experience in Database Administration, system analyst, Design and Development and support of MS SQL Server 2017 /2016 /2014/ 12012 /2008 /2005/7/6.5 in Production, Test, Development, Cluster and Replication environments.

Experience in Always on Availability Groups, Mirroring, Replication and Log Shipping. High Availability /Disaster Recovery (HADR) Solutions, Failover Cluster

Experience in Upgrade of MS SQL server 2008 R2 to SQL Server 20012 from SQL Server 20012 to SQL Server 2014 to SQL Server 2017 with partially contained databases.

Experienced in Microsoft Azure Cloud database management systems, Designing, Client/Server Application and Implementation, performance tuning using Microsoft technologies

Experience on Microsoft Data Migration Assistance and Azure Storage Explorer

Expertise in Performance Tuning Database Administration on Production Server Configuration, and Maintenance with outstanding troubleshooting capabilities

Experience in on prime Migration of SQL Server database to Microsoft Azure cloud database management.

Experienced in Backup and Recovery point in time, Query optimization and security.

Experienced monitoring the health and performance of SQL Servers as well as home grown application using SQL server Native tools and several other third-party solutions.

Expert in Automating in T-SQL, Stored procedures, Indexes, Table, views, AOG, Mirroring.

Experienced in PowerShell scripting technologies and SQL R services.

Expect in creating DTS packages and SSIS ETL packages, functionalities and DB dependency resolution.

Power BI Gateway administration and troubleshoot security issues on Cloud.

Created various SSIS, SSRS and SSAS packages to serve company application requirements.

Expert in using DTA/extended events/Perfmon/SQL profiler/Trace/Scripts and other third-party tools to resolve server performance bottlenecks, dead locks and slow running queries.

Responsible for securing SQL Server, user management, assigning permissions and roles.

Experienced DDBoost and LiteSPeed, Idera, Red gate, Splunk Log explorer for MS SQL Server.

Strong knowledge in System Administration background in Windows, Azure Cloud and Linux environment.

Experienced with Development/Test/Stage/Production QA which included documentation of process, creation of test scenario and execution of tests via T-SQL scripts, to ensure UI Standards met the standard requirements.

Created SOP Technical documentation and process archiving and Change and Incident Management

Experienced in working independently as well as in team-oriented environments and problem solving, Analysis and conflict resolution. Excellent analytical, communication and interpersonal skills.

Experience in supporting and maintaining large databases and troubleshooting critical issues.

Experience in Software development life cycle (SDLC) of enterprise scale data warehouse.

Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent

Worked on administration tasks such as data loading, Windows Batch jobs, data unloading, Backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.

Knowledge on ETL Tools and RDBMS Oracle and Sybase database.

Experience in SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE and DB2

Microsoft® Database Experimentation Assistant (DEA) Testing solution for SQL Server upgrades SQL 2005

Excellent technical, communication and interpersonal skills with very good troubleshooting and problem-solving skills. Ability to work on multiple tasks in a fast-paced environment independently and in a team.

Experience in SharePoint Database and site migrations to cloud.

TECHNICAL SKILLS

RDBMS

MS SQL Server 2017/20162012/2008 R2/2008/2005/ 2000/7.0/6.5, Oracle 10g/9.x/8i, Sybase, MS Access 2010

Tools

SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Profiler, MS Visio 2003/2007, SQL Loader, Toad, ITSM, Remedy, Tivoli Storage Media IBM, SQL litespeed 4.6, Grid App Tool,WebTop,DataStage7.5.1,Datastage7.5.3,DataStage8.1,Cognos8,Trillium,ArcGIS,SDE,PetroWeb,Zenator,vCentre,HP-SIM,,Smart Signal, Enerdeq Desktop, Hobbit, Team Quest, Legato Networker, Autosys, Precise, TSM, Citrix. Enterprise Power BI, DDBoost, ASG Remote Desk, Microsoft Team, Office 365

Operating System

Windows 2008/2007/VM/2003/2000/Vista/XP/NT/98/Me, UNIX, Ms-Dos

Data Modeling

Erwin 3.5.2/4.0, Microsoft Visio

Languages/Utilities

Power Shell, T-SQL, .Net,Unix shell script, PL-SQL, MDX, VB Script, MS Access.

Visual Basic 6.0, C, C++, VC++, C, PL/SQL,

Cloud Tools

Data Migration Assistance, Microsoft Power BI

Web Technologies

HTML, XML, ASP, JSP, JavaScript, PERL,PHP

BI Tools

Microsoft Power BI, SSIS, SSRS, SSAS, Crystal Reporting, Business Objects, Informatics 8.x/7.x.

Domain Knowledge

Oil & Gas Energy utility/Banking and Financial /Hospital information Services

Certification

IT

MCITP, MCDBA, GNIIT

Achievements

Best Delivery Associate of the year 2017 Awards from Tech Mahindra

Bravo Awards from Tech Mahindra, You Rock award for the month of Jan-2015

Pat on the back from Chevron Project-Lynx, 2017

Employee of the month from Mahindra Satyam

Best DBA Award from Merrill Lynch

Star Performer award 2012,2010,2009,2005, 2006 from Satyam AIC Club

Strengths

Onsite and Offshore co-ordination and execution model

Strong in Quality and Six Sigma Process orientation

PROFESSIONAL EXPERIENCE

Client: Chevron, San Ramon, CA Jul’2017 – Till Date

Role: SQL Server Administration (DBA) and Solutions Architect

Description: The Data Management Services & Support (DMSS) team provides data management technology solutions and expertise to enable the business to optimize results using high quality data. Services we provide: Database management services for Microsoft SQL Server and Oracle and both on-premises and in the cloud.

Project Domain

Data Management Services & Support (DMSS)

Sub Domain

Oil &Gas (upstream)

Solution

ITC - Information Technology Company

Client

Chevron

Organization

Tech Mahindra Ltd.

Project Name:

DMSS - Project and Consulting

Role

Solution Architect and DBA

Location

San Ramon

Duration

Jul/17 –Till Date

Team Size

15

Environment

(with skill versions)

Languages:

T-SQL, SQL, PL/SQL, PowerShell

Database:

SQL Server 2017 RTM, 2016, 2014,2012,2008 R2/2008, SQL Server 2005, SP4

Tools:

DDBoost, SQL Litespeed, Citrix, SSC, Net IQ, SCOM, TOAD,ITSM, Remedy, OEM, Arc GIS, Petr Web, SharePoint

O/s :

Windows server 2012,2008,2003, Linux and Solaris

Hardware

HP - GS320, E24, D10, SPARK, Red Hat etc.,

Team Services

•Data management consulting services for business enabling projects

•Data Gateways to connect on-premise data to cloud applications

•Data Migration services to safely and securely migrate data between locations, versions, or technologies.

•IP Compliance for all hosted data, including SOX controls.

•Operational support provided 24/7/365

•Deliver Data Management Services to improve, maintain and protect high quality data assets that can be leveraged to create competitive advantage

•Simplify the technology landscape with fewer, standardized, policy compliant applications, tools and processes

•Aggressively decommission legacy platforms to achieve benefits and reduce costs

Responsibilities:

•Installation and configuration of SQL Server 2017, 2014, 2008 and 2005 with SP and Hot fixes

•Deploying the vendor tools in ETC with controlled security.

•Responsible for IP compliances and guidance to other ETC sites

•Standardizing the ITC process and creating Best practice documents.

•Involved in DBA best practices and SOP (standard operation procedure) documentation

•Going through the clients' requirements and coming up with database design and application architecture.

•Installing, configuring, administering and securing our as well as our clients' production servers.

•Coming up with custom-tailored backup/restore and disaster recovery plans for production servers.

•Troubleshooting performance issues and fine-tuning queries and stored procedures.

•Implementing and administering database replication between SQL Server databases as well as dissimilar databases.

•Writing code and creating jobs to automate repetitive tasks.

•Database maintenance & Availability, Backup/Restore, Job monitoring

•Security, Troubleshooting, Capacity Planning

•Storage Requirements, Identification and recommendations of hardware configurations

•Ensures all database environments (Development, Test, Staging, and Production) are in sync.

•Performs database design/modeling of new applications and database changes to existing applications.

•Develops and maintains documented guidelines for database security and disaster recovery.

•Created and maintained, SOP documented for database standards.

•Obtained IP. Auditing for SOX compliance.

•Reports project/task status and hours worked to the Information Systems Manager via weekly status report.

•Keep informed of advances in databases and database administration and the application of that technology to improve systems.

•Install and configure SQL client using SQL Server 20017/2016/2014/2012 and SQL 2008 R2.

•Created database objects Tables, Views, Synonyms etc.

•Implemented the different types of constraints (Primary key, foreign key, unique key etc) on tables to avoid data discrepancies and enforce the integrity of data.

•Created complex stored procedures, functions using joins for application following SQL standards.

•Extracted the data from different sources such as Excel spreadsheet, flat files, SQL Server, transformed data according to business logic and loaded the data into tables using SSIS packages.

•Created complex customized reports using SSRS.

•Created Parameterized, Cascaded Parameter Reports using SSRS.

•Responsible for deploying reports onto the server.

Environment: MS SQL Server 20017/2016/2014/2012/2008 and SQL 2005, MS SQL Integration Services 2014, SSRS,SSAS, MS Excel, Visual Studio 2010, VSTF 2010.

Client: Chevron, Houston, TX June’2008 – Jul’2017

Role: SQL Server Administration and Primary DBA

Description: Energy Technology Company (ETC) the place for technology solutions and technical expertise for all Chevron operating companies globally. At ETC, my activities include inventing industry leading, proprietary technologies, applying innovative techniques for existing processes and delivering a wide spectrum of technical services and competencies. My efforts are focused on enabling superior performance and growth for our business partners and creating long term, meaningful value and competitive advantage for Chevron shareholders through our technology leadership and partnerships.

Project Domain

Energy and Utility Company

Sub Domain

Oil &Gas (upstream)

Solution

Production Management & ERP Solutions

Client

Chevron

Organization

Satyam Computer Services Limited (Mahindra Satyam)

Project Name:

ETC - TC - Database Support

Role

Primary DBA

Location

Onsite: Houston

Offshore: Hyderabad

Duration

Onsite: Jun/10 –Jul/17

Offshore: Jun/08 –Jul/10

Team Size

Project : 11

Environment

(with skill versions)

Languages:

T-SQL, SQL, PL/SQL

Database :

SQL Server 2012,2008 R2/2008 SP1/RTM/

SQL Server 2005,SP4

Tools :

SQL Litespeed, Citrix, SSC, Net IQ, TOAD,ITSM, Remedy, OEM, Arc GIS, PetroWeb, SharePoint

O/s :

Windows server 2008,2003, Linux and Solaris

Responsibilities:

•Primary DBA for 30+ application

•Installation and configuration of SQL Server 2012, 2008 and 2005 with SP and Hot fixes

•Deploying the vendor tools in ETC with controlled security.

•Responsible for IP compliances and guidance to other ETC sites

•Standardizing the ETC process.

•Involved in DBA best practices and SOP (standard operation procedure) documentation

•Going through the clients' requirements and coming up with database design and application architecture.

•Installing, configuring, administering and securing our as well as our clients' production servers.

•Coming up with custom-tailored backup/restore and disaster recovery plans for production servers.

•Troubleshooting performance issues and fine-tuning queries and stored procedures.

•Implementing and administering database replication between SQL Server databases as well as dissimilar databases.

•Writing code and creating jobs to automate repetitive tasks.

•Database maintenance & Availability, Backup/Restore, Job monitoring

•Security, Troubleshooting, Capacity Planning

•Storage Requirements, Identification and recommendations of hardware configurations

•Ensures all database environments (Development, Test, Staging, and Production) are in sync.

•Performs database design/modeling of new applications and database changes to existing applications.

•Develops and maintains documented guidelines for database security and disaster recovery.

•Created and maintained, SOP documented for database standards.

•Obtained IP. Auditing for SOX compliance.

•Reports project/task status and hours worked to the Information Systems Manager via weekly status report.

•Keep informed of advances in databases and database administration and the application of that technology to improve systems.

•Created complex stored procedures, functions using joins for application following SQL standards.

•Extracted the data from different sources such as Excel spreadsheet, flat files, SQL Server, transformed data according to business logic and loaded the data into tables using SSIS packages.

•Created complex customized reports using SSRS.Created Parameterized, Cascaded Parameter Reports using SSRS.

•Responsible for deploying reports onto the server.

Environment: MS SQL Server 2008 R2, MS SQL Integration Services 2008 R2,SSRS 2008 R2, MS Excel, Visual Studio 2010, VSTF 2010.

Client: Merrill Lynch (Bank of America, New Jersey) May-2005- Jun-2008

Role: SQL DBA/Technical Lead

Description: Merrill Lynch (Bank of America) is a multinational banking and financial services corporation. Bank of America serves clients in more than 150 countries. My project, HSSN is the system used to track all loan modifications, Delinquent loans etc. As a SQL/BI developer, my responsibilities is to write SQL scripts, Creating SSIS packages for ETL purpose and generate the reports to the users.

Project Name:

Merrill Lynch – ODC

Client

Merrill Lynch

Role

Tech Lead - SQL server DBA Onsite and Offshore support

Organization

Mahindra Satyam.

Location

Offshore: Hyderabad

Onsite: New York

Duration

Offshore: Mar/2005 Jun/2008

Onsite: Nov/06-May/07

Team Size

21

Environment

(with skill versions)

Languages:

T-SQL

Database:

SQL Server 2005, SQL 2000,SQL 6.7

Tools:

MS SQL Server 2005,2000, ITSM, Remedy, IBM Tivoli Storage Manager,

Legato Backups, SQL Light, Autosys, Precise, Citrix, SSC, Net IQ, Grid App Solutions

Responsibilities:

•Installation of SQL Servers with new releases and service packs

•Cluster Server Builds,load balancing and adding drive dependencies

•DBA for SQL Server 2005, 6.5, 7.0,2000 in production, integration and development environments.

•Installation of DBA tools TSM, Autosys, Precise, and SQL Litespeed.

•Worked on Legato backups and different types of backups

•Restoration of database’s with the latest backups form tape drives

•Worked on Precise for Server performance history.

•Execution Production releases request, Scheduling the Jobs for stable maintenance.

•Suggested and implemented various new server settings to enable a Stable environment.

•Created different type of linked servers in SQL Server.

•Handled corrupt databases. Diagnosed and repaired the databases.

•Set up security roles, SQL accounts.

•Created maintenance plans for Production, Integration and Development databases.

•Experience on Clustering, DB mirroring, Replication and log shipping.

•Experience on project management for strategic and long range planning.

•Experience on setting up C&R and Standby server.

•Troubleshooting of Server oriented problems

•Created Low-Level Design Document (LLD) and Technical Express Project document (EPD).

•Created database objects Tables, Views, Synonyms etc.

•Implemented the different types of constraints (Primary key, foreign key, unique key etc) on tables to avoid data discrepancies and enforce the integrity of data.

•Created complex stored procedures, functions using joins for application following SQL standards.

•Created stored procedures, SQL Scripts using Dynamic SQL.

•Altered the tables and re-created Indexes and the constraints on table.

•Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases. Implemented exception handling using @@ERROR and TRY/CATCH methods.

•Responsible for Unit Testing, Deploying, Altering and Maintaining the Database Scripts.

•Responsible for transferring huge amount of Data from Excel and flat file to OLTP environment.

•Extracted the data from different sources such as Excel spreadsheet, flat files, SQL Server, I series, transformed data according to business logic and loaded the data into dimension and fact tables using SSIS packages.

•Extracted the data from different sources using OPENQUERY.

•Responsible for the development of ETL Component using SSIS accordingly for Initial and Incremental Load process.

•Implemented the Error Logging, Package configurations and Event Handling in SSIS packages.

•Responsible for Deploying, Alerting and Maintaining SSIS packages.

•Responsible for Scheduling Jobs using SQL Server Agent and Windows scheduled tasks.

•Involved in performance tuning of SQL Scripts, stored procedures and SSIS packages

•Modified existing SSIS packages to meet current business requirements.

•Created some complex Excel reports and XML reports.

•Worked in developing the complex customized reports using SSRS.

•Experience with ADHOC reporting, Parameterized, Cascaded Parameter Reporting using SSRS.

•Responsible for Job monitoring activity.

•Worked with XML.

Environment: MS SQL Server 2008/2005, MS SQL Integration Services 2008/2005,SSRS, MS Excel, Visual Studio 2008/2005,VSS 2005, VSTF 2008, MS Visio 2007, XML.

Client: Apollo Hospitals – Hyderabad Oct 2000 - Feb 2005

Role: Visual Basic Programmer and SQL DBA

Description: Apollo Hospitals-India’s most trusted name in healthcare-Supremacy in healthcare is well acknowledged. The state of the art infrastructure. Medical professional of International repute and adaptation of latest technology place the hospital on the highest pedestal of quality case. 400 bedded hospitals with over 50 super-specialty departments and supported by 54 Integrated HIS Modules.

Project Name:

HIS- Hospital information system

Client

Apollo Hospitals Enterprise Ltd. Hyderabad

Role

Database Designer and Modules coding & implementations

Organization

Apollo Hospitals Hyderabad

Location

Offshore: Hyderabad

Onsite: Nil

Duration

Offshore: Oct/2000 Feb/2005

Onsite: Nil

Team Size

9

Modules: 50

Environment

(with skill versions)

Languages:

Visual Basic 6.0

Database:

Ms-SQL Server 6.5, 7.0, 2000

Tools:

Ms-SQL Server 2000, Citrix

O/s:

Windows server 2003. Windows NT

Responsibilities:

Architected and developed windows based Hospital information system, a fully integrated with all the application modules in PC’s and Mobile Devices Environment in VB.NET.

Involved in the design of security module that gives access to users based on roles and groups.

Extensively used third party controls like Imagistics to display information in both Web and Windows based applications.

Developed and executed PL and SQL procedures, triggers and views to integrate them with windows and web based software applications.

Developed extensive RDBMS table design for many different subsystems and enhancements, ensuring that relationships and keys are established with all the tables in SQL Server 2000 and 2005 and 2008 database. Responsible for developing complex SQL queries and stored procedures.

Backups and Recovery Performance Monitor and Troubleshooting-SQL programming Scripts.

Bugs Fixing in the Database with T -SQL and VB code

Data Migration from Heterogeneous files to SQL Database, Replication between the multiple Servers

Log shipping in remote location. Analysis of the specifications provided by the clients

Design and Development of OLAP Cubes

Recovering the Data when the database in suspect mode

Implementation of HIS software at various centers (Chennai, Delhi).

Designing Database (Tables, Views, Procedures, and Triggers).

Providing MIS reports to the Top Management (Comparison reports on Daily, Monthly, Quarterly and Yearly)

Creating User Id’s Logins and Job Schedule, Creating Indexes periodically and Running the DBCC Commands

SMS Module Development & implementation

Interaction with end users and all levels of IT staff providing SQL related support

User co-ordination for HIS Implementation.

Education: Master of Science(M.sc) and Bachelor of Science (B.sc)

Osmania University

Contact this candidate