SUMMARY:

• 10+ years of Information technology governance, database administration experience and implemented more than hundreds of oracle, sqlserver and nosql database technology solutions for companies like Verizon, Confidential, Constellation Brands, Hudson Group, NYFIX, Armani, Access Group, Dynamic Logic, Heineken USA, AICPCU, Benjamin Moore, Rogers, OFSOptics, DSM Pharmaceuticals, PDI Comcast and Confidential .
• Create project plans and proficient in data center migrations from clunkers hardware to amazon aws, vblock, oracle database appliance and Confidential P750 servers.
• Performance tune NYFIX now NYSE clearing application database and FIX applications databases.
• Architect, implement and budget solutions for structure and unstructured big data ingestions, its batch and serving layer analytic using cassandra and oracle. Designed solutions for in memory speed layer big data analytics using spark.
• Install and configure ORACLE RAC 12C, 11GR2 with ASM, SQLServer 2008R2/2012 failover cluster, Hadoop, mongoDB and Cassandra clusters, Oracle Ebusiness 12i suite on distributed nodes.
• 2 years of Cassandra database administration on aws vpc cloud.
• 2 years of vblock and emc storage and data domain backup appliance and hadoop experience.

TECHNICAL SKILLS

Programming Languages: C/C++/Csharp, Java, Java Spring, Javaspark, scala, PLSQL, TSQL, Perl, VB scripting, PHP, Shell, python scripting

Databases: Oracle 7.x,8i,9i,10G/11G/12c, SQLServer 2005/2008/2008 R2/2012, Mongodb, mySQL, Cassendra,. Oracle RAC, Oracle data guard, Oracle ASM, Oracle Streams, Todd Shareplex.

Big Data: Hadoop, Kafka, Hbase, zookeeper, DSE Cassandra, DSE Spark

Tools: Informatica Hparser, Rational Rose, Microsoft Project, Toad, Shareplex, Vmware, Oracle Grid Control 12c. Warehouse builder, BI Publisher, Informatica, ArchServ, Avamar, datadomain, Netbackup, Netapp, Weblogic, Websphare, Echo Stream, Echo Cluster and Doubletake.

Cloud Computing: Salesforce.com, aws, Openstack, SCAP, OSSEC, Snort

Management: Program management, Project management, IT infrastructure management, Technology governance, Technology auditing, Big data analytic and Cloud integration.

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

Sr Database administrator

Responsibilities:

• Provided hands on database administration professional services for transforming fog computing IOT projects onprem infrastructure to aws cloud. Pioneered proof of concept projects of oracle and cassandra spark database migration to aws vpc cloud. Supported product development teams and delivered scalable robust data driven Java/Spark/Scala applications in the realm of IOT projects development pillar like Internet of things - thingspace and Internet Services - verizon message app applications VMA, DVS, CMP and SCM applications.
• Configured scripts and utilized aws cloud formation tools with devops tools automation tools like Git and Jenkins. Performed level1, level 2 and level 3 database operation support like reviewing, analyzing and implementing NOSQL data modeling and schema design db tickets, add replace dead cassandra spark nodes on aws, add or remove nodes, datacenter and clusters, expand cluster to new datacenters, decommissioned clusters, configured hadoop cfs, spark, spark jobservers and worker servers for database reconciliation jobs, forced compression process using uber jars and configured Wily and DSE opscenter for database monitoring. Installed oracle 12c rac on prem server and migrated Oracle RAC databases to aws ec2 instances and ebs volumes. Load data from flat file using SQL Loader.
• Installed, configured and maintained shareplex bi direction replication between oracle databases on aws cloud and on prem oracle racs, tuned SQL queries, database and OS kernel tuning for peak load performance. Installed and support cassandra aws based clusters range up to total 80 nodes across multiple data centers. Loaded 30TB bytes of VISION mainframe data into cassandra cluster by Datastax
• Provided control file and loader jars. Refresh cassandra clusters databases keyspace from QA to DEV for ongoing release development using aws snaphots. Use Git and accurev tools for configuration management. Monitored and improved database tuning, instance tuning and SQL tuning using tkrof, awr, addm, sql plan, sql profiler in oracle 12c databases.

Confidential, Purchase NY

Database Administrator Led

Responsibilities:

• Implemented oracle sqlserver mysql mongodb database administration and enterprise level data center transformation of Confidential accounts and its 24/7 IT proactive and reactive steady state support services. Supervised and installed oracle rac and sqlserver failover clusters, mysql NDB clusters and hadoop distribution clusters physical to virtual and virtual to virtual datacenter transformation projects to vmware vblock based private cloud.
• Stabilized database infrastructure, performance tuned and implemented latest oracle patches on 11G rac database servers. Setup hugepages and secure oracle listener by implementing cast listener’s encryption wallets. Black belting and hardening oracle, sqlserver and mysql database security for military grade level security implementation of STIG and OWSAP guidelines. Maintained and managed database queues, printers and concurrent manager jobs.
• Configured oracle idm based authentication and authorization workflow and its integration with ldap server. Configured and scheduled enterprise backups using emc avamar and emc dd890 appliance. Analyze awr and addm reports for oracle database and sql tuning. Installed and maintained sqlserver 2008r2 and 2012 cluster server’s high availability always on, failover mirroring and replication. Installed and integrated mysql NDB, hadoop multinode stack for wso2 api management and bam deployment setup.
• Implemented level 3 support of mongodb data warehouse and big table for mass user registration data merge process.
• Added database users for data scientists and supported 4 node mongodb shard clusters incidents, change and problem tickets. Audited mongodb database patterns and identified careless indexing, bucket collections, large and deeply nested documents, and unsharadable collections for performance improvements. Migrated primavera application and databases from cloud to vmware vblock based platform for upgrade migrations from primavera p6 to p7.
• Performed architecture design and capacity plan mongoDB and Cassandra clusters IO and disk space Clone oracle databases on AIX powervm Confidential server. Audit Unix, Windows, oracle, mysql and mssqlserver security profile using open scap. Implemented mysql based calendar sharing app for legal department secured infrastructure. Decommissioned highly secured government data and its infrastructure after data center migrations.

Confidential, NY

SQL / NO SQL/Consultant

Responsibilities:

• Gauged package hadoop distributions of MAPR vs Confidential biginsights vs EMC greenplum / EMC Isilon platforms for C level evaluation and purchase recommendation. Administrated hadoop cluster nodes, setup replication of data nodes, configure encryptions for low latency data ingestions, architect namenode high availability and configured multifactor Fedramp security with ldap and kerbose authentications.
• Cloud Architect Introduced cloud managed services practice for private and public cloud orchestration, which offers end-user support and troubleshoot cloud implementation technologies of vmware vblock, openstack and aws technologies. Conducted platform as service cloud security profile audits using SCAP and utilized host and network based intrusion detections tools like OSSEC and snort for cloud protections.
• Implemented and automated cloud configuration management using chef and puppet. Audit mongodb multimode clusters and its database design performance and security. Developed and deployed oracle packages, unix shell scripts, vbscipts, nagios, ruby, python scripts for maintenance and monitoring. Recovered and restored Hudson group oracle databases during and after, hurricane Professional Services Established
• Managed, led and directed remote database administration practice for Confidential group for 10 plus years and created a 24/7 remote support organization of 14 DBA’s which offer end-user support and troubleshoot oracle, oracle e-business suite and sqlserver, mysql and postgres based database level1, level 2 and level 3 issues. Directed, coached, motivated and recruited technology team for managed services support.
• Managed, budgeted, implemented and project planned datacenter migrations from clunkers hardware to virtualized servers. Created sas70 / type 11 audit reports for IT auditors, created best practice blue prints for pci data security standards, created security reports for sox auditors and created hippa reports for healthcare hospital. Audited, managed and supported database

Confidential, New York, NY

Principal database administrator

Responsibilities:

• Installed and configured oracle real application cluster on windows, solaris, linux, hpux and aix servers using automatic storage manager. Implemented oracle streams replication in oracle rac environment and configured logical and physical active and snapshot standby multisite data guard disaster recovery solutions. Implemented oracle database data movement etl/elt strategies between
• OLTP and data warehouse olap, rolap and holap analytics of very large databases (over 5 terabytes) size. Installed oracle 12i ebusiness software on distributed application servers with oracle rac and upgraded oracle ebusiness rac database to 11GR2. Customized oracle mobile applications java modules of sub inventory transfer and pick order confirm.
• Reverse engineered java source from class files and clone the oracle apps classes for customization. Identified and resolved performance tuning issues in business warehouse data loads into PSAs, ODSs, and infocubes for analytic reporting. Reduced the average response time of sap, oracle ebusiness suite, peoplesoft, jda - manugistics application transactions from 1.6 seconds to 0.3 seconds by tuning indexes, batch jobs, and oracle cost based optimizer.
• Upgrade and applied patches to oracle 8i, 9i, 10G and 11G, 12c, sqlserver 2000, 2005, 2008, 2008 R2 and 2012 servers. Implement oracle database recovery solutions using oracle goldengate and snapshot replication, oracle streams, oracle datagaurad, doubletake replication, vision echostream and echo cluster.
• Maintained database objects partitions and automate tables partitions by using perl scripts. Developed and deployed oracle packages, unix shell scripts, vbscipts, nagios, ruby, python scripts for maintenance and monitoring. Utilize chef and puppet for configuration management. Implement oracle 11G streams replication in RAC environment. Configure oracle database heterogeneous integration with S390, AS400, and sqlserver. Upgrade and migrate sqlserver 2000/20 R2 version. Implement database replication, backup and disaster recovery for postgres and mysql database.

Confidential, New York, NY

DBA Architect/Software Engineer: Developed

Responsibilities:

• Integrated it with AnnTaylor.com website. Developed test authorization C++ socket routines for transaction processing with CRS encore & First data merchant services ENCORE server.
• Developed oracle packages transaction activities logging and fraud checks for Ann Taylor card payment processing. Implemented/programmed/deployed Interworld commerce exchange B2B software at Verizon business, Okidata and IKON Office solution.

Confidential

Analyst Programmer/Payment Solution Integrator

Responsibilities:

• Designed, configured and certified the confidential bank card track layout with Master card network using Arksys euronet software. Configured hardware cryptography for host pin verification modules in Arksys atm controller software. Developed atm screens, configures atm states and programmed financial Institution tables programming by using Confidential pace software on Confidential and NCR atm hardware. Develop depot inventory and sales management system in developer 2000 tool.
• BS in Computer Science, National University of Emerging science and technology, FAST-NU, Pakistan.
• Oracle real application clusters and new features from Oracle University.
• Attended OpenStack security seminar at Comcast.
• Aws workshop and elastic hadoop orchestration seminar at amazon.