Capgemini Consultant Oracle Database Administrator salaries in India

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

I am in Finance and haven't seen much work pressure here. They have more than enough FTEs to perform activites. Job security is good. Hybrid mode structure is there so one is not forced to come to office everyday.

Dislikes

...leave the organisation before years they have to pay training expenses of 2lacs. They also provide 50k of retention bonus after 2 years which is fully recoverable if you leave within one year of payout. CTC Structure of Capgemini very misleading and disappointing. Bonus, Gratuity are part of CTC which is unethical. 3 months notice period.

Likes

The team consistently demonstrates strong support and encouragement, creating a collaborative and inclusive environment that empowers individuals to take on new challenges and explore diverse opportunities for professional growth. There is a focus on personal and skill development, with leadership actively encouraging innovation and excellence. Moreover, the organization places a strong emphasis on team engagement, regularly scheduling well-organized activities that foster camaraderie and enhance team dynamics. This balance of support, growth, and team-building creates a motivating atmosphere where employees feel valued and inspired to excel.

Dislikes

While the organization provides a supportive and encouraging work environment, there is room for improvement in the area of compensation, specifically with regard to salary hikes and increments. These adjustments do not always align with market trends or adequately reflect the contributions and performance of employees. Addressing this aspect could further enhance employee satisfaction and retention by ensuring that compensation is competitive and rewards individual and team achievements appropriately.

Likes

Work culture Work environment Learning opportunities Work ethics Apart from work, there are various events and opportunities that helps to keep up a good work-life balance

Dislikes

Salary and no hikes. Growth opportunities Overall not good for a long term job Work politics