PROFESSIONAL SUMMARY:

• 13+ years of Information Technology industry experience in leadership and non - leadership roles.
• Currently working as Solutions Architect for Affordable Care Act Verification System at IRS.
• Worked with Confidential as Systems Engineer. Designed and prepared RHEL based systems to support healthcare fraud detection and privacy event monitoring applications. Designed and prepared Cloudera based big data system. Designed hybrid database solution using Greenplum and Hadoop.
• Worked with DHS as Platform Engineer. Designed cloud solutions to migrate applications from individual datacenters of DHS agencies to consolidated datacenter supporting 150+ users. Datacenter is FISMA complaint.
• Solutions involved technologies such as AIX, Windows, powerVM, powerHA, Redhat, Solaris, VMware, Oracle RAC, Oracle ASM, WebSphere and VERITAS Cluster File System HA.
• Worked in Systems Engineer, Systems Administrator, and Lead Database Engineer capacity.
• Designed and Implemented systems using Redhat Enterprise Linux 5/6, 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, and Syncsort.
• 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 Experience with Jboss EAP6, JDG 6, and FUSE 6.
• Strong experience working with AWS, EC2, S3, VPC, Cloud Formation, Security Groups, and Network ACLS.
• Experience working on Puppet, CHEF, GIT, SVN, Jenkins, Docker, AWS, Ansible, and Maven.
• Strong Experience working with ETL and Reporting Tools such as Informatica, COGNOS, and Business Objects.
• Extensively involved in analyzing and developing physical and logical database models.
• 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, python, shell scripting, Perl, C, and XML,

TECHNICAL SKILLS:

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. Cloud Infrastructure: AWS, EC2, S3, VPC, Cloud Formation, Security Groups, and Network ACLS

DevOps (CI/DC): Puppet, CHEF, TerraForm, Salt, Jenkins, and Ansible

Bigdata: Cloudera, Spark, Hive, Hbase, and zookepper

SAN: NetApp FAS3200 Series, EMC VNX, Hitachi 9500v, Brocade.

Database: DB2 8.2/9.5 ESE, Oracle 11g RAC, SQL Server 2008, Informix, MySQL

MiddleTier: Apache Tomcat 6.0, Jboss Datagrid, JBOSS EAP 6.4, Jboss FUSE 6, Jboss AMQ

Development Tools: Websphere Studio Application Developer, Eclipse Editor, JBuilder, GIT, SVN, Maven

Programming Languages: Java, C, C++, SQL, PHP, HTML.

Application Frameworks: XML, J2EE, REST, JSON, XSLT, UML, SOA

Other Technology: TCP/IP, iptables, BIND, Sendmail, DNS, DHCP, NFS, openSSH, Samba, UDP.

Scripting: Perl, Shell, awk, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential

Solutions Architect

Responsibilities:

• Designed and developed several prototypes using open source technologies (primarily Redhat JBOSS) for AVS system in RHEL environments and presented to internal stake holders.
• Working on designing configuration and automation infrastructure using Ansible Tower and Jenkins
• Prototyped Redhat Gluster storage cluster and Ceph storage cluster to compare the metrics with native NFS storage in an effort to replace NFS storage.
• Prototyped systems with Redhat Jboss EAP6, Jboss datagrid, Jboss A-MQ, and Jboss FUSE products to benchmark the performance against existing systems running on IBM websphere and Webmethods like products. It is an ongoing effort to present cost savings of using open source products. Replaced IBM Websphere and Webmethods like products with Redhat Jboss EAP6, Jboss datagrid, Jboss A-MQ, and Jboss FUSE across IRS Enterprise.
• Prototyped scalable distributed data solutions using Hadoop, MapReduce, and Spark.
• Configure and deploy several hypervisors and VMs running OpenStack for DevOps, testing and production environments
• Created and maintained baseline RPMs for Jboss EAP6, Jboss datagrid, Jboss A-MQ, and Jboss FUSE products. Created and maintained the roadmap of these products. Tested new releases of Redhat Jboss EAP6, JDG, and FUSE for new product features, and enhancements before rolling out to production systems and after discussion with application teams.
• Administered Jboss EAP6, JDG, and FUSE. Configured SSL certs, vault for passwords, hornetq, and clustering. Troubleshot application issues deployed on Jboss EAP6. Configured multi instance Jboss EAP6 installations.
• Configured LDAP and role based authentication for administration of Jboss EAP6.
• Configured git based repository for version control of Jboss EAP6 application scripts.
• Successfully migrated all critical and noncritical applications to Jboss EAP 6.4. Following the urgency of security at all levels in IRS, lots of new security features are introduced and used in EAP 6.4.
• Streamlined the installation and maintenance process for Jboss EAP. Earlier Jboss EAP packages were individual scripts and configuration files which were run by individuals by following installation guides. Currently, automated software packages are created which can be run by individuals without the need to follow any installation guides. These packages can also be kept at repository servers and pushed to target servers for installation without the need to have someone install them manually. They are also easy to maintain.
• Created software programs to automate many earlier repeated tasks which were done manually. Scripted all post Jboss EAP installation tasks and added them to Jboss EAP installation package. This eliminated the need to run post installation tasks.

Environment: RHEL 6.4, JBOSS EAP 6.4, JDG 6.2, FUSE 6.2, Gluster Storage, Ceph Storage, Ansible

Confidential, VA

Systems Engineer

Responsibilities:

• Designed, Installed, and configured Redhat linux 6.3 systems in cloud environment to host Fraud and Privacy monitoring applications. These Systems ran Tomcat, Versant Database, and application.
• Configured RHEL 6.3 system to run OpenEMR application. Configured mysql, PostgreSQL, Apache httpd with PHP/JSP and Tomcat.
• Written python scripts and java code for data manipulation, cleaning, filtering, and aggregation.
• Installed Vertica database to use statistical models on medical claims data to run queries on raw data and find patterns in the data as well as to see the integrity of data.
• Designed, installed, and configured cloudera 5.2.0. Configured spark 1.0.2 to work with Hive. Created hive tables and loaded 4 years of claims data.
• Designed, Installed, and configured greenplum data computing appliance. Involved in exporting data from Hadoop to Greenplum using GPload utility. Created and executed SQL scripts that corrected data errors in Greenplum database.
• Written and maintained Requirement documents, build documents, and Engineering design documents.
• Designed data model for openEMR application. Helped developers to tune database, SQLs.
• Troubleshot Redhat Linux issues related to application servers.

Environment: RHEL 6.3, Tomcat 6.0, MySQL 5.6, JBOSS 7.1, Python, Java, Greenplum DCA, PostgreSQL, AWS

Confidential, VA

Platform Engineer

Responsibilities:

• Designed standards-based Redhat, AIX, VMWare and Solaris systems to host standard and customer applications in a cloud based data-center environment supporting more than 150K users.
• Designed, Installed, Configured, and Managed VMware ESXi multi-cluster environment incorporating HA, vMotion, and Fault Tolerance for a development, testing, and production environment using VMware 5.0, VCenter 5.0. Configure EMC SAN by zoning to allocate the LUNS to VMware Infrastructure.
• 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 Foundation for Cluster Filesystem HA (SFCFSHA), which also utilizes the Veritas Volume Manager (VxVM) and Veritas Filesystem (VxFS) sub-components.
• Migrated WebSphere applications and Oracle Databases of size 10TB+ from traditional standalone servers to cloud environment.
• Collaborated with other engineering teams (such as Storage Area Network, Backup and Recovery, and Security) n 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, DC

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 COGNOS. Tuned SQL queries for COGNOS.
• 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
• Designed and configured Websphere application server solution with Websphere process server, Websphere MQ series and Websphere broker server. Provided tier 3 support to operations team for critical issues.

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, DC

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 Performance Expert 3.1, DB2 Warehouse Edition, Cognos 8

Confidential, MD

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.
• Developed scripts for automated audit reports in order to compare critical databases.
• Revisited database security and cleaned unwanted permissions. Defined new security standards.
• Maintained physical data model.
• 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, Vignette Content Management System, Informatica, Websphere and Clear case and ClearQuest for Change Management control.

Confidential, DC

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, Delphi

Confidential, MD

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, Quest Central 4.5, Foglight 4.0, Informix XPS 8.4, Informix IDS 9.4, DB2 Query, Patroller and DB2 Governor, IBM P655 and P590 systems, DS8300 Storage

Confidential, MD

Data Architect / DB2 UDB DBA

Responsibilities:

• Reviewed database environment and determined if they should be using the Data Partitioning feature.
• Reviewed the physical data base design, the data load procedures and the data warehouse reports.
• Designed logical and physical data model for pricing.
• Created high-level plan to move the database from a partition to a non-partition environment.
• Documented the steps required to migrate the DB2 UDB ESE database from a partitioned environment to a non-partitioned environment.
• Reviewed the DB2 UDB ESE with DPF database parameters and configurations.
• Made recommendations to optimize the performance of the system. That included the production, development and QA/UAT systems.
• Reviewed the AIX settings which can affect performance and stability of DB2 UDB and made recommendations to optimize the performance of the system and DB2. That included the production, development and QA/UAT environments.
• Monitored and reviewed the execution environments of production, development and QA/UAT providing recommendations for stability and performance of DB2.
• Configured health monitor to monitor various parameters.
• Supported application developers for SQL optimization and DB2 Schema changes.
• Provided support for Disaster Recovery.
• Configured the system for automated RUNSTATS, REORG, ONLINE BACKUP, REVERSE

Environment: AIX 5.2, Java, DB2 UDB 8.2 EEE/ESE, Embarcadero’s DB Artisan 8.1.0, COBOL, Erwin 4.1.4, Control-M, P650 systems, EMC DMX 1000 Disk Subsystem

Confidential, VA

UDB DBA

Responsibilities:

• Provided support for DB2 Schema changes, Performance Tuning and Performance Monitoring.
• Supported application developers for SQL optimization.
• Developed procedures and scripts for recovery of ONLINE backups from DB2 UDB V7.2 to DB2 UDB 8.1.
• Configured and administrated DB2 auditing utility.
• Migrated database from DB2 V7.2 to DB2 V8.1 + FP6a as well as handled client server compatibility issues during migration.
• Prepared documentation of procedures and standards (SOX).
• Prepared documentation for new onboard DBA.
• Handled Production, Development as well as Testing environments.
• Involved in Customer Interaction activities for Problem determination and Solution activities.
• Provided 24 X 7 Support for all the Customer Support Issues.
• Configured the system for automated RUNSTATS, REORG, ONLINE BACKUP, REVERSE

Environment: AIX 5.2, Sun Solaris 5.8, Java, DB2 Information Integrator, DB2 UDB 7.2/8.2