Resume

Resume Details
S. H.
Location	San Ramon, CA
Contact	Click to View Contact
Source	Direct Candidate
Salary	N.A.
Rate	N.A.
Resume

Summary:

Over 20  years of experience in databases as an Architect, DBA Lead and Developer in Oracle-big data-no SQL and related technologies, including Oracle 11g (R1 and R2), Oracle 10g, Oracle 9i,  8i  and 7.x databases (handled databases as big as 20 Tera Bytes), primarily as a back-end engineer performing database architecting, High Availability, Disaster Recovery, administration and performance tuning, maintenance and migration of Oracle databases, analysis, design of logical and physical databases (using Designer, Erwin and Rational Rose) for enterprise OLTP as well as DSS applications, development of oracle procedures, packages, functions and  triggers using pl-sql and sql, development of forms and reports,  using Oracle Application Server (OAS).  Excellent hands on experience on Installing, upgrading, trouble shooting and supporting 24x7 Production Database systems with 99.99% availability.

Skills:

HardwareUCS, Sun Fire 15000, Sun E4500, HP 9000, Origin 200  02 (SGI), Digital Alpha 300, Cisco UCS
Operating SystemsCent OS, Solaris 10-9-8-7, Red Hat Enterprise Linux, Linux AS, HP-UX, IRIX, Windows XP- 2000-NT
RDBMSOracle 11g, 10g, 9i, 8i, 8.x,7.x MySql, Access-97, WATCOM SQL
ERPRetail Merchandising System (RMS) 11-10, Retail Data Warehouse (RDW), Retail Demand Forecasting (RDF), Retail Distribution Management (RDM), Retail Integration Bus (RIB), Retail Extract, Transform and Load (RETL), Retail Allocation, Retail Warehouse Management System, JDA-Arthur Planning, People Soft, STS Sales Audit
Case ToolsDesigner, ERWIN, ER Studio, Rational Rose, Visio and S-Designer
Scripting LanguagesSQL, SQL*Plus, PL-SQL (9i, 8, 2.x), Korn and C Shell Scripts, Power Script, VB script
Software-PackagesOracle Enterprise Manager (OEM) Grid Control, DBA Studio, DB Artisan, Oracle Performance pack, Veritas Clustering Software, TOAD, DBVisualizer, SQL Xpert, Developer-2000-6i(Oracle Forms  Reports), Power Builder, Visual Basic, Oracle Internet Directory,  Oracle 9iAS, Explain plan, tkprof, statspack, golden gate, Veritas-Symantic I3 tool(Precise), Test Director, CA File Transfer, CA Work Bench, CA Help Desk
Backup SoftwareNet backup and Tivoli
Version ControlSource Safe, CVS, Clear Case
EDIMercator
SAN-StorageHitachi (HDS) 9990, 9980, 9950, NetApp, EMC
Other TechnologiesTrue copy, Flash Snap, Shadow Image


Professional Skills: 

Installing and configuring large (VLDB as big as 10 TB on SAN) databases
Oracle 11g (R1 and R2), 10g, 9i, 8i and 7.x databases in a Unix-Linux-Solaris as well as windows environments 
Oracle database migrations from 9i to 10g, 10g to 11g and Oracle upgrades, Critical Patch Updates (CPU)
Cross platform porting of databases
Maintain and support mission critical High Availability (99.99% available)      24x7x365 production databases
Planning and implementing the backup, recovery and  disaster recovery (DR) strategies and automate them
Monitoring and tuning of databases for performance and availability 
Used extensively the RMAN, log miner, partitioning, data encryption, transportable tablespaces, data pump, export and import, sql*loader, sql*plus, sql, plsql
Plan, design, deploy and support database security (roles, virtual private databases-Fine Grain Access Control)
Expertise in Configuring and maintaining the Oracle Data Guard
Structured system analysis and design of databases
Expertise in Software Development Life Cycle (SDLC) and design methodologies and project management techniques 
Involved in creating and supporting the Development, Test, QA-Integration, Staging-Performance test and Production environments
Provide technical support to the engineering department in application development-tuning  
Develop and maintain PL-SQL stored procedures, packages, functions and triggers. 
Optimized complex SQL statements using explain plan and tkprof facilities and used Rule based and Cost based optimizers extensively
Monitor data and index growth and perform capacity planning-forecasting; estimate database space requirements. Monitor logs 
Provide turnover documentation for all projects involved and will take part in establishing Service Level Agreements (SLA) Operational Level Agreements (OLA) 
Knowledge in SAN, Veritas Volume Manager, connection pooling, OO methodologies, use cases and UML










Work Experience:
Mar, 2010 - Current: Cisco Systems
Role: Lead DBA-Architect
Designation: Technical Leader

Responsibilities: 

Mentoring and Supporting the total Engineering team on all aspects of the oracle and mongo databases as a SME (Subject Matter Expert)
Architecting and Supporting all Operational aspects of the (internal as well as customer) Development-Staging-Integration-Performance-Production databases 
Guiding and supporting the AS (Advanced Services) engineers
Architected the High Availability (HA) using Oracle RAC and Disaster Recovery using Oracle Data Guard for the on-premise and Cloud (QaaS) offerings
Architected, Lead, carried out the database performance tuning efforts and eventual certification of the QUAD product for 5K, 10K, 100K and 500K users
Designing the data model for the Enterprise Collaboration Platform (Quad-ECP), Designing the multi-tenant SaaS-QaaS application databases-infrastructure, Installing, configuring, maintaining and supporting the Oracle 11gR2 and 10gR2 databases, Performance Tuning of Databases and SQL query optimization, Setting up Oracle Data Guard for Disaster Recovery (DR), Oracle RAC for High Availability, DB backups and recovery using RMAN, OEM grid control 
Lead hardware and software evaluations, planning and leading the execution of the scalability of DB infrastructure. Managing and coordinating the Onsite (CA, USA) and Offshore (India) teams,  Agile-SCRUM methodology
Architected the multi-tenancy of the oracle DB on the cloud and on-prem
Taking care of all the aspects of oracle DB and the noSQL mongo DB incluging (but not limited to) replication, high-availability, partitioning-sharding, backup-recovery strategies, security, production on-call, 24X7 support etc 


Platform: Oracle 10gR2-11gR2 on RHEL-CentOS, Oracle Enterprise Manager  (OEM) Grid 
Control, MongoDB, LifeRay, RDF, SOLR,  MemCache, Active MQ

Dec, 2008 - Feb, 2010: ADX-Liaison
Role: Lead DBA-Architect-Project Manager

Responsibilities: 

Installing, configuring, maintaining and supporting the Oracle 11g, 10g-9i databases, Designed-modified the corporate data model, Carried out the design reviews and code reviews, Supported the Java and web 2.0 applications, Tuned the sql, pl-sql and databases, Setting up Oracle Data Guard-Standby databases and RMAN backups. Carried out the database design-Architecture for the Saas OLTP system, developed, tested and rolled out the changes into production and subsequent supporting of the same, performance tuning of the database as well as the queries,  Worked with engineering team to over see the database-application designs, Leaded the database design review efforts-meetings, reviewed and recommended the emerging database technologies, guiding the database team members. Supported the Oracle B2B, BPEL and BAM products. 

Platform: Oracle 10g-11g, RAC, ASM, Oracle 9i (9.2.0.8) on RHL, Oracle Enterprise 
Manager  (OEM) Grid Control, SQL, PL-SQL,





Apr, 2008 - Dec, 2008: Rearden Commerce
Role: Senior DBA-Architect

Responsibilities: 

Installing, configuring, maintaining and supporting the Oracle 10g-9i databases, Oracle migration-upgrade from 9i to 10g,  Oracle Cross Platform porting, Designed-modified the corporate data model, Carried out the design reviews and code reviews, Supported the Java and web 2.0 applications, Tuned the sql, pl-sql and databases, Setting up Oracle Data Guard-Standby databases and RMAN backups. Carried out the database design-Architecture for the Saas OLTP system, developed, tested and rolled out the changes into production and subsequent supporting of the same, performance tuning of the database as well as the queries,  Worked with engineering and architectural teams to over see the database-application designs, Leaded the database design review efforts-meetings, reviewed and recommended the emerging database technologies, guiding the database team members 

Platform: Oracle 10g, Oracle 9i (9.2.0.8) on RHL running on EMC storage, Oracle Enterprise 
Manager  Grid Control, SQL, PL-SQL

Nov, 2002 - Apr, 2008: Ross Stores, Inc.
Role: Lead DBA-Architect- Project Manager

Responsibilities: 

Installing, configuring, maintaining and supporting the Oracle 10g-9i databases, Oracle 9iAS, LDAP and Oracle Internet Directory (OID), 
Installing, configuring, maintaining and supporting the Development, Test, QA-Integration, UAT, Preview, Staging-Performance Testing, Training, Production database environments (SDLC environments)  
Installing, configuring, maintaining and supporting the Oracle Retail Applications such as Retek Demand Forecasting (RDF), Retek Merchandising System (RMS 10.1 and patch 10.1.1 to 10.1.5), Retek Data Warehouse (RDW 10.2), Data Warehouse Interface (DWI 10.2), RDW Web 2.3.1, Retek Integration Bus (RIB 10.1), RETL (Retek ETL) 10.2, People Soft (HR and Finance), Sales Audit etc
Installed and configured the Business Intelligence reporting, MicroStrategy (7.1.6 and 7.2.1) Microstrategy desktop, intelligent agent, web, SDK etc. 
Installed the Oracle Warehouse Builder (OWB)
Retek interface customizations, tuning the SQL, pl-sql and databases. 
Designed and-or validated the database designs
Defined the database standards-best practices and educated the developers in coding for best performance and scalability
Defined the DB security standards in conjunction with VeriSign vendor
Worked in compliance with the SOX  audit requirements
Encrypted the sensitive data within the database such as credit card info, social security numbers etc
Project Management during the SDLC environment builds and during GO LIVE
Documenting Standard Operational Procedures (SOP)
On-call support to production systems as well as developers 
Database guidance-support to Network Operation Center (NOC) and Help desk
Provide turnover documentation for all projects involved and took part in establishing the Service Level Agreements (SLA) and Operational Level Agreements (OLA) 


Platform: Oracle 10g, Oracle 9i (9.2.0.8) on Sun Solaris UNIX 5.9-5.8 running on Sun 15000, 
Oracle Enterprise Manager, DBA Studio,  Oracle Performance pack, SQL, PL-SQL, Retek  (RMS, 
RDW, DWI, RETL, RIB, RDF), Oracle 9iAS,  LDAP, OID, MicroStrategy 7.x, Hitachi SAN


Nov, 2000 - Oct, 2002 : BeVocal Inc, Mountain View, CA
Role: Lead Database Administrator

Responsibilities: 

Installing, configuring, maintaining and supporting the 24X7 voice portal database with a 99.99% uptime.  Oracle database migrations-upgrades from 7.x to 8i and from 8i to 9i. Designed the DB for the enterprise OLTP voice portal application, planned and implemented the backup and recovery strategies, Configured the Oracle Standby database in managed recovery and read-only modes, used the Transportable tablespaces for the DB objects copying among different databases. Implemented the Oracle advanced Multi Master replication for DB objects which have  regular as well as complex data types (such as LOBS) in which two master sites were present. Written scripts for resolving the various types of conflicts in the advanced replication. Also used the snapshot replication, Oracle Forms and reports. Tuned the SQL and PL-SQL statements.

Platform: Oracle 9i and 8i on Sun Solaris UNIX 2.8, Windows-NT 4.x and Red hat 
Linux 7.2, Veritas Cluster (VCS), Designer-2000, Oracle 9iAS, Oracle Enterprise manager, 
DBA Studio,  Oracle Performance pack, SQL, PL-SQL


Aug, 1999 - Nov, 2000: QIVA Inc, San Francisco, CA
Role:  Lead DBA 

May,  1999 - Aug, 1999 : Client is Amgen and iVision is the employer, USA
Role: DBA-Developer

Sep 1998 - May, 1999 : CTS (Cognizant Technology Solutions), Calcutta, India 
Role: Tech lead, DBA

Jun, 1997 - Aug, 1998 : ABP Ltd. Calcutta, India.
Role: Tech Lead

Jun, 1996 -  May, 1997  Gloster Infomatics, Calcutta, lndia.
Role:Tech Lead

Feb, 1995 - May, 1996 : For TELCO, Jamshedpur, India.
Role: Team Member

.



Awards and Recognitions

¢I.R.S. reward at Telco for technical contribution.
¢Greaves Foseco Endowment Award for M.Tech. Thesis at IIT, Kharagpur.
¢National Merit Scholarship from grade 10 to the end of Engineering.
¢A.P. State Merit Scholarship from grade 10 to the end of Engineering.
¢Recognized Player of the Week twice at BeVocal, Inc.


Education:
MS, Indian Institute of Technology (IIT), India.
<< Back
Resume

Similar Candidates
