SUMMARY:

• Senior Database Administrator with over 13 years of experience in administration, planning, installation, configuration and upgrades of Oracle 12c, 11gR2, 10G, 9i, 8i databases including applying patches under Linux, HP - Unix, Sun Solaris, IBM-AIX and Windows platforms.
• Experience includes managing Oracle 9i, 10g, 11gR1/R2 and 12c RAC environments using the OEM Grid Control tools.
• Experience includes using Golden Gate to support data replication in the Oracle database environment. Experience includes Oracle Utilities Data Guard, Data Pump, Flashback and RMAN.
• Good experience of setup & configuration, implementation of (Oracle 12c/11gR2 RAC two-node on Linux with ASM).
• Implemented Oracle Patches (PSU, CPU) on the Compliance Databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support.
• Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
• Migrating and Upgrading the Databases between different environments and versions.
• Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases. Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
• Design, document, implement, and maintain all backup, recovery including disaster recovery.
• Procedures using RMAN, VERITAS Net Backup. Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas and to restore the Dev, Test databases.
• Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 12c and 11gR2 ASM.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems. Performed complete multi-master replication with updateable Materialized views.
• Strong programming experience in creating Packages, Stored Procedures and Functions, Database Triggers.
• Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
• Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Experience in Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions X5/X4 Quarter/Half & Full RACK Machines.
• Good experience in applying Critical Patch Update (CPU Patches) on Exadata Machines.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROF and ADDM reports. Proven ability of providing production support for 24X7 on multiple databases.
• Launched and maintained EC2 and RDS instances in AWS cloud.
• Created Snapshots, Elastic IPs, EBS Volumes, Security Groups per clients/costumer’s request.
• Migrated the 11.2.0.4 Oracle databases to AWS RDS.
• Having good knowledge of the EDB PostgreSQL DB architecture.
• Drive end to end availability, performance monitoring, and capacity planning for PostgreSQL, using PostgreSQL monitoring for Zabbix/PG Admin.
• Implement automated methods and industry best practices for consistent installation and configuration of EDB PostgreSQL for production, pre-production and non-production environments.
• Install & configure development PostgreSQL 9.5 databases on Linux 7.4 servers.
• Optimize postgresql.conf for performance improvement.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support.
• Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
• Maintenance of PostgreSQL databases.
• Updated earlier releases of PostgreSQL to version 10.5 on 6 servers running Linux 7.4.
• Insure night cron jobs for backups, reindexing & vacuuming & materialized views executed properly on 24/7/365 high availability Postgres production and development databases.
• Review all PostgreSQL logs for problems.
• Create, Backup, Restore & Drop databases per developer’s requirements.
• Respond to database outages caused by equipment failure and coordinate with Network Admin to perform database fail over to standby servers.
• Insure high availability of production via Slony replication.
• Propagate all database changes (DDL & DML) to multiple databases and servers.
• Coding of Pl/PgSQL Stored Procedures, Data Types, Triggers, Constraints and Constraints. Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
• Migrating and Upgrading the Databases between different environments and versions.
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Replica set and Sharded network setup and maintenance with high availability.
• Backup & Recovery, Database optimization and Security maintenance.
• Deployment design of database systems.
• DB Monitoring and DB health checks.
• Preparing user interfaces for the application.
• Ensuring that the applications being developed can be used by non-technical personnel
• Making the necessary changes in the developed application or software as suggested by the testing department.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.

TECHNICAL SKILLS:

Operating System: UNIX, LINUX, Solaris, Windows, AIX

RDBMS: ORACLE 12c/11gR2/10.x and SQL Server 2008/2005, MS SQL, MYSQL, POSTGRES

Oracle Tools/Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, DBVERIFY, TKPROF and STATSPACKAWR, ADDM, OEM

Languages: SQL, PL/SQL and UNIX Shell

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA

Confidential, Boston, MA

Responsibilities:

• Oracle DBA managing and administering the ERIS database hosted services and the underlying OS systems that include services for Oracle, Postgres, MySQL, Filmmaker and Microsoft SQL instances. Additional database systems under development within ERIS include Hadoop, MongoDB and technologies such as Spark.
• Conduct thorough study and analysis of end client’s business processes to identify and ascertain its needs and requirements in database.
• Serve as a subject matter expert in enterprise-wide technology planning and architecture.
• Interact with end-users, who are internationally recognized scientists and researchers, in support of their projects.
• Manage databases to provide the accessibility, security and integrity of data.
• Evaluate Oracle features and Oracle related computer products.
• Coordinate with Oracle Corporation for Technical support.
• Design logical and physical databases.
• Perform data sizing, mapping, migration, profiling, modeling and inventory.
• Manage database workload, space and partitions.
• Establish and maintain database backup and recovery policies and procedures.
• Tune code, queries and application code.
• Create and manage user accounts.
• Identify bottleneck and detect data errors.
• Apply software patches to Oracle Database and GRID Infrastructure which includes Bug fix patches, Interim patches, Enhancements patches, RDBMS patches, CPUs and PSUs. etc.
• Write stored procedures.
• Install and maintain applications using Oracle as back ends.
• Monitor database performance and turn performance.
• Provide database utilization reports.

Environment: Oracle 12c, PostgreSQL 10.5, MYSQL 5.7, MS SQL, OEM 13c, PGAdmin III, MangoDB

Project Lead

Confidential, Providence, RI

Responsibilities:

• Planning, implementing and validating various versions of Oracle Databases to 10gR2(10.2.0.4) & 11g R1 & 11gR2 upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and working on proof of concept for Oracle 12c upgrades.
• Installation of 11.2.0.4 RAC (3 node) from the Scratch and the maintenance of the high available Databases.
• Migrated OCR and VOTING disks to newer disks by adding newer disks from SAN and dropping the old disks by using ASM’s native rebalancing feature.
• Installing and configuring Grid Infrastructure & Database software. (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of Clusterware).
• Refresh/Cloning of Database and applications for development and testing purpose.
• Performing Backup/Restore of all the Oracle databases using RMAN.
• Performed migration of the oracle databases whose database sizes vary from GB from Oracle 10g /11gR1/11.2.0.1 to Oracle 11.2.0.4 using Exp/Imp and Expdp/Impdp.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Set up Active Dataguard Configurations for oracle database 11.2.0.4 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.
• Ran Scripts for Health Check on Exadata Storage Servers.
• Implemented Oracle Patches CPU & PSU on the Compliance databases Device a plan to patch them.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Involved in Production Support for Critical Application Databases when needed.
• Installing agent 12c on the server. Adding High Available Database with CRS, Scheduling Backups through OEM12c.
• Scheduling jobs through oracle JOB SCHEDULAR, Crontab (UNIX).
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
• Closely Worked with Oracle support in identifying some long-standing issues. Also, extensively used oracle Metalink.

Environment: Oracle 11.2.0.4, OEM 12c, LINUX, IBM AIX, TOAD, SQL Developer.

Project Lead

Confidential, Trevose, PA

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases to 10gR2, 11gR1 & 11gR2 upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and working on proof of concept for Oracle 11g upgrades.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Involved in installation, configuration and support of Oracle 12c RAC.
• Worked on using the Materialized views for large Data Replication between 2 production databases.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Implemented Oracle Patches (CPU, PSU) on the Compliance Databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN. And legato TAPE backup management.
• Recovering Databases when there is any Physical or Logical Corruption.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Implemented Transparent Data Encryption (TDE) for compliance related databases.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection. Also did Capacity Planning.
• Responsible for purging and archiving the production databases.
• Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
• Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time, ran SQL trace and generated TKPROF reports.
• Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.
• High level of tracing of Optimizer and SQL performance with events 10053, and 10046 etc, recommend any changes required.
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Used DBMS * packages to schedule jobs, re-engineering, gathering statistics, mview refresh...so on.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
• Closely Worked with Oracle support in identifying some long-standing issues. Also, extensively used new oracle Metalink.
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
• Assisted developers with the Tuning during the development and tuned the applications.

Environment: Oracle 9i,10g, IBM Manage NOW, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, LINUX, IBM AIX, WebSphere, Solaris5.9, TOAD, SQL Developer.

Sr. Oracle DBA

Confidential

Responsibilities:

• Involved in 24x7 Oracle Production Database Administration.
• Involved in installation, configuration and support of Oracle 11g RAC.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Performance tuning for optimized results using Explain Plan, SQL*Trace, TKPROF and Statspack.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.
• Created physical standby database (for disaster recovery) from hot backup of primary database.
• Resolved gaps between primary and standby databases (Gap Resolution).
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• Creating Tables, indexes, & triggers to assist developers.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Was involved in developing a disaster recovery (DR) plan.
• Experience with Oracle Golden Gate software.
• Proficiency using Oracle Golden Gate and csscan utility.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Scripts for Health Check of Databases.
• Reading Alert Logs and User trace Files and Diagnosing the Problem.
• Writing UNIX shell Scripts and Scheduling through crontab.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• OS level activities like space monitoring of Mount points.
• Scripts for Analyzing of Tables and Rebuilding of Indexes.
• Taking periodic backup of the database and the software.
• Automation of Backups.
• Interfacing with Oracle Corporation for technical support.
• Environment: Oracle 9i,10.2.0.2,11.1.0.7, Maestro 7.0,HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3,WebSphere,Solaris5.9,Informatica Power center 8.1x and 8.6.
• Managing the network and service changes on the network of the databases.
• STANDBY Database implementation and Automation of the process (KSH, LOADER, PL-SQL scripting combination) of ftp download of files to proper load and update on tables.
• Writing shell scripts, Loading data into the database from the flat files with SQL*Loader.
• Environment: Solaris 2.6/2.8, Oracle 8.0.5, PL/SQL, shareplex, Perl, Windows NT shell scripting, TOAD.