Sql Server Database Administration

Satya Devulapalli ***.*****@*****.*** Ph: +1-847-***-****

Professional Experience

Elinks LLC July 2021 - Till date

TEKsystems, USA June 2018 – July 2021

Sierra Cedar Inc, USA April 2012 – June 2018

Mahindra Satyam Computers Services Ltd August 2010- April 2012

Cedar Crestone Inc March 2010- August 2010

Oracle Corporation January 2009- March 2010

Satyam Computers Services Ltd March2004- January2009

Key Contributions (PeopleSoft DBA):

Satya has vast range of experience in managing PeopleSoft application administration and Oracle, DB2, SQL Server databases on Solaris, AIX, HP-UX, Linux, OEL, OVM and Windows 2000 series Server. As part of PeopleSoft DBA/ Admin practice, Satya’s contributions are as follows.

Provided implementation and management support of PeopleSoft v8.x/v9.x (HRMS, CS FIN, CRM, EPM) Application running on Unix/NT environment.

Installation, Configuration of Application server, Process Scheduler, Tuxedo/JOLT and Workstations, PIA, 2-tier client, Report repository.

Setting up the Environment for Development users: Setting up 2-Tier/3-Tier connection, Installing People Tools, Installing required Database Client.

Upgrading PeopleSoft applications, participation from the initial architecture onwards. Involved in the architecture discussions with various clients for PeopleSoft implementation /upgrades.

Performed People Tools upgrades from PT 8.48 - PT 8.50 & PT 8.52 – PT8.55.

Performed Application Upgrades from HRMS v8.9 – 9.1 & to 9.2.

Performed Application Upgrades from FSCM v8.9 – v9.0.

Oracle Database administration activities viz. Installation, User

Management, Table space Management, Managing Profiles, roles and

Privileges, Storage Management, Backup and Recovery.

knowledge in UNIX Shell Scripting.

Expertise in DB2 Database administration.

Configured Oracle Streams for PeopleSoft applications.

Patching the Oracle Databases.

Designed Scheduled Jobs in production along with functional and technical team.

Expertise in SQL Server Database Administration. Worked on Data Migration from Oracle to SQL Server, configured Backup-Jobs, and DTS Package Scheduling.

Experience with most of the top clients across the globe (GSK, DBS, Novartis,UN etc)

Dealing with Oracle Corporation’s biggest clients in PeopleSoft.

Involving in the architectural discussions, performance tuning, troubleshooting the issues existing in top clients of Oracle Corporation.

As part of Oracle Consulting Singapore, Participating in proposal discussions, Implementation critical issues, Performance enhancements.

Architecting Oracle SES solutions.

Installation of SES servers / instances.

Integrating SES search instance with PeopleSoft.

Installed and configured Elastic Search for PeopleSoft .

Setting up Shibboleth Idp /SP for PeopleSoft applications.

Worked extensively on RPA automation.

Set up SDLC for RPA.

Set up Bots.

Expertise in IBM Connect Direct.

Expertise in IBM Sterling.

Expertise in File Agent set up / coding processes for File Agent.

Expertise in SQL Server Database .

Skill Summary

Hardware

Sun SPARC Ultra E-450,Fire V-880, IBM Netfinity 5000

Operating Systems

Sun Solaris 8,9,10 Windows 2000,2003,2008,2012 NT,AIX,HP-UX,Linux,OEL, OVM

Languages

Java, SQL

Databases

Oracle 12c,11g, 10g,9i, 8i, MS SQL Server 2000,2005, 2012,DB2

APPLICATION /Web SERVER

Web logic, Tuxedo/Jolt, Web Sphere

ERP

PeopleSoft v8.x, v9.x (HRMS/FIN/CRM/EPM), BAM8.8,Oracle e business Suite

Tools & Utilities

People Tools 8.4X, 8.5xData Mover, Application Designer, RMAN, Crystal Reports BO, Shibboleth, SSO

Professional Achievements

Involvement in customer presentation for the new deals.

Designing architectures for new implementation/upgrades.

Training the associates on skill-based requirements.

Good knowledge in setting up and supporting PeopleSoft clustered environments.

Expert in PeopleSoft Implementations, Upgrades, Performance Engineering

performance benchmarking for CISCO UCS hardware.

Elinks LLC USA

Duration: Jul / 2021 – Till Date Client University Of Georgia

Performed People Tools upgrades.

Troubleshoot various upgrade specific issues and suggest different options to resolve those issues and their potential impact.

Installed Visual Cobol

Planned the Storage allocation and Memory requirements to host the Upgrade, Development and Test servers.

Prepared backup strategy and the number of backups required for the upgrade.

Tax Updates

Installed Elastic search and integrated with PeopleSoft environments.

Log4j vulnerability remediation and prepared scripts to make the log4j changes.

Expertise in setting up Kibana dashboards / Visualizations.

Expertise in shell scripts on a need basis .

TEK Systems USA

Duration: Jun / 2018 – July 2021 Client SAO

involved in architectural discussions setting up new PeopleSoft environments.

Extensively worked on securing PeopleSoft apps internally and externally.

Designed DMZ for self-service modules.

Expertise in deploying stealth for PeopleSoft applications to encrypt the communications.

Worked on segmentation project for PeopleSoft applications.

Worked on CPU patches / security patches.

Vulnerability patches

PeopleSoft security administration

Sierra Cedar USA

Duration: Mar / 2012- June 2018 Client: CNY, NVG, PLX,ACT

CNY- City University Of New York – Apr 2012 – Jul 2013

Being a Lead PSAdmin /DBA, responsible for picking and troubleshooting priority incidents.

Involving in Architectural discussions for the customer implementations /upgrades.

Fine tuning the PeopleSoft applications.

Applying Bundles

Applying DB patches.

Setting up and resolving IB /Messaging issues.

Tools upgrades.

Java Patches

Importing the certificates in to PeopleSoft environments.

Developing scripts to enhance the best usage of the database and application.

Performance tuning.

Worked closely with QAS team for QAS integration with PeopleSoft for address verification in PeopleSoft pages.

Third party integrations

ACT- Alameda costa contract – Aug 2013 – Mar 2015

Involving in Architectural discussions for the customer implementation.

Installed PeopleSoft HCM / FSCM 9.1 applications on MS SQL SERVER.

Installed and set up MS SQL SERVER Instance / Databases.

Installed and set up Microfocus Cobol for windows 2012 servers.

Applying DB patches.

Setting up and resolving IB /Messaging issues.

Tools upgrades.

Automated the backup and refresh of MS SQL Server using power shell scripts.

Performance tuning.

Third party integrations

SCI- Sierra Cedar Inc – Apr 2015 – Mar 2018

Performed PeopleSoft Campus Solutions application upgrades.

Installed and set up Shibboleth Single Sign on for PeopleSoft.

Installed and set up Oracle 12c instance / databases.

Tools upgrades.

Performance tuning.

CITY UNIVERSITY OF NEW YORK

CITY UNIVERSITY OF SEATTLE

ARIZONA STATE UNIVERSITY

Alameda costa contract

ABBOTT DIABETES CARE

Oracle Corporation

Duration: Jan / 2009 – Mar / 2010 Client: TWG (USA), UDR (USA), RWS, NUS

Being a consultant in Oracle Corporation playing role of POC for DBA issues with the customers.

Involving in Architectural discussions with other teams for the customer implementations /upgrades.

Fine tuning the PeopleSoft applications.

Applying Bundles

Applying DB patches.

Setting up and resolving IB /Messaging issues.

Tools upgrades.

Checking for alert logs at all the levels including the database tier.

Troubleshooting issues related nVision reports, query to Excel reports.

Troubleshooting issues related to the process scheduler, reports not being posted etc.

Detailed architectural level discussions w.r.t upgrades.

Patching analysis.

Trouble shooting integration broker/messaging issues.

Fixing Voucher to excel issues.

Developing scripts to enhance the best usage of the database and application.

Performance tuning.

Scheduing the bacth jobs and troubleshooting issues w.r.t Batch Jobs

Configured Oracle Streams for PeopleSoft applications.

Patching the Oracle Databases

Customers supported in Oracle:

United dominion republic

The warranty group

Bellevue university

Kendle

New Mexico Gas

Illinois tools works

Johnson diversy

Resorts world of Sentosa, Singapore (Full life cycle implementation)

National University Of Singapore, Singapore(Full life cycle implementation)

Satyam Computer Service Ltd.

Duration: Mar / 2004 – Jan / 2009 Client: GSK, DBS, Novartis,UNLB,shoppersstop

Responsibilities:

Installed People Soft HCM 9.0 and FSCM 9.0 with tools 8.48.10 on Windows 2003 and Oracle Enterprise Linux

Installed DMO, DEV, CFG, SAN, TST, PRD instances

Configured the People Soft load balancing for the new instance.

Have done application server load balancing

Implemented SSL for the instance

Implemented LDAP with SSL using MS AD.

Configured the report nodes for the instance.

Configured complete fail-safe instances for Shoppers Stop.

Configured SMTP and FTP for the Instances.

Configured PeopleSoft workstation clients for development team.

Configured the context-sensitive help for the instance.

Configured the Verity Search for all instances.

Configured SSO for PeopleSoft applications.

Fine-tuned the PeopleSoft application for the performance improvement.

Installed and configured PeopleSoft FSCM 8.9 Demo database with people tools 8.48 which is a source database for Initial pass.

Downloaded the upgrade templates and scripts required for FSCM 8.4to8.9 upgrade from PeopleSoft GSC.

Configured Jobs for Initial and Move to production passes using change assistant tool.

Monitoring upgrade jobs and troubleshooting the issues.

Co-ordinate with technical team in analyzing compares reports.

Applied updates and fixes which are required for upgrade to COP (copy of production) using change assistant tool.

Responsible for setting up the SIT, UAT and Production Environments.

Installed and configured COBOL compiler (i.e.) server express 4.0SP1 which is compatible with people tools 8.48

Installed and configured Crystal Reports 9.0.

Configured Integration Broker/Report manager to view reports in Report list.

Configured three App servers for load balancing and high availability of Production Instance

Configured multiple process schedulers on both UNIX and windows Machines

Configured LDAP to setup single signon.

Have configured SSL for Production Instance with Verisign 128 bit SSL Certificate.

Configured App/Web/Process schedulers for Reporting Database.

Configured crystal 10 (with BO) for Novartis.

Wrote batch scripts in MS SQL SERVER for backups.

Configured SMTP and FTP setting for the Novartis application.

Configured SSO and LDAP with SSL for Novartis.

Maintained all the instances at Novartis.

Involved in GSK application upgrade from Apollo(8.4) to GPS(8.9)

Responsible for coordinated dba work along with GSK AUS and GSK USA.

.Configured Mobile Agent for all the instances at Lafarge for laptops and PDA’s.

Fixed all the issues during the setup of Mobile Agent for PeopleSoft CRM instances

Configured the IntelliSync(Info Sync) for CRM at Lafarge

Configured the LOTUS NOTES, DOMINO server for Info Sync at Lafarge

Made the PeopleSoft CRM instance in sync with client’s DOMINO server

Successfully fixed all the issues occurred during the setup of Info Sync

Redirected the URL of the people soft instance to CN (Lafarge’s CN) mentioned by the team

Configured the Correspondence Management for merging of the documents (Microsoft Word and Acrobat Reader) and also configured the printer configuration for all the instances.

Defined the Merge Server (in process scheduler) for merging the documents.

Fixed all the issues occurred during the setup of Correspondence Management.

.

Customers supported in Satyam:

Lafarge

GlaxoSmithKline

DBS ELM implementation

GlaxoSmithKline

UNLB

Shoppers Stop

Academic Profile

Masters In Computer Science Osmania University Telangana India

Contact this candidate