SUMMARY

• 15+ Years of overall industry experience preferably on Database Architect or Database related skills and having knowledge on development of lifecycle management of the databases, installation and configuration of PostgreSQL, performance monitoring, Architecture, Administration, disaster recover, migration, connectivity, and shell scripting.
• 5+ years of experience on core AWS services, uses, basic architecture and best practices Strong Knowledge in Aurora databases, AWS RDS, Postgres, AWS DMS Ability to write, debug and optimize complex Postgresql queries
• Experience in managing AWS Aurora upgrades to higher versions
• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases. ETL and data warehouse design experience, especially with Green plum.
• Proficient with all major PostgreSQL procedural languages (PL/PgSQL, PL/Perl, PL/PgPython, PL/TCL) as well as some Oracle PL/SQL and SQL - Server T-SQL.
• Configure / Troubleshoot Replication (BSR / xDB SMR / xDB MMR)
• 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 configuring high availability systems like Real Application Clusters (RAC).
• Experience in installation of Oracle RAC with ASM and manage RAC instance using Crsctl and Svrctl utility.
• Setting up databases in AWS using RDS.
• Installation of RedShift data warehouse on AWS clusters.
• Maintaining the security groups in EC2, VPC and controlling the inbound and outbound traffic.
• Deployment of virtualized workloads using EC2, VPC, Auto Scaling and Elastic Load Balancing using step by step manual process or using Cloud Formation templates.
• Monitoring of Cloud Applications and resources using AWS Cloud Watch.
• Knowledge about loading and streaming of data applications using AWS Kinesis.
• Migration of homogeneous and heterogeneous databases to AWS using Database Migration Service.
• Migration of Web Servers to AWS using AWS Server Migration Service (SMS).
• Installation of Word Press website over AWS using AWS Cloud Formation. The MySQL database was multi AZ deployed and Apache web server installed on AMI-EC2 instance. The stack deployed with Load Balancing and Auto Scaling.
• Issues using grid control (OEM).
• Experience in installation and configuration of Oracle Golden gate (both unidirectional and bidirectional).
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports using OEM.
• Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.
• Experience in implementing and planning backup and recovery strategies using Recovery Manager (RMAN). Performed block recovery, data files and databases using RMAN.
• Created clone databases for development and test environments using RMAN and User managed cloning and Implementation of Flashback Technology.
• Installed patches using Patch utility and upgraded databases from 9i/10g to 11gr2 and expertise in applying Oracle PSU and CPU patches.
• 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

RDBMS: Oracle 11gRAC/10gRAC/10g/9i.

Operating Systems: Red Hat Linux RHEL 4.x, 5.x 6.x, Sun Solaris 5.8/5.9/5.10 and Windows 2000/2003, HP -UNIX 5.9, AIX 5.1/5.2/5.3

Languages: SQL, PL/SQL, C++, C, UNIX Shell Scripting, XML.

Web Tools: HTML

Tools: /Utilities: Oracle Enterprise Manager (OEM) Grid Control, Toad, RAC, SQL Navigator, SQL*Loader, AWR, Patch Management, SSIS, Humming Bird/xming (X-windows),Data pump, Data Guard, Remote desktop Server, WebEx and Net Meeting, JDBC, MS Office.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

PROFESSIONAL EXPERIENCE

Confidential - Bristol, CT

AWS DBA

Responsibilities:

• Perform AWS Cloud DBA cum Data Architect to Analyze the requirement, estimate and provide solution on critical requirement and assess the required AWS components as part of architectural requirement
• Prepare presentation on the solution blueprint, provide demonstration, create SRS, Design Architecture, prepare Design Document
• Perform system/architecture study of various system and provide AWS enable solution with the goal of faster AWS adoption
• Migrated MySQL database from on premise to AWS cloud.
• Migrated Oracle database to AWS Aurora database using AWS Database Migration Services (DMS).
• Deployed a WordPress website that is Multi AZ enabled using AWS CloudFormation.
• Planned a backup and recovery SOP for the company’s RDS infrastructure.
• Perform System study and requirement Analysis of the existing legacy system and understand the existing data model and design the new Logical & Physical data model and Semantic data model with Naming standards using
• Prepared and presented the Data Models to the clients and implement industry standard naming standards
• Involved in Effort estimation, Develop project plan, maintain RAID log, Ensure effective quality control processes are in place to monitor deliverables
• Analyzed the business requirement and existing source systems to capture data flow in Conceptual model
• Design the Physical data model using Erwin 9.5 for the system as per the naming standards and do reverse/forward engineering of the physical model
• Work with the Project team to setup the Development, Test and Production environments
• Pull data from AWS RDS(SQL Server) for one of the data source and load it into DW
• Perform few POCs to provision AWS Redshift for future state Architecture
• Define data migration strategy, scripts creating tables/views, loading the data in the development and test environment
• Organize weekly and monthly meeting with all the project stakeholders for project review
• Maintaining client relationships, ensuring timely and quality delivery for overall success of the project
• Giving various functional & technical solutions and implementing the best practices

Environment: AWS Aurora DB(MySQL), Redshift, Glue, Athena, EC2, S3, Informatica Cloud, Data Modeling using Power Designer, ETL Design, QlikSense report design.

Confidential - CA

PostgreSQL DBA

Responsibilities:

• Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.
• Perform installations and upgrades of PostgreSQL (Preferably PPAS 9.4+)
• Plan and perform DB Patching.
• Knowledge of Database backups / Troubleshoot failures, query execution plans, performance tuning techniques
• Experience in Oracle to Postgres DB Migration
• Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc.
• Daily log analysis using pgbadger tool and query tuning.
• Maintaining custom vacuum strategies at table and db level.
• Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.
• Monitoring the bloat repot on every table and performing maintenance with minimal downtime.
• Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.
• Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
• Identifying and resolving incidents and address to user problems/concerns
• Attending initial sales calls to Offer technical solutions for customer queries in pre-sales cycle
• Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.

ENVIRONMENT: PostgreSQL, Oracle 11g, 10g, Golden Gate, Linux, Solaris, RMAN, Data guard, SQL*Loader, TKPROF, EXPLAIN PLAN, AWR, ADDM, RAC, Expdp and Impdp, IPMon, JIRA.

Confidential - Irving, TX

Oracle DBA

Responsibilities:

• Setup monitoring for 240 Databases using Oracle Enterprise Manager (OEM) 12c.
• Created Oracle RAC 11gR2 databases with ASM File system on Oracle Exudates Servers.
• Implemented Dataguard setup for production databases using Oracle Enterprise Manager (OEM) 12c.
• Implemented Incident rule creation, Mail Server registration, Email subscription and repeated alert notification in OEM 12c.
• Converted the single instance standby database to RAC using Oracle Enterprise Manager (OEM) 12c.
• Refreshed 14 test and development databases with production data using RMAN duplicate database feature with set until time clause.
• Generated CPU Utilization, Memory Utilization and Database growth reports using Oracle Enterprise Manager (OEM) 12c.
• Registered newly built databases in OEM 12c and deleted the targets associated with obsolete databases from OEM 12c.
• Configured commvault to run RMAN full backup production, test and development databases using RMAN.
• Successfully compared schemas across databases using Toad and Oracle Enterprise Manager (OEM) 12c.
• Dropped the obsolete databases using DBCA utility to retrieve space.
• Installed and Configured Golden Gate Setup for replication.
• Migrated a 200GB table with LOB column across different table space to shrink it by 75% after data purge by application team.
• Gathered table and schema level statistics on a regular basis using Toad.
• Performed Metric Extension creation, publication, deployment, upgradation and deletion in OEM 12c.
• Monitored the performance of the database using Cloud Control 12c and AWR reports.
• Converted the single instance standby database to RAC using Oracle Enterprise Manager (OEM) 12c.
• Tuned SQL queries in Exudates and was able to increase the performance for some queries by 70%.
• Migrated web services database of 300GB size from AIX 6.1 to Linux 6.2 in 4 hour window
• Monitored health of the databases using precise software.
• Implemented Template creation, deployment and customization in OEM 12c.
• Setup LDAP Entries for the newly built oracle databases.

Environment: Oracle 11g, Oracle 10g, Red Hat Enterprise Linux 5.8/6.2, Oracle RAC, Cloud Control 12c, RMAN, Precise, Toad, Commvault, Oracle Linux 5.8