Candidates About

 

                                 Sushanta  Kumar Jena                                  

CORE COMPETENCY:     

IT professional specialized in oracle DBA having a depth understanding in different versions of oracle database and its advance feature, database server OS like UNIX, Solaris, Linux, window with a global mindset and strong

Quantitative & conceptual abilities.

 

SUMMARY:

• Having  7.4 years of experience as Oracle Database Administrator.  Oracle 12C RAC/11g RAC/10g RAC/9i databases running on different environments such as Sun Solaris, HP-UX, AIX, Red Hat Linux, and Windows.
• Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, capacity planning, shell scripting, and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g & 12C with experience within very large scale database environment of size more than 45 TB and mission critical OLTP and OLAP systems.
• Oracle DBA support in Exadata environment.
• Implemented High availability/replication technology using Oracle Stream and Golden gate.
• Uni-directional and Bi-directional replication set-up using Golden gate in Oracle environment.
• Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management, and monitoring

·         Experience in OLTP database systems, implementing and managing large Oracle databases (VLDB).

• Hands On Experience in installing, configuring and managing Oracle 12C RAC, 11g R2 RAC, Oracle 10g RAC
• Experienced at using Oracle Enterprise Manager/Grid Control (OEM 12C/GRID CONTROL).
• Installation/Upgradation of OEM 12C. Agent installation, adding different host/database, setup different job, monitoring etc through OEM 12c.
• Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 TRACE, AWR, ADDM, ASH, SQLT, SQL tuning advisor.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR), AWR comparison report and Automatic Database Diagnostics Monitor (ADDM).
• SQL query tuning using PLAN management, explain plan review, index creation , base line implementation using SQL profile and SPM.
• Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration.
• Experience in Flash-Back Recovery, Data Pump, AWR, ASM, ASH and ADDM, Recycle Bin and Grid Monitoring.
• Migrated databases from one OS to other and from one cluster to other cluster.
• Knowledge on Oracle Support processes for technical requests through Meta link.
• Planning and scheduling for the backup of database information using UNIX shell script and Crontab jobs, Autosys, OEM 12C.
• Strong knowledge and experience of managing Oracle 9i,10g, 11g, 12C RAC environments using the OEM 12C Grid Control tools.
• Data transferring with Export, Import, Data Pump and SQL* Loader utilities.
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.

·         Refresh/Cloning of Database and applications for development and testing purpose.

·         Basic knowledge in no sql database Cassandra.

• On call 24x7 Production Support Worked beyond regular hours.

·         Dealing with database security and auditing.

·         Have extensive knowledge Oracle Application Server Administration (web logic).

·         Oracle ASM diskgroup creation and management.

·         Configuration and maintenance of jobs like stats gathering, table/index gathering.

·         Client installation and configuration.

·         Application server support with TNS update and connectivity to database.

·         Code migration from lower environment to PROD.

·         Shell scripting for automating DBA related monitoring jobs.

·         AWS training completed with basic hands-on in AWS cloud environment.

·         Basic knowledge and hands-on in Amazon RDS database.

·         MySQL database basics.

·         PL/SQL coding and debugging.

·         COBOL grammar for generating parser and lexer using ANTLR

·         Excellent communication, interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

 

TECHNICAL SKILLS:

 

 

 

EDUCATION:

Course	Duration	College
BTECH (Computer Science and Engineering)	2006-2010	ITER, Bhubaneswar , Odisha, India

 

CERTIFICATION/AWARDS

Certificate Name	Issuing Organization	Year
OCA(I & II)	Oracle	2011
OCP	Oracle	2012
ITIL	IBM	2013

 

Certification of Excellence Award from Hartford Insurance Group client.

 

 PROFESSIONAL EXPERIENCE:

ORGANISATION : WIPRO LTD

CLIENT: CITI BANK.

LOCATION: DALLAS, TX, USA        09/2016 to PRESENT

ROLE: Lead Oracle DBA

Responsibilities:

·         Database monitoring and maintenance activity of more than 1000 prod/non-prod database in Oracle 10g,11gR2 RAC, 12C RAC  hosted in AIX,LINUX, HP, Sun Solaris platform as an oracle DBA.

·         Maintenance of production, PROD-Like, QA and Development database with overall database creation, migration, up-gradation, capacity planning, user/schema creation, role, privilege etc.

·         Oracle 11g/ 12c binary installation and up-gradation.

·         Worked on creating multiple 11.2.0.3, 11.2.0.4, 12.1.0.1 and 12.1.0.2 oracle RAC database using DBCA and manual method.

·         Adding new RAC instance/RAC node to an existing cluster.

·         Database up-gradation from 11g to 12C and 12.1.0.1 to 12.1.0.2 oracle database.

·         Database migration from one cluster to other cluster in same platform and cross platform migration

·         Client installation in application server and tns-entry update in OID, OUD, tnsnames.ora file and troubleshooting connectivity from application server to database.

·         Worked with UNIX team, storage team for new LUN allocation, scanning disk as part of new ASM disk creation.

·         Configuring listener and aliases to set up TAF.

·         Port opening and troubleshooting with the help of network team for the servers (application/database) under firewall.

·         Applying PSU and One-off bug fix patches in rolling fashion.

·         Cluster level patching and upgradation.

·         ASM disk-group creation, Adding/Dropping disk using ASM rebalance feature, migration of ASM disk from one VMX array to another VMX array.

·         Configuration and creation of physical standby database in standalone and RAC. Created latest 12.1.0.2 physical standby database.

·         OEM 12C grid installation, upgradation  and maintenance.

·         Creating/ configuring/troubleshooting RMAN level 0 and level 1 database backup using OEM 12C.

·         Database logical backup using exp, imp, expdp, impdp.

·         Database/Schema/Table level refresh, migration and cloning using data-pump, RMAN duplicate.

·         Database backup, restore and recovery activities.

·         Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 TRACE,TK PROF, AWR, ADDM, ASH, SQLT, SQL tuning advisor.

·         Troubleshoot Database performance issues using Automated Workload Repository (AWR), AWR comparison report and Automatic Database Diagnostics Monitor (ADDM).

·         SQL query tuning using PLAN management, Pinning better plan, explain plan review, index creation , base line implementation using SQL profile and SPM.

·         Creation and managing Table partitioning and Rebuilding, validating the Indexes.

·         Creating SR and analyzing/troubleshooting any outstanding issue directly with oracle support and engaging duty manager if required for any critical support.

·         Involved in root cause analysis, problem solving, issue tracking and support in production.

·         Creating shell scripting to automate monitoring activity.

·         Oracle golden gate exposure

·         Maintain database operation environment with SOX compliance and adhere to corporate policy.

·         Applying security policies to database.

 

 

ORGANISATION: TCSL

CLIENT: BEST BUY INC.

LOCATION: Richfield, MN, USA        04/2015 to 08/2016

ROLE: Enterprise Oracle DBA

Responsibilities:

·         Providing 24X7 productions supports for oracle database availability.

·         Database monitoring and maintenance activity of more than 300 prod/non-prod database in Oracle 10g,11gR2 RAC, 12C RAC  hosted in LINUX, HP, Sun Solaris platform as an oracle DBA.

·         Maintenance of production, PROD-Like, QA and Development database with overall database creation, migration, up-gradation, capacity planning, user/schema creation, role, privilege etc.

·         Oracle 11g/ 12c binary installation and up-gradation.

·         Worked on creating multiple 11.2.0.3, 11.2.0.4, 12.1.0.1 and 12.1.0.2 oracle RAC database using DBCA and manual method.

·         Adding new RAC instance/RAC node to an existing cluster.

·         Database up-gradation from 11g to 12C and 12.1.0.1 to 12.1.0.2 oracle database.

·         Database migration from one cluster to other cluster.

·         Client installation in application server and tns-entry update in OID, OUD, tnsnames.ora file and troubleshooting connectivity from application server to database.

·         Worked with UNIX team, storage team for new LUN allocation, scanning disk as part of new ASM disk creation.

·         Configuring listener and aliases to set up TAF.

·         Port opening and troubleshooting with the help of network team for the servers (application/database) under firewall.

·         Applying PSU and One-off bug fix patches in rolling fashion.

·         Extensible worked on oracle 11g/12C RAC cluster and very large 45TB RAC databases.

·         Cluster level patching and upgradation.

·         ASM disk-group creation, Adding/Dropping disk using ASM rebalance feature, migration of ASM disk from one VMX array to another VMX array.

·         Quarterly capacity planning for all production databases and adding space to ASM diskgroup.

·         Space management which includes creating new tablespace, adding datafiles.

·         Managed Table spaces, Rollback Segments, Redo Logs and other database object.

·         Assisted developers in DML activity and DDL activity like creating stored Procedures, Triggers, Functions, Cursors and Packages.

·         Configuration and creation of physical standby database in standalone and RAC. Created latest 12.1.0.2 physical standby database.

·         Monitoring and sync standby database using SRDF, restore archive log and incremental backup feature.

·         OEM 12C grid installation, upgradation  and maintenance.

·         Creating/ configuring/troubleshooting RMAN level 0 and level 1 database backup using OEM 12C.

·         Database logical backup using exp, imp, expdp, impdp.

·         Database/Schema/Table level refresh, migration and cloning using data-pump, RMAN duplicate.

·         Database backup, restore and recovery activities.

·         Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 TRACE,TK PROF, AWR, ADDM, ASH, SQLT, SQL tuning advisor.

·         Troubleshoot Database performance issues using Automated Workload Repository (AWR), AWR comparison report and Automatic Database Diagnostics Monitor (ADDM).

·         SQL query tuning using PLAN management, Pinning better plan, explain plan review, index creation , base line implementation using SQL profile and SPM.

·         Creation and managing Table partitioning and Rebuilding, validating the Indexes.

·         Involved in analysis, design and development phases of the project.

·         Creating SR and analyzing/troubleshooting any outstanding issue directly with oracle support and engaging duty manager if required for any critical support.

·         Involved in root cause analysis, problem solving, issue tracking and support in production.

·         Creating shell scripting to automate monitoring activity.

·         Create and handle oracle streams in production environment.

·         Maintain database operation environment with SOX compliance and adhere to corporate policy.

·         Monitoring service now to maintain SLA for INC/CR/PBI.

 

 

 

ORGANISATION: TCSL

CLIENT: CIGNA DENTAL HEALTH INSURANCE

LOCATION: Fort Lauderdale, FL, USA      01/2015 to 04/2015

Responsibilities:

·         PL/SQL coding, debugging for new modules and enhancement of existing module.

·         Worked in Live Data project for identifying all PHI(Protected Health information) data by analyzing all related tables as per the physical and logical relationship between the tables.

·         Identifying poorly performing query and performance tuning in long running SQL/batch jobs.

·         Working in Test data remediation(TDR) project for purging and masking of sensitive data in non-production(Test) environment by analysing and writing purge script.

·         COBOL grammar in ANTLR for generating parser and lexer in Java for COBOL as part of conversion of COBOL structure to XML.

·         Project planning and execution using different phases of SDLC.

 

ORGANISATION: TCSL

CLIENT: HARTFORD INSURANCE GROUP(HIG)

LOCATION1: Kolkata, INDIA      08/2010 to 10/2013

LOCATION2: Hartford, CT, USA 10/2013 to 12/2014

 

Responsibilities:

·         Provide support and maintain very large number of complex Oracle Database systems in a multi-platform 24x7 environment.

·         Database monitoring and maintenance activity of more than 100 prod/nonprod database as an oracle DBA

·         Accountability on Onshore-Offshore co-ordination, customer and client handling.

·         Oracle DBA support for different version of oracle 9i,10g,11gr2 RAC(in both non-exadata and exadata)  database.

·         Worked on Oracle exadata.

·         Provide support and coordination with development, QA and production support application teams for all new releases, code fixes and  migration of data between different environments.

·         Managing and Scheduling cron jobs and DBMS Scheduler jobs.

·         Backup job creation and troubleshoot backup/recovery issue for RMAN and appBCV backup jobs.

·         Database refreshes using RMAN, schema refresh and PII activity co-ordination.

·         Logical backup and restore using exp/imp and data pump technology.

·         Maintaining data integrity and tune database/SQL query for optimum performance and availability.

·         Batch job performance testing/tuning and monitoring by effective utilization of OEM 10g, OEM 12C and by generating & analyzing of AWR,ASH,ADDM report, explain plan, tuning advisory  and different trace files.

·         Analysis of 10046 traces using tkprof utility.

·         Tuning SQL queries using SPM and SQL profile.

·         Performing scheduled maintenance (Stats gathering, Table reorgs ,Index rebuilds ,Partition creation etc) on database objects.

·         Plan for database growth and monitor capacity usage by monthly and quarterly forecast of tablespaces and communicate these capacity requirements to management and with SAN/NAS team to add space.

·         Co-ordination as appDBA for migration of production databases to different servers and environments as per the requirement.

·         Database user management related activity like creating/dropping user, role and providing necessary privilege.

·         Raising and Handling Service requests in Oracle Metalink Support.

·         Develop, implement and administer database policies and procedures.

·         Database objects creation and management as per the project requirement.

·         Write and implement scripts to automate regular database functions and improve overall throughput

·         Co-ordinate/implement for Installation of Patch set update, bundle patch, rolling patch in RAC, new fixes, RAC cell node upgrade  and bug fixes.

·         Outage management and regular database health check in both RAC in exadata/non-exadata platform and RAC/stand alone database.

·         Co-ordination/implementation for upgrading of Database and other oracle products from lower version to higher version.

·         Preparing testing environments, replicating Production as per the application team requirements for testing and deployment purposes.

·         DG(physical/logical/snapshot data guard) and DR testing for production database.

·         Maintaining database for SOX and audit compliance.

·         Monitoring ticket tracking tools and maintaining different code repositon