We provide IT Staff Augmentation Services!

Database Administrator Resume

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

Database Administrator

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.

Hire Now