SUMMARY

• Certified Oracle DBA with experience (11+ years) in the software industry as an Oracle DBA carrying out activities on platforms like AIX, Sun Solaris, Linux, Windows NT/XP, and Windows 2008 Server.
• Duties included installation, patching, upgrading, performance tuning, space allocation and maintaining Oracle Server according to Oracle OFA Standards.
• Installed and configured Oracle 10g, 11g (11.2.0.3) ASM, 12.2 and 9.2.0.8 for migration to production environment.
• Implemented & maintained backup & recovery program using rman for all database servers.
• Monitored Oracle 10g, 11g, 12.2 database backup procedures.
• Performed media recovery when required.
• Mentored Jr. to Senior Level DBA’s to gradually assume production responsibilities.
• Extensive involvement in data capturing, cleansing, extraction, transformation and transportation of existing operational data to current enterprise wide analysis systems.
• Experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using ETL Tools i - Way ETL Manager, DTS, Modeling Tools Erwin and Oracle Designer 2000, Reporting Tools like Crystal Reports 8.X/7.0/6.0).
• Thorough knowledge of database management concepts like conceptual design, logical design, physical data modeling and data definition, population and manipulation.
• Expert in database creation, maintenance and query optimization for applications.
• Expert Oracle 11g/10g/9i/8i/7.x, Developer 2000, PL/SQL, and UNIX Shell Scripting on UNIX versions (Sun Solaris 2.x, AIX, HP-UX).
• Master in design and development of tools for data migration and data synchronization from one application to another using various Oracle utilities (Bulk loader, External table from Oracle9i, ODBC).
• Developed test plans, test plans and test requirements for Manual, regression & performance testing.
• Developed ETL process using i-Way ETL Manager to load the Data Warehouse from other RDBMS, XML data sources, COBOL sources, applications and flat files systems.
• Experience in handling various database management systems (relational (RDBMS), sequential, nested (XML) and knowledge discovery suites (KDD)
• Self-motivated and a proactive leader with superb technical acumen and exemplary communication skills.
• Ability to create, implement and improve IT standards, policies, and procedures.
• Capable of quickly grasping and applying cutting-edge ideas, methods and technology.
• Skilled in migrating data and systems to latest programs and technologies.
• Strong leadership, project management, documentation, interpersonal, analytical, organizational, technical, administrative and conflict resolution skills.
• Effectively managed important projects and programs in fast-paced, time-critical environments.
• Skilled in the full project lifecycle, including initial concept, requirements, design, development and delivery.
• An intelligent and responsible database programmer, fast learner, possesses excellent technical abilities and skills developed by a strong work ethic and self-learning.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis MO

Oracle Database Administrator

Responsibilities:

• Implemented and maintained the database designs.
• Created database objects (tables, indexes, etc.)
• Wrote database procedures, functions and triggers
• Assisted developers with database activities
• Tuned database queries
• Worked with ASM/CRS on Oracle 10g and 11G and RMAN
• Monitored application related jobs and data replication activities
• Providing production support for 24X7 database availability for Oracle and SQL server Databases.
• Maintenance and monitoring of oracle 11g/12.2 database instances hosted on Windows and Linux platform.
• Upgrade and Migration of Databases from 10g R2 to 11g R1 to 12c and applying patches as per requirement.
• DBA activities such as configuring Grid events, Regular Backup’s, Oracle Golden Gate Replication, Tuning, and troubleshooting performance issues.
• Simulate a copy of production databases into test databases for application upgrade testing.

Confidential, St. Louis MO

Oracle Database Administrator

Responsibilities:

• Implemented and maintained the database designs.
• Created database objects (tables, indexes, etc.)
• Wrote database procedures, functions and triggers
• Assisted developers with database activities
• Tuned database queries
• Worked with ASM/CRS on Oracle 10g and 11G and RMAN
• Monitored application related jobs and data replication activities
• Providing production support for 24X7 database availability for Oracle and SQL server Databases.
• Maintenance and monitoring of oracle 11g/10g database instances hosted on Linux and Sun platform.
• Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
• DBA activities such as configuring Grid events, Regular Backup’s, Oracle Golden Gate Replication, Tuning, and troubleshooting performance issues.
• Simulate a copy of production databases into test databases for application upgrade testing.

Confidential, St. Louis MO

Oracle Database Administrator

Responsibilities:

• Implemented and maintained the database designs.
• Created database objects (tables, indexes, etc.)
• Wrote database procedures, functions and triggers
• Assisted developers with database activities
• Tuned database queries
• Worked with ASM/CRS on Oracle 10g and 11G and RMAN
• Monitored application related jobs and data replication activities
• Providing production support for 24X7 database availability for Oracle and SQL server Databases.
• Maintenance and monitoring of oracle 11g/10g database instances hosted on Linux and Sun platform.
• Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
• DBA activities such as configuring Grid events, Regular Backup’s, Oracle Golden Gate Replication, Tuning, and troubleshooting performance issues.
• Simulate a copy of production databases into test databases for application upgrade testing.
• Helped with Sybase 15 and Informix databases in troubleshooting.

Confidential, St. Louis MO

Oracle Database Administrator

Responsibilities:

• Providing production support for 24X7 database availability for Oracle and SQL server Databases.
• Maintenance and monitoring of oracle 11g/10g database instances hosted on Linux and Sun platform.
• Worked with Sybase 15 database issues like starting up and shutting down and checking space usage.
• Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
• DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.
• Simulate a copy of production databases into test databases for application upgrade testing.
• Support and advise the development teams on database related issues.
• Assisted developers in tuning SQL statements in the applications.
• Performance tuning of SQL Server and Query Optimization
• Space Management which includes table space creation, adding new data files.
• Managed Table spaces, Rollback Segments, Redo Logs and other database object.
• Oracle installation, creation of database, which includes physical and logical design.
• Assisted developers in creating stored Procedures, Triggers, Functions, Cursors and Packages.
• Involved in support for 1TB 2 Node production RAC database.
• Responsible for monitoring and resizing Oracle database objects (Table spaces, Tables, Indexes etc,
• Responsible for memory and Application tuning of the databases using Oracle utilities like OEM,SQL Trace, TK Prof and Explain Plan.
• Partitioning of large tables for fine tuning performance.
• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup plans.
• Taking periodic Backup of the Database and the software using Recovery Manager and VERITAS.
• Generated regular Stats-Pack reports for the performance tuning of the databases.
• Experience with DBUA/Export and Import/Datapump to migrate the database.
• Responsible for optimizing data access and performance by tuning indexes.
• Performed Replication of the Production database for setting up instances for the QA and Testing teams.
• Hands on experience in writing UNIX Shell Scripts..
• Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self tuning purposes.
• Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks.
• Helped with Sybase 15 and Informix databases in troubleshooting.
• Worked with ASM/CRS on Oracle 10g and 11G and RMAN

Environment: ORACLE, SQL Server, SQL*Plus, Oracle 11g/10g, IBM AIX, RAC, Oracle Enterprise Manager, Data Guard, ASM, PL/SQL, RMAN, Toad.

Confidential

Oracle Database Administrator

Responsibilities:

• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
• Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP .
• Installed, and patched Oracle software and associated applications.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and ‘rewind’ entire database to a particular time respectively.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Coordinated with .Net programmers and SQL Server developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.
• Created and maintained all databases required for development, testing and production usage.
• Worked as part of a team and provided 24/7 support when required.
• Established and maintained sound backup recovery and procedures.
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
• Experience in configuring Data guard 10g R2 for physical standby database.
• Experienced in managing data guard configuration using DGMCRL tool.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.

Environment: Oracle10g, IBM-AIX, RMAN, SQL*Plus, SQL, PL/SQL, SQL*LOADER,Oracle OEM, Putty, Oracle Data Integrator.

Confidential

Data Architect/Database Administrator/System Analyst

Responsibilities:

• Loaded data into db2 database tables from Siebel data source (Oracle production database) using i-Way ETL Manager based on different data requirements for reporting.
• Created partitioned tables, views, and indexes. Converted SQL code into Focus code and vice versa for the performance.
• Created jobs to load data to data warehouse database on daily, weekly and monthly basis. Monitoring jobs was one of the main tasks.
• Database creation, database space management, performance tuning, monitoring applications, installing patches / upgrades, backup & recovery and documentation.
• Reporting of problems to Oracle: This involved getting the latest patches and upgrades from Oracle and keeping in touch with the latest technologies of Oracle related products.
• Back up of Database: I formulated a Backup and Recovery procedure using rman for each application depending on the usage of the application. This involved a combination of Exports and Operating System Level Backup.
• Created 10g database and used data pump (expdp, impdp) to export and import data. Tuned the database optimization. Installed Enterprise Manager and used its features.
• Upgraded 9i production databases to 10g.

Technical Environment: i-Way ETL Manager, SQL Server, Oracle 8i, 9i, 10g, rman, DB2 Database, Focus Coding, Web Focus Reporting, Windows 2000, Rational Rose