Manager Security

adkr8w@r.postjobfree.com

Cell # 617-***-****

Venu Rama

SUMMARY:

Strengths:

Proven ability to lead and coordinate project team resources

Exceptionally good communication and technical skills to implement business and management solutions

Extensive experience in Client/Server Environment

SKILLS:

DBMS: Oracle 9i/10g/11g/12c, MS SQL Server 2012/2016, MySQL5.0

Operating System: Linux, Windows 2008/2012/2016, Sun Solaris 10/5.9, VMS

Hardware: Sun Enterprise 5, 20, ULTRA, E4500, 3800, HP-9000, Sun4u Sparc, SUNW, Sun-Fire-440, DEC ALPHA

Tools: OEM Grid 13c, Toad, GIT, SQL Developer, Nagios, Splunk

Software: SQL*LOADER, SQL*NET, Outlook, MS Office, MS Project

Languages: SQL, PL/SQL, Perl, Python

PROFESSIONAL EXPERIENCE:

STATESTREET, BOSTON MA

Database Administrator – Contractor Mar 2020 – Current

Working with Life Cycle DBA Team in Certification and Building New Oracle 19c/12c Databases. Implementation of security requirement using sec_menu

Upgrade existing Databases to latest 19c/12c oracle Databases, certification including implementation of security requirement using sec_menu

Migration of existing Databases to latest 19c oracle Databases, certification and implementation of security requirement using sec_menu

JHONHANCOCK, BOSTON MA

Database Administrator – Contractor Aug 2019 – Mar 2020

Project Mangement and co-ordination with various Technology and Security Teams in implementation of CyberArc security on all Databases across the US/Asia/Canada Divisions.

Estimation of total users and application entitlements on all databases. Evaluation of risks and implement entitlements based on roles rather than on individual user basis.

Implement CyberArc password management on rotational basis. Access to databases through CyberArc on single sign on.

Evaluation of users and application risk entitlements and database parameters using Qualys Scan on periodic basis and take corrective actions.

Harvard University, MA

Database Administrator Jun 2004 - Jul 2019

Provide Production, Development, Testing and Maintenance of Oracle 11g/12c/18c Databases on Linux VM, Unix (Sun Solaris 5.9), MS SQL Server 2008 2012/2016 on Windows 2008/2012/2016, MySQL on Linux VM for various University Web based applications for grants management, student registration/courses/Billing, Jobs Hiring, Library, Financial etc.

Project management and co-ordinate design develop and provision ec2/RDS cloud infrastructure on AWS platform using Cloud Formation. Migrated on-premises databases to AWS cloud. Set up cloud watch and monitoring and alerts of databases using Nagios.

Design, install and configure Oracle 11g/12c/18c, RDS, MS SQL Server and MySQL Databases on-premises and AWS cloud for university web applications used by students and faculty. Design and configure SQL Server Mirroring and MySQL replication.

Configured RMAN backup and recovery strategy for Oracle databases.

Installation, configuration of Oracle Real Application Custer (RAC) 10g/11g. Upgrade and patching of RAC servers. Monitoring, troubleshooting and performance tuning using OEM 13c.

Upgrade databases on-premises and AWS from Oracle 10g to 11g to 12c.

Migration of Oracle databases from physical servers to VMWare.

Design, Install and configure Active Data guard and Physical/Logical standby Databases on-premises and AWS Cloud for Web based critical applications like Remedy, Isites, and Weblogic applications and for Report generation. Performed Data guard Switchover and Failover for maintenance and periodic testing.

Installed and configured Oracle Enterprise Manager 13c Grid and configured Monitoring of all databases on-premises and AWS ec2 and RDS instances using central OEM 13c grid.

Installed and configured Golden Gate between several Databases at Schema/Database level. Used Golden Gate for migration from on-premises to AWS Cloud. Configured Golden Gate between Databases in AWS Cloud. Automate Golden Gate monitoring and performance.

Install periodic Security Patches as necessary. Perform regular Releases to Applications and Databases as scheduled by Release management.

Performed Performance monitoring and tuning Databases using AWR and ADDM reports to view/analyze and fix Database and Application related performance issues. Tuning SQL queries, optimizing and debugging. Create and maintain users and roles and grant permissions. Performed Export/Import using Datapump to refresh Database schemas and migration between schema.

Implemented advanced features using compression techniques and transparent data encryption.

Performed Cloning/Refresh/Recovery of OLTP and DWH Databases for Development/Testing/Stage using RMAN backup and Disaster Recovery purposes to validate backups.

Provide ON CALL PRODUCTION SUPPORT for Oracle/MS SQLSERVERS/MySQL Databases and Applications.

TransCore, Inc., MA

Database Administrator Mar 2000 - May 2004

Provide database production support and maintenance of Oracle 9i/8i/805 databases on UNIX (Sun Solaris 5.7)/NT (4.0) Servers for Automated Toll Revenue Collection System (ARCS) Application 24x7 Production Support. Implemented proactive procedures for databases health monitoring and optimal production database performance. Design, develop and configure HOT STANDBY database for graceful switch over to STANDBY in the event of Production database failure

Developed database backup procedures, using Recovery Manager (RMAN) and Recovery Catalog to perform Backup and Recovery of databases. Performed database recovery using RMAN and recovered sql statements using logminor utility. Performed database and application tuning to enhance performance. Implemented even distribution of I/O incorporating storage arrays

Designed, configured, and installed production, development, and test database environments on Solaris/NT platforms, including design, security, capacity planning, disaster recovery, upgrade, migration, and maintenance of system. Design, Develop and Configure 9i database structures for Transaction History database with Partition tables, materialized view. Supported developers in tuning Database and Application for optimal performance, monitor Database growth and provide Database capacity planning for future expansion

Bell Atlantic, Inc., MA

Database Administrator Jan 1998 - Feb 2000

Provide database consulting in design and development of GALAXY Marketing promotion DATA MART system comprising (CMS, CAS, PTS) databases for Bell Atlantic using Valex application. Involved in Star Data modeling, design, creation and maintenance of large relational database Warehouse. Configured multiple databases on Oracle 806 Instances on HP-UX 9000

Performed Schema design using Power Designer for logical/Physical model. Analyzed technical requirements and implemented source extraction, transformation and automated data loading to refresh and update database using SQL* LOADER. Implemented backup recovery strategy, monitoring database growth and performance enhancement. Providing development support for staff developers

Developed and Implemented HOTBACKUP and RECOVERY strategy and STANDBY database for high availability. Configured and Installed Oracle Enterprise Manager 204 and Implemented SNMP configuration for database monitoring from central management station. Performed database Tuning and PARTITIONED TABLES for performance enhancement and improved response time

EDUCATION:

University of Madras India

BS Electronics and Communications

Andhra University India

MBA

Contact this candidate