• Experience in production support of Oracle, DB2 UDB, SQL Server and Sybase databases on UNIX, Linux and
• windows, as well as ,experience with various high availability as RAC, Data guard for Oracle, Hadr, db2
• database partitioning features, db2 Pure Scale for IBM.
• Experience with technologies for replication like Sybase Replication Server and Oracle Golden Gate, also
• experience with Sybase IQ.
• Strong analytical and problem solving skills, ability to work under pressure in complex database
• environments.
• Skills and capabilities include databases management, troubleshooting, upgrades, migrations, performance,
• tuning, backup recovery, monitoring alerting.
• Excellent interpersonal skills with an ability to work well in a team environment.
• Seeking contract or regular position with U.S. employer legal permanent resident with no sponsorship
• needed.

PROFESSIONAL EXPERIENCE:

SYBASE:

Sybase ASE, IQ and replication server installation, configuration. Apply patches ESD and/or EBF .

Database

nd Replication Server Management

• Database integrity checks with dbcc's, database reorganization, database backups, update statistics.
• Database security management with logins, users, roles password policies and objects permissions.
• Replication server security management with logins, users, passwords and permissions. Creation of routes
• and connections, creation of replication definition and subscription.
• Database and replication server troubleshooting during business hours and during on-call schedule.
• Definition of the databases backup/recovery standards and policies incremental or physical backups .

Database Backup Recovery

• Creation of backup shell scripts according to standards and policies specifications and integration with third-
• part tools like TSM.
• Backup validity and integrity checks, recovery checks. Database and replication server upgrades migrations
• Databaseupgrade migrationusing dump/load ,sqlupgrademethodsorlogicalmethodswithbcp,
• sybmigrate.
• Upgrade and migration of various replication server setup including warm-standby, multi-site availability
• MSA , standard replication or 2 way replication system.
• Database performance audit with Sybase tools sp sysmon, mda tables, application tracing, and asemon .

Database

nd R plication Server Performance Tuning

• Perform sql query optimization with Sybase ASE.
• Replication server's configuration parameters optimization to cut latency.
• Configuration and customization of various monitoring tools for the use of Sybase, Oracle, DB2 UDB products.

Database and Replication Server Monitoring Alerting

DB2

Development and deployment of customized monitoring and alerting system written in korn shell.

confidential

UDB LUW

Creating and configuring instances for non-partitioned environments and for multipartitioned environments

DB2 Instance : Administration and Configuration

• Creating and configuring a non-partitioned and multipartitioned database
• Creating and configuring table spaces within automaticstorage databases
• Creating and configuring buffer pools
• Creating and using MDC tables and block-based indexes Creating and using materialized query tables
• Implementing table partitioning
• Table of Contents Using temporary tables Created global temporary table
• Managing instance-level authorities Managing database-level authorities and privileges
• roles table encryption label-based access control LBAC to strengthen data privacy
• Performing an offline database backup Performing a full online database backup

DB2 Backup ad Recov ry

DB2

Performing an incremental delta database backup Performing an incremental cumulative database backup

Setting up HADR- Managing instances, members, and cluster facilities in DB2 pure Scale Monitoring DB2

High Availability

pure Scale environments

Using db2mtrk db2pd db2dart db2ckbkp db2support

Problem Determination, Event Sources, and Files

Configuring andsystem monitoring snapshot monitoring event monitoring Memory Visualizer

Monitorig DB2 Tuning and Optimization

Operating system tuning Resolving CPU bottlenecks Tuning memory utilization

RUNSTAT utility Tuning sorting I/O tuning Loading a table EXPLAIN PLAN

Architecturalof Oracle Database Installing and Creating a Database Instance Management

ORACLE:

• Oracle Networking Oracle Storage Oracle Security
• Configuring the Database for Backup and RecoveryBack Up with RMAN Restore and Recover with RMAN
• User-Managed Backup, Restore, and RecoveryFlashback Automatic Storage Management
• Moving and Reorganizing Data The AWR and the Alert System Performance Tuning
• Implementing, installing ,configuration and administration of High availability with Oracle RAC and Data

• Implementing, installing, configuration and administration of replication of data with Oracle Golden Gate.

EMPLOYMENT HISTORY:

IT Database Administrator, UTC AEROSPACE SYSTEMS - Monroe, NC September 2014 to Present

Responsibilities: Oracle, Db2 Database Administrator: Maintains database by identifying and resolving issues

Maintainsdatabaseperformancebyevaluatingcurrentperformance,adjustingvaluesfordatabase

supports Appl cation Ownrs and ensurs IT Scurity and Audit require

ts are being met.

• parameters and configuring metrics for meaningful alerts.
• Applying Critical patch updates Evaluating/Implementing maintenance releases as required.
• Proactively monitors database storage and memory requirements.
• Ensures data consistency with database backups and Disaster Recovery planning.
• Evaluating operating system parameters and hardware platforms for optimal performance.
• Working with Application Owners and Configuration Management team for maintenance window approval
• and scheduling.
• Provides documentation and Standard Work Instructions for maintaining databases.
• Coordinating support with Application vendors and 3rd party Infrastructure support teams.
• AssistsDeveloperswithdebugging,performancetuningandensuringthatbestpracticesfordatabase
• transactions are being met.
• Maintains quality of service by establishing and enforcing IT Policies.
• Contributes to team effort by accomplishing tasks within given timelines, supporting other team members
• and completing all Business requirements for training and compliance.
• Perform migration of ASM for 200 RAC databases from SAN storage DMX VMAX/VMAX2 toHitachi EMC

ORACLE, DB2 UDB LUW DBA Consultant, BNP PARIBAS, Paris, France BNL, Rome, Italy 2013- June 2014

• Upgrade 100 databasesGRID/RAC oracle 11.2.0.1 to 11.2.0.3
• Implementation, configuration Oracle Golden Gate for critical financial application in RAC environment.
• Effectivelytransferredtechnicalknowledgeto2DBAsinParisthroughonsitetraininganddetailed
• documentation of best practices, architecture and procedures for DB2 UDB LUW.
• KeymemberofDBAteamwhichsuccessfullyintegratedcomplexDB2databasesofsensitivefinancial
• information after merger of 2 large banks BNP France and BNL Italy .

ORACLE, SYBASE, SQL Server DBA Consultant, Natixis, Paris, France 2011-2013

• Performed daily DBA management tasks including troubleshooting, performance and tuning, database
• monitoring and backup/recovery.
• Responsible for verifying the integrity of critical backups for about 500 production databases in various
• environment namely Oracle, Sybase and SQL Server.
• production environments including a critical insurance application.
• Upgrade 250 databases from DB2 V.7 to DB2 V.8
• Windows NT System administrator, La roche Posay, Ch tellerault, France 1995-1996
• Performed daily system administrator Windows NT management tasks.

TECHNICAL SKILLS AND CERTIFICATIONS:

Operating systems

Sun Solaris, HPUX, IBM Aix, Linux RedHat, Centos, Windows server NT, 2000, 2003, XP .

Database Management System

Sybase ASE v11, v12, v15, SybaseOracleIQ v127/8/9/10g/11g/12c.5,v12.7,Sybase RAC,eplicationDATAGUARD ,OracleServerv11,v12,Goldenv15,Gate,MicrosoftDB2 UniversalSQLServerDatabasev7,2008V7/8R2,.1/9/10/10202,.5 DPF, HADR, DB2 Pure Scale .

Programming languages

T-SQL, SQL, PL/SQL,Unix shell ksh, sh, bash

Certifications

MCSE Windows NT 4, MCP Windows 2000, IBM Certified Database Administrator V8.1and V10.1.

DB2 10.5 for Linux, UNIX and windows

Boot camp ,IBM, Paris, France 2014

TRAINING:

• Boot camp, IBM, Paris, France 2012
• DB2 10.1 for Linux, UNIX and windows
• Administration of Replication Server v12.5, Sybase Inc, Paris, France 2004
• Administration of Oracle 8i and SQL Server 2000 , Pierre andMarie Curie University, Paris, France 2002
• Performance Tuning for Sybase ASE v12.5, Sybase Inc, Paris, France 2003
• Training Microsoft certified system engineer MCSE ,ENI, France 2000