Sql Server Oracle
Resume:
[pic]
Vijay Kadimela
[pic]
SUMMARY:
. More than 10 years of strong experience in Oracle 9i, 10g and one
year in Oracle11gR2, 10g Certified Oracle DBA.
. Experience in administration, design and development of Oracle
Databases and applications.
. Experience in administrating both OLAP and OLTP databases.
. Hands on experience with Oracle 8i, Oracle 9i, Oracle 10g RAC under
UNIX (SUN, HP-UX) and Oracle 10g/11g on Sun Solaris, IBM AIX and
Red Hat Linux AS 4.0.
. Experience with the 10g/11g Real Application Clusters (RAC)
implementation and maintenance.
. Expertise in Migration/Upgrade from 8i/9i to 10g, from 10g to 11g
and configuration.
. Extensive experience in Tuning Oracle Databases, including the
installation and use of Statspack, ADDM, AWR, LTOM, identifying and
eliminating disk "hot spots", pinning packages in memory.
. Develop UNIX Shell Scripts, Oracle Load Scripts and Oracle Database
Triggers and Stored Procedures using PL/SQL.
. Proficient with TOAD, OEM, 10g Grid control, RMAN, SQL *Loader,
LogMiner, Data Guard & User Management.
. Configured RAC Standby db and standby database for multi-node using
Data Guard.
. Experience in ASM on multi node 10g RAC environment.
. Used O/S utility (Cron, at) to schedule logical, Cold and Hot
Backup and Exposure to take Backup-using BCV (Split Mirror).
. Used SQL*Trace, Explain Plan for SQL Tuning.
. Good Expertise in MS-SQL Server 7.0/2000/2005 Administration.
. Experience in SQL Server Installation, Configuration, Upgrade and
Maintenance Patch management using SQL Server Tools like Database
Maintenance Plan Wizard, DTS Import/Export Wizard, Index Tuning
Wizard, SQL Server Enterprise Manager, SQL Profiler,SQL Query
Analyzer, Database Engine Tuning Advisor, SQL server Management
Studio and SQL server Surface Area Configuration.
. Up gradation/Migration of MS SQL Server 2000 to MS SQL Server 2005
using Upgrade Adviser and suitable methods.
TECHNICAL SKILLS:
Database Oracle (8.0, 8i, 9i), Oracle Database 10g/11gR2, MS SQL
Server2000/2005
O/S Sun Solaris, Compaq Tru64 UNIX, Linux AS, HP-UNIX, IBM AI,
Exposure Windows NT/2003/XP
Languages/ SQL, PL/SQL, Shell Scripting, Erwin 5.1, Erwin 6.0, Veritas
Tools cluster manager, Veritas Net Backup, Netapp, dbartisan,
Golden Gate
Business Advertising, Manufacturing, Payroll, Inventory, Insurance,
Systems and Sales
Oracle Stats Pack, Oracle Streams, AWR, ADDM, LTOM,
Tools TLBSTASTS/UTLESTATS Data Guard, ASM, OEM Grid Control,
Import/Export, SQL*Loader, Log Miner, Data Pump
Certifications:
. Oracle10g Database Administrator Certified Professional.
. Oracle9i Database Administrator Certified Professional.
ACADEMIC Qualification:
Bachelor of Engineering : Computer Science Engineering.
University : Jawaharlal Technological
University.
PROFESSIONAL EXPERIENCE:
Sr. Oracle DBA (Contract)
Jan 2010 - Till Date
247realmedia, NYC, NY
Responsibilities:
. Installation and maintenance of 10gR2/11gR2 multi-node RAC
Environment.
. Migrated very large terabyte standalone production databases to RAC
environment with minimal downtime by
creating RAC standby database.
. Created and maintained standby database for the RAC production
database.
. Major involvement in the automation of database maintenance by
scripting and scheduling in crontab.
. Partitioned very large tables for monthly and weekly to avoid
performance hits.
. Provided a highly proactive role and work out solutions before it
become a bottleneck for the systems using tools like AWR reports, ADDM
and SQL Tuning Advisor.
. Created and handled Materialized Views and MVlogs for the scheduled
refresh jobs.
. Involved in tuning RMAN backups and Gather stats as they two were the
major contenders of CPU and memory usage being multi terabyte
databases.
. Debugging Rman Errors, Alert log errors, block corruption errors.
. Upgraded standalone and RAC production databases from 10.2.0.3 to
10.2.0.4 using rolling forward strategy.
. Diagnosing and troubleshooting CRS issues/errors by considering CRS,
CSS, EVM, SRVM( srvctl), OCR
( ocrdump, ocrconfig, ocrcheck ) logs and Oracle Clusterware alerts.
. Worked on Grid Control, EM, Data Guard, Upgraded systems to Oracle10g
and gave presentations to the DBA group on the RAC essentials and
internals.
. Cloned multi terabyte production databases to QA/staging using RMAN
duplication on ASM/RAC/OMF.
Sr. Oracle DBA (Contract)
Jun 2008 - Dec 2009
NYCHHC (New York City Health and Hospitals Corp)
Responsibilities:
. Installation and maintenance of Oracle 11.x, 10.x, 9.2, managing
databases in OLAP and ETL environment.
. Implementation and maintenance of 4 node 11.1.0.6 RAC Cluster
for the cognos/datastage reporting
environment.
. Involved in the analysis of Physical Data model for ETL mapping
and processed flow diagrams to develop
Datamart design.
. Designing the Star Schema and Snow flake schema for faster
effective querying and business analyze
requirement.
. Performing the oracle partitioning for the highly volume tables
(Range partitions, Hash Partitions).
. Creating the Bit Map Indexes for the fast accessing of OLAP
queries.
. Monitoring and optimizing system performance using index tuning,
disk optimization, and other methods.
. Providing backup which includes Import/Export using Data pump
and restore functions on requirement.
Automated RMAN hot, cold & export backups, and performed
recovery from backups.
. Migrated Oracle Databases from 10.2.0.3 to 11.1.0.7 for both
production and development instances.
. Managing patch requests and code migration from one Oracle
instance to another.
. Implemented Data Guard for configuring standby databases for
high availability and data protection. Viewing, monitoring and
administrating primary and standby databases using OEM.
. Providing schema creation for new development activities.
. Performed Replication using materialized views with a Complete
refresh/Fast refresh.
. Development of policy and procedures as they relate to database
maintenance, security and archiving.
. Creating, granting and monitoring user access rights and privileges
through roles and profiles.
. Providing instance level performance monitoring and tuning for Event
Waits, Sessions, Physical and Logical IO and Memory Usage with the
help of AWR and ADDM Reports.
. Automatic Shared Memory Management (ASMM) for Performance
diagnosis/tuning and Automatic Segment Space Management (ASSM).
. Supported development effort by providing SQL statement tuning and
optimizing ETL procedures and removing load and query performance
bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and
Oracle Enterprise Manager.
. Uploading data files into the databases using SQLLDR and also through
EXTERNAL tables.
. Troubleshoot issues related to Oracle Discoverer application and also
help developers use the BI Discoverer more efficiently.
. Monitor the loading of the daily files and writing scripts to handle
the monitoring the same.
. Installation and Administration of MS SQL Server 2000/2005.
. Experience with the physical database administration for SQL Server
databases including backup/restore procedures, reorgs, space
utilization, performance monitoring and tuning, problem determination
and resolution.
. Working as a member of production DBA team in perfect coordination
with seniors and team members.
. Installation, Maintenance (Adding and deleting of Oracle Instances)
and Monitoring Foglite alerts and
solving them.
Environment: Oracle Database 10.2.0.3, Oracle Database 11.1.0.7, IBM AIX
5, OEM, AWR, ADDM, SQLLDR, TOAD, Foglite( Monitoring Tool ).
Oracle DBA (Contract)
Jan 2008 - Jun 2008
Humana, Louisville, KY
Responsibilities:
. Oracle 10gR2, 9i installation on Sun Solaris to establish
environments for Development, Functional & UAT Testing and
production environment.
. Involved in Oracle 10g RAC setup on Sun Solaris environment and
Migrated Single Instance to Multi Instance.
. Adding and deleting nodes from cluster to carry out MAA (Maximum
Availability Architecture) scenarios.
. Implementation of ASM on a 2 node 10g RAC setup.
. Administering RAC databases with Server control utility (SRVCTL), SQL*
Plus & OEM. Monitoring instances on different nodes. Configuring
client/server side connect-time load balancing.
. Managed redo log groups, undo tablespaces, spfile, OCR and Voting
Disk, worked in a RAC environment.
. Setup backup and recovery strategies using flashback feature and
RMAN/UNIX shell scripts.
. Environments refresh (cloning) from production requirements as per
development team's requirements.
. Monitoring alert log files, System resource management included
bottleneck detection, contention tuning on SGA, CPU, Memory and I/O,
Queue locking issues, etc. Monitoring Oracle Database 10g using OEM
tool (ADDM, AWR, and Stats pack). SQL Tuning using Explain Plan,
session tracing and tkprof.
. Optimized and tuned database by planning storage requirements,
building indexes and altering storage clauses for tables and
indexes. Storage Management included fragmentation detection,
tablespace growth ratio, etc.
. Microsoft SQL Server 2000 migration to Oracle 10.2.0.2 using OMWB
utility for CCM application.
. Shell Scripting to automate some DB scheduled tasks.
. Created and deployed standard operational procedures of Data Guard
switchover/failover and disaster recovery. Performed Data Guard for
database disaster recovery. Setup and configured standby database.
. Creation of different Database objects (Partition Tables, Materialized
View, Refreshing materialized views, Index Rebuilding etc.)
. Experience with the Oracle Streams in propagation and management of
data, transactions and events in a data stream within a database or
from one database to another.
. Creating, granting and monitoring user access rights and privileges
through roles and profiles.
. Provided suggestions to system administrator regarding disk
configuration, RAID level according to database sizing and capacity
planning.
. Expertise in handling huge data warehouse with a good insight in
various oracle internal setups.
Environment: Oracle Database 10.2.0.2, Oracle 10g RAC, SQL Server 2000,
Sun Solaris 9, Linux AS 4.0. OEM, AWR, ADDM, LTOM (Oracle Lite Onboard
Monitor), OMWB (Oracle Migration workbench), TOAD.
Oracle DBA (Contract)
May 2007 - Dec 2007
WPSC (Wheeling Pitt Steel Corp), Wheeling, WV.
Responsibilities:
. Installation/maintenance of Oracle 10.1.0.2, 9.2.0.5 using GRID
features on HP-UX 9 and Windows platforms.
. Provided instance level performance monitoring and tuning for Event
Waits, Sessions, Physical and Logical IO and Memory Usage.
. Made performance improvements to the database by building Partitioned
tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
. Supported development effort by providing SQL statement tuning and
optimizing ETL procedures and removing load and query performance
bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and
Oracle Enterprise Manager.
. Performance tuning of Queries by maintaining Aggregates, Compression,
partition, indexing and use of Hints, Stored outlines, Statistics for
the same.
. Created Users, Groups, Roles, Profiles and assigned users to groups
and granted privileges and permissions to appropriate groups.
. Estimate the size of the database and its objects (in large database
of 1 to 2 Terabyte).
. Devised & Implemented backup strategies using hot, cold, and exports
based on the business requirements and Implemented Backup-using RMAN
(Recovery Manager) as a media management layer.
. Used SQL*Loader for loading legacy data.
. Cloned schemas, objects and data on new server using exports and
imports 10g using Oracle data pumps.
. Trouble shooting of various database performances by proper
diagnosis at all levels like SQL, PL/SQL, database design, database
tables, indexes, Instance, memory, operating system and java calls.
. Developed UNIX shell scripts to perform the above tasks efficiently.
. Worked as a member of production DBA team in perfect coordination with
seniors and team members.
Environment: Oracle9.2.0.6, Oracle Database 10.2.0.1, HP-9000, Erwin 5.1,
TOAD, OEM.
Oracle DBA (Contract)
Mar 2005 - Apr 2007
ADP (Automatic Data Processing), Ann Arbor, MI.
Responsibilities:
. Provided 24x7 support on a rotation basis within a team.
. Migration/Upgrade from 8i/9i to 10g.
. Cloned and refreshed production database to development, testing and
QA environments in regular basis.
. Implemented, configured and maintained Oracle 10g RAC (Real
Application Clusters) on Sun Sparc for HA (High Availability) system.
. Designed and implemented database backup/recovery strategy and
performed full incremental and cumulative backup/recovery using
RMAN/UNIX shell scripts.
. Space Management, User Management, Managing Privileges, Roles, Users,
Tables, Indexes and Security of Database.
. Organizing Oracle Database operations in UNIX environment,
installation, creation, configuration of Databases, laying out
database tables and database schema design, startup and shutdown of
Databases, setting "init.ora" parameters, maintaining, Data Files,
Control Files, Redo Log Files, managing Table spaces, segments,
extents, indexes and performing management of Undo Data. Maintained
Test Database for testing and research work.
. Analysis of Statspack Reports and v$ views to find out the Database
performance bottlenecks. SGA and Background Processes Tuning as per
findings from different Statistics Reports. Objects design and
reorganization according to their sizes and nature, for better
performance.
. Monitoring system performance, Disk I/O, processes, Memory etc.
. Shell scripting to automate schedule daily jobs. Monitoring Oracle
Database 10g using OEM tool (ADDM, AWR) and STATSPACK. SQL Tuning
using Explain Plan, session tracing and tkprof.
. Installation of SQL Server 2000 and 2005 on Intel platform.
. Physical database administration for SQL Server including
backup/restore procedures, reorgs, space utilization, performance
monitoring and tuning, problem determination and resolution.
Environment: Oracle9.2.0.6, Oracle Database 10.2.0.1, Oracle 10g RAC, Sun
Solaris 9, Linux AS 4.0, SQL Server 2000/2005, Windows server 2000, Erwin
5.1, TOAD, OEM.
Oracle DBA (Contract)
Jan 2004 - Feb2005
Medserv Management, Pittsburgh, PA
Responsibilities:
. As a DBA Configuration of Oracle Database Server and clients on
different platforms. Initial Database Study, Plan & design Database,
Database creation (using OMF). Installation of ERP Package at client
side. (Configuration of Database, Prerequisites for installing ERP)
. Creation of different Database objects (Partition Tables, Materialized
View, Refreshing materialized views, Index Rebuilding etc.).
Monitoring scheduling backend process (Resolve if it fails).
. Creation and Maintenance of Rollback Segments. Creation and
Maintenance of Data files, Control files and Redo log files. Creation
and Administration of Clone Database, Standby Database and Recovery
Catalog. Managing Privileges, Indexes and Security of Database.
. Involved in Database Backup strategies and recovery scenarios and
implemented backups using RMAN.
. Used Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF
to analyze timing and execution plan for SQL query to tune the SQL
statements.
Environment: Oracle8.1.7, Oracle9.2.0.6, Oracle Database 10.2.0.1, Sun
Solaris 9, Linux AS 4.0, Windows server 2000, Erwin 5.1, TOAD, OEM.
Oracle DBA (Full time, Permanent)
Apr2001- Nov 2003
Dachi Technologies, Hyderabad, India.
Responsibilities:
. Database Refreshes.
. Database Builds for new clients and Database Unbuilds.
. Installation and configuration of Oracle database 8i (8.1.7), 9i
(9.0.2) on various OS platforms like Solaris, Linux, WindowsNT, 2000.
. 24 X 7 Monitoring of Customer Databases, physically located in U.S.
and Remote Administration of fifteen Production Databases in UNIX
environment.
. Performance tuning of application and database, identification and
resolution of contention, defining and implementing Backup Recovery
policy, and day-to-day monitoring of the Production database.
. Used Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF
to analyze timing and execution plan for SQL query to tune the SQL
statements.
. Configuring Net8 and ODBC, to enabling networking between the Database
Server and Clients.
Environment: Oracle8.1.7.3.0, Oracle9.2.0.4.0, Compaq Tru64 UNIX V5.1A,
Sun OS 5.8/5.9, AIX Version 5.
Contact this candidate