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.