SUMMARY:

• Have over 18 years of experience as a Certified Oracle Database Administrator working on various platforms like UNIX and Windows.
• Over 4 years of experience leading the database and business tools team, planning, budgeting and people management.
• Some of the management work includes Data Maintenance, Database Management, Promoting Process Improvement,
• Presenting Technical Information, Database Design, Reporting Skills, Quality Focus, Technical Understanding and Attention to Detail, Thoroughness and Requirements Analysis.
• Involved in decision making of both project and maintenance budgeting, portfolio budgeting and standard core budgeting. As a manager, was involved in employee appraisal and performance management.
• Worked closely with vendor on vendor management and was key decision maker in product purchase.

SKILLS PROFILE:

Hardware: HP, SUN systems, Pentium systems

Operating Systems: UNIX (HP, SUN), Windows 2016, Linux

Software: SQL*DBA, Server Manager, Business Objects, Tableau, IBM SPSS Data Modeler, SQL*Net, Oracle Enterprise Manager, Performance Pack, Statistics Pack, Golden Gate

Languages: SQL*Plus, PL/SQL, UNIX Shell script

Database: Oracle 10g/11g/12c, SQL Server, DB2 on Mainframe

PROFESSIONAL EXPERIENCE

Director, Database and Business

Confidential, Smithfield, RI

Responsibilities:

• Confidential is an international provider of financial services and investment resources that help individuals and institutions meet their financial objectives. Once known primarily as a mutual fund company, Fidelity has adapted and evolved over the years to meet the changing needs of its customers. Today, that evolution is reflected in the menu of products and services. In addition to more than 300 Fidelity mutual funds, Fidelity offer discount brokerage services, retirement services, estate planning, wealth management, securities execution and clearance, life insurance and much, much more.
• Effectively managed DBA’s across the globe, supporting Oracle, DB2 and SQL Server database environments
• Delivered vital consistency through introduction and implementation of enterprise wide set of database standards.
• Prepared plans, negotiated timeline, proposed implementation plan and migrated OLTP, Data Warehouse and Operational Reporting databases from non - Exadata to EXADATA platform. Exadata migrations resulted in up to 40x improvements on some of the critical reports and have consistently met the SLA for our batch cycles.
• Led the team to virtualize all non-production environments using ZFS technology and saved good money for the organization, without impacting the QA community
• Led the DBA’s to upgrade Exadata servers from X4 to X5 series and worked with management for upgrade proposal and new appliance procurement
• Prepared for database expansion by studying plans and requirements; advising senior technical management; coordinating design and programming.
• Keep senior technical management informed by preparing reports on system performance and problems.
• Ensured adherence to key regulatory demands through design and deployment of SOX compliant database and business tools security structure - audited and resolved all issues within mandated time.
• Upgrade hardware and software by assessing transaction processing and database production options.
• Secure database by developing policies, procedures, and controls. Also managed the team to develop DATA MASKING process for non-production databases and improved the process runtime from 1 week to less than 16hours total.
• Update job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
• Accomplished information systems and organization mission by completing related results as needed.

Confidential, Smithfield, RI

Principal Oracle DBA

Responsibilities:

• Installation, configuration and upgrade of Oracle 9i/10g/11g/12c on Sun Solaris, AIX
• Implemented 2 node RAC cluster for one of our critical production databases and all of its corresponding non-production databases
• Developed a process to SUBSET production database into smaller database for QA and development purpose
• Setup Oracle Enterprise Manager Grid control for production and non-production databases and established standards for installing the agent software
• Requirement Analysis for the projects and capacity planning for the various client applications.
• Supporting Production Oracle 9i/10g databases.
• Responsible for Database Design including creations, modification, deletions of tablespaces and datafiles, creation of rollback segments and schema's.
• Performance tuning of Unix System for Oracle RDBMS like Kernel tuning, separating different tablespaces in different disks.
• Database performance tuning using Parameter file.
• Query optimization -- using Explain Plan, tkprof and third party software like TOAD/DbArtisan/Quest Performance analyzer.
• Database structuring strategies and procedures for optimum database performance.
• Export/ Import including data pump of preserved logical data.
• Created unix shell scripts for various requirements of the team
• Centralized scripting environment for database and server monitoring
• Used Quest Stealth collect to monitor and report various activities occurring in the database

Confidential, Groton, CT

Oracle DBA

Responsibilities:

• Confidential discover and develop innovative, value - added products that improve the quality of life of people around the world and help them enjoy longer, healthier, and more productive lives.
• The company has three business segments: health care, animal health and consumer health care. Confidential products are available in more than 150 countries.

Confidential, Dallas, TX

Lead Oracle DBA

Responsibilities:

• Facilitating customer access to shipping data while improving timeliness and accuracy of information is a primary goal of KWE.
• Providing customers with the tools to monitor shipments, notifying them of any changes or disruption of service in a timely manner, and making all tracking, EDI and report histories available are just a part of what KWE offers.

Confidential, Denver, CO

Oracle Database Administrator

Responsibilities:

• Janus is an investor relationship (Mutual Fund) company, mainly dealing with share holders/investors.
• They maintain different databases for different type of activities.
• Every night the data from external sources are loaded into the database through a tool called Autosys.
• This data is then replicated to their other site in Austin, TX using Oracle Advanced Replication (Multi Master Replication).
• Other databases also have their own significant roles. Janus had 33 production instances scattered across 11 servers.
• The team strength consisted of 4 and we were maintaining databases on On - Call rotation basis.

Confidential, San Francisco, CA

Oracle Database Administrator

Responsibilities:

• The information about the individuals, such as User names, allocated space, used space, billing info etc. is stored in the database. \
• The production instance runs in Archive log mode and backups are taken everyday using RMAN and hot backup.
• The database size was around 50gb and was expected to grow to terabytes within a year.

Confidential, San Jose, CA

Oracle Database administrator

Responsibilities:

• They develop multiple software packages to cater to the needs of the semiconductor industry.
• I was the only DBA there, taking care of development, QA and some client production (on call support) databases.
• The software was developed in Visual C++ and the data was retrieved from Oracle and MS Access databases. shipped Oracle software along with their software, in an image format.

Confidential

Oracle DBA

Responsibilities:

• I was a part of 5 - member team, where in each one of us had to handle several different development projects.
• I gave expert advice on writing SQL and PL/SQL scripts. I advised the programmers on how to develop modules as well as conducted training classes for them.

Confidential

Software Engineer/Oracle DBA

Responsibilities:

• The timings of the workers changed every week and the same has to be updated in the database to generate the required report.
• The system also kept track of the extra allowances paid to the workers.
• The system kept track of people paid to see if they were paid on a monthly or weekly basis.
• The program generated the reports to a file as when the day s transactions were closed.
• The company had a database of 8 GB with 96 MB RAM. I had a major role in tuning the client side programs and reports.
• They had 50 concurrent workers working on the system (for all departments). I was leading a team of 4 members.

Confidential

Software Engineer

Responsibilities:

• The company orders for goods that fall below the required order level and for the same an order form is used, to generate the output.
• The goods received are checked with the order form and the necessary updating is done. For the above process the system also generates Debit and Credit notes.
• The major modules involved in this unit are Order processing, Inventory, Sales and Warehouse.
• The system generates various reports, which include Purchase, Sales, Stock, Stock Transfer, Returns, expiry of goods.
• The system has three major users or roles for accessing the information.
• Auditing of table data modification was also enabled in this project.
• Testing was performed on the system before it was installed on the client. The team strength for this project was 3.

Confidential

Software Engineer

Responsibilities:

• This project was developed for Confidential .
• The modules include Material Management system, Enquiry, Allotment of stock to different various warehouse based on the head office statement and
• Production and preparation Analysis report periodically.
• Reports like item stock, Daily production, stock movements from inventory to production department and to various warehouse, maintains tax information.
• Purchase statements were generated from the system. I was part of a 3 - member team.

Confidential

Software Engineer

Responsibilities:

• This project uses bill of materials, automatic generation of material requisition slips whenever the material level falls below requisite order level.
• Referring to the bill of materials and multiplying the component quantity per unit times the planned production quantity determined the gross material need.
• This quantity was then compared with the expected availability of the component items on the date of need.
• When shortage of the material was detected the requisition was raised immediately. The team size for this project was 2.

Confidential

Software Engineer

Responsibilities:

• This project was developed for a supermarket named Nine to Nine Superstores.
• This project was titled Integrated Management system because it involved both inventory and accounting operation.
• The system had many levels of security by, which entry into the system was restricted.
• The system was developed as a multi user system where many counters will be opened simultaneously for the operation.
• The application was tuned to work with a maximum of 9 counters and a supervisor, which could act as a counter also.
• The major modules such as customer, supplier, and product were developed by myself and the accounting part was handled by the other team member.
• The system generates re order level report, daily sales report, daily stock report, overdue report, credit card transaction report, purchases report etc.
• The system generates these reports as and when required as well as at the end of the day. The team consisted of 5 members.