Resume of Oracle DBA

Title
Oracle DBA

Primary Skills
ORACLE DATABASE ADMIN

Location
US-DC-Washington (will consider relocating)

Posted
Sep-30-07

PROFESSIONAL SUMMARY

• 10 Years of total IT experience in Software Systems Design & Development, responsible for developing customized business applications, database design, database administration, Leading Projects and building large public domain databases.
• 7+ years as Oracle Database Administrator (Proficient in Oracle Database Administration Activities).
• Installation, configuration, creation, upgrades Oracle environments (8i/9i/10g) using OS via. Sun Solaris, SCO-Unix and Windows XP/NT servers.
• Experience with database backup, restore, and disaster recovery procedures.
• Backup and recovery procedures using RMAN.
• Hands on experience of database backups and Recovery strategies using RMAN, Export, and Transportable Tablespace, Recovery disaster recovery and Tivoli Storage Manager (TSM) for monitoring and backing up the Oracle databases.
• Oracle Data guard and Standby databases experience
• Hands on experience of Oracle Real Application Clusters (RAC)/parallel servers on SUN E10K.
• Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator; handle business service requests using Helpdesk Service Management/Call centre.
• Managing team, achieve team and individual targets, addressing any issues of concern regarding performance of team members, monitoring performance, coach, counsel and develop people competencies with in the team etc.
• Experience in all facets of the systems development lifecycle, from requirement development, architecture design, testing, and post implementation revisions.
• Strong Knowledge on 10g release and top 20 features.
• Strong in data (system) analysis, DBA support of phases of Software Life Cycle (design & development, implementation) in large-scale multi-user (systems) environments.
• Strong in knowledge of oracle data-dictionary, configuration of Oracle Enterprise Manager (OEM) tools for monitoring, performance enhancement and debugging
• Involved in replication setup, configuration and maintenance of replication process.
• Building ad-hoc queries/ complex SQL queries Report development,
• 5-yrs troubleshoot/monitor script, creation of log files, packages & script, develop scripts for SQL*Loader, Export, Import, PL/SQL,
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• Monitoring and optimizing the Performance of the database, turning Management, Change Management, capacity planning, create new technologies and SQL tuning.
• Working experience with Very-Large databases (VLDB) up to 1 terabytes, data migration, against Oracle & other databases such as MS Access, SQL Server.
• 3 years of software development experience using Developer-2000 (Forms, Reports), FoxPro & 'C++'.
• Practical solutions to problem solving with creative ideas, identify patterns, linkages and underlying situations, consider customer needs in evaluation of solution.
• True team player; maintain client/customer relationships by providing timely, superior quality products and services; understanding of client/customer needs, opportunities and satisfaction criteria.


AREAS OF EXPERTISE
Databases: Oracle10g/9i/8i, SQL SERVER
Languages: C/C++, VC++, J2EE, Perl, Shell Script, SQL, PL/SQL, UML, HTML, XML
Operating Systems: UNIX (Sun Solaris) / Red Hat Linux
Windows 2003/2000 Server/ XP /NT 4.0
Tools: OEM, SQL*Plus, SQL*Loader, RMAN, Toad, Quest tools, LogMiner, PL/SQL Developer, Statspack, TKPROF, PUTTY, JDBC, ODBC, VI editor. Bash/ksh/csh, Erwin, Rational Rose, MS Project
Protocol: TCP/IP, SFTP, TELNET, HTTP, SSL, SSH

EXPERIENCE
PBGC- Federal Corporation, DC 03/2007-Present
Senior Oracle DBA, Consultant
Pension Benefit Guaranty Corporation is a federal corporation. It currently protects the pensions of nearly 44 million American workers and retirees defined benefit pension plans. As member of production DBA team, I support over 2TB production Database, over 10TB database in test and developer environment.
10g migration project
Migrate 50 databases in dev, test, and production environments.
• Plan and implement Oracle software installations, upgrades, and patches.
• Plan and build database instances and objects.
• Plan, implement, and troubleshooting Oracle RMAN backup, restore, and recovery.
• Monitor and tune Oracle database for optimum performance. Assist in capacity planning of Oracle database servers.
• Monitor, rebuild, and troubleshoot standby databases in coop server.
• Troubleshoot Oracle infrastructure problems.
• Provide technical assistance and guidance to application support staff and project teams.
• Develop, document, and implement operational support procedures for the Oracle infrastructure components.
• Develop, document, and implement security configuration for Oracle software and database instances to comply with existing standards.
• Refresh development/test databases from copies of production.
• Responsible for 24x7 on-call support and morning DBA.
• Maintain Development(CDE), QA(ITC), and Production environment and apply patches/fixes
• Implement coop test to switch any standby database to the production role, for minimizing the downtime associated with the outage, and preventing any data loss.
• Add new nodes to RAC 10g Cluster to distribute the load
• Modified and finalized the migration guide.
• Database tuning: Optimize database performance by analyzing objects, generating statistics, creating indexes and views
Environment: Oracle Server 10G/9i/8i, OEM (Oracle Enterprise Manager) , SQL*Plus, PL/SQL, Sun Solaris5.8, Linux Red Hat, Windows2000/XP

ChoiceOne BANK, Lansing, MI 12/2005-3/2007
Senior Oracle DBA, Consultant
AS one of the largest local commercial bank, ChoiceOne Bank has over1 TB data spreading across Oracle, DB2, and SQL Server databases on Solaris, Linux, and WinXP server. ChoiceOne Bank has about 53 Oracle production databases with some of the DSS database sizes up to 200GB and OLTP database sizes up to 50GB, And many oracle development and test databases.

At Financial Evaluation office in Lansing, Michigan, Enterprise databases are supported by a DBA team. Databases are grouped based on the applications they support. DBAs are assigned to support specific group of databases, but must support all databases during On-Call, Recovery and other special occasions. DBAs are responsible for supporting the production and development environments, maintained 2 Oracle Instances on Sun SPARC with Solaris Cluster Environment.

Environment: Oracle Server 10G/9i, OEM (Oracle Enterprise Manager) , SQL*Plus, PL/SQL, Sun Solaris5.9, Linux Red Hat, Windows2000/XP

• Setup and supported for Oracle 9i/10g HA solutions including RAC, Standby servers, Data Guard.
• Installed and configured of Oracle 10g/9i RAC(Real Application Clusters) on Sun Solaris 5.9-64bit
• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager), Statspack, and V$ dynamic views.
• Setup, Configured Oracle Data Guard using physical standby database
• Implement log miner, Dataguard / Standby both physical and logical standby (with FAL), perform switchover/failover and monitor using Data Guard manager command line and GUI in POC project.
• Created, maintained, and monitored the Standby Database (contingency site).
• Provided Oracle version 9.2.0.4 Replication Support for Development of new security software. Analyzed replication environment, provided replication support fixes: Implemented Replication Conflict Resolution; Provided Replication troubleshooting and solutions for various Replication issues; Provided Oracle Patch installation. Developed Oracle Replication Troubleshooting Guide.
• Performed Large Terabyte size Database Backup including Physical backup through Hot Backup/Cold Backup of Oracle Database on Raw Devices using compress and Logical backup using multiple streams Export / Import on Unix - Solaris5.8-64bit
• Designed and developed scripts to monitor instances locks, long running queries, listener, free space, extents growth, etc
• Meet the SLA on each database by maintaining high availability / uptime
• Involve in the Capacity Planning for databases based the future business growth requirements
• Provide On-Call support to production Databases on rotation basis.
• Designed and developed Daily Schema Change Monitoring program across all Databases

Database Size: over 1TB

Health Highway Inc. CA 05/2004-12/2005
Oracle DBA, Consultant

As Oracle core DBA, Provided day-to-day clinical data management and analysis support to clinical research user community, response for designing, scheduling, and monitoring backup plan of entire databases of enterprise, and Managed import and export data for Dev and QA team

Provided dynamic supports to development team of Patient Registration System (PR) developed using J2EE technology. Supports included, but not limited to Oracle clinical support, database design (Oracle designer), database development, import/export, data migration, backup, recovery, and SQL query performance tuning
Environment: Sun Solaris, Linux, HP-UX, Oracle 9.0,

• Plan, Implement and test disaster recovery system, using RMAN/UNIX shell scripts.
• Design and implement of database backup strategy and performed full incremental and Cumulative backup using RMAN.
• Troubleshooting with RMAN backup problem.
• Written PERL, Shell, Expect scripts to automate daily processes like archive log, data file, tablespaces, control files backup.
• Restructured production databases and Improved performance by 35 %, considered the requirements of Business, databases and applications, and resource utilization.
• Optimization and fine-tuning the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes
• Designed and developed Unix shell scripts using Awk, Sed, Tr, etc to automate wide range of tasks including administration, backup, monitor, troubleshoot database issues, execute background and batch process round the clock
• Provide 24/7 monitoring of network and database operations to ensure top operating efficiency
Database Size: 20GB to 200GB

Nidi Associates of Toronto 01/2003-3/2004
Oracle DBA
Wizard IT Services has a wide range of expert system managers, developers and consultants, and is recognized for their skills in the following areas: Integrated Oracle databases, E-Commerce Solutions, Dedicated Internet Connections, Custom Programming, Custom Firewall design.

Environment: Sun Solaris, Red Hat Linux and Windows 2000/XP, Oracle 8i, Oracle 9i

• Provide database administration on production, testing and development database servers.
• Estimate Storage requirement, Creation of Tablespaces and other Database Primary Objects.
• Prepare backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.
• Setting up SharePlex log-based replication to meet the high availability and load balancing needs.
• Perform tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc.
• Clone/Refresh of Production databases to Testing and training environments.
• Develop/customize UNIX shell scripts to automate routine DBA tasks of taking backups, exports and monitoring space availability and database performance database. Developed Standards for the developers.
• Creation of database objects like tables, indexes, stored procedures, snapshots and views etc.
• Creation of users and roles and maintaining system security.
• Monitor and Tuning of Database Performance by using various optimization techniques.
• Interacted with Oracle Support for resolving various critical database issues
Database Sizes: 50-100GB


COMMbits, Toronto Canada 10/2002-12/2003
Oracle DBA

Environment: HP UX, Linux, Windows XP, Oracle 9i

• Performed day-to-day DBA jobs for managing 15+ Prod/Dev databases.
• Configured Oracle Management Sever (OMS) for enterprise-wide database event monitoring, change management and performance tuning.
• Created a self-tuning procedure for adjusting SGA memory components based on application processing needs.
• Applied a patch to a Linux box in order to solve the Oracle Intelligent agent crash problem.
• Tuned parameters for a large monthly SQL* Loader job resulting in 90% reduction of operation time.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, Optimizer Hints and TKPROF utility.

Database Sizes: 30-200GB

Wizard IT Services, British Columbia, Canada 10/2001-09/2002
Oracle DBA
Environment: Sun Solaris, HP UX, Oracle 8i, Linux, SQL Plus

• Under the direction of a Sr. Oracle DBA, assist in supporting Oracle databases and applications.
• Installing and upgrading Oracle on Sun Solaris platform
• Maintaining and monitoring multiple Oracle database instances in production, development, and test environments
• Participate in testing and the development of performance standards
• Performs and/or verifies database backups and recovery procedures using RMAN.
• Perform SQL queries using SQL Worksheet and SQL Plus, Data researched and analysis
• Administer an Oracle database and its users using Oracle Enterprise Manager and DBA Studio


Database Sizes: 1 GB to 30 GB

CGC INC 04/2000-07/2001
Oracle DBA
• Oracle Databases installation, creating and Managing instances, schemas, users, profiles.
• Performance monitoring, tuning, storage management, capacity planning, Backup and recovery
• Monitoring, Tuning the performance of the databases
• Coding, testing and Tuning SQL and PL/SQL stored procedures, functions, Packages and triggers.
• Coordinating with Developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, security, backup & Recovery, SQLs coding guide lines etc
• Tuning SQLs using explain plan, SQL Trace, Statspack, TKProf etc.
• Migrating Oracle Databases from 8i to 9i and 10G
• Writing Unix Scripts to automate jobs.
• Installing and configuring Oracle databases including RAC.

Environment : Oracle 8i,Toad, SQL Plus, Java, Informatica HP Unix.


EDUCATION

BS in Computer Science Beijing University
Master of Computer Science University of Illinois
MCDBA

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-DC-Washington »
View all resumes in US-DC »

View other Oracle DBA resumes, Database Administrator resumes