SUMMARY

• An Oracle DBA with over 7 years IT experience in Oracle ( 9i, 10g, 11g) data guard, installation, migration, designing, backup, recovery, scripting, performance tuning etc. spanning various industries like insurance, banking, wireless, financial etc. in variety of environments like UNIX, LINUX (Solaris, HP - UX, AIX), Windows NT 4.0/2000/2003 in production as well as development databases.
• Detail-focused professional with expertise in installation, configuration, design, upgrades, and maintenance of Oracle environments / databases on UNIX, and Windows servers as well as SQL Servers.
• Adept at diagnosing and resolving technical problems; record of providing 24/7/365 on-call support.
• Strong knowledge of data warehouse administration and database backup, restore, and disaster recovery procedures.
• Proven ability to create and publish packages/multidimensional models using Framework Manager from multiple data sources
• Proven ability to establish and administer Oracle Database Security environments; create, grant, and revoke users / permissions and manage schema.
• Proficient at monitoring databases, implementing performance enhancements, and debugging.
• Skilled at using system-generated logs to analyze code-related defects and troubleshoot configuration issues on database and application servers in all environments.
• Proficient at Framework Manager modeling, Report Studio, Query Studio, Analysis Studio, Active Report
• Played a key role in executing the Database Change Control Process (DBCC) on 35+ grant applications.
• Workedwith various groups such as Developers (50+), Architecture, Testing, Security, User Support, and Analysts.
• Project leader with excellent operations / administration skills.

TECHNICAL SKILLS

Oracle Utilities: OEM, SQL Developer, Oracle Designer, TOAD, Oracle Data Pump Imp/Exp, SQL Loader, DBCA, DBUA, Oracle Data Dictionary, database refresh / upgrade (10g to 11g)

Hardware: UNIX, Oracle, SQL Server, Framework Manager

Software: Rational ClearCase / ClearQuest configuration management software, JIRA project tracker, Cognos

Operating Systems: Windows 95/98/2000/NT/XP/Vista/Windows 7.

Other: Java, C++, PL/SQL, HTML, XML, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

Oracle DBA

Responsibilities:

• 24x7x365 production support for several mission critical systems which utilize multiple Oracle 10g, 11g databases.
• Installation, maintenance and tuning of Oracle databases
• Performed upgrades from Oracle 10.2.0.3 to 11.2.0.1 on Sun Solaris.
• Data Migration as part of enterprise data warehouse project.
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Data Modeling, Database Design and Creation with Logical and Physical s database layout.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts
• UNIX shell scripting in csh, ksh to be controlled from Crontab
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Daily Health Check Up of the Database using statspack, AWR, ADDM, TKPROF, explain plan.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures. Data Refresh in Test and Integration Databases using Transportable Table spaces
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases

Environment: Oracle 11g, Solaris 10, Oracle 10g, Toad, SQL Developer, PL/SQL, SQL*Loader, ODBC, ASM, OLTP, Flashback, OEM, Clear Quest, Clear Case, Jira, Cognos, Discoverer, MS office.

Confidential, TX

Oracle DBA

Responsibilities:

• Monitored and managed user accounts, created profiles and roles, backed up database, and tracked use of disk space, memory, connections, and schema objects (tables, views, indexes and materialized views) while maintaining referential integrity.
• Performed schema changes to facilitate development and migration initiatives
• Collaborated with such departments as Development, Architecture, Testing, Security, User Support, and Analysts to run QA / QC and plan for future applications.
• Optimized database performance by analyzing objects, generating statistics, creating indexes and views.
• Participated in testing and the development of performance standards.
• Implemented export and import
• Created stored procedures, functions, triggers
• Created Functional Diagram, Entity Relational diagram, Generating Server module, Generating Database scripts and Forms and Reports.
• Monitored disk space usage, memory, connections and the creation of schema objects (tables, views, indexes) and maintained referential integrity.
• Optimized database performance by analyzing objects, generating statistics, creating indexes and views.

Environment: Oracle 10g, Red hat Linux 5.X, Solaris 10, Toad, SQL Developer, PL/SQL, SQL*Loader, ODBC, DBCA, OLTP, Flashback, OEM, MS office.

Confidential, TX

Oracle Database Administrator

Responsibilities:

• Monitored and managed user accounts, the creation of profiles and roles, database backups, the use of disk space, memory and connections as well as schema objects (tables, views, indexes and materialized views) while maintaining referential integrity.
• Supported databases, troubleshoot user issues.
• Audited database to monitor suspicious activities.
• Performed schema changes in development instances and migrates changes to other environments.
• Provided regular updates to program management on the current and planned status of data and databases.
• Interacted with various groups such as Development, Architecture, Testing, Security, User Support, and Analysts to troubleshoot and plan for future applications which are part of the contract management cycle.
• Deployed code for DCIS in all environments (including Development, Test, UAT and Production) according to schedules and control and manage any changes in these environments.
• Analyzed code related defects using system generated logs, and troubleshoot configuration issues on database and application servers in all environments (including Development, Test, UAT and Production).
• Worked on testing of database, queries optimization and performance.

Environment: Oracle 9i, Red hat Linux 5.X, Solaris 10, Toad, SQL Developer, PL/SQL, SQL*Loader, ODBC, DBCA, OLTP, OEM, MS office.