SUMMARY

• Certified Oracle DBA (OCA) and Information Security Analyst, with experience in Oracle, SQL server, DB2, Teradata and Sybase databases.
• Support platforms including; Active Directory, Shared folders, UNIX (Solaris, HP - UX, AIX), LINUX (Red Hat), IBM & Windows (2008 and 2012), in multiple environments.
• Strong analytical, organizational, multi-tasking, and prioritizing skills.
• Pay very close attention to details
• Excellent documentation skills
• Enthusiastic, creative and willing to assume increased responsibilities.
• Worked closely with other support teams including DBAs, Developers, System Admins, and Network admins to complete various assignments.
• Collaborate with Oracle my support by submitting Oracle SRs to resolve complex security incidents.
• Quick in learning new skills and working independently with limited supervision.
• Skilled in planning and executing time sensitive assignments and projects.
• Flexible in responding to the ever changing assignment, demands and a sound decision marker.
• Excellent communication skills, and the ability to work with customers, project managers, and team members of all different levels and skill sets to meet up with SLAs on current and planned projects.
• Experience in monitoring and maintaining database security and Auditing.
• Training and bringing new team mates up to speed and getting them used to the various environments.

TECHNICAL SKILLS

Databases: Oracle (9i, 10g, 11g, and 12c), SQL server (2008 and 2012), Teradata, DB2 and Sybase

Database Provisioning Tools: SSMS (Microsoft SQL Server Management Studio),IBM Security Guardium, Ca (IDM), Power Shell, Veronis, Rochade, Enterprise Access Manager, Oracle Vault, Service Now, CyberArk, Remedy (PAC2000), AD (Active Directory) TIM (Tivoli Identity Management), Triage, DSAM, Teradata Sql Assistant. SQL*Plus, SQL Loader, SQL Developer, DB Configuration Assistant) Toad, Putty, OEM Grid,RMAN, Exp/Imp Data Pump, Log miner, Statspack/AWR, Shareplex Top, DBCA, DBUA, OVD

Remote Tools: Cisco VPN, RSA, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, LDAP, OID rpt, TNS, Kerberos Authentication

PROFESSIONAL EXPERIENCE

Confidential - Charlotte, NC

Sr. Information Security Analyst

Responsibilities:

• Provision and De-Provision access to the following platforms Oracle, SQL databases, Active Directory and Shared Folder.
• Create Active Directory groups and manage access to and from these groups.
• Use Security Guardium to Monitor access to data sources, automate compliance controls, and protect sensitive data across multiple platforms ( such as databases, data warehouses, big data platforms, cloud environments, files systems
• Enable high visibility at a granular level into database transactions that involve sensitive data using Guardium
• Create Shared Folders and manage access to these folders using Veronis, AD, and PowerShell
• Manage access to CyberArk vault for privileged account security.
• Install and configure new C3 servers for Cyber security Operations
• Ensure compliance with existing IT security policies are met and develop new policies specific to Oracle and SQL Server Database
• Work closely with other Teams to configure Oracle EUS in centralizing the company’s Databases.
• Perform entitlement review and remediation for Oracle and SQL Server Databases.
• Updating the current database access procedures and developing new SOPs for the updated forms.
• Create, drop, alter, grant and revoke accounts, roles, privileges and security labels to users
• Provisioning and de-provisioning database access through Services Now Request and Incidents for users and services, using tools like Identity Manager and SQL Developer
• Working closely with customers and end users through emails, conference calls and Skype in identifying and resolving database access related issues.
• Actively working with DBA teams in developing Remediation policy and process to meet the company’s security standard.
• Working with other teams on getting more processes into automation tool such as the termination process.
• Enforces and maintains database constraints to ensure integrity of the database.
• Work with DBAs to identify and resolve complex database issues.
• Reports daily databases status on all the various environments in the SDLC.
• Troubleshoot and fixing failures within IDM and databases.
• Working with other teams in the configuration of the company’s new database inventory (IGC)
• Actively taking part in the testing and implementation of CyberArk
• Actively working with other teams in centralizing and standardizing accounts across all database platforms

Confidential - Charlotte, NC

Information Security Analyst / Database Admin

Responsibilities:

• Provision access to the following platforms Oracle, SQL, Sybase, Teradata, and DB2.
• Use CyberArk password vault for privileged account security.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• Provided instance level performance monitoring and tuning for Wait Events, Sessions, Physical and Logical IO and Memory Usage.
• Use Database Security & Access Management for certification of Oracle, Sql Server, DB2 and Sybase databases.
• Granting, revoking and monitoring access to Realm in Oracle Vault
• Protecting Applications, Objects and Users in the Oracle Vault by adding and making them owners in the Realm.
• Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose and also fail-over and switch-over processes.
• Attach and detach security policies to tables, schemas and applications using the Oracle Vault.
• Create, drop, alter, grant and revoke accounts, roles, privileges and security labels to users
• Provisioning and deprovisioning database access through services request (ACT/ART) for users and services, using tools like Tivoli Identity Manager (TIM), Putty, Sql Developer, Triage, MSSMS, Teradata Sql Assistant and the command prompt.
• Working closely with customers and end users through emails, conference calls and Lync in identifying and resolving database access related issues.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Enforces and maintains database constraints to ensure integrity of the database.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Proactively manages the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues, disasters from happening.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Establishes and maintains the appropriate time period for changing passwords.
• Maintains contacts with QA auditors and prepares reports for audit reports.
• Creating and submitting Pac2000 (BMG Remedy) Problem Tickets and Work requests to responsible support groups for database access related issues.
• Training and bringing new team members up to speed as well as getting them acquainted to all the environments.
• Working in collaboration with other DBAs to identify and resolve complex database issues.
• Identifying stale data within DSAM’s database inventory and submitting updates from other sources like the Triage tool.

Confidential - Atlanta, GA

Security Oracle DBA

Responsibilities:

• Maintains contacts with QA auditors and prepares responses to audit reports.
• Track activities of end users who access data indirectly through enterprise applications with the help of Guardium
• Automate the entire compliance auditing process, including creating and distributing reports as well as capturing comments and signatures using the guardium tool.
• Following DSAM’s policy in provisioning Oracle and SQL Server database users using SQL Developer, SQL Server Management Studio and TIM.
• Receives and creates Pac2000 (BMG Remedy) Problem Tickets and Work requests to responsible support groups for database access related issues.
• Training and bringing new team mates up to speed and getting them used to the various environments.
• Working in collaboration with other DBAs to identify and resolve complex database issues.
• Identifying stale data within DSAM’s database inventory and submitting updates from other sources like the Triage tool.
• Installed, configured, and maintained Oracle 10g, 11g and 12c on Linux and also Upgraded from Oracle 10g to 11g and 12c.
• Implements and enforces security for all Databases.
• Migration of database from one server to another server.
• Responsible for setup and implementation of 2 Node RAC in 10g, 11g and 12c.
• Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. And perform reviews on the design and code frequently to ensure the site standards are being adhered to.
• Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
• Assists with impact analysis of any changes made to the database objects.
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Done migration of non ASM database to ASM database.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• SQL tuning and Application Performance monitoring.
• Responsible for tuning of long running query’s by creating B-Tree and BITMAP indexes.
• Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.
• Enforces and maintains database constraints to ensure integrity of the database.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Performance Tuning i.e., Tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Oracle Grid Control Management Server Installation
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures for performance testing and future 10g production implementation
• Upgrade databases from Oracle 10g to 11g, Oracle 11g to 12c.
• Security patches for PCI compliances and also one-off patches for bug fixes
• Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose and also fail-over and switch-over processes.
• Verifying, troubleshooting and fixing data corruptions
• Clone databases for development and testing from production.
• Setting up Golden Gate replication
• Using RAT(Real Application Testing) to Capture production work load and replay in a test system and SPA(SQL performance Analyzer) - to identify performance divergence between workloads on source and target platforms.
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: Oracle 10g/11g, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, DataGuard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, and TKPROF, Toad, PL/SQL.

Confidential - Charlotte, NC

Oracle Database Administrator

Responsibilities:

• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Application of Oracle software patches when/where necessary.
• Create oracle databases on configured servers using both the DBCA & Database creation scripts.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Worked on application and database security (data access, passwords, network, etc).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Experienced in cloning the databases using HOT and COLD backups.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Backup/Recovery monitoring and reporting using Oracle RMAN
• Create database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.
• Database refresh from Production to Tech Test as needed.

Environment: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential - Mooresville, NC

Jr Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.

Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN