PROFESSIONAL SUMMARY:

• I am an accomplished Database Administrator and IT security expert with over 10years of experience with extensive knowledge and proficiency in database design, monitoring & tuning, Migration, Upgrades, Backup & Recovery, Cloning, Replication, and Security Implementations.
• I am also proficient in an assortment of technologies including Oracle 10g, 11g, 12c, and MS SQL Server.
• I also possess exceptional written, verbal, analytical and organizational abilities.
• Proven leader with motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions.
• An energetic achiever who can successfully manage multiple priorities and perform tremendously under pressure.

DATABASE MANAGEMENT PROFICIENCY:

• Database Security
• Database Upgrade and Migration
• Backup and Recovery using RMAN
• Data Pump and Export/Import
• Transparent Database Encryption
• Oracle Performance Tuning
• Patch Set Management
• MS WINDOWS (08,12,14)
• UNIX (Solaris 8/9/10)
• LINUX (Red Hat Enterprise)

TECHNICAL COMPETENCIES:

• MS SQL Server (SSMS)
• Excel
• Tableau
• SharePoint
• Oracle RAC
• Oracle Data Guard
• TOAD
• SQL Developer
• Oracle Enterprise Manager
• Oracle VM Virtual Box
• Salesforce
• T - SQL
• MySQL
• ETL (SSIS)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Provide administrative support and maintenance on Oracle 10g, 11g and 12c installations, database creation, database security, database optimization and tuning.
• Perform backup and recovery procedures using RMAN and Data Pump utility for Oracle databases
• Provide and maintain high availability and disaster recovery using ORACLE DATA GUARD.
• Monitoring and Troubleshooting database performance using OEM, AWR, ADDM, ASH, Explain Plan, and TOAD.
• Manage database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption (TDE).
• Implement Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.
• Apply Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances.
• Clone databases via RMAN and DATAPUMP utilities for various Database sizes.
• Extensively use AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.
• Setting up and managing RMAN, Hot and Cold Backups, Exports and Production database support
• Managing Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges
• Oracle Database performance-tuning services with EXPLAIN PLAN, AWR reports, ADDM
• Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases
• Work on several OLTP, OLAP, Enterprise Data Warehouse databases and provide 7x24 support
• Work with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data
• Establishing connectivity to databases and monitoring system performance
• Monitor AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace Files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports
• Implement table and index partitioning so as to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query
• Knowledge in PL/SQL programming
• OEM Monitoring for Databases - checking AWR/ADDM reports. Understanding ADDM reports finding. Running SQL tuning adviser against the query in the Databases.
• Checking top activity for system I/O, user I/O and other processes, monitoring SQL executions for Time & wait statistic, I/O statistic
• Part of support team for 24/7 on-call production support.

Confidential

Senor Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 10g, 11g servers and created databases in Linux environments.
• Researched, tested, and made recommendations of data validation tools.
• Established and implemented backup/recovery and patch scheduling as well as exported and imported databases frequently into the development and test environments and for archiving purposes.
• Created, tracked, and closed service tickets using REMEDY ticketing system and developed a defect prevention process including but not limited to root cause analysis and corrective action.
• Manage database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption (TDE).
• Implement Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.
• Controlled all databases with high alertness to ensure peak performance, stability and reliability and availability.
• Perform backup and recovery procedures using RMAN and Data Pump utility for Oracle databases
• Resolved locking issues, inconsistencies and assisted in batch processes.
• Assisted developers with SQL code troubleshooting as well as tweaked applications, procedures and SQL when necessary.
• Installed and administered GOLDEN GATE in a unidirectional, bidirectional, and broadcast configuration to mainly replicate data and ensure high availability, in a heterogeneous environment, also worked with EXADATA Machines for high performance and availability.
• Developed RMAN backup and recovery strategies and procedures
• Performed database patching for bug fixes, and mitigate security vulnerabilities
• Test recovery and support continuity of operations procedures
• Performed all aspect of database operations and maintenance (O&M)
• Monitor and tune Oracle database environments for improved system performance, ensure integrity and recoverability of Oracle database structures
• Work with Developer team to create interfaces for other Applications interact with Databases.
• Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, Reports and performance issues.
• 24x7 remote support and on call rotation

Confidential

Oracle Database Administrator

Responsibilities:

• Create databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
• Follow System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation
• Implement Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.
• Design and implement ETL utilizing PL/SQL and Talend Administration Suite.
• Manage database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.
• Perform instance tuning by changing init.ora parameters and managed region parameters such as shared pool size and db cache size with the use of AMM and ASMM.
• Install and configure the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replications
• Configure Oracle tools like SQL*Net to access the database across the network
• Configure and manage ASM instances on Oracle 11g and 12c.
• Worked in a cross functional team that oversaw the Oracle RAC installation and configuration for Linux environments.
• Extensive experience in Installation, Migration, Database Upgrade, Backup and Recovery, DR, RMAN, ASM, 10g RAC administration, data pump, performance tuning of Oracle Database
• Create and manage pluggable databases in the multitenant container database of the Oracle 12c architecture
• Experience migrating database objects from development through test and into production environments
• Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.
• Tune database for higher performance, analyze, explained and trace sessions for bottleneck queries, and configured instance optimal parameter setting
• Supported daily Database call for maintenance and administration such as performance, connections, locks, refresh data and security issues.