We provide IT Staff Augmentation Services!

Sr. Oracle Database Administrator Resume

Warren, NJ

SUMMARY

  • Over 12 years of progressive experience in Database Technologies this includes extensive exposure to Oracle Database Administration (12c/11g/10g/9i), MS - SQL Server Administration ( 7.0/2000/20 ), Performance Engineering, System Analysis, Design, Development, Implementation and Support.
  • AWS Certified Solutions Architect - Associate with 2 years of working experience on cloud solutions using Amazon Web Services (EC2, RDS, IAM, Security Groups, VPC, and S3).
  • Experience in migrating the On-Premise Databases to AWS cloud infrastructure (EC2, RDS (Aurora))
  • Good working knowledge of AWS VPCs, subnets, peering between VPCs and hardware VPN configuration. Reduce attack surface by closing off inbound/outbound routes and ports.
  • Experience in configuring Shareplex Replication from Oracle to Amazon RDS (Aurora (mysql) as per project requirement.
  • Experience in troubleshooting, architecture analysis, design and implementation of Oracle and SQL-server databases for Telecommunications and Financial services. Experience in high availability (RAC/Data-Guard) production database maintenance and support (24x7).Extensive experience on implementing High Availability solution and Disaster Recovery Plan. Expertise in high-volume work environment with creative problem resolution capability.
  • In-depth knowledge of Oracle internal architecture, RAC, Data guard, Grid/Cloud Control, RMAN, OS and Hardware.
  • Experience in installation, configuration and administration of Oracle Database, RAC, Data Guard, 12c/11g Cloud/Grid Control (OMS/OEM), RMAN, ASM, GoldenGate, Shareplex, Oracle WebLogic, Operating Systems, such as HP-UX, Solaris, RHEL and MS Windows Servers, Virtual systems like VMware, Oracle Virtual Box (Oracle VM).
  • Implementation of High Availability solutions with Oracle 12c/11g/10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using GoldenGate/Shareplex.
  • Experience in GoldenGate/Shareplex Bi-directional/Uni-directional setup and production support for various applications.
  • Experience in installation, configuration and administration of SQL Server 7.0, SQL 2000, SQL 2005, and SQL 2008R2.
  • Handled Migrations of MS-SQL Server production DB’s from and R2.
  • Perform DRE (Disaster Recovery Exercise), backups and tested crash recoveries using conventional hot and cold backups and also RMAN utilities, cloning databases using RMAN and VERITAS Net-backup.
  • Skilled in developing RMAN policies, RMAN scripts for database backup including hot and cold backup operation for RAC, Data Guard and standalone instances using catalog and no catalog setup.
  • Experience in resolving issues related to day-to-day operation, Oracle DB installation, Upgrade and Patching.
  • Extensive experience in SQL tuning and understanding of business requirement/frontend application.
  • Expertise in RDBMS Tools like SQL Loader, Data Pump, RMAN, Toad, SQL Developer.
  • Extensive experience on 12c/11g OEM Cloud/Grid Control, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), SQL Tuning Advisor, Explain Plan, Database Auditing, Statspack.
  • Experience in Transportable Tablespaces, Oracle LogMiner, Data Pump, Flashback Table, Tablespace Management, and Materialized Views.
  • Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
  • A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
  • Excellent interpersonal skills and analytical skills.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g /9i, MS-SQL Server 7.0/2000/2005/2008 R2/2012.

Could Tools: AWS Services (EC2, RDS, IAM, Security Groups, VPC, DMS and S3)

Operating Systems: Solaris, HP-UX, Red Hat Linux and MS Windows 2000/03/08.

Languages: SQL, PL/SQL, UNIX Shell, Perl.

Oracle Tools: RMAN, OEM, TOAD, SQL*Loader, GoldenGate, Shareplex.

Hardware/Storage: Net App, EMC, VERITAS Net Backup, Tivoli Storage Manager (TSM).

Ticketing systems: HP service management, Remedy

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Sr. Oracle Database Administrator

Responsibilities:

  • Supporting, maintaining and managing 24X7 high availability multi node Oracle 12c RAC, Active-Active Data Guard and standalone databases including troubleshooting reported issues, implementing routine/ad-hoc change requests in production systems and DW databases.
  • Migrating the On-Premise Databases to AWS cloud infrastructure and Troubleshoot application workloads running on AWS infrastructure.
  • POC for Configuring Shareplex Replication from Oracle to Amazon RDS (Aurora (mysql)) using splex9.
  • Configure Amazon Machine Images (AMI), IAM polices and best practices.
  • Set up and deploy servers on multiple AWS availability zones and regions.
  • Identification of appropriate techniques and methods using various AWS services like Amazon EC2, S3, IAM to code and implement cloud solutions.
  • Real-time monitoring and alerting of applications deployed in AWS using Cloud Watch, Cloud Trail and Simple Notification Service to maximize resource allocations. Estimating AWS costs and identifying cost control mechanism.
  • Upgrading, applying CPU/PSU patches, deploying change and optimizing database design on production databases. Building staging database to validate pre-implementation procedure and new proof of concept.
  • Designing, planning and, building multi-node Oracle 12c/11g RAC environment with contingency Data Guard database
  • Supporting, managing and maintaining data synchronization and replication between multiple locations for large production Oracle database environments using GoldenGate / Shareplex.
  • Monitoring and/or, executing daily-nightly-weekly maintenance jobs, database backup and recovery policies using RMAN or, server scheduler (CRON), also monitoring, diagnosing, and responding to system failures.
  • Managing and maintaining 12c/11g Oracle Grid Control and Enterprise Manager (OEM). Installing OEM Agent on existing Oracle Server and register Management Agent to OMS to take the advantage of Grid component like database generated alert, SQL performance, Information Publisher, ADDM, AWR, auto email generation.
  • Performing database performance tuning by Defining and executing database performance and tuning scripts, and keep database running at optimal performance for business and operation workload.
  • Identifying and resolving locking conflicts, latch contention, rollback requirements for all database instances.
  • Creating and/or, refreshing development/QA/UAT databases from production database using either RMAN duplicate or, restoring from backups or, loading tables/schema using Data Pump (expdp/impdp).
  • Executing and documenting all database system-level changes, schema changes for all instances, data definition requirements for applications and developer schemas.
  • Maintaining consistent database parameters and system settings across all like instances; consistency must be maintained according to establish development to QA to production life cycle.
  • Developing and documenting Database Administration procedures that meet requirements and adhere to defined policies. Coordinating with Oracle My Support team to resolve trouble tickets. Also resolve database tickets and service request opened by end users.
  • Providing technical assistance and subject matter expertise to business/operation application developers, as well as coordinating with third party vendors on security guide lines.
  • Regularly participating in DBA team status meetings, application development and QA meetings as required and also providing database environments health, status and optimization reports to upper management.
  • Performed database upgrades & applied software patches to databases as per application/client requirements.

Environment: Amazon Web Serices(AWS),Oracle 12c/11g/10g RAC, Solaris, HP-UX, RHEL 5, GoldenGate, RMAN, SQL*Plus, PL/SQL, Oracle Grid Control (11g/12c), OEM, Data pump, Toad, AWR, ADDR, ASM.

Confidential

Sr. Oracle Database Administrator

Responsibilities:

  • Supporting, maintaining and managing 24X7 high availability multi node Oracle RAC, Active-Passive Data Guard and standalone databases including troubleshooting reported issues, implementing routine/ad-hoc change requests in production systems and DW database.
  • Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Environments) for various groups such as Developer, QA, Users etc and ensured the Availability of the Database Server in a 24X7 Environment.
  • Upgrading, applying CPU/PSU patches, deploying change and optimizing database design on production databases. Building staging database to validate pre-implementation procedure and new proof of concept.
  • Designing, planning and, building multi-node Oracle 11g RAC environment with contingency Data Guard database and adding additional node to existing Oracle RAC, also migrating standalone database to RAC.
  • Supporting, managing and maintaining data synchronization and replication between multiple locations for large production Oracle database environments using GoldenGate.
  • Installed and Setup GoldenGate between Oracle and SQL server.
  • Monitoring and/or, executing daily-nightly-weekly maintenance jobs, database backup and recovery policies using RMAN or, server scheduler (CRON), also monitoring, diagnosing, and responding to system failures.
  • Planning, leading and performing Disaster Recovery Exercise (DRE) on all Oracle production environments.
  • Managing and maintaining 12c/11g Oracle Grid Control and Enterprise Manager (OEM). Installing OEM Agent on existing Oracle Server and register Management Agent to OMS to take the advantage of Grid component like database generated alert, SQL performance, Information Publisher, ADDM, AWR, auto email generation.
  • Performing database performance tuning by Defining and executing database performance and tuning scripts, and keep database running at optimal performance for business and operation workload.
  • Identifying and resolving locking conflicts, latch contention, rollback requirements for all database instances.
  • Installing, configuring and maintaining Oracle Middleware WebLogic and Oracle Application Server.
  • Implementing data security on Oracle databases. Providing security administration including managing role and end user database permissions in accordance with policies. Executing authorization service requests.
  • Creating and/or, refreshing development/QA/UAT-demo databases from production database using either RMAN duplicate or, restoring from backups or, loading tables/schema using Data Pump (expdp/impdp).
  • Maintaining consistent database parameters and system settings across all like instances; consistency must be maintained according to establish development to QA to production life cycle.
  • Developing and documenting Database Administration procedures that meet requirements and adhere to defined policies. Maintaining documentation for all database instance parameters and system settings.
  • Coordinating with Oracle My Support team to resolve trouble tickets. Also resolve database tickets and service request opened by end users.
  • Providing technical assistance and subject matter expertise to business/operation application developers, as well as coordinating with third party vendors on security guide lines.
  • Regularly participating in DBA team status meetings, application development and QA meetings as required and also providing database environments health, status and optimization reports to upper management.
  • Performed database upgrades & applied software patches to databases as per application/client requirements.
  • Performed acceptance testing to verify that database changes perform without adverse consequences.
  • Developed, tested & implemented a robust database backup and recovery strategy as required.
  • Conducted root cause and analysis for database incidents and problems.
  • Created and administered SQL Server Replication - Snapshot, Merge and Transactional from SQL server to oracle databases

Environment: 11g/10g RAC, RHEL 5, GoldenGate, RMAN, SQL*Plus, PL/SQL, Oracle Grid Control (11g/12c), OEM, Data pump, Toad, AWR, ADDR, STATSPACK, WebLogic, ASM, MS-SQL Server 7.0/2000/2005/2008 R2/2012.

Confidential

Sr. Oracle Database Administrator

Responsibilities:

  • Specifying, designing, architecting, configuring, deploying, delivering, testing and maintaining multiple OLTP and ETL databases in production, development and staging environment.
  • Providing support on a wide range of administrative functions in Real Application Clusterware (RAC) environment, which included building, configuring, managing and troubleshooting Oracle 10g and 11g RAC running on Linux (RHEL5) and Windows (2008 Server) using ASM file system.
  • Developing guidance and strategy for Oracle RAC administration and development.
  • Building, configuring, maintaining and troubleshooting Oracle 10g and 11g Data Guard.
  • Creation, configuring and maintenance of GoldenGate Replication to a reporting system.
  • Installing, configuring, managing and, upgrading of Oracle Enterprise Manager (OEM)/GRID control tool for database monitoring, managing, configuring, load balancing, backup/recovery, sizing and space management, PL/SQL tuning, diagnosing.
  • Evaluating new version of Oracle Binary/patch levels and providing recommendations on system upgrades.
  • Supporting patches, upgrades, migrations to all project infrastructure software and tools, including the Oracle Database, Oracle Application Server
  • Perform cross-platform database migration between Windows and Linux using RMAN Cloning, Export/Import and, SQL loader.
  • Performing and validating various types of traditional and RMAN, cold/hot, full/0 and incremental/1 backups and restoration procedures.
  • Designing, deploying, validating and monitoring disaster recovery of Oracle database and instances for standalone, RAC and data Guard environment.
  • Establishing and maintaining sound backup and recovery policies and procedures.
  • Performing database and application performance tuning in production and/or, lower environment by periodically monitoring Oracle Enterprise Manager (OEM), Alert log, System Health, creating and/or, rebuilding the indexes to improve the performance, as well as trouble shooting if requires.
  • Enhancing Performance and Tuning databases by collected performance statistics, memory usage, transaction load analysis, data manipulation on physical/logical storage, network traffic, and implement/manage parallelism for optimum performance using Explain Plan, AWR, SQL Trace, Tkprof & Statspack, optimizing SQL and/or, PL/SQL code, etc.
  • Designing and implementing capacity plan and performance optimization using Enterprise Manager, DBMS SPACE PL/SQL package, by identifying bottlenecks in the system, e.g. CPU utilization, memory usage/leak, I/O bandwidth, disk space consumption, network traffic utilization.
  • Strong applied administrative knowledge of UNIX (HP-UX) and Enterprise LINUX Operating System.
  • Oracle service request opening, managing, and resolving at Metalink/My Oracle Support site.
  • Assisting with Audit request by providing requested information to internal and external auditors.
  • Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Environments) for various groups such as Developer, QA, Users etc and ensured the Availability of the Database Server in a 24X7 Environment.
  • Performed database upgrades & applied software patches to databases as per application/client requirements.
  • Performed acceptance testing to verify that database changes perform without adverse consequences.
  • Developed, tested & implemented a robust database backup and recovery strategy as required.
  • Conducted root cause and analysis for database incidents and problems.

Environment: 11g/10g RAC, GoldenGate, HP-UX, Linux 5, WINDOWS 2008, RMAN, SQL*Plus, SQL, PL/SQL, SQL*LOADER, Oracle Grid Control, OEM, Import/Export, Data pump, STATSPACK, MS-SQL Server 7.0/2000/2005/2008 R2/2012.

Confidential

Sr. Oracle DBA

Responsibilities:

  • Maintained, developed, and implemented policies and procedures for ensuring security and integrity of company databases.
  • Resolved database performance and capacity issues, replication, and other distributed data issues.
  • Provided solid technical solutions and supports for implementation and integration on various systems.
  • Managed multiple database environments (production, development, test, training, demo)
  • Performed data conversion and migration as required achieving corporate objectives.
  • Migrated to new releases of RDBMS -- from 9i, 10g and 11g.
  • Interacted with the development staff, business analysts and customers on several large projects.
  • Experience in automation to run reports off hours and in batches, delivering them to the necessary recipients via email to await them arriving in the morning. This saved employee time as well as removed workload against the database during working hours.
  • Created and managed ETL database for fault management and continuous performance monitoring of networking data, ETL procedures and reports to extract required information daily, weekly, monthly, half to 3 years of historical and forecast data.
  • Extensive data modeling was required to create not only the basic database but also to assist in the creation of the required reports.
  • Used a combination of triggers and stored procedures to audit all updates and deletes to any of the network data on the nightly ETL runs. Much of the ETL required trigger and stored procedure usage.
  • Setup the Grid and CRON job to monitor Database, servers, DAS and NAS.
  • Developed UNIX Shell Scripts for automating the loading, RMAN Backup.
  • Perform other DBA activities including space management and performance monitoring under various loads.
  • Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) and OS monitoring using SAR, VMSTAT, IOSTAT.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN, AUTOTRACE, STATSPACK, AWR and ADDM reports for performance issues resolution
  • Extraction of data from different flat files into Oracle Database using SQL*Loader and automated to prevent manual errors.
  • Installed, configured and maintained WebLogic and Oracle Application Server (OAS), and also deployed application using these web servers.

Environment: Oracle 9i,10g,11g, RMAN, OEM, ETL, RAC, Data Guard, Data Stream, Grid Control, UNIX (HP-UX), Linux (Red Hat), Java, Oracle Application Server, WebLogic.

Confidential

Sr. Oracle DBA

Responsibilities:

  • 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Configured hardware and installed Oracle 8i, 9i and SQL Server 2000
  • Designed and Configured the UNIX file systems for Oracle 9i and 10g RDBMS
  • Upgrade of Oracle databases from 8.1.7 to 9.2.0.4 to 10.2.0.4
  • Implemented RMAN with OEM as a backup Strategy
  • Created a separate Recovery Catalog on a 10g database and registered all other databases
  • Created scripts for hot backup on a daily basis scheduled with CRON jobs
  • Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
  • Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
  • Prepare documents of the process and knowledge transferring about the project to the new team members.
  • Created PL/SQL procedures (jobs) to automate maintenance tasks.
  • Database export/import using expand imp utilities. Data loads using SQL loader utilities.
  • Developed shell script to automate system and DB Background monitoring, log aging, DB Backup processes.
  • Coordinated with development team to solve the issues for new database enhancement releases.
  • Performed Database Administration activity like space management in database, user and roles administration, schema management, automated checking alert log of all the databases.

Environment: Oracle 8i/9i/10g, Windows Server 2003, RMAN, OEM, WebLogic, Data Guard, Java

Hire Now