Neha Sharma
- 1. Neha Sharma Mobile: (+47) 92215579 E-mail: neha.sharma2828@yahoo.com My Self Neha Sharma, I completed my Master of computer science in Information technology (Topper in University, Gold Medalist) and completed Oracle 10g Database Administrator course from SQL STAR International New Delhi. I also completed Red Hat training and having hands on experience on Red Hat Linux environment for Oracle Databases. Having good knowledge of UNIX scripting PROFESSIONAL SUMMARY Having 4.5 years of Experience in DBA activities like Database Creation Tablespace management, User management, Table/Index management Experience in installation, upgrading and migrating various versions of database (9i/10g) on different platforms Strong experience in installation and configuration of Oracle 9i/10g Experience in implementation of backup and recovery strategies Experience in monitoring the performance of database using performance tools such as AWR, ADDM and advisor Experience in preparing the Technical Documents on relevant topics Currently I am working as a Database Administrator dealing with Oracle databases having Extensive experience in Database Design, Backup Strategies, Performance Tuning, Standby databases, Data Guard Configurations, Database Recovery, Unix Shell Scripting, Windows Batch Scripting Expert in Oracle SQL,PLSQL, backup and Recovery, Performance tuning and high availability TECHNICAL SKILLS Operating System RHEL,Windows-9x/NT/XP/2000/2003 Databases Oracle: 9i, 10g,11g,Oracle RAC 11g R2 Computer Languages Tools /Utilities Services SQL,C++,C,JAVA,shell scripting Xmanager,Teamviewer ssh,ftp,telnet,smtp etc Database tools Oracle Enterprise Manager Database Control, Rman, Dbverify, Tkprof, AWR, ADDM, SQL Loader SKILLS (Oracle) Installation and configurations of Oracle software Design, Create and configure oracle databases for best performance Configure and Manage storage structures for database Servers Performing status checks by monitoring the Alert log, Trace files of the database Database backup and Recovery with user based and RMAN Setup Recovery Manager(RMAN) for Backups and recovery Develop scripts to handle cold/hot/export/archive/monitor jobs (UNIX and Windows) Extensive hands on experience for upgrade all kind of oracle database versions Extensive hands on experience for Migrate all kind of oracle database versions Extensive hands on experience for recovery of databases Capacity Planning and configuring the backup recommended by oracle using RMAN strategies. Tune databases, restructure databases as per application requirements for best performance Extensive work experience with Export, Import, Data Pump, SQL Loader Utilities Develop scripts to perform Export, Import, Data Pump, SQL Loader activities
- 2. Extensive knowledge in Developing Stored Procedures, Packages, Functions, Triggers Installation of 2-node RAC 11g R2 on Linux platform with configuration of DNS Server Professional Courses/ Qualifications Oracle DBA 10g OCP Certification from Oracle University Mar 2011. Oracle 10g, SQL* International Delhi (India) Mar 2011. Educational Qualifications Master of Computer Science (Topped in University) 2009 2011 WORK EXPERIENCE INTERNATIONAL SOFTWARE MINDS (ISM) Nov 2014 Feb 2016 Managing Director / Oracle Trainer PROJECT RESPONSIBILITIES: Management: Involved in the recruitment and selection of teaching and support staff. Monitoring the performance of all staff. Keeping in regular contact with the local community to promote the institute ethos and ensure good a relationship. Ensuring quality assurance and development targets are met. Planning, managing and monitoring the curriculum within the agreed budget. Making sure that financial regulations are adhered to. Setting appropriate targets for the improvement of institution performance. Promoting, developing and enforcing good management practice. Setting targets for teachers and other staff. Teaching: Taking Workshop(Oracle DBA) Batches for IT students & Corporate Employees Installation and configurations of Oracle 11g /12c databases on Linux & windows platform Design, Create and configure oracle databases for best performance Configure and Manage storage structures for database Servers Performing status checks by monitoring the Alert log, Trace files of the database Database backup and Recovery with user based and RMAN Extensive hands on data pump for managing logical backups Participate in different kinds of college projects for IT students on Oracle technology Involved in different types of database migration & upgradation. PATH INFOTECH LTD July-2013 April 2014 Oracle DBA Professional Trainer PROJECT RESPONSIBILITIES: Installation and configuration of Oracle 11g on Linux Platform Monitoring databases, which include basic health checks, growth of objects, performance of the database and giving recommendations how to resolve it. Performing status checks by monitoring the Alert log, Trace files of the database. Extensive hands on performance tuning & logminer concepts
- 3. Migration of Oracle 8i to Oracle 11g on Linux platform Moved database Schema changes to stage or production. Developed some Unix Shell scripts to automate database backup operation through RMAN and database monitoring & manual startup & shutdown scripts Defragmentation of tables and indexes for improved performance and effective space management. Scheduling backups in crontab (Linux) Verifying scheduled user managed & Rman backups Preparing daily, weekly and monthly report of incidents escalated and resolved Configured & Implement daily backup scripts & weekly backup scripts using RMAN increment level 0 & 1 database backups. Provided 24x7 on call production support. SKY INFOTECH PVT LTD 10-Aug-2012 05-july-2013 Oracle DBA professional Trainer PROJECT RESPONSIBILITIES: Taking Workshop(Oracle DBA) Batches for corporate Employees (3 Batches a Day) Taking SQL/PLSQL Batches for corporate Employees (2 Batches a Day) Installation, creation and support of Oracle 9i and 10g database in Production Environments. Monitoring databases, which include basic health checks, growth of objects, performance of the database and giving recommendations how to resolve it. Performing status checks by monitoring the Alert log, Trace files of the database.. Performing backups and restoration. Capacity Planning and configuring the backup recommended by oracle using RMAN strategies. Creating new databases under various environments and maintaining different oracle homes in the same servers. Support has Database administration on Development and Production databases. Rebuilding the indexes and Gather statistics of tables to improve the performance. Monitoring and Reorganizing Database objects Tables & Indexes to minimize fragmentation in the database using logical backup and restoration. (Export and import) and Data pump. VMC COMPUTERS PVT LTD 01-apr-2009 31-Sep-2010 Rejoined 01-june-2011 03-Aug-2012 Oracle DBA Trainer PROJECT RESPONSIBILITIES: Developing and creating tables & views, stored procedures, triggers as per the client requirements. Help and support in the clients production environment To manage the data in the MS-ACCESS and maintains the connectivity with the SQL SERVER 2005 Worked in their Education Domain & Provides training to various batches regarding SQL, RDBMS. Maintaining database and ensuring its availability to users Controlling privileges and permissions to database users Installation and creation of Oracle Database for best performance To Take daily export backup & Rman backup of Oracle database Moved database Schema changes to stage or production.
- 4. Developed some Unix Shell scripts to automate database backup operation through RMAN and database monitoring & manual startup & shutdown scripts Defragmentation of tables and indexes for improved performance and effective space management. Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity. Performed SQL tuning by using Explain Plan and Tkprof. SOFT SKILLS Disciplined, organized, a team player having excellent interpersonal & communication skills. Always open and eager to embrace innovative ideas Languages Known: English, Hindi, Punjabi PERSONAL DETAILS Date of Birth: 28-Jan-1988 Marital Status: Married Nationality: Indian Passport Status: Available and Valid Current location: Oslo, Norway