SUMMARY

• Seasoned Oracle Database Administrator and Security developer - Architect with around 13 years experience in Oracle Database Administration. Successfully designed, implemented and supported (24x) large databases using Oracle 11gR2, 11gR1, 10g, 9i on various platforms like Linux, Solaris, Windows and HPUX, AIX.
• Design,developed and Implemented the architecture for Audit logging, Database Security and Enterprise Security Services.Primarily includes Oracle Audit Vault and Database Firewall,Oracle Audit Vault,Oracle Database Vault,Syslog,Informatica,Arcsight logger etc.
• Design, code test and implement Audit Log Management Architecture for Health Care Quality Information System Architecture to comply with NIST SP Log Management.
• Extensively Documented the Security Control Assesment as per CMS Guidelines for all the Audit Data Logging Services.Developed the service that is used by External Auditors to Audit Data.
• POC Support /AutomationLeadSupport for External Line of Business(LOB) in DECC -CMS Enterprise Services
• Experienced in database design translated business requirements into creation of database objects tables, indexes, constraints, packages, stored procedures and functions using oracle tools
• Implemented and Documented Informatica Data Qaulity to discover,profile,monitor and cleanse the data.
• Implemented and Documented Erwin Model Mart Upgrade for Data Modelling.
• Prepared Project Plans for Various Services Developed.
• DBA daily activities, including user management, resource management, space management, monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
• Storage Optimization involving Partitioning 10g,11g.Advanced compression 11g,ASM,MAA
• Installation and maintenance of 11gR2/11gR1/10g/9i Real Application Clusters (RAC), ASM, CRS. Application server, LDAP server and their version Upgradations. Applying Oracle CPU, security patches, patch sets and one-off patch
• Implemented Goldengate replication o2o(Oracle 2 Oracle)
• Database migration from a datacenter to a datacenter for the whole enterprise,Migration involving cross-platfrom migration and version upgrade etc.
• Extensively worked on Backup with different technologies like RMAN, VSU Snap, Netbackup, Netapps snap,BCV split n sync etc. and different backup modes like user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Extensively worked on Oracle Internals, Security, Replication, Data Modeling, Recovery Manager (RMAN), Standby database using Data Guard, Oracle Enterprise Manager (OEM), Database Migration and Database Archival. High Availability Solutions like Oracle 9i/10g/11gR2/R1RAC, Advanced Replication, Oracle Streams, Oracle Failover using Active-Passive cluster and disaster recovery. Recovery operations through RMAN, SNAP backup, flashback database, table, TSPITR etc.
• SQL tuning and Performance tuning for databases and applications. Used Explain plan,TKPROF, DBMS Profiler, AWR reports, ADDM, TOAD for SQL/PLSQL Tuning; Performance tuning i.e. tuning SGA,I/O distribution. Resource and capacity planning, migration from lotus to Oracle
• Worked on complete set up of monitoring tool Foglight and Backup/restore tool Commvault Customized these monitoring tools as per the client requirement. Created the Space management and trending reports using various tools and shell scripts for all the Oracle databases, added SQLServer and Sybase to the list. Implemented Performance Analysis tool from Quest
• Used Oracle Enterprise Management (OEM) with standard management, diagnostic, tuning, and change management packs to perform various administrative tasks. Setting-up and configuring Oracle Management Server (OMS) to monitoring database operation
• Daily Monitoring of Oracle instances using Oracle Enterprise Manager, Grid Control, BMC Patrol, TOAD, monitor users, tablespaces, memory structures, rollback segments, logs, and alerts
• Work closely with developer, provides Oracle DBA support and technical support for multiple applications in DEV,TEST,UAT,SIT and PRODUCTION environments
• Raising SR with oracle support in case of oracle internal errors and get the oracle bugs fixed.
• Setting up Oracle audit vault, Oracle Database Vault,Oracle Audit Vault agent across all the databases to monitor the audit operations like DML and DDL operations, dropped objects etc.This is set up to monitor malicious activities and for the auditors. Reports will be sent across the team.
• Unix shell scripts to set up patrol monitoring which checks the health of the database and alarms in case of crossing the thresholds set u and to generate trend reports on the databases Shell scripts for hot backups, SQL*Loader, export / import of database
• Security implementation through Single Sign-On (SSO) and Oracle Internet Directory (OID)

TECHNICAL SKILLS

Languages: SQL,PL/SQL,Shell scripting,Perl,Groovyscripting,MySQL

RDBMS: Oracle 9i,10g,11gR1,11gR2,Postgres,SQLServer

Internet Technologies: Java Script, J2EE,HTML

Front End: Oracle9i,10g Appserver,Oracle9i/10g LDAP Server,Sun one LDAP server,Oracle Designer,Weblogic 10,UCM,Glassfish Application Server,Syslog N/G Collection Server,XMLGatewayAppliance,OER,OBIEE,GRC,OracleEnterprise Security(Identity & Access Management)

Operating Systems: Windows XP/2000, IBM-AIX 5.3,6.1,7.1 HP-UX 11.11,11.21,SunSolaris 9,10,RHEL4, RHEL5

Oracle related Tools: Quest Foglight 5.5.8,4.1, Quest PA 7.0 6.0, Commvault 9.0, Toad 10 PL/SQL Developer, Oracle 9i/10g/11g client,OEM grid control, Oracle Audit Vault and Database Firewall 12.2,Oracle Audit Vault 10.3, Oracle Database Vault,OER(Oracle Enterprise Repository,OBIEE(Oracle Business Intelligence Enterprise Edition),Oracle Service Bus,Oracle WebLogic

Other Tools: SSHclient,Xbrowser,MicrosoftVisio,Rational,CVS,VisualSourceSafe 6.0,SVN,SharePoint,Citrix,OpenSTA,ora2pg,GRC (Governance,risk management and compliance),Splunk, Syslog,Syslog-NG, Informatica 9.2,Informatica DQ 9.5, Erwin Model Mart 9,Soap UI PRO

PROFESSIONAL EXPERIENCE

Confidential, Coulmbia, MD

Audit Logging Solutions SME/Oracle DBA

Responsibilities:

• Deigned,Implemented SALARS, IRWS, Splunk Security Ontology & Topology Analysis, Log4j & Container Management Security, FISMA/NIST Security Compliance and HIPAA standards.
• Design, code test and implement Audit Log Management Architecture for Health Care Quality Information System Architecture to comply with NIST SP Log Management.
• Installed, configured, tuned and updated Oracle Audit and Database firewall,Oracle Audit Vault,Oracle Database Vault as well as Realms and Incident Response Filters to HQCIS Audit Logs, spanning across the entire Architectural Layering, to provide alerts to HQCIS - CMS
• Installed, configured, tuned and updated Oracle Business Intelligence Enterprise Edition 11g - to query CMS Audit Logs and provide Incident Response Analysis Reports and Alerts.
• Designed, developed, coded, tested and implemented Security Audit Log Analytic Report Service (SALARS) with OBIEE.
• Designed, developed, coded, tested and implemented Error Handler Service (EHS) with XML Gateway appliance, Oracle 11g Database and Oracle Audit Vault 10.3, Oracle Audit Vault and Database Firewall.
• Upgrade Oracle Audit Vault 10.3 to Oracle Audit Vault and Database firewall 12.2
• Coordinated implementation of ArcSight ESM and Logger SIEM with Data Connectors to access HQCIS - DECC Audit Logs to provide an IV&V Incident Response Correlation to HQCIS Security Audit Log Analytic Report Service (SALARS)
• Extensively Documented the Security Control Assesment as per CMS Guidelines for all the Audit Data Logging Services.Developed the service that is used by External Auditors to Audit Data.
• POC Support /AutomationLeadSupport for External Line of Business(LOB) in DECC -CMS Enterprise Services
• Implemented and Documented Informatica Data Qaulity to discover,profile,monitor and cleanse the data.
• Implemented and Documented Erwin Model Mart Upgrade for Data Modelling.
• Prepared Project Plans for Various Enterprise Services Developed.
• Designed, developed and implemented the following Functional Specifications, White/Black Box - Activity and Sequence Diagrams: BI Log Analysis Report Service Specification, Pull Audit Log Service Specification, Syslog Endpoint Service Specification, and Retain Operational Log Data Service Specification,
• Database Installation/Upgradations/Patches
• Installation and configuration of 11g RAC/Standaline database server and their version up grades
• Apply quarterly, half-yearly, yearly patches using OPATCH. Also applying different patch sets on the database releases to overcome the bugs. Apply CPU patches, security patches, one-off patches etc.
• Database Monitoring
• OEM Grid Control and OAV Oracle Audit Vault.
• Database User management
• Tablespace management for each module, Schema creation and security privileges over database objects, Creation of synonyms for security, Creation of views and procedures for faster access, Creation of database links.
• Database Optimization
• Fine Tuning of SQL queries that affect the performance, Proper creation of indexes, setting in init.ora, RAM and virtual memory settings, performance tuning, load balancing etc
• Tuning database with the help of,v$ views, Grid control, OEM tools, Tuned database at different levels like, DB level, SQL level, User/session level. Used different reports like AWR, statspack, ADDM, SQL tunning advisor, Segment advisor etc. Also used Explain plan, tkprof etc. used various tools,OEM, AWR & ASH Report
• Storage Optimization involving Partitioning 11g and 10g databases.Advanced compression 11g,ASM,MAA
• Shell scripts
• Perl /Shell Scripting using REGEX to automate Data Parsing and Loading.
• Shell scripts for creating oracle environment which brings the ease of usage in accessing the databases. For example, oratab.dat (includes all the environment variables for that database), sqlsecure (for storing the passwords).
• Database start up and shutdown scripts, maintenance scripts, backup scripts, purge scripts, reporting etc
• Database maintenance
• Perform all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup, patches, monitoring, export/imports and SQL load
• Oracle Audit Vault,Enterprise Manager Grid Control, Database Control(OEM)
• Daily DBA activities like Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring, User creation and db profiles
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, recovery time allowed etc. Recovery management. Audit and log management through purge scripts
• Export and Import of database objects to copy from one database to another database with use of Datapump (expdp/impdp) in 10g/11g with new features
• Documentation
• Documents containing Logical System diagrams,Functional Specifications, White/Black Box - Activity and Sequence Diagrams: BI Log Analysis Report Service Specification, Pull Audit Log Service Specification, Syslog Endpoint Service Specification, and Retain Operational Log Data Service Specification,
• OAV(OracleAudit Vault )Architecture design,Installation, configuration, security,Administration documents.
• CMS Security Control Assesment Documentation for various Enterprise Services developed.
• Erwin Model Mart Implementation
• Informatica Data Quality Implementation
• Database design,Performance consideration,maintenance,backup recovery and monitoring documents.
• TestCase Specifications and Test Summary Report documents.

Confidential, NY

Lead Sr.Oracle DBA

Responsibilities:

• Oracle DBA Lead and POC for Goldengate 11.1.1.1 implementation involving bi-directional replication across Europe,Singapore, Japan Data center
• Documentation involving SOPs,security architecture document,Knowledge transition documents.
• Presentations involving the implemention of Vblock,Oracle,Goldengate replication across the datacenters involved.
• Organizing meetings and knowledge transition to the offshore team.
• Upgradation of Oracle databases version 11gR2 AIX to 11gR2 Linux.

Confidential, ParkRidge, NJ

Sr.Oracle DBA

Responsibilities:

• Database Installation/Upgradations/Patches / Migration
• Installation and configuration of Oracle 9i/10g/11g database server and their version up grades. Installed SQL Server 2008R2 in a clustered and standalone
• Apply quarterly, half-yearly, yearly patches using OPATCH. Also applying different patch sets on the database releases to overcome the bugs. Apply CPU patches, security patches, one-off patches etc. Migrated 500 Oracle databases and lead team of Database Administrators.
• Database Monitoring
• Tools lead and set up Quest tools foglight 5.5.8, PA 7.0 and Commvault Simpana backup tool for Oracle/SQLServer/Sybase databases in the new data center. Wrote custom scripts.
• Implemented shell scripts for generating management reports and Email-notifications which are too specific and cannot be generated through the monitoring tools which involves storing the data in other database and reports generated from that database.
• Solved several monitoring issues in these tools and helped improve the 3rd party product foglight. This involves the design improvements and defects in the product.
• Wrote Custom scripts in groovy language for Alarms and ticket generation through integrated tool BMC. For example, to identify an archive file system through foglight which has reached a threshold generate an alarm and make a script action exported to the Monitored host and invoke the backup tool to kick off the archiving. These was wiely appreciated by the client
• Database User management
• Tablespace management for each module, Schema creation and security privileges over database objects, Creation of synonyms for security, Creation of views and procedures for faster access, Creation of database links.
• Database Optimization
• Fine Tuning of SQL queries that affect the performance, Proper creation of indexes, setting in init.ora, RAM and virtual memory settings, performance tuning, load balancing etc
• Tuning database with the help of PA,foglight,v$ views, Grid control, OEM tools, Tuned database at different levels like, DB level, SQL level, User/session level. Used different reports like AWR, statspack, ADDM, SQL tunning advisor, Segment advisor etc. Also used Explain plan, tkprof etc. used various tools, like foglight,PA,OEM, AWR & ASH Report
• Storage Optimization involving Partitioning 11g and 10g databases.Advanced compression 11g,ASM,MAA
• Shell scripts
• Shell scripts for creating oracle environment which brings the ease of usage in accessing the databases. For example, oratab.dat (includes all the environment variables for that database), sqlsecure (for storing the passwords).
• Database start up and shutdown scripts, maintenance scripts, backup scripts, purge scripts, reporting etc
• Database maintenance
• Perform all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup, patches, monitoring, export/imports and SQL load use of foglight, PA, Commvault, Enterprise Manager Grid Control, Database Control(OEM)
• Daily DBA activities like Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring, User creation and db profiles
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, recovery time allowed etc. Recovery management. Audit and log management through purge scripts
• Export and Import of database objects to copy from one database to another database with use of Datapump (expdp/impdp) in 10g/11g with new features
• Setting up Commvault backups, refresh, BCV backup, customizing the scripts through Commvault tool Tablespace point in time recovery. Setting up Disaster Recovery DB
• Usage of logminer to recover incase of no alternative left to flashback table
• Development and Testing Environment Database refresh using production database backup
• Implemented Data Guard for Disaster recovery system using Oracle 11g
• Setting up Oracle read only replication with materialized views and developed scripts for automating the rebuilt process of replication
• Prepared and Implemented UNIX shell scripts for automation of different administrative activities and notifications. Archival management through foglight and Commvault
• Documentation
• Foglight Architecture, Installation, configuration, security and Administration Document
• PA Architecture, Installation, configuration, security and Administration Document
• Commvault Installation/Administration document

Confidential, Irving, TX

Sr. Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i/10g/11g database server and their version up grades. Installation of Oracle 11g Real Application Cluster (RAC) release 2 and 11g Real Application Cluster (RAC) release 1 (11.1.0.6 and 11.1.0.7) databases for VSource/EDMS/VOC/AIMS/iGo/PNP Project on Linux RHEL5
• Involved in database upgrade from 11.1.0.6 to 11.1.0.7/11.2.0.1.0 for all the environments in EIC/ VSource/EDMS/VOC/AIMS/iGo/PNP project DEV, TEST, STAGE and PROD environments, upgrade from 10.2.0.1 to 10.2.0.3/10.2.0.4 for EDMS project for DEV, TEST and PROD environments, upgrade from 11.1.0.6 to 11.1.0.7 for all the environments in EIC project DEV, TEST, STAGE and PROD environments also involved in upgrading databases from 10.2.0.4 to 11.1.0.6. applied Patches as when required
• Installation of Oracle Weblogic 10.3, Apache, SSO and SSL certificate configuration for Corp Reporting Project. OS Installations -windows, HP-Unix
• Implemented Goldengate replication o2o(Oracle 2 Oracle) version 10.4.0.x for Oracle 10g 64bit on RHEL4,RHEL5
• Database Optimization/Monitoring
• Setting up patrol monitoring scripts. Fine Tuning of SQL queries that affect the performance
• Tuning database with the help of v$ views, Grid control, OEM tools, Tuned database at different levels like, DB level, SQL level, User/session level. Used different reports like AWR, statspack, ADDM, SQL tunning advisor, Segment advisor etc. Also used Explain plan, tkprof etc. Proper creation of indexes, setting in init.ora, RAM and virtual memory settings.
• Tuned database after migration from Oracle 9i to Oracle 10g/11gR2/R1 using various tools, like Oracle Enterprise Manager, AWR Report, ASH Report
• Database maintenance / Design
• Administrating and troubleshooting oracle clusterware, starting-stopping different services like CRS, Nodeapps etc, administrating different CRS logs like cssd, crsd etc.
• Configuring ASM instances on RAC database nodes by installing and configuring ASM library, marking disks for ASM, creating ASM diskgroups, adding disks into diskgroups etc, administration of ASM instances by ASMCMD and ASM logs.
• Storage Optimization involving Partitioning.Advanced compression,ASM
• Extensively Used Enterprise Manager Grid Control, Database Control(OEM)
• Implemented Data Guard for Disaster recovery system using Oracle 11g. Configured and scheduled different database related jobs through ESPX agent, also created the scripts.
• Used TOAD Data Modeler for data base design and creating of objects. Normalized tables, Implemented schemas, table space, synonyms, database links, views, privileges etc
• Actively involved in installs, upgrades, builds, sizing, backups, patches, monitoring, performance tuning, data migrations and data transfers and capacity & resource planning
• Used Datapump, TKPROF, RMAN, VSU Snap, Netbackup, Netapps snap etc
• Usage of logminer to recover incase of no alternative left to flashback table & Setting up Disaster Recovery DB. Refreshed database in Development and Testing
• Extensively used materialized views, wrote scripts for automatic rebuilding of replication
• Prepared and Implemented UNIX shell scripts for automation of different administrative activities and notifications. Internal documentation on server performance monitoring
• Configured and scheduled different database related jobs through ESPX agent, also created the scripts for these jobs. Archival & Recovery management, Audit & log management
• View creation for audit purpose and to eliminate any dead locks in development environment
• Wrote Shell scripts for startup/shutdown, user / group / DB creation and file and folder permissions.

Confidential

Oracle DBA

Responsibilities:

• Analyzed business requirements and built logical data models that describe all the data and relationships between the data. Designed and implemented physical database
• Installation and configuration of Oracle 9iR2 10g (10.2.0.1) database server and their version up grades. Installation of Oracle Applications Release12 on HP-UX (Single User & Rapid Installation).
• Responsible for performance tuning. Extensively worked SQL tuning, database tuning and operation systems tuning. Used several utilities and tools to perform performance tuning & monitoring
• Applied patches, successfully upgraded Oracle. Worked on Storage, Network configurations.
• Developed PL/SQL procedures, assisted /supported dev team with database related issues.
• Designed and implemented Oracle RAC, Back up & Recovery. Tested and implemented disaster recovery plan and procedures. Responsible capacity planning, resource management (disk/space), high availability and fail over and other regular Database Administration tasks
• Extensively used RMAN. OEM, Data Guard, Rational Toad and several other DBA tools

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 10g (10.2.0.1) database server, application server (10.2.0) and LDAP server and their version up grades. Installed windows, Linux, Postgres 8.1, JBOSS etc
• Deployment of Confidential application on oracle 10g Application server (10.2.0), Linux, HP-UNIX.
• Designed Digital Gov Database includes Normalization of tables, creating of Tablespace, Schema, security privileges, database objects like synonyms, views, database, index etc
• Developed tool for migration and successfully migrated lotus notes to Oracle. Migrated data from oracle database to postgres8.1 using ora2pg tool. Developed tool to extract DMLscripts from table
• Designed and implemented Backup and Recovery. Extensively used RMAN.
• Responsible for Archival, Recovery management, Resource & capacity planning, audits and log management. Maintained DB scripts for various clients in MS-VSS server.
• Responsible for performance tuning. Tuned SQL queries, set parameters in init.ora & kernel, RAM and Memory for high performance, Created Index. Used Explain / TKPROF.
• Installation of oracle data guard to ensure high availability, data protection, and disaster recovery for enterprise data. Recovery management in switch over and fail over operations.
• Administration of physical and logical standby database.
• Created a batch file to install the whole database schema for Confidential application. Separation of master data (table and constraint creation), mandatory data (Organization model and ACL lists) and transactional data (client files and data). Created procedures to upload blobs into the database
• Used rational tool for benchmarking results, Glance plus tool for CPU info /server performance monitoring on HP-UX DB sever, zenoss for performance monitoring on Linux server.
• Developed shell scripts to automate several database administration tasks

Confidential

Oracle DBA

Responsibilties

• Installation, Patching, Configuration and Administration Oracle 10G /9i in windows and unix platform.
• Choosing different types of data storages (Locally Managed Tablespaces, IOT and partition tables) and indexes in order to have good performance for SQL and DML.
• Tuning Oralce9i database server using tools dynamic, dictionary views, Statspack, Utlbstat, Utlestat, Diagnostic and tuning packages. Created & Configured RMAN recovery.
• Backing up the production database, synchronizing the standby database by responding to any physical changes in the primary database.
• Day to Day General Administration (Tickets by PVCS Tracker):- Table-pace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Configured network for Oracle database with Tnsnames.ora and Listener.ora.
• Implemented Auditing the Database. Tuned the Slow SQL queries.
• Work as part of a team and provide 24*7 support when required
• Monitored DB Performance using STATPACK, TKPROF, SQLTrace, and Explain Plan.