Resume
Sign in
Email

Sr Developer/DBA

Location:
Hicksville, New York, 11801, United States
Salary:
80000
Posted:
December 28, 2011
Email:
g820jv@r.postjobfree.com
Contact Info:
*********@*****.***


NILENDU RAHA
ORACLE DBA
EMAIL ID : g820jv@r.postjobfree.com
CONTACT NUMBER : 516*******

PROFESSIONAL SUMMARY

• More than 7 years of strong experience in Oracle Applications as Oracle DBA and Oracle Apps.
• Current project daily responsibilities include only severity one production outage trouble shooting and restoring Oracle Applications components Apache, Forms, Reports, Concurrent Managers, Workflow Managers, Discoverer plus/viewer, iAS, Single Sign-on, DB recover & backup, corruptions, Short time performance issues, Standby DB issue, Netapps and sun filer issues, Writing Bash shell scripts to manages and support, manage and fix known issues, Arrange con call to monitor progress of critical production outage situation for esc top 25 customers.
• Good experience in maintaining, troubleshooting of 10g, 11g RAC (Real Application Cluster), also provided assistance with the installation of RAC on Linux environment.
• Expertise Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN (Recovery Manager), recover and test the backups regularly.
• Recognizing critical operations and knowing when to use careful planning and preparation, rather than action.
• A good understanding of network, multi-user access and locking issues.
• Good experience Implementation and troubleshooting of Oracle SSO/OID with Microsoft AD (Active Directory).
• Installation, configuration, maintenance, troubleshooting of Oracle E-Business Suite releases 11i/R12.
• Expertise in Expertise in troubleshooting of Notification Mailer and Workflow.
• Expertise in troubleshooting on critical Concurrent Manager Issues.
• Expertise in Oracle Database Maintenance, Administration and Performance Tuning using OEM (Oracle Enterprise Manager).
• Understanding of various most widely used RDBMS technologies and associated tools.
• Knowledge in Patching, Upgrading, Migrating, Cloning for Oracle DB 9i to 11g.
• Expertise in Managing user Accounts in databases as well as applications.
• Sound knowledge on Configuration and troubleshooting Data guard resolving archive gap resolution.
• Supported Production environment for Oracle database 9i, 10g, and 11g with database size of size 100G’s to 2TB.
• Good knowledge in creating and administrating database objects like Table, Views, Indexes, DB Links, etc
• Understanding and installation, configuration, and troubleshooting of Service Oriented Architecture (SOA) 11g R1 with the middleware technologies and using Oracle AS and BPEL PM for application integration.
• Provided support in the Installation, Maintenance, Upgradation of Fusion Middleware environment, monitoring its pre-requisites and providing support to customer for their production environment.
• Supported in SOA implementation, SOA cluster.
• Troubleshooting of Weblogic server, Apps server, SOA suite, BAM server, and monitoring the status of composites.
• Expertise in User Account management: Creating Users, Disabling users, Responsibility management for Oracle Database.
• Create and maintain Database Objects like Tables, Views, and Materialized views, Indexes, Constraints, Sequence, Synonyms and Database Link.
• Expertise in working with Netapp, Sun Filer for DB size of 2 TB.
• Expertise in maintaining several Database instances running on UNIX, Linux, Solaris, and AIX & Windows Servers.
• Performing Export & Import operations on databases.
• Expertise in Monitoring & Managing the Table spaces and data files growth
• Good knowledge in Monitoring locks and various sessions by OEM and SQL Queries using TOAD etc.
• Knowledge about No SQL, Cassandra.
• Experience working in OBIEE, DAC, Informatica in Production environment.
• Expertise in Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes
• Expertise in Backup and Recovery procedure which includes documenting the process
• Expertise in Regular checking of Alert log file
• Taking Export and Import using Data Pump when required.
• Expertise in Responsible for taking full cold database backup.
• Sound knowledge in Data upload using SQL* loader oracle utility
• Good knowledge of dynamic performance views in Performance Tuning.
• Experience in handling and Troubleshooting of Operating System, WINDOWS 95\98\2000\XP, UNIX, Linux, Solaris, AIX.
• Expertise in Providing support for the smooth functioning of the Database to developers

TECHNICAL ENVIRONMENT

Operating Systems Windows 95/98/NT/2000/XP,2003,2007,VISTA, UNIX (korn shell), Windows server 2003, AIX
RDBMS Oracle 11g/10g/9i (OCP), SQL Server 2003
Languages SQL, PL/SQL, C, C++.
DB Management Enterprise Manager Console
Tools/Utilities RMAN, OEM, SQL Navigator, Oracle Management Service (OMS), SQL*Loader, Export/Import, Data Pump, ODBC, Forms
Application Server 10gAS, 9iAS
Version Oracle EBS (E-Business Suite) – 11i & R12,Oracle 10g & 11g Database
Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK.
Web Language VB.NET, ASP.NET, XML

PROFESSIONAL EXPERIENCE:

Employer: Collasys Inc.
Client: Oracle Corporation (Oracle On Demand Command Center), CA
Period: From Sept'2010 to Sept’2011
Role: Oracle DBA
Environment: Oracle 10g, 11g, PeopleSoft, Siebel, Linux, AIX, Solaris

Responsibilities:

Worked as a Database Administrator in OnDemand Command Center. Command Center team specializes in expert level host system and application restoration to minimize outage downtime and maximize system availability. Command Center is also responsible for first level outage reporting, root cause analysis, and corrective action identification. Command Center develops and promotes long term solutions in the areas of operations process improvement, configuration management, and product enhancements to increase overall system reliability. The team develops, tests and executes (if needed) disaster recovery solution for OnDemand customers.

Day to day activities involves the following responsibilities,

• Supporting Oracle OnDemand Customers running various versions of Database (Oracle 8i, 9i, 10g and 11g) with database size of size 100G’s to 2TB.
• Oracle Applications (11.5.8, 11.5.9, 11.5.10 and R12.x), Tech Stack (Discoverer, IAS, Discoverer, JDK, Jinitiator, and Developer6i) and Oracle Application Server.
• Worked on outages on Forms issue for release (11i, R12).
• Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and staging OnDemand Customer environments.
• Supporting different products apart from EB-Suite are Siebel, Hyperion, Retail, PeopleSoft and many more.
• Expertise in working with Netapp, Sun Filer.
• Provided support in the Installation, Maintenance, Cloning, Upgradation of Fusion Middleware environment, monitoring its pre-requisites and providing support to customer for their production environment.
• Troubleshooting of Weblogic server, Apps server, SOA suite, BAM server, and monitoring the status of composites in Production and Non – Production environment.
• Experience in troubleshooting of OBIEE, DAC, Informatica in Production environment.

• Daily responsibilities include trouble shooting and restoring Oracle Applications components Apache,
• Forms, Reports, Concurrent Managers, Workflow Managers, Discoverer plus/viewer, iAS, Single Sign-on
• Identifying, analyzing and resolving technical problems related to Oracle software systems.
• Restore failed services; find workarounds to reduce business outage situations.
• Worked on multi-node RAC DB and mutli-node Mid-tier Apps.
• Performance tuning on DB and Applications.
• Physical and Logical primary/standby database issues.
• Provide 24x7 on-call support.

Name: New York Institute of Technology, Old Westbury, NY
Period: April’2008 to Dec’2009
Role: SQL Server 2003, E-Business Suite 11i, Oracle Fusion Middleware.
Environment: Windows server 2003, LINUX

Responsibilities:
• Installation, configuration, maintenance, as well as monitor the database (SQL Server 2003, Oracle 10g) in the central database. Maintained records for teachers, their schedules, personal details, student information and also administrative resources all stored in that database.
• Performed backup and recovery operations on a day-to-day basis.
• Installation, configuration, maintenance, troubleshooting of Oracle E-Business Suite releases 11i/R12.
• Experience working in OBIEE, DAC, Informatica environment.
• Installation of Fusion Middleware 10g, Weblogic Server SOA suite 1.
• Upgraded SOA suite from 10g to 11g.
• Monitoring Business applications by developing, designing and maintaining Fusion middleware environment, SOA suite (11g Release 1).
• Extensively engaged in troubleshooting several scenarios like DB out of space, temp file system is 100% full, tablespaces out of size, DB audit trail issue, DB has crashed.
• Worked under the supervision of my Professor taking care of Technical issues for the Management Department inside our campus.

PROJECTS

Project Title: Toyota Dealer, NY
Place: New York Institute of Technology
Period: From Jan'2009 to May'2009
Role: Oracle DBA.
Environment: Oracle 10g, Windows Server 2003

Responsibilities:

• Installed DB 10g and proficiently designed distributed database connectivity of 3 or more systems located in different places. Connected these systems by using DB Links.
• Monitoring the performance of DB by checking through dynamic performance views, Active session history also checking for the SQL statement tuning.
• Online backup of the database with or without using RMAN.

Project Title: Customer Support System, NY
Place: New York Institute of Technology
Period: From Sept'2008 to Dec'2008
Role: Oracle DBA.
Environment: SQL Server 2003, Windows XP

Responsibilities:

• Responsible for developing online customer support built on SQL Server 2003.
• Designed a database in SQL Server to store customer records, including purchase information. My role in this project was to develop the database in SQL Server which I did efficiently and I created all the tables, loaded it raw data. I linked all the tables to give it a normalized look.
• Designed front end using ASP.NET to make it work in live environment.

CERTIFICATION:

• Exam 1ZO-007 - Introduction to SQL - Oracle 9i – In this paper I have learned basic stuffs related to oracle database like SQL statements and its different operations.
• Exam 1Z0-031 - Oracle 9i Database Administration Fundamentals I –This is the most important section of this training program. Here we get a chance to know in complete details how an Oracle database works. How it utilizes the memory, its processes, backup operation, physical and logical structures of the database, how it stores records and how to manage users and its resources.
• Exam 1Z0-032 - Oracle 9i Database Administration Fundamentals II – This paper was completely on the different types of backup and recovery operation used in Oracle databases whether it is by using RMAN or even user managed. I was also able to learn about import and export operation using SQL Loader.
• Exam 1Z0-033 - Oracle 9i Database Administration Performance Tuning – This is the most vital section of each and every DBA. Here I got a chance to handle the Oracle database in my own hands. I could even tune the base according to my requirements. As I started working with the Oracle database I adapted myself to these changing requirements so that I never go out of memory space. I also learned how to tune the SQL statements, use TKPROF utility, and determine statistics about the database by using STATSPACK. There are also different dynamic performance views that actually help a lot to tune the database which actually helped me to work in future in my office as well as in my school projects. I also learned how to allocate resources to users or to a group of users. More importantly it was the ultimate training that I received to gain my knowledge regarding Database Administration.

Name of Company: NIIT, India
Period: Sept ‘2003 to Dec’2007
Role: Faculty, Oracle DBA
Environment: Oracle 9i, 10g, 11g, Windows XP, Windows Server 2003.
Industry: IT Training Industry.

Responsibilities:

• Have major role in the operations of our company. To be precise, our company used to deal with corporate clients all over India. So we used to keep track of all the records and the records used to
keep changing day by day. So in order to keep these records intact I installed Oracle 9i in that system. I then did one setup of the Backup in that system and have put several copies in different systems
excluding one in our Head Quarter. As we know that we can keep up to 10 destinations in oracle 9i so it was never a problem for me. Undoubtedly the database was large and we used to monitor it 24/7, writing RMAN scripts, performed root cause analysis.
• Install, configure, maintenance on Oracle 9i, 10g, 11g.
• Monitoring Business applications by developing, designing and maintaining Fusion middleware environment, SOA suite (11g Release 1).
• Worked extensively on Oracle Installation, Oracle Version Upgradation, and Migrations (from 8.0.7 to 10.0.1), also had to work on 9i in one of office branches to resolve performance related issues.
• Performed root cause analysis (RCA) and provided solution to them in numerous occasions.
• Handling fail-over issues for numerous situations.
• Responsible for coding in SQL and PL/SQL to aid developers whenever required.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS. I took participation as a trainer and trained people to become a successful DBA, a few of them are really working for companies like IBM, TCS.
• Trained students as well as corporate staff on entire Oracle 9i Database Administrator Track to Reliance Infocom, Steel Authority of India.
• Monitored and managed various database components (logical & physical) like tablespaces, segments.
• Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database.
• Knowledgeable in using OEM Features and worked with databases which have critical and BLOB data.
• Used TKPROF to find out tracing of which user has occupied more of the CPU time by executing longer queries, STATSPACK to find out the statistics of the database, worked on wait event based tuning, memory tuning, logical structure tuning, I/O tuning.
• Trained corporate staff on entire Oracle 9i Database Administrator Track at companies including Reliance Infocom and Steel Authority of India. I also have major role in the operations of our company. To be precise, our company used to deal with corporate clients all over India. So we used to keep track of all the records and the records used to keep changing day by day. So in order to keep these records intact I installed Oracle in that system. I then did one setup of the Backup in that system and 3 several copies in different systems excluding one in our Head Quarter. As we know that we can keep up to 10 destinations in oracle 9i so it was never a problem for me. Several times I used to query v$session_waits to find out if there is any user who is blocking the resources or not. Trained a couple of students who were working at US, came to India for a fast-track course as DBA.

EDUCATIONAL QUALIFICATION

Master of Science, New York Institute of Technology, New York, 2008-09
Bachelor of Engineering in Computer Science, Krupajal Engineering College, BBSR, India, 2000-04