PROFESSIONAL SUMMARY

• 6 years of extensive experience as an Oracle DBA in Production, Test and Development environments.
• Designing, modeling, administration, implementation, and troubleshooting, and quality management for several production/test systems on Oracle 9i, 10g, 11g Databases. Involved system administrators groups in designing the logical and physical model of the databases.
• Installation, configuration and upgrade of Oracle 10g, 11g RAC.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Experience as Oracle DBA providing support to many Production, Development, Test, instances comprising of some of the more complex and challenging environments from versions 9i to 11g releases.
• Installing and Upgrading Oracle Server 10g 11gR1, 11gR2.
• Administering Oracle 10g, 11g Instances.
• Multiple upgrades of Oracle server older versions to newer versions.
• Performed Cross Platform migration of Oracle and Advanced Planning and Scheduling from HP to AIX.
• Configuring, Upgrading and installing Oracle Server 9i/10g/11i/11g.
• Troubleshooting and Administration of Oracle 9i/10g/11g Server.
• Oracle 11g Server Enterprise load balanced setup and configuration using multiple Oracle RAC databases for metadata repositories.
• Oracle 10g,11g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager RMAN for backups.
• Implementing High Availability solutions with Oracle 11g RAC, Standby Datagaurd .
• Installing, configuring and maintaining Oracle Grid Monitoring.
• Extensive knowledge in working with the tools like OEM, TOAD, QUEST, Export/ Import, Stats pack, SQL Loader, SQL Analyze, TKPROF, Explain Plan, and Oracle Supplied DBMS PACKAGE.
• Configuring backup software like VERITAS Netback up, Legato Networker for oracle using RMAN tool for backup and recovery.
• Hot and cold Backup and recovery of Oracle 10g, 11g database using tools like RMAN.
• Scripting and scheduling of oracle database backup using RMAN.
• Good experience of Oracle PL/SQL, Procedures, Triggers, Cursors and Functions.
• Cloning of database for development teams, import and export of data.
• Good working Experience on Sun Solaris, Linux, HP-UX and AIX.
• Extensively used oracle tools like TOAD and SQL Developer.
• Experience in writing complex SQL Queries, created materialized views.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.
• Proven ability to adapt to demanding schedules and changing priorities.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Involved and implemented with analysts, developers, programmers and project managers in a project system development life cycle SDLC phases.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCES

Confidential

Oracle Dev DBA

• Working as a Dev DBA for Environmental Protection EPD Branch of state of GA.
• Worked in database design, process re-engineering, application development and the application of technology to significantly improve quality and efficiency in support of agency operations.
• Perform Migration of legacy database to new production environment.
• Upgrading legacy dev and prod db from 10g to 11gr2.
• Created materialized views to achieve replication of production tables into Dev db. And wrote a pl/sql procedure to refresh them every day.
• Working as lead on a project to migrate state's data from legacy environment and map them according to new federal standards and create an XML file to submit the changed data to the destination as per the requirement.
• Configured and installed Oracle database gateway for sql server to complete the requirement of data warehousing environment.
• Created a pl/sql code to stage an updated data into sql server from oracle and scheduled it to run every night.
• Created a new schema, tables, views, indexes, constraints and trigger to manage a staging area for the project.
• Created an ETL procedure to extract and Transform data from production database and load into staging tables.
• Configured a CDX connector to facilitate out bound data flow to CDX virtual node from Production database.
• Successfully installed and configure database gateway for MS SQL server on oracle 11gr2.
• Configured ETL procedure to facilitate data warehousing between sql server and oracle database.
• Administered user access, table space issues.
• Troubleshooting performance issue for one of the ETL procedure for data warehouse.
• Periodically refreshing dev database with production data using expdp/impdp.
• Successfully completed all the projects assigned with documentation in given timeframe.

OS: Windows, Linux

Software: 10g, 11gr2, MS SQL SERVER 2008 R2

Replication Software/ Tools /Utilities: RMAN, OEM, SQL Loader, Expdp, Impdp, Microsoft Access, Excel, Sql Developer, stylus studio 2013,SQL Server Management Studio Express SSMSE

Confidential

Oracle DBA

Responsibilities

• Worked as an RBAC Role Base Access Control DBA in CSO Chief Security Office of AT T.
• Helped ADBA's and ODBA's across the company in order to integrate 800 applications with 6000 Oracle databases into CSP-IDM.
• Maintaining connectivity and troubleshooting connectivity issues of Oracle databases with IBM's CSP-IDM adapter.
• Auditing different privileges of users in order to make them in compliance with the AT T security policy.
• Developed a health check script which systematically connects to all the oracle databases in scope using JDBC thin driver.
• Created a Dev db on sql server for team's testing purposes.
• Management of users, roles and privileges.
• Worked as team lead for group of DBA's in RBAC team.
• Excellent communication skills and strong analytical troubleshooting skills.
• Worked with different offshore DBA's team and Onshore DBA's team in order to onboard their Oracle databases for CSP-IDM integration.
• Excellent knowledge of Microsoft ACCESS for generating reports.
• Identified the root cause of connection error ORA-12514 and worked with development team to implement a graphical user interface for DBA's, so that it can be resolved at front end of the integration.
• Responsible for analyzing designing Identity management, Access management Role base access control solutions for customers.
• Provide support to an Identity Management solution using IBM Tivoli Identity Manager.
• Monitor compliance with information security policies and procedures and access control systems to assure maintenance of appropriate access levels.
• Analyzed and designed Identity Management IDM , Access Management and Role Base Access Control RBAC solutions for various AT T applications.
• Interacted with client staff on daily basis to gather requirements for Identity Management solution on their enterprise servers.
• Designed roles in IDM solution according to the client requirements and also provided valuable suggestion to the clients for improving user and role management.
• Successfully resolved various connectivity issues as a Support Team Lead with in the acceptable timeframes.

OS: Windows, Sun Solaris 10, UNIX, Linux

Software: 10g, 11gr2, Java, JDBC, RMAN, TOAD

Replication Software/ Tools /Utilities: RMAN, OEM, SQL Loader, EXP, IMP, Expdp, Impdp, Microsoft Access, Excel, Sql Developer, sql server management

Confidential

Oracle DBA

Responsibilities

• Worked in 24x7 Production Oracle Databases environment.
• Involved in both managing and supporting more than 1500 instances with 600 databases in Production.
• Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin.
• Maintaining the Oracle Applications Systems including Oracle databases, Middle tier IAS Applications.
• Working closely with Functional/Developers and helping them in issues.
• Creating and sizing of database objects tablespaces, tables, and indexes .
• Database Backup and crash/Recovery both local and remote.
• Documented the Backup and Recovery procedures for all the applications supported by our team.
• Created four node Standby using Data Guard Broker and performed Switchover.
• Management of Users, Roles and Privileges.
• Scripts to monitor online Database objects and SGA.
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Experience in Installing, configuring and administrating database in RAC environment.
• Troubleshoot RAC database by verifying alert logs. Configured Rapid connect-time failover and Transparent Application Failover in RAC environment and working knowledge in Maximum Available Architecture MAA .
• Installed, configured and troubleshoot Oracle Clusterware Cluster Ready Service CRS for RAC. Used Oracle 11g specific features like Automatic Memory Management AMM , Result Cache parameters.
• Adding a Disk group, removing a disk group, movement of data between disk groups in an ASM storage platform.
• Successfully implemented Data Guard on physical, logical standby databases in OLTP environment.
• Replicating the tables, schemas and database using the replicating tool Golden gate.
• Managed Resumable Space Allocation using Resumable Time out parameter.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling with utilities like OLTP, Logical and Physical Database Design, Backup and Recovery procedures.
• Backed-up database and database objects using different techniques such as user-managed backup, RMAN backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Experienced in cloning database using RMAN Duplicate and cold hot backups.
• Performed full database recovery as well as incomplete recovery using Tablespace Point in Time Recovery TSPITR . Knowledge of cross platform migration of databases.
• Implemented Change Tracking File with RMAN and reduced the backup time significantly.
• Hot and cold Backup and recovery of Oracle 11g database using tools like RMAN.
• Maintain database security, user roles and access profiles, Involved in taking cold and hot backups.
• Participated in data model review meetings with other Data designers and Data Architects internally and across multiple teams onsite and offsite.
• Daily monitoring and checking the Background Dump File alert SID Logs and User Dump Files for errors.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.

OS: Sun Solaris 10, UNIX, LINUX

Software: 10g, 11gOEM, RAC Grid Control, RMAN, TOAD

Replication Software/ Tools /Utilities: RMAN, OEM, EXP, IMP, expdp, Impdp, TOAD, Streams, Shareplex, DataGuard, Golden Gate.

Confidential

Oracle DBA

Responsibilities:

• Responsible for maintaining Oracle 10g/11g databases for different clients
• Implement Physical Standby database for High availability Disaster Recovery using Data guard.
• Performed cross platform migration from Solaris to Linux using Transportable Table space TTS .
• Installed, Configured and deployed SOA on single node and cluster node.
• Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces for source and target Data Mapping and Packages.
• Tested different Journalizing Knowledge Modules to ensure better performance.
• Good knowledge of data warehouse architectures, concepts and technologies.
• Conceptual data modeling logical and physical data modeling.
• Cloning and Patching.
• Working knowledge of non-Oracle database migration to Oracle database by using Oracle SQL developer IBM DB2 8 to Oracle 10g .
• Good understanding in data modeling, entity-relationship modeling.
• Implemented cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and AWR.
• Reviewed the procedures and methods used to manage the staging and production data feeds all via materialized views replication .
• Configuration of OEM11g.
• Applying Oracle Applications patches Maintenance Pack, Interoperability patch, Family pack, one offs Patches etc .
• Expert knowledge of oracle data-dictionary configuration of Oracle Enterprise Manager OEM : DB Control, Grid Control 9i/10g/11g.
• Skilled in database upgrades 9i to 11gr2 and 10g to 11g.
• Oracle 11g RAC Database setup and administration using Oracle Recovery Manager RMAN for backups.
• Oracle 11g Application Server Enterprise load balanced setup and configuration using multiple Oracle RAC databases for metadata repositories.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, and Responsibilities for the user.

OS: Sun Solaris 10, UNIX, LINUX

Software: 10g, 11gOAM, OEM Grid Control, RMAN.

Replication Software/ Tools /Utilities: RMAN, OEM, EXP, IMP, expdp, Impdp, TOAD, Shareplex,

Confidential

Oracle DBA

Responsibilities:

• Creating and sizing of database objects tablespaces, tables, and indexes .
• Database Backup and crash/Recovery both local and remote.
• Documented the Backup and Recovery procedures.
• Management of Users, Roles and Privileges.
• Database performance tuning, table sizing and administration.
• Scripts to monitor online Database objects and SGA.
• Diagnose the bottlenecks and problems causing poor performance.
• Database reorganization to minimize fragmentation.
• Rebuilding indexes for faster access and to reduce disk I/O.
• Data extraction and Loading using Export/Import and SQL Loader.
• Responsible for security on production database like creating roles and provide access to application schemas to users and maintain separate table spaces for data, indexes and temporary applications.
• Created different synonyms views as per business needs. Created materialized views and snapshots for high end application usage.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Experience in implementing hot, cold and RMAN backups and performance tuning of SQL statements

OS: HP-Unix, AIX, Linux, Windows, Solaris,

Software: Oracle database 8i 9i.