SUMMARY:

• Senior Oracle DBA with 5+ years of experience supporting applications hosted in latest versions of Oracle database
• Experience working in various databases including Oracle 10g, Oracle 11g, Oracle 12c
• Currently analyzing the multi - tenancy architecture to determine whether consolidating the acquired products will be beneficial for our business
• Proficient in analyzing the production issues and determining the stack responsible for the issue
• Proficient with escalation procedures, creating service tickets meeting SLA, working with developers, business analysts, project managers by participating in cross-functional team meetings, project meetings to clearly communicate end-client expectations in the form of new feature request, feature enhancements, bugs in current products etc
• Experienced in creating tar with Oracle using Oracle metalink, following up on SR giving appropriate priority to the issue, following up with Oracle support on as needed basis, implementing the fix as per Oracle recommendations
• Script developer automating operational tasks using windows batch scripting, Shell (ksh, sh, bash)
• Proficiency in working with advanced Oracle technologies including RMAN, Datapump, Dataguard, RAC
• Proficient PL/SQL developer creating reports, PL/SQL procedures to automate tasks
• Managing schemas that do store, manage, maintain information in XML format. The xml datatypes are needed for supporting a latest feature in our product
• I’ve undergone MongoDB training from Mongo university and know format of JSON
• I’m currently undergoing HDP essentials training from hortonworks in my part-time out of my own interest. This is an attempt to expand my knowledge in bigdata domain to support an upcoming healthcare analytics project
• Interested in learning and expanding my knowledge. Avid reader and self-learner

TECHNICAL SKILLS:

Database Client Tools: SQL*PLUS, iSQL*PLUS, TOAD

Databases: Oracle 10g 10.2.0.4, Oracle 11g 11.2.0.4, Oracle 12c Currently evaluating 12.1.0, SQL Server 2005, Sybase ASE 12.5, MySQL 5.0,MongoDB 2.6

UNIX: Solaris 9, Solaris 10, Linux RHEL, HP-UX, Fedora Core Linux 5, AIX5L, AIX 6,Ubuntu 10.04 LTS

Server Hardware: SUN Enterprise Server E4500, E5500, Sun Fire E480, Ultra-8 SUN Workstation

Database Utilities: SQL* Loader, exp/imp Datapump, Flashback Query, ASM, tkprof, ADDM, DBMS Packages, opatch, DBUA, DBCA, emctl, emca, lsnrctl, crsctl

Scripting Languages: Shell (csh, ksh, tcsh, bash), PERL, SQL, PL/SQL

Oracle Applications: 11.5.10, R12

DBA Concepts: RAC, Dataguard, OEM, SQL Server 2012

Backup Tools: RMAN

Source Control Tools: IBM ClearCase (conversant using commandline and visual GUI)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Being part of ultimate support team I’m responsible for all aspects of application support. This primarily starts at data layer but not limited to IIS server, front end JavaScript issues, application performance issues to name a few
• Create a ticket in Quality center upon receiving escalation form field engineers and start investigation meeting SLA
• Collect the logs from server as well as database that comes as first-hand information to start investigation
• Communicate and co-ordinate with personnel to get more details on the issue if needed
• Escalate the customer requirement to Project Management team if this happens to be a new requirement that is currently missing in product
• Upgraded 10gR2 databases to 11gR2 .Currently started analysing Oracle 12c and its applicability, advantages of using it in our stack
• Regularly export and import database to avoid defragmentation after a maintenance task
• Made use of expdp, impdp tools
• Created batch files, .sql scripts tools to address different database tasks
• Implemented high availability solution using Oracle dataguard 11g
• Learnt schema design in less than a week and started working on production issues in as less as 12 days
• Evaluate Oracle CPU once in three months and provide recommendations to upper management
• Perform health checkup of systems using oracle supplied tools like awrrpt.sql,addmrpt.sql and provide recommendations as needed
• Perform backups and restore, handle issues related to backup and restore using RMAN
• Handled the migration of databases from English to localized languages. Made use of expdp/impdp to accomplish this task successfully
• Investigate DB corruption issues by using dbv utility, dbms repair and such tools related to database
• Good understanding of oracle internals
• Perform database statistics collection as and when needed
• Monitor the validity of database backups using automated scripts
• Create PL/SQL programs and tools. Extensively made use of sqlldr tool to upload the information
• Medical Imaging Software specific: Very knowledgeable on image management DICOM standards, HL7 interfaces, RIS, HIIS, IHE the latest protocol to enable integrated healthcare management. Very good knowledge on DICOM concepts like C-FIND,C-MOVE, C-STORE. Good knowledge on using RIS scheduler, RIS simulator to simulate issues related to front end ordering and patient management systems. Solved issues relevant to PACSCUBE and related CD burning software

Confidential

Responsibilities:

• Continuously check the support escalation inbox
• Upon receiving an escalation, we create a tracking ticket in our bug tracking system quality centre
• As a first step, we work with field engineers and help them get us gotoMeeting, gotoAssist (or) Teamviewer support session
• We connect to site remote and start issue investigation by collecting necessary data from site and analyze the information collected
• If the issue happens to be an issue that can be fixed on the fly, we immediately notify the customer, get the approval and with the help of field engineer fix the issues using any one of the remote console tools mentioned above
• If this issue demands downtime, we provide clear information on root cause of this issue, nature of this issue, potential impact, need to fix the issue to the customer routed via our field engineers. Upon approval we perform tasks at scheduled downtime

Confidential

Database Support

Responsibilities:

• My primary responsibility as a Senior Oracle DBA involves monitoring escalation inbox, create a ticket as and when we receive escalation, co-ordinate with field engineers to start issue diagnosis, fix issues on the fly or during scheduled maintenance. Common database issues that we handle on day to day basis include
• Fix the database block corruption issues - We run dbv, identify issues, perform database refresh in test server to calculate downtime, ask customer to perform end to end testing, backups and finally perform steps in production during scheduled downtime
• Work on down site - Typical sites come with requests saying that site is down. As a first step we start investigation by looking at alert.log, trace files to see what causes the issue. If we find ORA-600, ORA-7445 crashes we proceed further
• Work with Oracle support - As first step in investigating issues we try to find solution in Oracle metalink. If we couldn’t find something as a next step we work with Oracle support to find a fix on the issue
• Backup Issues - Backup failures reported in rman.log typically get sent to us. We work with site engineer to fix backup issues
• Database Health Check Monitor - On an as needed basis typically before and after migrating data we get requests to perform health check of databases. We check for tablespace freespace and add more datafiles if needed, look for statistics collection after data migration and gather statistics if needed, run AWR report and determine there are no poorly performing sql’s to name a few. In addition we have in-house database tools needed to check OS level resource utilization that we make use of for checking database health

Confidential

Evaluation, Analysis, Patch Installer

Responsibilities:

• Oracle Critical Patch Updates, CPU as they are popularly called gets published once in every quarter. Our customers running on windows need complete patch analysis. All these customers are high profile customers, government agencies that need periodic report in system security threats if any
• Once the patch gets published, I download the patch, create evaluation report by getting list of bugs fixed by the CPU that comes as part of readme.html
• After analyzing the patches and determining the possible impact if any, I route this report to development DBA’s. They come up with their inputs based on which I put my final comments and submit report to my DBA Manager. My manager makes decision on whether to make patch install mandate (or) optional
• I create patch Installer by co-ordinating with installation automation developer - Originally the database related scripts needed for patch automation has been created by me
• We create an automated patch installer that I make use of to test in our local test machines. I maintain the ESX server for our team. Before installing patch I take snapshot of the current env, install the patch and perform end to end functionality testing.Once done based on results I work with product publication Team Manager and publish the patch to our 5000+ global customers

Confidential

Responsibilities:

• As a DBA there are scenarios wherein I need to get the backup copy (RMAN backup) of database from global sites, perform restore and recovery internally. To proceed with these scenarios, I create and maintain our own virtual test servers
• Internal test servers are used for testing of database development tools before they get integrated as part of product before final product release (major version or patches)
• Internal test servers are used to determine if field issues can be reproduced - This demands making of snapshots at different versions that can be reverted to on as needed basis. If we reproduce a typical issue internally this is essentially due to the fact that this is a bug in that particular release. If we find one, this is co-ordinated with developers, fixed and we test this if the scope of bug is database. For such testing again vmware server environment becomes mandate
• 24x7 support and off-hour support on as needed basis
• As a part of global support team, I carry DBA support phone once in every 3 months. On an average I provide support 4 months every year
• On an as needed basis like customer scheduled downtime I co-ordinate with customers and help them fix the database issues. Typical issues like fixing datablock corruption, patching highly sensitive database environments etc

Create PL/SQL Tools

Confidential

Responsibilities:

• Our business has a provision for customers to demand some adhoc tools mostly reporting tools to get reports in .csv format. Such requests get routed to our team
• I create a ticket on such requests and develop simple tools using pl/sql programming that are automated using batch scripts
• Supporting SQL Server 2012 Running Third-party vendor Apps:
• My manager wanted to leverage my database skills and asked me to learn sql server to support one of our in-house application that run on sql server 2012 enterprise. I’ve performed the following tasks in sql server environment
• Created and scheduled maintenance plan to collect statistics, perform backup - full, incremental, transactional
• Worked with Microsoft support and increased the temp database size

Confidential

Responsibilities:

• Our business marketing team will meet up with us as and when a new version of Oracle database gets released
• Every year we get to meet people from Oracle in webinars that involve showcasing of latest products from Oracle
• We perform analysis and determine new features that can be availed from current Oracle release - As a simple example currently we are evaluating full export/import option that comes as part of 11.2.0.3 to upgrade databases that will minimize downtime

Confidential

Database Administrator

Responsibilities:

• Involved in capacity planning phase of database implementation
• Created database objects like tables, indexes, views, synonyms, sequences
• Created, altered, dropped online redo log files
• Upgraded Oracle 9i to 10g
• Configured Replication using Oracle Streams
• Setup standby databases (physical and logical) using Dataguard
• Implemented 3 node RAC cluster to ensure high availability of databases
• Conducted in-house training to facilitate junior DBA’s
• Created triggers to monitor various database activities
• Assisted development team in their quarterly product release
• Performed rebuild of indexes every 2 to 3 weeks
• Assisted DBA’s with server issues. Databases were hosted on RHEL 5 servers

Confidential

Oracle DBA - Application Support

Responsibilities:

• Automated startup of database in Linux
• Created and managed database users, OS users, OS groups
• Configured archive log mode
• Involved in SOX audit. Hardened servers to be SOX compliant
• Disabled all the default system accounts
• Automated many system admin operational tasks using shell(ksh, bash, tcsh) and Perl scripting
• Developed an Confidential system with Perl as front end and MySQL as back end

Confidential

System Developer/DBA

Responsibilities:

• Involved in analysis,design,implementation and documentation of internal system
• Basic job is to extract information from MySQL backend database and display it in front-end using Perl script
• Gained great experience using LAMP stack and learnt scripting languages including PHP, Python
• Created scripts to automate the startup and shutdown of MySQL databases
• Created and optimized SQL scripts, stored procedures and optimized the queries
• Performed backup and recovery operation of mysql database

Confidential

System Administrator

Responsibilities:

• Involved in Security Implementation project as per guidance from InfoSec team. Security Policies are in compliance with SOX(Sarbanes Oxley- 404 - Assessment of Internal Control) act
• Configured Master/Slave replication of MySQL database. MySQL database was the backend of internal Confidential system
• Involved in capacity planning and gave proposals relevant to sizing of storage
• Performed Backup and Recovery of Servers using IBM TSM (Tivoli Storage Manager)
• Involved in preparation of disaster recovery plan, assisted with trial runs on failover and fallback storage setup
• Extensive experience in using editors like vi, emacs
• Experience in using NFS(Network File System)
• Experience in administering NIS (Network Information System) users. Managed NIS users
• Automated Operational tasks using scripting like csh, tcsh, sh
• Patched UNIX/Linux servers on a regular basis. Secured OS by applying patch fixes
• Secured UNIX/Linux server access by monitoring server access logs on a regular basis, checking for failed login attempts, securing root user(Superuser) access
• Secured the access of Apache Webserver by configuring .htaccess file