Data Manager

Shreekanth Veleru

Cell: 908-***-****

Email: adcopw@r.postjobfree.com

Professional Summary:

Currently working as a Senior Database Security Administrator in New York Life.

Having 17 years of experience as a Senior DBA and 5 plus years of experience in Database Activity Monitoring.

Expertise in database security tool using IMPERVA DAM.

Strong knowledge on the compliance requirements and implementing the audit and security controls to adhere to the audit requirements.

Very strong in creating place holders using Imperva and route the audit data to Amazon S3 and Sumo Logic Environments.

Having working knowledge on different data protection tools like DLP, Qualys, Risk Sense, Imperva and log monitoring tools like Sumo Logic.

Ceritified SumoLogic Pro User and completed training for log monitoring.

Worked as a Team Lead for AARP managing company database environments.

Worked as a Database Architect for Novelis on multi-region datacenter migration project.

Worked on large scale environments on Unix and Windows platforms

Good expertise on managing large databases, RAC and Disaster recovery environments.

Expertise on administrating databases on Banking, Telecom and Pharma domains.

Expertise as a database architect, involved in database design and database modeling using Embarcadero tools.

Expertise in Data Center Migrations for database environments and provided solutions for disaster recovery setups.

Experience in handling large databases ranging up to 120 TB in size and deploying best practices for stabilizing the environment.

Experience in installation and implementing Oracle Golden Gate replications.

Expertise in Oracle development routines.

Education Details:

B.Tech (CSE) - J.N.T.University - April 2002.

Skills:

Operating System

Windows, Solaris, RHEL, HP Unix, AIX

Languages

SQL and PL/SQL

Reporting Tool

Oracle 6i reports

Databases

Oracle 12c/11g/10g/9i/8i

Monitoring Tools

Data Point, OEM 12C/ 13C, Imperva

Ticketing tools

Hp Open view, Remedy and ServiceNow

Data Modelling

Embarcadero Tools- Change Manager, Erwin

Database tools

Toad, SQL developer, DB Artisan, PL/SQL Developer

Clusters

Oracle 12C RAC

Replication Tools

Oracle Golden Gate

Version Controls

PVCS and VSS

DAM Tools

Imperva Securesphere

Log Monitoring Tools

SumoLogic

Data Masking Tools

Protegrity, Imperva

Vulnerability Management Tools

Qualys, RiskSense

Experience Summary:

Currently working as a Senior Database Security Engineer at NewYork Life since July 2017 to till date

Worked as a Consultant for HCL Technologies-May 2009 to July 2017

Worked as a Senior Consultant for Mphasis an EDS –July 2006 to May 2009

Worked as Systems Engineer for Polaris Software Labs Ltd-May 2004 to July 2006

Worked as an Oracle Programmer for ICSA INDIA LTD-May 2002 to May 2004

Project Profile:

NewYork Life – Lebanon, NJ

Senior Imperva Database Administrator-Data Security

Duration: July 2017 to till date

Responsibilities:

Implemented a different set of audit policies to improve the security of company data, including client and patient data.

Implemented appropriate security controls and perform data classifications.

Implemented security controls which includes transactional auditing, log retention, tokenization and data masking.

Defined security and audit policies for data at rest and data in motion for the structured data audited from the mission critical databases of MS SQL, Oracle and DB2.

Created different reports based on the customer requirements to access the sensitive data and to report it to the business tower heads.

Worked closely with database administrators and educate them about the DAM tool and implement the security controls inherit in the platform for Oracle, MS SQL and DB2 databases.

Worked efficiently and closely with Risk Assessment teams and compliance teams to understand the external compliance requirements.

Performed Risk assessment using Imperva Risk assessment policies and informed the stake holders and database administrators about the vulnerabilities captured for the database servers.

Created different set of audit and security policies to adhere to SOX, PHI, HIPAA and GDPR compliances.

Scheduled set of reports for capturing failed logins, Risk assessment reports, audit reports, maintenance reports and also performed vulnerability scans to identify potential risks on the database servers.

Worked on the P1 tickets occurred for the critical databases of NewYork Life and identified the root cause of the issues and reported them to business stake holders.

Worked with Incident response teams to create a better work flows and also worked with the change management team to integrate imperva appliances with cmdb.

Created different SOP’s for imperva infrastructure.

Performed health checks and capacity planning for the Imperva MX, Gateways and securesphere agents.

Performed application risk assessments against Health Insurance Portability and Accountability Act (HIPAA) and Payment Card Industry (PCI)

Performed SecureSphere installations v10x, v12.0

Created production, development environments for NYL data cleansing projects.

Upgraded securesphere agents to v12.0 from v10.5. Nearly 250 agents of MS SQL, Oracle, DB2 on windows, solaris, linux are upgraded to v12.0.

Applied securesphere patches p50, p60, p71, p72, p73, p80, p83 to all the gateways and management servers of Imperva.

Created many policies on the oracle and sql databases for protecting the sensitive data of the organization.

Created reports, PII SCANS and monitored the database environments effectively using Imperva.

Deployed management server, gateway patches of securesphere v12.0

Created user, policies for oracle and imperva users and configured LDAP for authentications.

Deployed best practices in traffic distribution and load balancing.

Worked on Sev1 and Sev2 issues effectively and got good appreciations from the client

Implemented oracle and Imperva best practices and increased the performance of the databases and its applications.

Created user defined reports as per business requirements and worked on discovering sensitive data in the databases.

Implemented NAS migration best practices and used the NAS drives for routing data traffic from the gateways.

Created a brand new infrastructure of Newyork Life Direct environment which includes creation of gateways, MX and creation of v13.2 clusterred environment.

Deployed EX Server on the SOM and generated reports using the EX Server.

Created entire architecture from NYL Direct which involves creating policies, security controls, global objects, IP groups, data type creations, Configuring sites tree and many more things.

Performed Discovery Scans and Implemented PII scan routines for the databases.

Implemented syslog transfer to SumoLogic and also to Amazon S3.

AARP - Atlanta, GA

Senior Oracle DBA & Data Protection Admin

Duration: November 2015 to July 2017

Responsibilities:

•Performed database design and maintained logical models of the applications

•Performed PSU patches every quarter and applied one off patches for the bugs related to databases.

•Worked on a Spanish to English conversion project which converts the Spanish characters in the oracle columns in the tables to English language for the databases

•Performed oracle upgrade project upgrading AARP environment from 11204 to 12102 on linux platforms.

•Performed OEM upgrade project from 12103 to 12105 and also version upgrade from 12 to 13c.

•Working with Vendor on unknown bugs and applied bug fixes to the databases.

•Capacity planning and managing ASM environment with SSD disks

•Involved in Imperva Monitoring for mission critical databases which is a very good security feature of the database monitoring.

•Performed Huge pages’ implementation for Linux servers

•Worked in configuring OS watcher reports for linux servers which gives very effective information when node eviction happens.

•Implementing best practices for oracle

•Created a RAC to Non RAC standby environment and creating custom scripts for data guard environments

•Worked on cloud migration project migrating databases to cloud environment

•Database refreshes upon requests from the developers and application people

•Database cloning and backup configurations

•Performed oracle database, grid and client installations for 11g/12c environments.

•Prepared technical documentation for the team and to the company.

•Capacity planning for oracle servers and working with OS teams and maintaining the disks from different raid levels.

•Involved in planning and implementing scheduled maintenances for bi monthly.

•Recovered ASM disks from some disk corruption scenarios and got a very good appreciation from the customer.

•Prevented data loss scenarios during p1 calls and reduced these scenarios by developing oracle best practices and standards.

•Performed automations and created custom scripts in AARP for a better and stable operation of the database environments.

•Created ASM disk corruption checks which enables DBA’s to identify any sort of ASM corruptions happening in the databases.

•OEM upgrades and OEM 13c installations.

•Used Sql loader utilities for loading the data to the tables.

•Performed database refreshes using RMAN and datapump utilities.

•Performed Database server’s virtualization and migrating them to virtual environments.

•Performed adding nodes and removing nodes for RAC cluster environments and created a new RAC environments for AARP.

•Creating customized reports for proactive monitoring.

•Creating Value adds to the customer.

•Installing Oracle Golden Gate and setting up replication environments.

•Upgraded Imperva Gateways from v10.5 to v12.0

•Created Gateways, MX and created v12.0 clustered environments.

•Onboarded database agents of MS SQL and Oracle to Imperva

•Created best practices in supporting securesphere agents efficiently.

•Resolved SSL cipher issues on the agents.

•Created Imperva data types, global objects, audit policies and security policies.

•Generated custom reports and scheduled reports using Imperva.

•Performed Discovery Scans and captured the sensitive data and reported to the business stake holders.

•Created Scan profiles, Configured Sites tree for AARP databases.

•Implemented blocking features in Imperva for the sensitive tables and restricted unauthorized access to the PII data.

•Worked as a team lead for database track and engaged in data protection and ensuring the audit data is in compliance.

•Created SQL Injection security policies and generated reports on adhoc basis.

Novelis, Data Center Migration - Atlanta, GA

Senior Oracle DBA

Duration: March 2012 to November 2015

Responsibilities:

•Design the database architecture for the datacenter

•Inventory Validation and maintaining logical models of the application

•Data migrations from one data center to the other

•Consolidating database servers and migrating them as per downtime requirements

•Projects include Oracle RAC, Data Guard/ Disaster Recovery, ASM, RMAN, Expertise in setting up Standby databases, implemented and administered Data Guard for higher availability and Disaster recovery.

•Implemented Golden gate replication for critical production, Test, development card system environment.

•Responsible for high availability of database environments, contacting command center and work with Unix/tape/storage to troubleshoot and fix the issues within the SLA’s.

•Used Change Manager data modeler tool for database logical design.

•Responsible for switchover of databases for hardware maintenance and datacenter maintenance.

•Expertise in Oracle 10g and Oracle 10g RAC installation and administration Patching.

•Identify and resolve bottlenecks in the database environments, monitor the databases and collect the historical data for root cause analysis.

•Unix OS knowledge with shell scripting abilities (Korn/Bourne)

•System Architecture, including Database and System performance tuning, as well as hardware and network workload balancing.

•Participate in and support application development projects to develop new schemas or databases or modify existing databases.

•Plan and execute periodic releases of the databases.

•Maintain successful database continuity, backup, recovery, user support and other day-to-day activities.

•Assure environments meet SOX Compliancy guidelines

Ernst & Young - Secaucus, New Jersey

Senior Oracle DBA

Duration: May 2009 to March 2012

Responsibilities:

•Hands on experience with developing and maintain the applications in Oracle 11GR2 RAC.

•Experience with Oracle 11GR2 Grid infrastructure.

•Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.

•Design, architect, and build Golden gate replication environments from determining business requirements.

•Support Development, Test, Pre production and production Golden gate replication environments.

•Installation of Oracle database software, Gird infrastructure software.

•Experience with Oracle Enterprise Manager Grid control 12c.

•Experience using Golden gate for replicating schemas between data centers.

•Troubleshoot golden gate replication issues.

•Experience in analyzing the AWR reports.

•RMAN backups and restores. RMAN Image copy backup.

•Dataguard for physical standby database, and disaster recovery implementation.

•Experience with 11G new features tablespace encryption, compression virtual column partitioning, Cube organized Materialized views.

•Experience with recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.

•Experience in managing various projects in OLTP and Decision support systems.

•Experience with Oracle warehouse builder, data warehousing and Star schemas.

•Experience with the SOX audit procedures and developing the secure applications. Secure user management and restrict the unauthorized users from accessing the critical database objects.

•Experience with PL/SQL procedures, functions, packages and triggers.

•Experience with Oracle parallel queries to improve inserts and updates.

•Advanced knowledge of SQL. Solid SQL performance tuning. SQL query plan analysis and optimization.

•Experience with Materialized views and Query rewrite.

•Experience with Partitioning and sub partition of large tables.

•Support to the data arch team on physical design of DB objects, incl. partitioning, archiving strategy, naming of columns, proper constraints, etc.

•Collaborate with the DB Engineering team to improve operations and implement new features and tools.

•Develop, maintain and review team members to ensure professional and timely delivery of quality services.

•Expertise in Oracle 10g and Oracle 10g RAC installation and administration Patching.

•Identify and resolve bottlenecks in the database environments, monitor the databases and collect the historical data for root cause analysis.

EDS-Sprint & Nextel (Mphasis) – India

Oracle DBA

Duration: July 2006 to May 2009

Responsibilities:

•Provided regular production DBA support for around 1000+ databases.

•Manage and support Production Oracle 9i/10g/11g databases

•Installation of Oracle CRS and configuration of RAC setup on Unix and Linux with ASM raw devices.

•Convert the Single Instances to RAC cluster databases in 10gR2

•Perform cross platform Migrations of large database systems with transportable database option in 11gR2.

•Configured High Availability with Dataguard with two nodes RAC.

•Setting High Availability technologies like Log Shipping.

•Solving Disk space related issues and Log and database file full issues.

•Troubleshooting Log shipping, Database Mirroring issues.

•Applying the CPU Patches and fix the bugs.

•Managed high end databases in Data Warehouse Systems and OLTP databases and its applications.

•Periodically clone multi-terabyte databases to QA and UAT.

•Installed, Configured and upgraded the databases to Oracle 10g/11g R2 (11.2.0.1), Oracle 11g R1 (11.1.0.7) and 10g R2 (10.2.0.4).

•Installed/configured and administered Oracle10g/11g RAC on a 4 node environment.

•Performed Database Migrations and Upgrades on the same platform and across platforms.

•Applied the Security CPU patches quarterly on RAC databases with rolling fashion.

•Managing the backups using Recovery Manager (RMAN)

•Installed Oracle Grid control OMS10g/Agents for monitoring

•Liaised with Oracle Support for resolving issues.

•Setup and Managed Oracle DataGuard / Physical standby for Oracle 10g and performing both planned and unplanned switchovers and failovers.

•Installed, Created and Administered Automatic Storage Management (ASM) instances and OCFS setups for use with both RAC and Single instance setups.

•Applied the Oracle CPU patches on RAC databases with rolling fashion method.

•Performed Database Migrations and Upgrades on the same platform and across platforms.

•Creation and Cloning of Oracle databases for setting up Development and Test databases.

•Performed conversion of Single Instance to Cluster databases.

•Implemented Node Addition / Deletion and Instance Addition / Deletion procedures 2for the RAC Database.

•Configured Sqlnet, Net8 and Oracle Net services, Connect failover and Application failover (TAF), load balancing and Names server.

•Managing the backups using Recovery Manager (RMAN)

•Set up and maintain physical standby database for disaster recovery

•Rebuilding the standby databases as and when required.

•RMAN backups and restores. RMAN Image copy backup.

•Dataguard for physical standby database, and disaster recovery implementation.

•Experience with 11G new features tablespace encryption, compression virtual column partitioning, Cube organized Materialized views.

•Configured and Installed RDA, OSWATCHER, RACDIAG tools as per the requirements.

•System Architecture, including Database and System performance tuning, as well as hardware and network workload balancing.

•Participate in and support application development projects to develop new schemas or databases or modify existing databases.

•Plan and execute periodic releases of the databases

Citibank US (Polaris) - India

Oracle DBA

Duration: August 2004 to July 2006

Responsibilities:

•Production support of Citibank most critical application TRIMS.

•Provided regular DBA support for multiple ORACLE databases on UX/NT running RAC on VERITAS Cluster and standalone.

•Manage database changes and upgrades using proper ITIL process.

•Performed quarterly CPU patches as part of the ongoing security enhancements

•Performed the installation of Oracle software over the dev, test and prod environments

•Performed Upgrades of Oracle software versions (9i to 10G)

•Involved in CAB meetings and applied the Changes accordingly.

•Involved in L3 support and done Some Root Cause analysis and fixed the solutions permanently.

•Involved in incident management, Problem management and change management.

•Involved in project management activities.

Citibank US (Polaris) - India

Oracle DBA

Duration: May 2004 to July 2004

Responsibilities:

•Creating database for Production/Quality/Development

•Performed Database migrations.

•Performed Backup and recovery management

•Database refresh (Export / Import)

•Monitoring databases for various applications

•Managing privileges and roles to ensure database security

•Handling database change request from the application developers as on need basis

•Tablespace creation and space management

•Creating users, granting roles, allocating tablespace as required in the project

•Database/ Schema refresh

•Cron Job setting

•On call support for production instances

•Creation of online and offline backup / performance scripts

•Providing telephonic support to the client about the issues related to database

E-health insuance (ICSA) - India

Oracle Developer

Duration: December 2003 to April 2004

Responsibilities:

•Creating logical models for the application

•System Integration testing and maintaining development databases

•Creating procedures, triggers

•Creating database objects, designing tables

•Application testing and maintaining all the database environments.

Hospital Management System (ICSA) - India

Oracle Developer

Duration: May 2002 to December 2003

Responsibilities:

•HMS is a product of ICSA. We have gathered the requirements from different hospitals.

•Creating logical models of the applications

•Generating reports using oracle reporting tool.

•Testing and coding the application, Go-live activities and production support.

•Creating procedures, triggers, schema objects, designing tables

•Application testing and maintaining all the database environments

Contact this candidate