OBJECTIVE

• Oracle/Mysql/Sql Server/DB2 database administration or database consultant position with opportunity towards database design, implementation and operation in a challenging business environment
• QUALIFICATION
• 15 years' industry experience as DBA/Developer
• Oracle 8i, 10g Certified Professional/ DB2 UDB certified professional
• Strong Oracle Production DBA experience
• Full life cycle database design, development and administration
• Extensive Database experience and knowledge in Oracle, MySql, Sql Server, IBM DB2
• Demonstrated excellent communication skills and team leadership

TECHNICAL SKILLS

• DBMS: Oracle 8i/9i/10g/11g, /Mysql/DB2/Sql Server
• DBA tool: RMAN, OEM, TOAD, ERWin
• Languages: Shell script, Perl, Python, SQL, PL/SQL, Java, C/C , HTML
• OS: Solaris 8/9, Unix, Linux RedHat, Windows, HPUX, TRU64

PROFESSIONAL EXPERIENCE

Confidential

Operational management of 100 mysql databases, some located in amazon AWS for various clients such as IGN, Rockyou, Adobe. Performed troubleshooting various operational issues including replication failures and performance issues. Wrote detailed mysql instance review and analysis as well as reports for high availability and disaster recovery scenarios. Performed upgrades of mysql server from 5.0 to 5.5

Confidential

Operational management of 200 databases including Oracle 8/9/10g/11g on unix, linux and windows, Mysql database on linux platform, IBM DB2 7.2 and 8.2 on Aix and Sql Server 2000, 2005, 2008 and for various major clients such as American Airline, Bestbuy, Gap, Jet Blue, Hayatt, Sony, Borders and Scholastic.

• Day to day operational responsibilities included:
• health diagnostics and continuous monitoring of all the databases,
• managing backups and testing failover systems,
• performance enhancement/tuning issues such as blocking, resouce contention issues
• troubleshooting major technical issues such as database outage situations and emergency
• develop shell script / sql scripts for monitoring and diagnosing db health and issues

Confidential

• Develop sql queries and stored procedures for analyzing and processing various complex datasets related with medicare/medicaid payment processing
• Develop multi-threaded cold backup scripts and other database maintenance scripts.
• Monitor and analyze database configurations and performance problems using trace and statspack.
• Install oracle 10g/9i rac on Solaris and Redhat ES4.0 linux with NFS netapp
• Upgrade/patch oracle 9i databases on Solaris and Redhat ES4.0.

Confidential

• Test RMAN and oracle 10g for potential upgrade to existing infrastructure.
• Test RAC database silent install/upgrade from 9.0.1 to 9.2.0.6 and apply patches to fix intermittent oracle database errors.
• Perform graceful switchover between production RAC and disaster recovery RAC. Create and maintain standby database for RAC production system.
• Administer Oracle 9i RAC database with two nodes on HP-UX, and Oracle 9i database on Redhat ES3.0.
• Perform tuning under high load stress test scenarios and data retrieval involving log mining, flash back query, session tracing and tkprof.
• Create backups and export jobs for Microsoft Sql server 2000, create Transact sql stored procedures.
• Create and modify stored procedures for Oracle as well as for MS sql server.

Confidential

• Design and develop and maintain PL/SQL stored procedures
• Administer Oracle 9i and standby server on Windows Server
• create perl scripts for monitoring database
• Adminster sql server database instances, troubleshoot operational issues

-

Confidential

• Develop/Maintain Oracle database and application for processing user site submissions, and then subsequently migrate to Mysql
• Develop Java servlet based web reporting tool for internal users of Altavista to gain access to the data warehouse content as well as the Trusted Feed/Express inclusion Service data
• Develop Java multi-threaded program to fully automate data processing/loading/querying/reporting on 24 instances of Mysql databases on Linux boxes redhat 7.2 using multi-threading/JDBC.
• Develop Java multi-threaded program/ database schema to automate collection of domain registration information from over 100 domain registrar databases
• Administer Oracle database on Compaq Tru64, develop Java stored procedure, Pl/Sql procedures and Shell scripts to automate processing of XML feed data for Trusteed feed/Express inclusion service offered by Altavista.
• Administer Oracle database on Redhat Linux on x86 platform for partnersite paid inclusion program. And in addition, contributed to tuning, debugging and extending Java based partnersite application 600 classes . Also setup standby database.
• Administer/monitor existing MS SQL Server instances in conjunction with data transfer with Oracle instance.

Confidential

• Create and maintain daily reporting scripts to compile detailed user activity analysis on the Eyetide website.
• Create and maintain PL/SQL scripts for Eyetide production database.
• Developed JSP based tools for comprehensive partner and internal reporting.
• Developed servlet driven content management tool involving 100 servlets to edit/manage/deploy content on Sayit database/website. Deployed on Apache/JRun/Linux platform to access Oracle 8i production database.
• Maintain 24X7 Oracle 8i database
• Install Oracle 8.1.6/Solaris 8, along with Sun Disksuite, and APS alternate pathing software for Sun E4500 and E450 with A5200 disk array.Performance testing with various configuration on striping sizes.
• Plan, test and perform switchover of the production database to E4500 from NT Oracle.

Confidential

• Administer Sayit production database Oracle 8i
• Test and verify hot backup and full export strategies.
• Create and maintain daily reporting scripts to compile detailed user activity analysis on the Sayit website.
• Create and maintain PL/SQL scripts for Sayit production database
• Solve performance problems related to batch updates using standby tables
• Java client/server side development using IBM visual Age, JDK1.2 and RMI. Extend and debug programs for Sayit card editorial using RMI, JDBC/Oracle 8i and Glimpse search.

Confidential

• Install/administer Oracle 8.1.5 Oracle 8i on Solaris 2.6/ E4500 with A5100 Storedge disk array. Test develop/benchmark different approaches to optimizing data access performance in large data warehousing environment using Oracle 8i features.
• Successfully troubleshoot several production database problems involving inexplicable delays, export problems and triggers.
• Administer Oracle 8.0.5 on Solaris 2.6/ E4500/E4000 using Enterprise Manager, Sql plus, command line utilities and unix scripts. Work with OLTP and historical data warehouse instance.
• Perform automated backups and exports using unix cron jobs.
• Perform tuning of Oracle instance using Performance Manager, Oracle expert, utlbstat/utlestat. Perform tuning of triggers, indexes and stored procedures using explain plan.

Confidential

• Database migration of Oracle 8.03 Enterprise from Solaris on NT Server
• Administered and tuned the Oracle database.
• Use Java Web Server, IIS/Jrun and Oracle 8.0.5 for backend to develop website for viewing bill of material online.
• Use Visual Basic 5 to develop NT service for supervising retrieval and storage of power generation data to Oracle database and for automated launching of diagnostic engine application..
• Used Visual C 5 for development of data access layer component, and for developing DLLs components to speed manipulation of power generation data with VB5 application
• eveloped application for assisting report generation using VBA/DCOM.

Confidential

Working with VB4.0/3.0 primarily to develop Man-Machine interface, program for industrial applications and using DDE and Custom Controls to interface to other applications.

Confidential

Worked independently to successfully develop a set of user interfaces to Access database using Visual Basic 4.0.