SUMMARY:

• Responsible for IT strategy, roadmap, future state, technology selection, focus on emerging business enabled technologies, Internet of Things, BigData (Hadoop ecosystem), Data Analysis, Architecture, Design, Utility cloud computing (AWS, Oracle Cloud), Open Source (LAMP), web security and scale out architectures. Sound experience in BigData domain - Hadoop (Apache, Cloudera) distributions, NoSQL: MongoDB, Cassandra. Hands on working experience on Hadoop/HDFS, HBase, Pig, Hive, sqoop and NoSQL (MongoDB & Cassandra) and cloud architecture. Good working knowledge and hands on experience on MongoDB, MMS, Datastax enterprise, DevCenter, OpsCenter, and CCM tools. Benchmark experience with Hadoop infrastucture layers (Compute, Network & Storage).
• Working knowledge with Data Integration tools Golden Gate replication, Pentaho & Tableau BI/Analytics and Informatica/ODI ETL tools. Amazon Web Services Architecture and implementation.
• Expert in scalable Oracle Architecture and Design of Virtualization (Xen & Esxi), Linux, Solaris, Exadata, RAC, Dataguard, HA, DR, Advanced Replication, Streams, Fusion Middleware, GoldenGate, Exadata, Virtualization/Private Cloud, 12c cloud, Performance tuning assessments. Architecture reviews, health checks, project management/Program Management. Expert knowledge and hands on experience with Oracle Enterprise Manager 12c cloud platform with Level 4 implementation experience.
• Designed high available, scalable enterprise manager monitoring infrastructure with F5 SLBs and Storage replication for True HA & DR. Good working knowledge on IP, DHCP, and DNS, switching, routing and subnets. Designed and Implemented oracle Database as Service (DBaaS) private cloud, infrastructure design.
• Oracle Cluster database Design, Disaster Recovery, Storage design for databases, Application Migration and replication in 12c/11gR2 environments, Oracle cloud, exadata, 12c database architecture/migration/upgrades, and golden gate environments.
• Actively looking for a new position to make best use of his existing skills and consulting experience to work in a challenging environments to solve real world problems Confidential scale. Currently working with customers to design and deploy RDBMS and NoSQL/Hadoop data integration and cloud integration projects.

PROFESSIONAL DEVELOPMENT: Linux System Administration, VSphere, ESXi, Sun Super Cluster, Big data Appliance. Hadoop Cluster, HDFS, NoSQL (MongoDB, Cassandra, HBase, Redis), Pig, Hive, Sqoop, Flume, ZoopKeeper, Apache Spark, Solr, Cloud Utility Computing (Iaas, PaaS), Amazon Web Services (EC2, S3, EBS, RDS, R56, ELB, EMR), Oralce Cloud VMWare, ESXi, Project Management & Program Management.

CORE TECHNICAL SKILLS:

Operating Systems: Sun Solaris, Solaris Express, HP-UX, AIX, RedHat/Oracle Linux, Ubuntu, OS X and Windows

Databases: Oracle, MS SQL Server, MySQL and SQL Anywhere, Oracle E-Business (11i/R12), NoSQL

Networking/Protocols: LAN/WAN, TCP/IP, Ethernet, UDP, Fiber Channel/HBA, NAS, VoIP, VPN, Switches/Routers, EtherChannel, VLAN, EMC SAN, Network Aggregation, DNS, HTTP/HTTPS, IPSec, XML, DMZ, Firewalls, SMTP, SNMP, Virtual IO, Load Balancing, Big IP/F5, Cisco Catalyst.

Applications/Tools: Toad, SQL Navigator, Shell, Perl, Python, Java, SSH, SCP, RPM packaging, networking, MS Project, TSM, RMAN, EMC SAN, SRDF, BCV, Oracle RAC, ASM, VMWare, Erwin, SQL, PL/SQL, Confidential -SQL, Apache, Eclipse, JDeveloper, DB Artisan, Data Mirror, Oracle Enterprise Manager (OEM) 11g/12c

Hardware: Sun SPAARC/Super Cluster, HP/PA-RISC and Itanium, IBM Power Systems, RS/6000, Hardware Virtualization, VMWare Server, ESXi 4.0 /5.1, X86 and X86-64

Middleware/Java: Weblogic, Websphere, J2EE, J2SE, SOA, JDeveloper, Fusion Middleware, Oracle AS10g, EJB 2.0, Oracle Fusion Middleware, SOAP, REST API, Web Services

Cluster/High Availability: HP Service Guard, VERITAS Cluster HA Solutions, IBM HACMP, Oracle Clusterware, Linux Advance Clustering, Oracle Streams, Data Guard, Oracle RAC 10gR2/11gR2/12c, HDFS, GFS 2

Storage: EMC SAN, SRDF, BCV, HP/IBM Storage Solutions, Raw Devices, Oracle ASM, VERITAS FS, Hitachi, 3PAR, Open Stack, Cloud Storage

Real time Replication: Oracle Streams, Golden Gate

Exadata: Sun ZFSOracle Exadata, Sun ZFS

Big Data: Oracle Bigdata Appliance, Hadoop, HDFS, Map Reduce, Pig, Hive, NoSQL, Cloudera distribution CDH 5.x, Cassandra, MongoDB 2.6, HBase, Sqoop, Flume. HortonWorks HDP 2.0. Spark, Kafka

Virtualization: VMware ESXi 4.0/5.1, VSphere 4/5, Oracle Virtual Box, IBM LPAR/DPAR, DB Cloud, VBlock, UCS Cisco Blade Servers.

Performance Engineering: Oracle Databases, Siebel/SOA/AIA/BRM/Peoplesoft and applications.

ERP Database Mgmt: Oracle Apps, Seibel, Peoplesoft

Modelling: Visio, Erwin, SQL Developer, DB Studio

Cloud Architecture: IaaS, PaaS, SaaS, DBaaS, Private and Public Cloud, AWS (EC2, S3, EBS, RDS, R56, ELB, EMR), Oracle Cloud (DBaaS)

Monitoring Tools: OEM, Nagios, Ganglia, Splunk, MongoDB MMS, Datastax OpsCenter, CCM, Dev Center.

Scripting/Programming: Shell, SQL, Bash, Ksh, Perl, Python, Java

ETL/Batch: Pentaho Kettle, Sqoop, ODI, Pig, Hive

Web Servers: Apache, NGINX

PROFESSIONAL EXPERIENCE:

Confidential

Technical Manager/Solutions Architect

Responsibilities:

• Helped a Banking customer to migrate and consolidate Oracle databases to Exadata platform. Achieved its stated goals of cost reduction and single point of contact with Oracle.
• Worked with retail customer to migrate EDW to Oracle Exadata and application stack to Exalogic. Worked with engineering team to integrate Exa* stack, InfiniBand connectivity across exadata, exalogic and ZFS storage.
• Architectural, Project Planning and Hands on BigData/Hadoop/NoSQL, Database and System Engineering and Performance Management. Managed database engineers/ system administrators/application developers and operations teams on Oracle, MySQL.
• Helped retail customer with migration of Oracle EBS R12 suite to Exadata. Provided monitoring, configuration best practices using Enterprise Manager (OEM) 12c using HA solution.
• Scoped, Planned and Designed Enterprise Manager 12c Cloud Control HA/DR Level 4 solution. Collaborated and Helped Infrastructure team to configured Network, SLBs, Global DNS, Virtual Host, Common URL. Configured Storage replication with Rsync, ZFS real time synchronization options. Setup ASM Flex clusters and ACFS for OMS cluster file systems for Software Libraries. Developed run book for switchover and failover testing. Participated in enterprise wide DR testing. Deployed Database as Service cloud pack, service catalogs, created server pools, resource pools, Infrastructure as service, Software as Service and chargeback.
• Designed, build and delivered a large-scale Hadoop cluster. Fine-tuned compute, network and storage layers in the HDFS cluster to achieve high performance and scale out architecture and to host very large data sets Confidential largest retail customer.
• Helped large telecom customer with Planning, Architecting, Sizing and migration of databases (50 TB) from SPAARC & IBM Power Systems to VCE VBlock hardware. Designed and Deployed OEM 12c cloud control infrastructure with clustering, HA, DR and Load Balancing. Provided roadmap for upgrading oracle databases to 12c. Provided Health checks, capacity planning/sizing, performance metrics that enabled customers with infrastructure migration and upgrade plans and project planning. This project migration helped customer with 1.2 million dollars annually savings from hardware/software license consolidation, less outages, alleviated from performance and slow responses and high team productivity.
• Helped largest retail customer with Database architecture, Capacity Planning, design and implementation of database upgrades, migrations, Exadata deployments & best practices, RMAN/ZFS backup/recovery best practices, re-design of retail application (OLAP, Dimensional Modeling, STAR schema, EDW, Operational Data Stores, and Data Replication). Helped Database and data architecture teams with merging 2 X3-2 full racks for POC and bench marking and high volume testing. Provided Workshops, Training sessions, Presentations and Project Plans. Helped with database consolidation and upgrades to 12c. The successful project achieved 4.5 million dollars annual savings in infrastructure hardware, software licenses, better use of resources and team performance.
• Helped utility customer with migrating legacy applications and databases to smart metering using Oracle database & middleware (Weblogic & MDM) to enable 4 million customers with smart metering & better user experience. Helped Informatica ETL Development and Support teams with tuning large Load & Extract process and reduced load time to 2 hours from 18 hours. Design and implemented an ETL process to load/unload data sets from NoSQL/Hadoop cluster to RDBMS/Data Warehouse stores. Customer saved 1.5 mil
• Helped retail customer with migrating their E-business R12 suite from RedHat Linux running on HP hardware to Exadata X4-2 1/4 rack. Setup DBFS, helped troubleshooting IB network, backup network, routing, VLAN trunking, and NFS mount options of RMAN backups to ZFS storage. The successful project completion has achieved 750,000 dollars yearly savings to customer through high availability, low outages and higher transaction throughput.
• Helped insurance customer with migration of 10gR2 database (10TB) on Solaris to Exadata X3-2 full rack using Oracle Golden Gate and other methods.
• Involved in designing, installing and configuring Hadoop clusters Confidential large retail and telecom customers. Helped customer data team with installation, configuration and administration of 10 node HDFS cluster including Hadoop eco-system (Pig, Hive, Sqoop, Hbase) in RedHat Linux environment. Provided solution to configure and maintain Cassandra cluster. Helped customer with infrastructure architecture, capacity, storage, and hardware and technology selection.
• Implementation experience with SOA & Fusion Middleware data stores performance tuning & configurations.
• Worked with and Helped customer team designing and deploying Virtualization solution using VMWare ESXi/VSphere 5.0 for R&D and Lab environments. Built 300+ VMs for applications, Database Systems.
• Other Skills: Presentations, Proof of Concepts, RFPs, RFIs, SOWs, Work Shops, White Papers, Engagement Reports, Standards and Process automation and documentation. Good Vendor Management skills worked with licensing teams.

Confidential, Atlanta

Consulting Database Architect/Lead Database Engineer

Responsibilities:

• Managed database and system administrators on various infrastructure projects improving service level agreements by reducing time to deliver IT solutions to business.
• Developed stronger ties between customers and Infrastructure team resulting in collaborating and working together to effectively use IT for business.
• Conducted interviews and participated in hiring decisions along with HR in order to retain the best talent in the organization.
• Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap
• Led database compliance effort in accordance with corporate data security and participate with internal and external audits resulting in fulfillment of SOX/PCI requirements.
• Managed change control meetings, change management, process and standards to ensure changes to production environments are validated and thoroughly tested. These efforts eliminated human errors, software bugs, workload issues and reduced drastically
• Provided guidance to database and application team with Database backup and recovery strategy, storage design for databases, data security and archival strategy and Application Migration.
• Articulated, Collaborated in enterprise system designs and architecture best practices. Worked with hardware and software vendors to gain industry’s best technology selection and insight.

Confidential

Senior Database Architect and Technical Lead (Consultant)

Responsibilities:

• Benchmarked and captured I/O subsystem statistics with ORION tool.
• Orchestrated, architected and designed database systems, planned and implemented migrations/upgrades 11gR1 to 11gR2. Upgraded 9i & 10g databases to 11gR1. Implemented DR solutions, Streams, Data Guard and Golden Gate
• Administered Linux Servers. Installed and configured 11gR1 & R2 RAC Database systems. Supporting multiple state health care and Pharmacy Benefit Management Databases. I/O benchmark testing on Fiber Channel SAN, NFS, Direct NFS for oracle databases.
• Responsibilities including leading team of database, system and storage administrators
• Implementing of cost based optimized statistics and maintain histograms. Optimizing nested sub-queries and Transform relational expressions.
• Evaluation of aggregate data, implementation and maintenance of materialized views, staging tables, and partitions
• Resolving contentions due to high concurrency in an Oracle RAC database
• Evaluating business requirements and ability to map with Oracle database performance
• Implementing best practices with cost based optimizer statistics and histograms
• Proficient in achieving SQL plan stability, maintaining baselines with SQL plans, ASH, AWR, ADDM for pro-active follow up and SQL rewrites. Optimizing nested sub-queries and Transforming relational expressions
• Providing framework for the indexing evaluation, implementation and maintenance
• Customize solutions development with the best practices
• Hands on experience in implementing complex business logic by developing and maintaining SQL for multi-terabyte and very high transaction volume SQL & NOSQL database/systems.

Confidential, Atlanta, GA

Senior Database Engineer (Consultant)

Responsibilities:

• Responsible for overall database systems availability, Performance and Availability Dash Boards, Sizing and Capacity planning, Performance Metrics and Analytics
• Designed and implemented several RAC cluster database design, deployment & configuration and performance tuning
• Designed and configured Data Guard Solutions. Designed, Developed, Configured and Assisted in Database backup and Recovery solutions.

Confidential, New York, NY

Senior Database Architect (Consultant)

Responsibilities:

• Responsible for overall database systems availability, Performance and Availability Dash Boards, Sizing and Capacity planning, Performance Metrics and Analytics
• Designed and implemented several RAC cluster database designs, configuration and performance tuning
• Designed and configured Data Guard Solutions
• Designed, Developed, Configured and Assisted in Database backup and Recovery solutions.

Confidential, New York

Lead Database Administrator

Responsibilities:

• Responsible for database administration, support, application and database performance tuning.
• Process engineering, procedures and standards, change management, on-call rotation, team mentoring.
• Lead Database Administrator. Mentoring, Tasks assignments, presentation, architecture and design.
• Data Modeling, Logical and Physical Design.

Confidential

DBA/Systems Analyst

Responsibilities:

• Responsible for database administration, support, application and database performance tuning, installation and configurations. Application Development, Version control and Change management. Data modeling, Data security and data management.
• Prior to relocating to the U.S worked in India from on various IT projects supporting and administering several oracle and SQL server and Sybase databases, supporting Development, Testing and Production environments in banking, financial, insurance and telecommunication industries.