DBA, SQL Mumbai : SK International Pvt Ltd

[mariammal]

Jr. DBA , SQL
The candidate should have -
[LIST][*]Extensive knowledge of Relational Database Management Systems and Service pack installation strategies.[*] Experience in Implementation, Administration and Support of MS SQL Server 2005, 2000, 7.0 in Production, Test and Development Environments.[*] Expertise in Query Optimization, Performance Monitoring, Security Administration, Trouble Shooting and using DBCC utilities.[*] Implemented Log Shipping, Replication Models, OLAP and Linked Servers.[*] Should have basic knowledge of Oracle Administration.[*]Familiar with Concept of clustering.[*]Candidates with certification (MCDBA) will be preferred.[/LIST]
Please email your detailed resume along with a scanned passport sized photograph to jobs@skinternational.com

About as
S.K. International is a leading systems integration, technology services and consulting company. It was founded with the belief:
[LIST][*]To do things differently by delivering out of box technology driven business solutions & services;[*]To be a trusted & reliable partner of our clients by helping them to be more responsive to their customers & shareholders and successful in their competitive industries and[*]To conduct our business in a socially responsible & ethical manner.[/LIST]
Contact us
SK International
SK House,
94-A, Avval Baug,
DSP Road,
Dadar (East),
Mumbai 400 014.
India.

Email: info@skinternational.com

[Guest-IJT]

Name : bh.sandeep1 AT gmail.com
Email : bh.sandeep1 AT gmail.com
Designation / Skillset : Oracle Apps Dba

Resume :

OBJECTIVE :
Challenging position as a Database and Oracle Applications Administrator in a growth-oriented Company utilizing my abilities developed through my education with an opportunity for career growth on my merit and to promote the growth of the organization.
PROFESSIONAL SUMMARY :
- A competitive professional having 2+ years of experience in Oracle Apps DBA and as well as core DBA.
- Currently associated with DynaSoft, Bangalore from May 2009 to till date.
- Had exposure to RMAN and R12 environment.
- Excellent working skills with installation, cloning, maintaining concurrent managers, Patching, User management issues and space management issues related to Oracle Applications
- Involved in tasks like performing Pre Patch Analysis for the requested Patches, preparing Patching Plan Document for patching activity and successfully executing the patching activity.
- Familiar applying database and tech stack patches.
- Sound knowledge in AD utilities like adpatch, adadmin, adctrl, etc.
- Experience in performing Sysadmin Activities like Creating Users,Creating Responsibilities & Assigning Responsibilities.
- Creation of Concurrent Mangers and assigning work shifts.
- Troubleshooting patching and Apache issues.
- Cloning Oracle Applications using Rapid Clone Utility.
- Used Oracle Utilities like export/import.
- Had a good knowledge of Physical Backup’s like COLD and HOT Backup, Restore and Recovery at different scenario.
- Upgraded the Databases from 9i to 10g.
- Have a basic knowledge on Upgrading the Applications from 11.5.10 to R12.
- Monitoring alert log and trace files.
- Monitoring Alerts and table space growth proactively.
- Strong presentation, analytical, statistical and problem solving skills.
EDUCATION :
- Bachelor of Technology (B.TECH)
Major : Computer Sciences.
Jawaharlal Nehru Technological University 2009
SKILLS :
Platforms Windows 9x/XP/ NT 4.0/2003, Linux AS 3.0/4.0
Database Oracle 9i, 10g & 11g.
ERP Applications Oracle Applications (11.5.9, 11.5.10, R12)
Languages SQL, PL/SQL ,C
Tools & Utilities Putty, OAM, SQL Loader, EXPORT/IMPORT.
Project #1 :
Customer : Sabic Innovative Plastics
Role : Oracle Applications DBA
- Responsible for the support and maintenance of the multiple oracle databases and applications in high availability (24*7) heterogeneous environment.
- Participating in customer calls and ensuring all requirements are documented.
- Had exposure to RMAN environment and R12 instances.
- Cloning of Oracle Applications using Rapid Clone Utility.
- Used AD administration utilities (adpatch, adadmin, adctrl).
- Applying database patches with Opatch Utility
- Used FNDCPASS to change passwords
- Creating users, roles, Profiles & assigning roles, Profiles to users.
- Monitoring the log files Pro-actively to forecast issues.
- Provide Technical Support and Assistance to all Database and Users
- Checking the status of important services like concurrent manager, form server, web server, application listener, database listener etc.
- Tracking invalid objects, Compiling and validating the invalids
- Trouble Shooting both Application and Database issues.
- Databases refresh Activity Manually.
- Ensuring successful and periodical backup, Restoration.
- Relinking and regeneration of application objects using adadmin
- Creation of DBlinks from Production to Test and vice versa
- Creating users and assigning responsibilities to users.
- Creating concurrent managers and assigning workshifts
- Managing the Concurrent Managers and its operations like starting, stopping the concurrent
- Managers, re-schedule the requests, purging the concurrent requests historical data
Project #2 :
Customer Type : Ingersoll Rand Security Technologies.
Role : Oracle Applications DBA
- Changed the configuration Parameters as per the Customer requirement and Bouncing Applications /Database if needed.
- Changed the Profile options in Site/Responsibility/Application/User Level.
- Used adutilties like adpatch,adctrl,adadmin etc.
- Relinking and regeneration of application objects using adadmin.
- Creating and assigning appropriate roles and privileges to users depending on the user activity.
- Granting and Revoking Privileges/Roles from Users.
- Regular system health checkups.
- Tracking invalid objects, Compiling and validating the invalids.
- Creation of DBlinks from Production to Test and vice versa
- Monitoring alert log and trace files.
- Monitoring Alerts and table space growth proactively.
- User access control and administration
- Used Oracle Utilities like export/import.
- Worked on Physical Backup’s like COLD and HOT Backup.
-------------------------------------------------------
More Information about this submission and submitter :-
___________________________________________________
Submission ID : 4395647
Date & Time : 21st Jul 2011 7:56 AM (UTC)
IP Address : 122.169.212.115
Browser Info : Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0
Predicted Country []: India