© 2002-2008 IT-Careernet.com Reproduction, retrieval, copying or transmission of the content of this site is not permitted without the publisher's prior consent. Last changed: 18 Nov 2008 Home SiteMap Terms & Privacy
-start of code- -end of code- &n
|
Professional Profiles |
IT-CAREERNET
.
|
From: Ritesh Raj Singh
Date: Wednesday, February 27, 2008
Time: 01:34 AM
Ritesh Raj Singh <BR> Address<BR> # 17 Bane Compound, Tardeo Mumbai Central (West), <BR> Mumbai – 400034.<BR> Mobile: +91 - 9322070038<BR> Email: riteshrajsingh1984@yahoo.com<BR> <BR> Objective<BR> <BR> To pursue an excelling career in an organization that provides a challenging work <BR>environment and gives me a scope to update my knowledge and skills in accordance <BR>with the latest trends in IT industry and be part of a team that dynamically works towards growth of the organization. Job Summary An Oracle DBA Certified by Oracle Corporation as an Oracle Certified Professional with Strong Administration and Troubleshooting skills. Strong business and technical vision with effective people skills to allow close work with senior management, ability to manage multiple complex projects for internal and external customers, Innovative and creative problem solver who is result oriented, has an aptitude for learning and can maximize resources while possessing a sense of urgency. More than Two Year of Extensive Work Experience in Oracle Database Administration, Development and Design of Production/development Databases. Maintaining High availability With Real Application Cluster, Advance Replication, implementation of Data guard through Physical Standby and Logical Standby for Reporting Purpose and Snapshot Replication Backup Strategies with RMAN and User Managed Backup, Oracle Partitioning, Advance Queuing and Job Scheduling for ETL Operations, Tuning Performance by Tuning Design, Memory and SQL Statements. Implementing Oracle PLSQL Packages like UTL_HTTP, UTL_SMTP for Emailing and Virtual Private Database And DBMS_OBFUSCATION for Security Implementation. Currently working for ICICI Ltd deputed by 3i-infotech (ICICI InfoTech) and handling more than 200 Production Databases for ICICI Bank and Group Companies ranging from 10 Giga Bytes to 3 Terra Bytes for ICICI bank at their Data Centre in Mahalakshmi, Mumbai, Databases are running on Oracle 7, 8i, 9i, 10g on Linux, Solaris, HP-UX and IBM AIX and Windows 2K,2003 Server on Clustered Environment with OS Clustering as well as Oracle Real Application cluster on 24/7 Databases. Work Experience 3i-infotech (ICICI InfoTech) Ltd Oracle Database Administrator Duration: May 2006- Till date Employer: 3i-infotecj (ICICI InfoTech) CTC: 6.0 Lacs/annum Job Summary: Designing and Maintenance of Production / Development (UAT) Databases for ICICI Bank at their Data Centre Mahalakshmi Mumbai deputed by 3i-infotech (ICICI InfoTech). Monitoring and Optimizing Performance of more than 200 Production databases for ICICI Bank and group companies ranging from 100GB to 3 TB running on Oracle 7.2/8i/9i/10g on Linux, Solaris, HP-UX and IBM AIX and Windows 2K,2003. Auditing and Security implementation. Installation and Upgrades of Oracle Server and Application Tool by installing latest Security patches and maintaining proper functioning of Databases. Gameking India Pvt. Ltd Oracle Database Administrator Duration: Dec 2004- 24-May Employer: Gameking India Pvt. Ltd. CTC: 2.94 Lacs/annum Job Role : Monitoring and Optimizing Performance of 24/7 Financial Database installed on Oracle 9i Release 2 running on Windows 2003 Server . Configuring Data Guard with Physical standby and Logical Standby for Failover and Reporting Purpose. Maintenance of Production Database, Development Database and a Data Warehouse. Enrolling Users and Maintaining System Security, Installation and Upgrades of Oracle Server and Application Tool. Planning Backup Strategies for Production, Development and Data Warehouse.Online Backup of Production Database through Physical Standby from RMAN and Logical Backup of Production Database. User Managed Backup for Development Database. Creating automated scripts through Dynamic SQL and OS scripts to automate tasks. Interacting with Developers and assisting them with PLSQL and SQL scripts. Designing PLSQL Procedures, Packages and Triggers.Configuration and Maintenance of Multiple Oracle Database running on Oracle 8i/9i10g. Project Summary Project Details 1) Gameking Internet Gaming Project (GIGP): GIGP is an Online Gaming System with its Connectivity all around the Globe. A user can install an application and can login on Application Server after authentication with the database and can play online games. All Details are online and recorded in a production database running 24/7. My Responsibility towards GIGP is Configuring, designing and maintenance of Database, Optimizing and maximizing performance by Tuning SQL and memory. Planning Growth and application design. Database is running on Oracle 9i R2 under Windows 2003 Server. The application designing was done using Advance Queuing Feature with “DBMS_obfuscation” for Security Implementation. Application was designed using VC++ and communicated with Oracle through ASP. Emailing system is done through UTL_SMTP and UTL_HTTP to send emails. 2) www.gamekingindia.com : This Website is Designed with Microsoft .NET technologies running and Communicated with our Oracle 9i production database. Website involves Financial transactions running 24/7.My Task Includes Database designing and application Development for this project. I am also involve in Optimizing performance, Installation and Upgrades of Oracle Server and Application Tool 3) www.chaurasiasamaj.com : This is a matrimonial Website designed on Microsoft.Net and it communicates with Oracle 9i R1 on Windows 2000 Server. My task involves application designing and Database Designing for this Website. It is a 24/7 Production Database. 4) Gameking Internal Management System: This Software is designed in Visual Basic 6.0 and Database residing in Oracle 8i. This project is for the Internal Employee Management of the Company including Salary and attendance details. My Responsibility is backup and maintenance of Database. 5) High Availability Solution with Data Guard and Materialized View Replication: Created One Physical Standby Database and One Logical Standby for Failover and Reporting Purpose. Logical Standby is created for moving data of Production Database to Data Warehouse through ETL Operations. Database is running on Oracle 9i R2. Materialized View Replication is created for zero data loss of Production Database. 6) Oracle Data Warehouse and ETL Operations: Designed Oracle Data Warehouse for Historical analysis and reporting purpose. Created ETL Process through PLSQL Procedures which runs as an Scheduled Job and moves the data from production database to Data Warehouse on nightly Scheduled basis. Tables in Data Warehouse is Designed with Partitioning on date column to facilitate feature of partition pruning and large block size is used with bitmap indexes. Optimizing performance and maintenance for this database is a regular task to improve the response time. Database is designed on Oracle 9i R2 running on Windows 2003 Server. Oracle Skills Oracle Tools Development: SQL *Plus, iSQLPlus, Advance Queuing Configuration Tools: Net Configuration Assistant, Net Manager, Oracle Enterprise Manager (OEM), DBCA etc. Performance Monitors: Performance Manager, Top Sessions Recovery Tools: RMAN, Flashback Query, Log Miner PLSQL Packages: DBMS_obfuscation, Profiler, Utility and Stats, UTL_smtp, http, tcp etc High Availability: Materialized View Replication, Data Guard (Logical and Physical standby) Technical Skills Technical Knowledge Programming Languages: C, C++, VB 6 Web Technologies: HTML, ASP, ASP.Net Operating Systems: DOS, IBM –AIX, Sun Solaris 9-10, HP-UX, WINDOWS 95-98, NT/2000, 2003 Server, Red Hat Linux Databases: ORACLE 8/8i/9i/10g Educational Qualifications Oracle Certified Professional 10g Database Administrator® Oracle Certified Professional 9i Database Administrator® Oracle 10g Certification Exams Cleared 1Z0-040 Oracle 10g New Featured for Administrator Oracle 9i Certification Exams Cleared 1Z0-007 – Introduction to Oracle 9i SQL 1Z0-031 – Oracle 9i DBA Fundamental I 1Z0-032 – Oracle 9i DBA Fundamental II 1Z0-033 – Oracle 9i Performance Tuning Oracle 9i SQL, DBA Fundamental I – Trained By UPTEC Varanasi Oracle 9i DBA Fundamental II and Oracle 9i Performance Tuning – Trained at Oracle Authorized Centre IIHT Bangalore Diploma in Computer Hardware Engineering and Networking - ITC Varanasi One Year Foundation Diploma in Computer Programming - UPTEC Varanasi DOEACC A Level Department of Electronics Accredited By Central Govt New Delhi (Equivalent to PGDCA) Exams Cleared: UNIX and Shell Programming OOPS Programming through C++ Data Structure through ‘C’ Data Communication and Networks Data Base Management System DOEACC O Level Department of Electronics Accredited By Central Govt New Delhi Bachelor in Commerce Purvanchal University 2003-2005 52% 12th Sunbeam Bhagwanpur CBSE 2001-2002 70% 10th Sunbeam Bhagwanpur CBSE 1999-2000 54% Achievements Awards and Achievement • Scored 93/93 - 100% on Prometric Sylvan’s IZ0-032 Oracle Fundamentals II examination covering Oracle Networking, User managed backup recovery and Backup Recovery using RMAN. • Scored 56/59 - 95% on Prometric Sylvan’s IZ0-033 Oracle 9i Performance Tuning covering Oracle Performance Tunning, Tuning Shared Pool and Database Buffer Cache, Application Tuning and Designing. Collecting Statistics and designing optimization technique • Meritorious Award for Securing Superior Position in all over India Exam For Programming and Problem Solving through ‘C’. Received Cash Scholarship on behalf of this achievement. • Meritorious Award for Securing Superior Position in all over India Exam For OOPS programming through C++. Received Cash Scholarship on behalf of this achievement. Personal Details Name: Ritesh Raj Singh Fathers Name: Mr Rajeev Singh Permanent Address: K44/18 Viseswarganj Varanasi – Uttar Pradesh 221001 Present Address: 17 Bane Compound Sane Gurugi Marg Tardeo, Mumbai Central (west) Mumbai - 400034 Maharashtra India Date of Birth: 16-Mar-1985 Mobile No: 09322070038 Email Id: riteshrajsingh1984@yahoo.com Nationality: Indian Language Known: English and Hindi (Verbal and Written) Hobbies: Playing Guitar, Listening Music, Reading Books References: Available on request.
|
|
|||
|
|
|||
|
© 2002-2008 IT-Careernet.com Reproduction, retrieval, copying or transmission of the content of this site is not permitted without the publisher's prior consent. Last changed: 18 Nov 2008 Home SiteMap Terms & Privacy |
|||
|
-start of code- -end of code- &n |
|
||