SUMMARY

• To achieve a challenging position in the area of database development and administration, and to contribute all my efforts to the organization with efficiency and proficiency.
• Have 14+ years of experience in Oracle Database Administration on Linux, Windows and UNIX environment and 1.5 years of experience on Apache - Cassandra administration.
• Supporting 24X7 enterprise production/non-production oracle databases on UNIX (Linux, AIX and Solaris) OEL platforms and Windows platforms.
• Involved in the planning, analysis, design, implementation, maintenance, and control of the databases.
• Oracle Golden Gate configuration and administration. Configured bi-directional and unidirectional replication between databases.
• Good experience in troubleshooting Oracle Golden gate issues.
• Oracle Software Installation 12c/11g/10g, Upgradation, migration, Client Installation, Database creation & its objects, Tablespace management, File system standards. Scheduling Cron jobs.
• Database Upgrades and migration from oracle 9i and 10g to 11g and 11g to 12c.
• Experience in Oracle Transparent Data Encryption (TDE) for enhanced security.
• Experience in Oracle data encryption and security (SSL, TLS, TDE, Advanced security and Network Security).
• Experience in Oracle cloud control management.
• Experience on creating key spaces in Datastax environment.
• Experience on adding nodes and DC (Data centres) to the Cassandra ring.
• Experience on scheduling jobs (Backup, swift backups and graphs) on DSE OpsCenter.
• Schema management activities like Create/Drop database users, Create Roles, Grant Roles/Privileges, Create/Modify Profiles and Password reset.
• Maintenance and troubleshoot for production/non-production DB instances configured on RAC.
• Experience in Oracle ASM 10g/11g ASM disk group management.
• Installation of OEM13c and upgrading the EM agents and configure new agents in EM and add on packages like Oracle golden gate.
• Applying GI PSU (oracle 11gr2 RAC) & standalone PSU on quarterly basis.
• Experience in maintaining/troubleshooting DB instances configured on high availability solutions such as Oracle RAC services and workload balancing using Server Pools.
• Experience in configuring/troubleshooting Oracle Data guard & Standby database. Monitor/Identify the log gaps and resolve any issues.
• Coordination with Oracle support to resolve issues through raising SR.
• Experience in working on AWR/ADDM reports, SQL Tuning Advisor, TK Proof and Explain Plan.
• Data refresh from production to non-production environments through RMAN hot backup, Cold Backup, Export/Import & Data pump utilities. Experience in RMAN backup and recovery tool.
• Monitoring Databases using OEM Grid control and adding Cluster and Database services in OEM Grid for new servers.
• Enabling auditing on the objects and monitoring on the indexes drop them if they are not in use.
• Experience on EXADATA.
• Knowledge on Couchbase (NoSQL) database,
• Prime responsibilities for DBA activities - Logical/ physical design of databases, defining of roles, profiles etc., backups, connectivity to database.
• Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.
• Experience in Re-indexing, Replication, Mirroring, Updating Statistics and performing other maintenance tasks.
• Experience - Very strong in ITIL processes on Change Management, Problem Management, Incident Management and ITIL Process related activities.
• Good team player, attitude with the ability to work independently.
• Excellent verbal, written, and interpersonal communication skills.

TECHNICAL SKILLS

RDBMS: Oracle (9i, 10g, 11g 12c and 19), RAC, ASM, Data guard and Oracle Golden Gate

Platforms: IBM AIX 5.1/6.1, Linux AS4, ZFS, OEL, Solaris 10, Windows 2012/2002/XP/98

Tools: SQL*Plus, Toad, Oracle Net Configuration Assistant, OID, ER Studio, DB Artisan, ZDLRA, SRDF Replication, OEM Grid 12c and 13c.

Languages: PL/SQL and Shell scripting

Ticketing Tools: Remedy, Ascent, HPSM, PDSM and Service Now

PROFESSIONAL EXPERIENCE

Confidential, Colorado Springs, CO

Database Administrator

Environment - Red Hat Enterprise Linux 7.3, Oracle Linux and Windows 2012R2

Responsibilities:

• Assist in design of complex, global or strategic development projects. Identify and address interfacing functions, applications and databases.
• Work with operation/delivery team and deploy Oracle best practices.
• Installing, patching, upgrading and migration of the Oracle 10g, 11g and12c RAC and standalone databases.
• Administration and management of Database within a tightly controlled and secured environment.
• Proficient in Oracle Internet Directory (OID), Oracle Enterprise Manager (OEM), partitioning, ASM, RMAN, Cloud Control (12c), Data guard, Golden gate, SQL and PL/SQL.
• Oracle Golden Gate installation, configuration, monitoring and troubleshooting extract/pump/replicate issues.
• Configure databases in EUS (Enterprise User security) and PAM (Password Authentication Management).
• Migration of Oracle databases to Oracle 19c using Oracle Golden Gate.
• Allocating system storage and planning future storage requirements for the database system
• Provide technical analysis and solutions to issues and technical direction.
• Enrolling users and maintaining system security. Controlling and monitoring user access to the database.
• Maintain the integrity, security, performance and availability of databases.
• Performs database and software life-cycle activities to ensure the highest level of system performance and availability and compliance with business requirements.
• Expertise in SQL tuning using tracing, execution plans, wait events, 11G/12C advisors.
• Detailed DB performance analysis using various tools OEM, AWR, ASH, OS monitoring tools.
• Management of databases created and maintenance of Segment space, devices, Log files etc.
• Support and Maintenance of Oracle server software and related tools/products.
• Monitoring the Storage usage and Disk I/O by managing Database space, Data files, OS File Systems, implementing Materialized views and Table partitioning.
• Schedule and prioritize work and plan a sequence of development activities that accomplish the planned targets. Set priorities and provide reports to the management.
• Perform backup and recovery of databases, performance analysis and tuning, index maintenance, and monitoring of databases.
• High availability and Disaster recovery - installation and configuration at the database layer and setting up Active data guard database for reporting and Disaster recovery purpose.
• Performs capacity analysis reports/data and recommendations for improvements.
• Perform application systems development tasks which include working with users to define system needs, analysing and designing applications to meet user needs, translating logic diagrams into program statements, deploying and implementing packages and conducting research in emerging technologies.
• Provide computer program, system development and technical support for very complex, highly critical programs and systems. Plan and coordinate tests, resolve production problems, identify opportunities to improve systems and architecture.
• Create and deliver an Enterprise Blueprint that effectively translates a business vision into Oracle Solution roadmap in execution and customer acquisition context.
• Initiate system analysis leads the definition of user requirements and assesses impacts. Determine alternate solutions with risk analysis and identify opportunities to use technology to improve availability and advance business initiatives.
• Coordinate development activities evaluate and report performance of project.
• Maintain proficiency in programming languages, program development, testing and serve as an expert in area of responsibility.
• Provide technical analysis and solutions to issues and technical direction.
• Utilize technical expertise to manage multiple assignments, including large and critical projects to assure timely and cost-effect objectives delivery.
• Schedule and prioritize work and plan a sequence of development activities that accomplish the planned targets. Set priorities and provide reports to the management.
• Mentor team members in design and analysis activities.
• Assist in the training and orientation of other staff and end users.
• Management of databases created and maintenance of Segment space, devices, Log files etc.
• Patch application and maintenance.
• Monitoring the Storage Usage and Disk I/O by managing Database space, Data files and OS File Systems.
• Establish and Maintain Sound Backup Policies and procedures for Data and Log.
• Provide RCAs and work on resolution of ongoing issues.
• Database Instance Tuning, Maximizing Performance by setting Utilization, Storage parameter and Allocating System.
• Enabling and maintaining Log shipping between PRD and DR sites.
• Replication Server monitoring and troubleshooting.
• Working with operation/delivery team and deploying Oracle best practices.
• Performs the capacity planning required to create and maintain the databases and applications. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.

Confidential, Colorado Springs, CO.

Database Administrator

Environment - Red Hat Enterprise Linux 7.3, Oracle Linux and Windows 2012R2

Responsibilities:

• Assist in design of complex, global or strategic development projects. Identify and address interfacing functions, applications and databases.
• Work with operation/delivery team and deploy Oracle best practices.
• Installing, patching, upgrading and migration of the Oracle 10g, 11g and12c RAC and standalone databases.
• Administration and management of Database within a tightly controlled and secured environment.
• Proficient in Oracle Internet Directory (OID), Oracle Enterprise Manager (OEM), partitioning, ASM, RMAN, Cloud Control (12c), Data guard, Golden gate, SQL and PL/SQL.
• Oracle Golden Gate installation, configuration, monitoring and troubleshooting extract/pump/replicate issues.
• Allocating system storage and planning future storage requirements for the database system
• Provide technical analysis and solutions to issues and technical direction.
• Enrolling users and maintaining system security. Controlling and monitoring user access to the database.
• Maintain the integrity, security, performance and availability of databases.
• Performs database and software life-cycle activities to ensure the highest level of system performance and availability and compliance with business requirements.
• Expertise in SQL tuning using tracing, execution plans, wait events, 11G/12C advisors.
• Detailed DB performance analysis using various tools OEM, AWR, ASH, OS monitoring tools.
• Management of databases created and maintenance of Segment space, devices, Log files etc.
• Support and Maintenance of Oracle server software and related tools/products.
• Monitoring the Storage usage and Disk I/O by managing Database space, Data files, OS File Systems, implementing Materialized views and Table partitioning.
• Schedule and prioritize work and plan a sequence of development activities that accomplish the planned targets. Set priorities and provide reports to the management.
• Perform backup and recovery of databases, performance analysis and tuning, index maintenance, and monitoring of databases.
• High availability and Disaster recovery - installation and configuration at the database layer and setting up Active data guard database for reporting and Disaster recovery purpose.
• Performs capacity analysis reports/data and recommendations for improvements.
• Perform application systems development tasks which include working with users to define system needs, analysing and designing applications to meet user needs, translating logic diagrams into program statements, deploying and implementing packages and conducting research in emerging technologies.
• Provide computer program, system development and technical support for very complex, highly critical programs and systems. Plan and coordinate tests, resolve production problems, identify opportunities to improve systems and architecture.
• Create and deliver an Enterprise Blueprint that effectively translates a business vision into Oracle Solution roadmap in execution and customer acquisition context.
• Initiate system analysis leads the definition of user requirements and assesses impacts. Determine alternate solutions with risk analysis and identify opportunities to use technology to improve availability and advance business initiatives.
• Coordinate development activities evaluate and report performance of project.
• Maintain proficiency in programming languages, program development, testing and serve as an expert in area of responsibility.
• Provide technical analysis and solutions to issues and technical direction.
• Utilize technical expertise to manage multiple assignments, including large and critical projects to assure timely and cost-effect objectives delivery.
• Schedule and prioritize work and plan a sequence of development activities that accomplish the planned targets. Set priorities and provide reports to the management.
• Mentor team members in design and analysis activities.
• Assist in the training and orientation of other staff and end users.
• Management of databases created and maintenance of Segment space, devices, Log files etc.
• Patch application and maintenance.
• Monitoring the Storage Usage and Disk I/O by managing Database space, Data files and OS File Systems.
• Establish and Maintain Sound Backup Policies and procedures for Data and Log.
• Provide RCAs and work on resolution of ongoing issues.
• Database Instance Tuning, Maximizing Performance by setting Utilization, Storage parameter and Allocating System.
• Enabling and maintaining Log shipping between PRD and DR sites.
• Replication Server monitoring and troubleshooting.
• Working with operation/delivery team and deploying Oracle best practices.
• Performs the capacity planning required to create and maintain the databases and applications. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.

Confidential, Colorado Springs, CO.

Database Administrator

Environment - Red Hat Enterprise Linux 7.3, Oracle Linux and Windows 2012R2

Responsibilities:

• Assist in design of complex, global or strategic development projects. Identify and address interfacing functions, applications and databases.
• Work with operation/delivery team and deploy Oracle best practices.
• Installing, patching, upgrading and migration of the Oracle 10g, 11g and12c RAC and standalone databases.
• Administration and management of Database within a tightly controlled and secured environment.
• Proficient in Oracle Internet Directory (OID), Oracle Enterprise Manager (OEM), partitioning, ASM, RMAN, Cloud Control (12c), Data guard, Golden gate, SQL and PL/SQL.
• Oracle Golden Gate installation, configuration, monitoring and troubleshooting extract/pump/replicate issues.
• Allocating system storage and planning future storage requirements for the database system
• Provide technical analysis and solutions to issues and technical direction.
• Enrolling users and maintaining system security. Controlling and monitoring user access to the database.
• Maintain the integrity, security, performance and availability of databases.
• Performs database and software life-cycle activities to ensure the highest level of system performance and availability and compliance with business requirements.
• Expertise in SQL tuning using tracing, execution plans, wait events, 11G/12C advisors.
• Detailed DB performance analysis using various tools OEM, AWR, ASH, OS monitoring tools.
• Management of databases created and maintenance of Segment space, devices, Log files etc.
• Support and Maintenance of Oracle server software and related tools/products.
• Monitoring the Storage usage and Disk I/O by managing Database space, Data files, OS File Systems, implementing Materialized views and Table partitioning.
• Schedule and prioritize work and plan a sequence of development activities that accomplish the planned targets. Set priorities and provide reports to the management.
• Perform backup and recovery of databases, performance analysis and tuning, index maintenance, and monitoring of databases.
• High availability and Disaster recovery - installation and configuration at the database layer and setting up Active data guard database for reporting and Disaster recovery purpose.
• Performs capacity analysis reports/data and recommendations for improvements.
• Perform application systems development tasks which include working with users to define system needs, analysing and designing applications to meet user needs, translating logic diagrams into program statements, deploying and implementing packages and conducting research in emerging technologies.
• Provide computer program, system development and technical support for very complex, highly critical programs and systems. Plan and coordinate tests, resolve production problems, identify opportunities to improve systems and architecture.
• Create and deliver an Enterprise Blueprint that effectively translates a business vision into Oracle Solution roadmap in execution and customer acquisition context.
• Initiate system analysis leads the definition of user requirements and assesses impacts. Determine alternate solutions with risk analysis and identify opportunities to use technology to improve availability and advance business initiatives.
• Coordinate development activities evaluate and report performance of project.
• Maintain proficiency in programming languages, program development, testing and serve as an expert in area of responsibility.
• Provide technical analysis and solutions to issues and technical direction.
• Utilize technical expertise to manage multiple assignments, including large and critical projects to assure timely and cost-effect objectives delivery.
• Schedule and prioritize work and plan a sequence of development activities that accomplish the planned targets. Set priorities and provide reports to the management.
• Mentor team members in design and analysis activities.
• Assist in the training and orientation of other staff and end users.
• Management of databases created and maintenance of Segment space, devices, Log files etc.
• Patch application and maintenance.
• Monitoring the Storage Usage and Disk I/O by managing Database space, Data files and OS File Systems.
• Establish and Maintain Sound Backup Policies and procedures for Data and Log.
• Provide RCAs and work on resolution of ongoing issues.
• Database Instance Tuning, Maximizing Performance by setting Utilization, Storage parameter and Allocating System.
• Enabling and maintaining Log shipping between PRD and DR sites.
• Replication Server monitoring and troubleshooting.
• Working with operation/delivery team and deploying Oracle best practices.
• Performs the capacity planning required to create and maintain the databases and applications. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.

Confidential, Austin, TX.

Database Administrator

Environment – IBM- AIX, Red Hat Enterprise Linux 6.5, Sun OS, Windows 2012R2

Responsibilities:

• Providing production support (24/7) and troubleshooting user issues.
• Cloning of oracle application using cold/RMAN/Traditional backup.
• Weekly bounce for PROD database and health check. Downloading and uploading LDT’s using FNDLOAD.
• Using TKprof utility generating test file for the trace files. Enabling the notification mailer.
• Space management by shipping and clearing archive log files. Creating and managing users by granting and revoking certain privileges as per business needs.
• Taking different types of logical and physical backups. Restoring and recovering databases with available backups.
• Use different types of utilities like expdp and impdp. Scheduling RMAN backups from OEM.
• Install Oracle discoverer and configure it with oracle applications. Migrate databases from one server to another server.
• Tuning the database to speed up the instance.
• Upgrade databases from 10g to 11g and from 11g to 12c.
• Install OEM agent while migration of the PROD databases.
• Apply application patches and administering ad utilities.
• Migrating the code to the prod instance based on client requirement.
• Purging sysaux tablesapces when it reaches threshold and purging workflow items when required.
• Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
• Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation.
• Enforces and maintains database contraints to ensure integrity of the database.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Assists with impact analysis of any changes made to the database objects.
• Troubleshoots with problems regarding the databases, applications and development tools.
• Create new database users as required.
• Manage sharing of resources amongst applications.
• The DBA has ultimate responsibility for the physical database design.

Confidential, Denver, CO

Infra Team Lead

Environment – IBM- AIX, Red Hat Enterprise Linux 6.5, Sun OS, Windows 2012R2

Responsibilities:

• Handling more than 260 databases including Production, Pre-production, SIT, UAT and Development boxes.
• Primarily responsible for production support. To keep all databases up and running in production.
• In-depth Knowledge of installation, configuration, and maintenance of Oracle database – 9i, 10g, 11g and 12c.
• Did the datacenter migration of Oracle databases from one DC to another DC with zero downtime using Oracle golden gate.
• Hands on experience on fixing Oracle golden gate issues.
• Moved the Dev and QA databases to Oracle PCA (Private Cloud Appliance).
• Experience in creating, configuring, and managing AWS RDS databases related to MySQL and Oracle.
• Performed to storage migration of databases from VNX storage to Unity and Xtream IO.
• Experience in migrating the Oracle databases to AWS.
• Installation of Couchbase cluster in Linux environment.
• Experience in Couchbase cluster, bucket design and maintenance.
• Performed annual DR (Disaster Recovery) of critical production databases.
• Perform switchover and switchback of databases as per client requirement.
• Experience on E-Business Suite R12 Applications.
• Up-gradation of RAC databases from 10gR2 to 11gR2.
• Configuration of 11g CRS RAC Environment using ASM and creating ACFS in RAC environment.
• Oracle 12c installation and applying latest security and bug fix patches to the grid and RDBMS homes
• Multitenant: Manage tablespace in a Container database (CDB) and pluggable databases (PDB) in oracle database 12c release 1.
• Multitenant: Manage users and privileges for container databases (CDB) and pluggable databases (PDB) in Oracle release 12c.
• Multitenant: Backup and recovery of container database (CDB) and a pluggable database (PDB) in oracle database 12c.
• Managing the couchbase database with 4 node cluster.
• Oracle Golden Gate configuration and administration. Configured bi-directional (12 Databases) and unidirectional replication between databases.
• Troubleshooting golden gate issues and conflict handling issues in golden gate.
• Experience in datacenter migration using Oracle datagurad (Create standby DB and switch over the database).
• Experience on GDPR and implemented it in Oracle databases in WesternUnion environment.
• Implemented Oracle data encryption and security (SSL, TLS, TDE, Advanced security and Network Security) in Confidential environment.
• Configure Oracle wallet for TDE encryption and set to auto login.
• Experience in capacity planning and space management and add required storage and resources to the database servers.
• Experience in Oracle licensing (Processor based or Named user based licenses). Optimizing the oracle licencing like de-install the licensed components which are not in use from database registry.
• Experience in Oracle sql developer data modelling.
• Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the Confidential ’s requirement as necessary, from information given by the application developers.
• Converting huge tables into partition tables.
• Automation of jobs using shell scripts and task scheduling.
• Monitor database management systems as well as evaluating database performance to maximize efficiency
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.
• Taking table level backups using expdp/impdp.
• Experience in Oracle active datagurad.
• Responsible for capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lock activity.
• Tuned the system in terms of SQL optimization, Memory tuning and application tuning.
• Tuning Query performance by creating Indexes and using SQL Advisory to tune queries and give recommendations to the Applications Team.
• Monitoring, sizing and tuning undo segments by creating multiple undo tablespaces.
• Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.
• Replication of tables to cross platform and Creating Materialized Views.

Confidential

Senior Specialist

Environment – Oracle 11g/10g, Oracle EM Grid Control 11g and 12c, ASM, Streams, IT Central, AWR and ADDM Analysis, SQL*Plus, Toad, SQL*Loader, RMAN, Red Hat Linux, VMSTAT, IOSTAT, MPSTAT, DSTAT, TOP, HP-UX, Sun Solaris.

Responsibilities:

• Handled more than 380 databases including Production, Pre-production and Development boxes.
• Primarily responsible for production support. To keep all databases up and running in production.
• Experience on installation of 4 node and 3 node RAC and creating services in the RAC environment.
• Configuration of 11g CRS RAC Environment using ASM.
• Meeting the SLA Metrics week to week for Oracle Track.
• Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the Confidential ’s requirement as necessary, from information given by the application developers.
• Extensive experience in working on Distributed Oracle Database server's 11g/10g, and developing stored packages, procedures, functions, triggers and views
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.
• Taking table level backups using expdp/impdp.
• Responsible for capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lock activity.
• Tuned the system in terms of SQL optimization, Memory tuning and application tuning.
• Extensive experience in database design, data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.
• Tuning Query performance by creating Indexes and using SQL Advisory to tune queries and give recommendations to the Applications Team.

Confidential

Senior Specialist

Environment – Oracle 11g/10g, Oracle EM Grid Control 11g and 12c, ASM, Streams, IT Central, AWR and ADDM Analysis, SQL*Plus, Toad, SQL*Loader, RMAN, Red Hat Linux, HP-UX, NetBackup, TSM, TDP, Sun Solaris.

Responsibilities:

• Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.
• Taking table level backups using expdp/impdp. Responsible for capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lock activity.
• Tuned the system in terms of SQL optimization, Memory tuning and application tuning.
• Extensive experience in database design, data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.
• Tuning Query performance by creating Indexes and using SQL Advisory to tune queries and give recommendations to the Applications Team.
• Primarily responsible for production support. To keep all databases up and running in production.
• Up-gradation of RAC databases from CRS 10.2 11.2 for the Micron’s SDW and CDW databases.
• Configuration of 11g CRS RAC Environment using ASM.
• Exadata Database Machine installation and administration experience.
• Managing oracle databases in EXADATA environment.
• Meeting the SLA Metrics week to week for Oracle Track.
• Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the Confidential ’s requirement as necessary, from information given by the application developers.
• Worked on Oracle SAP databases and applied the patches using mopatch utility.
• Worked on Oracle E-business database and ODA.
• Perform switchover and switchback of databases as per client requirement using DG broker or manual.
• Extensive experience in working on Distributed Oracle Database server's 11g/10g, and developing stored packages, procedures, functions, triggers and views
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Monitoring, sizing and tuning undo segments by creating multiple undo tablespaces.
• Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.
• Replication of tables to cross platform and Creating Materialized Views.
• Has worked on various Volume Management software's like AIX LVM, HP LVM, and VERITAS Volume Manager
• Designing and developing packages in the database layer, stored procedures, functions and triggers.
• Replicated Datacenter and Local database for automatic update of Objects.
• Communicating with UNIX Production Support group for UNIX production issues like database installations, file space issues, patch applications, database startup/shutdown automation, and other database services and file system backups.

Confidential

Senior Specialist

Environment – Oracle 9i/10g/11g, AWR and ADDM Analysis, SQL*Plus, Toad, SQL*Loader, RMAN, Red Hat Linux, HP-UX, Sun Solaris.

Responsibilities:

• Handled more than 350 databases including Production, Pre-production and Development boxes.
• Installation of Oracle 9i and10g on UNIX and Windows platform and creation of Database.
• Installation of Database security patches and performing the point release upgrade.
• Installing Oracle Client of version 10.2.0.4
• Frequent refresh of the Databases using RMAN.
• Creating Duplicate database using RMAN
• Involved in the server migration activities.
• Performing periodical Backup, Restoration and recovery using RMAN (full & incremental).
• Database Restoring from Production to Test and Development Database using RMAN and performing Point in time Recovery (Cancel based, Change based, Time based).
• Monitoring databases space requirements and adding spaces as per the database.
• Managing tablespaces, data files, redo logs, tables and its segments.
• Managing Users, Privileges and Roles.
• Performance tuning resource monitoring (Disk Space Utilization CPU etc).
• Day-to-day business database support and management of the production DB.
• Support activities that include areas like Problem Management, Incident Management and Change Management.

Confidential

Operations Senior Lead Specialist

Environment – HP UNIX, IBM AIX, Solaris, Windows 2003, Oracle 8i,9i,10g and 11g, Oracle EM Grid Control 10g, ASM, Streams, AWR and ADDM Analysis, SQL*Plus, Toad, SQL*Loader, RMAN, OS cluster and windows failsafe cluster.

Responsibilities:

• Handled more than 1600 databases including Production, Pre-production and Development boxes.
• Installation of Oracle 9i and10g on UNIX and Windows platform and creation of Database.
• Installation of Database security patches and performing the point release upgrade.
• Installing Oracle Client of version 10.2.0.4, OEM.
• Standby Database Rebuild using RMAN.
• Frequent refreshing the Database of size 1.2 TB using RMAN.
• Involved in the server migration activities.
• Administrating oracle10g, 9i and Oracle 10g RAC, standby database.
• Performing periodical Backup, Restoration and recovery using RMAN (full & incremental).
• Database Restoring from Production to Test and Development Database using RMAN and performing Point in time Recovery (Cancel based, Change based, Time based).
• Monitoring databases space requirements and adding spaces as per the database.
• Managing tablespaces, data files, redo logs, tables and its segments.
• Managing Users, Privileges and Roles.
• Database switchover and switchback and failover in case if it require.
• Performance tuning resource monitoring (Disk Space Utilization CPU etc.).
• Handled Databases in RAC and OS Cluster environments.
• Support activities that include areas like Problem Management, Incident Management and Change Management.
• Handling Alert tickets and the severity tickets with incident tracking tools Remedy and Manage Now.
• Close interaction with the business users and IT groups across the region and globally to ensure issues are resolved in a timely manner as per the Database Management standards.
• Co-ordination with the team to meet the SLA between vendor and client.
• Handled more than 20 databases including Production and Development boxes.
• Installation of Oracle 9i and10g on Linux, Solaris and creation of Database.
• Applying Database security patches.
• Installing Oracle Client of version 10.2.0.4.
• Managing tablespaces, data files, redo logs, tables and its segments.
• Managing Users, Privileges and Roles.
• Monitoring databases space requirements and adding spaces as per the database.
• Collecting the database statistics using stats pack, explain plan, tkprof, AWR.
• Handling the severity issues which is impacting the service.
• Data fixes over the production databases.
• Documenting the daily changes on behalf of application administrator.