SUMMARY

Creative Information Systems professional with extensive personal and professional experience in Database Management/support both in production and non - production environment, QA/Product testing, Software application Support/Design, Product Development Life Cycle ( SDLC ), Data management/Analysis. Proven experience/working knowledge in using Database tools as well as overall general and up to date knowledge of Information Technology.

DBA HANDS ON EXPERIENCE AND SKILLS:

• Oracle 10g, 11g, 12C, mysql,SQL Databases (2008 - 16) Performance Tuning & Capacity Monitoring
• Data Security, DR, Backup & Recovery Data Guard Replication (Physical and Logical) Goldengate replication SQL Server Data Tools (SSRS, SSIS, SSRT)
• Knowledge of AWS (ON-PREMISES Management/migration) Erwin Modelmart, ETL, Jira
• MS Office suite, Advance excel (Pivot tables, Dashboards) Oracle RAC & ASM Admin. / Installation
• Programming (C/C++, Python) SQL creation and tuning, Data Analysis
• Unix, Linux, Windows Operating System PLSQL and Shell scripting
• Experience in both Waterfall/Agile project management

PROFESSIONAL EXPERIENCE:

Confidential, Woodland Hills, CA

Application support/Associate Instructor

Responsibilities:

• Was hired on a Part time/contract basis to help in implementation/Setup training labs and general student support, as well as general it/database support on an on-call basis.
• Manges/setup students lab as well as assists and trained students in using project management software (Jira), Database query and usage, excel spreadsheet for basic data analysis.
• Manage routine day-to-day Database administration/maintenance that includes such activities as (database performance tuning, patching, troubleshooting, upgrades, backup/recovery, and testing).

Confidential, Woodland Hills, CA

Database Administrator

Responsibilities:

• Performed operational DBA tasks/duties in our large-scale/heterogeneous environments with such tasks as performance tuning, patching, cloning, replication, upgrades, backup/recovery, testing, migration, routine maintenance/support.
• Assisted in defining system configuration requirements, backup, monitoring strategies and developed SDS department standard operating Procedure (SOP)/overall database management processes.
• Managed routine day-to-day Database administration work deployments in assigned Non-production and Production Databases.
• Installation, configuration and administration of assigned Oracle RAC 11G/12c Databases in Oracle Enterprise Linux.
• Installation, configuration and administration of assigned SQL Databases (Cluster/non-cluster) in both Window/Linux platform.
• Performed all aspects of Performance monitoring/analysis, optimization and sql tuning as well as storage capacity planning /analysis with scheduled reports to management.
• Coordinated SQL Server Upgrade project from SQL ser 2008 2014, as well as creating/monitoring SQL server agent jobs and troubleshooting as required.
• Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12C software.
• Configured GoldenGate Downstream Mining and integrated components for Active-passive and Active-Active replication.
• Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.
• Installed and configured GoldenGate JAgent to work with OEM GoldenGate plugin.
• Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP
• Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
• Occasionally acted as interim PM/Scrum-master on any database internal project that were not under the auspice of PMO.
• Performed all shared data service department capacity planning (to asses, analyze, trends, forecast, reports) to meet customer SLA/requirements.
• Led and planned all aspects of disaster recovery for all databases and acted as the main liaison between DBA team and disaster recovery team in all disaster recovery activities.
• Worked with change management team, Configuration management, incident management team regarding database issues in all incident levels.
• Was the main liaison between business unit and database department and assisted/analyzed requirements that will used in designing new required databases system.
• Use OEM and other third-party tools to monitor database activity as well as analyze instances to identify potential performance bottlenecks.
• Provided all database support as well as coordinate with developers, application team and business stake holders during the development of new and implementation of a new project.
• Worked with both in-house developers, offshore team, vendors to troubleshoot/analyze database issues, code reviews and offered recommendations as needed.

Confidential, Calabasas, CA

Lead QA / Database Analyst

Responsibilities:

• Developed/designed/Analyzed Test plan, Test requirements, Traceability matrix, Test cases/scenarios. Participated in functional and design specification reviews to resolve software functionality and testing issue.
• Wrote Automation Test Scripts/Unix Shell for Smartbits project. Made recommendations regarding the purchase of all 3 rd party software application/automation tools.
• Coordinated/performed all aspect functional, integration, regression, performance, and complete system test. Data Analysis, Generated/delivered test reports and ensured compliance of tested systems to engineering specifications.
• Participated and offered inputs on various weekly review meetings such as, functional/design specification review, Systems definitions, bug reviews, test progress status, release version control as related to Smartwindow GUI Project.
• Managed bugs/defect database, access control, as well as created custom reports using PL/SQL. Wrote/Modified Standard Operating Procedure Documents (SOP).
• Functioned and Led in the planning, estimation, creation and execution of test strategy, test plan, test scripts, and test data.
• Installed, Queried, Recorded/programmed test scripts and maintained test scripts database, and ensured that issues and defects were managed and resolved.