We provide IT Staff Augmentation Services!

Sr. Database Architect Resume

Sunnyvale, CA

EXPERIENCE SUMMARY:

  • Over 12 years of experience as Database Architect /System Architect/Designer working on following key deliverables.
  • Authored solution Architecture document for production as well as disaster recovery site.
  • Authored, Designed and Implemented High availability architecture model for core production system.
  • Documented and implemented Hardware platform migration for core financial system to enhance system performance.
  • Identified, fixed and documented performance bottlenecks for core financial systems as well as middle - ware systems.
  • Implemented and documented Best practices for production environments.
  • Analysed system growth pattern and performed capacity planning, server sizing for Hardware resources for sustaining future system growth.
  • Evaluated various storage replication technologies and provided suggestion to client which helped them to narrow down on vendor selection.
  • Evaluated technology stack for obsolete or de-support technologies and suggested upgrade methodologies.

TECHNICAL SKILLS:

Line of Business: Finance, Manufacturing, Banking (Credit Rating), Information

Line of Technology: - Oracle Applications, Oracle Database, SQL Database, Oracle SOA, Web logic

Computer System: Unix: HP-PARISC,HP-Itanium, Sun-Solaris 10, Red Hat Linux,Windows Server 2008

Programming Languages: SQL, PL/SQL, Unix Shell scripting, Python

Special Software: Tools & S/W:Oracle Applications Manager, OID, PL/SQL developer, SQL*Plus, VNC, Kintana, MTT, STAT, TeamPass, Getpaid,OEM 11g and cloud control 12c etc

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Sr. Database Architect

Responsibilities:

  • Design Documented and implemented High availability architecture for Production system.
  • Oracle E-business Suite R12.1.1 integration with Oracle SOA 10gAs.
  • Evaluate and Designed system configuration and hardware sizing for sustaining increased End User base.
  • Implementing Best Practices for secure E-business environment.
  • Integrated Core Financial application system with Discoverer 10g for Reporting application.
  • Implementation of RAC environment for our Database and performing the Tuning monitoring and load-balancing and patching etc.
  • Implemented advanced configuration in E-Business suite (workflow mailer notification configuration) as per client request.
  • Design and develop solutions to complex applications problems, system administration issues. Also provided production support for maintaining the system developed and resolve the complexities and bugs raised by customers efficiently and effectively on time.
  • Analysed user requirements, procedures, and problems to automate and improve existing financial systems.
  • Communicate with staff or Clients to understand specific requirements and design solution to support that requirement.
  • Interact and co-ordinate with stake holders when an issue is reported for Business-critical systems and perform initial troubleshooting to resolve the issue.
  • Analyze production systems for performance issues and work towards resolving them.
  • Strong knowledge of various Patching model like Critical Patch Update (CPU), Patch Set updates (PSU), Security Patch Update (SPU) and Bundle Patches.
  • Performed various cloning of instance from production to Non-prod and other various environments as par business needs.
  • Suggested and implemented standard best practices for technologies in ERP and SOA
  • O365 Mailbox migration
  • SSL Renewal
  • Upgrade of Java 7 on Oracle E-Business Suite Release 12.1
  • Installation of M4Apps application and perform Upgrade.
  • Installation and maintenance of Getpaid Application and upgrade.
  • Oracle E-business and SOA administration.
  • Implementing High Availability solution for ERP Database.
  • Proactive Monitoring - Developed Shell scripts to automate the monitoring of services and performance.
  • Capacity planning for servers and server storage.
  • Oracle Applications and Middleware administration.
  • Oracle 11g Database administration.
  • Using Oracle advisories for SQL Tuning.
  • Maintaining Database security by creating Roles, Privileges and Profiles.
  • Troubleshooting and providing production Supporting.

Environment: Oracle Applications 11.5.10, Oracle Application R12.1.3, Oracle PLSQL Developer, CVS, PVCS, SVN, Oracle Database 12c, 11.2.0.4, 11.2.0.3, SQL, PL/SQL, Shell Scripting., Sun Solaris-SPARC, Red hat Linux, Windows, UNIX, Linux, Windows server 2008 R2

Confidential, Atlanta, GA

Sr. Oracle Database Architect

Responsibilities:

  • Design, Documented and implemented High availability architecture for Production system.
  • Oracle E-business Suite R12.1.1 integration with Oracle SOA 10gAs.
  • Evaluate and Designed system configuration and hardware sizing for sustaining increased End User base.
  • Implementing Best Practices for secure E-business environment.
  • Integrated Core Financial application system with Discoverer 10g for Reporting application.
  • Implementation of RAC environment for our Database and performing the Tuning monitoring and load-balancing and patching etc.
  • Implemented advanced configuration in E-Business suite (workflow mailer notification configuration) as per client request.
  • Design and develop solutions to complex applications problems, system administration issues. Also provided production support for maintaining the system developed and resolve the complexities and bugs raised by customers efficiently and effectively on time.
  • Analysed user requirements, procedures, and problems to automate and improve existing financial systems.
  • Communicate with staff or Clients to understand specific requirements and design solution to support that requirement.
  • Oracle E-business and SOA administration.
  • Implementing High Availability solution for ERP Database.
  • Proactive Monitoring - Developed Shell scripts to automate the monitoring of services and performance.
  • Capacity planning for servers and server storage.

Environment: Oracle Applications 11.5.10, Oracle Application R12.1.3, Oracle PLSQL Developer, CVS, PVCS, SVN,SQL, PL/SQL, Shell Scripting., Sun Solaris-SPARC, Red hat Linux, UNIX, Linux, Windows server 2008 R2

Confidential

Senior System Architect

Responsibilities:

  • Design, Documented and implemented High availability architecture for Production system.
  • Oracle E-business Suite R12.1.1 integration with Oracle SOA 10gAs.
  • Evaluate and Designed system configuration and hardware sizing for sustaining increased End User base.
  • Implementing Best Practices for secure E-business environment.
  • Integrated Core Financial application system with Discoverer 10g for Reporting application.
  • Implementation of RAC environment for our Database and performing the Tuning monitoring and load-balancing and patching etc.
  • Implemented advanced configuration in E-Business suite (workflow mailer notification configuration) as per client request.
  • Analysed user requirements, procedures, and problems to automate and improve existing financial systems.
  • Communicate with staff or Clients to understand specific requirements and design solution to support that requirement.
  • Interact and co-ordinate with stake holders when an issue is reported for Business critical systems and perform initial troubleshooting to resolve the issue.
  • Analyze production systems for performance issues and work towards resolving them.
  • Implementation and configuration of DR in our environments.
  • Performing various Oracle Backups like RMAN, Exp imp backups and monitoring them if they are completed successfully.
  • Suggested and implemented standard best practices for technologies in ERP and SOA

Environment: Oracle Applications 11.5.10, Oracle PLSQL Developer, Kintana, MTT, CVS, PVCS, SVN, IMSCAN, STAT, MS SQL server 2008 R2,SQL, PL/SQL, Shell Scripting., Sun Solaris-SPARC, Red hat Linux, UNIX, Linux, Windows server 2008 R2

Confidential

Senior System Architect

Responsibilities:

  • Design, Documented and implemented High availability architecture for Production system.
  • Performed Database upgrade from 10.2.0.4 to 11.1.0.7
  • Oracle Database11g installation for production system.
  • Monitoring Database health (tablespace, datafile,object size)
  • Monitoring long running sessions in database and taking proactive action.
  • Implementing Oracle security and managing user account.
  • Monitoring user sessions and implementing resource limit to avoid over consumption of DB resource by user sessions.
  • Taking regular logical and physical RMAN backups.
  • Providing test environment setup for development team by cloning exercises using RMAN
  • Perform RAC level monitoring like Administering Oracle Clusterware components like Voting Disk and Cluster Registry. Adding and Deletion of Nodes & RAC Instances. Oracle RAC Database Backup and Recovery Solutions.
  • Oracle E-business administration.
  • Proactive Monitoring - Developed Shell scripts to automate the monitoring of services and performance.
  • Capacity planning for servers and server storage.

Environment: Oracle Enterprise Manager, RMAN, Pl/SQL Developer, SQL Developer, VSS, SQL, PL/SQL, Shell Scripting., Sun Solaris-SPARC, Red hat Linux, Windows, UNIX, Linux, Windows 2003 R2

Confidential

Junior System Architect, Oracle Core DBA

Responsibilities:

  • Installing oracle 10g for Development and UAT environments.
  • Performing oracle User management, assigning different profiles/role for service and development users.
  • Performing regular DB health checks using OEM.
  • Monitoring DB growth and performing database housekeeping activities.
  • Analyzing AWR reports for performance tuning.
  • Taking logical backups using expdp oracle utility.
  • Performing RMAN Backup of database to safeguard from User errors and Media failures. Oracle E-business administration.
  • Proactive Monitoring - Developed Shell scripts to automate the monitoring of services and performance.
  • Capacity planning for servers and server storage.

Environment: Export- import Pl/SQL Developer, Oracle 8i, 9i, 10g, SQL, PL/SQL, Shell Scripting., Sun Solaris-SPARC, Red hat Linux, Windows, UNIX, Linux, Windows 2003 R2

Hire Now