SUMMARY

• Experienced, Infrastructure, Data Security Engineer credited wif more TEMPthan a decade of Oracle database administration and applications development and regulatory compliance experience.
• Proven record of efficient management of large - scale database and data-driven projects, executing project implementation lifecycles, and managing internal and external customer relations to assure on-time, on-budget deliverables.
• Strong expertise in Project management, end-user support and training, Practitioner of process procedures, and collaborative team building.
• Highly accomplished in quantitative and analytical problem-solving in demanding and results-oriented technical environments.
• Dedicated, enthusiastic, highly motivated individual wif 16 years of IT experience which includes 2 plus yrs. of Database security, 8yrs of Oracle Database Administration experience and 5 yrs of Oracle DDW Development & Production Support.
• Technical Delivery manager in implementing regulatory audit PII compliance.
• Expertise on Database creation, Data modeling, Sizing of databases, capacity planning and documentation of database/operational processes.
• Comfortable and competent wif system architecture, data flow and process flow
• Expertise in using Data obfuscation/ Masking techniques using Informatica and inbuilt masking scripts.
• Conducted detection/analysis, security assessments and recommendations for regulatory audit compliance.
• Expertise in setting up proactive processes for Health checks and performance assessments of teh production databases.
• Migrated DB environments from 10gR2 environments to 11gR2 environments wif Zero Downtime using Shareplex.
• Managed workload for teh team during Shareplex migrations assigning roles and responsibilities.
• Provided mentoring and training as needed to teh team members.
• Prepared technical documentation for projects and production issues.
• Upgrade and migration of databases from 8i to 10gR2, 9i to 10gR2, 10gR1 to 10g R2 and 10gR2 to 11gR1 & 11gR2.
• Coordinated and worked on projects wif global IT teams wifin DELL.
• Implemented Real Application testing to improve performance of teh environment.
• Migrated databases using Shareplex to replicate real time data from 10gR2 and 11gR2 databases.
• Designed and provided solutions like Disaster Recovery and High Availability database solutions using RAC.
• Performed database switchovers from Production to Standby environments using Dataguard broker.
• Expertise in Real Application Clusters for Adding Instances to teh cluster and resolving performance issues in teh cluster.
• Strong Experience in Database Backup and Restore solutions using RMAN features for Cloning, Duplicating databases and redirect restores.

TECHNICAL SKILLS

• Oracle Database Management
• Health Check Administration
• Data Access Controls
• Data Modeling & Analysis
• Performance Tuning
• TDE and Data Redaction
• Data Obfuscation & Masking
• Regulatory PII Compliance
• Risk Management
• IT Infrastructure Management
• Strategic Planning
• Data Governance
• IT Operations Management
• Process Improvement
• Real Application Clusters (RAC) Automatic Storage Management
• Recovery Manager (RMAN) Performance Tuning
• SQL ProfilingDataguard configuration
• Database Design Data Modeling
• Oracle Enterprise Manager - Grid ControlLinux Shell Scripting
• Shareplex, Golden GateOEL, SUSE SLES 10, RHEL Linux
• Real Application Testing Oracle TDE & Redaction

PROFESSIONAL EXPERIENCE

Confidential

Technical Delivery Manager

Responsibilities:

• Managed project teams for onsite engagements. Conducted daily progress and review meetings for Client Senior management.
• Designed, Built and maintained 11gR2 Oracle RAC database.
• Migrated databases from various databases environments using RMAN backup and restore process.
• Migrated databases using RMAN/ Shareplex/ SAN Copy technologies.
• Developed Security Assessment plan, Security assessment report, Security assessment questionnaire, rules of engagement, kick off brief and exit brief templates.
• Implementation of IT governance using teh COBIT principals.
• PCI & PII Compliance reviews - Matrix mapping of company policies and controls.
• Has very good knowledge of application data security, Databases and IT infrastructure design.
• Proposed remediation strategies for remediating database vulnerabilities.
• Managed Data obfuscation and masking, registering workflow and associated dependencies on applications.
• Performed Risk assessments to ensure corporate compliance.
• Designed teh data model for a tactical homegrown solution to kickstart teh data obfuscation process.
• Developed a rule-based engine to support automated data obfuscation activities across various database platforms.
• Providing User access Management services to database systems, gathers/analyzes access request information.
• Defined and created Roles and generated Authorization profiles based on role matrix.
• Responsible for driving various discovery and requirement gathering sessions wif SME, business stakeholders.
• Designed teh infrastructure needs for teh Strategic solution for building an Enterprise wide self-service model to mask objects.
• Successfully implemented work-flow process for data obfuscation containing PII data.
• Successfully implemented Oracle redaction to reduce teh risk in non-production environments.
• Successfully implemented a process to implement role-based access controls on applications.

Confidential

Database Administrator

Responsibilities:

• Managed various projects for teh complete life cycle of teh database build, configuration, solution and implementation into production.
• Extensively used and migrated environments using Shareplex technologies to migrate environments from one version to another wif zero impact to teh application.
• Coordinating wif application teams in analyzing teh requirements of teh business for teh database build.
• Designed, Built and maintained 11gR2 Oracle RAC database of 22TB in size wif DR solution.
• Configured additional database Instances to teh existing RAC in 11gR2 environments.
• Resolved performance issues in RAC environment
• Extensively used GRID Control utility and SQL profiler to resolve any performance issues.
• Designed Archiving and purging solutions for teh database environments by understanding requirements of teh business needs and moving historical data to SATA drives rather TEMPthan SAS drives and improving overall performance.
• Migrated databases from various databases environments using RMAN backup and restore process to build DR solutions, performance, UAT, development environments.
• Migrated databases using RMAN/ Shareplex/ SAN Copy technologies during Upgrade process to reduce downtime and zero impact of teh application.
• Provided solution to teh business by analyzing their database usage and also enhancing teh scalability, performance for a HA solution.
• Designed, configured teh database in extracting data using Goldengate.
• Identifying & tuning data workflows to enhance performance and meet Service Level agreements.
• Implemented successfully in usage of DELL Security Standards like Oracle Identity manager
• Running Health Checks/ tuning on Oracle databases and doing continuous improvement of teh workflows by running AWRRPT, ASH and ADDM reports.Achievements
• Successfully implemented zero impact migrations and near zero downtime database migrations using Shareplex.
• Documented process for implementing new process initiatives to improve response times.
• Successfully implemented Disaster recovery solutions for many critical environments.

Confidential

DDW Developer

Responsibilities:

• Reorganizing Objects for Space Utilization and recover fragmented space between objects.
• Troubleshooting database issues in Application development for finance/ Manufacturing & Service segments which are a very high priority and need immediate attention.
• Implemented successful training for teams in Malaysia and India and setting up a process for supporting applications.
• Maintained & resolved scalability issues of class 1 Applications used to send Email Campaigns by business.
• Designed and developed PL/SQL code for handling quotesend data into CRMS Database.
• Maintained & resolved scalability issues of Order Management.
• Implemented process for supporting various Application wifin DELL.
• Document process for transitioning new application to teh Level 1 support.