|
Rajnish D. Pershon
Oracle Certified Database Administrator
SUMMARY
• In-depth knowledge and experience in full life-cycle database including data
architecture, logical and physical database design, data modeling,
implementation, and administration.
• Extensive experience in planning, installing, configuring, and administering
multiple Oracle databases in a WindowsNT/2000/XP and Sun Solaris UNIX
environment.
• Solid skills in database optimization and performance tuning for servers,
applications, and SQL queries.
• Experience in designing enterprise-wide database backup and recovery plans and
implementing backup/recovery, failover, and replication procedures.
• Designed and developed database applications and data warehousing for business
intelligence.
• Proven expertise in object-oriented design and client/server application
systems development.
• Experienced in designing and developing web applications for e-business
solutions and supporting various J2EE based application server environments.
• Proven ability to deliver high quality products and services on schedule and
under budget.
• Self-motivated team player with excellent verbal and writing communication
skills.
• Experience in business analysis, project management, supervisory, and team
leadership.
EXPERIENCE
Senior Database Consultant 5/1999 – Present
DataTrend Consulting Group, Chicago, IL
• Database Administrator: Administer Oracle Server and Microsoft
SQL Server databases. Manage database instances, monitor server
performance, tune the database server and applications, and perform backup and
recovery. Provide consulting solutions to various clients in database design,
database server configuration, data warehouse implementation, server performance
tuning, and application tuning.
• Data Architect: Designed OLTP and OLAP database infrastructure for
analyzing state government budgeting process. Defined database requirements and
designed data model. Re-engineered business process and conducted data
integration between BARS software and ERP systems. Implemented data mart and
data warehouse.
• Database Developer: Led project for the Statewide Budget Analysis and
Reporting Systems development life-cycle. Planned project, analyzed client
requirements, and documented technical specifications. Used case tools to build
the data model. Developed Oracle database stored procedures, packages, and
triggers to process business rules and data logic.
Database Administrator 2/1998 – 5/1999
Municon Computer Services, Inc., Lakeside , IL
• Managed 10+ Oracle database instances, conducted server performance
tuning, backup and recovery, and troubleshooting in Windows NT and Sun Solaris
UNIX platforms. Performed Oracle server software installation, database
creation, system configuration and upgrades. Administered Oracle repository in
Designer/2000 for data modeling and database design.
• Participated in the company’s business process re-engineering planning and
implementation to integrate desktop applications into enterprise-wide
distributed client/server system. Developed client/server database applications
that were used by over 100 municipal governments to analyze, audit, and recover tax
revenues. Utilized Microsoft Visual Basic and Oracle Developer for application
development.
Programmer Analyst 10/1996 – 2/1998
RTL Power Company, Fairview, IL
• Responsible for architecture, design, development, and testing of
custom distributed client/server applications that were implemented in an
enterprise-wide environment. Developed a management information system used by
operators and supervisors to enter and manage operation data and generate
technical reports in a hydro power plant. Developed a power distribution
statistical analysis program used by engineers to collect, analyze, and report
operation data.
TECHNICAL SKILLS
• Database: Oracle8i and 9i Server, Microsoft SQL Server, Microsoft Access,
IBM DB2
• CASE Tools and Design: Oracle Designer, Sybase PowerDesigner, ERWin, UML
• Platforms: J2EE, .NET , WindowsNT/2000/XP, UNIX (Sun Solaris, HP-UX, Linux)
• Application Servers: Sybase EAServer, Tomcat, JRun, Oracle9i AS, SilverStream
• Programming: SQL, PL/SQL, Java, C/C++/C#, Perl, FORTRAN, Assembler
• Internet: JSP, Servlet, ASP, HTML, JavaScript, Peal CGI, PHP, XML
• Development Tools: Sybase PowerBuilder, Visual Basic, Oracle JDeveloper
EDUCATION, TRAINING, AND CERTIFICATIONS
Certifications
• Oracle 9i Database Administrator Certified Professional Certification
Training
• Oracle Server Performance Tuning - Oracle University
Education
•
M..S. in Engineering, West Virginia University, Morgantown, WV
•
B.S. in Engineering, India Institute of Technology, India.
|