[pic][pic] [pic]

ANTONY R PATHROSE

acg9t3@r.postjobfree.com

Ph: 201-***-****

PROFESSIONAL SUMMARY

. Lead Oracle Database Engineer with 10+ years of experience in

administering and architecting database systems, managing database

projects, mentoring junior DBAs, and advising developers on database

best practices.

. Oracle Certified DBA Professional with expertise in HA and DR solutions

including Oracle Real Application Clusters (RAC), Data Guard and deep

knowledge of Oracle internals.

. Oracle Certified PL/SQL Associate, proficient in SQL development and

performance tuning.

. Sun Certified Solaris Systems Administrator with over 12 years of

experience on Linux, Solaris, AIX and Windows environments.

. Extensive experience in administering database systems on a variety of

SAN and NAS systems, VMware and bare-metal environments, ASM, cluster

file systems and raw devices.

. Proficient in shell scripting, strong automation skills, conversant in C

and Object Oriented programming.

EDUCATION

M.S. Computer Science, Florida State University.

B.E., Computer Science and Computer Engineering, Madras University.

CERTIFICATIONS

OCP- Oracle DBA Certified Professional.

OCA - Oracle PL/SQL Certified Associate.

SCSA - Sun Certified Solaris Systems Administrator.

TECHINICAL SKILLS

Databases/Related Tools: Oracle 11g/10g/9i/8i/12c, RAC, RMAN, Data Guard,

OEM, AWR, Oracle Apex, SQL*Loader, Datapump, MySQL, SQL Server.

Languages: SQL, PL/SQL, Shell scripting, C, C++, Perl, PHP, Java.

Environments: Red Hat Enterprise Linux, Solaris, VMware, EMC Data Domain,

Puppet, Weblogic Server, Apache HTTP server, Netapp, EMC/IBM SAN/NAS

Storage Systems, Jira, AIX, Windows.

PROFESSIONAL EXPERIENCE

The New York Times, NYC

March 2013-Present

Lead Oracle DBA

As part of the core infrastructure engineering services team, I architect

database solutions, engage in capacity planning and POC exercises, enforce

standards and PCI compliance, lead a team of DBAs providing systems,

production and development support to companywide databases including

ecommerce, advertisement, BI and Newsdesk systems.

Responsibilities include:

. Install, configure, upgrade and administer Oracle RAC and Oracle

Restart databases on virtual and bare-metal servers.

. Clone databases, setup Oracle dataguard for Disaster Recovery,

replicate data from OLTP databases to reporting databases using

materialized views.

. Employ VMware's virtualization technology and puppet to create Oracle

RHEL installation template for rapid provisioning of Oracle database

servers in minutes.

. Manage database projects, mentor team members, ensure license

compliance.

. Develop end-end completely automated tools for cloning Oracle

databases and creating Oracle standby databases.

. Leverage EMC data domain to improve cross-environmental data refreshes

and RMAN backup jobs.

. Optimize application sql code, develop bash and sql utilities for

diagnostics and troubleshooting, automate configuration management and

deployment using puppet, resolve Jira Service Requests, write SOPs.

. Troubleshoot database issues, collaborate with systems, virtualization

and storage teams in performing root-cause analysis.

. Interface with application vendors to integrate 3rd party applications

in conformance with the NY Times' standards.

.

Environment/Tools: Oracle 11g RAC, dataguard, Red Hat Enterprise Linux,

CentOS, VMware, EMC VNX, Data Domain, SQL, PL/SQL, RMAN, ASM, nagios,

shell scripting, puppet, perl, Jira.

StreamWIDE Inc., New Jersey

December 2009-March 2013

Senior Oracle DBA

Headquartered in Paris, France with subsidiaries in the USA, Romania and

China, StreamWIDE is a global telecom services company providing value-

added services (VAS) for telecom carriers and operators in more than 35

countries.

Responsibilities included:

. Work with a global team of DBAs in ensuring 24x7 production support

for customers in over 35 countries.

. Provide development support to R&D teams in the USA, Europe and Asia.

. Administer Oracle 11g/10g RAC, data guard and MySQL 5.x databases --

new database installations, upgrade to new versions, capacity

planning, database design, disaster recovery.

. Audit customer database environments for conformity with StreamWIDE's

standards.

. Develop sql/plsql programs and shell scripts for database maintenance

jobs.

. Develop scripts to migrate databases for new product releases.

. Optimize queries, troubleshoot database issues, resolve customer

support tickets.

. Participate as the technical resource on sales calls with potential

customers, train pre-sales and sales team on database features and

capabilities.

. Employ Oracle Enterprise Manager DB Control for data base

administration, monitoring and troubleshooting.

. Implement composite partitioning of large tables to improve

performance, data purging batch jobs.

. Improve RMAN backup strategy to increase window of recoverability.

Environment/Tools: Oracle 10g/11g RAC, dataguard, MySQL, Red Hat Linux

Enterprise Server, IBM DS4200 SAN, Netapp NAS, SQL, PL/SQL, ASM, shell

scripting, PHP, Perl.

SharedBook Inc., New York City

April 2005 - December 2009

Senior Oracle DBA

SharedBook Inc., is a Custom Publishing Company (www.sharedbook.com ) that

offers an on-demand publishing and collaborative platform for Internet

users to extract content from multiple sources, customize and distribute

their unique creation online or in print.

Responsibilities included:

. Install and configure Oracle RAC from ground-up.

. Perform tasks in the areas of capacity planning, database systems

design, DBMS installation, upgrades, performance tuning, backup and

disaster recovery.

. Provide production and application development support for all RAC and

standalone databases in production, development and UAT environments.

. Manage database projects, work with Oracle Sales on new software

purchases/license pricing,

. Configure, administer and monitor the Oracle9i/10g Real Application

Cluster (RAC) instances running in the production, development and QA

environments.

. Upgraded Oracle 9i RAC to Oracle 10gR2 RAC and configured OCFS2 on red

hat enterprise Linux environment.

. Develop SQL scripts and PL/SQL stored procedures and packages for

purposes of database monitoring and report generation for the

management to drive their business/marketing strategy.

. Configure Oracle Enterprise Manager Grid Control and use it for data

base administration and performance monitoring.

. Configured Oracle Application Express (apex/htmldb) to facilitate a

rapid web development environment and used it develop web

applications. Developed an apex web application for the customer

service team to track orders and lookup customer information in the

database.

. Troubleshooting database performance issues using Oracle diagnostic

tools/utilities like AWR, Statspack, ADDM and OS tools like top,

vmstat, sar.

. Write UNIX shell/Perl scripts to automate database processes and jobs;

write awk, sed scripts to handle adhoc text manipulation needs.

. Used oracle data pump utilities to migrate data between databases and

between schemas.

. Analyze redo/archive logs using LogMiner, to determine when/what

changes were made to the database at various points in time in the

past.

. Work with the Systems Administrator in configuring, monitoring and

growth-trending the storage space on NetApp filers. Use Netapp's

'snapshot' ting technology to take near instantaneous backups of the

database.

. Work with the development team in analyzing query performance and

recommend optimizations to the application architecture team on

database design.

. Integrate data from heterogeneous databases, Oracle and MySQL, to

generate consolidated reports.

Environment/Tools: Oracle 9i/10g RAC, OCFS/OCFS2, Red Hat Enterprise Linux,Weblogic, Apache Http server, NetApp storage solutions, SQL, PL/SQL,

J2EE, RMAN, Shell scripting, Perl, MySQL,Oracle Application Express.

Bank of America Investment Services, New York City

September 2007 - October 2007

Senior Oracle DBA Consultant

Responsibilities included:

. Administer Oracle RAC databases, work on the oracle 9i to 10g upgrade

project, install oracle 10g, tune application sql queries, recommend

optimizations.

. Monitor the health and the load of the systems during peak market

hours, prepare change requests, open Oracle SRs, follow up vantive

cases to troubleshoot and resolve production issues and determine

effective solutions.

. Work on the globalization/database characterset conversion project to

support non-ASCII characters.

Environment/Tools: Oracle (64 bit) 9i RAC/10g, Solaris 64-bit 9/10, Veritas

Cluster File System, Netbackup, Dataguard, SQL, PL/SQL, shell scripting,

Weblogic.

CHANNING-BETE COMPANY, MASSACHUSETTS

November 2004 - March 2005

Oracle DBA consultant

Channing-Bete Company is a niche publishing company specializing in

producing information resources for customers such as America Heart

Association, US National Army, Prevent Child Abuse America (PCAA).

Responsibilities included:

. Provided production-support, managed and maintained the company's E-

Commerce production, standby, development and UAT databases and the

health of the Solaris servers that hosted these databases.

. Revamped the old backup/recovery strategy and implemented a better,

robust strategy to ensure high database availability and to reduce Mean

Time To Recover (MTTR). This included increasing hardware redundancy to

avoid a single point of failure, performing incremental, cumulative

backups, implementing backup procedures, testing backups and preparing

Disaster Recovery plan.

. Analyzed the Oracle Text based search engine on the Channing-Bete portal

and prepared efficient queries based on a better indexing scheme to

expedite search response times.

. Converted legacy Objective C code written for the

EnterpriseObjectsFramework based WebObjects Application Server into

equivalent SQL queries to be executed through JDBC.

. Set database audit trail, complemented that with trigger based auditing,

to detect unauthorized access to critical data. It was also used to

reverse-engineer the functionality of the legacy Objective C-based

"batch update" application against the database.

. Developed PL/SQL stored procedures to encrypt private user-information

like credit card information, address etc., before storing them in the

public-tables.

. Installed and configured Solaris 8 and Oracle 9i to set up a UAT

environment for the QA team.

. Developed SQL scripts to facilitate routine database lookups, database

book-keeping, statistics collection, purging old data etc.,

. Prepared comprehensive SOPs (Standard Operating Procedures) on the

various database processes involved.

. Wrote cron scripts to ship production DB archivelogs to standby servers

periodically and automate nightly disk and tape backups.

Environment/Tools: Oracle 8i, Solaris 8, Mac OS 10.2.x, SQL, PL/SQL, RMAN,

Export/Import, Shell scripting, WebObjects, Java, MySQL.

Contact this candidate