Oracle Dba Analyst Resume
2.00/5 (Submit Your Rating)
SUMMARY
- Oracle DBA 11g certified Oracle Database / Administrator offering around 9 years of experience with over 8 years in IT Oracle 10g, 11g,12c and finance
- Enterprise Manager - RMAN- Backup & Recovery -Database Migration, SQL Server installation & Administration - Qualifications Oracle Database Administration oracle database administration - Unix shell scripting-System Administration oracle architecture and database Network Management -concepts Production Database Management Oracle Architecture & Database Concepts Quality Assurance Project Co-ordination.
TECHNICAL SKILLS
- Account management, SAP FICO, IT Audit, logistic armed forces, ASM, auditing database, redhat Linux Sybase database, SCAN, TAF
- database administration, and oracle 12c. Risk management, financial analysis, compliance, and audit risk technology
- firm wide stress testing and financial management. Administration, Database, Sybase Database Management
- Cassandra database management, Finance, hardware support, information technology, Linux, managing access, MOS
- Windows OS, Network Management, network, Oracle Enterprise Manager, Oracle, Oracle database, processes, Quality Assurance
- Relationship Management, scheduling, servers, scripting, SQL Loader, Strategic Planning, Sun
- System Administration, Tables, Technical Support, troubleshoot, Troubleshooting, upgrade
PROFESSIONAL EXPERIENCE
Oracle DBA analyst
Confidential
Responsibilities:
- Oracle 12c OEM for database monitoring.
- Working on financial database production server.
- Monitoring and troubleshooting SQL*Loader/PL/SQL Data Loads for Performance.
- Working in software development project teams and independently to accomplish the primary function of ensuring the uptime, performance, optimization, and security of all critical systems and ensuring a consistent strategy is used for the design of new systems and hosted environments.
- Advising developers and data modelers on design and optimization. In conjunction with the ACA PROJECT at the IRS, Support the development and maintenance of spatial database systems that support development, financial operations, and production and QA activities for Oracle 11gR2 single instances.
- Working with pluggable databases in 12c, and security compliance correction.
- Managing Cassandra database, managing database security and encryption through Authenticating, Authorizing and Auditing users. Creating and assigning appropriate roles and privileges to users depending on the user activity.
Oracle DBA
Confidential
Responsibilities:
- Responsible for Oracle 11g, oracle 12c, logical and physical database design, implementation, and maintenance. Reorganize databases and size database objects to meet standards and improve performance.
- Administered and managed 20+ RAC production databases of sizes up to 10TB in various datacenters.
- Performed migrations of Oracle 10gR2, databases from LDOMs (Oracle VM) to Oracle 11gR2 ASM databases. Monitored daily RMAN reports and created status update to the higher management. Performed database refreshes using RMAN and created standby databases. Managed multiple Data Guard Disaster Recovery and System Replication processes using Streams, ensured synchronization between the primary and standby database, and performed manual intervention when required. Configured and troubleshot Grid Control. Used customized templates to create the target databases based on the Oracle components installed in the source databases. Performed migrations as per client standards, regulations, security policies and procedures. Worked with the migration Team, Team Lead and Sys Admins. Coordinated the migrations with the Application Team and the Applications DBA. Performed validation reports comparing the source and target databases.and for CSSCAN on source databases for change in character set conversion upon migration. Create new databases, involving importing and exporting: installing and configure database software for Oracle application development environment. Provided a 24/7 availability and coverage of technical assistance through the use of emails and cell phones for mission critical Databases Handle database server tuning, application tuning, maintaining documentation, and Capacity planning and. Provided 24*7 support and report to the Operations Manager and the VP of Operations. Installed Oracle 10g cluster, ASM and database on Windows 2008. Assisted the application developers with performance issues and database change requests.
- Coordinated system maintenance with Support Specialists and System Engineers
Oracle DBA
Confidential
Responsibilities:
- Used RMAN to backup database.-Used Cassandra database. Worked daily on incremental backup, and weekly on full database backup. Used OEM to schedule backup. Handled disaster testing. Cloning and creating new databases using EM DB console. Configured and implemented data warehousing. Managed and monitored direct database access security, data integrity, enforcing constraints, and database privileges. Assist J2EE application developers and project managers in implementing best practice database security features. Configured and monitored the TNS Listener using Net CA, cost parameter. Used data Pump to implement database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation. Responsible for Oracle 11gR2 logical and physical databases design, implementation and maintenance on UNIX and NT. Patched and installed of Oracle software. Performed tuning using the AWR, ADDM ( adam') to guide tuning and maintain high database availability and reliability. Provided direct consultation and support to projects or application developers in the areas of database architectural design, database conversion, independent testing, application development and database administration. Documented the procedure for a Data Pump migration of source databases having encrypted data; Oracle Wallet
Business analyst
Confidential
Responsibilities:
- Identified new value sources by conducting industry and client research and Designed/administered business processes and systems. Facilitated deliverable transition between project life cycle stages and ensured that key project deliverables were effectively transitioned and placed under configuration management. Implemented quality management processes such as process and product quality assurance (PPQA) and other quality- related reviews (e.g., Quality and Process Improvement or QPI best practice reviews). Provided system architecture recommendations to reflect OFA Recommended RAID levels and STRIPE Sets. -Configured UNIX System kernel that is semaphore settings and shared memory. Developed Backup and --Recovery strategies using both RMAN and operating system scripts for Oracle databases supported. Recovered and refreshed databases made up of one terabyte of business data using RMAN. Utilized the automatic work load repository and automatic database diagnostic monitor. Configured and maintained data loads in huge Data warehousing systems using the Information Power Center ETL tool. - Supported data warehousing and databases. Performed troubleshooting and fixed Oracle internal database errors with support from Oracle support. Did security update and patch/bug fixes as recommended by Oracle Support.