CURRICULAM VITAE

Atul Markan Permanent Address: H.No 602 Block A1

Marvilla Society Pune 411028

B.Com

MCA

Oracle Certified 9i/10g Mobile Number: 956*******

Email Id: acq0ie@r.postjobfree.com

OBJECTIVE

Seeking career in Oracle Database Administration in Multi platform UNIX environment and Managing Oracle Applications on Clusters in a world-class organization that would provide competitive and challenging work environment to exploit my potential and augment my skills.

KEY SKILLS

Sound understanding of Process and delegate escalations in 24x7 mission-critical

Banking & Insurance, Petroleum environments.

Having fundamental knowledge of Oracle Database Architecture

Installation and Configuration of Oracle Instances(9i/10g/11g/12c) on Linux environments

Installation 12C Enterprise Manager and configure with target

12C Cluster ware

Install 12C clusterware

Upgrade Clusterware from 11gr2 to 12C

Convert Standard cluster to FLEX cluster

Adding HUB node and Leaf Node

12C Database

Install Database on 12C

Upgrade database from 11Gr2 to 12C

Create CDB and PDB database.

Convert non-cdp to PDB database.

Clonning the pluggable database.

Unplug and plug the database

Database Backup and Recovery

a.Manual Backup and Recovery

b.RMAN BACKUP & Recovery

Redolog Recovery

ControlFile recovery

Datafile Recovery

Full Database recovery

TSPITR

Block Recovery

c.Using Flashback

Database Cloning & Refresh

a.Using RMAN Backup

b.Using DataPump & EXPORT and Import

c.Using Hot and cold backup Manually

Upgrade standalone and RAC databases

a.Upgrade from 10G to 11G

b.Upgrade from 11gr1 to 11gr2

Upgrade Clusterware

Upgrade from 10G to 11G

Upgrade from 11gr1 to 11gr2

Upgrade from 11gr2 to 12c

RAC ACTIVITIES

a.Converting Standard RAC CLUSTER to FLEX CLUSTER

b.GNS (Global Naming Service)

c.Planning & Installation RAC

d.Installation one node RAC

e.Changes the VIP and Private IP addresses.

f.Workload management.

g.Migrate OCR and Voting disk from non-asm to ASM

h.Recover the OCR and voting disks.

i.ADD/Delete nodes on 11Gr2 and 12C

Re-org the Objects to avail the space

Automatic Storage Management.

a.Create and maintain Disk groups

b.Add/Remove disks

c.Configure Volume Manage

d.Configure ACFS shared file system

e.ACFS replication from primary to standby

Migration database from NON-ASM to ASM

Migration Database cross platform using RMAN

DATAGUARD

a.Configure physical standby database

b.Configure snapshot database

c.Configure Active database

d.Hand on experience switchover/failover

Applying PSU/CPU patches

Bulk loads and data migrations (Data pump, IMP/EXP)

Implementation of oracle security by creating roles, privileges and profiles

Usage of Data Dictionary Views

Generating & analyzing PT related Reports(AWR, ADDM, stats pack etc)

MONGO DB

1.Replication

2.Sharding

SUMMARY OF PROFESSIONAL WORK EXPERIENCE Total work experience Approx. 10 Years

# Tricore Solutions April 2015 to till date (Principal Consultant)

ABOUT TriCore Solutions

TriCore Solutions, the application management experts, provides a full suite of scalable and reliable managed application, cloud, infrastructure hosting, and consulting services to enterprise organizations. The company delivers its services and the TriCore Trusted Promise to more than 250 companies worldwide to reduce costs, raise service levels, increase business agility, and accelerate innovation, unlocking the business value from their IT investments. TriCore Solutions is headquartered in Boston, MA with offices in India. TriCore is an Oracle Platinum Partner, Oracle Accelerator Certified, a three time Oracle Titan Award winner and a nine time Oracle Partner of the Year.

PROJECT DETAIL: NOVARTIS

Novartis International AG is a Swiss multinational pharmaceutical company based in Basel, Switzerland, ranking number one in sales (57.9 billion US$) among the world-wide industry in 2013.

JOB RESPONSIBILITIES:

1.RAC installation

2.Performance Tuning

3.DataGuard Setup

4.Monitoring Alerts and provide the solution

5.EXPDP/IMPDP

6.RMAN Backup/Restore/Recovery

7.Upgrading Oracle Databases and Patching

8.Working on MongoDB (Big Database)

#CITAGUS BANGALORE July 2014 to April 2015 (Tech. Lead DBA)

ABOUT CITAGUS:-

Citagus is a global IT services company with sharp focus on ERP and BI services. Founded by first generation entrepreneurs with initial niche focus on PeopleSoft technologies. Citagus have completed several large ERP and BI engagements in USA and India. Founded in 2004 with offices in Atlanta, GA and sales offices in Chicago, IL. D; TWCelivery Centers in Atlanta, Bangalore and Chennai, India.

PROJECT DETAIL: TWC

Total No of Databases: Oracle- 350

Total No of Databases in Production: 200

Total No of Databases in UAT: 170

ABOUT TWC:-

Time Warner Cable Inc. (NYSE: TWC) is among the largest providers of video, high-speed data and voice services in the United States, connecting 15 million customers to entertainment, information and each other. Time Warner Cable Business Class offers data, video and voice services to businesses of all sizes, cell tower backhaul services to wireless carriers and enterprise-class, cloud-enabled hosting, managed applications and services. Time Warner Cable Media, the advertising arm of Time Warner Cable, offers national, regional and local companies innovative advertising solutions.

JOB RESPONSIBILITIES:

1.Handling the Performance related issue

a.On query level.

b.On Database level.

c.On Cluster Level.

2.Real Application Cluster

a.Installation RAC clusterware.

b.Adding Nodes.

c.Migrate Voting/OCR from NON-ASM to ASM.

d.Installed RAC one node.

3.UPGRADE

a.Upgrade RAC & Single instance database

b.Upgrade clusterware

4.MIGRATION

a.Migration database from NON-ASM to ASM

b.Migrated database from Solaris to LINUX

5.ASM & ACFS

a.Installation ASM

b.Creating disk group with various replication.

c.Create Volume and ACFS

6.Patching:- SPU/PSU on cluster level, binaries level and database level.

# MPHASIS LTD, PUNE- Aug 2012 to July 2014 (Sr. Principal Infra. Eng.)

PROJECT DETAIL: APMM

Total No of Databases: Oracle- 290

Total No of Databases in Production: 150

Total No of Databases in UAT: 140

ABOUT APMM:-

Maersk Line, the global containerized division of the A.P. Moller – Maersk Group, is dedicated to delivering the highest level of customer-focused and reliable ocean transportation services. It is recognized as the most reliable container shipping company.

JOB RESPONSIBILITIES :

1.Implementation of Dataguard. Switching over the database in planned activity. Failover the databases.

2.Refreshes using exp/imp, EXPDP/IMPDP, using RMAN

3.Cloning:- Using RMAN & Manually.

4.RAC:- Implemented RAC on 10g/11g, implemented service (TAF),

5. Performance tuning issues using SQL advisor/OEM

6.Patching:- SPU/PSU on cluster level, binaries level and database level.

7. Daily health check:- Alert log file, tablespaces, Filesystem mount point.

8. ASM:- Configure ASM, adding disk, dropping disk, created disk group.

9.Agent installation and de-installation.

10. Database creation, User creation, table creation, index creation.

11.Migrate OCR/VOTING disks to ASM.

12.Restore votingdisk/ocr after corruption.

13.Working on ACFS and installation the binaries on ACFS.

14.Creation of ASM disk group and compatibility with ASM and RDBMS.

15.Installation ASM on ORACLE 11G.

16.Migrated 10 TB database on Preprod and prod.

17. Meeting with client & application team if they want any changes in database. Work directly with them.

18. Installed RAC one node.

PROJECT DETAIL: British Petroleum 01st Feb 2014 to Till date ((Sr. Principal Infra. Eng)

ABOUT BP:

BP is a reputable oil/gas industry with wide network all over the world. British Petroleum developed oil fields and built refineries in several more countries

JOB RESPONSIBILITIES(L3+):

1.Maintain and Handle the data guard .

2.ASM:- Configure ASM, adding disk, dropping disk, created disk group.

3.Agent installation and de-installation.

4.Work with application team

#HCL TECHNOLOGIES LTD, NOIDA - 7th April 2008 to 14th Aug 2012 (Senior ORACLE DBA)

PROJECT DETAIL: DOWJONES

Duration : March 2010 to Till Date

Company : HCL

Client : Dow Jones USA

Database : Oracle 8i,9i,10g,11g

Environment : Linux, IBM AIX, HP –Unix, Windows

Total No of Databases: Oracle- 350

Total No of Databases in Production: 170

Total No of Databases in UAT: 180

JOB RESPONSIBILITIES:

Working with ITIL Process (Incidents, Change, Patch and problem Managements etc)

. Installation and monitoring oracle 10G Real Application Cluster on Linux platforms and IBM AIX

. Implementation of dataguards on oracle 9i and 10g

. Has done switchover and failover on dataguards (oracle 9i & 10g)

. Experienced in 10g/11G New features (ASM, Datapump, AWR, ADDM, ASH)

. Configuration of databases in RMAN for backup and recovery

. Taking and deciding the suitable kind of backup (Rman, Export, Cold and Hot backup).

Assistance in restoration exercises & recovery of database.

Applying maintenance patches, quarterly CPU patches, PSU & upgradation.

. Installation and administration of Oracle Database and its Tools on various Operating Systems, such as Windows NT, Unix Server, Linux Red Hat, IBM AIX Monitoring production and development environment

Maintenance and tuning of databases: Disk I/O optimization through table, index, differentiating table data and indexes in separate tablespaces in separate disks. Monitoring and appropriate sizing of logical structures viz. tablespaces, tables, indexes through appropriate parameters such as pctused, pctfree, initial and next extent values balancing both I/O and space usage.

Interactions with application developers extensively to maintain and tune performance of Oracle server on IBM AIX, LINUX, Windows Platforms

PROJECT DETAIL: TRAVELLERS

Duration : April 2008 to Feb. 2010

Company : HCL

Client : Travellers USA

Database : Oracle 8i,9i,10g,11g

Environment : Linux, IBM AIX, HP –Unix, Windows

Total No of Databases: Oracle- 200

Total No of Databases in Production: 120

Total No of Databases in UAT: 80

The Travelers Companies (NYSE: TRV) is the largest American insurance company by market value. It is also the second largest writer of commercial property casualty and personal insurance in the United States. Travelers has significant operations in New York, New York, Hartford, Connecticut and St. Paul, Minnesota.

We are responsible to maintain the application DBA/System DBA activities, where the prime responsibility is to manage the oracle releases on servers according to the different business requirements.

There are 50 high end shared UNIX servers (DEV, TEST and PROD) with 350 databases on Solaris and UNIX environments.

RESPONSBILITIES-

Obtain and Maintain DBMS Software & Patches

Install Oracle Security Patches

Set up and maintain the listener.ora, tnsnames.ora and ORATAB file as per Security requirements

Set up Links for init.ora file and spfile.ora

Remove audit logs older than 30 days, ($ORACLE_HOME/rdbms/audit/*.aud)

Create password file & OFA Directory Structure

Backup Tnsnames.ora, listener.ora, sqlnet.ora, oratab

Regular monitoring the status of standby databases, space on ASM.

Backup and recovery (RMAN Catalog).

Database Cloning using RMAN.

Refresh database using exp/imp and Datapump.

Using Oracle 10g AWR & ADDM to monitor database activities and performance tuning.

Working on RAC administration.

Install and maintain DBMS Client software on Unix Server.

Block Recovery using RMAN.

# Wipro InfoTech Mumbai Sep-2006 - Mar 2008

Wipro Infotech is a leading CMM Level 5 certification and Six Sigma initiatives and global software powerhouse providing innovative and pioneering products and software solutions, focused in banking and financial services spanning under FINNONE flag across solutions in the areas of Core Banking, Retail & Corporate Banking, Credit Cards, Cash Management, Relationship Banking, Financial CRM, Credit Risk & Appraisal, Trade Finance, EAI, Internet Banking, FX, Basel II, Data warehousing and Analytics.

Role: Engineer Oracle Database

Client: HDFC Standard Life.

Team Size: 10 DBA

HDFC Standard Life Insurance Co. Ltd. is a joint venture between Housing Development Finance Corporation Limited (HDFC Limited) - India's leading housing finance institution, and a Group Company of the Standard Life Plc, UK. The Company is one of leading private insurance companies, offering a range of individual and group insurance solutions, in India. Being a joint venture of top financial services groups, HDFC Standard Life has adequate financial expertise to manage long-term investments safely and resourcefully.

We are responsible to maintain the Application DBA/System DBA activities, where the prime responsibility is to manage the oracle releases on servers according to the different business requirements.

There are 20 high end shared UNIX & WINDOWS servers (DEV, TEST and PROD) with 150 databases.

RESPONSIBILITIES-

Copying production backup to DEV/UAT boxes.

Full Database, Table and Schema refresh from Export Backup

Full Database, Table and Schema refresh from Cold/Hot Backup

Hot/Cold Backup Restore

Handling Change Request for Schema change, modifying TNSNAMES.ORA & Parameter files, Database backup, Database Startup, Database Shutdown and Bounce.

Production Break Fix- Users connectivity issues, running out of connection, KILL Sessions.

Undo and Temp Tablespaces management.

Create Accounts and Tablespaces.

Configure Database/Parameter.

Run ad-hoc user supplied SQL scripts

Monitoring of Cluster’s node of RAC database.

Managing real application clustered database.

Role: Engineer Oracle Database

Client: Timesofmoney.com, Mumbai, India (A Times of India Group Company)

Team Size: 2 DBA

TimesofMoney is India’s leading digital payment service provider, and serves a varied client database. Spanning Indian and international clients, our offering includes specialized NRI services, India Money Transfers, Global Money Transfers, ePayments and Co-branded cards.

Conceptualized and built to serve diverse communities, TimesofMoney’s services offer convenience, connectivity and flexibility across a global platform. The conglomerate continually strives to deliver the best to its clients, ensuring flexible service and meeting global standards.

Responsible for administering & managing 6 production and development database servers. Responsible for the monitoring and supporting Oracle and MY-SQL database hosted on UNIX environment.

RESPONSIBILITIES

Managing Tablespaces, datafiles, segments.

Analyze tables

Creating and Rebuild Indexes

Creating Users, constraints, profiles, roles.

Block recovery.

Modifying Instance with SGA parameters.

Configuring network using listener and tnsnames/hostnames.

Running Statspack, Explain Plan, tkprof.

Daily check the space.

Maintain the Archive Log Files.

Daily basis maintain the hot backup.

Weekly Restore the Database.

Logical Backup exp/imp.

Running the SQL-Loaders.

Monitor performance using dynamic views.

# BGIMT Nov 2005 – Aug 2006

Bhai Gurdas Group of Institutes, committed to the cause of skilled and quality education at par with Global Standards, appeared on the academic front in 2002. The Group has successfully been running seventeen institutions in various districts of Punjab. Bhai Gurdas Group has been established with the objective of providing high quality education in Engineering, Technology, Management and medical sciences. This is a PTU affiliated and AICTE approved institution.

Role: SYSTEM ANALYST CUM LECTURER

RESPONSIBILITIES

Maintain the institute LAB with proper networking.

Installation proper software and maintain the hardware in LAB

Provide the database training in institute.

Arranging work experience placements

Attending staff meetings

Liaising with other professionals/employers

CERTIFICATIONS

Oracle Certified Professional 10G RAC Administration

Oracle Certified Professional 10G

Oracle Certified Professional 9i

TRAININGS

RAC for High Availability on Oracle 10g Release 2

Microsoft Certified Professional

Trained on Oracle 10g Database Server by Oracle CORP. at Wipro InfoTech.

Qualification

MCA from Punjab Tech. University Jalandhar (2001-2004)

B.Com from Punjabi University Patiala (1997-2000).

AREA OF INTEREST

Oracle Database

Operating System

RDBMS ORACLE 9i, ORACLE 10g, ORACLE 11gr2

OPERATING SYSTEM UNIX, LINUX, SOLARIS-10 & Windows Server 2000/2003

REMOTE ACCESS TOOL Putty, Terminal Server

BACKUP TOOLS TIVOLI/SQL BACKTRACK/HP PROTECTOR

PERSONAL PROFILE

FATHER’S NAME Mr. Ashok Kumar

MOTHER’S NAME Mrs. Sangeeta Rani

DATE OF BIRTH ‘ 06th Dec. 1979

MARITAL STATUS Married

LANGUAGES KNOWN Hindi, English,Punjabi

Passport Number L8059013

Visa B1 visa till Sep. 2018

HOBBIES Reading, Traveling, Sports & Keen interest in social welfares, Chess.

PERSONAL ASPIRATION

To remain the best by continuing study with the emerging technologies. I hereby do solemnly affirm that the details furnished herein are true to the best of my knowledge.

DATE

PLACE (Atul Markan)

Contact this candidate