· Experience with databases on Linux, Solaris and Windows platforms.
· Platform : Windows Family, Red-Hat Linux (7.1,8,9,AS2.5), Solaris8, and AIX 4.3.
· Languages : C++, HTML, PL/SQL, Shell Scripting.
· Database : Oracle 10g, 9i & 8i, Sybase12, Adaptive Sybase Enterprise (ASE), SQL Server 2K, MySql4.1.
· Tools : Imp/Exp, SQL*Loader, SQL*Plus, SQL*Net, Quest TOAD 6.3/8/8.5, PL/SQL Developer,
Benthic Golden32, SQL Tools 1.4, Oracle Workbench, iSQL (Sybase).
· Hardware : Compaq Proliant ML 350/370, HP TC2120, Cisco 2500 router, 2950 Switch.
· Modems : Avantel V.35, G.703.
· Firewall : ISA Server 2000/2004, Netgear (Wireless router cum firewall).
· Network : DNS (server), DHCP (protocol), TCP/IP, Routing, VPN, Oracle Net8.
September ' 2005 – Till Date at Pythian India Pvt. Ltd., Hyderabad
Oracle Database Administrator
· Size of Backups ranges from 10M to 300G (Varies from Client to Client).
· Remote Database Administration on Linux, Solaris and Windows 2000/2003 Server.
· Involved in table re-organization, space management, performance tuning, SQL Tuning, Backups etc.
· Migration of three Sybase database (Production) to Oracle 10g using Oracle Workbench, ASE.
· Manual conversion of Sybase Procedures to Oracle Procedures.
· Worked on Quest Toad 8.5, Benthic Golden32 for more productivity.
· Switchover of Production Database to Standby Database and vice versa using Data guard (DGMGRL).
· Created Standby Database for 24/7 production database.
· Monitoring/Maintenance/Troubleshooting of Clients Databases.
· Supporting off hours call for production database (Oracle, SQL Server, MySql).
· Setting up CRONTAB for backups/monitoring of database and server.
· Adding Data files to the Oracle (8i, 9i, 10g, RAC) and SQL Server 2000 databases.
· Monitoring MySql and SQL Server2000 databases.
· List of few Clients: 1) CBS 5) Community Connect Inc.,
2) Logical Information Machines 6) IGN
3) Twelve Horse North America 7) Curaspan
4) DRX Pharmaceuticals 8) SiGe Semiconductor
January ' 2005 – August’ 2005 at Apex Co-Services, Hyderabad
[Laid-Off]
Jr. Oracle Database Administrator
· Responsible for installation, creating and configuration of Oracle Database on Linux and Windows 2000.
· Involved in table re-organization, space management, performance tuning.
· Supporting off hours call for production database.
· Monitoring Database Activities, Checking for Tablespace Availability, Checking the Alert Log File for errors, and monitoring the Hit Ratios.
· Involved in table/index reorganization using export/import and online rebuilding of indexes.
· Loading Bulk data from flat files using SQL*Loader.
· Provide all kind of Oracle Support to developers.
· Maintains the database constraints to ensure the integrity.
· Associated and involved with Sys Admin in RAID configuration and disk stripping for optimized database I/O performance.
· Responsible for Database maintenance i.e. Scheduling Backup, Startup-Shutdown.
· Responsible for Schema design and maintenance.
· Involved with Admin Team to implement on Active Directory and User Security policies.
· Responsibilities also include maintaining Concerto Ensemble Pro Dialer and reports generation from Data views, Sybase database and Oracle database as per requirements mentioned by the management.
Oracle Database cum Network Administrator
· Installed, configured, and maintained the Oracle databases and related software, managed users and maintained security.
· Partial programming in PL/SQL. (Stored procedures, functions, and triggers).
· Planning Backup & Recovery procedures, Performing Backup and Recovery activities (both in archive & no archive mode) with/without using RMAN & Export/Import utilities.
· Monitored network and system conditions for impact on database performance.
· Provided system troubleshooting and database tuning expertise to ensure optimal performance.
· Performed risk analysis of mission critical systems and applications and supported the development, design, implementation and maintenance of the disaster recovery plan.
· Developed standards for the environment. Designed database tables, views, indexes, triggers and stored procedures.
· Application performance tuning using different oracle tools like Explain Plan.
Download Resume Format
0 comments:
Post a Comment