Management Manager
Resume:
SAILAJA LEDALLA
EXPERIENCE
IBM, NY
Siebel Administrator
For this global project, deployment is being done in three different
Geographic locations: USA, Europe (UK and France), and Asia (Japan and Asia
Pacific).
Siebel Performance experience:
. Help Tuning OS to get better performance from Siebel
. Tune AOM for better performance from server -- Siebel runs on like-AOM
Caches, Thread pooling etc.
. Tune MTServer parameters for individual components like SRBroker, and
CommSessionMgr for specific environments to get optimum performance
. Help developers tune their script to enhance EAI performance
. Analyze EAI Siebel adapter performance to detect the performance issues
. Use Business Objects caching to get better EAI performance
. Tune parameters like NUM_IFTABLE_LOAD_CUTOFF and Docking to enhance EIM
performance
. Tune Remote components like Transaction Router to enhance the performance
Overview:
. Installed and configured multiple versions of Siebel.
. Worked on Windows as well as AIX platforms
. Worked on DB2 and Oracle databases doing extensive monitoring and
performance tuning
. Installed and configured databases for Siebel during the environment
builds
. Installed and configured correct bit client on required servers.
. Advised clients on architectural decisions for Siebel
. Assisted developers and end users on production
Responsibilities:
. Worked on builds of various environments for Siebel 7 through Siebel
8.1.1.
. Installed and administered various Siebel applications on many servers in
environments like prod, test and development.
. Install/uninstall remote client.
. Troubleshoot Siebel Synch issues
. Troubleshoot remote client issues/troubleshooting.
. Resolve issues and concerns that users are facing.
. Installed and configured components to enable various functions users
requested.
. Created and implemented changes to include users wishes
. Changed many configuration parameters using GUI and server manager
commands
. Used server manager extensively to resolve issues and implement changes
. Worked on migration of SRF, browser scripts
. Helped developers resolve issues with SRF or scripts
. Created scripts to administer Siebel
. Opened SR with Siebel with issues faced by users.
. Built and administered Siebel sales analytics.
. Restoring database and performing post refresh Siebel steps.
. Worked on EAI
. Write maintenance scripts in kshell.
Oracle DBA
. Installing full 10g version and 11g version databases
. Patching the database to resolve bug issues as well as enhance existing
features
. Set up Rman full and incremental backups
. Creating and maintaining databases for development, testing, quality
assurance environment
. Korn Shell scripting for automating various databases' admin activities
like monitoring space utilization, export/import, run table/index
statistics updates, alert log purging, granting privileges according to
security guidelines.
. Product support includes data reorganization, backup & recovery (version
and roll-forward recovery) and managing log files
. Data loading, migrating and maintaining using various utilities export,
import, load.
. Handling database security across development, test and functional team
with granting read only, read/write access to various users and user
groups.
. Product support includes reorgs, backup & recovery and managing log
files
. Work with application developer and sql monitoring
. Create various database objects (tables, indexes, views) and implement
referential integrity constraints for enforcing data integrity and
business rules.
. Separating tablespaces for system, data and indexes. Create locally
managed tablespaces, online objects management and views.
. Write maintenance scripts in kshell.
Data warehouse
. Administered ETL on DAC client and Informatica for data consistency.
. Create database objects for specific datawarehouse functions
. Planned and implemented backup plan.
OBIEE
. Installed and configured various components of OBIEE
. Fixed ETL when its stuck using database tables and DAC and
Informatica configuration consoles
. Troubleshoot the connection issues of OBI, Informatica, DAC and
databases
. Troubleshoot the integration issues of OBIEE integration with
Siebel
. Resolved sockets and port issues with start/stop of OBIEE
. Integrated Bi Publisher with Siebel
DB2 UDB Administrator
. Patching the database to resolve bug issues as well as enhance existing
features
. Set up full and incremental backups
. Configure QCapture and QApply
. Planning storage requirements and allocating
. Creating and maintaining database storage structures.
. Tablespace administration.
. Monitoring database and performance tuning.
. Maintaining schemas, users depending on the type of function.
. Trouble shooting installation, maintenance problems.
. Write maintenance scripts in kshell.
Ethink Services, NJ
12/2003- 02/2005
DB2 DBA
Responsibilities:
. Korn Shell scripting for automating various databases' admin activities
like Monitoring space utilization, export/import, run table/index
statistics updates, alert log purging, granting securities, rebuilding
invalid objects
. Use snapshots to detect slow performing SQLs and deadlocks, resolve
user's issues with SQLs
. Develop shell scripts, SQL code, stored procedures and triggers
. Database loading, migrating and maintaining data using various utilities
EXPORT, IMPORT and DATA Replication
. Production support includes data reorganization, backup and recovery
(version and roll-forward recovery) and managing log files
. Flash copies to mirror and reporting databases to maintain consistency of
the databases
. Set up runstats and reorgs to maintain performance level of systems
. Rebuild a DB because of the corruption on one of the system catalog
table.
System Monitoring duties include
. Analyzing the performance problems.
. Changing the memory parameters after the memory analysis and study
. Fine tuning SAP memory using RZ10, ST02, ST06 and ST04
. Monitoring the OS related performance problems
. Performance optimization of system after carefully monitoring system
. Transport Management System, Patches and Client Administration
. Configure the Transport Management System
. Post installation activities such as Patch Application, Language Delta
Import etc.
. Creation of Clients.
. Copying Clients (Local & Remote) and Deleting Clients.
SAP Basis Administrator duties include:
Computing Center Management System (CCMS)
. Configuring background server and related properties
. Scheduling and monitoring background jobs
. SAP batch scheduler configuration and maintenance
. Imported and maintained all system profiles.
. System monitor, alert monitor, workload and buffers
. Created and tested the efficiency of logon groups and load balancing.
. Maintained alert thresholds by monitoring the system over a period of
time.
Oracle DBA
. Ensure that the Oracle 8i databases and data management procedures are
production ready, implement, verify and test the changes
. Database and application tuning
. Documenting the data management procedures, recovery strategies, tuning
procedures specific to each database.
. Database specific configurations (user ids, grants, packages and system
owned utilities)
. Space management
. Implementing data model changes on physical and logical data model
. Monitoring, resolving and tuning SQL *NET related issues
. Supporting Database users.
. Provide technical guidance and support other Database staff.
Career Vision, NY 03/2001- 02/2002
Oracle Database Administrator
Responsibilities:
. Online backups and regular user-table, complete backups and restoration
of the same in case of problems.
. Planning storage requirements and allocating.
. Creating and maintaining database storage structures.
. Tablespace administration.
. Offline lines redo logs archiving.
. Monitoring database and performance tuning.
. Trouble shooting installation, maintenance problems.
. Oracle backups and recovery.
S.S.M Consultancy, India
05/1995 - 09/1997
Senior Programmer
This Project generates the purchase order for the requirements and sales
orders for the future transactions with the customers. It updates the
stock in the inventory and maintains the re-order level
Responsibilities:
. Design, Entry Screen Painting, Existing data conversion, creating
samples, testing with existing data, Checking Data Integrity, Programs
and Reports Consistency Checking.
SKILLS:
ERP: Siebel 7.0 - 8.1.1
Database Management Systems: DB2 UDB 7x and DB2 UDB 8 ESE, ORACLE 8.x
Programming Languages: C, SQL, PL/SQL, Visual Basic 6.0, and Java
Operating Systems: AIX, Solaris, HP-UX, Linux, Windows NT/2000, Windows
2003, Windows XP
Certifications: Oracle certified Database Administrator, IBM Certified DB2
Database Administrator
EDUCATION:
. Masters in IT management from Marist University
. Bachelor of Science from Osmania University, Hyderabad
. Certification as DB2 Professional
. Certification by Oracle (Oracle Certified Professional) for Database
Administration.
Contact this candidate