PROFESSIONAL SUMMARY

• 9 years of Information Technology industry experience in leadership and non-leadership roles.
• Currently Working as UNIX Platform Engineer. Engineering Solutions involving AIX, powerVM, powerHA, Redhat, Solaris, VMware, Oracle RAC, Oracle ASM and VERITAS Cluster File System HA.
• Worked in Systems Engineer, Systems Architect, and Lead Database Engineer capacity.
• EOD cleared to work for Department of Homeland Security.
• Designed and Implemented systems using IBM Power Systems P6-570/P5-570, IBM PowerHA HACMP , AIX 6.1,
• PowerVM Virtualization, VIO, HMC, SAN, NetApp 3270 Storage , Hitachi Storage, VMWare vSphere Virtualization, HP Enclosures, HP Blades, NIM, Syncsort, and Redhat Enterprise Linux 5.
• Strong Experience working as DBA with DB2 UDB 9.5 ESE in OLTP and Data Warehouse environment.
• Extensive Performance Tuning Experience in MPP, SMP, and BCU environments on p5 based p595, and p575
• series systems with NetApp 3020/3270, Hitachi, IBM DS8300, 2105 ESS Sharks, DS4800, and EMC DMX 1000 storage systems.
• Strong knowledge of data warehousing and business intelligence concepts.
• Strong SQL writing, SQL Analysis, and SQL tuning skills.
• Strong Experience with Database Migrations. Lead DB2 7.1 to 8.1 migration and 8.2 to 9.5 migration.
• Strong Experience working with ETL and Reporting Tools such as Informatica and Business Objects.
• Programming experience with DB2 admin API.
• Experience working with Data Studio, PL-SQL, DB2 Connect, Erwin data modeling tool, Embarcadero's
• DBArtisan monitoring and tuning tool, Quest Central performance monitor for Databases, and IBM Optim Performance Manager for DB2.
• Extensively involved in analyzing and developing physical and logical database models.
• Strong Experience with Import, Export and Multipartition Load utilities.
• Strong experience in writing Perl/Shell scripts for backup, recovery, replication, migration, performance monitoring, and day to day operations across different operating systems such as Windows, AIX, SUN SOLARIS, Red Hat Linux.
• Programming knowledge of Java, JDBC, Perl, C, XML, VB.NET, C .

TECHNOLOGY EXPERTISE

• Operating Systems : AIX 5.3/6.1, Red Hat Enterprise Linux 5.x/6.x, Windows 2008.
• Virtualization : VMWare vSphere ESX 4.1/5.1, Redhat Virtualization, VMotion, IBM PowerVM, VIO
• Systems : IBM Power 7-740/795, 6-570,p5-570,HP Enclosure c7000, HP Blades BL460c/BL490, HP Server DL580/380, SUN T Series, IBM x Series.
• SAN : NetApp FAS3200 Series, EMC VNX, Hitachi 9500v, Brocade.
• Database : DB2 8.2/9.5 ESE, Oracle 11g RAC, SQL Server 2008, Informix, MySQL Database tools : Foglight 4.0, Spotlight 4.5.0, Erwin Data Modeler, BMC Patrol, IBM Optim
• Performance Manager 4.1, MS Visio 2003, Embarcadero's DBArtisan 8.0, Quest Central 4.5.
• Data Warehousing Tools : Informatica 8, Buisness Objects XIR2.
• Application Servers : WebSphere Application Studio 8.5, Apache, Apache JServ, Tomcat
• Development Tools: : Websphere Studio Application Developer, Eclipse Editor, JBuilder
• Programming Languages : Java, C, C , SQL, PHP, VB.NET, C , HTML.
• Web Technology : XML/XSL, XSLT, ASP.
• Other Technology : TCP/IP, iptables, BIND, Sendmail, DNS, DHCP, NFS, openSSH, Samba, UDP.
• Scripting : Perl, Shell, awk, JavaScript

EXPERIENCE

Confidential

Job Profile: UNIX Platform Engineer

Responsibilities:

• Designed standards-based Redhat, AIX, and Solaris systems to host standard and customer applications in a data-center environment.
• Worked with network engineer to design and deliver load balanced solutions using F5 Big-IP.
• Worked with Database Engineer to design and deliver Oracle RAC platform using InfiniBand protocol.
• Written and maintained Requirement documents, build documents, and Engineering design documents.
• Provide tier-3 support to operational support personnel regarding AIX, VIO, powerHA, powerVM, Redhat, Solaris, File Systems, LVM2, Multipathing, NFS, iSCSI, Veritas Storage Foundation, Static routes, Network Interface Card NIC configuration, port channeling, routing, and various other Operating System configuration issues
• Engineered custom RedHat OS installation images utilizing kickstart.
• Engineered concurrent shared storage solution for Solaris servers using Oracle OCFS which is part of Oracle ASM. This was required to support Oracle Enterprise manager in Active Passive mode
• Engineered concurrent shared storage solution for RedHat Linux servers using Symantec's Veritas Storage
• Veritas Filesystem VxFS sub-components
• Foundation for Cluster Filesystem HA SFCFSHA , which also utilizes the Veritas Volume Manager VxVM and
• Collaborated with other engineering teams such as Storage Area Network, Backup and Recovery, and Security
• on certain designs.
• Developed Linux Virtual Machine images to be used in a VMWare ESX cloud environment.
• Developed engineering documentation for designs and peer reviewed engineering documentation from other Engineers on the team.

Environment: Redhat 5.9/6.2, Solaris 10, AIX 6.1, IBM Power 7-740/7-795/5-570, PowerVM, VIO, PowerHA HACMP , NIM, HMC, NetApp 3200, EMC VNX, Brocade, HP Enclosure, VMWare VSphere ESX 4.1/5.1, Oracle 11g RAC.

Confidential

Job Profile: Systems Engineer / Architect / DB2 Engineer

Responsibilities:

• Successfully delivered IBM PowerVM Virtualized Systems for DB2 migration project. Following are key achievements.
• Researched multiple technologies from many hardware and software vendors to design robust infrastructure for hosting DB2 databases belonging to all DOL agencies.
• Designed robust infrastructure using IBM Power 6-570 Systems after evaluating requirements from DOL agencies.
• Implemented hardware solution as per design and delivered by project deadlines.
• Documented project manuals, baselines, and architecture diagrams. Delivered to customer by project deadlines.
• Newer system's throughput exceeds customer's expectations.
• Isolated every agency in separate environments which avoids interference. Earlier environment was common server for all agencies and some agencies were getting below average performance because of resource used by other agencies
• Earlier storage was using ISCSI as communication medium which delivered slower I/O throughput. Newer storage is communicating using fiber channel medium and provides higher I/O in magnitude of hundreds when compared with earlier ISCSI storage. Newer storage is also fault tolerant.
• Earlier systems were not fault tolerant. Newer systems have multiple level of fault tolerant at component and server level. Newer systems can failover at site and across site. HACMP technology is used at site to provide fault tolerant and HADR technology is used to provide fault tolerant across site
• Trained production support staff in newer technologies used in newer infrastructure in order to help them maintain this infrastructure in the future
• Newer infrastructure uses virtualization technology which saves power and space in the data center.
• Newer infrastructure is highly scalable. PowerVM technology allows server resources to scale far beyond allocated limits without intervention from system administrators. Older systems had hard set limits on resources which needed downtime and intervention from system administrators to scale.
• Newer System has better management and monitoring tools which makes it easier to manage and monitor system as compared to older systems
• Successfully migrated DB2 databases for all agencies of DOL from 8.2 to 9.5. Coordinated with application teams from all agencies to successfully test and migrate databases in production.
• Installed and configured IBM Optim Performance Manager in order to monitor all DB2 databases.
• Successfully delivered VMWare virtualized environment for IBM WebSphere Application Server migration project. Following are key achievements.
• Designed newer infrastructure using HP Enclosure, HP Blades, VMWare vSphere ESX for virtualization, and NetApp 3170 storage for hosting all instances of applications of DOL on IBM WebSphere Application Server.
• Implemented hardware solution as per design and delivered by project deadlines.
• Documented project manuals, baselines, and architecture diagrams. Delivered to customer by project deadlines.
• Newer system's throughput exceeds customer's expectations.
• Earlier systems were standalone dell servers and were not fault tolerant. Newer systems have multiple level of fault tolerant at component and server level. Newer systems can failover at site and across site. VMotion technology is used at site to provide fault tolerant.
• Trained production support staff in newer technologies used in newer infrastructure in order to help them maintain this infrastructure in the future
• Newer infrastructure uses virtualization technology which saves power and space in the data center.
• Newer infrastructure is highly scalable. VSphere technology allows server resources to be scaled dynamically.
• Newer System has better management and monitoring tools which makes it easier to manage and monitor system as compared to older systems

Environment: AIX 6.1, IBM Power 6-570/5-570, PowerVM, VIO, PowerHA HACMP , NIM, HMC, NetApp 3020/3270, Brocade, Hitachi 9500v, HP Enclosure, VMWare VSphere ESX 3.5, VMotion, DB2 9.5, HADR, IBM

Confidential

Job Profile: Lead DB2 UDB DBA

Responsibilities:

• Kept CCTI and CCP databases up and running with the objective of best performance delivered to applications.
• Successfully analyzed performance issues and delivered best solutions in solving performance issues during various releases
• Helped Application developers to write SQL, analyze existing SQL to rewrite, and tune SQL for any improvements.
• Analyzed and recommended infrastructure design changes to accommodate new software such as Cognos.
• Developed various scripts and recommended various off the shelf products for better availability, and better performance of CCTI databases.
• Mentored developers to write better SQL, suggesting new functions and features available in databases to improve performance and help make code shorter.

Environment: DB2 ESE V9.1 in BCU environment, p575, DS4800, AIX 5.3, DBArtisan 8.6, IBM

Confidential

Job Profile: Lead DB2 UDB DBA

Responsibilities:

• Worked as a lead DBA for revenue generating and highly critical marriott.com database with 99 uptime.
• Standardized database maintenance activities by standardizing directory structure, documentation of DBA activities. System performance enhanced by 80 after redesign of database directory layout.
• Maintained physical data model.
• Revisited database security and cleaned unwanted permissions. Defined new security standards.
• Developed scripts for automated audit reports in order to compare critical databases.
• Enhanced performance of poor running applications
• Lead database support for vignette 7311 content management upgrade.
• Developed scripts for reoccurring DBA activities in order to make DBA work more efficient
• Developed database scripts for issues such as lock waits, instance down, automated REORG, and RUNSTATS.

Environment: DB2 ESE V8.2 FP 15 ,AIX 5.3, p595, DS4800, Oracle 10g, Erwin, DBArtisan,

Confidential

Job Profile: DB2 DBA/Data Modeler/ Developer

Responsibilities:

• Responsible for design, development and maintenance of IFECS database.
• Involved in maintaining existing Conceptual, Logical and Physical Data Model using ERWIN.
• Partitioned few history tables using UNION ALL partitioning.
• Written Complex SQL and Shell Scripts for various data cleaning tasks.
• Supporting Business Objects Developers and Middle Tier developers for SQL optimization.
• Developed Stored Procedures, Triggers, MQT, Perl/Shell Scripts.
• Maintained documentation of procedures and standards.
• Worked on design for MDR Metadata repository .
• Reviewed the existing physical data base design, the data load procedures and the reports. Suggested new table layouts using normalization, denormalization, MQTs, and MDCs.
• Reviewed database manager as well as database parameters and configurations. Reviewing Memory allocation for all heaps and made recommendations to optimize the performance of the system.
• Developed database code for all application releases.
• Developed various shell script tools useful for day-to-day database administration work.
• Maintained the Security and Access for User Identification.

Environment: AIX 5.3, Java, DB2 Information Integrator, DB2 UDB 8.2 FP12 ESE, ERWIN 4.1.2

Rational tools, Business Objects 6.5, IBM WebSphere Application Server, Citrix,

Confidential

Job Profile: DB2 UDB DBA

Responsibilities:

• Supported migration from Informix XPS 8.4 and Informix IDS 9.4 to UDB DB2 ESE 8.2.
• Configured Informix to UDB and UDB to UDB Federation using Information Integrator.
• Developed data refresh jobs which uses LOAD with UNIX Pipe. It also take advantage of DB2 parallelism.
• Provided support for designing MDC tables as well as MQT tables.
• Configured and maintained Query patroller and DB2 Governor. Developed scripts to get reports from QP tables.
• Reviewed the existing physical data base design, the data load procedures and the data warehouse reports. Made new storage layout recommendation for all tablespaces.
• Monitored all production ETL AB Initio as well as reporting Microstrategy jobs 24X7.
• Reviewed database manager as well as database parameters and configurations. Reviewed Memory allocation for all heaps and made recommendations to optimize the performance of the system.
• Supported application developers for SQL optimization.
• Provided 24 X 7 Support for all the Customer Support Issues.
• Configured the system for LOCKWAIT, TABLESPACE USAGE report.
• Wrote various shell script tools useful for day-to-day database administration work.
• Maintained the Security and Access for User Identification.

Environment: AIX 5.3, Java, DB2 Information Integrator, DB2 UDB 8.2 FP10 EEE/ESE,