Karmakar - Oracle Database Administrator - Kolkata, West Bengal, India

Nimai Karmakar

Kolkata, West Bengal, India

Summary

Never Say Never....

Services

Oracle Database Administrator

Summary:

Highly accomplished deeply driven, senior-level Oracle DBA and Oracle Database & Applications Servers administration. With a successful more than 4 years 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.

Work History

Oracle DBA

BEAS Consultancy And Services Pvt. Ltd.

April 2013 - May 2013

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.

Oracle DBA

Tata Consultancy Services

From June 2013

Support of a large mission critical manufacturing application database based on 11g database system for client West Bengal Commercial Taxes on Oracle Extended RAC servers. Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent enterprise manager administration. Duties included database creation, database tuning/reorganization, backup/recovery, general troubleshooting. Delivered regular updates to seniors on database system status.

Oracle Database Administrator

Ingenious Minds Consultants

December 2012 - April 2013

Implementation, design maintenance, and support of a large; mission critical manufacturing application for NITS Solutions based in U.S.A. , with Oracle database 11g database system for NITS 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

CMS infosystems pvt. ltd.

May 2009 - December 2012

Work as a Oracle 10g DBA for RAC on windows and dataguard on windows as well as on linux.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.

Projects

Oracle Support

 Support of 5 Oracle 11g(11.2.0.1.0) Production database server with monitoring and installation 5 Oracle 11g Applications Server (Oracle Apex) and 2 Oracle 11g Test Server on Amazon Cloud Environment.
 Configuring, installing and administrating Oracle Database and Oracle Apex (Application Express) on Redhat Linux Server, Ubuntu Server.
 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.
 Have to resolve the error and to give solution on Ticket Raised from clients within the time limit.
 Linux Open Source Installation on the servers like Glassfish 3, Nagios, Apache-Tomcat and many more .
 Backup including Physical (Hot/Cold backup) & logical backups like Rman & EXPDP/IMPDP on Amazon cloud storage(S3 backup/restore) through Linux Shell Scripts

SREI group

 Support of Oracle 11g(11.2.0.1.0) Production database server with on RAC environment.
 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.

NITS Solutions (United States Of America)

 Support of 5 Oracle 11g(11.2.0.1.0) Production database server with monitoring and installation 5 Oracle 11g Applications Server (Oracle Apex) and 2 Oracle 11g Test Server on Amazon Cloud Environment.
 Configuring, installing and administrating Oracle Database and Oracle Apex (Application Express) on Redhat Linux Server, Ubuntu Server.
 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.
 Have to resolve the error and to give solution on Ticket Raised from clients within the time limit.
 Linux Open Source Installation on the servers like Glassfish 3, Nagios, Apache-Tomcat and many more .
 Backup including Physical (Hot/Cold backup) & logical backups like Rman & EXPDP/IMPDP on Amazon cloud storage(S3 backup/restore) through Linux Shell Scripts.

Birla Tyres Unit –II, Laksar,Uttarakhand

 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.

Check Post Management System (North Tripura

 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.

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

• 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

Qualifications & Certifications

Bachelor Of Science (Information Technology)

Sikkim Manipal University

subhash smarak inter college

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?