Sr.oracle Dba Resume
2.00/5 (Submit Your Rating)
SUMMARY:
- Oracle Database Administration (12c, 11g, 10g, 9i, 8i) Database Administrator.
- MySQL DBA (v4x, 5x).
- Oracle Golden Gate administration (v11x, 12x).
- Experience with many operational environments and software applications including all Windows OS’s, Linux, Confidential AIX, HP - UX and Sun Solaris UNIX servers.
- Over 20 years of experience in the IT industry including 15 years of Oracle Database Administration. The last 15 years of my career focus has been in the area of Oracle8i, Oracle 9 i, Oracle 10, Oracle 11g, Oracle 12c RAC and Standalone Database Administration, Performance Tuning, Installs, Upgrades, Configuration, and documentation, Operation Support and RMAN Backup and Recovery. I have strong skills in database administration, migration, upgrades, performance tuning, operations support, backup and recovery and database hardening. I am also accomplished in Implementing Database Auditing and Audit Reports via Entgra Software. I also specialize in other Oracle tools like Toad, Quest Central for Oracle, Oracle Enterprise Manager, RMAN, Data Guard, Data Pump, APEX, Golden Gate replication, GRID Control and DB Console.
- I am very proficient in applying Oracle Patches, Database Tuning and Oracle version upgrades. I am also proficient in supporting Oracle RAC and Oracle Standby databases (Logical and Physical). I am Proficient in supporting Golden Gate Replication administration for versions 11 and 12.
- A few of my most recent accomplishments include documenting and upgrading several Oracle RAC 11g databases and GRID/CRS to version 12c successfully, I’ve also successfully implemented Oracle Golden Gate upgrade from version 11 to version 12.
TECHNICAL IT SKILLS:
- Oracle8i, Oracle9i, Oracle 10g, Oracle 11g and Oracle 12c database administration within a standalone, HA cluster, Oracle RAC, Data Guard and Golden Gate Replication environments.
- SQL*Plus, SQL and PL/SQL administration
- RMAN Backup and Recovery implementation and administration.
- Oracle Data Guard support and administration.
- Oracle Golden Gate support and administration.
- Oracle DB Console implementation and administration.
- MySql Database support and administration.
- DB2 Database support and administration.
- Oracle Enterprise Manager.
- Oracle Data Pump and Import/Export.
- Oracle APEX implementation and administration.
- Crystal Enterprise and Crystal Reports.
- Oracle Client Installation and Configuration.
- Confidential AIX, SUN Solaris Sparc 64, Linux Red Hat and Windows OS.
- Toad, Quest Central for Oracle.
- Lumigent Entegra for Oracle .
- Oracle Golden Gate replication support and administration.
- SharePlex for Oracle
- TDE (Oracle Transparent Encryption).
PROFESSIONAL EXPERIENCE:
Confidential
Sr.Oracle DBA
Responsibilities:
- Support over 3000 databases which include: Oracle, MySql, DB2, SQL Server and Sybase.
- Responsible for documenting database procedures and database change steps for change management, Database Maintenace and incident management.
- Mentor and Assist Jr. and Mid Level DBA’s.
- Perform database administration tasks including (Upgrades, patching, software install, creating databases, database refresh, RMAN restore and recovery, performance tuning, resolve database outages and alerts.
- Administer and Support MySQL databases.
- Administer and Support DB2 databases.
- Administer and Support MS-SqlServer databases.
- Administer and Support Oracle Golden Gate Replication.
- Administer and Support Oracle Dataguard.
- Support and Configure TDE (Transparent Data Encryption).
- Perform Root Cause Analysis for database outages and issues.
- Work with database Vendor Support to resolve Sev 1 issues.
- Attend weekly status meetings with clients and management.
Confidential
Sr.Oracle DBA
Responsibilities:
- Support over 3000 databases which include: Oracle, MySql, DB2, SQL Server and Sybase.
- Responsible for documenting database procedures and database change steps for change management, Database Maintenace and incident management.
- Mentor and Assist Jr. and Mid Level DBA’s.
- Perform database administration tasks including (Upgrades, patching, software install, creating databases, database refresh, RMAN restore and recovery, performance tuning, resolve database outages and alerts.
- Administer and Support MySQL databases.
- Administer and Support DB2 databases.
- Administer and Support MS-SqlServer databases.
- Administer and Support Oracle Golden Gate Replication.
- Administer and Support Oracle Dataguard.
- Support and Configure TDE (Transparent Data Encryption).
- Perform Root Cause Analysis for database outages and issues.
- Work with database Vendor Support to resolve Sev 1 issues.
- Attend weekly status meetings with clients and management.
Confidential, Beltsville, MD
Oracle DBA
Responsibilities:
- Working as an operations shift DBA which consist of:
- Executing user provided sql scripts.
- Investigate and resolve Database issues and or performance issues.
- Install and upgrade Oracle software.
- Create new Oracle databases.
- Manage and monitor database tablespaces.
- Create and support Oracle standby databases.
- Administer Oracle RAC databases.
- Create and update all service tickets for database changes and issues.
- Complete DBA projects and communicate project status to management and team.
- Attend team, project and management meetings.
- Implement new Oracle database features.
- Apply Oracle Patches to 10g and 11g databases as needed.
- Upgrade and migrate Oracle databases.
- Add additional tablespace to databases.
- Respond to all Oracle alarms received from monitoring alerts.
- Refresh databases using data pump or cloning technique.
- Rotate on-call duties with DBA team.
- Support production systems locally and remotely via VPN.
- Create DBA documentation for DBA administration procedures.
- Backup and Recover Databases using RMAN.
Confidential, Merrifield, VA
Oracle DBA
Responsibilities:
- Work on Remedy Helpdesk tickets assigned to me for resolution which consist of
- User access or termination requests.
- Database outage or performance issues.
- Assistance with sql tuning.
- Adding more tablespace.
- New Database Creation Request.
- Oracle parameter modification.
- Create new change tickets and Releases for upcoming and approved database changes.
- Complete DBA projects and communicate project status to management and team.
- Attend team, project and management meetings.
- Implement new Oracle database features.
- Apply Oracle Patches to 10g and 11g databases as needed.
- Upgrade and migrate Oracle databases.
- Add additional tablespace storage to databases.
- Respond to all Oracle alarms received from BMC and DBA monitoring shell scripts.
- Refresh databases using data pump or cloning technique.
- Rotate on-call duties with DBA team.
- Support production systems locally and remotely via VPN.
- Create DBA documentation for DBA administration procedures.
- Work with ASM, NetApp, Thumpers and Hitachi SAN Storage.
- Backup and Recover Databases using RMAN.
Confidential, Springfield, VA
Oracle DBA
Responsibilities:
- Assures the quality of data in the Company’s production environment.
- Implements and maintains new and modified databases from test to production environment while following existing change management guidelines and procedures.
- Provides database support during the development, enhancement, and on-going production use of the Company’s production applications.
- Works with business unit, applications development, technical support, and operations staff during the design, development and implementation of database applications.
- Advises business unit and applications development staff to better utilize relational databases and the Company’s computing environment.
- Conducts ongoing assessment of database performance, resource requirements, and the identification of problem areas.
- Develops and/or maintains a security scheme for the database environment.
- Performs database backups and recoveries including disaster recovery.
- Ensures continued security and integrity of databases.
- Develops necessary standards and procedures for effective use of the Data Dictionary/Directory and for efficient data base design.
- Assists project development teams in defining data element attributes to the Data Dictionary/Directory.
- Maintains Data Dictionary/Directory definitions and software.
- Currently administering 30 plus Oracle8i, 9i and 10g databases on 6 different servers (Windows 2003 and UNIX AIX P670 and P650) to total more than 1.5 Terabytes of DB size.
- Maintaining OLTP, Web Base and Data Warehouse databases in 24x7 Production environments located locally and remotely in New Jersey.
- Successfully design and configure all Databases, to ensure security and Oracle Flexible Architecture (OFA).
- Also responsible for refreshing Development databases with data from Production as per the requirements of the clients using ( CLONING) or (EXPORT/IMPORT) method.
- Check and Monitor Oracle alert logs and OS logs for errors.
- Document all new changes made to production database objects and request approval via change management system (DIMENSSIONS).
- Upgrading of Database from lower version to higher version and Installation of Patches and bug fixes.
- Plan for system growth and monitor capacity usage of Server Resources and Performance for new hardware or software requirements.
- Attend weekly meetings to discuss current and future projects.
Confidential, Wash, DC
Network Systems Consultant
Responsibilities:
- Provide desktop/network support and administration for a 3,500-node enterprise network currently running Windows NT and Novell.
- Provide internal and external support to help desk consultants, clients, and Project Managers of Confidential .
- Assisted with implementation, migration and upgrading of Confidential computer systems.
- Provide various computer and network related services including System Integration, Network Administration, Network Connectivity, Electronic Mail and Internet Access.
- Assisted with distribution & installation of network servers, printers and high-powered workstations.
Confidential, Wash, DC
Senior System Technician
Responsibilities:
- Responsible for identifying and resolving hardware and software problems in the required response time and repair time.
- Provided documentation and tracking of all relevant PC/ network problems and solutions.
- Administered various operating systems and application in a mixed NetWare & NT environment.
- Supervised and Mentored junior level PC Technician while performing various duties and responsibilities.
Confidential, Wash, DC
Computer Support Specialist
Responsibilities:
- Supervised new PC upgrades and rollouts via ghost imaging software, which required proper planning and coordination with 300 users.
- Administered various operating systems and applications in a mixed NetWare & NT environment.
- Exercised superior customer relations & communication skills.
- Hardware included various models of Dell and Compaq PC’s. Printers included various models of Hewlett Packard.
- Duties included administering Users accounts using NetWare administration and NT server administration.
- Provided support for Lotus Cc mail, Microsoft office and various third party applications.
- Installed and upgraded PC systems upon customers request with minimal down time.
- Responsible for implementing Windows NT Workstation Standardization and Security.