SUMMARY

• Oracle 10g Certified DBA
• 24 years of experience in information technology in various sectors and capacities
• Experience in leading DBA teams and in leading technology projects
• Experience in AIX, HP - UX, Solaris, RedHat Linux
• Experience in administering Oracle versions 11g, 10g, 9i, 8i, 7
• Experience and strong knowledge of data warehouse, PeopleSoft, SAP, Siebel, OLAP, OLTP systems
• Experience in Oracle RAC, VCS, Data Guard (Physical & Logical), BCV / time finder, RMAN
• Experience using Active Data Guard, Snapshot Standby, flashback, Advanced Replication, Oracle Streams, ASM, Resource Manager
• Experience in administering VLDB
• Strong in implementing security controls and standards, implementing SOX & PCI controls.
• Experience in using Oracle’s VPD, encryption package, TDE
• Strong in SQL Tuning, PL/SQL
• Experience in Derby DB
• Experience in using different change management tools like BMC Remedy.
• Excellent communication and interpersonal skills.
• Experience in mentoring team members, and working with developers.

PROFESSIONAL EXPERIENCE

Confidential - Tampa, FL

Senior Team Lead (Database Administration)

Responsibilities:

• Team lead for oracle DBAs who manage many multi TB (around 20TB) databases in various environments. My team members are in Sunnyvale, CA and Banglore, India.
• Responsible to work with these DBAs to implement changes. And ensure that the changes follow strict change management guide lines and documentation.
• Responsible to work with various teams who are involved in the product to get tasks done. This includes working with product team, system admin team, storage admin team, development and operations team to plan and execute upgrades, enhancements etc.
• Responsible for capacity planning every year to estimate the resources needed to run the systems smoothly.
• Responsible to create and provide different non-production databases and data refreshes as and when needed.
• I have responsibility of making sure that the systems are geo-redundant and highly available. All databases are either on VCS cluster, linux cluster or using oracle RAC. All the databases have data guard (standby) implemented between two geo-redundant cities.
• Making sure that recoverable backups are taken and readily available. Oracle RMAN and NetBackup are used for backup and restore. Also participate in yearly disaster recovery drills.
• I am involved in all development life cycle of the systems I am responsible for.
• Responsible for working with developers for the enforcement of standards/best practices, review the designs, tuning of code, give expert opinion on their designs and teach them new features which they can take advantage.
• We use ASM for all Oracle RAC databases. File system or raw files for non-clustered databases.
• We use Grid Control for monitoring and alerting.
• I am also involved in implementing data security solutions to conform to the audit controls and requirements.
• I regularly monitor the databases to find and resolve any bad queries running and causing problems.
• I write shell scripts and cron jobs to do additional monitoring, cleanup, partition maintenance and export jobs.
• I use most of the oracle features like Active Data Guard, snapshot standby, flashback in different situations.
• I work with Derby DB (not an expert) also.

Confidential - St Petersburg, FL

Senior DBA

Responsibilities:

• Primary DBA for the order taking system (Siebel 8.0) which uses a 4 TB OLTP database.
• Responsible for working with developers for the enforcement of standards/best practices, review the designs, tuning of code, give expert opinion on their designs and teach them new features which they can take advantage.
• Constant monitoring of the health of the system, monitor to see if there are any inefficient SQLs running
• Capacity planning, working with UNIX administrators, working with internal and external auditors for SOX & PCI complaints, check for new critical patch updates, backup and recovery, work with development team for scheduled patching and upgrades and taking part in disaster recovery drills
• Use Oracle’s VPD and encryption packages for sensitive data. We have about 150 Oracle databases to take care.
• Work with Oracle to resolve any bugs or problems by opening SRs
• SQL tuning, trouble shoot performance issues, data replication using Oracle Streams & materialized views.
• Refresh of non-production databases with production data and mangling of sensitive data before it is used in the non-production environment.
• Install & manage Grid Control, RAC, and Data Guard (physical & logical)
• Databases are used for applications like PeopleSoft financial & HR, Data Warehouse (7 TB), Siebel (4 TB OLTP), Retek and many other environments
• Using transient logical standby to upgrade the OLTP system to reduce the down time and using resource manager to control the parallel queries.

Confidential - Westbrook, ME

Principal DBA

Responsibilities:

• DBA team lead, excelled to provide stability, availability, security and performance for all databases in the enterprise. This included oracle and SQL server
• Provided capacity planning.
• Lead database related technology projects.
• Coordinated the install, patch and upgrade of Oracle and SQL Server
• Provided enterprise level Disaster Recovery, backup and restore plan.
• Involved very actively with other teams to study their problems and provide solutions.
• Worked with management to negotiate vendor deals.
• Worked with management for recruitment (screening and interview).
• Worked with system administrators and storage administrator to be proactive about capacity management
• Managed some successful technology projects which involved the study and recommendation of the improvements in the environment and new technologies.
• Database administration of about 100 oracle databases including Oracle 10g RAC. SAP R/3 database is 3 TB, data warehouse was 6 TB on ASM.
• Provided DBA support for Europe data centers and implemented data guard solution.
• Attending Change Control Board meetings every week.
• Support of Data Warehouse, Informatica ETL tool, Business Objects, many data marts
• Trained the administrators in Europe. Worked with the DBAs to make sure all projects and new initiatives are covered by allocating resources for each project. Worked as data architect for some projects.
• Developed best practices, standard operating procedures and security policies.
• Worked with developers for the enforcement of standards and tuning of code.
• Worked as data architect for some projects. Review the designs and correct if necessary.

Confidential - S. Portland, ME

Senior Database Administrator

Responsibilities:

• Install, upgrade and patch Oracle databases and related products.
• Create and maintain the replication environment (used Oracle Advanced replication).
• Participate in DR drills.
• Database support for DW, OLTP, Peoplesoft, Siebel and Lawson applications.
• Maintain optimal performance of all Oracle Databases by monitoring them.
• Expert Review/Oversight of Database/application changes and designs.
• Provide backup and recovery solutions. Wrote scripts for BCV, timefinder and TSM.
• Archiving of data which is out of date according to SLA to another database. Used partitioning and transportable tablespaces to archive the database to another database.
• Provide 24 x 7 on call support
• Provide DB2 System Administration support including DB2 connect
• Using monitoring and administration tools like OEM, DB Tuner, TOAD
• Make sure that backup is done using BCV timefinder and TSM.
• Trouble shooting ODBC, DB2 connect etc
• Administered Oracle 9i, 8i, 8.0.6 and 7.3.4 production databases. Some of the production databases were about 500GB is size. Data warehouse was about 500GB. About 80 databases in the enterprise. Managed and re-engineered existing systems, including a system, which gained 300% percent performance improvement.

Confidential

Systems Consultant

Responsibilities:

• Designing and writing new programs, debugging and enhancing old programs.
• Conducted Performance tuning on the applications. Tuned SQLs, Packages, procedures etc
• Re-engineered the primary data loading application on the reporting database. This gained 300% performance.
• Wrote a lot of new packages, procedures, functions, and triggers
• Used SQL Loader, SQR, PL/SQL and shell scripts to cleanse and load the data into oracle databases and generated reports.

Confidential

Team Lead/DBA

Responsibilities:

• Responsible for leading a team to analysis, design, development and implement various projects developed for various state and central government departments in India.
• Some of the departments are Central Excise, Central Provident fund, Directorate of Health Services, Directorate of Horticulture, Passport Office.
• This included DBA duties also: UNIX, Xenix, Oracle, FoxPro, dbase in various departments.
• System Administration and user consulting services
• Carried out system administration of mainframe computers.
• Conducted preventive maintenance of mainframes, including operating system maintenance.