Sr. Oracle Dba Resume Profile
NY
OBJECTIVE:
Seeking a challenging position as Database Architect to work in Sybase and Oracle database environment. Willing to take up the Tech Lead as well as manage group of DBA's.IT professional with 24 years of experience in System Administration and Database Administration. More than 16 years of experience working in Sybase and 10 years in Oracle. A self motivated, responsible and reliable team player with strong technical skills.
PROFESSIONAL EXPERIENCE:
Confidential
Sr. Oracle DBA
Responsibilities:
- Worked as Consultant in Dow Jones Database Group upgrading the E2 ATEX revenue generating application generating over 1 billion in revenue to migrate from Oracle 9i to Oracle 11GR2. This is a Data guard Configuration with ASM Automatic Storage Management . I handled all the issues with upgrading from Oracle 9i database to Oracle 11GR2.
- Tested the failover mechanism for application as well as Data guard Configuration.
- Enable TDE Transparent Data Encryption at the table and table space level.
- Created the services for MPU metadata platform upgrade on Oracle 11gR2 RAC.
Confidential
Responsibilities:
- Provide database support for some of the most critical systems at Dow Jones like Dow Jones Industrial Averages, Dow Jones Global Indexes applications running on Sybase 15.x with OS AIX.
- On call production support 7x24
- Work with the developers to resolve application and database problems.
- Upgraded the Sybase ASE and Replication Server.
- Backup to support the ISource application on MS-SQL server 2008
Confidential
Sr. Sybase DBA
Responsibilities:
- Provide database support for some of the most critical systems at Dow Jones like Dow Jones Industrial Averages, Dow Jones Global Indexes applications running on Sybase 15.x with OS AIX.
- On call production support 7x24
- Work with the developers to resolve application and database problems.
- Upgraded the Sybase ASE and Replication Server.
- Backup to support the ISource application on MS-SQL server 2008
Confidential
Sr. Sybase and Sr. Oracle DBA
Responsibilities:
- Provide database support for some of the most critical systems at Dow Jones like Dow Jones Industrial Averages, Dow Jones Global Indexes, EDMS II, STATS applications running on Sybase 15.x with OS AIX and Solaris.
- Responsible for Oracle and Sybase database logical and physical database design, implementation and maintenance on UNIX and Windows environment.
- Sybase ASE migration from Solaris to AIX.
- Installed, upgraded and patched Oracle and Sybase software. Setup brand new machines including Oracle and Sybase software installation, Oracle and Sybase side configuration, third party backup software Legato troubleshoot and backup testing.
- Managed and resolved design issues during development.
- Moved database schemas from development to Production.
- Developed some Unix Shell scripts to automate database operation and database monitoring.
- Provided primary Support for many applications like DAMS, GAMS, REPRINTS, EDSYS II, ARCHIVE SERVER, ADSALES dataware house and CCCP Credit card Processing running on Oracle 10GR2 and 11GR2.
- Upgraded Oracle from 9i to 10GR2 and 10GR2 to 11GR2
- Wrote shell scripts to fully automate the restore of PeopleSoft databases from Production to Development and QA using RMAN.
- Upgraded Sybase from 4.8 all the way to ASE 15.5
- Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
- Created new databases and users, setup RMAN backups, Export, and other monitoring scripts.
- Setup bi-directional Sybase replication on DJIA and DJGI systems
- Setup Oracle 10GR2 multi standby databases for CCCP
- Provided 24x7 on call production support.
- Trained new DBA's in our environment.
- Managed a team of BDA's from outsourcing company.
- Setup Sybase IQ on AIX and Windows environment
- Setup Oracle Grid Control 10gR2 on Linux using ASM for monitoring Oracle databases. Setup rules and installed the grid agents. This was a two server configuration with a load balancer. Set up rman repository to backup production, QA and development servers.
Confidential
Sr. System and Database Administration Consultant
Responsibilities:
- Provided system and database administration support for AT T, World Net BCDS Billing Group managing Sybase 11.5 on HP-UX 10.0
- Backup and restore.
- Logical and physical design of database.
- User support.
- Wrote several shell scripts and programs that helped save millions for AT T world net.