SUMMARY

• 14+ years of experience as an Oracle Database Administrator having hands on experience in Production Support, Application Development, Installation, Configuration, Upgrades, Patching, Performance Tuning, RMAN Backup and Recovery, Migrations, Exadata, AWS, RDS, EC2, Cassandra, Postgres, ASM/RAC Administration, Golden Gate Replication, Cloning, Space management, Database Security, Patching and Auditing
• Progressive experience in Oracle database Design and Architect. Proven track record of providing strategic direction while deploying tactical technical solutions.
• Exceptional analytical and problem solving skills. Excellent ability to look Confidential problems from a macro level and a detailed level, always keeping the appropriate business prospective
• Excellent experience in Installation, configuration and cloning of Oracle 8i, 9i, 10g, 11g, 12c and 11g,12c,18c,19c, RAC, EXADATA, AWS, RDS, EC2, Oracle Cloud(OCI), Postgres, Cassandra.
• Expertise in Application Development as Application development admin and Production Support 24X7
• Duties included installation, patching, upgrading, performance tuning, space allocation and maintaining Oracle Server according to Oracle OFA Standards.
• Expertise in Troubleshooting Performance issues, Bottlenecks and RCA( Root cause analysis) for critical failures.
• Perform timely patching and upgrades to avoid security vulnerabilities and maintain company policies.
• Prepare and execute Database Migration plans for ONPREM to AWS ( RDS) without downtime using OGG and other methods.
• Prepare Space forecast for the future needs for the DB and perform Reorg on db’s for the better utilization of space.
• Good hands on experience on bash, shell scripting and exposure to python.
• Good hands on experience and working on oracle 10gR1,10gR2,11gR1,11gR2,12c, 18c,19c, RAC,ASM and Data Guard, Goldengate,AWS, RDS, EC2, DMS, Ora - to-PG, SCT for migrations.
• Experience in data loading utilities like SQL*LOADER, Logical backups using full export, import and DATAPUMP
• Create Guidelines for the user maintenance and security based on company policies.
• Create and maintain proper security groups on AWS depending on company security policies and standards.
• Build-Installation, configuration, upgrading and migration across platforms of Oracle (9i, 10g &11gr2 RAC- DATAGUARD).
• Hands on experience on Jenkins and knowledge on Kubernetes.
• Hands on experience with CURAM Software development environment as CURAM DBA
• Proficient in Database Administration activities such as installing, upgrades, patches, cloning, backup and recovery, performance tuning, script development, and documentation.
• Good hands on experience working on physical standby databases.
• Hands-on experience in planning & designing Oracle Backups and Recovery strategies like RMAN, export/import - logical and physical backup.
• Intensively used latest Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM), ASH reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control and 11g (11.1.0.1.0 )
• Handled High volume production databases around 60 TB size along with Physical standby databases
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GOLDEN GATE, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.
• Design and support a disaster recovery plan to enable timely failover of all instances when necessary
• Performed Data file recovery from logical and physical block corruptions
• Good understanding and Implementation expertise in RAC, ASM, Data Guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
• Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability.
• Extensive experience in DBA activities including schema/user management, space management monitoring on oracle.
• Large high volume site experience with database monitoring and tuning on OLAP 24*7*365 systems.
• Installing, Configuring, Administering, Cloning, Patching, Upgrading and Migrating the Oracle Technologies Database Products on Unix, AIX, Sun Solaris SPARC, Linux, Cent OS and Windows server family.
• Expert in database installations, configuration, test instances creation and refreshes and the change management.
• Work with Architect and planning teams to identify right technology investments and technical architectures upgrades
• Knowledge on Designing and implement database structures for all instances of Meter data management (MDM ) and Meter Asset Management (MAM)
• Expertise in performance- tuning, SQL tuning services with EXPLAIN PLAN, TKPROF,STATSPACK,SQL,TRACE,AWR,ADDM to collect and maintain performance statistics and improve the database performance.
• Hands on Exp with recovery of datafiles and block corruption problems.
• Developer UNIX Shell scripts and SQL scripts to carry out routing checks on databases. This includes database health check, automate RMAN backups, disk space availability, alert log errors, stats gathering etc
• Expert with Data Guard, creation of physical standby and resolving the physical standby database gap.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN
• Experience in platform migration from Sun Solaris to HP Linux using traditional export/import and datapump utilities
• Supportive Individual capable of Managing incidents, being proactive in terms of preventive maintenance and knowledgeable in terms of risk management.
• Expert in Support and Maintenance, shell scripting, database upgrades and enhancements.
• Conduct Knowledge sharing and training sessions to Train staff to perform all aspects of on-going support of the databases.
• Proficiency in Analytical, Presentation, written and oral Communication and Interpersonal skills.

TECHNICAL SKILLS

Database Admin: AWS, RDS, EC2, S3, Oracle Cloud, Oracle 19C, 18C, 12C, EXADATA, 11gR1, 11gR2,10g/9i,SQL Server, DB2, Aurora Postgres, Cassandra, Mongo Db, DMS, Ora-to-PG, Lambda, SCT

RDBMS: Oracle, Microsoft SQL Server, MySQL, DB2

High Availability: Exadata,19c, 18c, 12C, 11G, 10G, RAC, Data Guard, ASM, GOLDEN GATE

Languages: SQL, PL/SQL, Shell Script, bash, C, Core Java

Operating System: LINUX (4.x, 5.x, 6.x), Sun Solaris 8/9/10, SuSE Linux Advanced Server, and HP-UX 10/11.x, IBM AIX 5.1, 5.2, 5.3 & Windows Server 2003/2000/NT, AWS, Oracle Cloud ( OCI)

Development Tools: SQL Developer, Toad, SQL*plus, SQL* Loader,TIDAL, DMS, SCT, OratoPG

Database Tools: SQL*PLUS, TOAD, Putty, OEM( 11g & 10g), RMAN, EBU, SQL* LOADER, imp, exp & Data pump (expdp and impdp).

Web Tools: IMPACT, Rational Clearcase, Clear Quest, Remedy

Web Technologies/HtmlTicketing Tools: Remedy, Impact, JIRA

Tuning Tools: TKPROF,EXPLAINPLAN,STATSPACK,AWR,ADDM, ASH

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential

Responsibilities:

• Create and support PROD, Stage, UAT, ST, DEV and DR Oracle 11g, 12c databases
• Create Cloud Databases for PROD, UAT and Dev 12c, 18c and 19c
• Perform cloud migrations for Oracle and Postgres and ONPREM oracle to AWS, RDS
• Perform ONPREM to Cloud, ONPREM to ONPREM Oracle to Postgers migraitons
• Configure Oracle GOLDENGATE between the databases and Migrate db’s using OGG
• Create new Cluster environments, ASM and databases as per the requirements.
• Create New Standby databases for PROD environments and Perform DR tests.
• Develop, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created databases
• Refresh Lower environments with prod data for multiple releases.
• Perform review meetings for PROD deployments.
• Work closely with Development teams for application related performance issues and fix them
• Implement Microservices databases for all the applications.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Perform database tuning and performance monitoring
• Perform application tuning and performance monitoring
• Setup and maintain documentation and standards
• Take care of the Database design and implementation
• Plan growth and changes (capacity planning)
• Work as part of a team and provide 24x7 support when required
• Perform general technical trouble shooting and give consultation to development teams
• Create instances and databases with appropriate initialization parameters and database structures
• Document migration procedures and test results
• Perform database maintenance functions Move, rebuild, or change database objects as required in production Providing assistance in the development of the conceptual & logical database design
• Supporting application programmers in the testing of database applications
• Provide ongoing database support/review in the CPC production environment
• Assist the Application Developers in developing efficient SQL code to access and manipulate database objects as projected in functional requirements.

Oracle Database Administrator

Confidential

Responsibilities:

• Provide technical solution (enhancement of existing functionality/ propose new functionality) to client. This requires frequent face to face interaction with the client also be responsible for performing technical risk assessment and prepare the mitigation plan accordingly (both proactively and reactively). Provide technical guidance to team members and developers.
• Performing consolidated health check reports for the entire application which includes Database server utilization and generating reports for the underlying database, Web Sphere Portal database health check and bellow mentioned activities.
• Capacity planning for database growth, space management, physical and logical database design.
• Dynamic changes of database parameter for the optimum performance of the database.
• Analyse and design new databases based on client requirements
• Work with various teams like Development, test and application teams to understand the issues and help to provide solution from Database level.
• Configure Physical standby databases with Data guard
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
• Mapping client’s requirements and implementing processes in line with the guidelines specified by the client through ETL process
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results
• Developed mappings to load into staging tables and then to Dimensions and Facts
• Configure Goldengate between Legacy and New databases for Data migrations
• Configure Goldengate between PROD and Reporting databases
• Monitor the databases using Database metrics from OEM and Automated adhoc Shell scripts.
• Refresh the lower environments for the Development, test teams.
• Recover the database for physical and logical data file corruptions and other failures
• Analyse the bottlenecks and performance issues and provide resolution with efficient database, query tuning for smoother functionality of database with best response time.
• Perform successful Database Deployments in PROD as well as lower environments.
• Develop, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 10g/11g and 12C databases
• Work with development teams for database performance issues.
• Schedule jobs using TIDAL job scheduler for database and ETL
• 24x7 production support and on call rotation
• Configure Data guard between production and DR site with Max performance replication.
• Analyse and resolving any technical issues in the applications related to the Project.
• Monitor the performance of the system and resolving any issues to ensure stable performance.
• Monitoring the critical system parameters and analysing and resolving any issues found during the monitoring
• Monitoring the performance of the system and resolving any issues to ensure stable performance.

Environment: Oracle 11g, RAC, DATAGUARD, Informatica, TIDAL, Goldengate, DB2, JIRA, AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, MQ, WebSphere, CURAM and Hadoop

Oracle Database Administrator

Confidential, Dallas, TX

Responsibilities:

• Support 24x7 production for 180 Oracle databases and 60 Sql Server Database and Applications.
• Create and support new DEV, SIT, UAT, BAU, TechTest and Prod /DR Oracle 11.2.0.3 databases
• Create new Cluster environments, ASM and databases as per the requirements.
• Develop, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 10g/11g and 12C databases
• Involved in Implementing Oracle Golden gate between Production databases Active - Active configuration with CDR implementation.
• Migration of around 2000 Schemas across 65 prod databases to New 8 Node 12c PROD RAC database
• Creation of Deployment plans for the Cut overs activities
• Preparing the deployment plans with pre and post installation steps
• Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Max performance mode.
• Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose’s
• Responsible for managing production, development & test databases and applications.
• Extensively worked with export/import and datapump utilizes to migrate data from Sun Solaris to AIX
• 24X7 production support and on call rotation
• Involved in database migrations, cloning production system, for testing and development.
• Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth
• Extensively worked with indexes and table partitioning.
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.

Environment: Oracle 10g, 11g, 12C, RAC, ASM, Data Guard, EXADATA, Goldengate, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux( RHEL 4.x, 5.x 6.x), Sun OS 5.8/5.9/5.10 , AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Oracle Database Administrator

Confidential, Dallas, Tx

Responsibilities:

• Developing, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 11g/10g databases
• Involved in Implementing Oracle Golden gate between Production databases Active - Active configuration with CDR implementation.
• Migration of around 2000 Schemas across 65 prod databases to New 8 Node PROD RAC database
• Creation of Deployment plans for the Cut overs activities
• Preparing the deployment plans with pre and post installation steps
• Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Max performance mode.
• Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Perform Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments
• Responsible for managing production, development & test databases and applications.
• Extensively worked with export/import and data pump utilizes to migrate data from Sun Solaris to AIX
• 24X7 production support and on call rotation
• Involved in database migrations, cloning production system, for testing and development.
• Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth
• Extensively worked with indexes and table partitioning.
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.
• Implement and maintain database structures for all instances of Meter data management (MDM ) and Meter Asset Management (MAM)
• Worked with multiple teams for to Maintain complete data for MDMS databases ( Command centre and LCIS )
• Worked with Maximo implementation teams for MAM database instances maintenance and support.

Environment: Oracle 11g/10g, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Confidential, Dallas Texas

Oracle Database Administrator

Responsibilities:

• As a Oracle DBA my role was to support Client's Production and Development databases
• Supporting/monitoring 3-node Production Oracle 11g RAC on Oracle Cluster ware platforms on high availability environment and writing shell scripting for various database maintenance and alerting activities
• Creating RAC databases in various environments when ever required.
• 365 X 24/7 Production support and deployments of new releases.
• Maintained large sized prod and Disaster recovery databases of around 25 TB size
• Creation of New Cluster environments, ASM and Databases
• Maintaining 11Gr1 and 11Gr2 Databases.
• Performed upgrades from 11GR1 to 11GR2
• Created RAC11g standby database on 2 node cluster for large production system as per specification.
• Created new ASM disk groups using RAW disks, LUNS and adding, dropping disk members from ASM.
• Working extensively with Oracle support for Sev 1 issues like Datafile corruption, Block corruption problems in Production environment.
• Installed RAC 11G Staging database Installed and configured EM Central Grid control on 11g to administer and manage large number of databases and enterprise wide targets.
• Plan for backup, recovery, and fault tolerance of database; back up and restore the database
• Control and monitor user access to database; monitor and optimize the performance of database
• Allocate system storage and plan for future storage requirements for the database system
• Provide technical resolution to Oracle database related problems
• Create primary database storage structures and primary objects
• Create and maintain clone/staging database environment as well as hot standby database
• Responsible for installation, account management, backup/recovery of Oracle 11g databases
• Performing Rman Level 0 and leve1 backups daily and weekly.
• Performed automatic monitoring of users, tablespaces, tables, indexes
• Creating Shell scripts to automate database monitoring activities and regular Rman backups.
• Performed logical exports and imports of database, users, and tables as and when required.
• Manage and maintain SMT's Production and Development databases.
• Maintain MNF Tracker which directly goes to the client for verification
• Carry out day to day activities in production includes sanity test, schema management and space management.
• Work with various teams involved in this project as when needed to resolve issues.
• Refreshing Development Databases with production data
• Working as a team member of an integrated group that provides consistent support in a collaborative manner to the client.

Environment: Oracle 11g/10g/9i, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux(RHEL 4.x,5.x),Sun OS 5.9/5.10, AIX OS 5.1,5.2,5.3, Toad, Performance Tuning Shell Scripting, PL/SQL, SQL*Plus.

Oracle Database Administrato

Confidential, San Francisco,CA

Responsibilities:

• Creating New RAC database as per the requirement.
• Space management, Uesr management
• Refreshing data from prod to lower environments for testing
• Creating the new jobs for report generation, Database monitoring and alert mgmt.
• Creating RMAN backup strategies as per the requirements.
• Creating, adding new disk groups and members to ASM for new databases
• Resolving user issues immediately and closing the issues on timely manner
• Monitoring jobs, troubleshooting on failure and addressing alerts
• Performed heavy data loads using SQL *Loader, Export, Import for backing certain tables.
• Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Plan and implement appropriate backup and recovery strategies for the database.
• Rebuilding indexes for faster access and to reduce disk I/O.
• Observing Logs generated every day.

Environment: Oracle 9i/10G/11G, MS SQL Server 2000/2005, Oracle Enterprise Manager (OEM), OEM 10g Grid Control, RMAN, RAC, ASM, DBArtisan, DataGuard, AIX OS 5.1,5.2,5.3,Linux( RHEL 4.x, 5.x),Sun OS 5.8/5.9/5.10 , Toad, Shell Scripting, PL/SQL, SQL*Plus.

Oracle Database Administrator

Confidential, Stanchfield, MD

Responsibilities:

• Checking health systems of Oracle Database
• Involved in Oracle database logical and physical Backups
• Ensure the completion of all daily backups.
• Monitoring database growth and space management.
• Checking the alert logs regularly
• Configuring the database to archive mode
• Maintaining database security by creating users and profiles
• Resolving user process error
• Monitoring Database Performance by Dynamic Performance views.

Environment: Oracle 10g/9i, Toad, Oracle Enterprise Manager (OEM), RMAN, RAC, Data Suse Linux Advanced Server and AIX 5.1/5.2/5.3, TOAD, Performance Tuning, Shell Scripting, PL/SQL, SQL*Plus

Oracle Database Administrator, Developer

Confidential

Responsibilities:

• Creation of New databases as per the requirements for UAT, DEV and Test.
• Resolving connectivity issues with the database from clients
• Develop technical platform for global-client
• Upheld quality control and data validity for Java Programs
• Resolve application and connectivity problems in Java Programs
• Creating oracle clients on application end
• Creating new scripts to automate the monitoring jobs for faster response.
• Scheudling the backups and jobs to maintain the better performance of DB
• Performing exports and imports based on the application user requests
• Application trouble shooting with respect to Database issues.
• Designed and developed front view components using JSP and HTML
• Backing up databases.
• Providing security privileges to developers.
• Managing Users and Giving appropriate permission’s.
• Managing Default Temporary Table space
• Creating and Managing Table space with Multiple Block Sizes.
• Involved in database schema creations and writing queries.

Environment: Linux, Windows, core java, javascript, JSP, servlets, Sprint and Oracle 9i, 10G.