Karmakar - Oracle Core DBA - Kolkata, WB, India

Nimai Karmakar

Kolkata, WB, India

Services

Oracle Core DBA

Work History

Oracle Database Administrator & Server Administration

BEAS Consultancy and Services Pvt. Ltd

April 2013 - July 2013

Project: PWC project for SREI group

Role & Responsibilities
Implementation, design maintenance, and support of a large; mission critical manufacturing application for the client Price Waterhouse Coopers India, with Oracle database 11g database system for SREI GROUPS. Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration & Linux open source installation. Duties included database creation, database tuning/reorganization, backup/recovery, general troubleshooting. Delivered regular updates to upper management on database system status, Collaborated with business analysts and development teams in design and deployment for better outcome of the business.


* Support of Oracle 11g(11.2.0.1.0) Production database server with on RAC enviorment.
* Automated various db monitoring tasks, such as instance availability, backup completion, disk space usage, db job executions wrote in Shell Scripts via Cronjobs, and other error conditions.
* Involved in capacity planning and resource planning.
* Identified performance bottlenecks using precise and provided resolutions.
* Performed all aspects of Database and Application Server administration including DB Server setup, user creation, installs, builds, upgrades, object sizing, object creation, backup/recovery, monitoring, and export/imports.
* Sizing database objects for effective space management and optimal performance.
* Create users & Assigning Roles and Privileges.
* Backup including Physical (Hot/Cold backup) & logical backups like Rman & EXPDP/IMPDP on Tape drive through Linux Shell Scripts.

Oracle Database Administrator & Server Administration

Softech Solutions

December 2012 - April 2013

Implementation, design maintenance, and support of a large; mission critical manufacturing application for Commercial projects based in U.S.A. , with Oracle database 11g database system for clients like AUDI,VOLSWAGEN,VOLVO, etc.. Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration & Linux open source installation. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting. Delivered regular updates to upper management on database system status, Collaborated with business analysts and development teams in design and deployment for better outcome of the business.

Oracle Database Administrator, SYSTEM Admin

CMS Info System Pvt. Ltd

June 2012 - December 2012

Project: Birla Tyres Unit -II, Laksar, Uttarakhand
Role & Responsibilities
Implementation, design maintenance, and support of a large; mission critical manufacturing application for Birla Tyres Manufacturing Plant with multiple version of Oracle database 10g database system. Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting. Collaborated with business analysts and development teams in design and deployment of relational databases.


* 24/7 Database support of Oracle 10g(10.2.0.1.0) database.
* Configuring, installing and administrating Oracle Database server on Linux Server.
* Various db monitoring tasks such as instance availability, backup completion, disk space usage, db job executions, and other error conditions.
* Involved in capacity planning and resource planning.
* Identified performance bottlenecks using precise and provided resolutions.
* Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, monitoring, and export/imports, backup schedule through Shell scripts using cronjobs(linux utility).
* Sizing database objects for effective space management and optimal performance.
* Assigning Roles and Privileges.

Oracle Database Administrator

Ingenious Minds Consultants

From January 2012

Oracle Database Administrator

CMS Info System Pvt. Ltd

May 2010 - June 2012

Projects Details (Check Post Management System (North Tripura) )

Role & Responsibilites
Implementation, design maintenance, and support of a large; mission critical manufacturing application for Tripura - Assam Checkpost with Oracle database 10g system over windows 2008 standby server. Responsible for installation, upgrades, database tuning, concurrent manager administration and cloning. Duties included database creation, database tuning/reorganization, backup/recovery, general troubleshooting. Collaborated with business analysts and development teams in design and deployment of relational databases.

* 24/7 Database support of Oracle 10g(10.2.0.4.0) database.
* Configuring, installing and administrating Oracle Database on Windows Server 2008.
* Automated various db monitoring tasks, such as instance availability, backup completion, disk space usage, Schedule jobs, and other error conditions.
* Involved in capacity planning and resource planning.
* Identified performance bottlenecks using precise and provided resolutions.
* Performed all aspects of database administration including installs, builds, object sizing, object creation, backup/recovery, monitoring and export/imports, apply security patches.
* Sizing database objects for effective space management and optimal performance.
* Assigning Roles and Privileges.

Oracle Database Administrator

CMS Info System Pvt. Ltd

February 2010 - April 2010

Projects Details (Central Railway Information System (CRIS), Kolkata in COA project )

Role & Responsibilities
installation, configuration and administration of several Oracle server releases across multiple platforms, Planned and executed multiple server upgrades and migrations. Coordinated capacity planning through in-depth trend analysis, Calculated space utilization and application growth, and projected database sizing. Initiated and executed disaster recovery and backup initiatives. Delivered regular updates to upper management on database system status, Collaborated with business analysts and development teams in design and deployment of relational databases from legacy data facilitated.
• Oracle 10g RAC Database support with ASM and RMAN at Indian Railways at Kolkata, West Bengal.
• Upgrading Oracle 10.2.0.1 to Oracle 10.2.0.4 with full RMAN and disaster server.
• Working in RAC environment and well versed with it.
• Creating new databases and installing in new servers.
• Configuring oracle net manager to interact with client machines.
• Administering the database by maintaining the control files, redo log files, managing tablespaces, managing indexes etc.
• Create new database users as required.
• Manage sharing of resources amongst applications and users.
• Granting roles to users.
• Administers all database objects, including tables, indexes, views, sequences etc.
• Rman, backup (hot and cold backup of databases).
• Database refresh
• Well versed with export and import and Expdp and Impdp.
• Giving support to the development team.
• Performance tuning.
• Initiating, testing and implementing of the ASEB MIM software which works as a front end to the oracle database.
• Troubleshooting Application

CMS Info System Pvt. Ltd

April 2009 - December 2012

(3.5 years) www.cms.com

Projects under CMS INFO SYSTEMS PVT. LTD.

Associate Customer Support

CMS Info System Pvt. Ltd

April 2009 - January 2010

Projects Details (HPGAS(HPCL) Kolkata, West Bengal)
Role & Responsibilites
To give support to my team over the remote and to attend site when needed for Database support such as data lost, data recover, Client data migration from FoxPro to sql and for that rectify the errors in FoxPro database.

Oracle Database Administrator

CMS Info Systems

January 2009 - January 2012

Projects

Experience as Core Oracle DBA

Highly accomplished deeply driven, senior-level Oracle DBA and Oracle Database & Applications Servers administration. With a successful more than 3 year track record of success in -depth technical acumen and extensive experience spanning progressive accountability in launch and administration of enterprise database infrastructures. A challenging position as an administrative assistant at a growth-oriented firm, which will allow me to both further utilize my skills and acquire new abilities. Willing to work as a key player in challenging and creative environment.

Qualifications & Certifications

Siikim Manipal University

Media Infotech undertaking of Sikkim Manipal University

Allahabad Board of Higher Secondary Education

Subhash Smarak Inter College

Allahabad Board Of Secondary Education

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more


Are you sure that you want to leave?

   
Supported Countries
Choose your country

×