SUMMARY:

• More than twelve years of experience in Database Administration,
• Experienced in ORACLE DBA (8i/9i/10g/11g).
• System Administration
• Skills in SQL* PLUS, SQL* Loader, Export/Import Server Manager.
• Worked on Creation of table spaces, data files, roles, database links, redo logs, rollback segments.
• SQL query optimization using explain plan, TKPROF reports, gathering statistics
• Experience developing new projects and supporting the existing ones.
• Database creation, backup/recovery using RMAN, Flash Recovery, Performance tuning /reorganization, cloning, general troubleshooting, and configuring servers
• Experience in database cloning, physical & logical Standby database.
• Datagaurd implementation and RAC installation on win 2003 server
• As System Administrator managed Linux and Windows Server
• Able to meet tight deadlines and provide 24x7 production support.
• Demonstrated business leadership and strong technical and functional knowledge of Oracle, SQL Server, Postgres and MySQL
• Deployment of Portal with e - Groupware and SAPRFC and leading a team.
• Experience in hardware and software evaluations, capacity planning, infrastructure design and implementation.
• Managing E-mail Server.

TECHNICAL PROFICIENCY:

Languages: SQL, Java Script, HTML/DHTML, PHP

OS: Linux, WIN- 2000/2003/2008/2012 , UNIX

Databases: Oracle, MSSQL, Postgres, MySQL

Protocols: TCP/IP, HTTP

WORK EXPERIENCE:

Confidential

Responsibilities:

• Worked on Several Software using Programming languages such as PHP, ASP.net, and HTML.
• Installing Linux and Windows Server as a System Administrator.
• Managing Oracle, SQL Server, Postgres and MySQL.
• Managing and Maintaining E-mail Server.
• Installation and Configuration of Database and
• Maintaining MIS Software (ASP.net) and Database(SQL server 2008) of Plant Automation, troubleshooting and support of all plant’s automation software such as SCADA and its related applications
• Installation of SAP and Configuration of interface to auto capturing Data at weigh bridge, QC lab of Milk Plant and CF plant across all locations of organization.
• Managing and maintaining in-house developed software Confidential Portal, online Confidential order booking application by deploying e-Groupware and Installing SAPRFC on Linux server.
• Developing document of inward outward Register for Admin Department using PHP and Postgres.
• Develop Birthday wishing Application using PHP and Postgres.
• Supervising a team of software developers.
• Manage workload for individual team members.
• Establish individual goals and objectives.
• Perform reviews and provide feedback to team members.

Confidential

Oracle DBA

Database: Oracle 9i

Operating System: HP Unix 11.11, 11.23

Responsibilities:

• Database Monitoring
• Tablespace Management
• Purging activity
• Table Partitioning
• Database migration
• Oracle patch updation
• Creation of database
• Index mangement and system statistics
• Datapump
• Datagaurd
• Creation of database
• Backup management and Recovery Manager

Confidential

Oracle DBA

Database: Oracle 9i, Oracle 10g

Operating System: HP Unix 11.11, 11.23

Responsibilities:

• Database Monitoring
• Tablespace Management
• Purging activity
• Table Partitioning
• Database migration
• Oracle patch updation
• Creation of database
• Index mangement and system statistics
• Datapump implementation
• Datagaurd implementation
• RAC installation on win 2003 server
• Creation of database
• Backup management and Recovery Manager

Confidential

Application support

Programming Language: D2K

Database: Oracle 9i

Responsibilities:

• Solution of errors occurred during the user’s process.
• Locating bugs and reporting to the developer
• Updation of Confidential patches
• Creation of database
• Taking backup, Space management and system statistics
• Monitoring Scheduled jobs
• Communicate with users and provide technical and functional support
• To assist in the setup, Administartion and day-to-day operation of Confidential
• Designing and developing the reports as user requirements

Confidential

Customer Support

Programming Language Oracle - D2K

Database Oracle

Operating System: Sun Solaris 8

Responsibilities:

• Giving the solution of errors occurred during the user’s process.
• Locating bugs and reporting to the developer.
• Updation of Confidential patches.
• Creation of database
• Taking backup, Space management and system statistics
• Monitoring Scheduled jobs.
• Communicate with users and provide technical and functional support.
• To assist in the setup, Administartion and day-to-day operation of Confidential .
• Designing and developing the reports as user requirements.

Confidential

Programmer

Programming Language Oracle - D2K

Database Oracle

Operating System: Sun Solaris 8

Responsibilities:

• Creation of Database and installation of Confidential at the server side and client side.
• Imparting to the commercial section and Confidential section.
• Locating bugs and reporting to the developer.
• Testing the system for Confidential
• Correcting the reports supplied along with the software, according to the user’s requirement.
• Designing and developing the reports for bill printing.
• Designing and developing the forms as per client requirements.
• Handling Rajkot SSA.

Confidential

Junior Programmer

Programming Language: Visual Basic

Database: Oracle

Responsibilities:

• Designing the Master / Transaction tables.
• Designing the layout for the Transaction document.
• Setting the screen layout
• Testing the Application
• Testing Results and Implementing
• Implementation of the Application and the Database Developed.