Anil Kalra [Send email to request phone number] 14-7693
[Send email using form at bottom]
Expertise:
Over 13 years of experience in software Design, development and implementation
as Database Architect/DBA in combination with ERP APPs using SAP system and
Siebel system. The key involvement in SAP Basis Administration and Oracle
Database administration for various fortune 500 organizations. Extensive
experience in managing all SAP Basis and Database activities for VLDB and HA
environment applications
Education:
Masters in Computer Application
Bachelors in Science (Physics)
Visa status: U.S. Citizen
Skills: Oracle (7.x.x, 8.0.x, 9i, 10g), Sybase (4.x)
Highly proficient in Oracle (7.x.x, 8.0.x, 8i, 9i, 10g) DBA responsibilities,
Installation of oracle (7.x.x, 8.x.x, 9i) on NT, 2000, Unix (HPUX, Solaris, DEC)
Oracle Parallel Server (OPS) (8.1.7.4), RAC (9i.10g), Oracle CRS
Oracle Replication manager
SAP BASIS (4.0B, 4.5, 4.6D, ECC 5.0, 6.0) including
Installation and upgrade of SAP system (4.0 B, 4.6D, 4.7C), SAP Netweaver 2004,
NetWeaver 7.0
SAPDBA (Dba utility), BRTools, Bw3.0,3.2, Bi 7.0, Xi 3.0
SAP Net weaver Components NW2004/2004S (Bw / Bi /Xi)
TMS (Transport management system),NW2004SR1,SR2
Hot packs and Kernel patches upgrades
Siebel (6.0 , 7.0)
GUI Tools: Embarcadero DBArtisan (5.4, 7.3), BMC Patrol 3.2, BMC OptiSystem
Solution for SAP, Precise InDepth For Oracle, OmniBack (2.5, 3.0, 3.5),
SqlWindows,
O/S: HP-UX 9.0, 1020, 11, Solaris (2.4, 2.5, 2.6, 2.8), Sco Unix
Unix SVR 4.2, Windows NT, Windows 2000
Job Experience:
Worked as Sap basis / oracle DBA
(Jul 2004 - Current)
§ Working at Abbott Laboratories (Chicago, IL) as Oracle DBA. Involved in
managing 80 SAP instances with multiple multi terabyte production SAP databases
and RAC Database instances under Unix Environment using Veritas (vcfs). Involved
in upgrading all oracle instance from 8i to – 9i to 10g oracle and applying
off-patches as well. Also involved in managing oracle 9i/10g databases for SAP
Core (4.6c) for entire SAP landscape (DEV,QA, Training, Staging, Eval,
Production). Involved in daily DBA and Basis activities including applying
databases and SAP kernel patches. Involved in upgrading all database instances
from 8.1.7.3/8.1.7.4 to 9i to 10g. Involved in fresh install of Databases (10g) /
SAP HRT system. Involved in using SAP tools (brtools) for daily database
activities. Work closely with ABAP developer for all SAP/database issues. Worked
extensively on SAP Basis for performance analysis and memory management,
database management and troubleshooting (problem reporting and resolution).
Involved in planning/implementing backup strategy for all database instances
using RMAN and media s/w Lagato and Netbackup. Involved in extensive multiple
Disaster Recovery off-site / on-site 3rd party datacenter for 2 terrabyte SAP
Database. Involved in all aspects of SAP Basis Administration including
installing SAP and oracle instances, implementing change management system (CTS)
and Transport management system (TMS), Background jobs, Workload Analysis, SAP
workplace monitoring using CCMS, System Monitoring, Performance Tuning, design
and implementing strategy for backup and recovery, Evaluating sap components, DB
tools. Performed DB refreshes and client copies /deletes in Sandbox, Development
and Training. Hands-on exp with SAP utilities like SAPDBA/BRToool for online and
offline reorgs of SAP objects
Worked as Sap basis / oracle DBA
(May 2002 – Jun 2004)
Worked at Takeda Pharmaceuticals (Chicago, IL) as Sr. Oracle DBA. Involved in
managing 14 Production database including SAP Application (4.6C,4.6D), oracle
clinical, and siebel (crm) database instances. Involved in installing and
implementing oracle clinical systems 4.0 and upgrade to 4.0.3, supporting CRM
siebel system (6.0, 7.0) during upgrade from 6.0 to 7.0 system and involved in
oracle upgrades (8i and 9i) for various applications. Involved in managing oracle
database instance including performance and monitoring , setting up alerts and
backup using rman and netbackup all across the SAP landscape. Involved in daily
SAP Basis activities like SAP system monitoring, Troubleshooting the Basis issues
using CCMS, Client and system copies, Weekly Transports using TMS, Periodical
Support packages implementations, Involved in capacity planning for various
applications. Involved in supporting Documentum based applications (docbases).
Involved in planning / implementing backup strategies. Involved in evaluating
various Database tools such as DBArtisan’s performance center Database Analyst,
BMC’s smartdba. Support application teams including knowledge transfer and
mentoring other dbas in the team.
Worked as Sap basis / oracle DBA
(March 2001 – May 2002)
Worked at McKesson Inc, (SanFrancisco, CA), ranks 35th in fortune 500, a
Pharmaceutical Distributor organization. Involved in managing Production Database
as Sr. SAP Basis Admin / Sr. Oracle DBA under SunOS using Solaris (2.6, 2.8)
running Oracle Parallel server (OPS) 8.0.6 to achieve High Availability. Involved
in managing 1.4 Terabyte Production database along with 2 QA and 2 Development
databases. Involved in managing all sort of typical database Administrator
responsibilities along with knowledge transfer. Involved in writing Alert watch
scripts for on-call operation Dept. Involved in resolving issues regarding big
table spaces as well as big objects fragmentations using TSReorg from CA.
Involved in as SAP Basis Admin as well which includes R/3 4.6D installation,
Transports, Performance issues of SAP and Database, supporting in-house
Development and QA teams, involved in evaluation of different third party SAP and
Oracle Database tools like BMC’s Opti System and Precise In-Depth for Oracle.
Involved in implementing different version Oracle databases (8.1.6, 8.1.7) for
Non-SAP Applications as well. Responsible for Database sizing and capacity
planning, involve in upgrading oracle (32 bit) on solaris 2.6 to 64 bit version
on solaris 2.8.
Worked as Lead Database Architect
AON (Feb 2000 - May 2002)
Worked as Lead Database Architect with AON (Insurance Brokerage Organization,
Chicago), Led a team of DBAs to manage distributed databases for different
insurance web applications that included NetID for maintaining NetID Product to
handle DNS servers, Cisco Security from Cisco, Eclipse to handle Filenet, Online
premium information using Oracle 8i under Solaris (2.5, 2.6) and Windows NT.
Involved in proposing Database infrastructure Solution, backup and recovery
strategies. Involved in setting up and implementing strategy for hot site
standby database, involved in data analysis and modeling for Bondlink using Erwin
3.5 at Logical as well as physical level, involved in Database Auditing for
security purposes. Involved in proposing strategies for hardware and software
upgrades with minimal down time for production and development systems. Led a
team of DBA’s , Involved in Distributing and monitoring various database tasks
among DBAs and getting their feedback /status and issues. Involved in Application
requirement analysis process and worked closely with application and functional
team leads to fulfill those requirements. Responsible for mentoring other DBAs,
Knowledge transfers to end-users by having regular communication. Underwent
Evaluation and Formal training of Oracle Parallel Server setup and
implementation. Evaluation of different options of Logical Backup using Export
and Import (cumulative as well as incremental) utilities in comparison with
regular backup to sync QA database and development database.
Worked as Sr. Oracle DBA/Developer/ Sap Basis Admin
SAP America (Sep 98 - Feb 2000)
Worked for Sap biggest clients such as Bank One (Ohio), WW Grainger (Chicago),
Andrew Corporation (Chicago) Responsibilities included Database modeling and
maintenance, Implementation of SAP Loan and Fund modules as Database architect /
Sap Basis Admin using Sap (4.0B) in combination with Oracle 8i with sizes varies
from 50GB to 700G on different flavors of UNIX (HPUX 10.20, Solaris 2.4, Windows
NT) and BMC Patrol. Responsible for mentoring other DBAs, Knowledge transfers to
end-users by having regular communication. Worked with users to gather
requirements and define scope for various modules, with Data modelers and
designers to define the Database schema and with DBAs to convert logical schema
to physical schema. Database sizing projections, strictly adhered to OFA
guidelines. Involved in defining database architecture for distributing
application and database replication. Underwent OLTP database design, sizing and
setting up of a highly available Oracle 8i database server for web sites. Also
involved in development activities using store procedures and database triggers
using PL/Sql for data validations and Business Logic, Setting up and implementing
Backup and recovery plan, Dealt with space utilization issues such as table space
management, reorganization of database object to defragmentation for better
performance. Involved monitoring Database activities batch processes etc using
SAP GUI utilities.
Sr. Oracle Database Administrator
Harris Bank , Jan 98 - Sep 98
Worked as Sr. Oracle DBA in an internet infrastructure Group in Harris Bank for
its financial web applications. Job responsibilities included database modeling
and managing 12 online oracle databases with sizes varies from 50GB to 400G for
their different web applications such as MasterCard, Fund finder, Online Mortgage
Application, Merchandise, Investor line and others. using Oracle 7.3.x, 8.0.x
under Sun Solaris (2.4, 2.5). Underwent data analysis and OLTP logical and
physical design, responsible for writing PL/SQL code for store procedures and
database triggers. Responsible for setting up OLTP servers and keeping various
databases in sync using database refresh scripts between test and production
environment for stress testing purposes. Also responsible for backup, recovery
and automating DBA activities and scheduling backups scripts for Hot backup and
cold backups. Support other DBAs in performance Monitoring and tuning; During
initial testing and dry run of certain I/O incentive modules that load/updates
several database objects and overcome different oracle table space, segments,
extents issues. Monitor the performance of the instance and, in association with
oracle Canada personnel.
Database Administrator
Phoenix Intl Jun 96- Jan 98
The Phoenix Banking system is a complete, integrated Client server based Banking
environment. The system process items from front-end capture units such as POD
and platform systems as well as clearing documents received online from Federal
Reserves , NACHA, ATM and EDI compliant networks. Led a team of DBAs, involved in
DBA Activities, User management and Security. In consultation with management and
development teams, devise security guidelines for accessing database and its
respective business objects and implements them. Created custom Roles for
application for ease of user administration Used Export and Import utilities as
well as cold backups and educate the customer on the benefits of using Hot
backups compared to logical (export/import) backups. Also implemented Hot and
cold backup automated shell scripts, maintaining a log of
errors/warnings/messages for these scripts. Maintenance of hot site for standby
database. Software installation and support, Setting up TCP/IP and SqlNet V2 for
database remote communication and connections, setting up various Unix files to
update necessary information such as Host, and services files, Listener.ora ,
TnsNames.ora and SqlNet.ora files. Set up Sql*Net 2.0 using listener.ora and
tnsnames.ora files. Involved in writing store procedures and database triggers
using PL/Sql , Installation of oracle 7.3.3 and applying appropriate patches to
overcome oracle known bugs.
Database Administrator
Birla Horizons Intl Dec 92 - Jun 96
Worked as Oracle DBA as well as Oracle developer in maintaining different
databases for various applications for Birla Horizons. Involved in maintaining
22 databases and development of various client server based applications and
data ware housing over a period of 4 years. Involved in data modeling of
inventory database including creation of entity relationship model and
normalization of database objects. The inter connection of these system using
TCP/IP and SqlNet V1 and V2 also facilitated an effective MIS. Involved in
identifying table spaces, data files, sizing and splitting of database files to
make use of available disk space in best possible way. Involved in all sort of
dba activities as well as writing code using PL/Sql, Pro*C, C++ to achieve
business logic. Also involved in creating SqlForms windows using SqlForms 3.0 and
reports work bench. Involved in writing code for Store procedures and triggers.
Involved in writing sql scripts to create the physical database, database
schemas, rules. Involved in applying oracle patches for oracle bugs. Involved in
monitoring performance and database tuning on user as well as system level.
Involved in setting sqlnet setup for clients and database communications.
Involved in routine jobs of handling user requests regarding security issues,
performance and tuning issues, maintaining user sessions tracing long running
sqls and auditing users workloads.
|
