DBA Cum Developer Resume Example Mazoon Electricity Company

DBA CUM DEVELOPER

Profile

Certified Database Administrator with 8+ years of experience in Database Administration, modeling, designing, programming, schema Design, SQL Optimization, Oracle, PL/SQL, SQL Plus, SQL Loader, coding Store Procedures, Triggers, Functions and Packages, Batch Processing, OLTP Systems. Extensive experience with database technology, data analysis, data architecture / data modeling, database design, quality reviews, hardware/software selection and installation, client/server, N-tier architecture and design, methodology development and administration, software configuration management, standards development.
Setup/configured Oracle RMAN for database backup and recovery. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure by using export/import & o/s scripts like shell scripts.
Hands on experience of database backups and Recovery strategies using RMAN, Export, Transportable Tablespaces.
Specific expertise in Upgrades, migrations, applying patches, Cloning/refreshes and Troubleshooting.
Extensive experience in SQL Developer and Toad as development tools and ERwin as a logical designing tool.
Proficient in technologies related to Reporting with Oracle Forms/reports (9i/10g).

Technical Skills

Skills	Experience	Total Years	Last Used
Oracle DBA	Advanced	9	1
SQL and PL/SQL	Advanced	5	1
SQL Loader, Import/Export dump	Advanced	7	2
RMAN Backup and Recovery	Advanced	5	1
Oracle Forms/Reports 9i/10g	Advanced	4	1
Oracle Application Server10g	Intermediate	3	1
Experience in database design, setup and patching	Advanced	5	2
Windows NT/2008 Server	Advanced	5	2
Toad for Oracle	Advanced	5	1

Professional Experience

DBA cum Developer, 04/2007 － 12/2013Mazoon Electricity Company

Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and tuning.
Monitor Alert Logs, Archive Logs, Trace files and to work proactive on alerts for the file system and CPU issues.
Tune SQL queries in Custom Applications to improve performance.
Cloned/refreshed Oracle Databases
Application of database patches.
Database backup and recovery using RMAN.Written RMAN scripts to perform automatic full and incremental backup. Tuned backup for performance by parallelizing channel allocation. Performed complete and incomplete recovery using RMAN.
Troubleshoot problems with web server, web listener, forms server concurrent managers, workflow and database.
Supported data cleanup activities after go-live, wrote bulk insert.
Upgrade database from Oracle 10g 32bit to 11gR2 Windows Server 2008 64bit.
Installed and Configured Oracle Application Server 10g.
Planned and designed physical & logical data models for electricity outages/shutdowns, system consist on multiple Oracle 10g forms and complex reports.
Maintained and developed in house system using Oracle Forms/Reports 10g with Oracle DB.
Experience with multi-tiered architectures, web-based applications, such as Oracle forms/reports
Reviewed, developed, and designed data models with application development team. Utilized ERwin to ensure logical data models were mapped efficiently into physical data models.

Software Engineer, 10/2004 － 04/2007Oman National Electric Company

Administer 2 medium sized OLTP database.
Installed Oracle products in production, test and development environments; migrated existing databases to new releases. I also wrote backup scripts (hot, cold and export) for the oracle Fail safe OS environment.
Provided problem diagnosis and resolution, monitored database backups; performed database restores and recoveries as well as table reorganizations
Monitored and tuned production environment when volume of data impact performance utilizing OEM SQL Analyze, OEM Performance Manager, STATPACK, SQL Trace, TKPROF, etc
Coded PL/SQL programs using Oracle Designers application programming interface.
Monitor Physical standby database.
Develop routine forms and reports using Oracle Developer 6i.
Implement Oracle Data Guard and created Physical Standby database for fail over/switchover using RMAN.
Performed Database Backup including Physical backup through Hot/Cold Backup of Oracle Database on Raw Devices such as tape.
Set up Oracle Enterprise Manager (OEM) (Grid Control) 10g for database for diagnosing & monitoring performance related problems and configured with Application servers on test databases
Add/update forms and reports with in in-house Oracle Forms/reports based system
Data migrations between databases using Oracle SQL Loader, IMPORT and EXPORT utilities.

Education

2003BSComputer Engineering

Certifications

Oracle Certified Database Administrator (OCP DBA)

Accomplishments

Implemented Oracle DataGuard and Created Physical Standby database for failover/switchover using RMAN.
Developed Electricity Grid Control Center system using Oracle Forms/Reports 10g Java runtime and web app with Oracle as DB, this system provides storage and manipulation of electricity load, system outages, upgrading/maintenance of network, provide several types of reports.
Install and Configure Oracle Application Server10g as middle tier.
Upgrade Database from 10g Win 32bit to 11g 64bit

Legal Status

Green card/Legal Permanent Resident (LPR)

Resume Overview

Companies Worked For:

Job Titles Held:

Degrees