SUMMARY

• 11 years of experience as OCI Architect and Oracle Database Administrator in various domains such as Aviation, Retail, Telephony, Finance.
• Experienced in using different versions of Oracle 8i, 9i, 10g, 11g, 12c Database.
• Managing and creating oracle database, Oracle Storage Structures
• Creating and administrating database objects like table, views, indexes etc.
• Expertise in user account management like creating users, disabling users, responsibility management
• Performing Export & Import operations
• A deep working understanding of the Oracle E - Business Suite and it’s underlying technology stack, as well as that of related Oracle components (Portal, Single Sign-on, Fusion Middleware, OBIEE etc)
• A broad technical understanding of infrastructure technologies, such as data centres, servers, networks and storage subsystems
• Experience of project environment planning to ensure that all development and test systems are available in line with project plans
• Systems sizing and capacity planning
• Experience of the design and deployment of Oracle software across a range of infrastructure technologies
• An understanding of good practice deployment techniques for Oracle software, to suit client requirements
• Skilled in maintaining several Database instances running on Windows & UNIX environments
• Handled oracle Database upgrades/migration from 8i to 9i, 9i to 10g and above versions
• Proficient use of advanced replication using Oracle Streams and experience in using utilities like TOAD, SQL Developer, SQL*Plus, SQL*Loader, data Migrations using export/import as well as traditional UNIX command that requires for Oracle DBA.
• Installation of servers and clients
• Hands on Knowledge in NoSQL Databases (Mongo DB and Casandra).
• Extensive experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM.
• Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• PL/SQL development experience of all types of SQL DML statements - functions, stored procs, triggers
• Experience in working with Application Development teams
• Extensive SQL tuning experience to improve query performance.
• Proficient in Oracle Enterprise Manager, grid agent installation, OSM patching, alert notifications, job scheduling, adding and monitoring targets by grid.
• Highly accomplished in Performance Tuning.
• Sound Knowledge in Backup and Recovery procedure which includes documenting the process
• Highly accomplished in Performance Tuning
• Skilled with Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes
• Hands on experience in Recovery Manager (RMAN)
• Exposure to RAC Implementation, ASM, cluster event issues
• Good knowledge and experience in SOA maintenance, ESB, BPEL service check, Queuing de-queuing in SOA DB
• Experience in Security infrastructure including Oracle Virtual Directory.
• Experience in installing and configuring Golden Gate 11g/12c and using replication procedures to support data replication in the Oracle database environment.
• Experience in building Standby databases; Implementing FSFO (Fast start failover) on 11G databases and configuring disaster recovery site using Dataguard.
• Modeling and designing Data, OLAP, Logical and Physical Database Design of tables, tablespaces, Users, roles, privileges, creating storage structures or using ASM and Performance Tuning. Experienced in IBM Optim archival solutions
• Configured development and QA environments to meet Data Privacy, Data Masking and Data Sub-setting requirements using IBM Infosphere Optim Test Data Management (TDM) services.
• Sound Knowledge in performing production support activities, Involving in P1,P2 on-call bridges
• A proactive team player, quick learner, Self-motivated, hardworking professional with good organizational, leadership, project co-ordination, interpersonal, excellent analytical, problem solving and troubleshooting skills with result-oriented attitude towards work.

TECHNICAL SKILLS

Database: Oracle 9i,10g,11g,12c

OS: Linux 4.0, Windows 2000 Advanced Server, UNIX

Oracle Tools: Oracle Enterprise Manager (OEM), Oracle Database Configuration Assistant (DBCA), Oracle NET 8 Configuration Assistant, RMAN, SQL*Plus, SQL*Loader, Export/Import, Golden gate

Design Methodologies: Waterfall, Agile

Ticketing Tool: Jira, Remedy, Service Now

Version Tools: Git, SVN, CVS, VSS(Visual Source Safe)

PROFESSIONAL EXPERIENCE

Confidential, TX

Senior Oracle Database Administrator

Responsibilities:

• Involved in the complete Decommission Database for 70+ applications like Enterprise, Shared Services, Digital, HR, Finance
• Provide end to end support in issues while Scream test fails
• Analyze application flaws checking for CPU waits, server parameter issues, SGA related issues long running customized JAVA application
• Deployment of war files and configuration of application with Database while restoring application from failed scream test
• Extensively involved in migration of Databases to Oracle Cloud Service.
• Work on SOPs of network access, VIP, storage disable and remove environment.
• Active support in Server Decommission
• Proactive in application and BU owner follow ups for New Cloud DB creation and decisions on database sizing and decommissioning after migration
• Involvement in compression on database moving less important database to Mongo DB, MS Access DB
• Perform migration from existing environment to Oracle Cloud Services
• Perform Export/Import from traditional database to Cloud service
• Oracle E-Business Suite implementation and it’s underlying technology stack, as well as that of related Oracle components (Portal, Single Sign-on, Fusion Middleware, OBIEE etc)
• Understanding and Migration infrastructure technologies, such as data centres, servers, networks and storage subsystems
• Experience of project environment planning to ensure that all development and test systems are available in line with project plans
• Systems sizing and capacity planning
• Experience of the design and deployment of Oracle software across a range of infrastructure technologies
• An understanding of good practice deployment techniques for Oracle software, to suit client requirements

Confidential - Irving, TX

Senior Oracle Database Administrator

Responsibilities:

• Involved in the complete Database Support for 15+ applications like HR, Finance, Risk & Compliance
• Provide end to end support in CPU/Memory issues while UAT load testing fails
• Analyze application flaws checking for CPU waits, server parameter issues, SGA related issues long running customized JAVA application
• Extensively involved in AWR, ASH, ADDM working on memory recommendations for Database
• Work on Access policies and privileges in highly secure environment.
• Worked on golden gate replication.
• Active support in Server Decommission
• Proactive in SLTN follow ups for New Cloud DB creation and decisions on database sizing
• Hands on experience on OCI, User creation, VCN creation, load balancer monitoring, migration to ORaaS Cloud
• Involvement in compression on database, tables, indexex
• Perform migration from existing environment to Oracle Cloud Services
• Work on Access policies and privileges in highly secure environment.
• Worked on golden gate replication.
• Responsible for performance tuning of large partitioned tables
• Perform Export/Import from traditional database to Cloud service

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Involved in the complete Database Support for 8 applications like SIEBEL CRM, Sabre, OBIEE, SOA.
• Provide end to end support in OBIEE db issues while installation and upgrade.
• Analyze application flaws checking for CPU waits, server parameter issues, SGA related issues long running SIEBEL queries.
• Extensively involved in Backup and Recovery, RMAN configurations, deciding backup strategy, working on failed backup jobs.
• Work on multiple user stories in Agile methodology like new script generations and implementation, report generation, health check routine automation.
• Skilled in setting new standby environment, Standby synchronization with production databases
• Worked on golden gate replication.
• Active support in SSFP release in AA.
• Perform Export & Import operations.
• Synchronization of Dataguard with primary databases
• Suggestion in code changes in stored procedures, views, functions and triggers to reduce operation cost of statement.
• Efficiently work on JIRA tickets raised by application teams.
• Configured development and QA environments to meet Data Privacy, Data Masking and Data Sub-setting requirements using IBM Infosphere Optim Test Data Management (TDM) services.
• Excellent back end skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, and functions.
• Proactively monitor OEM peak loads, notification alert, failed jobs, and configure new jobs in OEM.
• Creation and implementation of new prod-like environment.
• Installation and upgrade on Oracle Database 12c.
• OEM job creating on all environments. OEM patches and upgrades.
• Hands on experience in RAC Cluster issue resolution.
• Involved in release Documentation.
• Replication using Golden Gate, checking errors and synchronization issues
• PL/SQL development experience of all types of SQL DML statements - functions, stored procs, triggers
• Active partition in daily status scrums, Bi-weekly client meetings.
• Mentor for L1 team members and arrange various knowledge sharing sessions.

Environment: ORACLE 11g/12c/13c, OEM 12c, Golden Gate, Linux, Solaris, Jira, SIEBEL CRM, OBIEE, SOA, SQL developer, TOAD, putty

Confidential

Oracle DBA

Responsibilities:

• Proactively working on Production Support activities.
• War room support specialist in Black Friday, Thanks giving, cyber Monday.
• Expertise in handling team of 15 DBAs, ticket allocation, ticket report creation and chart presentation on behalf of DBA team.
• Attending L3 meetings and discussion on new database RFPS like upgrades, service creation.
• 24*7 On call support for P1, P2 issues, attending bridges, providing timely updates on P1 issues.
• Supporting application teams in respective CRs.
• SME for Optim Archival solution from IBM, creating optim job script, scheduling and deciding archival and purging strategy. On call support in Optim issues.
• Kernel parameter changes support, OS watcher enabling disabling.
• Skilled in handling ASM issues, SAN issues, disk failures.
• Exposed to various Oracle applications Oracle Retek, Oracle Ego handling Database and application issues.
• Experience in backups and recovery such as checking failed jobs, scheduling/updating backup jobs, deciding backup strategy for new database, maintaining cold backup details.
• Experience with handling MY SQL database issues.
• Handled large databases sized 250G-15T.
• Active participation in cluster issues, service load balancing issues.
• Proactively working on creation of new standby environment.
• Monitoring long running sessions, locks, hanging sessions.
• Performance tuning expertise.
• Analyzing index, gather table statistics.
• Experience in working with Application Development teams
• Maintaining and suggesting partition details.
• Working on lower environment refreshes.
• Maestro job scheduler job creation and support.
• Exposed to service now tool.

Environment: Oracle 10g/11g/12c/13c, OEM 11g/12c, Oracle Retek, Oracle Ego, HPOV, Netapp, Maestro scheduler, IBM Optim, Protegirty, Service Now, TOAD, SQL Developer, Win SCP, putty

Confidential

Database Specialist

Responsibilities:

• Active involvement in OSM installation and configuration, handling DB issues, access controls while OSM upgrade.
• Support in day to day application maintenance in production and lower environments like tracing session, generate/analyze tkprof, long running sessions monitoring.
• Perform multiple Export/Import.
• Release support like new SOA(CHOIS) services launch, configuration/issues checking in access logs and error logs in SOA database.
• KAS-FUTUR billing application production and lower database support involves checking out hanging transactions in MQ/DB, working in database CRs.
• Generating and analyzing AWR report.
• Automation of backup scripts, scheduling cron jobs.
• SIEBEL DB support understanding queries and suggesting performance improvement solutions.
• Gather statistics on schema/ tables, rebuild indexes.
• Analysis on OSM database and implementation of partitioning tables, maintaining partitioned tables.
• Successful OEM 10g installation, OEM PSU release.
• Working on ERD and Data modeler for new DB objects getting launched in service, extensive use of MS-Visio.
• Handling privacy and user access control on all database environments.
• Automation of jobs like creating on demand shell scripts, ASM disk space usage, archive space usage, server cleanup utility.
• Daily ETL jobs status check and database error resolve.
• Extensive use of Remedy.
• Establishing relationships among them, defining mechanisms for managing different application’s databases, working on changes that are imposed, auditing and reporting on the changes that are made.

Environment: Oracle 9i/10g, OEM 10g, OSM, SIEBEL CRM, SOA, Netapp, Remedy, TOAD, SQL Developer, Win SCP, putty, Windows Server

Confidential

Database Administrator

Responsibilities:

• Production support activities such as handling L2 tasks executing changes on production and lower environments.
• Handling Oracle database installation, patching on lower environments.
• Perform Export/Import.
• User creation and maintenance, access control, security clearance.
• Database monitoring for performance issues.
• Responsible for SIT and UAT database issues.
• Data retrieving, querying, storage and manipulation and also performed Unit test on Cashplus product.
• Monitoring & Managing the Tablespaces and datafiles growth.
• Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.
• Regular checking of Alert log file.
• Responsible for taking full cold database backup.
• Data upload using SQL* loader oracle utility.
• Handled oracle Database upgrades/migration from 8i to 9i
• Maintaining CVS updates as per each releases specific to banks.
• Schema creation and maintenance on lower environment as per product enhancements.
• JP1 job scheduler job creation and updating.
• Active participation in production support weekly meetings.
• Working on multiple JIRA issues.

Environment: Oracle 8i/9i/10g, OEM 10g, OSM, SIEBEL CRM, SOA, Jira, TOAD, SQL Developer, Win SCP, putty, Windows Server

Confidential

Responsibilities:

• Working as production support specialist DBA on Powerfit Product for cash management.
• Active participation in archival and purging releases from documentation, meetings, and script creation, scheduling and execution.
• Installation of Websphere MQ5.3, testing on lower environment.
• Implementation MQ upgrade project 5.3 to 6 lower environment to production.
• Installation of WAS 6.0, testing database connection, end to end flow of transaction.
• Understanding of Powerfit product and responsible for daily reports before Zengin Tsushin.
• Implementation of multiple services for different messages (kyoyo,kyoyo2, Tsushins) and providing database support for each failed messages in system.
• Solely handling lower environment refreshes.
• Extensive working on shell script creation and updating existing script as per release requirements.
• Handling Confidential password maintenance policy issues on daily basis.
• Bringing up/down services in case of scheduled releases.
• Active participation in Database upgrade release, user creation, maintenance.
• Archival purging data specialist, script creation and implementation.
• Working on Oracle 8i to 9i upgrade, schema backup and migration
• Responsible for user security clearance for services, updating accesses of services as per role change
• Handled oracle Database upgrades/migration from 8i to 9i
• Participation in meetings, creating change requests initial draft.
• Working on multiple database changes at a time.

Environment: Oracle 8i/9i/10g, OSM, SIEBEL CRM, SOA, Jira, TOAD, SQL Developer, Win SCP, putty, Windows Server