Alex Frêne

1280 Fulton Street · San Francisco, California 94117 · M - 630.626.9781· alexfre@gmail.comm

Permanent U.S. Work Authorization

SAP Oracle Database Administrator

ORACLE:

• Good Knowledge of Oracle Architecture (Standalone and RAC)

• Installing and configuring oracle client and Oracle server on Linux and windows.

• Configured two nodes RAC (11g R2) in test environment on Oracle Linux platform.

• Adding and Deleting node in an existing Oracle Cluster ware and creating database instances.

• Knowledge in Oracle RAC Database Administration.

• Knowledge in Oracle Clustering and Oracle ASM concepts.

• Good understanding on Troubleshooting Oracle Clusterware.

• Understanding on Configuring Oracle Data Guard on RAC environment.

• Experience in working with Oracle Index rebuilding and Table Re Org.

• Gathering stats on schema and table level.

• Oracle Table space management techniques (Resizing/moving data files/adding data files)

• Experience in configuring RMAN settings as per safety standards.

• Capable of handling critical oracle RMAN backups and recoveries like control file, data files.

• Capable of handling BLOCK level corruption in oracle RMAN.

• Knowledge of Oracle Flashback Recover.

• Logical Backup: Experience in working with Oracle Data Pump Utility.

• Creating, managing user accounts granting roles, allocating quotas on tablespaces, assign profiles.

• Experience in working with ORACLE 11GACTIVE RMAN cloning.

• Oracle Networking: Configuring network in oracle i.e. Listener.ora & tnsnames.ora.

• Exposure on Oracle Database Migration on windows 2003 server. (9i to 10g)

• Experience with SAP Oracle Database Administration.

• Knowledge of TSM backups, Flash copy backups and Metro Mirroring operational technologies.

• Good Exposure on working with services and ticketing tools like ITSM and BMC.

• Capable of working with RCA of issues of different criticality levels.

MS SQL SERVER

• Installing MSSQL 2005, 2008 on servers.

• Checking blocking sessions and killing as required.

• Managing Day to day activities.

• Checking fragmentation at database level.

• Reducing fragmentation by Index-Rebuild and Index Re-org.

• Working on memory Issues on SQL Servers.

• Checking alerts using eventmgr and SSMS.

• Roles and privs management.

• Experience in working Database Mirroring and Clustering concepts.

• Shrinking log files when facing space issues.

UNIX Skill Set:

• Installation of RHEL 5, 6

• Basic of Shell Scripting (Bash)

• Cron jobs management.

IT Literacy:-Scripting Basic Shell Scripting Knowledge.

WORK EXPERIENCE

SAP Oracle Database Administrator

Accenture India Services Limited (Net Connect Consultancy) - San Francisco, California - February 2013 to

Present

Client BHP Billiton is a 1st largest mining company which operates out of 25 countries.

Project Oracle Database support

Role Level F - Oracle and SQL DBA

Team Size 8

Contribution

• Owner and responsible for the oracle and SQL Databases.

• Review and provide recommendations to gain the space in database. From the table shrink and index rebuild

Activity.

• Monitoring the backup and provide the database growth report to client on weekly basis.

• Installing Oracle software 11g on desired servers.

• Space addition, DB backup, dB stats through BRTOOLS.

• Killing blocking sessions if required or analyzing on same.

• Troubleshooting & providing solutions for long running queries and backup failure.

• Doing hands and solving Critical and High Priority Tickets.

• Involved in Data Migration from 9i to 10g on windows.

• Involved in project from due diligence phase, requirement gathering phase, understood and reviewed the

Scope of work, defined the work packages and catalogues

• Have been involved in the transition phase and attended KT sessions and have given reverse Knowledge

Transitions to the team.

Environment Oracle 11g (11.2.0.3) Enterprise database, IBM - AIX and Oracle 10g (10.2.0.3) on Windows

Project 1:

ORACLE and SQL DBA

Nasik Merchants Co-operative - San Francisco, California April 2011 to February 2013

PUNE DISTRICT CENTRAL COOPERATIVE BANK (PDCC bank)

ROLE: ORACLE and SQL DBA

ORGANISATION: Focus InfoTech Pvt Ltd

OS: Linux 5 and Windows.

Database size: 100 GB to 270 GB

Team size: 8

Domain: BANKING

RESPONSIBILITY:

• Adding / Resizing data files if needed.

• Raising CSR on metal ink to ORACLE SUPPORT.

• Checking and killing blocking sessions.

• Marking TNS Entries and checking Listener Status, connectivity.

• Generating AWR Reports. (Monthly)

• Installing Oracle Server and Oracle Client

• Configuring and Monitoring scripts in CRON.

• Taking Oracle RMAN Backups.

• Our Backup policy was to take HOT BACKUP (Full Backup) using RMAN.

• RMAN backup is on DISK as well as on External TAPE.

• Weekly Tape Backup. (External Tape connected to production server)

• Auto Backup feature of control file is enabled. (For security purpose)

• Logical Backup Using Data Pump. (SCHEMA LEVEL EXPORT)

• Export of important tables at regular intervals.

• Monitoring Alert Log files.

• Creating user Profiles Granting specific privileges and roles to the users.

• Maintaining table spaces & data files, Control files, Online Redo log files.

EDUCATION

B.E

Oracle University- Belgaum, Karnataka

ADDITIONAL INFORMATION

Operating Systems RHEL 5, RHEL 6, Windows Family.

Database Oracle 10g, 11g, MSSQL 2005, 2008

Language SQL

Tools Known DBCA, ASMCMD, ASMCA, RMAN, DATA PUMP, BR TOOLS.