Resume

Sign in

Oracle, MS SQL, Postgres, Greenplum, HAdoop, ETL

Location:
Saugus, Massachusetts, United States
Posted:
March 20, 2018

Contact this candidate

Resume:

Sohail Mian

* USA Citizen *

** ******* **, ******, ************* 01906

ac4vfk@r.postjobfree.com

617-***-****

Sohail is a seasoned IT Professional with 2 decades of broad industry and information technology experience. Sohail has acquired a deep understanding of relational databases and Hadoop technologies, has worked across a variety of industries including financial services, healthcare, insurance, retail, manufacturing, oil & gas production, energy, education and government. Sohail has also been working on directed availability implantations of Native Hybrid Cloud Analytics solutions in Healthcare, Finance, education. Sohail has extensive solid hands-on experience with core infrastructure technologies including, Hortonworks, Cloudera, Isilon, Greenplum, Linux, UNIX (HP-UX), Windows, Oracle, and SQL Server. Sohail is a problem solver and thinks outside the box on complex issues, managed & led cross-functional onshore and offshore teams.

CORE COMPETENCIES TECHNICAL COMPETENCIES

Analytical Ability

Business Technology

Technical Leadership

Strong Organizational Skills

Data Center Migration

Project Management

Mentoring / Delivering /Passion /Influencing

Coach / Fast-paced /Flexible

Best Practices / Problem Solver

Establishing goals, roles and guidelines

Data Lake /Data Reservoir Strategy

IT Service Management

Oracle RDBMS

MS SQL RDBMS

Greenplum/PostgreSQL

Hortonworks / Cloudera

Redhat Enterprise Linux

Isilon OneFS

SQL /PSQL

ETL / Data Load /Data Load Automation

Scripting

Experience:

DELL EMC /EMC / Pivotal (April 2011 to Dec 2017)

Business Technology Solution Advisor: Identified technology opportunities and actively engaged both business and technology leaders on the realization of those opportunities. Architects in the Technology Assessment & Management Team identify and evaluate vendor solutions, Big Data technologies and Cloud solutions to enabled business objectives through the use of technology. Worked closely with Business Units, Technology Teams, Software Engineering, Global Security, Procurement, Enterprise Architecture and Infrastructure teams to understand required business capability, identified solutions and balance both technical risk and cost of ownership in the product selection process. Served as the primary liaison between the Business, Architecture, Development and Testing teams throughout the project lifecycle. Advised the client DBA, BI, Analytics, Data Science teams and Business LOB which technology fit best to resolve their Business needs.

oAdvised as SME to install the Hadoop and Greenplum data lake clusters. 20+ Greenplum and 20+ Hadoop Clusters.

oBrought more than 80+ sources data to Data Lake (Hadoop, Hive, Impala, HAWQ, Mango DB, Greenplum) 10 PB Data.

oRecommended business technology which reduce time to build BI reports, dash board and reduce the cost.

oLed onshore and offshore teams delivering solutions and manage system development life cycles.

oRecommended the technology which helped read very dirty data not able to load in RDMS & MPPDB.

oAssessed, captured, and translated complex business needs and pain points into analytics use case.

Greenplum Architect/ DBA/ SME: Certified Greenplum environments meet best practices standards. Provided suggestions for mitigating any observed vulnerabilities. Built new Greenplum environments on DCA & Software only. Documented all new and existing environments and created additional documentation for installations, upgrades, migrations, expansion. Created shell scripts required for monitoring and alerting. Automated day-to-day tasks. Optimized load jobs and automated schema/table clones. • Created new roles, schemas, group roles and assign to resources as appropriate. Troubleshooted issues as required. Migrated multi-Terabyte databases from legacy servers to the new infrastructure. Participated in Disaster Recovery exercises.

Data Architect: - Performed health check of Greenplum, Hadoop and Gemfire systems. Developed and delivered technical training to their user base of approximately 200+ people and also trained their DBA team. Developed executive level presentation on findings, recommendations, best practices. Gathered data from many sources and loaded. Advised through the process of Greenplum Hadoop integration. Created scripts to start/stop DCA, Back & Recovery, Data Cleansing, Data Integration and Data Load. Loaded Data into Greenplum and Hadoop, Impala, HAWQ using Talented, NIFI, External Tables, gpload, sqoop, flume.

Hill Holliday - HHCC (Sep 2005 - Dec 2010)

DBA & BI Team Lead (Oracle, MS SQL, Postgres, Cognos)

Coached and mentored staff with an emphasis on building a world class database team in our organization.

Supported entire company’s data in Oracle11g, 10g, 9i databases, MSSQL 2008, 2005 and 2000 servers. Troubleshoot day to day database and application issues. Supported VLDB in data warehouse and OLTP databases. Provided 24x7 level-4 DBA support.

Supported and maintained Cognos BI application. Troubleshoot analytics team reporting issues.

Responsible for Monitoring, performance tuning, trouble-shooting, backup and recovery, partitioning and configurations in development, QA, Staging and production environments.

Restored databases with cold backup, hot backup, incremental backup, and archive logs

Created shell scripts to automate database maintenance procedures and to generate system reports.

Installed and Upgraded databases to 10g, ASM and Test Oracle 11g.

Created and implemented security models. Provide input into standards and procedures and for monitoring, capacity planning, maintenance, backups and recovery. Kept all environments up to date with patches. Worked closely with developers to deploy codes to different environment. Created and implemented best practices for PL/SQL scripts, triggers, packages, tables and views

Optimized database performance by analyzing objects, generating statistics, creating indexes and views

Setup and maintenance VMware servers which are running test and training databases in Red Hat

Coply IT / Bionaut / Syratech (Oracle, MS SQL, Unix) (Sep 2003 – Sep 2005)

Sr. Consultant / Team Lead: - DBA & BI Architect

• Lead Database team to implement and managed the Enterprise Database Services teams within company.

• Responsible for architecture, database operations and recovery, performance tuning and monitoring,

• Engaged with Business, Development, Team Leads and other Technology team

• Documented database and system process requirements

• Assessed the risk and business impact of Data Architecture on existing and future implementations

• Protected critical database solutions from security exposures and up-time availability

• Performed analysis and end-to-end execution from roadmap to implementation of database consolidations,

migrations, conversions and upgrades.

• Made recommendations to ensure we scale the business.

• Maintained and administered databases and supporting automation (e.g. database objects, security roles,

capacity, performance tuning, import/export, alert rules)

• Provided technical direction to DBAs, database developers and development Team Leads Architect,

developed and maintained transactional and multi-dimensional database solutions

• Supported compliance and disaster recovery activities

• Resolved database issues (incident and problem management)

• Established database standards and best practices

• Possessed strong working knowledge of High Availability, Backup and Recovery

• Database - Oracle, SQL, GPDB for OLTP. DSS & Big Data Analytic

Tools /Technologies:

Operating System: Window XP, 2000, 2008, Unix (Solaris, Red Hat, Linux, HP Unix)

Database/System: Greenplum, Oracle, MS SQL, Postgres, HAWQ, Impala, HBASE, Cassandra, Mango, Couch, Gemfire

Hadoop: Pivotal Hadoop, Hortonworks & Cloudera

Big Data Solution Design for BI and Analytics using Greenplum, Hadoop, Kafka, RabbitMQ, Hive, impala, HDB(HAWQ), HBASE, Cassandra, Mango DB, Couch DB, Tableau, QlikView, Cognos, MicroStrategy, R-Studio, R, Python, Java, ETC…

Advance Architecting on Amazon Web Services: Cloud Migration and Architect. Cloud System Architecture – Concept and Design / Cloud Strategy. Analytics Data Lake /Data Reservoir Strategy & Tools

BI Tool Exposure: Tableau, QlikView, Cognos, MicroStrategy, SAS, SAP, Presto

ETL/Data Load: Gpload, External tables. NIFI, Sqoop, Flume, Attunity, Informatica, Data Stage, ETC…

Education:

MBA --(Punjab College - Affiliated with Arkansas State University)

BBA --(Punjab College - Affiliated with New Mexico State University)

DSE --(One-year Diploma in Software Engineering – National College of Computer SciencesS)



Contact this candidate