Summary
Overview
Work History
Education
Skills
Timeline
Generic

Venkateswararao Muvva

Auckland,AUK

Summary

Talented and self-motivated Architect with exceptional organizational skills and a keen eye for detail. Offering 20 years of extensive experience in the IT industry, adept at analyzing problems and developing innovative solutions. A quick learner with strong communication abilities. Well-organized IT professional with a unique technology background, poised to add value to any organization.

Overview

18
18
years of professional experience

Work History

Infrastructure Architect

Enterprise IT /Servian /Cognizant NZ
05.2017 - Current
  • Created detailed technical designs for integrating systems in accordance with enterprise architecture principles.
  • Monitored performance of integration processes and identified opportunities for tuning and optimization.
  • Infrastructure and database designs.
  • Cloud Architecture.
  • Good experience in database design and infrastructure.
  • Cloud Migrations.
  • Planned, implemented, and integrated updated system-oriented projects.
  • Researched, evaluated and recommended appropriate software products to meet integration needs.
  • Database design, capacity planning, and forecast database storage requirements.
  • Responsible for installing, upgrading, patching, and configuring the Oracle environment.
  • Budgeting and capacity planning, as well as systems performance and uptime management.
  • Coordinate and manage reports for internal and external database audits.
  • Designed and implemented a secure network infrastructure architecture to ensure compliance with security protocols.
  • Developed systems diagrams, plans and technical documentation for the implementation of new network infrastructure components.
  • Conducted capacity planning analysis to identify areas for improvement in current network architectures.
  • Developed complex integration solutions based on requirements and architectural standards.
  • Architected cost-effective solutions by leveraging existing resources within an organization's IT environment while meeting their business objectives.
  • Planned, developed, and implemented IT solutions focused on areas.
  • Developed complex infrastructure systems to facilitate businesses achieving targets.
  • Designed and delivered mission-critical infrastructure to maintain consistent availability and performance.
  • Designed and implemented highly available, fault tolerant, secure, cost effective and scalable cloud architectures.
  • Developed cloud-based solutions using AWS, Oracle Cloud Platform technologies.

Database Engineer

Vodafone New Zealand
09.2012 - 04.2017
  • Senior Oracle DBA/ Hands-on DBA for Oracle BRM, CRM and DW/reporting Systems
  • Database design, Capacity planning and forecast database storage requirements
  • Responsible for installing, upgrading, patching and configuring the Oracle environment
  • Coordination and Manage reports for internal and Externals Database audits
  • Configured high availability solutions using replication technologies like Mirroring.
  • Designed, implemented, and maintained relational databases for data storage and retrieval.
  • Implemented best practices for database architecture design and development processes.
  • Resolved complex technical issues related to database systems performance tuning.
  • Developed scripts to automate routine tasks such as backups, indexing, and query optimization.
  • Performed database security management including user access control and privilege assignment.

Oracle DBA (Team Lead)

IBM New Zealand
11.2011 - 08.2012
  • Administration of Oracle Applications versions 11i
  • Installed, configured and administered Oracle 10g, 11g databases on Linux, Unix platforms.
  • Monitored database performance and tuned SQL statements for optimal performance.
  • Developed backup strategies using RMAN to ensure data protection and recovery.
  • Deployed third party applications with Oracle Databases as a back-end repository system.
  • Generated periodic reports about system performance and resource utilization trends .
  • Involved in capacity planning activities by analyzing current usage patterns and predicting future growth trends .
  • Applied Oracle Applications and database patches
  • Cloned/Refreshed Oracle Databases and Oracle Applications.
  • Responsible for optimizing the queries and application tuning
  • Perform SQL tuning and assist developers with coding PL/SQL
  • Provided support to Application Database Administrators in designing the database
  • Installed and Implemented Backup & Recovery procedures
  • Implement Hot, Cold and Logical backup plans
  • Implement 'Stored Procedures and Triggers' based on business plans using PL/SQL
  • Responsible for setting and managing user accounts, Granting required privileges to users
  • Defining and Implementation of backup and recovery strategies
  • Perform other regular DBA activities including space management and performance monitoring
  • Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN
  • Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
  • Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, and Oracle Standby Servers
  • Implemented physical database design including tablespaces, storage optimization and partitioning.
  • Migrated databases from one platform to another using tools like export and import, datapump.
  • Automated daily DBA tasks using shell scripting and cron jobs.

Oracle DBA (Team Lead)

IBM India
08.2010 - 10.2011
  • Company Overview: Client: Vodafone Australia
  • Provided 24X7 support for all the production and development databases
  • Installed and configured Oracle 10g
  • Performed upgrades from Oracle 9i to 10g
  • Administration of Oracle Applications versions 11i
  • Configured Golden Gate replication as per Project requirements
  • Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries
  • Applied Oracle Applications and database patches
  • Cloned/Refreshed Oracle Databases and Oracle Applications
  • Responsible for optimizing the queries and application tuning
  • Perform SQL tuning and assist developers with coding PL/SQL
  • Provided support to Application Database Administrators in designing the database
  • Installed and Implemented Backup & Recovery procedures
  • Implement Hot, Cold and Logical backup plans
  • Implement 'Stored Procedures and Triggers' based on business plans using PL/SQL
  • Responsible for setting and managing user accounts, Granting required privileges to users
  • Defining and Implementation of backup and recovery strategies
  • Perform other regular DBA activities including space management and performance monitoring
  • Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN
  • Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
  • Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, and Oracle Standby Servers
  • Client: Vodafone Australia
  • Environment: Technologies Used: oracle 11g/Oracle 10g RAC/9i/8i, REDHAT LINUX, ASM,OEM (Grid Control), IBM AIX, RMAN, Explain Plan, Data Pump, EXP/IMP, SQL
  • Loader, AWR, ADDM,Golden Gate

IT Analyst( Oracle DBA)

Tata Consultancy Services
02.2007 - 08.2010
  • Company Overview: Client: Deutsche Bank
  • Data Administration - Implementing the physical database and logical table spaces, managing integrity constraints and stored procedures
  • Problem prevention, detection, and correction
  • Replication of Database
  • Performance Tuning
  • Handling Technical CRs
  • Maintenance of project infrastructure
  • Coordinating throughout SDLC starting from development till production
  • Writing SQL scripts for back out process and shell scripting for process improvement
  • Oracle (9i/10g) database maintenance on Solaris systems
  • SQL code review and recommendation to development team
  • Executing disaster recovery plans
  • Refreshing database for development and testing process
  • Managing tablespaces, database objects, user, profiles, user privileges and roles
  • Working with table and index partitioning
  • Importing/Exporting statistics
  • Monitoring and analyzing slow running queries
  • Performing database refresh (i.e
  • Cloning of databases using RMAN and logical backups)
  • Tuning queries using available tools with oracle.(tkprof, autotrace, explain plan)
  • Day-to-Day problems of databases like locking, space issue, performance problems etc
  • Client: Deutsche Bank
  • Environment: Technologies Used: Oracle 10g /9i/8i, REDHAT LINUX, , IBM AIX, RMAN, Explain Plan, Data Pump, EXP/IMP, SQL
  • Loader, AWR, ADDM,IBM Optim Archive tool

Oracle DBA

Datcore Technologies Pvt Ltd
07.2006 - 01.2007
  • Company Overview: Client: Tata Consultancy Services
  • Data Administration - Implementing the physical database and logical table spaces, managing integrity constraints and stored procedures
  • Problem prevention, detection, and correction
  • Replication of Database
  • Performance Tuning
  • Handling Technical CRs
  • Maintenance of project infrastructure
  • Coordinating throughout SDLC starting from development till production
  • Writing SQL scripts for back out process and shell scripting for process improvement
  • Oracle (9i/10g) database maintenance on Solaris systems
  • SQL code review and recommendation to development team
  • Executing disaster recovery plans
  • Refreshing database for development and testing process
  • Managing tablespaces, database objects, user, profiles, user privileges and roles
  • Working with table and index partitioning
  • Importing/Exporting statistics
  • Monitoring and analyzing slow running queries
  • Performing database refresh (i.e
  • Cloning of databases using RMAN and logical backups)
  • Tuning queries using available tools with oracle.(tkprof, autotrace, explain plan)
  • Day-to-Day problems of databases like locking, space issue, performance problems etc
  • Client: Tata Consultancy Services
  • Environment: Technologies Used: Oracle 10g /9i/8i, REDHAT LINUX, , IBM AIX, RMAN, Explain Plan, Data Pump, EXP/IMP, SQL
  • Loader, AWR, ADDM

Education

Bachelor of Technology - Computer Science & Technology

Biju Patnaik Technological University
India
08-2004

Skills

  • Virtualization Technologies
  • Virtualization coordination
  • Disaster Recovery Planning
  • Performance Optimization
  • API management
  • Database Administration
  • Cloud services integration
  • Technical architecture
  • Network Architecture
  • Integration planning
  • Data migrations
  • Capacity Planning
  • DevOps principles
  • Performance Tuning
  • RESTful APIs
  • Data Warehousing
  • Solution Implementation
  • Cloud Architecture Design
  • Security compliance
  • Backup and recovery
  • Migration strategies
  • Database performance
  • Systems design analysis
  • Systems design
  • Client Engagement

Timeline

Infrastructure Architect

Enterprise IT /Servian /Cognizant NZ
05.2017 - Current

Database Engineer

Vodafone New Zealand
09.2012 - 04.2017

Oracle DBA (Team Lead)

IBM New Zealand
11.2011 - 08.2012

Oracle DBA (Team Lead)

IBM India
08.2010 - 10.2011

IT Analyst( Oracle DBA)

Tata Consultancy Services
02.2007 - 08.2010

Oracle DBA

Datcore Technologies Pvt Ltd
07.2006 - 01.2007

Bachelor of Technology - Computer Science & Technology

Biju Patnaik Technological University
Venkateswararao Muvva