We provide IT Staff Augmentation Services!

Sr. Oracle Dba / Architect Resume

PROFESSIONAL SUMMARY:

Confidential has over 18 years of experience in Design, Development, Implementation, Maintenance and Administration of Oracle database and software packages. He has extensive knowledge and experience in Oracle Database, App Server, RAC Database, Exadata full half and quarter racks and Confidential real time replication including database cloud provisioning both in Oracle & AWS. Mr. Patibandla has expertise of knowledge in setting up, configuring and scheduling Oracle Grid Control on Windows/Linux/Aix clusters including 12c cloud control & 12c database. Hands on experience with Amazon AWS Cloud Administration which includes services like: EC2, S3, EBS, VPC, ELB, AMI, SNS, RDS, IAM, Route 53, Auto scaling, Cloud Front, Cloud Watch, Cloud Trail, Cloud Formation, and Security Groups.

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA / Architect

Confidential

Responsibilities:

  • 12cR1 database both on site, Oracle Cloud
  • Experience in launching Amazon Web Services (EC2, Route53, S3, RDS, CloudWatch, IAM, SNS, VPC, ELB, etc.).
  • Cloud Control 11g & 12c
  • Confidential 10g, 11g, 12c
  • Active Dataguard
  • Exadata ¼ & ½ Rack
  • 12c pluggable databases
  • RMAN backup and recovery
  • Oracle & AWS Cloud provisioning Compute, Storage & Database services
  • Currently trained in Cloudera big data Hadoop admin role and in process of preparing to get certified as CCAH (Cloudera Certified Admin for Apache Hadoop).

Sr. Database Administrator

Confidential

Responsibilities:

  • Senior Oracle DBA responsible for supporting Confidential ’s pre - sales and post-sales activity around the Oracle Stack.
  • Specific area of expertise includes working with customers in a sales support and delivery capacity.
  • Currently supporting a multitude of customers throughout Midwest region implementing and supporting various hardware and software migrations.
  • Designed and engineered a solution by moving them to a new oracle appliance using 3 node 11g RAC with PURE as a SAN solution on a Linux platform.
  • The client was using the old oracle replication between both the sites to keep the systems in sync.
  • Designed and moved the client to use Confidential 11g bi-directional solution and moved them off an unsupported feature.
  • Involved in a two-day training session with one of the client GFS to design a solution to move from a single non clustered oracle 10g database to an oracle super cluster running on Solaris. Gave a road map to implement Confidential 11g between different data centers.
  • 11gR2 11.2.0.4 database
  • 12cR1 database
  • Cloud Control 11g & 12c
  • 11g & 12c Confidential
  • Active Dataguard
  • 12c pluggable databases
  • RMAN backup and recovery
  • Oracle Database Appliance
  • Oracle VM clusters
  • EXADATA ½ & Full Rack

Database Architect

Confidential, Carmel, IN

Responsibilities:

  • Implementing and supporting database for in-house designed custom .net application that receives, validates, stores, and visualizes data from new measurement devices that captures multiple measurements at a rate of 30 samples per second.
  • The current insert volume is around two billion rows per day partitioned daily. It grows at 40 ~ 60TB per year. High availability is maintained using Active Dataguard to sync data between the primary and disaster recovery RAC clusters.
  • 11gR2 11.2.0.3 database
  • Grid Control 12c
  • IBM P7 using AIX 7.1 O/S
  • Hitachi VSP using Oracle ASM
  • Configured, documented and managed end-to-end Confidential processes for data center migration/replication to support the commissioning of a new data center.
  • The work included initial loads using data pump between HP-UX and AIX servers moving from 10g to 11gR2 databases with a very minimum down time.
  • Deployed Confidential plugins on 12c to monitor and send alerts for any lag or other issues related to Confidential extracts and replicates.

Manager / SME

Confidential, Jersey City, NJ

Responsibilities:

  • Managed two teams and engineered four (4) Exadata v2 full racks using Confidential to replicate data and maintain bi-temporal data to support the single version of the truth initiative.
  • Involved in providing on both Exadata and Confidential technical expertise.
  • Above all, looked up as a subject matter expert in implementing Exadata best practices.
  • Extensively involved in fine tuning the Confidential processes to achieve maximum through put through replication on Oracle Exadata servers.
  • Handled around 10TB of data loads on a daily basis.
  • EXADATA V2 four full racks
  • Oracle 11gR2 & 11gR1
  • Confidential
  • Grid Control
  • 64bit Oracle Enterprise Linux
  • Exadata Cell Servers using Oracle ASM

Director of Database Administration

Confidential, Indianapolis, IN

Responsibilities:

  • Utilized columnar compression to bring the current 16TB database to under 10TB using oracle advanced compression.
  • EXADATA ½ rack and ¼ rack
  • 6 node Oracle Linux RAC cluster using 11gR2
  • 4 DB servers and 7 storage cells
  • 14TB on SAS drives
  • Oracle ASM 10g & 11g
  • 11gR1 GRID CONTROL
  • 64BIT Oracle Linux
  • InfiniBand network
  • Confidential
  • ORACLE VM for Development and Staging

DBA Manager

Confidential, Indianapolis, IN

Responsibilities:

  • Administered several senior and junior DBAs while actively involved in moving all Revenue Databases to 10g while building an enterprise level AS10g for the entire department. Built enterprise application server using SSL and converted existing 8i/9i databases to 10g.
  • Built GRID control to manage all Revenue databases from a central point.
  • Installed and configured 10g RAC on a 2 node clustered environment using a shared SAN disk configuration.
  • Helped development teams to fine tune applications using different tools like TOAD, Oracle Enterprise Manage, and GRID Control. Some of the highlights of the work included:
  • Helped SQL Server DBAs in moving several financial databases to ORACLE while acting as a backup DBA for SQL Servers when required.
  • Implemented Replication for major legislative tax databases using Oracle Data Guard.
  • All 10g databases and Oracle RAC used ASM
  • Used different partitioning techniques to distribute state tax data across the SAN.
  • Data Warehouse using Oracle ETL tool OWB (Oracle Warehouse Builder for the entire agency

Senior DBA / Data Architect Manager

Confidential

Responsibilities:

  • Designed the Production, Test, Development and enterprise manager databases,
  • Designed Application Server for all OneStopShop modules
  • Architect the entire design for OneStopShop,
  • Upgraded from 9i RAC to 10g release 2 RAC on a 2 node windows configuration.
  • Operating Systems-Win 2000, Win bit, AIX5L
  • COMPAQ Proliant 6500
  • IBM Netfinity 7600, x440 Servers
  • DELL Power Edge 2950 Dual 64BIT Intel Processors
  • RAID-0, RAID-5 & Enhanced RAID-5
  • Oracle 10g RAC using ASM
  • Application Server (9iAS/AS10g)

Senior Programmer

Confidential, Indianapolis, IN

Responsibilities:

  • Developed universes and ad-hoc reports using Business Objects for a data project.
  • Involved in gathering requirements in creating the universe. Oracle is used for the database.
  • Organized Training for the users on reports and database.

Senior Programmer / Database Administrator

Confidential, Indianapolis, IN

Responsibilities:

  • Responsibilities include using analytical and programming techniques to design, develop, and test different modules, also involved with users and management for analyzing database problems and upgrading the system. Involved in maintenance of TI printers, troubleshooting and writing scripts.
  • Developed different modules which interact with EPA and transfer data using sql*loader and file formats for EPA are done using PRO*C. Using Oracle 7. X, and SQL*Forms 3.0/4.5 developed various screens implementing security checks on the users.
  • The Bi-annual reporting done to the EPA is done using Reports 2.5 and SQL reporting.

Hire Now