We provide IT Staff Augmentation Services!

Senior Imperva Database Administrator-data Security Resume

SUMMARY

  • Currently working as a Senior Database Security Administrator in Confidential .
  • 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 Confidential managing company database environments.
  • Worked as a Database Architect for Confidential 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.

TECHNICAL 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

PROFESSIONAL EXPERIENCE

Confidential

Senior Imperva Database Administrator-Data Security

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 Confidential 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 Confidential 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.

Confidential - Atlanta, GA

Senior Oracle DBA & Data Protection Admin

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 Confidential 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 Confidential 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 Confidential .
  • 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 Confidential 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.

Confidential

Senior Oracle DBA

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

Confidential

Senior Oracle DBA

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.

Hire Now