Oracle Application DBA Resume

Title
Oracle Application DBA

Primary Skills
Oracle 10g, 9i, 8i, 8, 7.x, SQL Server 7.0 and PostgreSQL.

Location
US-VA-Herndon (will consider relocating)

Posted
Sep-12-08


Summary of Experience:
• 15 years of extensive “Application Design”, “Application Development”, “Database Administration” and “Data Warehousing” experience.
• Worked as DBA (6+ Years), Team Leader (3+ Years) and Application Programmer (5+ Years).

Oracle Database Administrator
• Administered and installed Oracle 9i/8i production databases on Windows/Unix/Linux/Solaris.
• Capacity planning, tuning & performance enhancements.
• Centralized all database monitoring and reporting using an Oracle Enterprise Management Server
• Analyzed, designed, modeled, and implemented new database schemas.
• Scripted in PL/SQL and SQL to migrate and manage databases
• Strong experience in monitoring and maintaining production OLTP.
• Strong Oracle Database tuning skills.
• Strong SQL statement tuning skills.
• Online and Offline Backup and Recovery using RMAN and user managed methods
• Experience in Database Replication.
• Experience in using oracle partitioning.
• Experience in using oracle parallel Server (OPS).
• Experience in using standby database.
• After hours Production Support.
Oracle Developer
• Strong development skills in PL/SQL and SQL Plus.
• Experience in Oracle Forms and Reports.
• Experience in Oracle tools like “TOAD”, “SQL Navigator”, “Spotlight on Oracle” and “DBArtisan”.
OS Installation and administration
• Experience in Unix, Sun Solaris, Linux and Windows Operating Systems installation and Administration.
Data warehousing/Reporting
• Implemented Crystal Reports accessing Oracle Procedures
• Experience in using “Brio Query” for generating different kinds of statistical Reports.
• Knowledge of Erwin, OLAP Tools, ETL process and Star Schema design.
• Knowledge Business Objects 4.1.4.
• Knowledge of OLAP tools like Informatica.
Scripting and Others
• Experience in UNIX Shell Scripting, Perl Scripting.
• Development skills in C++.
• Knowledge of Java, web environments and Architectures.
• Quick learner, easily adaptable to new technologies, excellent problem solving skills.

Technical Skills:

Databases: Oracle 10g, 9i, 8i, 8, 7.x, SQL Server 7.0 and PostgreSQL.
Operating Systems: Sun Solaris, Linux, Windows, SCO UNIX.
Case Tools: Erwin, Sybase Power designer.
Programming Languages: C++, Visual Basic, PL/SQL, SQL Plus, Oracle Forms 4.5.
Oracle tools: Toad, SQL Navigator, Spotlight on Oracle, RMAN, DBSTUDIO.
Report Tools: Crystal Report, Business Object and Oracle Reports 3.0, Brio Query.
Version Control Clear Case/CVS, VSS
Other Skills MS Visual Interdev, JAVA 2.1, Java Servelets, Apache Webserver, JDBC, ASP, ActiveX and Visual Interdev 6.0, UNIX Shell Scripting, Perl Scripting

Education:
Post Graduate Degree in Computer Science and Application in 1992 from Regional Engineering College, Allahabad, India.




Work Experience:

Client: Secure-Elements, Inc, Herndon, VA, USA Oct 2004 to Current
(DBA)
Duration: Sep 2003 onward

Responsible for
• Capacity planning, tuning & performance enhancements.
• Client side application/DB installation and maintenance.
• Developing client DB interface methods.
• Developing ETL tools for extracting, transforming and loading data into a common repository.
• Creation and maintenance of schema objects.
• UNIX Shell Scripting.
• Perl Scripting.
• Database tuning.
• SQL statement tuning.
• Schema Migration.
• Data Migration.
• Monitoring 24x7 operational databases.
• Database Backups and Recovery using DB Export/Import.
• Monitoring Fragmentation, Row Chaining and High water marks.
• Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.
• Using oracle 8i/9i analytical function to optimize the large OLAP Queries used for generating Reports.
• Effectively using Hints to optimize the throughput and response time.
• Keeping a checklist and methodologies, which defines required deliverables at each stage?

Technical Expertise: Solaris 8, Linux, Oracle 10g, 9i, PL/SQL, SQL*Plus, PostgreSQL UNIX Shell Scripting.

Functional Detail: Secure Elements provides solutions that find, prioritize, and eliminate vulnerability and compliance risk exposures. C5 Enterprise Vulnerability Management suite automates IT security and patch management, and the Secure Elements' C5 Endpoint Access Control combines our policy and remediation capabilities with network access control from Cisco or Juniper. C5 Attack Predictor enables our customers to prioritize their most critical vulnerabilities for remediation, optimally harden their networks, and protect against potential exploits with a business focused approach.

Client: Sun Microsystems, Newark, CA, USA Feb 2003 to Aug 2003
(Software Engineer/DBA)
Responsible for
• Capacity planning, tuning & performance enhancements.
• Creation and maintenance of schema objects.
• UNIX Shell Scripting.
• Perl Scripting.
• Database tuning.
• SQL statement tuning.
• Schema Migration.
• Data Migration.
• Monitoring 24x7 operational databases.
• Database Backups and Recovery using DB Export/Import.
• Monitoring Fragmentation, Row Chaining and High water marks.
• Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.
• Using oracle 8i/9i analytical function to optimize the large OLAP Queries used for generating Reports.
• Effectively using Hints to optimize the throughput and response time.
• Keeping a checklist and methodologies, which defines required deliverables at each stage?

Technical Expertise: Solaris 8, Oracle 8i, 9i, PL/SQL, SQL*Plus, Unix Shell Scripting, Brio Query.

Functional Detail: Sun's "Point of Sale Data" Collection System (EMEA and APAC Countries) collect and store Point of Sale (PoS) information from Sun's channel partners for all the indirect sales achieved through Resellers. This system simplifies the collection of PoS information from various sources, and creates a centralized repository for the PoS data to be utilized for analysis, reporting and other future downstream applications. This also makes all the indirect revenue and end-user data available to downstream reporting systems. This system is utilized for better analysis and business intelligence by the management.

Projects:

Client: Secure-Elements, Inc VA, USA September 2003 to October 2004
(DBA)
Responsible for

Responsible for
• Capacity planning, tuning & performance enhancements.
• Client side application/DB installation and maintenance.
• Developing client DB interface methods.
• Developing ETL tools for extracting, transforming and loading data into a common repository.
• Creation and maintenance of schema objects.
• UNIX Shell Scripting.
• Perl Scripting.
• Database tuning.
• SQL statement tuning.
• Schema Migration.
• Data Migration.
• Monitoring 24x7 operational databases.
• Database Backups and Recovery using DB Export/Import.
• Monitoring Fragmentation, Row Chaining and High water marks.
• Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.
• Using oracle 8i/9i analytical function to optimize the large OLAP Queries used for generating Reports.
• Effectively using Hints to optimize the throughput and response time.
• Keeping a checklist and methodologies, which defines required deliverables at each stage?

Technical Expertise: Solaris 8, Linux, Oracle 10g, 9i, PL/SQL, SQL*Plus, PostgreSQL UNIX Shell Scripting.

Functional Detail: Secure Elements provides solutions that find, prioritize, and eliminate vulnerability and compliance risk exposures. C5 Enterprise Vulnerability Management suite automates IT security and patch management, and the Secure Elements' C5 Endpoint Access Control combines our policy and remediation capabilities with network access control from Cisco or Juniper. C5 Attack Predictor enables our customers to prioritize their most critical vulnerabilities for remediation, optimally harden their networks, and protect against potential exploits with a business focused approach.

Client: Sun Microsystems, Newark, CA, USA February 2003 to September 2003
(Software Engineer/DBA)
Responsible for
• Capacity planning, tuning & performance enhancements.
• Creation and maintenance of schema objects.
• UNIX Shell Scripting.
• Perl Scripting.
• Database tuning.
• SQL statement tuning.
• Schema Migration.
• Data Migration.
• Monitoring 24x7 operational databases.
• Database Backups and Recovery using DB Export/Import.
• Monitoring Fragmentation, Row Chaining and High water marks.
• Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.
• Using oracle 8i/9i analytical function to optimize the large OLAP Queries used for generating Reports.
• Effectively using Hints to optimize the throughput and response time.
• Keeping a checklist and methodologies, which defines required deliverables at each stage?

Technical Expertise: Solaris 8, Oracle 8i, 9i, PL/SQL, SQL*Plus, Unix Shell Scripting, Brio Query.

Functional Detail: Sun's "Point of Sale Data" Collection System (EMEA and APAC Countries) collect and store Point of Sale (PoS) information from Sun's channel partners for all the indirect sales achieved through Resellers. This system simplifies the collection of PoS information from various sources, and creates a centralized repository for the PoS data to be utilized for analysis, reporting and other future downstream applications. This also makes all the indirect revenue and end-user data available to downstream reporting systems. This system is utilized for better analysis and business intelligence by the management.


Client: Ntechra Systems Inc, San Jose, CA, USA December 2000 to Jan 2003
(Oracle DBA)
Responsible for
• Capacity planning and management.
• Creation and maintenance of schema objects.
• Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.
• Keeping a checklist and methodologies, which defines required deliverables at each stage?
• Hot and Cold Backups and Recovery/Disaster Recovery.
• Monitoring Exports and imports.
• Loading data into database using SQL*Loader.
• Work closely with and provide consultation to developers.
• Evaluate software that access RDBMS, such as front-end tools and Provide recommendations.
• Explore features of new RDBMS versions and make recommendations.
• Schema Migration.
• Data Migration.
• Using oracle 8i/9i analytical function to optimize the large OLAP Queries used for generating Reports.
• Effectively using Hints to optimize the throughput and response time.
• Monitoring Fragmentation, Row Chaining and High water marks.
• Planning and Implementing Materialized views, Snapshot Replication and Advanced Replication.
• Monitoring the 24x7 database-using Spotlights on Oracle.
• A developer / DBA of motivated involvement in Development, System test, Acceptance test, Production test for the new Projects.
• Testing and validating backup procedures on a simulated database to recover from different types of DB failures.

Technical Expertise: UNIX, Windows NT, Red hat Linux, Solaris 8, Oracle 8i, 9i, PL/SQL, SQL*Plus, Erwin 3.5.2, VSS.
Functional Detail: NtechRA's Asset Radar Systems provide "audit quality" inventory and analytics used by large enterprise network owners to save $ millions in hard cost outlays. Asset Radar automatically discovers what's where, what's on it and how it's changed over time. This gives the large enterprise network owner a 99%+ view of all networked attached assets including routers, switches, servers, PC's and printers, down to the card and firmware level.

Client: Vasona Health Care System, San Jose, CA USA June 2000 to December 2000
(Data Mart Designer)
Responsible for
• Capacity planning, tuning & performance enhancements.
• Designing and Developing Data Marts.
• Designing Schema Objects and Developing Extractor Program using C++.
• Designing Data Dictionary.
• Developing sample reports using Business Objects.
• Used UNIX, Windows NT, SQL Server 7.0, Oracle 8i, C++, Business Objects, SQL*Plus, PL/SQL.
•

Client: Maxis Research, Salt Lake City, UT, USA (Oracle DBA) Feb 2000 to May 2000

Responsible for
• Capacity planning, tuning & performance enhancements.
• Creation and Maintenance of Schema objects.
• Creation and maintenance of stored procedures and database triggers.
• Database tuning and SQL statement tuning.
• Loading Data into Data Warehouse from different sources, Cleaning, Filtering, making Data Marts.
• Developing Reports, Charts and Maps using Seagate Crystal Report.
• Responsible for Backup and Recovery.
• Used UNIX, Windows NT, Oracle 8, PL/SQL, SQL*Plus, Crystal Report 7.0.

Employer: National Informatics Center, Government of India (Scientist/Engineer 'SB')
February 1997 to February 2000
Responsible for
• Capacity planning, tuning & performance enhancements.
• Project Planning and Implementation.
• UNIX and Windows system Administration.
• Database design, development, implementation, client communication and testing.
• Designing and developing formats for data inputs and reports.
• Developing programs in SQL Plus and PL/SQL.
• Customer Support.
• Used UNIX, Windows, Oracle 8, 8i, PL/SQL, SQL Plus, HTML, Oracle Forms 4.5 and Reports 3.0 and Java Script.

Employer: Hindalco Industries Ltd, India (Application Programmer)
August 1992 to February 1997
Responsible for
• Database Installation and Configuration.
• Capacity planning, tuning & performance enhancements.
• Defining and Designing Coding Schemes.
• Unix system Administration
• Writing Programs in C++, SQL Plus and PL/SQL.
• Existing Code Review.
• Converting exiting module written in Fox Pro to C++.
• Used Windows, UNIX, Oracle, C++, Fox Pro, PL/SQL, SQL Plus, Oracle Forms and Reports.

Certifications
Oracle Developer
? Strong development skills in PL/SQL and SQL Plus.
? Experience in Oracle Forms and Reports.
? Experience in Oracle tools like ?TOAD?, ?SQL Navigator?, ?Spotlight on Oracle? and ?DBArtisan?.
OS Installation and administration
? Experience in Unix, Sun Solaris, Linux and Windows Operating Systems installation and Administration.
Data warehousing/Reporting
? Implemented Crystal Reports accessing Oracle Procedures
? Experience in using ?Brio Query? for generating different kinds of statistical Reports.
? Knowledge of Erwin, OLAP Tools, ETL process and Star Schema design.
? Knowledge Business Objects 4.1.4.
? Knowledge of OLAP tools like Informatica.
Scripting and Others
? Experience in UNIX Shell Scripting, Perl Scripting.
? Development skills in C++.
? Knowledge of Java, web environments and Architectures.
? Quick learner, easily adaptable to new technologies, excellent problem solving skills.



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

Resumes in Herndon, VA | Resumes in Virginia

View other Oracle Application DBA resumes, Database Administrator resumes