|
|
|
e-mail : Krishna Gopalan
URL: http://www.krishna-gopalan.com
Krishna Gopalan has over 3 Years of experience in Project
Management and Oracle Data Base Administration. IT was initially part of it but
the last two years had been full-fledged on Oracle Database administration in
production environment and he also developed good UNIX (Sun Solaris and HP-UX)
and Windows NT administration skills.
He is also proficient in Oracle Enterprise Manager 2.1, Visual Basic
programming and knowledge of C, Java and Developer 2000 languages. Krishna Gopalan has strong interpersonal
skills and is an active listener, effective communicator with a
team/collaborative approach to problem solving. Presently working as a Data Base Administrator in an Oracle
Financials applications implementation environment.
TECHNICAL
SKILLS:
|
Application Software |
SQL, PL/SQL, Oracle 7.x,
Oracle 8.x, D2K, Visual Basic, FoxPro, MS Access |
|
Operating Systems: |
Windows 9x/NT, UNIX (HP-UX,
Sun Solaris), DOS |
CERTIFICATIONS:
|
89 % |
|
|
3.71 |
PROFESSIONAL
EXPERIENCE:
DishnetDSL Chennai, India
DBA Jan 2001 – present
DishnetDSL
is one of India’s largest Internet Service Providers and the leaders in
DSL in India.
Job involved:
Data Base
Administrator for Implementation of Oracle Financials for DishnetDSL and
maintenance of the Database. Project
currently in the test environment phase and plan to go live by Mar 2001.
·
Administration of Oracle
Application Database
·
Adding and managing
space for effective utilization of resources
·
Tuning, Periodic Backup
and Recovery
·
Security privileges and
profile management.
·
Regular auditing
Technical Skills : Oracle 8i, Sun Solaris 2.6, Oracle Applications 11, Win NT, Win9x
Oil & Natural Gas Corporation Limited,
Karaikal, India
DBA Aug 1997 - till Jan 2001
ONGC is
large Oil and Natural Gas EPC Giant and the No.1 profit making Co. in India.
Jobs involved:
Data Base Administrator for implementation
and maintenance of Integrated Materials Management System (IMMS) an Oracle /
Developer 2000 based OLTP Materials Management system linking ONGC’s 27 project
sites by LAN / WAN
1.
Complete the Day to day operation requests, which includes administration db
links, restoration of databases, object management and Security administration.
2.
Managed space utilization within Oracle servers, Wrote monitoring scripts in
SQL*Plus.
3.
Installed ORACLE software, created tuned and upgraded databases.
4.
Migrated the Oracle 7.3.4 to Oracle 8.
5.
Co-ordinate with the development team on their day-to-day requirements.
6.Tuned
database parameters; balanced I/O
7.
Frequent tuning on Application and memory to speed up the response time
8.
Regular production problem investigations
9.
Working on distributed environment.
8.
Maintaining Backup and Recovery procedures
Technical Skills: Oracle 7.x, Oracle 8.x, HP-UX, Win NT, Win9x, Enterprise Manager 2.1
Performance
tuning and monitoring
Continually
monitored system performances of all the databases and was retuned whenever
necessary like changing the tuning parameters, restructuring the table,
rebuilding indexes, checking for row chaining etc
Space
management
Since
production, the extent growths of key tables were monitored and block
parameters were changed to improve space.
Backup
and recovery
Developed
effective backup and recovery strategy.
Periodic testing of back and recovery process.
Security
Administration
Adding
and removing users, administering quotas, regular auditing and checking for
security problems
Troubleshooting
Troubleshooting
of the application and database bugs thereby eliminating potential problems.
Data
Analysis
Analyze
the data stored in the database and made recommendations relating to
performance and efficiency of that data storage. This related to the more effective use of indexes.
Data
modeling and optimization
Assisting
the application team with SQL and stored procedure developments and act as
consultant to the user community as well as the development team.
Evaluation
of new hardware and software purchases.
Evaluate,
Recommend and Approve purchases of new Hardware and Software for development
and future growth of new / existing projects.
Oil & Natural Gas Corporation Limited
Mechanical
Engineer Apr. 1984 to Aug 1997
Was in the Engineering Division and was in Equipment Management / Material Procurement and Planning for Offshore and Onshore Platforms and Drilling Rigs
EDUCATION:
|
1978-1983 |
Osmania University
Hyderabad |
Bachelors Degree in
Engineering (Mech. Engg.) |
|
1988-1999 |
I.G.N.O University New Delhi |
Diploma in Management |
|
1997-2000 |
University of Madras Chennai |
Master of Computer
Applications (MCA) |
PERSONAL DETAILS:
Date of Birth : 23 July 1961
Nationality : Indian
Marital Status :
Married