SUMMARY

• Highly accomplished information technology professional with over 19 years of experience inarchitecting, designing, testing and implementing projects and solutionsincorporating a wide range of technologies and applications.
• A naturalleaderwho thrives in environments requiring ahigh - level strategist and a big-picture thinker.
• Schedule-driven and budget-minded, able to prioritize multiple tasks, managing variousonshore and offshore teamswhile staying flexible to achieve project goals.
• A self-starter with proven values,a strong aptitude of ownership, dedication & expectations management along with communication skills.
• Proven track record of successfully working in both large organizations (with cross-functional teams) and start-up environments.
• Constantlyseeks challenges,driven with botha strong work ethic and the desire to exceed expectations.
• Extensive hands-on experience with performance tuning of large-scale e-commerce infrastructure.
• Managing senior technical team.
• Managed & delivered smooth business operations & upgrades in high volume Internet facing web applications at Confidential, Confidential Corp, Confidential .com, Confidential .com & Confidential .

CORE COMPETENCIES

• Team Leadership
• Software as a Service (SaaS)
• KPI’s tracking
• Project Management
• Change Control Management
• Release Management
• Incidence Management
• Trouble shooting (level III) issues .
• 24*7 Ops & SLA Mgmt.
• Quality Assurance
• Load Runner scripting & testing
• Shell Scripting
• Infrastructure System Management
• Data Center management
• Security management
• High Availability

PROFESSIONAL EXPERIENCE

Confidential. San Francisco, CA.6/

Director Databases Operations Reported to CTO

Responsible for database operations for ad serving from 3 data centers & data processing services up to 1 Billion ads on daily basis reaching more than 100M unique users across 110K publisher web sites.

Achievements

• Help achieve Master Data “system of record” & managed it as “single version of truth”. Implemented Data governance & master data management.
• Implemented integration with 3rd party data along with data ware housing and reporting model.
• Worked with Analytics team for implementation of Hadoop & java models for in flight data messaging & processing along with maintaining the quality of data.
• Implemented business requirements into technical solutions.
• Had 40+ successful project deployments (major architectural changes) over last 4 years.
• Introduced High availability & failover solution.
• Optimized database & removed unused indexes & optimized slow queries.
• Reduced the query processing time by 40% for features to bring page load times to half.
• Reduced the foot print of number of servers needs & with increased capacity we are able to do 40 % extra ad serving & increased the revenue by reduction of trashed clicks / over served ads.
• For expansion & ever increasing loads we are using Amazon web Services ( AWS / EC2 )
• Created production, standby, load testing, development & uat environment.
• Achieved PCI compliance certification.
• Successful Financial Audit with auditors
• Managed archival project which saved over 15 Tb of disk space & managed capacity management.
• Participated in on call rotation.

Environment: Status: 4 data centers & using Ec2 for spill over & capacity increase.

Application stack: LAMP, Java & C++ data foot print: 27+ TB MySQL 5, 5.1, 5.5

Confidential, Walnut Creek, CA

Sr. Oracle, Sql server, Mysql DBA

Managed onsite production dba team & outsourced dba team in India through (Patni). I was responsible for uptime of all production environments. The volume was 50-60 Million call transactions /day & 20 Million + SMS messages. The real time processing of balance checks before the calls makes the response time as critical.

Achievements

• Managed performance improvements for the cell phone activation, so that we could handle the black Friday to x-mas, holiday season cell phone activations without any Glitch.
• Successfully implemented the 3G env.
• Introduced Oracle advanced replication for HA (active- active mode).
• Introduced Split mirror based backup solution for 12 TB data warehouse on tier 3 hardware.
• Did numerous performance optimizations for different RDBMS & Siebel based CRM solution.

Environment: Status: High Customer Impact 24*7.

HA: RAC, VCS, Physical standby, Oracle Advanced replication.

Storage: EMC San

Db: Oracle 10g & 9i, MySQL, Sql server 2000, 2005

Database size: 1 TB OLTP to 12 TB DWH.

Confidential., San Francisco,CA

Sr. Oracle & Sql server DBA - Consultant. Employee of World Scape Inc.

Sr. Technical Consultant for a team of 18. Worked with onsite resources & outsourced resources (Wipro Ltd. ) The migration project involved stack upgrade of operating system, database, & application servers (Total 100 + production instances were upgraded to oracle 10g) along with testing up of DR, HA & BCP.

Achievements

• Went from Solaris to Linux based servers which resulted in saving of $30MM to Confidential .
• Services relocated in data centers
• Changes were implemented across various data centers with compromising business continuity.
• Implemented numerous performance improvements.
• Successfully executed disaster recovery test execution & QA checks for data center failovers scenarios.

Responsibilities:

• Upgrade the existing oracle 9i databases running on Solaris to oracle 10g databases on RHEL 4 in development, uat, standby, prod.
• Configure & test the VCS Environment for failover of db.
• Configure & test the RMAN backup solution.
• Performance tuning on the oracle10g databases post upgrade.
• Business Continuity Management testing for various scenarios.
• Export / Import & data pump for doing various Environment refreshes.
• DST patches application.
• Implementing partitioning for large db.

Versions: Oracle 8i, 9i, 10gR2 (10.2.0.2 64 bit),Sql server 2000

Max database size:7 TB DWH & 6 TB OLTP

Confidential, San Francisco CA

Sr. Oracle & Sql server DBA - employee

Sr. Oracle & Sql server DBA - contractor

Implemented numerous projects at Confidential Corp. improvised the website features, did QA & load testing such that it can perform under ever increasing peak loads. Migrated from old legacy environment to oracle - Retek based retail solution. Here we changed the system of record from legacy to RDBMS based system.

All change controls were 100% successfully implemented.

Despite hardware crash we did not have any data loss.

Worked on out sourcing with Marconi & later in-sourcing back to Confidential .

Versions: Oracle 8i, 9i, 10gR2 (10.2.0.2 64 bit),Sql server 6.5,7, 2000,2005

Achievements

The contribution was hands on as well as a lead / project in charge. Implemented following projects.

• Load runner scripting & testing.
• 7 Data center relocations & consolidation.
• Retek Merchandising System
• Retek Distribution Management
• Retek Data Warehouse management
• Implemented Oracle Financials v 11.5.4
• Upgrade, Redesign, load testing & QA
• Upgrade, Redesign, load testing & QA
• Upgrade, Redesign, load testing & QA
• Kewill shipping System
• Momentis Application.
• Audit works application from NSB / STS.
• Remedy for helpdesk
• SRC Software for Finance
• Perforce Source Safe
• Visual Source Safe
• Test Director
• Risk Control tracking System for Sarbanes Oxley.
• Egain Application for CSR Emails for website.
• Business Objects.
• Appworx.
• Micro strategy.
• Kronos Time & Attendance.
• Electronic Gym Bucks.

Responsibilities:

• Coordinate with various infrastructure teams for setting up the infrastructure; Db servers & San
• Install Oracle 8, 8i, 9i database and upgraded the databases.
• For IO performance reasons ODM Oracle Disk Manager was implemented using Veritas.
• Implemented partitioning.( range / list / hash)
• Create and maintain Disaster recovery instance using oracle Data Guard.
• Develop scripts to monitor the system and automate the processes.
• Tune the database for better performance
• Backup database (hot backup, cold backup, exports)
• Provide 24x7 support for the Oracle 8i/ 9i production environment.
• Refreshing the Development & QA environment.
• Code Migration & Change Control.

Environment: Sun V1280 with Hitachi Sun Storage 6320, 3 TB usable, Oracle 9i, Sun Solaris 2.8. Sql server 2000, 7 & 6.5