SUMMARY:

• Over 11 Year s and 4 month of experience in Oracle Database Administration and Sql,Pl/Sql programing (Oracle 9i/10g/11g).
• Experience in supporting and managing oracle production and non production databases.
• Expertise in Creating complex sql statements and Pl/sql code including packages, procedures, functions and triggers etc.
• Experience in configuring, managing and troubleshooting oracle golden gate replication.
• Experience in Oracle sql and pl/sql code performance tuning.
• Experience in database migration from Microsoft sql server database to oracle database.
• Expertise in moving big data from one oracle database to another database using oracle tools like datapump, export, import, sql loader etc.
• Experience in scheduling database backups.
• Experience in maintaining oracle database security by creating database users, database roles and managing privileges.
• Experience in managing database space by create and maintaining tablelspaces and datafiles.
• Experience in database designing.
• Experience in creating and maintaning shell scripts to load data from production database to reporting databases and to generate reports.
• Experience working in finance and telecom domain.

TECHNICAL SKILLS:

LANGUAGES: Sql, Pl/Sql, C, C++, C#

TOOLS: Toad, Pl/Sql developer, Sql plus, Putty, Oracle sql developer, Oracle Golden gate, Oracle enterprise manager, Oracle datapump, Sql server enterprise manager, Winscp, TortiseSvn, itrack.

CLIENT SIDE TOOLS: Oracle Forms 6i and Reports 6i.

DATABASES: Oracle 9i/10g/11g Microsoft Sql Server 2000/2005

OPERATING SYSTEMS: Windows 2003/2000,Windows XP, Linux,Sun Solaris.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Preparing development databases by creating new objects, updating existing objects and loading data in non production database from production for every release.
• Loading data from production or other databases to development database.
• Validating the code, sql queries, object redefinition scripts written by developers.
• Improving the performance of existing pl/sql codes and sql queries.
• Setting up oracle golden gate replication between oracle databases. Managing and troubleshooting golden gate replication between databases.
• Creating scripts to redefine tables for improving the performance like converting existing heap organized tables to index organized tables to reduce I/O.
• Preparing environment for every release mock deployments, coordinating with other supporting teams and production support team and schedule mock deployments.
• Assigning work to offshore team and helping offshore team to resolve the obstacles faced by them in completing the assignment.
• Writing complex sql queries and writing Pl/sql code like creating packages, stored procedures, functions and triggers.
• Writing scripts to synchronise oracle databases by replicating missing records from one database to another using oracle golden gate.
• Managing database security by creating database users, database roles and maintaining database privileges.
• Creating new tablespaces, users on development database and creating scripts to create users for QA and production databases.
• Maintaining and arranging the space for development databases.
• Creating and maintaining database links on development database pointing to QA and production databases.
• Writing or maintaining pl/sql code, oracle jobs of dashboard database to pull records from production database.
• Cleaning up development and QA environments by dropping not required objects after every major release.
• Creating scripts for developers to refresh local database with latest changes.
• Coordinating and helping other teams to schedule OS patching, oracle patching etc.
• Maintaining database repository, schemas and password details etc.
• Installing and configuring oracle web tier utilities to use webcache for api calls.
• Helping developers in troubleshooting database issues, creating database environments for developers as per the requirement.
• Creating code, scripts and jobs for maintaining oracle tables date partitions for removing old partitions and for adding new partitions.

Confidential

Team Member

Responsibilities:

• Deploying scripts on different database environments as per the requirement.
• Refreshing database schemas.
• Synchronising database schemas.
• Creating new database objects and changing existing objects definition.
• Applying Ad - Hoc queries on different databases.
• Monitoring databases and dealing with performance issues.
• Monitoring and executing shell scripts to move data between databases.
• Tuning complex sql queries and Pl/sql code.
• Creating and maintaining documents for release changes and guiding the team for release production deployments.
• Creating new database environments for new requirements.
• Troubleshooting database issues.
• Upgrading the database environment for each release.

Confidential

Team Member

Responsibilities:

• Designing new database schemas for application development.
• Migrating data and database programs from different databases like sql server and other oracle databases into new database by using hsodbc database link and oracle sql developer tool for migration.
• Creating and maintaining tablespaces and distributing data and objects between tablespaces according to their type.
• Creating new database objects and maintaining existing objects.
• Creating and maintaining scripts to automate daily backups.
• Exporting and importing databases, schemas and tables.
• Database monitoring and tuning.
• Tuning sql statements and application code written by application programmers and developers.
• Creating complex sql statements and pl/sql codes.
• Creating triggers to maintain data history.
• Creating packages, function and procedures for application development.
• Maintaining repository about database objects and data stored in the Database.
• Creating new users and granting privileges to users.
• Creating and maintaining database maintenance plan to schedule sql server database backup.

Confidential

Team Member

Responsibilities:

• Exporting and importing databases, users, tables.
• Creating and maintaining tablespaces and datafiles.
• Creating and maintaining users, roles.
• Creating and maintaining database links to access data from different databases.
• Creating complex sql statements and pl/sql programs for fetching data from different databases.
• Creating and maintaining scripts for daily database backups.
• Creating materialized views.
• Performance monitoring and tuning.
• Creating triggers, procedures, functions and packages for application development.
• Sql statements support to software development team.
• Tuning existing sql queries and pl/sql code.
• Troubleshooting database issues.

Confidential

Team Member

Responsibilities:

• Installation, configuration & maintenance of oracle database servers on Linux.
• Cloning database and maintaining test database server.
• Exporting and importing database, users, and tables.
• Taking full Database backup on digital linear tape.
• Maintenance of oracle connectivity.
• Creating and maintaining tablespaces and datafiles.
• Maintaining auditing.
• Monitoring databases and trace files.
• Creation and maintenance of database objects.
• Creating new users and locking existing users.
• Maintaining user’s quota and granting privileges and roles to users.
• Creating new roles and changing existing roles.
• Maintaining scripts to export database.
• Validating automated rman backups.
• Tuning application related issues.
• Inserting bulk data using sql loader.
• Sql statements support to software development team.
• Maintaining and creating applications using forms 6i and report 6i.
• Creating procedures, functions, packages and triggers for application development.
• Using Crontab to schedule scripts.
• Tuning sql queries and pl/sql code.

Confidential

Team Member

Responsibilities:

• Creating new databases for application development.
• Creating new database schemas and granting them privileges and database roles.
• Designing database and creating database objects for application development.
• Creating procedures, functions, packages, triggers and writing pl/sql code for application development.
• Writing and tuning complex sql statements.
• Scheduling and monitoring database backups.