Summary

Professional experience as Oracle DBA proficient in Oracle 9i/10g/11g Software installation, upgrade, Migrations, Database Capacity Planning, Automated Backup Implementation, Oracle 11g/10g/9i on Unix and Windows NT platform and Oracle Financial Application 10.7, 11i, 11.5.9. Including RAC, Enterprise Manager Grid Control 12c.

Highly motivated goal oriented team player with interpersonal skills

• Experience of working in 24x7 Production Environment.
• Experience in Oracle Enterprise Manager OEM , Erwin.
• Worked mostly with but not limited to Production servers along with development and testing servers.
• Expertise in installation and configuration of Oracle Financial and large databases on Linux Operation System.
• Usage of Datapump of oracle 10g 11g for exporting and importing logical data of the databases.
• Taking Hot and Cold backups using RMAN, along with Online and Offline backups and recovery Significant experience in using the RMAN and Flashback technologies for backup and recovery purposes.
• Proficient in use of Oracle Tools such as AD Utilities, SQL Plus, SQL Loader, SQL Net and Enterprise Manager and utilize data warehouse planning and management knowledge.
• Involved in multiple projects that required installing, upgrading and quarterly patching with the help of Opatch utility for the databases assigned under my applications.
• Experienced in taking cumulative and Incremental backups.
• Extensive experience in handled data migrations with the aid of expdp, impdp and RMAN utilities.
• Dealt with performance issues in previous projects, which involved managing the size of table spaces, redo log files and archived redo log files according to the production environment.
• Successfully delivered resolution ideas for critical database conflicts involving user roles and privileges, database network connectivity etc.
• Strong experience in creating user, roles, privileges, accounts and profiles in the database.
• Authoritative grasp on Oracle database architecture.
• Experienced in upgrading Oracle databases from 9i to 10g and from 10g to 11g.
• Experienced in upgrading Oracle Financial Applications 10.7 to 11.5.10, 11i to 11.5.9.
• Technical knowledge of AP, GL, HR, iProcurement, OPM and Purchasing.
• Experienced in effectively troubleshooting issues concerning network problems, instance startups, taking backups and recovering database files etc.
• Worked with PL/SQL procedures, cursors, functions, triggers, varrays.
• Excellent communication skills, a good team player and punctual in meeting project deadlines.
• Worked on multi platforms AIX, HP-UNIX, Sun Solaris, Windows.
• Knowledge over SQL Server 2000/2005/2008.
• Manage RAC environment for Day to Day Database administration, Performance Tuning.
• Add or Remove Node from Rac.
• Resolved/Diagnose Node Eviction.

TECHNICAL SKILLS:

• Hardware Platform : SUN Sparc Series, HP9000, IBM 7040-681, Pentium Servers and various PC.
• Operating systems : Red Hat Linux, Unix SUN Sparc Solaris 2.6/2.7/2.8,9, HP-UX 9.x, AIX 4.3, 5.1, 5.2, 5.3
• Windows XP/2000/NT/98
• Languages : SQL, PL/SQL, UNIX shell programming.
• RDBMS : Oracle 9i, 10g, 11g Servers, SQL Server.
• Tools / Utilities : ER Win, RMAN, OEM, Export/Import utility, expdp/impdp, SQL Developer, SQL
• Loader, ADI, Alerts, MS Office, TKPROF, WINSCP/PUTTY UNIX , VMware Tools.
• Software : Oracle Web Server, Oracle form Server, Oracle report, EMC.

PROFESSIONAL EXPENIENCE

Confidential

Oracle DBA

Perform DBA task such as Database Administration on Oracle 9i,10g, and 11g environments, Performance tuning, Schema creation, maintenance, and trouble shooting. Resolves database performance issues, database capacity issues, backup, replication, and other distributed data issues. Setup and manage RAC environments for our customers, Monitor, recommend and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity. Implement physical database changes, and performance reports. Maintain Oracle SQL and PL/SQL scripts, Unix shell scripts, debugging and tuning. Ability to pro-actively understand and manage end user/customer expectations. Provide best practice on new technology and implementations. Provides expertise and makes recommendations for physical database design, testing, performance tuning, and implementation of DB. Performance issues track and trend overall database performance and database area, index, and drive performance . Great experience applying patches and performing DB Migrations. Plan and Design Backup/Recovery solution using Shell scripting and RMAN. Ensure that the database software infrastructure is in place and up to date to support other infrastructure components e.g., operating system and hardware and application development.

Confidential

Oracle DBA

Upgrade Oracle Applications 10.7 to 11.5.10, 11i to 11.5.9 migrate from windows to linux. Migrated all Oracle 9i and 10g databases to 11gr2. Platforms include Windows, Linux, AIX, Solaris and Hp-UX sitanium. Setup RMAN solutions for all Oracle Databases created rman repository, wrote scripts for backup, integrated rman with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques restore and recovery. Recommend best practices for partitioning, scalability and monitoring. Served as Technical for Oracle 10g iAS environment consisting of Oracle core technologies including Oracle Portal, Oracle Application Server 10.1.2.3 and 10.1.3. Performed tasks in administration of databases including capacity planning, instance creation, performance tuning, storage management, backup and recovery and general troubleshooting. Configured shell scripts for job/process automation.

Confidential

Oracle DBA

Upgrading database to Oracle 11.2.0.2 from Oracle 10.2.0.2. Creating, configuring both standalone RAC databases. Installation, configuration of grid including ASM to provide shared storage to RAC databases. ASM administration including creating diskgroup, adding, dropping disks. Worked in 24x7 production environment and provide on-call and day-to-day support. Backup and recovery using Oracle's RMAN software used offline/online for recovery in a production environment via shell scripting. Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals. Helped team to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance. Changes were made dynamically whenever possible to fulfill high-availability requirements. Enforced need of regular data purging processes from production, design and fail-over purposes. Installation of RAC and Managing RAC Environment efficiently. Proficient in RAC Performance Tuning. Implementing and maintaining security create and maintain users, role and assign privileges . Database tuning, application Tuning performance monitoring. Fine tuning Initialization parameters, I/O, Memory. Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed. Monitored the production Oracle alert logs for database errors. Monitored system resource availability and responded to system memory and data issues.

Confidential

Oracle DBA Oracle Consultant

Installed and maintained Oracle Applications in complex environments such as Single-node and multiple-node installations. Upgrade of Applications from 11.5.9 to 11.5.10 on test servers successfully. Applied latest releases of patches to resolve few applications issues. Cloning the instances from production to test, development instance to test and simulate few technical challenges, coordinate with testing and development teams. Participate in a team to maintain and support for multiple oracle database and applications in high availability 24x7 heterogeneous environment. Worked closely with team including Applications development, database development, Oracle support, and business community. Installation of RAC and Managing RAC Environment efficiently. Performance tuning the RAC environment. Refreshing the test databases to a point in time as per the developers request using RMAN Duplicate. Creating services names for the newly created databases and updating the TNSNAMES.ORA file in other database with the entries of the newly created database. Monitoring the log file shipping for the physical standbys.

Confidential

Technical System Analyst

Responsible for day-to-day business application support including setting up user accounts and access, security, troubleshooting or debugging problems, providing technical supports and installation upgrades. Participate in the implementation of new projects such as project schedules, research evaluation, test plans, and system requirements. Support and assist Financial System users and security to ensure integrity, accuracy, and protection of systems. Update and maintain SQL Database on daily basis and responsible for importing data to Accpac and Excel. Develop, maintain, and access reports and ad-hoc reports such as month-end, daily sales, yearly budget, and forecasting using Crystal Reports, Excel and Accpac. Responsible for ongoing production support for daily and monthly financial activities by providing analysis, troubleshooting, and technical support for the business. This includes managing problems tracking and resolution with the vendors, and successfully supporting upgrades, testing, and system setup and configuration. Assist and support Financial and Accounting Dept. to participate in monthly and annual budget and forecasting process to ensure to work properly and correctly system.