SUMMARY

• 14 years DBA experience in Oracle RDBMS 11g/10g/9i/8i/8/7OLTP, DSS:
• High performance analysis and tuning: DB design, development, production, application
• Systematic and proactive database monitoring and maintenance across various platforms
• Installation, configuration, migration/upgrade, patching of databases and applications on multiple platforms in distributed environment
• Object management for performance and data processing functionalities
• Data conversion, migration, and integration and ETL.
• Logical/Physical database modeling to meet business and performance requirements
• DB layout, sizing, capacity planning, and resource management for small and large environments
• Backup and recovery for various scenarios and environments RMAN and hot backup script .
• HA management: Streams, Replication , standby/Data Guard, Goldengate,cluster/RAC
• Database security measurement and control conventional and advanced
• 3 years experience in MS SQL Server and 2 years in MYSQL and DB2.
• System validation and performance qualification for application/database software. Change control.
• Proficient O/S administration: Sun Solaris,Liunx,AIX and MS Windows NT/2000
• Strong skills: analytical and problem-solving customer management experience communication and team management organization, documentation
• Technical Skills
• O/S: Unix Sun Solaris, AIX, HP-UX, SGI IRIX, VMS , Linux 6x/7x/8x/9x/AS Redhat , SUSIE 8/9/10, Oracle Linux exadata
• Database: Oracle 11g/10g/9i/8i/8/7, MS SQL Server 6.5/7/2000, MYSQL,DB2 10
• DB Tools: OEM 12c cloud control, Grid Control,SQL Loader, Golden Gate, AWR/ASH/ADDM, Ignite,Sqlt,Export/Import, Data Pump, Solarwind, Quest Software Toad, Spotlight, Sql Navigator, Sql Lab , DB Artisan, SQL Server Enterprise Manager, Query Analyzer
• Modeling Tools: ERwin 3x/4x, Oracle Designer 2000/6i, Tableu
• ETL Tools: Oracle Warehouse Builder 9i
• Programming Scripting Languages: PL/SQL, SQL, Shell,JAVA, HTML
• Mining and Report Tools: Oracle Discoverer, Oracle Express, Crystal Report,Brio

Experience

Confidenital

Senior Database administrator

• Provide 7x24 production support for 20 databases of online broker trading and wealth management to meet 99 uptime SLAs.
• Monitor DB performance proactively by reviewing AWR/ASH/ADDM,OSwatcher, ignite,Solarwinds/Zabbix reports periodically.
• Install Oracle 11G Enterprise edition on AIX servers and upgrade 10G production Databases.
• Coordinate oracle to deploy exadata POC on 11G and migrate production DB to exadata X3.
• Create and configure exadata 4-node production DB and set up daily maintenance jobs.
• Tune applications on new exadata environment and develop best practice guide.
• Set up dataguard and conduct scheduled switchover test periodically.
• Resolved various compatibility DB issues after 11G upgrade.
• Finalize production database SOPs and compose oracle/db2 database runbooks.
• Work with analysts and developers to design/implement new financial applications.
• Configure OEM 12c server and agent and set up metric thresholds for AWR baselines.
• Unload oracle to DB2 10.5 and compare performance metrics.
• Create and configure DB2 DBs and investigate performance issues.
• Configure GoldenGate replication and support datastore applications.
• Review and tune the application codes on QA/pre-prod stage.
• Troubleshoot performance issues and resolve them in timely manner.
• Establish standard procedure documents and train junior offshore DBAs.

Database administrator

Confidenital

• Provided direct full support for 15 production databases and 32 dev/staging databases ranging in size 5G to 4TB on various platform including Sun Solaris, Linux, AIX.
• Maintained data warehouse DB for its performance, backup, storage and partitions.
• Implemented physical data guard as HA solution for critical databases.
• Set up stream replications among source DB and application web DBs.
• Initiated 11G DB project to evaluate its features such as performance analyzer and auto tuning.
• Troubleshot database errors by applying workaround and patches.
• Restored and recovered DB when file is corrupted or user errors.
• Coordinated developers to create procedures and optimize application queries.
• Developed shell script for monitoring database storage and potential performance issues.
• Managed user system and object privileges and track sessions by auditing processes.

Database administrator

Confidenital

• Upgraded Oracle 9i to 10G RAC on Linux using automated storage management.
• Diagnosed and tuned the offending processes by monitoring OS and Oracle statistics.
• Configured Oracle heterogeneous services to establish connections between oracle and Mysql, Sql server databases.
• Managed SQL server DB and supported its data loading processes.
• Set up and maintain Oracle data guard with physical standby database.
• Installed and deploy Oracle 10G grid control for centralized management.
• Implemented data model using Erwin for new clients for their customized needs.
• Developed PL/SQL packages and shell scripts for various database tasks.
• Provided technical support to clients and development teams for database issues.
• Developed and optimized applications in VSS form by initiating benchmark tests.
• Maintained Oracle 9i RAC database objects including tablespaces, tables, triggers, store procedures and indexes.
• Provided oracle training sessions and instructional guide for end users, developers.
• Monitored and addressed any reported performance issues by using statspack and AWR.
• Loaded third-party data sources area code, sales tax, check cleared etc to oracle.
• Configured RMAN backups for all four production DBs and validate restore/recover periodically.
• Constructed material views of various parameters for weekly and monthly crystal reports.
• Created templates and work instructions for database installation qualification and operation.

Database DBA/Developer

Confidenital

• Developed and maintain ETL process from streaming logs by using PL/SQL store procedures.
• Wrote PL/SQL package to track usage from different media sources.
• Initiated project to test applications on 10G database on QA environment.
• Created multi-level backup and recovery strategy according to business requirements and application characteristics.
• Created templates and work instructions for database installation and operation
• qualification, change control, and other SOP based guidelines.

DBA/Unix SA

Confidenital

• Designed and build multimaster replication environment for production database.
• Migrated 8.0.5 production database to 8.1.7 Oracle parallel Sever and modified all related applications.
• Maintained Oracle servers by managing their space, security and performance.
• Provided support to application developers in designing and implementing physical database structures.
• Contacted clients and vendors for oracle specific issues.
• Installed Veritas VM and configured volumes for oracle parallel server.
• Assured 7x24 availability of production database and keep maintenance downtime to minimum.
• Created Mysql database and set up replication in cluster environment as backup.
• Developed Mysql loading procedure and handled performance and connection issues.
• Consolidated and integrated heterogeneous servers to SAN infrastructure.
• Worked with Sun consultant to get cluster environment Sun certified.
• Implemented DNS server modification procedures for R D, QA and production groups.
• Configured and implement application server for 3-tier production environment.
• Monitored and troubleshot performance bottleneck for application servers.