Capgemini Oracle Database Administrator salaries in Gurgaon / Gurugram

Likes

Firstly i will say about the team As a dba if this your first job mostly you will work in L2 team and here you will many things but you will not get time to learn new things so after completing two years need to switch to l3 team or outside. I have worked for good clients within l2 team. 1. User management 2. Tablespace management 3. Stop and start db including rac database also 4. Logical thing bkp Schema refresh expdp /impdp and table schema and full db backup by this. 5. Patching on non rac db with standby 6 Solved Performance issues faced by application team( query optimization, stats gathering index rebuilding long running queries Awr and ash report, run sql tuning advisory At last also raised sr with oracle support they have suggested to change or increase the value of db parameters like sga and pga etc 7 Guaranteed Restore point creation testing work for apps team and rollback by using this. 8 solve sync issues as rfs not working due to various reasons like fra full, standby file management manual , password file change standby down. 9 restoration of db with rman and active duplicate method 10 upgrade the db with traditional way 11 rman bkp configuration and schedule with crontab using rman catalog db 12 Job security is good. If you get dba job please do if you are not interested in coding or development areas. Because here no coding required. For oracle dba kindly learn medium level In sql knowledge of ddl dml tcl dcl dql and object level knowledge because it will help while taking schema bkp. Basic linux commands. df - h ( filesyetem) ps - ef | grep pmon ( show db which are running) Kill - 9 id or kill -9 child id parent id rm -rf ( delete) mv ( move or rename) top to check the top process which are running free -gt to check the memory tnsping dbname After environment set use below command sqlplus / as sysdba -- this is the command to connect with database with sys user through password file because sys password store in this file that is why we use / For remote check Sqlplus username/password@servicename

Dislikes

Salary should be increased as current time.

Likes

...d company to work with. Work life balance is good. Learning & training are nice. Salary growth is low. Work environment is very impressive.

Dislikes

Nothing to learn new things in my project. Salary growth has very disappoint me.

Likes

Culture and team work and support but it's depend on team to team.

Dislikes

Low salary hike, Rating and Promotion is very low and you will be strictly asked to work from office no matter what other wise don't expect rating and you will get mail from hr department directly like they will take some strict action and you if not come.

Likes

Nothing

Dislikes

... and junior managers don't know how to talk with new joiners or with employees. Hr's and manager are too confused about job role and salary/ location discussion. At first they agree on everything but once you joined they company they deny on everything that has been discussed earlier even if it's on mail ..and put you on bench and after 6 months asked you to leave due to bench period over or you are not able to be billable. Also your probation with not be confirmed and having said that they will kick you out of the company. Even if you complain to HR about the issues. So if you want to stay in this company don't stand for your rights and just stay as per them because manager and HR ...they can change policy anytime as per their convenience and ask to to obey otherwise there will be termination which leads to no job security in this company.

Likes

Capgemini has a good work life balance. Offers many financial offers like leasing of cars and many more options. Capgemini offers more on-site opportunities for the employees. The Hybrid policy is more flexible than focusing on the number of hours in the office. Have plenty number of offices in major locations in India so one could relocate easily within country.

Dislikes

The pay and compensation is way lower than any competitor in the Service based sector. After being for 3+ years just 15% is hiked till now on total compensation on what I have joined the organisation.