Cyrille Tarla

Oracle Database Administrator

Anaheim, CA

Over10+ years of hands-on experience as an Oracle Database Administrator. Have complete life cycle (SDLC)knowledge and experience including Installation and configuration. I have worked on Oracle 11g, 10gversions involving database administration production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, database cloning, space management and security.

SKILLS SUMMARY

Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.

Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.

Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

Highly experienced in Oracle 11g, 10gAutomatic Storage Management (ASM) required to fulfill the storage needs.

High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.

Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).

Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 11g, 10g) for the purpose of monitoring multiple databases and application servers.

Highly experienced in using Oracle 10g features Flash-Back Recovery and Recycle Bin.

Experience with Oracle 11g/10g in Installation, Administration, Monitoring, Database Backup and Recovery.

Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.

Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.

Expert in RMAN backups including full, incremental and cumulative.

Expert in NETAPP backups and storage

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and Data Pump Import/Export tools.

Knowledge in configuring ASM (Automatic Storage Management)

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.

Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.

Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

Expertise in maintaining Database Security using auditing.

Extensive knowledge on scheduling Jobs with Jenkins

TECHNICAL PROFICIENCIES

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS

Oracle 10g, 11g, MySQL 5.6, MySQL5.7,SQL DB 2008r2, 2012R2

Languages

SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Jenkins, MySQL Workbench

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import

PROFESSIONAL EXPERIENCE

System Integration Engineer THALES DIS USA 08/2020-04/2021

Overseeing biometric system project phases, from verifying system specifications and project requirements to performing the system configuration, integration, testing, troubleshooting, deployment and system acceptance.

Taking lead role in delivering the biometric projects that secure the digital lives of millions of people.

Serve as a System Integration Engineer in the implementation of complex system integration projects from design to production launch, and coordinate project activities effectively among Project Mangers, Developers, IT, Support, and Documentation teams

Analyze customers’ requirements, review project SOW and RFP, develop high level system architecture and develop high level project implementation/delivery plan.

Work with PMs and Developers to kick-off the project and track progress

Collaborate with IT, DBA, and other teams during system deployment, collaborate with software developers to perform product customization and configure the systems to satisfy customers s needs.

Set up and configure the system in Windows and/or Linux environment, write program using Python or Unix Shell or Oracle PL/SQL etc.

Provide system integration support and troubleshooting of the system, provide system knowledge transfer and training to technical support team, and document the design specifications, installation procedures, and other system related information.

Manage multiple projects with time constraints under pressure and go to the customer site to implement the biometric system.

Interact with the customer to ensure that SOW and RRP meet customers’ s expectations on content and schedule.

SYSTEM ADMIN/DBA Unified Tech/Stowe Research - Pasadena, CA

March 2017- August 2020

Production DBA and Systems Admin for Tokio Marine providing 24/7 support on business-critical systems.

Proactive monitoring and capacity analysis facilitated low downtime on servers responsible for.

Expert database tuning, performance bottleneck work and system design for performance.

Implemented partitioning and archiving strategy on a 4 million rows per day VLDB.

Perform Weekly Tape backups using Arcserve.

Experience with Arcserve Tape Backup and Storage on Windows Server 2012R2

Daily monitoring and quarterly health checks performed for all clients' servers.

Environment: SQL Server DB 2008R2, Windows server 2012R2, Windows 10 Pro 64bit.

REMOTE SR DBA American Valve Center - Miami, FL

May 2016- Jan 2017

Production DBA for American Valve Center providing 24/7 support on business-critical large systems.

Clients such as Auto companies and provided large throughput, big

data OLTP processing experience.

Proactive monitoring and capacity analysis facilitated low downtime on servers responsible for.

Expert database tuning, performance bottleneck work and system design for performance.

Implemented partitioning and archiving strategy on a 4 million rows per day VLDB.

Worked with client to migrate system from Oracle to SQL server 2012.

Technical lead and mentor for other DBAs.

Daily monitoring and quarterly health checks performed for all clients' servers.

Environment: Oracle Database 11.2.0.3, MySQL 5.6.3 NDB-Cluster 7.3.7 SQL Server 2012, REHEL6, Sun Solaris, Windows7 enterprise edition.

Sr Oracle/MySQL DBA Toyota Motor Sales LA, CA

Mar 2015- April 2016

Install and configure new databases based on best practices

Perform day to day database administration on existing databases including implementing patches and upgrades as needed

Work with development team in optimizing SQLs.

Participate as a member of the engineering teams for database-related tasks

Develop, test, and implement the appropriate backup procedures

Design, test and implement Oracle and Enterprise MySQL high availability solutions

Maintain effective database performance monitoring procedures.

Perform database tuning for optimal performance to meet Business SLAs

Control and monitor user access to databases and maintain database security

Allocate storage and develop plans for future storage requirements

Maintain documentation of systems and standard operating policies and procedures

Resolve development and QA database requests.

Provide technical assistance and mentor junior members of the team

Be available for rotating on-call

Used Perl/shell scripting in creating and automating chron jobs.

Environment: MySQL, 5.5.40, NDB- Cluster, 7.2.18, MySQL 5.6.30, NDB-Cluster, 7.3.7,-Oracle 11G RAC/11.2.0.3,REHEL 6, Sun Solaris.

Oracle Database Administrator, Ishglo-One Corp, Fredrick, MD Jun 2013 – Mar 2015

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

Installed Oracle 11g on Linux platform using ASM.

RMAN point in time recovery and Instance recovery done on 11g.

Developed compliance reports and performed auditing at higher levels.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.

Capacity planning: Allocate system storage and plan future storage requirements.

Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer, Foglight.

Monitoring rollback segment and temporary table space use.

Performing housekeeping tasks like checking log and trace files.

Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

Performing monthly and annual performance reports for trend analysis and capacity planning.

Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Worked on both VMS and UNIX environments.

Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Experience in writing UNIX/SHELL scripts for providing the reports.

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Wellpoint Insurance INC – Richmond, VA June 2011 – June 2013

Oracle Production Support Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10gGrid Control.

Loading data from flat files to database using SQL*Loader, External Tables.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 10g/11g environments.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 10g (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

ChaveranInc - Bowie, MD Mar 2010 – June 2011

Oracle Production Support Database Administrator

Installed and configured ORACLE 10g on HP-UX and Windows NT.

Performed Upgradation of databases from Oracle 8i to Oracle 10g.

Planned and implemented physical backup (both hot and cold) & recovery procedures for the database using RMAN utility of Oracle 10g.

Implemented coalescing when required by monitoring the database for fragmentation.

Performing table space management, monitoring data files additions, extent growth, normalization, indexing as a part of day-to-day activities.

Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.

Prepare the documents of the process and knowledge transferring about the project to the new team members.

Created, maintained and troubleshoot PL/SQL objects, shell scripts and utilities.

Implemented proactive monitoring using STATSPACK, SQL TRACE & TKPROF, EXPLAIN PLAN.

Separated the indexes, data, rollback segments and redo log files on separate disks to minimize contention, Monitored the buffer cache hit ratio and the dictionary cache miss ratio. The DB_BLOCK_BUFFERS and SHARED_POOL_SIZE were increased, resulting in tremendous improvement in performance.

Creating the users and assigning them the required privileges.

Provided 24x7 on-call support as needed.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Recruiting and Retention Battalion Reisterstown, MD Mar 2009 – Mar 2010

Unix Administrator

Part of the team which was responsible for the overall management of the LAN/WAN.

Installed, configured and administered network devices such as routers, switches and

hubs and performed LAN/WAN routine maintenance and troubleshooting.

Overall responsible to ensure reliable and consistent LAN/WAN network performance and Services.

Implemented and administered Virtual Local Area Networks.

Administered Remote Access Server and defined its network security policies and User accounts.

Installed and administered NT servers for 100+ users.

Backup and Recovery as per the defined backup Strategies.

Installed security programs such as Public Key Infrastructure (PKI) into the military computer network using the Remote Installation System (RIS) programs.

Designed desktop account security parameters on one workstation which served as template for all terminals.

Monitoring of the system performance and corrective action for smooth functioning of system.

Installation and configuration of Windows NT 4.0 and MS-Proxy Server.

Hardware Maintenance

Environment: Windows 95 /98, Windows NT 4.0, MS-Proxy Server, FTP Server Print Server, MS-Exchange Server 5.5'CISCO Router 1700 Series and 3COM - Switches.

EDUCATION

Oracle Database 11g Administrator Certified Associate

BSc System and networking with coursework in engineering (IAI)- 2012

Contact this candidate