SUMMARY

• Experienced in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating MS SQL Server 201, 2012, 2008 R2 and PostgreSQL 9.4 and 10.1.
• Hands on experience on Oracle (9i/10g/11gR1/11gR2), installed and configured on different platforms like Windows, Linux, RHEL, Oracle Solaris, HP - UX., IBM-Aix
• Worked on databases sizes ranging from 500GB to 8TB.
• Worked on Different operating systems for OLTP & OLAP environment on Very Large Databases (VLDB).
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases. ETL and data warehouse design experience, especially with Greenplum.
• Experience in configuring, managing and monitoring both Physical standby and Logical standby database using Data Guard and Have hands on experience on Active Dataguard.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases.
• Having good expertise in data modeling a metadata services.
• Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text indexing, and Database Application Development using varied development tools.
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Utilized SQL* Loader to migrate or load data to Oracle.
• Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.
• Worked on the BMC remedy ticketing system.
• Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.
• Experience using Erwin as a Data Modeling tool & Designing the ETL processes.
• Worked on different types of storage structures (SAN/NAS).
• Good knowledge on Oracle support process for technical requests using Metal link and other support features.
• Good written and verbal communication skills, self-motivated team player and good analytical thinking.
• 24*7 on-call production database support and maintained remotely.

TECHNICAL SKILLS

Database: PostgreSQL 8/9, knowledge of MySQL, Oracle 10g & 11g

NoSQL Technologies: MongoDB, Appache Cassandra and Knowledge on basic concepts on hadoop.

Languages: C, Core Java, SQL & PL/pgsql, Shell Scripting.

Technical Tools: Toad (RDBMS tool for Oracle, pgAdmin, pgStudio

Monitoring Tools: Postgres Enterprise Manager (PEM), pgOn, Nagios, Pivotal Command center.

Operating system: MS-DOS, MS- Windows 9X/NT, RHEL 5, Centos, Solaris 10.

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Aurora PostgreSQL Database Administrator

Responsibilities:

• Experience in AWS cloud infrastructure database migrations, PostgreSQL and converting existing ORACLE and MS SQL Server databases to PostgreSQL, MySQL and Aurora.
• Installation and maintenance of PostgreSQL Databases migration to AWS Aurora.
• Master-Slave Replication setup in PostgreSQL environment
• Performance Tuning within PostgreSQL, Oracle, MongoDB, Cassandra
• Alerts and Trouble tickets executions in - PostgreSQL, Oracle, MongoDB, Cassandra
• Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists
• Setting up privileges to create local and remote objects
• Create materialized views to refresh data at regular intervals.
• Using materialized view logs to reduce the replication time costs for fast refreshes.
• Database Monitoring: Responsible for daily monitoring and managed Database Servers, Databases, Agent, Jobs log files
• Database Automation: Setup automated jobs for different purpose like database maintenance, backup verification etc.
• Troubleshooting: Monitored Server Activity, Error Log, space usage, and solving problem as needed
• Centralized Management Server: Configured centralized management server and add all the server and monitor from one place.

Environment: s & Tools: PostgreSQL 9.5/9.6, MySQL 5.6/5.7, MS Server 2008, 2012 & 2014, Aurora, AWS, EC2 & RDS, Nagios, LINUX, WINDOWS

Confidential, NJ

AWS / Postgre SQL DBA

Responsibilities:

• Converted Oracle and SQL Server databases to PostgreSQL and MySQL .
• Supported more than 1500 databases for more than 289 production servers for 24/7 support.
• Check the Accuracy of the Data being updated and ensure Perfect Reporting and Verify the Data Accuracy through various SQL Queries.
• Having Experience working on Data center servers and handling greater than 1.5 TB databases.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Worked in all shifts and 5 days SNAP (production maintenance) at the maximum handovers.
• Documented all the incidents and presented in a form of report.
• Conducting meeting as a host on various occasions, preparing RCA (root cause analysis) as shift coordinator for several months.
• Supported the agent patching for 12c server transformations.
• Modify PostgreSQL database functions for better performance and structure.
• Optimize Oracle procedures source code for better performance.
• Database physical modeling and normalization using SQL Developer and pgModeler.
• Prepared the document for applying quarterly UNIX patch over several databases.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Installed the fresh homes for 11.2.0.4 on Linux servers.
• Supported SAN Migration and ASM migration, allotted new candidate disks.

Environment: PostgreSQL, MySQL, PL/PGSQL, Shell Script, Windows, SUN Solaris, Linux, AIX.

Confidential, NJ

Oracle DBA

Responsibilities:

• The project had medium to large enhancements on the existing Insurance Rating System.
• Worked both as Business Process Analyst and an IT Business Analyst.
• As a Process Analyst, Understood the ways different competitors worked and what was needed in our system to compile all the data required to enhance our system. This required working with the business stakeholders to create a standardization business process.
• Worked closely with business and product manager to work out the business processes before going into sprints.
• Enhancements made using the Agile Scrum framework in four week sprints.
• Worked closely with the SCRUM Master to understand the sprint needs.
• Worked with the Product Manager to understand the initial need of the business.
• Worked to organize the sequential sprint backlogs and deployments as per business defined priority.
• Updated priority and complexity numbers based on input from product owner, development lead and quality analyst lead during product backlog meeting sessions.
• Worked with business to define the user story statement and then dove into writing user story narrative and acceptance criteria.
• Analyzed, elicited, and documented requirements with user stories.
• Created user stories, with user phrase, user narrative, and user acceptance criteria components and obtained sign-off.
• Participated and occasionally facilitated daily standup meetings for the team status.
• Provided demos to the product owner on completed functionality to gather input and other changes during the user story development.
• Highlighted and removed roadblocks for the Scrum Master.
• Managed requirements churn and scope creep during sprints.

Environment: Requisite Pro, MS Visio, Business Objects, SQL, QTP, Microsoft SharePoint 2003,UML, RUP, UAT, db2, Mercury Test Director, SQL, PL/SQL

Confidential

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues.
• Involved with installation and maintenance of ORACLE RAC 3 node and adding a node to this cluster database for high availability on Linux.
• Installation, Configuration and Maintenance of RAC, Standby database. upgraded Databases from 10.2.0.4 and to 11.2.0.1.
• Knowledge in handling and Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database using OEM.
• Duplication of Databases from Production RAC to test RAC using RMAN active cloning.
• Involved in migrating non-RAC databases to RAC environment on ASM.
• Converted single instance database to RAC Database using R-CONFIG.
• Configured and installed 15 standalone DR servers on ASM.
• Implementation and configuration of Oracle golden gate.
• Worked on databases sizes 8TB and involved in scheduling backups.
• Applied patches to Oracle Databases using Opatch utility and upgraded databases manually.
• Involved in migrating HP-Unix databases from 9i, 10g, and 11gR1 to 11gR2 Linux.
• Implemented Disaster recovery for production databases using Dataguard.
• Have hands on experience in creating physical standby databases, and involved in converting physical to snapshot standby.
• Implemented 11g new features for building Active Data-guard.
• Configured Dataguard-broker and involved in registering of databases in Dataguard broker using utility DGMGRL.
• Extensively used data-pump at schema level and Database level for moving data from Solaris to Linux during migration
• Performed database refresh from production to test environment in both RAC and NON RAC environment using RMAN.
• Installed and Implemented Backup & Recovery procedures using RMAN.
• Performed Block Recovery, data file recovery using RMAN.
• Configured RMAN retention policy, archive log deletion policy for Production databases.
• Maintained catalog server and registered databases in catalog server.
• Performed Database refresh using RMAN active cloning and data-pump.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, RAW Devices.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS - Netback up Team.
• Involved in SQL tuning by generating explain plan, ADDM, AWR and TKPROF.
• Installed 12C GRID CONTROL and registered databases in GRID control.
• Familiar with ORA-600 error. Involved with this ERROR.
• Involved in Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, Oracle Solaris 10, Linux 5.x,6.x, Toad, SQL, PL/SQL, Toad, Data-Pump, OEM, RMAN, XML, Shell Scripting.

Confidential, Dallas, TX

Oracle DBA Consultant

Responsibilities:

• Requirements gathering for providing Offshore Support for various applications Oracle EBS 12.2.3, EBS 12.1.3, SOA, Oracle WebCentre, OBIEE, Oracle HTTP servers and etc.
• Driving Offshore teams based on Onsite DBA's requirements for Installations, Upgrades, Clonings, Patching, Code Migrations, Deployments and Issues troubleshooting.
• Performing Development servers maintenance activities like Server reboots through OVM, volumes mounts&unmounts, Package Installations
• Successfully prepared and Documented first clone of Oracle EBS R12.2.3 Instance.
• Documents preparation as per Oracle Standards (D0XXX).
• Supporting Development teams for Code Deployments Procedures on R12.2.3 Instances.
• Applying Patches using adop on R12.2.3 and adpatch on R12.1.3
• Troubleshooting various issues of R12.2.3, R12.1.3 Instances
• Working with SA teams for new servers preparation and validations
• Performing Weekly filesystem level Snapshot Offline Backups for all non-prod servers.
• Configuring Load Balanced URL for Oracle EBS R12.1.3 and R12.2.3
• Installation of WebLogic Server 11gR1 and Oracle HTTP server
• Installation of Oracle SOA Suite 11.1.1.7
• Installation of Oracle Web Center Content Management (WCC) 11.1.1.7 and Oracle Web Center Portal (WCP) 11.1.1.7

Environment: Oracle EBS 12.2.3, Oracle EBS 12.1.3, Oracle Database 11.2.0.3, OAS 10.1.3.4, Web Logic 11gR1, SOA 11.1.1.7, Web Center, Oracle HTTP Server, OEM 12c, OVM, Operating System: RHEL 6/5.