Profile Summary:

• Over 15 years of experience in the IT Industry
• 8 years experience in Data Warehousing, designing Petabyte systems in
• 7 years experience in Oracle on different Unix platforms as a Developer & DBA
• Specialist in MPP and Distributed System Management.

Key Skills:

• Define the EDW Infrastructure Vision, Strategy, and Execution.
• Expert in Data Architecture, ETL Development, Administration, and Operations.
• Experience in designing Integrated Data Warehouse (IDW) - and.
• Effective in promoting a positive, productive work environment.
• Effective leader; able to prioritize, delegate and motivate.
• Expert in Database and its Utilities like TPT, TDCH, Query Grid, etc.,
• Design and configure critical workload Management settings which impact the adherence to SLA time for various applications using Active System Management (TASM).
• Proficient in Performance tuning of Application-database architecture.
• Built Sophisticated/Self-serving tool with Capacity Allocation, System resource consumption computation models.
• Provide last-tier support for ETL teams, including root cause analysis and best practices.
• Implement Security and integrity of corporate data warehouse.
• Design and configure the Backup Recovery Strategy (BAR) across Enterprise Systems to ensure data recoverability and availability in line with Business requirements.
• Design and built migration strategy for multi-petabyte EDW systems.
• Handled planned and unplanned outages; involving different stakeholders.
• Handle Change management Operations (Review/meetings/approval/implementation).
• Ecosystems - HDP, HDFS, Hive, Oozie, and Scoop.
• Oracle Exadata (database and storage server) Administration and proficient in Installing, Configuring, troubleshooting & Supporting Oracle 9i/10g Databases.

Skill Set:

RDBMS, V2R5/ V2R6/ 12.x/ 13.10/ 14.10 / 15.0, Netezza TwinFin v5.0.6, Oracle 8/ 8i / 9i / 10g / 11g /, Oracle Exadata SQL Server 2000 and Unify DataServer

ETL Methods:

Utilities - BTEQ, MultiLoad, FastExport, FastLoad, TPump, TPT, TDCH, Query Grid and Informatica Powercenter

Programming Languages:

UNIX shell script, Python, Oracle PL/SQL, Core Java

Monitoring Tools:

Viewpoint, Manager, PDCR, PerfWeb

Workload Management

Archive System Management(TASM), Priority SchedulerReplication Tool:

Oracle Golden Gate Data Modeling / Design Power Designer 16.8, Erwin 9.5, Microsoft Visio

Operating Systems:

UNIX (AIX, SUN Solaris), Linux (RedHat, Ubuntu), Windows (9X), Big Data HDP 2.2, HDFS, Hive, Pig, Sqoop & Oozie

Reporting:

Tableau 8.0, Scheduling and Automation Cron tab programming & UC4 scheduling

Project Experience:

Role: DBA / Architect

Responsible for:

• Building Integrated Data Warehouse (IDW)
• Design Database & ETL for seamless data flow from Oracle to and
• Simplify multi-system Analysis using Connector for (TDCH), QueryGrid
• Setup DataLab to provide separate dedicated space within Warehouse for Agile development of new Analytical queries that can combine ad-hoc and production data
• Responsible for data migration and data integration using HDFS, HIVE, HBASE, and Oozie
• Design logical and physical data model
• Present capacity and forecast report on System Health, Capacity and Performance
• Analyze and setup Workload Management for different applications, workload

Role: DBA / Architect

Responsible for:

• Ability to conduct discovery, root cause analysis, and make recommendations for the remediation of system-related issues
• Expert in TASM ( Active System Management)
• Implemented User and Business Unit level CPU limit program which looks up resource consumption metrics and re-classifies user accounts profiles
• Implemented Business Unit (BU) based security model ensuring security and integrity of corporate data warehouse adhere to SOX compliance
• Apply Multi-Value Compression (MVC) and Block Level Compression (BLC)
• Developed Daily and Weekly SmartStats process using TD 14.10 Features
• Prepare capacity planning report based on current Business demand and future need
• Migrated 700TB of data from TD 12 (120 Node x 5550H) to TD 13.10 (60 Node x 6690) shared system with minimal impact to the Business and 13.10 to 14.10 on new EDW system
• Identified 14.10/13.10 post-migration Optimizer behavior changes on OLAP queries and Foreign key join elimination and worked with the Engineering team on a customer-specific workaround
• Coordinate across Business Units and GSC resolving system and database related incidents on system outage, software upgrade, etc.,
• Provide support to Oracle GoldenGate replication service between Oracle and
• Implemented PDCR setup and developed performance and capacity KPI’s
• Proficient skills using Shell script and PL/SQL for automation
• Enable data movement between and using Sqoop and Hive

Role: /Netezza DBA Lead

Responsible for:

• Accountable for Managing service operations of Production/Test/Development systems
• Work with the Business and Application Development teams to ensure the database infrastructure meets/exceeds Business expectations
• Analyze query performance following Physical Design changes
• Assist developers in tuning SQL and maintaining appropriate TASM profiles, allocation groups, and workloads
• Work with ETL leads to formulating ETL approach and appropriate use of Tools and Utilities including FastExport, FastLoad, and SQL Assistant
• Provide ongoing support of the environment by developing processes and executing object migrations, security and access privilege definition, and performance monitoring
• Oversaw and managed all security-related tasks on, Linux and Windows environments, for tools and utilities
• Responsible for server availability and capacity planning
• Designed and implemented Data Access Control Mechanism (Project-based Functional Roles) to ensure better control over User access leading less overhead on DBC tables
• Maintain the living Engagement and Operating guidelines document
• Monthly SOX review for Users and Application security

Role: DBA

Responsible for:

• database object, space, user management, capacity planning, and security administration
• Identify bad performing queries and analyze, provide recommendations for improvement
• Handle physical and operational skew issues
• Backup using VERITAS NetBackup and TARA tool
• Handle Data movement to different environments using backup and restore process
• Viewpoint administration, alert management, scripts release on a production system
• Support ETL team on FastExport, FastLoad, and Bteq scripts
• Create incidents to support and co-ordinate with Customer Support as on when required to provide maximum system availability
• Modify Priority scheduler settings as per client requirement and system/user workload
• Generate reports on CPU usage, I/O, space usage, etc on a weekly/monthly basis
• Handle On-Call support and send weekly status reports to the client

Role: Oracle DBA Lead

Responsibilities:

• Oracle 10g Application server installation in Linux x86 environment
• Oracle 10g OCS Disaster setup & 10g content services patch apply
• Oracle LDAP, SSO, Content services, Portal Intranet, Portal Internet configuration
• Oracle Configuration Manager Installation in Database and mid-tier
• Oracle SOA, OCSM Installation & Administration
• Coordinating with Oracle support for patches and bug fixes

Role: Oracle DBA

Responsible for:

• Install/Upgrade Oracle 9i & 10g on HP-Unix environment
• Security and space management on Prod environment
• Interact with Oracle Support Services for customized patches
• USER management as per the request from the client
• Database character set conversion
• Analyzing daily jobs and suggesting an enhanced feature to improve the performance

Role: Oracle Application & Production DBA

Responsible for:

• Capacity and contingency planning of the project backend activities
• Developed PL/SQL packages and Libraries, Security audit trigger on database activity
• Handled various performance issues related to SQL tuning and Memory tuning
• Configure RMAN and plan database Physical, Online/Offline backups
• Established shadow database using Oracle Advanced Replication
• Provided technical training for clients to manage databases in regular and critical situations, writing optimized queries
• Implemented Disaster Recovery Solution using DataGuard

Role: Oracle Application & Production DBA

Responsible for:

• Install/patch Oracle9i and 10g
• Setup RAID-1 on IBM AIX 5L
• Developed ATM Reconcile module in PL/SQL package handling 1.4 million ATM transactions/day
• Configured Oracle database, Chilli Soft, and Apache on Solaris 8 and RedHat Linux 2.1 Advanced Server
• Developed Backup and Recovery tool integrated with the application

Responsible for:

• Involved in Purchase, Gate pass, Budget module database logical & physical design, and development
• High Oracle database availability (16x7) using Oracle8i DataGuard
• Ensure that all the work meets the quality requirements with zero defects