Trainer ID : XEL-RC

• ADF – Scheduling activity for Salesforce, DMS, SSIS – Packages

• Creating SQL Sever Databases on Azure and providing connections to the users.

• Implement Virtual Networks

• Manage Azure Security and Recovery Services

• Manage Azure Operations

• Implement Azure App Service Apps

• Manage Azure Identities

• Designing and deploying dynamically scalable, highly available, fault-tolerant, and reliable applications on AWS

• Selecting appropriate AWS services to design and deploy an application based on given requirements

• Migrating complex, multi-tier applications on AWS

• Designing and deploying enterprise-wide scalable operations on AWS

• Implementing cost-control strategies

• Creating Oracle large database environments on UNIX (HP, Solaris, LINUX & Centos) and Windows platforms.

• Installation, Configuration and Troubleshooting of Single Node and Multi Node Hadoop Clusters and Cloudera’s Distribution (CDH).

• Installed and worked on Hive, Hue, HDFS, Kerberos, Flume, Kafka, Active Directory and HBASE.

• Installation of OBIEE, Hyperion, Applying the Hyperion Patches and providing Oracle Database support to the OBIEE and Hyperion Admins.

• Excellent PeopleSoft Upgrade Skills with Complex Architecture and challenging upgrade Planning Strategy from OS, Database, People Tools and Application Level till the Go-Live.

• Good Experience in PeopleSoft Upgrades involved in analysis, design, Development and implementation from initial pass to go-live

• COBOL Installation with Permanent and Developer License setup for all the PeopleSoft instances with Unicode and non-Unicode issue re-solution fixed.

• Domain knowledge and worked on Oracle Application Server, SQLServer, Hyperion, OBIEE, Datastage, ODI.

• Performance tuning of Oracle Databases, PeopleSoft Application Server & Process Scheduler.

• Applying Bundles , Maintenance Pack, Patches, fixes, Tax Updates & etc

• Creating proactive monitoring and maintenance methodologies using third party tools like Toad, Symantec i3, Remedy, Salesforce.

• MTP server setup on PostCast Server setup for mailing and receiving the mails from the PeopleSoft  Instances for Internal Project.

• SMTP Configuration Setting for non-prod, pre-prod, prod and DR instances.

• Good Experience of PeopleSoft 8.4x, 8.50, 8.51, 8.52, 8.53 & 8.54 Implementation of PeopleSoft Modules - HCM, FSCM, CRM, EPM, CS, Portal  Installation.

• Hosting of all the PeopleSoft instances on the internet, provide support for onsite and offshore for business prospects with sales team for demo to the clients.

• Setup of Non-Prod, Pre-Prod, Prod and DR instance’s to multiple Clients.

• PeopleSoft Refresh, Cloning – Every fortnight provided the Client along with the IVT instance Document.

• Setup the ERD diagrams on the PeopleSoft non-prod, Pre-Prod, Prod and DR Instances.

• Developed Recovery Manager (RMAN) scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.

• Automated tasks using crontab including: Backups, exports and imports, archiving old records.

• Good experience with Unix Shell Script proactive monitoring like the disk usage and the memory usage of the server and monitoring tablespaces. Developed the complex shell scripts (corn mainly) for backup, rotating logs/files, etc.

• Logical backups of data using oracle data pump utilities EXPDP and IMPDP, to move Oracle data from a database or schema to another.

• Experience in designing, testing, managing and troubleshooting DB architecture and management policy.

• Worked on various tools like SQL*Loader, TOAD, Oracle SQL Developer and OEM.

• Analyzed Automatic Workload Repository (AWR), Active Session History (ASH) reports.

• Experienced in generating statistics of database using ADDM.

• Tune the SGA components like buffer cache, shared pool to avoid paging & swapping

• Thorough understanding and excellent experience in tuning, assigning proper indexes such as BITMAP or B-Tree Index according to requirement.

• Worked on Different platform of Unix and Windows operating Systems - AIX, HP-UX, Solaris, Linux, Centos, Windows 98, 2000, 2007, 2008 R2, 7, 8.

• Supporting multiple production databases running 24 x 7 mission-critical / OLTP applications demanding high availability and increased performance.

• Analyzed Tables, Indexes periodically to optimize the SQL queries.

• User Management like Creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.

• Good Knowledge working on Spark and Scala

​

Technical Skills

​

Bigdata Architect with Cloud Certified – Azure/AWS

 

Involved in the business oriented process like requirement gathering, design the solution on Big Data Platform, implementation/development of the requirement using Big Data capabilities, ramping up new team members, Unit Testing, ETL Processes, Cloud computing – Azure , AWS. Implementation, support, testing with the ETL processs, building the big data cluster, manage services, securities, infrastructure management.

 

Cloud Admin

 

Design and Implement Azure App Service Apps. Create and Manage Azure Resource Manager Virtual Machines. Design and Implement a Storage Strategy like Blob, Data Lake. Implement Virtual Networks, Firewall rules. Manage Azure User Security. Manage Azure Operations. Manage/Create  Azure Identities and Data Factory. Creating the LogicalSQLServer and databases. Cost Analysis/Management. Creating HDInsight. Implementing cost-control strategies. Cost Analysis , Cost Management. Create Web API. Version Control GIT Repository Setup.

 

Create an Amazon S3 Bucket, Creating ec2 instance, Cloud security at AWS. Designing and deploying applications on AWS. Selecting appropriate AWS services to design and deploy an application based on given requirements. Designing and deploying enterprise-wide scalable operations on AWS. Implementing cost-control strategies. Monitoring the Resources.

 

PeopleSoft  DBA

PIA configuration, Database refresh, Envirnoment refresh, Adhoc backups, Installation & Configuration of Peopletools, PeopleSoft Applications, Apps Server, Web Server( weblogic ), Process Scheduler,Performance tuning, Database Security,SQR Migrations, Patches, Taxupdates, Upgrades, support, implementation, ERD Diagrams.

 

Oracle DBA

Oracle db 10g/11g/12c, rdbms, sql scripting, sql tuning, SQL*Loader, SQL*plus, object size,  initialization parameters, backup recovery, imp/exp, RMAN, installation, migration, patches,  indexes, physical database design layout, logical database layout, Replication, Refresh database, training for OU, creating schemas,  db links, shell scripting, crob jobs.

 

OAM/OIM Admin/Big Data Admin

Create, load and manage Oracle Identity Manager organizations, roles and users, Import and use predefined Oracle Identity Manager connectors, Use manual and automated provisioning workflows to provision users to a resource, Provision users to disconnected resources, Access and configure Oracle Identity Manager reports using Oracle BI Publisher, Install, configure and launch Oracle Identity Manager 11g R2, Install and configure Oracle Access Manager 11g R2 PS3, Configure servers, data sources and agents, Set up policy configuration (shared components and application domain), Manage sign-on, sign-off and sessions, Configure detached credential collector [DCC], Set up auditing, logging and troubleshooting OAM 11g R2 PS3, Set up secure communication between WebGates and OAM Server.

 

Unix/Window

Sun OS-5.8, Hp-ux 9000, Linux 5, Redhat Advance Server (RHAS), Centos, Windows 2012/2008/2000/NT/98/95/ 3.1, DOS, Windows 7, Windows 8.

​

Oracle Analyst/developer

Developer 2k 2.1/4.5/6i.

 

Programming

Background includes C, C++ on UNIX, FoxPro, Java. Knowledge of object oriented programming. Familiarity with C++, html, JavaScript technologies, .Net, CSS, dhtml.

​

​

Certifications

​

•Certified in AWS Solutions Architect – Professional           

•Certified in Implementing Microsoft Azure Infrastructure Solutions

•OCP Certified in Oracle 11g

•Certified in ITIL foundation in IT Service Management

•Certificate in Bigdata Hadoop from Edureka

•Certificate in Bigdata Hadoop Administration from Edureka

•Certificate in Bigdata Spark & Scala from Edureka

•Certificate in Computing IGNOU University

•Certificate in Oracle DBA(10g), Wilshire Technologies

•Certificate in PeopleSoft Server Administration and Installation Rel8.48,Oracle University

•Certificate in BEA Weblogic Server 9/10 : System Administration, Oracle University

•Certificate in Oracle Application Server – 10g, Oracle University

•Certificate in R12 General Ledger Management Fundamentals Ed1, Oracle University

•Certificate in Asset Management Rel 9 (Hosted), Oracle University

•Certificate in R12 Implement Oracle Workflow Ed 1. Oracle University

•Higher Diploma in Software Engineering, APTECH Computer Educations

•Diploma in Relational Database Management Systems, Digital Computers

•Diploma in Oracle DBA (9i), Digital Computers

​

​

​