Candidates About

 

Robert  Kurapatti

Professional Summary

Robert has 18+ years of well rounded, proven IT experience in Architecture, Design, Development, Testing and Implementation of large scale data management solutions with focus on AWS Cloud, Oracle Databases. In his career, Robert has experience paying the roles of AWS solution architect, Technical Manager, Enterprise Data Architect and Oracle Database Administrator.

Expertise: Technical Management, Data Management, Solution Architecture

3+ years of experience in managing IT professionals as a Technical Manager, with demonstrated ability to lead development DBA team (7-8) in both architectural and Technical aspects of development environments.

8+ years of Database Architecture experience, primarily with Oracle Database Administration, Data Migration projects.

Expertise in Data Modeling and Metadata Management, and experience in developing and maintaining large enterprise data models (LDM & PDM).

3+ years of experience in AWS Cloud infrastructure, migrating oracle databases from on premise to AWS Cloud, Install, Maintain and Rehydrate EC2 instances, install, maintain RDS Oracle Databases and Install, Manage AWS Redshift

15+ years of development experience using Oracle database platform.

 Energetic and proactive IT professional with a sharp aptitude for problem solving, and right attitude to collaborate with extended IT teams/Vendors/Partners to foster a productive work environment.

Possess excellent written and verbal communication skills, with demonstrated expertise in presenting IT solutions and architecture roadmap to senior executives

 

PROJECT SUMMARY

CapitalOne, Mclean VA, USA                               Jan ’16 - Present

 

Senior DBA Lead/Architect at CapitalOne, Mclean VA

As a DBA lead, managed different projects, assign work to DBA team. Introduce new technologies in AWS cloud. Performed POC for setting up Redshift, EC2 and RDS instances for different projects. Working on migrating 20 TB oracle Database on Exadata server to AWS oracle database on EC2 server

 

DBA Lead Responsibilities

 

·         Major responsibilities on supporting and maintaining Oracle Financial Services Analytical Application (OFSAA) is the application which uses Oracle Database 11g of 100 TB in size running on 4 node EXADATA Cluster.

·         Applying quarterly patches on Oracle Databases running on EXADATA servers

·         Upgraded Database servers from EXADATA 5.0 to 6.0 servers

·         Automated archival data to archive schema older than 6 months

·         using EHCC compression which saved 90% storage space.

·         Currently working on POC for migrating on premise Oracle databases on EXADATA to Oracle Database on AWS EC2 instance

·         Addressing performance issues on migrating database from EXADATA to AWS EC2 instance

·         Actively involved in performance tuning on LCR (Liquidity Risk Management) daily reports

·         Automated refresh schemas using dbms data pump

·         Migrated 11g on premise database to AWS RDS instances using Oracle Data Pumps

·         Identified tables and partitioned using Range Interval Partition. Used REDEF method to migrate data from non-partition to partitioned tables

 

 

FannieMae, MD, USA                                                                                 July ’14- Jan ‘16

 

 

Senior Oracle DBA/Architect at FannieMae, Bethesda, Development

As a senior Oracle DBA, gathered requirements from various development teams and created database solution architecture to meet business needs. In addition, worked on implementing the solution by working with the data modelers to create the physical data model and creating the required database structures. Worked with other DBA teams and identified new hardware and storage to setup new environments. Created a blue print for High availability solutions involving various oracle database systems.

 

Oracle Development DBA responsibilities

 

·         Worked on analyzing development requirements for each sprint and provided feedback to the development teams.

·         Worked on building database scripts for development teams and deployed scripts through flyway for each sprint.

·         Worked on creating stored procedures, packages and functions.

·         Worked as a ER Studio Data Architect

·         Worked on building LDM/PDM and reverse engineering database scripts from PDM using E/R Studio (Embarcadero software).

·         Worked with CSP development team to setup a Data Mart environment for securitization project. Collecting Business entities and building Logical and Physical data models for Data Mart.

·         Worked/assist other oracle DBA team to troubleshoot database issues.

·         Prepared requirements for Hardware, Storage and Oracle software to setup new environments

·         Setup replication using Oracle Golden Gate tool. Prepared user guides to install, setup and configure OGG (11.2.1) for oracle 11.2.0.4 databases.

·         Worked on RDS databases on Amazon Cloud Control.

·         Worked on create, configure and manage AWS RDS oracle databases.

·         Worked on performance tuning on AWS RDS databases.

 

 

US PTO, VA USA                                                                            May ’13 – July ‘14 Oracle DBA Manager at USPTO Alexandria, Development and Production Support

 

As Oracle DBA Manager managed several Oracle DBA resources supporting various database systems. Provided support for 400 Sun, Linux and HP servers and databases in 9i RAC, 10g RAC and 11g (11.2.0.4) RAC. Provided oracle database expertise and technical assistance in planning, upgrade/migration, implementation, software installations and database lifecycles in development, Test and production. Using Oracle Golden Gate replicated terabytes of data between databases.  Responsible for prioritizing, assigning tasks and coordinating with business, testing and development teams in support of various initiatives. Able to work under pressure and deliver per project schedules. Some of the key accomplishments are:

 

·         Upgraded 10g RAC databases to 11g using oracle data pump

·         Installed, Configured 11g RAC databases on Linux Redhat systems.

·         Prioritized tasks and assigned them to team members

·         Installed, configured replication between databases using Oracle Golden Gate 11.1.1

·         Installed 12c Oracle Golden Gate and configured replication for 11g databases

·         Working on upgrading Oracle Golden Gate from 11.1.1 to 12c

·         Troubleshoot Oracle Golden Gate issues using log dump

·         Worked on troubleshooting Oracle Golden gate data issues

·         Worked on performance issues on 11g databases

·         Worked on tuning sql queries on 11g databases

·         Worked on install/configure/setup 11g oracle golden gate replication on several environments

·         Worked on creating database links from oracle to heterogeneous databases like my sql using oracle open gateway

·         Installed, configured and administered  projects in SQL 2012

·         Resolved Performance issues in SQL Server and Oracle.

·         Oracle PSU patch management and Service packs on SQL server.

·         Automating Database refreshes on SQL Server and Oracle instances.

 

Environment: Sun Solaris 5.10,  Linux Red Hat 6.4

 

Real Networks, Reston, VA USA                                                            Jan ’07 – May’13

Lead Sr. Oracle Database Administrator, Development and Production Support

Oracle System DBA support for various datacenter systems. Provide support for 200 SUN, AIX and Linux servers and databases in Oracle 9i RAC, 10g RAC and 11g RAC.  Provide Oracle database expertise and technical assistance in the planning, database upgrade/migration, implementations, software installations and database lifecycles in development, test and production.

Define and Promote Enterprise standards, Architecture and Controls.  Responsible for defining and standardizing processes across enterprise. Provide on call support for various client teams. Act as a mentor for other junior Database administrators on the team. Responsible for prioritizing, assigning tasks and coordinating with business, testing and development teams in support of various initiatives. Able to work under pressure and deliver per project schedules. Some of the key accomplishments are:

• Created and managed 9i 2 node RAC Database with Sun cluster on Sun servers
• Developed a process and implemented 9i RAC database with raw files to a 9i RAC database to cooked file systems using physical Standby
• Upgraded 9i 2 node RAC database to 10g RAC Database on the same hosts using Data guard
• Created and managed 10g 4 Node RAC with oracle cluster ware on Sun
• Created and managed 11gR2 Database on Sun and AIX servers
• Installed, setup and Configured 10g and 11g grid control
• Used 10g and 11g grid control to monitor prod databases
• Created and managed 11g Data Guard Database
• Created and managed 10g Data Guard Database
• Supported production databases in Reston, Seattle and Germany Datacenters
• Configured Grid control to monitor databases in each data center
• Configured 10g,11g RMAN Backups to disk
• Configured 10g RMAN backups to tapes using Veritas NetBackup
• Experienced recovering 2TB 10g prod RAC database from tape (Veritas NetBackup)
• Migrated 11g databases on Linux from old ASM storage to new ASM storage
• Reviewed and implemented application scripts using change management process
• Worked and troubleshoot on performance issues on 10g, 11g prod databases
• Created dev, test, Ptest, load test, prod databases in 10g, 11g
• Upgraded 9i 3 node cluster to 11gR2 using Transport Tablespaces
• Trouble shoot performance issues on 9i, 10g, 11g databases and address them
• Partition tables using Oracle REDEF Technology to minimize down time
• Installed 11gR2 Standard Edition RAC for small projects to minimize licensing cost
• Set up SMO Netapp backups for production systems and scheduled backups through SMO scheduler
• Installed and configured 12c grid control on Sun Solaris system to monitor 11g R2 production databases

 

Environment: Sun Solaris 5.10, AIX 6.1, Linux

 

EDS Corporation, Herndon, VA USA                                     Feb’02 – Jan ‘07

Sr. Oracle DBA, Oracle Production Support

Oracle System DBA support for SPRINT NEXTEL wireless communications. Provided support for 150 SUN, HP and NT servers and databases in Oracle 8i, 9i and beginning to use Oracle 10g. Provided Oracle database expertise and technical assistance in the planning, database upgrade/migration, implementation, and support of Oracle software installations and database lifecycles in development, test and production.

• Implemented and supported Oracle 9iR2 Real Application Cluster database environment. 

• Mentored new DBA’s in the production support environments and processes. Collaborated with various groups to develop a robust process to log and track all production activities.  
• Implemented RMAN backup and recovery using Legato direct to tape
• Worked on identification and resolution of database performance issues.
• Developed and promoted standardized and best practice processes for production support to utilize scripts and tools consistently across the enterprise.
• Maintained three terabyte Production Online System, running on Sun Solaris.
• Installed and configured Oracle Parallel Server (OPS) using Oracle Parallel File system (OPFS) for a Sun cluster.
• Replicated Online Billing data using Shareplex, Quest Tool. Performed Sharplex upgrades on the highly visible revenue impacting production systems.
• Replicate tables using Materialized Views

 

Environment: Sun Solaris, HP, NT

 

Nextel Communications, Herndon,  VA USA   Jan 98 – Feb 02 

Senior Oracle DBA

As part of the Oracle Database team supported various business critical projects by providing Database administration support to development and production teams.  Responsibilities include

·         Performed Oracle software installation in Oracle 8i.

·         Upgraded Oracle 7 database to Oracle 8i database. 

·         Responsible to create database, performance tuning, backup and recovery implementation.

·         Utilized and developed UNIX scripts to monitor the databases. Used Oracle Management Server for automated alert paging.  
Provide technical assistance to programmers and recommendations to management on efficiencies, productivity, and measurements.

·         Developed UNIX scripts for standardizing repetitive processes.

 

Environment: Sun Solaris, HP, NT

 

Principle Health Care, MD USA                                                  Jan 95 – Dec 97  

Oracle Database Administrator

 

Installed oracle financial applications 10.6. Created and set up the database applications. Developed custom forms and reports. Created custom interfaces to migrate from legacy system to oracle applications. Set up repository for Developer/2000.

·         Tuned databases with proper init parameters.

·         Created tablespaces with datafiles spread across disks and controllers to get optimal performance.

·         Created users, profiles and roles and assigned roles to users. Created database links.

·         Tuned sql queries. Tuned database with utlbstat and utlestat scripts. Tuned rollback segments to avoid contention. Tuned SGA  i.e. tuning library cache, data dictionary cache, database buffer cache and redo log buffers.

·         Set up scripts to run as Unix Cron job to do daily exports and hotbackups.

·         Initiated and planned recovery procedure.

 

Environment: Sun Solaris, NT

 

 

CSD, NJ USA                                                                                               Aug 94 – Jan 95  

Database Administrator

 

Responsible for Installing, upgrading, database creation, backup, recovery, capacity Planning, tuning and maintaining Oracle Databases.

·         Created users, roles, sequences, synonyms and database links.

·         Tuned databases by changing various parameters, laying out tablespaces to span disks to reduce I/O contention etc.

·         Wrote shell scripts to automate backups and exports every night

·         Also responsible for setting up and troubleshooting sqlnet and various related networking issues

 

Aptech Computers,  Chennai,  India                                         Jul 92 – Jul 94  

Programmer/Analyst

 

Developed Hotel Management System in Client/Server architecture using Oracle7.1/Unix and its front-end tools Oracle*forms and Oracle*Reports. Database was implemented by creating rules, defaults, stored procedures and triggers to store, retrieve and update data.

·         This application will facilitate the user to take checkins, checkouts, reservations, cashier’s report, daily transaction report, sales summary report and auditor’s report.

 

Education

George Mason University – VA, USA

MS Information systems 
Loyola College – Chennai, India

M.Phil, Mathematics

St. Joseph’s College – Trichy, India

MS Mathematics
Sacred Heart College – Tirupattur, India

BS Mathematics

Certifications

Certified Solutions Architect Associate 2017

Certified Developer – Associate 2017

Core Competency Areas

Data Management                          Project Management            IT Architecture

Database Management                  Project Initiation                      Data Architecture

Data Warehouse                              Project Planning                     ETL Architecture

AWS Migration                                 Project Execution                    Systems Architecture

Master Data Management              Operation and Maintenace    Backup & Recovery

Metadata Management                   Release Management           Capacity Planning

 

                         Technical Skills

Operating Systems	Unix (Solaris 5.8/8.0/10.0, AIX 4.3.3/5.2/6.1, MP-RAS SVR4), Windows Server 2005/2008 Enterprise Edition, SuSE Linux 10
Programming/Scripting Languages	SQL, PL/SQL, Perl, Shell Script (Korn, Bash, Csh)
Databases	Oracle 7/8i/9i/10g/11g/12c AWS PostgreSQL, Redshift, RDS