SUMMARY:

• More than fifteen years of experience in total solution management, database architect, data modeling and DBA activities.
• Specialized in Disaster Recovery Plan.
• Specialized in disparate industry verticals.
• Specialized in Shared Service e.g. Oracle RAC, clustered SQL Server.
• Specialized in front office, mid office back office applications for trading.
• Specialized in database design, installation, migration, performance and tuning.
• Specialized in setting up the standards and governance.
• Specialized in SOA architecture.
• Unique skill set that includes development, enhancement, implementation, advanced DBA activities, programming and people skills.
• Good knowledge and understanding of both web and client - server applications.
• Excellent team player with experience working in small and large teams.

TECHNICAL SKILLS

Database: Oracle - 11g, 10g, 9iRAC, 9.x, 8.x, 7.x, Microsoft SQL Server - 2008 R2, DB2, Sybase - 12.x

Database Skills: Table Partitioning, Index Partitioning, Performance Tuning.

Operating System: Sun Solaris, Digital UNIX, Hp UNIX, SCO-UNIX, Aix (IBM), Linux

Messaging Services: Solace router, TIBCO EMS

Middleware: TIBCO BW, Microsoft Integration Server.

Languages: PL/SQL, SQL, T-SQL, Pro-C

Scripting/Content: Shell script (UNIX), MS-DOS batch, XML

Case Tool: Enterprise Architecture, Designer 2000, 6i, Discoverer

GUI/Tools/ETL: Oracle Data guard (ASM, AWR, ASMM), Oracle Enterprise Manager, DBArtisan, Toad, SQL-Loader, Netbackup (Veritas), SSIS, Informatica.

Clustering: Oracle RAC, Microsoft, Veritas.

Web Application Technologies (Exposure): Oracle Applications Server, Apache Tomcat, ASP, .Net, J2EE, Web Logic, and Web Sphere.

Technologies: Vmware, Log Shipping, Grid Computing.

Storage: EMC, SUN

Source code control tool: Clear case

Process-Tools: Remedy, Revx, Six Sigma, SOX, ITIL Process and CVP

PROFESSIONAL EXPERIENCE

Confidential

Lead Architect Database and Data Warehouse

Environment: Oracle RAC 11g, Data guard, IBM (AIX), TIBCO, J2EE, .Net, SQL Server 2008 R2,TIBCO,Solace Router, NETAPP Storage, Temenos-T24Job

Responsibility:

• LED database and SOA architecture.
• Define database standards, data governance and database security standards.
• Define Information architecture.
• Define Data Warehouse standards
• Define database performance tuning, Optimization guide lines.
• Implementation of Oracle Data Warehouse (ETL Data guard, Table Partitioning & Index Partitioning)

Confidential

Lead database development

Environment: Oracle RAC 11g, IBM (AIX), TIBCO, J2EE

Job Responsibility:

• LED the database implementation of Credit Initiation System for Citibank to process new applications for secured/unsecured lending products. (APAC,EMEA)
• Define data modeling, database design for the Credit Initiation System.
• Lead end to end database development and data conversion.
• Database performance tuning, Optimization.

Confidential

Data/ Solution architecture

Environment: SQL Server, Microstrategy, Windows 2003 Server, Linux and EMC SAN.

Job Responsibility:

• Redefined data architecture and data modeling for Business Intelligent Data Warehouse.
• Analyzed and fine turned ETL process.
• Database performance tuning. Optimized the report run time from 3 hours to 5 min with effective data architecture changes.

Confidential

Solution architecture / Senior DBA

Environment: Oracle, SQL Server, Java, Business Object, Informatica, Windows 2003 Server, Sun Solaris, Web Logic, TIBCO, Veritas Clustering, Netbackup, SAN, Log shipping, Oracle Data Guard.

Job Responsibility:

• Defined, developed and managed shared services e.g. ORACLE RAC, SQL shared database (clustered).
• Designed data architecture and data modeling for power trading platform price data warehouse.
• Provided day-to-day DBA support to trading business (front office, mid office, back office applications), risk management.
• Supported application enhancement that included data modeling and change management.
• Performed DBA activities and conducted query optimization.
• Enforced DBA best practices to installation, server setup, backup and recovery, application tuning and performance tuning.
• Defined implementation process, disaster recovery process, and maintenance process.
• Managed disaster recovery drills two times in a year.
• Incident Management.
• Documentation: updated remedy Knowledgebase, support documents, change request implementation documents.

Confidential

BI Solution architecture / Senior DBA

Environment: Oracle, DB2, Java, Windows 2000 Server, IBM AIX, Web Logic, Web Sphere, Tuxido, Perl, Cobol

Job Responsibility:

• Provided solution architect and data architecture to implement enterprise solution in client environments.
• Provided data modeling to BI solution as per client requirements.
• Enforced DBA best practices to installation, server setup, backup and recovery, application tuning and performance tuning.
• Worked on data analysis, data processing and enrichment of data.
• Conducted pre-sales and post-sales for enterprise solutions.

Confidential

Technology Manager/ Solution architecture

Environment: Oracle, SQL Server, Microsoft, Java, Windows 2000 Server, Sun Solaris, Linux, DB2, Sybase

Job Responsibility:

• Provided technical solution architecture and data architecture to clients.
• Provide project cost and time estimate
• Responding RFP’s and take part in pre-sale and post-sale initiatives.
• Designed and implemented an automated data feed process to integrate Hewlett Packard Customer Knowledge Mart.
• Worked on data analysis, data processing and enrichment of data.
• Maintained customer knowledge-base data mart and provided data consultancy to clients.
• Worked on several customer acquisitions and retention initiatives across clients. Some of the versions involved redemption platforms.
• Enforced DBA best practices to installation, server setup, backup and recovery, application tuning and performance tuning.
• Provided maintenance and tuning to production databases.

Confidential

Oracle DBA

Environment: Oracle 8i, Oracle 9iAS, Designer 6i, Developer 6i, J-initiator, Form server, Report server, Windows, Linux

Job Responsibility:

• Technical adviser to all clients.
• Performed DBA activities such as installation, server setup, backup and recovery, strategy identification, application and performance tuning.
• Coordinate with clients for new requirements.
• System design and architecture.
• Implementation and user testing.
• Managing and implementing work change requests of deployed systems based on new business requirements.
• Composed maintenance strategies to improve the efficiency and effectiveness of the systems.
• Project monitoring and scheduling
• Managed a team of front-end and back-end specialists.