Database Administrator Resume

SUMMARY

I am an associate with Confidential, working as a Database Administrator, assisting teh migration of Production ATM’s from Tandem legacy servers to new Linux/Oracle servers.
I was an associate with Simeio Solutions LLC, a startup based in New Jersey for 17 months and with a total of 7 years and 8 months of work experience.
I was a Database Administrator for 90 months and I have exposure and expertise in teh full life - cycle administration of Oracle, Installation, Configuration of databases on both Unix & Windows, Performance Tuning, Configuration of Standby databases for both single instance and RAC, Oracle 11gRAC, Oracle 10g RAC and Multi-node application for Scalability, Oracle migration and upgrading of teh databases on different platforms and Storages.
Administering one of teh biggest OLTP database (State Bank of India’s), which is 80 +TB in size. Administering over 100 Databases including production/Non production databases whose size ranges from 1GB to 80TB.I have very rich exposure to HP-Unix. Exposure to Performance Tuning of batch jobs, migration related activities and partitioning of large tables for performance and archival purpose.

TECHNICAL SKILLS

Oracle 10g
Oracle10g RAC
Oracle9i
OEM 12c
Export/Import Utility
Data Pump
Oracle 11g
Oracle 11g RAC
MySQL
Oracle Golden gate 11.x, 12.x
OEM
Stats Pack
AWR
Quest Central
Toad
SQL Developer
HP Unix
Logical volume manager
RHEL5
Tandem
Amazon EC2

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

Implementing Oracle Golden Gate to migrate Confidential ATM’s from tandem to Linux/Oracle
Performance tuning of oracle databases in real time.
Testing teh functionalities with developers to assist in migration.
Administering Golden Gate processes across DEV,
Writing PL/SQL procedures to add new modules to existing code.
24/7 support for Developers.
Performance tuning and testing of new SQL codes.
ERD generation and data modeling for new environment.
Documenting teh migration activities

Confidential

Senior Database Administrator

Responsibilities:

Deploying Oracle 11g databases and integrating with IAM infrastructures.
Performance tuning of oracle databases in real time.
Deploying OEM 12c to monitor health and performance of various applications
Automated all teh Databases related tasks.
Deployment of customized shell scripts to detect issues.
24/7 support for Developers.
Configuration and maintenance of Standby database with Oracle Dataguard for High Availability.
Deploying Oracle 11g RAC.
Mentoring new team members in an expanding startup environment.
Deployment and administration of MySQL databases for in-house projects.

Confidential

Database Administrator

Responsibilities:

Performance Tuning of migration activities.
Performance tuning of oracle databases during batch execution.
Planning and Partitioning of Major tables in Production databases.
Administering teh Huge production and their Corresponding Standby Databases.
Performance Tuning of teh database and application related queries
Monitoring and maintaining teh space requirements for teh production databases.
Planning and executing oracle Version upgrades.
Studying teh entire application management process, procedures, identifying areas for improvements and implementing teh same.
Configuration and maintenance of Standby database at Disaster Recovery Site.
Performance tuning of standby databases.
Query and performance tuning of long running queries on huge tables against huge Databases.
Planning for Data Design and Creating tablespaces and tables for Databases.
24x7 Support to all Live production databases whose activities include OLTP and Heavy Batch processing.
Planning proactive maintenance activates like Huge index rebuilds and table reorgs for performance and space release.
Rich exposure to Oracle10g new technologies like Data pump, Flashback Database etc.
Familiar with all oracles basic Administration tasks like creation of users, tables, tablespaces, roles, privileges, grants, exp/imp etc.
Migrating Associate bank’s production databases from oracle 10g to 11 g.
Implemented Active standby in 11g in various databases.
Implemented advanced compression on large sized databases achieving a compression ratio of 1.8.
Planning and implementation of partitioning of large tables and indexes.
Adding nodes to RAC production databases.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship