SUMMARY:

• Expertise in system design and development required for business process.
• Good problem solving ability and analytic skill to solve the problem efficiently.
• Good team player and have excellent interaction skill to coordinate and work with team.
• Design, develop and implement complete life cycle of data warehouses.
• Ensure compliance of standards and conventions in developing programs.
• Resolve and troubleshoot complex issues.
• Design database Backup and Restoration Strategy.
• Performs general DBA duties (install software, create databases, table spaces, add redo log files, managing storage & work closely with Sr. DBA on capacity planning and performance tuning.
• Provider of database architectures, methodologies, and best practices for several companies - - using established project management methodologies.
• Technical project manager and data architect for Data Conversion, Data Quality, Data Migration, and Data Warehouse projects.
• Highly technical, quality-driven, and team-oriented with several years, successful, local and remote IT experience. Skilled in hardware and software set up, implementation, configuration, troubleshooting, repair, and testing. Excellent communication established with diverse internal staff and external customers/end-users. Meet all established deadlines
• Project Planning/Execution Market Research Clients' Relation
• Team Design and Development Negotiation Communication
• Leadership Development Problem Solving Decision Making
• Conflict Management Risk Management Technical Innovation
• Budget Management Team Work Stakeholder Management
• Attention to Detail Organizational Skills Decision Making
• Administration Self - starter Quality Assurance

TECHNICAL SKILLS:

OPERATING SYSTEM: Sun Solaris, HPUX, IBM AIX, Linux RedHat, Centos and Windows Server

CLOUD TECHNOLOGIES, VMWARE: Amazon AWS EC2, Google Cloud,VSAN

SEARCH: DSE Search with Solr, ElasticSearch

DATABASE INTERFACING: Hadoop, Cloudera and HBASE

BIG DATA AND HADOOP: Hadoop (IBM in Big Data and Hadoop) HDFS, Mapredure, YARN, Hbase, Pig, Hive, Apache Flume, Apache Sqoop, Apache Oozie, Impala, Apache Zookeeper, CDH4, Cloudera, AWR EC2

VERSION CONTROL SYSTEM: Git

DATABASE DEPLOYMENT: Puppet Chef

DBA PROCESSES: NoSQL Hbase, Mongodb, Cassandra, Couchdb, cassandra in Datastax enterprise, Solr in Datastax enterprise, Elastic search Oracle 9i/10g, 11g, 12i, REAL APPLICATION CLUSTER, Oracle Golden Gate, Data guard Sybase ASE, ASE REPLICATION SERVER, SYBASE IQ

DATABASE PROCESSES: Database tuning and designing Database security and recovery

PROGRAMMING LANGUAGES: T-SQL, SQL, PL/SQL, Unix Shell, Java, Json, Python, Pig Latin, HiveQL, CQL

Application Performance Monitoring tools: AppDynamics

Scripting language: Python, Shell Unix/Linux power user

PROFESSIONAL EXPERIENCE:

Ca ssandra architect

Confidential, Maryland Heights, MO

Responsibilities:

• Project: Migrating oracle data model to Cassandra to achieve and reduce the SLA from 10 minutes to 2 seconds and also improve user experience by using kafka, spark and cassandra.
• Actively and consistently supports all efforts to simplify and enhance the customer experience
• Maintains and administers computing environments including computer hardware, systems software, applications software, and all configurations
• Working knowledge of whole Hadoop ecosystem like HDFS, Hive, Yarn, Flume, Oozie, Flume, Kafka, Storm, Spark and Spark Streaming including Nosql database knowledge
• Recommends changes to improve systems and network configurations, and determines hardware or software requirements related to such changes
• Designs and maintains access and security administration for Hadoop ecosystem
• Responsible for troubleshooting Hadoop Infrastructure problems.
• Creates/maintains backup and recovery strategies
• Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation
• Uses established change management processes, requiring operational procedures be performed with minimal customer impact.
• Researches, evaluates and recommends software and hardware products
• Provides new hardware specifications to users based on application and business needs and anticipated growth; installs new servers and maintains the server infrastructure
• Defines procedures for monitoring and evaluates, diagnoses and establishes work plan to resolve system issues.
• Performs troubleshooting for complex hardware, Hadoop Cluster and network problems and provide plans to remediate complex business problems.
• Works on multiple projects as a project team member, occasionally as a project leader
• Deploys all Hadoop components including Operating Systems for project and operational support
• Knowledge of Private and Public cloud computing and virtualization platform

Performance Architect Cassandra Database

Confidential, Cincinnati, OHIO

Responsibilities:

• Worked with business users to define user requirements and business rules; ensured overall solutions met SLA (performance and up-time), DR, and scalability.
• Developed the detailed data architectures that support the enterprise and defined the data standards for enterprise systems.
• Reviewed and assessed all major database designs for implementation feasibility, ensuring that data structure aligned with business goals, intended use, and flexibility of design.
• Tracked all tasks and deliverables throughout the phases of the project.
• Tuned Cassandra for efficient operation using multiple views into system metrics, including OS stats, GC logs, JMX, Opscenter, and cassandra-stress.
• Implement and deploy LDAP Security in DataStax Enterprise 4.8.8 and Apache Cassandra
• Built a search Server with DSE Search SOLR with a cluster of 40 nodes with 2 datacenters.
• Upgrading DSE search with Solr and DSE Cassandra cluster from 4.6 to 4.8.8.
• Migrate oracle to cassandra

Cassandra Database Administrator

Confidential, Monroe, NC

Responsibilities:

• Developed high level designs and plans and estimate the amount of effort required to deliver on time and budget.
• Architecture, implementation and Monitor availability and performance of production and development Cassandra Databases and servers.
• Installed new database releases and related software tools to evaluate in CI environment, eventually promote to production.
• Apply software patches and upgrades to server software for Cassandra Database to stay in compliance with security standards and performance.
• Plan database and server level capacity according to statistics and user requests.
• Work through disaster recovery plans with other groups and departments.

Database Administrator

Confidential

Responsibilities:

• Data Modeling, Setup-DataStax Enterprise on Multiple Data Centers configuration.
• Configuration Vnodes and Single-Token Nodes.
• Managing Cassandra and Adding Nodes, Adding, Removing, Decommission, Move Nodes.
• Cleanup, Backup and recovery, Performance and Tuning.

Database Administrator

Confidential

Responsibilities:

• Served as MongoDb database administrator, installing, managing, maintaining and performance tuning.
• Migrated high-volume OLTP transactions from Oracle to Mongodb.
• Served as Oracle, Sybase, and SQL server database administrator, performing system management, troubleshooting, performance and tuning, and backup functions.
• Drove successful version migration of Sybase data servers in development, user acceptance testing, and production environments, including currency application tracking more than $14 billion in daily financial transactions.
• Performed daily DBA management tasks including troubleshooting, performance and tuning, database monitoring and backup/recovery with Oracle, Sybase, and SQL Server.