## BIO
RESUME Krishana Shakya E-mail: [login to view URL] Database Administrator [login to view URL] /DBA Contact No. : 9310477648; 9320702651 CAREER SUMMARY Currently working with Reliance Energy Ltd. (Anil Dhirubhai Ambani Enterprises) (BSES Yamuna Power Ltd.) as DATABASE ADMINISTRATOR with 3.0+ years of experience in the area of ORACLE, PL/SQL, DATABASE ADMINISTRATION AND PERFORMANCE TUNING. • Experience in Database Diagnosis process, Managing and creation of database (testing purpose) • Experience of taking backup of database (thru RMAN, User managed), managing tablespaces and datafiles. • Working experience on PL/SQL, SQL queries writing to produce MIS reports. • Working experience of export / import data from database to Excel & Access. • Working experience on MIS (Business Analysis). • Working Knowledge of Linux /UNIX Operating System. • Knowledge of Data Guard Configuration, Clear Concept of RAC with Oracle 10g and 9i, Recovery Concept( RMAN, User Managed) TECHNICAL SUMMARY Languages : PL/SQL, T-SQL, C/C++, Java (Intro.) Operating system : Linux, Z/OS, OS-390, Windows XP, Win 98 Databases (RDBMS) : Oracle-9i,10g, DB2, My-SQL. PROJECT UNDERTAKEN Project Title : EBS (Electronic Billing System) Client : BSES Yamuna Power Ltd Environment : Oracle 9i, Windows XP / UNIX (KCC Module) Team Size : 5 Description: BSES Yamuna Power Ltd (BYPL) is a power distribution company, supplying Electricity to appox 23 lakhs consumers of 2/3 of Delhi. The EBS is a database for computerized billing system, through which the bills are generated. I am associated for the logical and functional testing for the different processes and procedure of the billing system at database end. However, the processes were modified by the dedicated developing team, but the process testing is also done by our testing team, in which I was one of the most active members. And also test the changes on the day to day basis. Responsibilities: As Oracle DBA: I am responsible for database maintenance of Development Systems for BSES Online Applications e.g. BAM, PSM, CCM etc. I am also responsible for preparing, testing and documenting of procedures and queries optimization for the development teams. As Database Engineer: As part of development and supporting team of BSES Online application as database engineer, which developed and supports the application, I am responsible for writing and managing procedure & functions according to change and requirement of business functions, performance tuning, preparing and installing of patches for new releases of Online application, database security procedures, backup and recovery procedures, solving emergency database issues in every aspect. Other summaries responsibilities are:- ? Generate new procedures as per the requirement, update old procedures for new updates in old system and also rectify the errors when any error occurs in the prewritten procedures. ? Create new functions, stored procedures, triggers or make changes to existent one in new scenario as per the requirement. ? Generate new reports and make changes in old reports as per the company requirement. ? And also generate some special report through the back end as per the special requirement from the queries. ? Knowledge of Procedures, Cursors, Function, Triggers, Indexes etc. Database Objects, knowledge Of Explain Plan etc. PROFESSIONAL HISTORY Organization : BSES Yamuna Power Ltd. Designation : Database Engineer / Jr. DBA/DBA. Duration : Sep’2006 – till. Responsibilities : As Jr. DBA/ DBA : ? User Management, Creation and assignment of Roles to users. ? Managing Database (Adding datafiles, Managing Archived logs, Quota management etc.) ? Database Backup on daily basis. ? Checking database performance and sessions. ? Tablespace Management ? Table and Views designing for development teams. ? Table Indexing for better performance. ? Provide help to development team in SQL Queries and other issues related to database. As Database Engineer : ? Generate new procedures as per the requirement, update old procedures for new updates in old system and also rectify the errors when any error occurs in the prewritten procedures. ? Create new functions, stored procedures, triggers or make changes to existent one in new scenario as per the requirement. ? Generate new reports and make changes in old reports as per the company requirement. ? And also generate some special report through the back end as per the special requirement from the queries. ? Writing and Managing SQL Queries to prepare general / confidential MIS required by GM (B) / CEO / Business Managers to help in administrative task. ? Independently to provide required data by extracting from Database such as Defaulter List for Recovery Collection, Average / Provisional / Hold cases problematic data to the divisions for resolution of cases. ? To assist development team by analyzing their SQL Queries on performance or other issues Organization : Crompton Grieves (Digital) Pvt. Ltd. Designation : Network Engineer Duration : Feb’2004 – Aug’2006. Achievements : As Network Support Engineer (2+ Yrs.): ? Independently handled Linux server based network and troubleshooting of network problem. ? Managing DNS, SAMBA, Apache Servers, Printer Servers, File Servers and NFS. ? Also managing system administrative task such as managing users Account, Backing up and restoring data and files, and managing security issues. ? Got 4th best Engineer award by our client (LIC). Organization : STEG Computer Training Center. Designation : S/W Trainer Duration : Dec’2002 – Feb’2004. Achievements : As Software Trainer (2+ Yrs.): ? Providing Training on Various S/w like Oracle, C/C++ to the Students. ? Assisting Students in their Course Material. EDUCATION / QUALIFICATION Professional Qualifiacation:- 1) 2002, MCA ( Master of Computer Application ) from Institute of Management Education. Ghaziabad, (U.P.) 2) 2008, Persuing MBA (Master in Business Administration) in finance/IT from IGNOU. Academic Qualification:- 1) 1994, High school in science stream from U.P. Board, Allahabad. 2) 1996, Intermediate in science(Maths) from U.P. Board, Allahabad. 3) 1999, Bachelor of Science (Maths) From Chatrapati Shri Shahu Ji Maharaj University Kanpur. PERSONAL PROFILE Name : Krishana Kr. Shakya Date of Birth : 01.07.1981 Sex : Male Marital State : Married Father’s Name : Shri R.A. Shakya Mother’s Name : Smt. Krishna Devi Mailing Address : @2C-464, Sadbhawna Enclave, Vasundhar
## Area of Expertise
Linux, Oracle 9i,10g. PL/SQL, MS SQL SEVER05,MySQL, PHP, JAVA, C/C++,ProC*
