Siva Kumar Arza
Summary:
· Had a Masters Degree in Electronics & Control Engineering.
· Having more than Nineteen years of professional experience in IT industry. 12 years of experience in Oracle Database administration and Four Years of SQL Server administration running on Sun Enterprise servers and Sun Sparc servers (Unix),HP Unix, IBM AIX Servers, Windows NT,2000 with client/server applications. This includes install, manage, administer, maintain and tune Oracle 11g RAC, 10G RAC, 10g, 9i, 8i, 8.0.6, 7.3 RDBMS, and NETEZZA.
· Extensive experience in Software installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Clustering, Tuning of Oracle 11g,10g RAC/10g/9i/ 8i /8/7.x on Unix, Linux and Windows NT/2000/2003 platforms.
· Experience in analysis, design, development, testing and implementation of applications. Experience in handling production and development boxes under client/server environments on flavors of UNIX/NT operating systems throughout the life cycle of the application.
· Served Reputed companies: Amdocs, Intralot, AT&T, Bellsouth, Accenture, Compucredit Corp, Us web.
· Had excellent communication skills and a versatile team player with leadership qualities, with emphases on building strong client relationships, building result-oriented teams, aptitude to learn, integrity and ability to put in sustained quality effort consistently.
IT Skills:
RDBMS : ORACLE 7.x / 8.0.5, 8i, 9i, 10g, RAC, 11g, Oracle11i (CRM), R12, SQL Server 2000, 2005, 2008; Timesten, DB2 MYSQL, NETEZZA SERVERS
Languages : SQL, PL / SQL, PERL, AWK
Software Tools : SQL* Plus, SQL* Loader, Import / Export, data pump, data guard, OEM, Golden Gate, Toad, RMAN, SQLBACKTRACK. Tkprof, Discoverer 9ias, Mercator, Remedy, Dbartisan, Sqlnavigator, Erwin, Fast Copy.
Operating Systems : Sun Solaris 2.6, 2.7, 2.8, IBM AIX 5.2, HP UX11.0, Linux5.2 (Red Hat), Sco UNIX MS-DOS, Windows NT, 2000, 2003.
Protocol : Net 8, SQL* Net v2, TCP/IP, FTP, TELNET
· Installing Oracle7.x, 8i, 9.2.0, and 10g RAC, 11g on UNIX as well as Win NT, 2000 Operating systems for necessary databases, their storage space requirements and placing them for optimum I/O performance.
· Creating and Managing Oracle servers of 24TB sizes and Standby Servers
· Configured and Maintain oracle instances on veritas cluster and RAC envs.
· Extensively Used ASM to manage storage of the 10g databases.
· Upgrading the databases from 8i to 9i, 9i 10g and 11g.
· Daily monitoring and interpreting of Alert Log files and Trace files.
· Automated the monitoring scripts through cron and OEM GRID.
· Extensively used Sqlbacktrack, RMAN tools to backup and restoration
· Resource Management (create and manage indexes, allocate and manage physical storage structures like data files, redo logs, control files. Allocate and manage logical storage structures like tablespaces, schemas, and extents).
· Database Creation for development, testing and training Environments.
· Software Maintenance and operation (configure and manage SQL*Net, configure the oracle instance using the initialization parameters).
· Creating users, allocating tablespaces to users, managing privileges with role based access. Familiarity with profiles.
· Ensuring data, database security and integrity with auditing features
· Installed and supported SQL server databases 2000 and 2005 of sizes 750GB.
· Maintained and supported databases on UNIX file systems and raw devices.
· Performance Tuning and Troubleshooting (diagnose and resolve locking conflicts, using data dictionary tables and views, monitor the instance, collect and analyze relevant database performance information, identify and implement appropriate solutions for database performance problems).
· Exporting data from various RDBMS into flat files and Loading into Oracle database
· SQL*Loader, data transfer using EXPORT/IMPORT and data pump.
· Used Erwin, Power Designer data modeling tools extensively.
· Fixing data related errors and handling data loading issues.
· Installed and configured oracle Streams and data guard.
· Implementing and testing DR Strategies
· Backup and Recovery (develop backup and recovery strategies, implementation of backup procedures and recovery of database).
Carrier Achievements:
Amdocs, Champaign, IL Mar 2010 to Current
Prod DBA.
Working with Amdocs Prod DBA Team and been supporting the clients Sprint, Vonage, Clearwire, Mobilicity. Supporting more than 300 databases in very complex, critical and high available environments across all the clients and the dbs ranging sizes from 2TB to 24 TB. Supporting Ensamble, Enabler (3G), pre-paid applications of sprint. Providing production support to applications with Rdbms: Oracle databases 10g, 11g, TIMESTEN, SQL Server and DB2 and replication tools: Golden gate. Handling backup failures, standby database sync issues, replication, lag issues in Golden Gate envs, monitoring alerts for extents, space and identifying the bottle necks and resolving time consuming queries, using awr reports. Interacted with offshore DBA teams and client dba teams in addressing, resolving production issues to avoid SLAs.
Intralot, Atlanta, GA Nov 2009 to Feb 2010
DBA.
Installed and created 11g databases in AIX Unix servers on IBM clusters.
Installed Redhat Linux 5 on multiple servers.
Performed troubleshooting and fixed system related issues in Linux servers and network related issues.
Installed and configured a two node 10g RAC cluster in Redhat Linux Environments..
Configured +ASM instances on both the nodes.
Optimized Queries to fix performance related issues.
Administered the State Lottery databases of: Ohio, South Carolina and Montana dbs.
Implemented Steams to refresh data across multiple databases of state lottery databases.
Responsible of managing a team of 3 oracle dbas.
AT&T, Atlanta, GA Jun 2009 to Jul 2009
Sr. Oracle DBA/SQL DBA/Unix Admin
Working in couple of projects: Enterprise Mobile Device Management for the corporate companies, where corps can manage their devices, Enterprise Configuration Server, which manages and creates custom AT&T communication Mgr Client Software for data connection to AT&T’s 3G Wireless Network.
· Installed Oracle 9i, 10g oracle binaries.
· Built 4 oracle 10g instances each of size 500GB.
· Built the required file systems from shared disks which are connected SAN for the VERITAS cluster.
· Installed VERITAS volume manager, storage foundation suite and built a two node VCS cluster.
· Created and configured three 10g oracle instances and configured them into two node cluster.
· Configured Oracle rman backups.
· Planned and worked towards Migration of the application with Data Architects and migrated two instances from 9i to 10g, instances running on E10k machines.
· Installed and Configured Oracle 10g IAS server.
· Performed administration of Oracle Application Server.
· Starting and stopping application services as needed.
· Changed the forms mode from servelet to socket mode(OC4J)
· Supported stand alone and clustered (active-active, active-passive) SQL SERVER dbs.
Environment: Oracle 9.2.0, 10g, 10gias and VERITAS clustered databases, Sun Solaris 2.9 Oracle Enterprise Sun Enterprise Servers 4500, E10k
Compucredit, Atlanta, GA Apr 2007 to Apr 09
Sr. Oracle/SQL DBA/Netezza DBA
Suggested and Implemented database consolidation. Performed Database Administration of oracle instances running on E10k machines and maintained Netezza Server databases in a data ware housing environment. Maintained RAC clustered databases running on 10g oracle servers of sizes 3.5TB. Involved in monitoring the health of the database, applications and apply necessary action to maintain the 50 Oracle databases, 35 Sqlserver instances and application stable, running 24x7, 365 days. Supported IVR Applications, collections databases and risk management databases. Involved in implementation of new payment research project and coordinated and managed offshore Oracle & SQL DBA teams. Supported application users, developers and testers, with the following activities:
.
· Configured and monitored all the databases through OEM GRID.
· Worked with Data Architect teams on database consolidation project to stream line databases
· Used data pumps to load data migrations.
· Installation of the oracle software, migration and patch application for bug fixes. Created the Development, testing, UAT, training and Production RAC databases.
· Implemented cluster ready service and two-node RAC.
· Implemented 10g Automatic Storage Management (ASM).
· Managed disk groups using ASM for multiple databases using one ASM instance.
· Migrated a regular database Non-Asm instance to 10g Asm.
· Migrated 10g data bases to 11g in RAC Env.
· Supported databases of sizes more than 4 terra bytes.
· Implemented and configured Oracle Streams in 10g
· Supported systems for high Availability/replication envs using GOLDEN GATE.
· Monitoring and optimizing the performance of Databases and assisting developers in tuning the SQL and Analyzed performance bottlenecks and provided appropriate solutions using AWR and ADDM.
· Created, migrated and restored databases, configured for distributed OLTP and DSS databases.
· Install and Setup the RMAN backup for ORACLE Database and database maintenance plan for backup SQL Server database backups.
· Implemented Physical Hot stand by database as part of implementing DR strategies as per Business Requirements
· Installed, configured and administered Oracle 10g IAS server..
· Maintained database using Oracle Enterprise Manger, Toad, Sqlnavigator and DB Artisan.
· Responsible for Capacity, Scalability Planning and Growth analysis and Co-ordination with Infrastructure team for implementing business solutions.
· Restored the data and objects using DR Environment in the event of Human mistakes.
· Worked with Oracle Corp in fixing couple of data corruption issues.
· Created multiple databases in Netezza server of size 3TB and performed backups.
· Created users, groups in Netezza environment and assigned privs.
· Supported ETL/Inforamitca developers, resolved data mapping issues.
· Involved in the technical analysis of data profiling, mappings, formats, data types and development of data marts.
· Used workflow Manager for Creating, Validating, Testing and running the sequential and concurrent worklets, workflows and sessions.
· Created ETL scripts to load data into Oracle and SQL server.
· Performed loading of the data into Netezza Data Warehouse environment using nzload.
· Identifying the hung user process and resolve the issues.
· Worked with SAS developers in loading the data.
· Extensively used ERWIN tool for data modeling and for schema building scripts etc
· Identified data loading errors and fixed as and when necessary.
· Resolved the load issues into data warehouse netezza environment….using NZLOAD.
· Reclaimed the used space using: nzreclaim and scheduled through cron.
· Performed backups, restores on netezza servers in Data Warehouse Env.
· Administered the Netezza servers on Linux operating systems.
· Extensively involved in troubleshooting of Netezza and Oracle databases.
· Creating the application users with role based access, setting up of system profile options, responsibilities etc
· Implemented session level triggers to restrict the unauthorized access.
· Enforced the complex passwords and expiry of passwords for every 60 days for the users through profiles.
· Created application equivalent accounts to protect schema accounts.
· Applied oracle recommended security patches to protect the dbs from vulnerabilities.
· Supporting of Sarbanes–Oxley compliance databases and PCI standards by implementing User and Security Management in 24X7 environments.
· Installed and configured server software and hardware for SQL Server development and production environments 750GB.
· Create and manage SQL SERVER database maintenance plans and design and implement backup and disaster recovery plans.
· Configured and installed clustered active-active 2005 SQL SERVER dbs.
· Upgraded number of production servers from SQL Server 2005 to SQL Server 2008.
· Configured SQL Server Mirroring for High Availability solution.
· Configured replication technologies: Transactional Replication and Peer 2 Peer replication.
Environment: Oracle 9.2.0, 10g RAC, 11g RAC systems, and VERITAS clustered databases, Sun Solaris 2.8, 2.9 Oracle Enterprise Sun Enterprise Servers 4500, E10k, IBM ,Windows XP,SQL Server 2008, and NETEZZA Servers, Informatica 7.1 Business Objects, Erwin.
AT&T, GA Mar 2005 to Apr 2007
Sr. Oracle/SQL DBA
Created and Maintained databases and performed administration of more than 100 instances running E10K, E6500,E4500 and E450 machines in SMAS.ABIS.MARVES,CORP,BTG,ORACLE FIN(payroll) projects of Bellsouth applications running on 9.2.0 oracle servers. Involved in Monitoring of the health of the database, applications and apply necessary action to maintain the database and application stable, running 24x7. Managed the 10g instance and its storages through ASM. Built and supported databases with RAW file systems. Participated in installation and configured the VERITAS cluster for 12 instances and managing all these clustered databases. Performed cloning of the database and application as necessary. Performing disaster recovery when situation arises. Restored databases from the previous backups. Supported application users, developers and testers. Coordinated with Offshore Oracle & SQL server teams and supported local teams..
My Role:
· Configured, automated and monitored the 42 databases, checking alert log files, Contacting Oracle for issues and errors through metalink.
· Configured the OEM Grid Control to monitor databases.
· Configured Instances to send alert emails through OEM Grid.
· Ran awr and addm reports through OEM Grid.
· Created and Administered databases with RAW file systems and monitored BCVs.
· Installed and configured the veritas cluster databases and maintaing 15 clustered databases. Switching the dbs onto failover nodes and failing back as necessary.
· Upgraded 15 instances from Oracle 8.1.7.4 to 9.2.0 in VERITAS clustered environments.
· Restored and recovered the databases 500GB databases from backups.
· Worked extensively on tuning….reduced the bactch jobs time from 12 hours to two hours in HR module of People Soft Project.
· Hands on experience in performance tuning: Monitored CPU utilization, identifying high resource intensive processes and fixing the bottlenecks.
· Implemented and enabled audit logging of users.
· Configured and scheduled the jobs through OEM Grid control.
· Advised and worked in removing the operating system access to end users.
· Installed and configured data guard solution to production databases.
· Enforced the auditing of specific user actions.
· Implemented and enable secure roles, privs and implemented sox regulations.
· Applied oracle recommended security patches to protect the dbs from hackers & buffer overflow.
· Password complexity and expiry is enforced to all the database users.
· Implemented and configured Oracle 9ias application server.
· Install and Setup the SQL Backtrack for oracle database backup and extensively used SQLbacktrack for db backups, db cloning etc.
· Creating the application users, setting up of system profile options, responsibilities etc
· Migration of People Soft running on Oracle databases in Solaris Environment..
· Extensively involved in troubleshooting of application and database. Used DB Artisan, Toad, SqlNavigator, ERWIN, Rational Rose tools extensively.
· Performed cloning of the database independently.
· Administered over 50 SQL Server instances of sizes 750GB sizes.
· Ensure that adequate backup procedures exist for all critical SQL Server instances.
· Apply latest SQL Server service packs and hot-fixes to ensure maximum security.
· Designed and configured a SQL Server 2005 cluster system to be used by an internal trouble ticket tracking application.
· Upgraded number of production servers from SQL Server 2000 to SQL Server 2005.
· Configured and implemented SQL Server Log Shipping.
· Created and maintained daily backup and restore jobs. Automated existing tasks as well as created new jobs, DTS packages.
· Supported stand alone and clustered active-passive SQL SERVER dbs.
Environment: Oracle 8.1.7.4,9.2.0,10g RAC Sun Solaris 2.8,2.9 Oracle Enterprise Manager 2.1,Server Manager, Instance Monitor, Sun Enterprise Servers 4500, E10k, IBM AIX, HP UNIX Servers, Windows, SQL Server 2000,2005, People Soft, Business Objects, Micro Stratagy, Erwin, Sqlbacktrack, RMAN
BELLSOUTH, Birmingham, GA Aug 2001 to Mar 2005
Sr. Database Administrator
Created and maintained databases throughout the life cycle and performed administration of 40 instances running E4500 and E450 machines in EDI project of Bellsouth. Monitored EDI-MERCATOR applications running on 8.1.6, 8.1.7, 9.2.0 oracle servers. Involved in monitoring the health of the database, applications and apply necessary action to maintain the database and application stable, running 24x7. Created and managing the Standby Servers for Oracle instances on different servers. Performed cloning of the database and application as well. Performed refresh of the training instance, bouncing the database, applications. Monitoring and administering launcher and ldrmon processes etc. Supported application users, developers and testers. Supporting five teams performing the following activities:
· Configured, automated and Monitored 14 databases, checking alert log files, Contacting Oracle for issues and errors through metal ink.
· Created two Standby Servers and managed them.
· Implemented data guard solution for the critical production databases.
· Refreshing two standby servers to see both Primary instance and standby are sync weekly basis.
· Ran specific scripts to check the process and database node and application nodes.
· Finding the processes, which are taking excessive CPU resources and taking necessary action.
· Performed restoration from backup whenever it is required.
· Bouncing the database and application including stopping the services and starting the services.
· Creating the application users, setting up of system profile options, responsibilities etc
· Extensively involved in troubleshooting of application and database. Used DB Artisan, Toad, SqlNavigator, Erwin, Rational Rose tools extensively.
· Performed cloning of the database independently.
· Supported Peoplesoft Payroll applications on Oracle Database in Unix Env.
· Fixed SQR running issues and worked with developers
· Extensively supported the application users, developers in association with help desk.
· Documented the activities performed.
· Coordinated with different teams involved in the project.
Environment: Oracle 8.0.5, 8.1.6, 8.1.7, 9.2.0 Sun Solaris 2.6, Windows NT, Oracle Enterprise Manager 2.1, Server Manager, Instance Monitor, PeopleSoft, ERWIN, cc Harvest, Sun Enterprise Servers 4500, E10k
Bellsouth, Atlanta, GA Oct 2000 to July 2001
Apps DBA
Performed Database Administration of two instances running E10k machine in ADSLCRM project of Bellsouth. Monitored two Oracle 11i CRM applications running on 8.1.6 oracle servers. Involved in monitoring the health of the database, applications and apply necessary action to maintain the database and application stable, running 24x7. Performed cloning of the database and application as well. Performed refresh of the training instance, bouncing the database, applications. Monitoring and administering xdp processes, concurrent managers, weblisteners, forms server, report servers and apache servers etc. Supported application users, developers and testers, with the following activities:
· Monitoring the two Apps CRM databases of 4TB size, checking alert log files.
· Ran specific scripts to check the process and database node and application nodes.
· Finding the processes, which are taking excessive CPU resources and taking necessary action.
· Performed restoration from backup whenever it is required.
· Installed and configured 9ias application server.
· Bouncing the database and application including stopping the services and starting the services.
· Creating the application users, setting up of system profile options, responsibilities etc
· Extensively involved in troubleshooting of application and database
· Performed cloning of the database and application independently.
· Extensively supported the application users, developers in association with help desk.
· Coordinated with different teams involved in the project.
Environment: Oracle 8.1.6, 8.1.7,9i Sun Solaris 2.7, Windows NT, Oracle Enterprise Manager 2.1,Server Manager, Instance Monitor, Sun Enterprise Servers 4500, E450
Vox, UK Aug 00to Sep 00
Oracle DBA Consultant
The client voxstar is an IT division of vox, a renowned media company. We have launched one portal. I have installed oracle version 8.1.6. I have created the database and supported, maintened the databases. Used different tools to monitor the database activity like instance monitor, Toad and resolved the user problems in the development environment.
Environment : Oracle 8.1.6, Sun Solaris 2.7, Oracle Enterprise Manager 2.1,
Server Manager, SQL* Plus, Instance Monitor, TOAD, Windows 98
US Web, SAO PAULO Dec 99 to July 00
Oracle DBA Consultant
The client Idealyze is an IT division of Editora Abril, a leading publishing company in Brazil. We have launched two portals. I have installed different oracle versions 8.0.5, 8.1.5, and 8.1.6. I have involved in the database creation and maintenance of three databases. Used different tools to monitor the database activity like instance monitor and resolved the user problems in the development environment,
Staging (preproduction) and production environment.
Environment : Oracle 8.0.5, 8.1.5, 8.1.6, Sun Solaris 2.6, Oracle Enterprise Manager
Server Manager, SQL* Plus, DB2, webdb 2.2, TOAD, Windows 98
AdvanSoft, India Aug ‘98 to Dec ‘99
Software Engineer
The company has strategic alliance with hospitals, doctors, and health care systems for group purchasing of supplies and services. The application is being used to efficiently provide product information, manage sales leads and to reduce the sales and service cycle time
Environment : Oracle 7.3/ 8.0.1, Sun Solaris 2.5, Windows 95, SQL*DBA, SQL* Plus, SQL* Loader.
GSG, India Jan ’96 to Aug ‘98
Configuring the Oracle instance using the Initialisation parameters. Regularly monitoring the table spaces for space allocation.Performed backup and restoration of database with backup files. Performed incremental, cumulative and complete back up of specific objects and users of the database using export utilities.
Environment : Oracle 7.3, Sun Solaris 2.5, Windows 95, PL/SQL, SQL* Plus.
Dyna, sec’bad, India Jan ‘89 to Jun ’94
Software Engineer
Managed Production an electronic Industry which manufactures entertainment electronics, consumer electronic goods and batch weighing systems. And also Responsible maintaining Software division of the company. Responsibilities like Oracle 7.x database administration. Which includes, Installation of software, Creation of Databases (Development and Production). Configuration & Testing of Sun Sparc/Ultra Workstations Responsible for the overview of the data storage,
Environment: Oracle 7.3, SQL*PLUS, PL/SQL, Sun Solaris, NT
RGW, Hyderabad July ’85 to July ‘89
The system maintains information from BOM's (Bill Of Materials) & sales order acceptance in Oracle database. Work Orders are assigned to individual items, which keep a track of the status, till the order is executed. This helps in formulating different reports like Design Statistics, Pending Orders and Production Planning, work in progress etc. With the help of the available data from the design master, automatic BOM's are generated. Based on the production plan for the month and the BOM's available the material Requirement plans are generated which in turn are used to issue the purchase requisitions.
Environment: Oracle 7.x, SQL*PLUS, VB