We provide IT Staff Augmentation Services!

Database Architect Resume

Fort Worth, TX

SUMMARY

  • Experience in various aspects of information processing ranging From Client/Server application design and development, Physical Database Design, Enterprise Modeling, Database Performance tuning, Backup & Recovery, Database architecture design and development.

TECHNICAL SKILLS

  • 10.2g, 11g and 12c RAC
  • Oracle Enterprise Manager 11gR2
  • RMAN Backup and Recovery
  • ASM Storage.
  • Data Guard
  • Oracle GoldenGate
  • Exadata
  • Foglight Performance Analysis
  • Korn/Bash Shell Script
  • OEM
  • Grid Control
  • PL/SQL
  • SQL
  • SQL/Plus
  • SQL - Loader
  • SQL Developer
  • TOAD
  • SQL Navigator
  • SQL Server Management Studio
  • Word Perfect
  • MS Word
  • MS Access
  • MS excel
  • Unix
  • Dos
  • Cognos Impromptu
  • Crystal
  • Oracle Developer 2000

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

D atabase Architect

Responsibilities:

  • Perform current state data model assessments/target data models and gap analysis
  • Analyze legacy database, including both data content and structure to derive necessary information
  • Define and analyze data requirements needed to support business processes
  • Establish data modeling naming standards, abbreviations, guidelines and best practices
  • Develop and maintain conceptual, physical and logical data models
  • Drive the data model review process and solicit user’s feedback
  • Propose new database architecture, database technologies and support data migration from an existing Legacy system to a new structure
  • Run/execute Oracle19c and SQL Server 2019 on Google Cloud Platform.
  • Bulk data insert into Oracle19c and SQL Server 2019.
  • Run queries, inserts, updates and deletes on different databases (Oracle 19c, SQL Server 2019, Neo4j and MongoDB) to get performance statistics.

Confidential

Data SME/Engineer

Responsibilities:

  • Represent the Production Support organization on company-wide project teams.
  • Monitor process and software changes that impact production support, communicate project information to the production support staff and raise production support issues to the project team.
  • Prioritize workload, providing timely and accurate resolutions.
  • Perform production support activities which involve assignment of issues and issue analysis and resolution within the specified SLAs.
  • Provide daily support with resolution of escalated tickets and act as liaison to business and technical leads to ensure issues are resolved in timely manner.
  • Participate in knowledge transfer to ensure better grasp of the product and domain.
  • Suggest fixes to complex issues by doing a thorough analysis of root cause and impact of the defect.
  • Coordinate with Application Development Team to successfully deploy software releases in both User Acceptance Testing and Production environments.
  • Work as the front end support for any Oracle11g or SQL Server errors in Linux or Windows environments.

Confidential

Sr. Oracle DBA

Responsibilities:

  • Oracle 11g/12c Installation on Linux
  • Provide support for Oracle on Red Hat Linux, including installation, configuration, upgrading and patching of Oracle server software and related products.
  • Modified or create new SQL and PL/SQL function, procedure, trigger, and package using Oracle SQL*Plus, and SQL Developer.
  • Create Unix scripting to monitor and create con job.

Confidential

Sr. Oracle DBA

Responsibilities:

  • Provide production support to all the Latino America Databases.
  • Oracle Binary Installation (Database and Client)
  • Oracle Binary de-installation and space reclamation
  • Database software upgrades and patching
  • RAC Clusterware builds, upgrades and patching
  • Oracle on VMware clusters infrastructure - support, manage & maintain.
  • ASM storage management and configuration
  • ASM Space management
  • Binary Cloning & Patching
  • OEM Management and agent installation
  • RAC/VM node reboots
  • RAC/VM DB decommission
  • Backup and Recover configurations (RMAN)
  • Database /storage performance analysis (AWR)

Confidential

Sr. Oracle DBA

Responsibilities:

  • Provide support for Oracle RAC and single databases running on Sun Solaris and Linux. (Prod, QA, Dev and test databases).
  • Provide support to Oracle GoldenGate.
  • Work with the Oracle DBA team to Define/Recommend/Maintain database Standards and Architecture.
  • Research/Recommend Migration/ Upgradation, 3rd Party Vendor Support and Interaction (including TAR and OS.
  • Technical Consultation and Mentor L1 and L2 DBAs.
  • Installed GoldenGate software in Test instances
  • Experience in replication using golden gate v11.1
  • Replication and Extracting data and applying on production using GoldenGate.
  • Resolved replication issues in Goldengate

Confidential

Oracle DBA/Developer

Responsibilities:

  • Provide support for Oracle RAC on Red Hat Linux, including installation, configuration, upgrading and patching of Oracle server software and related products .
  • Perform backup and recovery using RMAN, Exp/Imp and Data Dump.
  • 10g, 11gR1, 11gR2 & 12c Installation on Linux and AIX
  • Use of OEM and Grid Control to monitor and support the databases.
  • Database creation using dbca
  • Monitoring, performance analysis and fine tuning of databases
  • Experience using AWR, ASH, ADDM and Explain Plan to help solving problems.
  • Listener, shared server, and database link configuration
  • Database schemas, users, privileges, basic Oracle data dictionary and view knowledge
  • Tablespace and table sizing, locally-managed tablespaces
  • Data migration using expdp/impdp and dbua
  • Add disk to ASM using ASMCMD utility.
  • Perform quarterly disaster recover exercise.
  • Upgrade Lawson Application.
  • Create unix/sql to monitor and refresh automatic the database.
  • Use unix shell script to purge log and trace files.
  • Modified or create new PL/SQL function, procedure, trigger, and package using Oracle SQL*Plus, Toad, and SQL Navigator.
  • Modified in home PL/SQL and Forms application base on business necessities.
  • Use of Clear Case to provides life cycle management and control of software development assets.
  • Ability to work on multiple projects and production support simultaneously.
  • Experience in developing and/or supporting 24/7 mission critical applications
  • Implemented Database cloning to disaster recovery database using physical standby database.
  • Successfully configured and implemented Physical Standby Database using Oracle DATAGUARD feature for High availability configuration and reporting.
  • Worked to secure database for SOX and PCI compliance by implementing roles, profiles and implementing Oracle’s best security practices.

Confidential

Oracle Developer

Responsibilities:

  • Enhance the Rx:Home features and functionality to meet payer requirements for billing Non Compounded Services as Compounded.
  • Modified or create new PL/SQL function, procedure, and package using Oracle SQL*Plus, and SQL Navigator in Oracle 10g.
  • Modify Oracle Forms & Reports version 6i.
  • Use of Clear Case to provides life cycle management and control of software development assets.

Hire Now