Pabitra Mohapatra

Experience

• 

  NEXTECH POWER SOLUTIONS LIMITED

  Jan 2011 - Jul 2013

  Software Engineer

  • Create databases, configuring them to meet developer and user requirements. • Use the range, and list partitioning keys to partitioning large tables. • Install client side of Oracle on developers and end user’s PC and configuring them with network connections. • Use SSH and Remote Desktop to remotely administrating Oracle databases. • Creating tables and views for developer and client needs. • Manages and maintains the data dictionaries. • Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN. • Monitors database activity and file usage, and ensures necessary resources are present so that databases function properly by removing or deleting old or obsolete files. • Managing Users, Privileges and Roles. • Managing table spaces, data files, redo logs, tables and its segments. • Maintaining data integrity also managing profiles, resources and password security. • Install Oracle software and patches. Exibir menos

• 

  Agilis International

  Jul 2013 - Jan 2014

  Application support Engineer

  Managing and maintaining hosted production, development, test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.Providing database support by 24/7 on Production Databases.Installing Oracle software for 10g/11g.Involved in Requirement Analysis, Design, and Implementation of Test Environment for UAT, Development and ProductionTroubleshooting related to performance tuningInstallation and configuration of Oracle11g Real Application Cluster. Monitoring ASM Instance and Clusterware services using RAC utilities like SRVCTL, OCRCHECK, OCRDUMP and CRSCTLASM – Automatic Storage Management.Implementing PSU Patches.Work on day-to-day performance related issue received from users/apps team. Monitor Tablespaces, disk balancing report, table and their partition size, schema object and etc.Maintains track of init.ora, listener.ora, tnsnames.ora and sqlnet.ora.Using backup Hot Backup, Cold Backup, and Logical Backup. Very frequent refresh of the test servers with the production server. Shell scripting and batch file creation.SQL Server Production support which includes Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.Involved in Design, Development and testing of the systemMonitored the Database Growth and Space Requirement. Handling Users/Logins/User Rights.Installing SQL Server Client side utilities and tools for all the front-end developers/programmers.Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.Created Triggers to maintain the Referential Integrity.Created indexes, Constraints and rules on database objects for optimization.Responsible for setting preferences for various ad-hoc requests and distribution of tasks.Involved in performing database Backup and Recovery. Exibir menos

• 

  Nectar Infotel

  Jan 2015 - Jan 2021

  Sr. Database Administrator consultant

  Working as an onsite DBA consultant at UNITEL SA (A mobile telecom service provider at Angola).As a DBA consultant, my responsibility includes managing multiple Oracle Databases for uptime up to 99.99%. Manage their complex system having more than 500 Nos. of RAC database along with more than 50 no’s of single instance DB, with 12c,11g and 10g environment with size in TB’s. Develop backup and recovery strategies that are appropriate for the client, Manage and implement backup and recovery procedures and backup validation.Implemented Database security through User management, Role management, database auditing.Plan and Migrate Oracle databases from old hardware servers to new hardware servers to comply with consolidation and required performance level.Install, configure and support of Oracle RAC Database 10g, 11gR &12c on Linux environment. Performance Tuning / analysis through OEM, memory management, SQL tuning, Explain Plan, Tkprof and SQL Analyzer.Setting DR servers – Physical Standby Databases and Maintenance.SQL Server Production support which includes Implementing SQL Server, security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.Index maintenance and maintain fragmentation. Tuned and Optimized SQL Queries using Execution Plan and Profiler.Checking Data integrity using DBCC check dB utility. Space management by removing old backup and transaction logs. Update the index statistics, re-indexingBackup and Space Management. Trouble shoot problems with the various teams including network related issuesUsers and Login Management in cluster environment.Experience in performing integrity checks. Methods include configuring the database.Moving database through import/Export. Maintenance plans to perform index de-fragmentation, re-indexing, update the index statistics, log file shrinking, database shrinking. Exibir menos

• 

  OMNIdata Lda.

  Jan 2021 - now

  Database Specialist