OBJECTIVE:

• Database Administrator committed to maintaining cutting edge technical skills and up to date industry knowledge with success in database design, performance, implementation and ensuring high availability, scalability and quality of databases.
• Adept at all stages of project lifecycle, from business requirements and technical definitions to testing, documentation, production support, training, troubleshooting systems and hand over.
• People oriented with leadership experience in both professional and volunteer settings.

TECHNICAL SKILLS

• Data Archiving
• Database Administration
• Database Administrator
• Database Modeling
• Database Design
• DDL
• Oracle
• Oracle 10g
• PL/SQL
• Replication
• SQL
• Stored Procedures
• WEB Database
• Database Development
• Linux
• RED HAT
• Shell Scripting
• Unix Shell
• Unix/Linux
• UX
• Disaster Recovery
• Encryption
• RMAN
• LOG File
• Backups
• Secure File Transfer Protocol
• SFTP
• SDLC
• System Analysis
• Remedy
• Service Level Agreement
• File Systems
• HP - UX
• Storage Management
• VM
• Change Control
• Project Development
• Project Lifecycle
• RDBMS
• Scripting
• Virtual Machine
• Security
• Data Warehousing
• Migrations
• OEM
• Estimation
• Optimization
• Remediation
• Performance Tuning
• Archiving
• Scheduling
• Production Environment
• Rebuild
• Security Policies
• Documentation
• Operations
• Metrics
• Audit
• Collection
• Loader
• Windows Server 2003
• Windows Server 2008
• Microsoft Office
• Architecture
• Integrator
• Integration
• Business Requirements
• Performance Management
• Cloning

PROFESSIONAL EXPERIENCE

Confidential

Snr Oracle Database Administrator

Responsibilities:

• Configured and maintained replication using Oracle Golden Gate.
• Planning Oracle Database projects assigning them to Confidential team
• Responsible for setting deadline for project deliverable
• Installed Oracle 12c, 18c and 19c Confidential environments on Red Hat 6/7
• Upgrade Oracle 11.2.0.4 databases to 12c, 18c and 19c Both Confidential and Single instance databases
• Providing Production support 24/7 and also part of on-call rotation
• Setting RMAN backups and Setting up OEM agents for monitoring
• Tuned SQLs using Oracle SQL tuning advisor
• Setting up Data Guard broker for production databases in different data centers for disaster recovery.
• Setting up scripts to monitor log gap between primary and standby in data guard env
• Installed, configured and Troubleshot Golden gate between Oracle databases
• Setting up bidirectional replication between Oracle and Oracle databases
• Experienced in Leading DBAs working with them and helping to create projects planning providing guidance both technically and also functionally to complete database projects
• Migrated databases from Oracle Confidential server to Oracle Confidential environments using Data Guard
• Tuned SQLs database parameters to improve application performance
• Working with Application SMEs to provide recommendations on database design, architectural design and capacity planning
• Provision and Support Databases on AWS Cloud Environment.
• Managing Oracle Databases on AWS RDS cloud environment.
• Migrating databases to AWS Cloud Environment.
• Performing Quarterly and Monthly Outage Activities in Production environment for system performance.
• Experienced in handling tickets related to blocking, performance issues.
• Involved in the complete SDLC, Database design, System analysis, design and development.
• Monitored the Performance of the migrated databases using Grid Control and features AWR, ADDM, ASH and generated the reports for metric collection and health check of the databases.
• Performance tuning and optimization of Oracle applications and databases (DB cache, Library catch, Dictionary Catch) AWR reports, SQL Trace, explain Plan.
• Identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.
• Monitoring and Maintaining Server uptime to ensure the least possible unavailability of the database to avoid downtime to the client.
• PSU patching application on all the environments (Both Primary and DR) as and when released by Oracle.

Confidential

Lead Oracle Database Administrator

Responsibilities:

• Configured and maintained replication using Oracle Golden Gate.
• Migration of large data Confidential clustered environment.
• Installed, configured Oracle 10G, 11gr2, and 12c on Linux, Sun Solaris and HP servers.
• Migration of standalone databases to Confidential and ASM.
• Hands on experience in creating application contest packages for VPD configuration
• Created login triggers to monitor users access in the database using VPD technology
• Created synonyms, objects and grants on security packages to users
• Created and applied security policies to VPD tables
• Implemented transparent data Encryption ( Confidential ).
• Used Confidential with Encrypted columns and Data Pump.
• Patching all EBS and DB patches in SIT, UAT and PROD instances including post patch analysis and owning the patch management.
• Clone of all Oracle EBS and DB instances from PROD to UAT and DEV
• Creating duplicate databases for RAT Testing, and moving databases from environment.
• Installation of TLS for database encryption and for PII Security data.
• Installed, configured and maintained Oracle 9i/10g/11g/12c Databases on Linux, UNIX and Windows Platforms.
• Involved in the complete SDLC, Database design, System analysis, design and development.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Installation and Configuration of 11g, 12c Grid Control.
• Installed OEM Grid Agents on UNIX, LINUX and Windows for monitoring of production databases.
• Implemented Oracle Database 11g/12c 2 to 4 node Real Application Cluster ( Confidential ) using Oracle Cluster ware for achieving high Availability on ASM.
• Setup and maintain RMAN backup and recovery strategy for Confidential and Single instance Databases.
• Worked on Oracle 9i to 10g/11g migration projects with low maintenance window and applied patches to various databases.
• Worked on OEM Grid Control 11g and OEM Cloud Control 12c and 13c scheduling and troubleshooting OEM jobs and deploying OEM agents.
• Scheduling Backup Jobs and troubleshooting failed jobs through OEM GC.
• Disaster recovery implementation using physical standby databases for high availability.
• Worked for Incident & Problem Management and Change Release Management to meet business SLAs (Service Level Agreement).
• Monitored the Performance of the migrated databases using grid Control and features AWR, ADDM, ASH and generated the reports for metric collection and health check of the databases.
• Work with software vendors and Oracle support to ensure all database and application related issues are resolve timely and efficiently.
• Performance tuning and optimization of Oracle applications and databases (Database Buffer cache, Library catch, Dictionary catch) AWR reports, SQL Trace, explain Plan.
• Identify problems and implement

Confidential

Oracle Database Administrator

Responsibilities:

• Experienced in setting up and configuring Uni directional Goldengate replication to a reporting system.
• Experienced in installing and configured Oracle Enterprise Manager (OEM) / Grid Control for monitoring and administrative tasks purposes.
• Experienced in database backup and recovery using RMAN, Data pump, Import and Export utility.
• Modifying database object’s structures as required by developers due to business or application requirements.
• Cloning of production databases to test environment for testing and training purposes.
• Experienced in Troubleshooting Golden Gate extract processes and Replication related errors(table ddl changes, remove/add tables between replication group) during code deployment and data refresh activities.
• Experienced in troubleshooting ORA-xxxx errors, adding data files to tablespaces during dataload operation if required.
• Supported, maintained and troubleshooting Oracle Golden Gate for data replication and high availability databases.
• Debugging Golden Gate replication issues such as Abend.
• Sending daily operational report to the top management regarding the whole operation of the day, including any hitches and unusual situations.
• Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems, I/O hardware performance problems etc.
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.
• Administering and maintaining databases including daily monitoring and performance analysis using Stats pack, ADDM, AWR Report etc.
• Gathering and analyzing AWR report for troubleshooting purposes.
• Working with other IT professionals for database designs and reviews troubleshooting database issues, and deploying timely fixes maintaining regular and proactive database patches, updates and performance enhancement.
• Enhancing SQL statements performance using Explain Plan and Oracle optimizer hints
• Ability to manage high availability solution centers using Oracle Real Application Clusters ( Confidential ) with several nodes.
• Creating database that meet the constantly changing requirement and need of the company and clients.
• Configuring the Oracle Network environment including Oracle Net Services and Listeners, configuring and managing oracle network.
• Developing SQL scripts to carry out routine checks on databases.
• This include checking if the Listener is running, optimal running of all databases, Unix error messages, disk space availability etc.
• Experienced and participated in shift rotation and on-call 24/7.

Confidential

Oracle Database Administrator

Responsibilities:

• Experienced in setting up and configuring Uni-directional Goldengate replication to a reporting system.
• Experienced in installing and configured Oracle Enterprise Manager (OEM) / Grid Control for monitoring and administrative tasks purposes.
• Experienced in Troubleshooting Golden Gate extract processes and Replication related errors(table ddl changes, remove/add tables between replication group) during code deployment and data refresh activities.
• Cloning of production databases to test environment for testing and training purposes
• Experienced in troubleshooting ORA-xxxx errors, adding data files to tablespaces during dataload operation if required.
• Supported, maintained and troubleshooting Oracle Golden Gate for data replication and high availability databases.
• Debugging Golden Gate replication issues such as abend and performance enhancement.
• Enhancing SQL statements performance using Explain Plan and Oracle optimizer hints
• Ability to manage high availability solution centers using Oracle Real Application Clusters ( Confidential ) with several nodes.
• Creating database that meet the constantly changing requirement and need of the company and clients.
• Administering and maintaining databases including daily monitoring and performance analysis using Stats pack, ADDM, AWR Report etc. Gathering and analyzing AWR report for troubleshooting purposes.
• Working with other IT professionals for database designs and reviews troubleshooting database issues, and deploying timely fixes maintaining regular and proactive database patches, updates Configuring the Oracle Network environment including Oracle Net Services and Listeners, configuring and managing oracle network.
• Developing SQL scripts to carry out routine checks on databases.
• This include checking if the Listener is running, optimal running of all databases, Unix error messages, disk space availability etc.
• Experienced in database backup and recovery using RMAN, Data pump, Import and Export utility.
• Modifying database object’s structures as required by developers due to business or application requirements.
• Sending daily operational report to the top management regarding the whole operation of the day, including any hitches and unusual situations.
• Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems, I/O hardware performance problems etc.
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.
• Experienced and participated in shift rotation and on call 24/7.