SUMMARY

• A competent professional with around 6.5 years of experience in Database Administration and Database Security Administration, Project Execution, Space / Storage Management, Cost / Time Effectiveness, Resource Optimization and Process Enhancement.
• Proven ability in Security Projects implementation i.e. Guardium database activity monitoring.
• Proven ability in monitoring database technologies like Oracle, SQL Server, DB2,Netezza etc.
• Proven ability to monitor end to end Guardium infrastructure.
• Proven abilities in patching, upgrade, migration, performing rman backup / recovery process; query optimization & tuning; cloning, expdp - impdp, automation of report generation and installation / configuration of Oracle Databases.
• Skilled in analysing, designing and creating database for prod support & development purpose.
• Resourceful in overseeing smooth implementation of the application by interacting with team members to ensure smooth progress of project work.

AREAS OF EXPERTISE

• Guardium Appliance/Agent Management Design & Data Modelling Server Administration Data Warehousing
• Database Upgrade, migration and Cloning
• Guardium Health Management Space Management Backup & Recovery Management ASM instance Management DB Health Management
• Guardium DAM Implementation Data & Information Architecture Project Management Database Security Patching Management Guardium Appliances Upgrade

TECHNICAL SKILLS

• Oracle 10g / 11g/12c/MySQL/SQL Server 2008/2012 SQL
• PL-SQL
• Shell scripting Windows and Red hat Linux 6.x
• 7.x
• Sun Guardium
• VRM
• Cyberark
• QRadar
• OEM
• SQL*Plus / Loader
• Export / Import
• RMAN
• DBCA and TOAD
• Putty

PROFESSIONAL EXPERIENCE

Confidential

Senior Associate

Responsibilities:

• Responsible for Guardium capacity planning and System design lifecycle.
• Ensure all appliances meet the minimum system requirements.
• Responsible for Upgrade of Guardium Appliances and Agents versions from v9 to v10.
• Creation of shell script to automatically the purge Guardium Appliances backups older than specific time period.
• Ensure successful data activity monitoring implementation that supports critical business applications for the enterprise.
• Run, test, and validate Guardium configuration settings and fully document technical and procedural requirements.
• Provide continuous support for troubleshooting and maintenance of Guardium deployments.
• Perform regular health check for overall Guardium Infrastructure.
• Ensure audit processes are properly scheduled and results are purged correctly.
• Periodically reviewed policy against business requirements, especially if new Guardium agents are added
• Periodically reviewed report definitions and results against business requirements.
• Periodically reviewed correlation alert definitions.
• Kept up to date with latest appliance patches and agents that are available. Installed the latest packages to eliminate known problems.
• Administer User Access appropriate to the role. Also, Maintained GUI admin, accessmgr and CLI account passwords.
• Involved in performing a POC of SONARg tool implementation.

Confidential

IT Analyst

Responsibilities:

• Creation & administration of all database objects, including tables, clusters, indexes, views, sequences, packages and procedures o Database tuning and performance monitoring o Resolution of database start up problems
• Handling end-to-end project management activities inclusive of planning, effort, design, scope, estimation, resource coordination and delivery as per specified timeframes.
• Monitoring project progress as per scheduled deadlines for various tasks and taking necessary steps to ensure completion within time, cost and effort parameters
• Managing code deployment, change management and quality assurance
• Providing technical support to application development teams and setting / maintaining standards
• Managing Oracle patching and apply PSU patches on all non-production and production databases twice in a year.
• Managing upgrade and migration of databases including 9i,10g and 11g databases.
• RMAN cloning of databases.
• Physical/Logical standby setup and troubleshooting.
• Guardium tool implementation for DAM purposes for technologies Oracle, SQL Server and Netezza.
• Lifecycle management of gaurdium appliance/agent
• Understand application audit requirements and modify/setup the Policy/Audit Reports accordingly
• Handling end to end project management activities inclusive of planning, effort, design, scope, estimation, resource coordination and delivery as per specified timeframes.
• Cyberark EPV implementation for high privilege DB accounts
• Instrumental in implementing application sub-module successfully
• Successful migration of critical databases on same platform and different platforms.
• Successfully created replica for production server for development server
• Responsible for upgrading database from all versions of 10g to 11g or to 12c.
• Migration of database from Non ASM to ASM.
• DR testing across different regions.
• Guardium Tool implementation for DAM purposes.
• Setup the Enterprise Load Balancing
• Responsible for upgrading all agents to the latest version to support ELB feature
• Cyberark tool implementation for EPV

Guardium Security Administrator

Confidential

Responsibilities:

• Responsible for Guardium capacity planning and System design lifecycle.
• Ensure all appliances meet the minimum system requirements.
• Ensure successful data activity monitoring implementation that supports critical buisness applications for the enterprise.
• Run, test, and validate Guardium configuration settings and fully document technical and procedural requirements.
• Creation of multiple technical documents including Appliance, Agent Install/Uninstall, Guardium Backup, Recovery Protocols.
• Upgrade of Guardium Appliances from V9 to V10.
• Implementing Guardium appliance V10 setup as a VM software appliance for a federated environment (Centrally managed) including around 80 Appliances across two data centres monitoring about 500 database instances.
• Implement the solution for basic data activity monitoring for technologies Oracle, SQL Server.
• Performed troubleshooting and fixed issues such as Aggregation/Archive errors, Scheduled Jobs Exceptions, Inactive STAPs etc
• Provide continuous support for troubleshooting and maintenance of Guardium deployments.
• Perform regular health check for overall Guardium Infrastructure.
• Ensure audit processes are properly scheduled and results are purged correctly.
• Configured unit utilization report to monitor inspection-core performance in centrally managed environments.
• Closely worked with application team to gather monitoring requirements, implement, and modify the policies as per need
• Periodically reviewed report definitions and results against business requirements.
• Periodically reviewed correlation alert definitions.
• Design the monthly patching strategy for appliances
• Setup the self-monitoring tasks for appliance maintenance
• Periodically reviewed policy against business requirements, especially if new Guardium agents are added
• Setup the auditing tasks as per application requirements.
• Design backup/purging/archiving solution for the appliance
• Analysis of Guardium advanced features such as FAM,VA,CAS, blocking, masking, quarantine etc.
• Administer User Access appropriate to the role. Also, Maintained GUI admin, accessmgr and CLI account passwords.
• Worked with platform team to install DAM agent GIM/STAP and configure inspection engines on numerous database servers
• Periodically reviewed report definitions and results against business requirements
• Upgrade of current GIM/STAP agents
• Load balancer configuration
• Monitor Privilege DB users and sensitive objects closely and generate real time alerts on critical security events
• Troubleshoot end to end install and resolve issues
• Implementation with Qradar for sending the syslog alerts
• Involved in performing a POC of SONARg tool implementation.

Security Administrator

Confidential

Responsibilities:

• Implementing Guardium appliance V10 setup as a VM software appliance for a federated environment (Centrally managed) including 6 in Production environment and 4 in QA environment.
• Implement the solution for basic data activity monitoring for technologies Oracle, SQL Server and Netezza and DB2.
• Performed troubleshooting and fixed issues such as Aggregation/Archive errors, Scheduled Jobs Exceptions, Inactive STAPs etc
• Configured unit utilization report to monitor inspection-core performance in centrally managed environments.
• Ensured all appliances meet the minimum system requirements
• Closely worked with application team to gather monitoring requirements, implement, and modify the policies as per need
• Design the monthly patching strategy for appliances
• Setup the self-monitoring tasks for appliance maintenance
• Setup the auditing tasks as per application requirements.
• Design backup/pruging/archiving solution for the appliance
• Analysis of Guardium advanced features such as FAM,VA,CAS, blocking, masking, quarantine etc,
• Worked with platform team to install DAM agent GIM/STAP and configure inspection engines on numerous database servers
• Periodically reviewed report definitions and results against business requirements
• Periodically reviewed correlation alert definitions
• Upgrade of current GIM/STAP agents
• Load balancer configuration
• Keep up to date with latest appliance patches and agents that are available. Installed the latest packages to eliminate known problems.
• Monitor Privilege DB users and sensitive objects closely and generate real time alerts on critical security events
• Troubleshoot end to end install and resolve issues
• Implement Cyberark EPV for Securing High privileges database accounts.
• Assess the vulnerabilities related to database using VRM tool.

Database Administration

Confidential

Environment: Oracle DBA35 - Offshore and 15 - Onsite, Netezza, SQL-Server 2000 / 2005,2008, Oracle 9i / 10g/11g/12c (Unix,Windows,AIX and Solaris) The project belongs to “Life Sciences and Healthcare” practice and involves development of the solution that will be part of Lilly's IT department. Lilly has approximately 2400 database instances across the globe - Zone1 (America), Zone2 (Europe & Africa), and Zone3 (Asia Pacific). TCS will provide the Data Management Services across all zones. The main database technologies currently in scope are Oracle, SQL Server, and Netezza. Sybase power designer is the main tool used for Data Modelling.

Responsibilities:

• Investigating performance issues and assisting application teams with resolution.
• Assisting application teams in providing access rosters.
• Administering and maintaining databases.
• Administering, creating, unlocking and resetting database accounts/ passwords and maintaining proper classification of privacy data.
• Developing database architecture recommendations and improvements.
• To setup and monitor database backups and to demonstrate that backups are running according to agreed upon schedule.
• Performing database restores as requested and recommending disaster recovery approaches for an application.
• RMAN catalog planning.
• Oracle to Netezza Migration.
• Physical/logical Standby Monitoring.
• Migration from NON ASM to ASM databases.
• Use of physical standby approach to move the database to have minimum downtime for any critical standby.
• Advance Enhance Monitoring through OEM like account lock, blocking session etc.
• Successful Disaster Recovery testing.
• Planning to move databases from Physical to virtual environment as a part of LCM(Life Cycle Management).
• To perform database management and monitoring for availability, reliability, and performance and to initiate preventive and/or corrective actions based on availability, reliability, and performance thresholds.
• To interface directly with application/project teams, including meeting onsite as necessary, to assure all database- related needs are understood and met.
• Handling performance-tuning issues of oracle databases.
• Upgrading and migrating Oracle Databases.
• Database cloning and migration.
• SQL Tuning Using Explain.
• Environments refresh through conventional and Data pump export utilities.
• Creating value-adds services and providing innovative solutions to save cost and time on business work requests.

Databases: Junior Oracle DBA15 - Offshore and 5 - Onsite DB2 8.X, SQL-Server 2000 / 2005, Oracle 9i / 10g/11g (Windows and Unix)

Database Administration

Confidential

Responsibilities:

• Instrumental role in coordinating the work between client & developers across different geographical locations
• Contributed significantly towards supporting for 1000+ databases on 25+ servers and oversaw the regular Database Administration (checking logs, backups, etc.)
• Played a key role in the generation of process / performance improvement as well as daily / weekly report for the Higher Management.
• Pivotal in creating new instances, databases and users and providing rules to the user
• Distinguished efforts towards query optimization & tuning; migrating database from one level to another level and deploying databases as per the request
• Spearheaded the daily / weekly backup for the Oracle Server Databases, which includes generation of batch scripts for the oracle databases backup & log
• Used TOAD tool for generating various scripts
• Responsible for monitoring Oracle log file for any error on daily basis
• Checked backup logs and rectify any issues faced in that
• Dexterously involved in:
• Diagnosing performance related issues (locking / database long waits) o Automation of alerts to proactively monitor the health of database o Oracle CPU Patching/Interim Patching/Bug Fix patches o Troubleshooting all database maintenance issues.
• Maintained the logical backup using EXP and IMP -maintained logical backups also for additional security and copy them on different servers with a batch file and import them on test servers on regular basis
• Rendered active maintenance & support to database in 10g and monitored the database & collection of AWR reports
• Managing Oracle patching and apply PSU patches on all non production and production databases twice in a year.
• Managing upgrade and migration of databases including 9i,10g and 11g databases.