Data Manager

VENKATA B SANGUBHOTLA

Objective

Manage, maintain and motivate team to support high performance databases and applications.

SUMMARY

Innovative and skill full manager with more than 20 years of IT experience combined in multiple service sectors in leading and delivering high quality technology solutions on-time and on-budget.

I have the proven ability to provide senior leadership in establishing IT Strategy goals and priorities for small and large companies. Key strengths include communicating corporate vision and creating a culture and work ethic that will maximize efficiency and team performance in the organization.

I have led and planned multiple IT Infrastructure, software related product deployments delivering high quality technology solutions on-time and on-budget.

Responsible for a team of 20 members that include Managers, Project Managers, Technical Managers and Application\Database administrators.

Developed team of SQLDBAs and Application support administrators from ground up in multiple locations worldwide.

Lead GDPR, PCI Tokenization projects.

Responsible for all Online, Business Intelligence \ OLAP and Reporting databases worldwide with servers located in different datacenters and in cloud. Managed multiple projects of Data warehouse \ Business Intelligence and Reporting environments from conception to implementation and support.

Responsible in understanding different SOX \ PCI Audit requests and providing system artifacts as required. Designing solutions and managing Data Security Encryption\ Tokenization\ Data Masking and Disaster Recovery procedures for all SQL Server databases worldwide.

Successfully managed multiple concurrent projects, while coordinating countless production support changes, enterprise wide upgrades, including operating systems and SQL Server and vendor application upgrades.

Responsible in creating multiple near real time Intelligence workflows using oracle, SQL Server Replication, ODI, Golden Gate, Informatica ETL tools that links to multiple BI systems and Reporting environments.

Responsible for initiating the cloud migration of SQL Servers Strategic initiative to Microsoft Azure platform.

Implemented multiple POCs on AWS and Azure cloud platform applications

Responsible in coordinating with multiple vendor applications to integrate with existing applications based on business requirements.

Experience in moving applications to different cloud environments.

Responsible in budgeting, procuring licenses, true ups and auditing all SQL Servers and third party tools.

Responsible for the consolidation of multiple in house and vendor applications and database servers to VM clusters

Responsible in mentoring Managers and technical managers to lead their teams.

Excellent organizational skills with proven abilities in team management.

Responsible in managing 24 x7 production support teams.

Experience in managing SharePoint, BizTalk, Team Foundation Services and Analysis services databases

Experience in designing High availability SQL Server databases on Microsoft Clusters and HP Polyserve Clusters.

Experience working with Oracle Databases, Oracle Applications E-Business Suite.

Experience working in Agile DevOps fast paced environment.

Experience in working with SNOW Ticketing system, SPLUNK monitoring and automation along with Microsoft System Center

Professional Certifications

Microsoft Certified Technology Specialist – SQL Server 2005, 2008 (MCTS)

Microsoft Certified Database Administrator (MCDBA)

Education:

Bachelor’s Degree in Computer Science, from Nagarjuna University India. April -1996

A’ Level (Advanced Diploma in Software Technology and Systems Management) from DOEACC, Year 1997

(Ministry of Communications & information Technology, Govt. of India)

Herbalife, Torrance, CA (www.herbalife.com) April 05 to September 2018

Manager SQLDBAs

Herbalife International is the premier wellness company dedicated to simplifying your path to healthy living.

Headquartered in Los Angeles, California, today's Herbalife has truly achieved a global reach. With more than one million Distributors serving customers in 80 countries, Herbalife's commitment to quality has succeeded in putting a lifetime of well-being within reach for people around the world.

Responsibilities

Responsible for managing 15 member team across different timezones.

Setting and implementing the MBO goals for the direct reports and cascading the goals to team members. Coordinating with team members on change requests and delegating it to team members.

Responsible for multiple multimillion dollar projects that are created from ground up, along with integrating multiple third party applications with existing systems.

Working with stakeholders to determine their vision and gathering requirements from the users/sponsors and implementing that vision.

Recommending and evaluating the cost/benefits of various solutions using different technologies. For example, hardware versus software versus manual, and assure that the system as a whole performs according to the user's expectations.

Point of contact for all Installations, Patches, deployments, tuning, refreshing databases for SQL Server, SharePoint, Scheduling and third party applications and monitoring tools.

Responsible for procuring licenses for SQL Servers, monitoring tools, enterprise agent tools. Responsible for yearly budgets for the teams and budgets for growth and capacity planning and Trueups.

Managed multiple product deployments and strategic initiatives by delivering high quality technology solutions on-time and on-budget.

Managed multiple teams around the world.

Manage the Systems with 99.99% uptime and the team with 24x7 support schedule to cover different country application databases and enterprise application databases.

Manage and Lead SQL Server Migration projects, upgrading the instances to Azure, 2016, 2014, 2012, 2008.

Manage the SQL Instances in HA solutions like MS Cluster and Polyserve Clusters.

Manage the team to proactively automate, monitor and resolve issues.

Trained employees and liaised with other departments to improve process flows.

Extremely hands on in all aspects of database administration

Review and approve all system charts and programs prior and after their implementation.

Recommending management team on improvising process flow, usage of technology and setting standards by evaluating business requirements and needs.

Audit Standards document and making the teams to follow the standards and procedures.

Planning for different environment refreshes that align with Development and QA team goals.

Involved in analyzing multiple vendor applications

Leading the team and coordinating with multiple application and functional teams for Maintenance activities, Creating and Approving change management requests, implementing and verifying the change requests.

Good Team Player and a good team builder.

Member of Architecture Review, Project requests initiation board (RAP and PAR) along with monthly project status reviewer for all approved enterprise applications and country specific applications.

Environment: SQL Server 2012\2008\2005\2000, Oracle, HP3000 AS400, Windows 2008 R2,2003, 2000, XP, OLAP, ASP.NET, VISUAL STUDIO, SharePoint, VMVare, MS Office applications like Excel, Word, PowerPoint, Visio, and MS Project. Quest Monitoring tools like Spotlight, Performance Analysis and Lite Speed. Red Gate tools like Schema and Data Compare. Reporting tools like Crystal Reports, MicroStrategy and SQL Server Reporting Services. Data Extraction and Transformations tools like ODI, Golden Gate, DTS\ SSIS and INFORMATICA. Workflow tools like ODI, SOA BPEL and BIZTALK for moving data, based on business process workflow. Ticketing and Monitoring cloud applications like SPLUNK for enterprise systems monitoring and automation, SNOW for ticketing and change request \approvals and project flows. Hyperion and Onestream financial tools. ADP cloud for HR applications

KB Home, Pomona, CA (www.KBHome.com) July 04 to April 05

Senior Database Administrator

KB Home is one of the leading Home building company, builds houses and apartments in all the major cities of US and France. It also helps customers in getting loans thru their mortgage business. KB Home Studio helps the customers to analyze, estimate, look and feel the options they choose, whether it’s for flooring, cabinets or any appliances which helps in creating a personalized homes.

Responsibilities

Used Data Transformation Services (DTS) and Distributed Management Objects (DMO) for downloading data from AS400 and local SQL Server databases

Scripting and checking the objects into VSS.

Usage of Triggers, Stored Procedures and Functions.

Uploading the Data Changes and application to the Production and Staging environments.

Creating Development environments, backup and recover databases/ transfer of individual data entities based on requirements

supporting team members for designing and developing applications

Environment: SQL Server 2000, AS400, Windows 2003, 2000, XP, OLAP, ASP.NET VB.NET, Excel, Word, and MS Project.

J.D.Power and Associates, WestLake Village, CA (www.jdpower.com) April 04 to July 04

Senior Database Administrator

J.D.Power and Associates conducts quality and customer satisfaction research across a variety of industries including automotive, commercial vehicles, telecommunications, travel, real estate, finance, marine, healthcare, utilities, sports, retailing, office products, and professional services.

Responsibilities

Automating the process flow for different surveys data by writing DTS packages and stored procedures.

Writing ActiveX scripts using VBScript, SQL DMO, ADO and DTS object libraries

Using encrypting software to encrypt and decrypt data for tables.

Usage of Triggers, Stored Procedures and Functions.

Testing the data with the Marginal provided by the Research team.

Uploading the Data Changes to the Production and Staging environments.

Environment: SQL Server 7, 2000, Windows 2003, 2000, OLAP, Visual Basic, Excel, Word, Visio and MS Project.

IndyMac Bank, Pasadena, CA (www.indymac.com ) March 03 to April 04

MS SQL Server 2000 Database Administrator

IndyMac Bank, a leading technology-based mortgage lender with its award-winning e-MITS® platform, that facilitates automated underwriting, risk-based pricing and rate lock of home loans on a nationwide basis via the Internet. IndyMac provides mortgage products and services through its business relationship division, IndyMac Mortgage Bank, and its consumer direct division, IndyMac Consumer Bank.

Responsibilities include creation of users, application development and maintaining the databases.

Involved in SQL Server 2000 migration module. [ Migration from SQL Server 7.0 to SQL Server 2000]

Archiving data from huge databases based on the business requirements from data gathering phase to QA and implementation.

Automate the scripting of all the database objects using SQL DMO for all the database server databases for Release team to keep track of the production changes.

Used Data Transformation Services (DTS) and Distributed Management Objects (DMO) for the archiving and scripting of objects and checking the objects into VSS.

Tuning stored procedures as a member of SWAT team for Code Review process.

Analyzed and implemented the password changes for SQL Server and NT domain login accounts,

Managing Replication databases fixing the errors when they arise

Generating SQL2K migration scripts and remediating the stored procedures from SQL 7, to be compatible with SQL 2K.

Involved in designing and implementing data scrambling functionality in Development and QA environments.

Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.

Server & Application fine-tuning & trouble shooting. Monitoring MS SQL Server performance and network issues.

Administering the MS SQL Server 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.

Helping QA personals in deploying and testing the application, which uses SQL Server as a database.

Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them when ever necessary.

Managing the SQL Servers in Clustered Environment.

Environment: SQL Server 7, 2000, Windows 2003, 2000, OLAP, Visual Basic, Excel, Word, Visio and MS Project, Oracle, AS 400, UNIX, PeopleSoft.

Verizon.com, Irvine, TX (www.verizon.com) July 2002 to Feb 2003

Senior Database Administrator

VERIZON.COM provides online services for wireline and wireless communications in the United States

Responsibilities include creation of users, application development and maintaining the databases.

I was involved in implementing East and West packages - New Connect, Add Line applications. Variations lead order and wireless equipment applications, database partitioning

Generating Script files of the databases when ever changes are made to stored procedures or views or any other database objects and checking the objects in VSS.

Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication, writing scripts for automation, for creating pulications, articles and running the snapshot agent job, so that the same scripts can be used from systemtest to production.

Managing the use of disk space, memory and connections.

Installing SQL Server service packs based on the errors and flaws that are found in the application

Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.

Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.

Server & Application fine-tuning & trouble shooting. Monitoring MS SQL Server performance and network issues.

Administering the MS SQL Server 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.

Helping QA personals in deploying and testing the application, which uses SQL Server as a database.

Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them when ever necessary.

Managing the SQL Servers in Clustered Environment.

Environment: SQL Server 2000, Windows 2000, Visual Basic, Excel, Word, Oracle, AS 400, UNIX.

ATESTO Technologies, CA (www.atesto.com) Oct' 2000 to July2002

Senior Database Administrator

Atesto provides an array of integrated, Web-native solutions for testing and performance management through the Web application development, deployment, and maintenance life cycle. This provides tools for application testing and performance testing, which includes Load Modeler and Functional Checker in application testing tools and Response watch and Resource watch in Performance testing tools. Load Modeler provides real-world performance testing, scalability assessment, and capacity planning for Web applications inside and outside the firewall. Response Watch measures application performance from the customer perspective through virtual agents in multiple locations around the world. Resource Watch is a 24/7-web infrastructure monitoring solution that tracks server and network health behind the firewall.

As SQL DBA Responsibilities and tasks include:

Software Solutions Integrated Limited July'98 to July’2000

Programmer/Analyst

Genius InfoTech Limited Mar’96 to Aug’98

Programmer/Analyst

Contact this candidate