Manager Database / Operations

Venkateswarlu Vurimi

Legal Status: US Citizen, Availability : Immediate

*********@***.*** 650-***-****

Manager - Database Administrators / Operations:

* Recruited, Managed & mentored teams, onsite & offshore (India, Singapore, Australia, Europe).

* Interacted with software / Hardware vendors related to contracts, support, delivery & installation, explore advanced technology & training opportunities.

* Travelled to customer locations for training end users, manage the contracts, DB setup, upgrades, patching and interact with upper management, mentor the client’s DBA’s .

* Design, Implement short & Long term goals & plans related to fixing issues, requirements, database capacity.

* Responsible for managing DB / data warehouse tools, infrastructure, system availability.

* Prepare, Review work plans for upgrades, patching, migration activities.

* Research & Recommend DB related technologies depending on requirement to achieve SLA agreements, better performance.

* In-Person or written communications with stakeholders, upper management, decision makers.

* Quick adaptability to a changing environment and effectively prioritize multiple work streams.

* Meet aggressive deadlines and juggle multiple, changing priorities.

* Made technical recommendations to senior management.

Project Management Executive / Technology Consultant:

* Progressive experience information Technology (IT) Project Management, creating and managing Project Management plans and budgeting, Staff supervision and motivation,Vendor/Contract Management.

* Problem solver - Accomplish complex tasks, recognize alternatives and maximize the use of resources.

* Project management expertise – milestone tracking, senior management and stakeholder reporting, and project budget tracking and reporting.

* Consistently provide exceptional customer service within project constraints - Proven ability to manage expectations and the total ‘change management’ process

* Effective communicator - Excellent listener, writer, observer, analyst and presenter

* Data gathering and recording/documentation for current client business continuity capabilities

* Managed Third Party Hosted applications and services, Data Center, Change Management, Systems architecture.

* Created and implemented change management strategies.

* Ensured each project met required action steps, stakeholder reviews and documentation.

* Defined milestones and delivery plans, identified and managed open risks, issues and blockers.

* Architected and implemented the Disaster Recovery process for Business Critical Systems.

* Collaborated with SAN team and developed several procedures for data migration and technology upgrades using the EMC software suit

* Migrated the Oracle11g RAC db’s from Linux to AIX on EMC’s VNX storage.

* Migrated Hosted customer Oracle DB’s (9i /10g) from Solaris to Redhat Linux on NetApp’s FAS storage.

Lead Database Administrator Consultant:

* Expertise with Oracle [7.3 – 11g], Oracle e-business suit [11.5.3 – 11.5.7] and Oracle Xchange.

* Worked in various domains like Banking, consulting, Health care, Government sector, startups, and product based companies, Oracle & Yahoo.

* Direct involvement with customers across the globe, Australia, Europe, Latin America, India, Singapore.

* Worked closely with cross functional teams including development, product support, QA, Service Delivery Managers, Project managers, System admins, Network admins.

* Expertise with database administration tasks like DB Installation, Administration, Monitoring, Performance Tuning, Database Backup and Recovery, creating users, security, DB objects, db links/table partitions, Transportable tablespace, RMAN, ASM, data pump, AWR, ADDM, ASH.

* Expertise with Change/Problem/Incident management system and the related tools, Remedy, Incident Tracking Service Management (ITSM), Service Now (SNOW),Git

* Installed, trained & used DB access tools like, OEM, SQL Developer, Toad.

* Worked with DB replication technologies, Oracle Advanced Replication, Standby DB, Materialized Views, Oracle Streams.

* Good Understanding of NoSQL, BigData, Cloud (AWS) architecture and features.

* Expertise with various tools like Bugzilla, Jira, Cloud Berry, Files Online, SharePoint, Subversion, Git.

Professional Experience:

Actium Consulting, Sacramento, California. May’ 14 – Till date

Role : Technical Project Manager - Database Operations

Environment : Oracle11g (11.2.0.3 / 11.2.0.4) on Exadata servers X2-8 & X3-8, Exalogic & Oracle Data Appliance (ODA).

* Recruited contractors for onsite and off shore (India).

* Lead the DBA team at CalHEERS to deliver a technically complex 13 prod and 36 non-prod database environments on Exadata/ ODA/ Linux servers

* Managed following projects with time bound:

* Migration of Exadata X2-8 to X3-8

* Driven the team for the DB upgrade of 11.2.0.3 to 11.2.0.4 on Exadata/ODA servers

* Designed/implemented the Fine Grain Auditing archiving

* Worked on Advanced compression of Oracle11g on Exadata servers

* Extensive research on LOB management and compression of LOB using Advanced compression

* Released around 100TB of disk space using advanced compression on Exadata servers.

* Coordinate & schedule deployments, Migration DBA on-call schedule with onsite & offshore DBA’s.

* Involved in the critical decision making meetings with the client, State of California.

* Implemented partitioning at table/LOB level for high volume tables.

* Used Transportable Tablespace for archiving the 10-25TB table’s data from Production.

Aeris Communications, Santa Clara, California. Mar’ 13 – Mar’ 14

Role: Manager - DBA / Operations

Environment: Oracle9i/10g/11g Enterprise on Solaris 5.10

* Created 11g Standard & Enterprise editions DB’s on Amazon Web services, linux instances.

* Supporting production & non-production with 24*7.

* Designed & implemented Oracle Advanced replication, Physical standby.

* Deployments, Backups, Data Management, Archiving data, Performance Tuning

* Table Partition, Partition Exchange, Monitoring, & Troubleshooting.

* Formed / Managed offshore team @ Tech-Mahindra, Pune, India.

* Meeting / Co-ordination with Engineering, upper management, offshore DBA’s & NOC support.

* Implemented the DB securities at Schema, Role, Profile levels.

* Structured & scheduled the deployments – Implemented Change Management.

* Moved the DB’s from Enterprise Edition to Standard Edition on AWS.

* Moved the DB’s from Advanced Replication Technology to Standby setup.

Kaiser Permanente, Pleasanton, California. Jan’ 11- Dec’ 12

Role: Interim Manager Oracle DBA / Operations

Environment: Oracle10g/11g on AIX 6.x

* Supported production & non-production environments, database backup/recovery, refreshes, cloning, DB upgrades, performance tuning w.r.t to SQL and the Instance, troubleshooting & day to day support on Oracle databases in production and development life cycle.

* Refreshed DB using Flashback & datapump.

* Migrated LOB’s to secure files with compression.

* Upgraded from 10.2.0.4 to 11.2.0.2

* Did the setup & Supported Golden Gate for 10g /11g DB’s, with consolidated topology, from each pharmacy store DB to Dataware house DB.

* Performance Tuning & Monitoring of the DB, SQL Queries, Space Management and I/O Optimization, using AWR & ADDM.

* Hired, Managed DBA contractors

* Supported the following application db’s related to Kaiser Pharmacies(OPPR):

Enterprise Pharmacy System (EPS), Advanced Registration services(ARS), Point of Sales(POS), Manufacturing Document Services(MDS), First Data Bank (FDB), Enterprise Control Center (ECC), Enterprise Service Business (ESB),Pharmacy Information Management System (PIMS), Store Based Mail Order (SBMO), Enterprise Patient Record / Enterprise Health Record (EPR/EHR).

Computer Associates, Redwood City, California. Sep’10 – Nov’ 10

Role : Project Manager - DataCenter migration

Environnent : Oracle10g /11g on Linux

* Short term project for moving On Demand hosted databases to new data center.

* Responsible to coordinate, implement, and manage the On Demand hosted Customer’s databases.

* Implemented consistent standards across systems, upgrades in the process of move.

iTrade network, Pleasanton, California. Aug’ 08 – Aug’ 10

Instill Corp, San Mateo, California. (Bought by iTrade Networks) Feb’ 08 – Apr’ 08

Role: Manager DBA / Operations

Environment: Oracle 9i/10g on Linux

* Migrated RAC DB from 9i to 10.2.0.4.

* Shrunken the 6 node to 3 nodes RAC for both 9i & 10g.

* Upgraded 10.2.0.2/3 to 10.2.0.4, 9.2.0.7 to 9.2.0.8 for RAC & Standalone.

* Migration of 32-bit Oracle 10g/9i to 64-bit.

* Datacenter move.

* Analyzed, designed and proposed solutions to application teams on performance issues

* Performance tuning of SQL & PL/SQL with the recommendation of Bind Variables, Hints, Stored Outlines.

* Recruited, mentored & formed the DBA team of 6, onsite & offshore.

Yahoo Inc., Sunnyvale, California. Apr’ 08 – Aug’ 08

Role: Sr. Oracle DBA

Environment: Oracle10g, 9i on Linux

* RAC, Standby DB, RMAN.

MobiTV, Emeryville, California Feb’ 07 - Dec’ 07

Role: Sr. Oracle DBA

Environment: Oracle10g on Linux

* Supported OLTP and Data warehouse databases.

* Provided 24*7 on call support

* Installed & configured connection manager.

* Installed 10gR2, 64 bit Oracle & migrated database from 10gR1, 32 bit.

* Implemented Materialized views to refresh the data from the OLTP to Dataware house instance.

* Standby setup

* RMAN setup

* Performance Tuning & Monitoring of the DB, SQL Queries, Space Management and I/O Optimization.

* Managed offshore DBA team.

Administrative Office of Courts, San Francisco, California Oct’ 06 – Feb’ 07

Role: DBA Consultant

Environment: Oracle8i/9i/10g on Solaris (v5.6 – v5.9)

* Cloned the databases for the Oracle ERP and PeopleSoft applications.

* Patched & upgraded the database.

* Worked with Oracle replication issues and Oracle streams.

* Implemented Security to the database.

Kaiser Permanente, Pleasanton, California. Aug’ 06 – Oct’ 06

Role: DBA Consultant.

Environment: Oracle8i on AIX

* Cloned the databases and the applications.

* Replicated the databases using materialized views.

* Performed logical Backups & Restores.

* Documentation of the operations.

Oracle Corp, Redwood shores, California. Mar’ 01 – Jul’ 06

Role: Sr. Oracle DBA / APPS-DBA

Environment: Oracle applications on Solaris / Linux for hosted customers.

* Supported the Oracle products (ERP, Data warehouse, Oracle Exchange, Oracle Portal, IAS and DB) for On Demand hosted customers.

* New instances creation using certified configuration for hosted customers.

* Involved in various versions of 11i upgrades of Oracle applications (11.5.3 - 11.5.7), Oracle Application Server (9iAS, 10gAS) and RDBMS (8i, 9i, and 10g).

* Expertise with AD utilities like adadmin, adpatch, adctrl, adsplicer

* Involved in the migration project, migrating the instances from Solaris to Linux.

* Involved in the Datacenter move, from Redwood Shores datacenter to Austin Datacenter.

* Involved in the Critical Patch Application.

* Worked with counter parts (Australia, India, Europe) for shift and knowledge transfer.

* Contacted customers for explaining the technical requirement and getting approval for implementing recommended changes.

* Troubleshooted exchange components like Apache, Transaction delivery methods, Workflow mailer and workflow background process, loaders, RDBMS, iAS, eBusiness Suit.

* Familiar with NETAPPS storage concepts/administration.

* Managed & Mentored off shore teams located @ India, Singapore.

Startups.com, Redwood City, California. Feb’00 - Feb' 01

Role: Oracle DBA

Environment: Solaris, Oracle8i, Apache

* Implemented the standby database.

* Implemented the security measures at user level & object level.

* Automated the system availability, reports & backups using cron jobs.

* Enhanced the schema design to maintain the application integrity & consistency.

* Recommended the usage of bind variables, Hints, Stored outlines

Wipro Infotech, Hyderabad, India. Aug’ 99 - Feb’ 00

Role: Sr. Customer support Engineer (Oracle DBA)

Environment: Sco UNIX v5.0, Solaris v2.6, Winix, Windows NT v4.0, RDBMS: Oracle V7.3

* Travelled to the client locations to manage the contracts, trained end-users, patching, upgrade, setups.

* Maintained the backups at the offsite on regular basis.

* Communicated the status of the database growth & performance with their respective regional & head offices.

* Taken care of Y2K compliance of the hardware & software.

* Trained the new hires of Wipro with Oracle DBA concepts.

* Identified and resolved issues related tablespace usage, disk contention, performance related to archiving.

The Vysya Bank Ltd., Bangalore, India. Feb’ 95 - Aug’ 99

Role: Systems Manager (Oracle Database & Banking Applications Administrator)

Environment: Sco UNIX v5.0, Oracle v7.3, Forms v3.0, Reports v2.3

* Implemented the Tata Consultancy Services Banking product, Integrated Standard Banking System(ISBS) for the branches, go-live with computerization from Manual system.

* Automated the backups, upload of data from all the branches to head office on daily basis.

* Customized & automated the generation of reports based upon the branch requirements

* Implemented the downloading of data from Cash Management system to ISBS using SQL*Loader.

* Migrated database to new hardware, higher version of O/S, RDBMS.

* Maintained an appropriate audit trail for database changes.

* Maintain the inventory of the hardware, software & storage across the branches of divisions.

* Involved in the Reserve bank of India meetings for the security implementation.

* Interact with upper management with the recommendation of the technology based on vendor’s requirement(TCS).

Education:

Bachelor of Engineering in Computer Science

University Of Mysore, Mysore, India.

Certifications:

* Oracle8i Certified Professional Database Administrator.

* ITSM Certified, IT Service Management Foundation (ITIL).

Awards:

* Cash reward from Oracle Corporation for being best team player

Contact this candidate